Manikantha M

About Manikantha M

Experienced SQL & SSIS Developer with 3 years and 7 months of expertise in database development and ETL processes. Proficient in the Microsoft BI (MSBI) stack, specializing in SSIS and SSRS for over 2 years. Skilled in crafting both simple and complex SQL queries, utilizing joins, subqueries, derived tables, and stored procedures, including User Defined Functions (UDFs). Adept at creating and maintaining database objects, such as indexes, views, synonyms, triggers, and constraints.Experienced in optimizing query performance, utilizing ranking functions, aggregate functions, and string functions. Proficient in using SQL Profiler for query tracing and creating automation jobs with SQL Server Agent. Well-versed in performance tuning and query optimization at various levels. Demonstrated capability in creating and modifying SSIS packages and SSRS reports, including expertise in using containers like for each loop and sequence containers.Experienced in managing control flow tasks, such as Execute SQL Task, Dataflow Task, Execute Process Task, Bulk Insert Task, File System Task, FTP, and Send Mail Task. Expertise in data flow task components like conditional split, Derived Column, OLEDB command, Sort, Multicast, and Data Conversions. Skilled in Union All, Merge, and Merge Join operations. Proficient in error handling using event handlers and loggings within SSIS.Specialized in initial data loading using Bulk Insert Task and Bulk Copy Program, as well as incremental data loading techniques like Slowly Changing Dimensions (SCD) and Change Data Capture (CDC). Proficient in developing Table and Matrix reports, performing groupings, and creating expressions in reports. Experienced in configuring and deploying SSRS reports, including various report types such as simple, complex, parameterized, drill-down, and drill-through reports.

Experience

1. Engineering Lead

   Persistent Systems

   Nov 2023 — Present · Pune, IN

Education

• Dravidian University, Kuppam, Chittoor District

  Bachelor of Applied Science - BASc

  2011 — 2014