• Extensive 9+ years of experience in Data Analysis, Data Integration, Database development, Reporting & customization.
• Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, and Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing & post-implementation support.
• Extensive experience in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System & User-defined Variables for SSIS Packages.
• Adept at analyzing, planning, implementing, managing large databases, writing complex T-SQL code, and creating functions and triggers to enhance data manipulation and data consistency.
• Experience in the design of tabular cubes for data analysis using SSAS. Strong knowledge of Data Warehouse concepts and technologies such as dimensional modeling, Star and Snowflake Schemas, reporting tools etc.
• Highly knowledgeable in Designing, Developing & deploying various kinds of reports using SSRS to visualize relational data. Having expertise in the design of reports and dashboards using PowerBI and Create Measures in Power BI based on the requirement using DAX.
• Extensive experience in creating Data orchestration with Azure Data Factory Pipelines & Dataflows and Azure Logic Apps.
• Adeptness across ETL, performance tuning, query optimization, database consistency and security, and ensuring rigorous data integrity.
• Experience in Visual Studio Team Foundation Server, SVN, GIT.