Anuhya Kanumuri Email & Phone Number

• 6 years of professional IT experience in design, development, implementation, maintenance in MS SQL Server 2019/2016/2014/2012/2008R2.• Extensive experience with different phases of Software Development Life Cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation, and Loading using SSIS from Heterogeneous databases such as Oracle, DB2, Sybase, and MS Access and designed data conversions from a wide variety of source systems. • Experience in Dimensional modeling using Star Schema/Snowflake modeling concepts and Kimball/Inmon strategies. Experience with Physical & logical data modeling using All-Fusion Erwin Data Modeler.• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.• Experience in Error Handling by using event handlers and also provide custom logging for SSIS packages.• Experience in handling Heterogeneous Data Sources and databases Oracle, TERADATA, IBM DB2, and CSV and XML files using SSIS.• Experienced in creating multiple kinds of reports in Power BI and Tableau and present them using Story Points. Developed BI solutions using Power Query.• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split, and Fuzzy Lookup.• Excellent T-SQL programming skills. Expert in writing complex queries, stored procedures, Triggers, Functions using T-SQL.• Expertise in using Team Foundation Server (TFS), Tortoise SVN, GIT, and Visual Source Safe (VSS) as a tool for a repository of codes and version control, branching and merging into production.