About
• Strong experience in using Microsoft Suite–SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL and Server Reporting Service (SSRS), with a focus on building automated ETL processes, creating interactive dashboards, and delivering actionable insights. Experience in implementing end to end BI Solutions using MSBI Stack.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star schema and Snowflake schema. in data integration, report generation, and business intelligence tools.
• Experienced working in an Agile environment with SCRUM development framework. Complete understanding of Software Development Life Cycle (SDLC) including requirement analysis, requirement gathering, design, development, implementation, testing, and deployment experience.
• Goal-oriented, detail-oriented, well-organized, hard-working, highly motivated, effective team player with excellent analytical, troubleshooting, and problem-solving skills to enhance efficiency and productivity in a corporate environment.
Looking for Full-TimePortfolio
US Stroke Mortality in Adults Over 35
This project focuses on analyzing stroke mortality rates among adults over 35 in the United States, ... ... More
Employment History
-
ETL Developer
Colaberry Inc
September 2023 - Present
• Created SSIS packages using various control flow and dataflow tasks to extract the data from multiple sources like Excel, XML, JSON and OLTP and consolidate them into staging tables.
• Maintained SSIS packages for production and test environment for incoming source application files.
• Implemented different Slowly Changing Dimension methodologies and Merge Statements to maintain and update data corresponding to Dimension tables in the Data warehouse.
• Monitored SSIS packages validation, errors handling, optimization, and deployment.
• Designed, implemented, and maintained Database Schemas, Entity relationship diagrams, Data modeling, Tables, Store procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, and complex SQL statements.
• SQL Query Optimization and Performance Tuning, Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created parameterized reports, drill down, and drill through reports using SSRS.
• Held accountable for creating dashboards, Tabular, Matrix reports, Charts and graphs as per customer requirement using SSRS.
• Identified and fixed issues related to data accuracy, T-SQL code, and SSIS/SSRS errors when needed.
• Worked with Business Analysts and Developers to define, document, and maintain customer reports and dashboards, ensuring updates as required.
• Collaborated with the project team throughout the project lifecycle, helping with business analysis, design, development, testing, and documentation based on user needs.