Over 7 years of Information Technology experience in all phases of Software development life cycle including Database administration, ETL, Data Analysis and Business Intelligence.
Meet with customer business and technical leaders to identify and scope the business opportunities.
Interacted with Business Users for gathering the Reports/Dashboards requirements.
Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services and MS SQL Server Reporting Services (SSRS).
Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T-SQL.
Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, Data Vault Modeling, Snow-Flake Modeling, FACT and Dimensions.
Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and agile methodology.
Strong experience in design and developing ETL using SQL Server Integration Services (SSIS).
Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Fuzzy Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, for transferred data modifications and dataflow tasks, script tasks, for loop container, for each loop, sequence container and Slowly Changing Dimension.
Design and implement end-to-end data solution (storage, integration, processing, and visualization) in Microsoft Azure.
Azure Data Factory (ADF), Integration Run Time (IR), File System Ingestion, Relational Data Ingestion.
Experience in Installing, Managing, Monitoring and Troubleshooting SQL Server.
Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services.
Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients and Power BI for executives and managers.
Experienced in supporting 24/7 production computing environments, on-call, and weekend support