• Extensive experience in designing ETL/ELT processes to load dimension and fact tables using SQL server, Oracle, Netezza and Postgre SQL databases.• Implemented advanced SSIS concepts to handle complex tasks like importing large files, loading data in a transactional database etc.• Processing the data into the data warehouse using slowly changing dimensions type1, type2 and type3 models.• Leading Key meetings including status meetings, and other meetings during the implementation… Show more • Extensive experience in designing ETL/ELT processes to load dimension and fact tables using SQL server, Oracle, Netezza and Postgre SQL databases.• Implemented advanced SSIS concepts to handle complex tasks like importing large files, loading data in a transactional database etc.• Processing the data into the data warehouse using slowly changing dimensions type1, type2 and type3 models.• Leading Key meetings including status meetings, and other meetings during the implementation process with clients• Debugged the processes to make sure data is mapped/processed correctly which provides a qualitative check of overall data flow.• Managed the Relational Database Management Systems, Database Physical and Logical design, Data Mapping, Data Normalization, Creation of DB Diagrams, OLTP, and OLAP systems.• Troubleshooting issues and implement performance tuning techniques by determining the bottlenecks of slow running processes.• Implemented various performance tuning techniques using Indexing, query optimization, parameterized queries, CTE’s, SQL server profiler, database engine tuning advisor, IO stats, explain plans etc.• Developed and deployed scripts with step-by-step instructions, create change requests (RFC’s) and deployed ETL packages/database scripts to DEV/QA/UAT/PROD Servers.• Generated custom interactive dashboards using SQL server reporting services, Tableau for the end users.• Build different ADF pipelines with different activities to implement maintenance of the data and load it into Curated Layer.• Configured Azure platform for data pipelines, ADF, Azure Blob Storage and data lakes. Build workflows to automate data flow using Python and ADF.• Outbound and Inbound data tracking and reporting. Show less

• Involved in writing heavy T-SQL stored procedures, complex joins, new T-SQL features like Merge, Except commands• Developed data standards, data exchange, XML data standard or data sharing model.• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy LookUps, and Derived Columns with Multiple Data Flow tasks.• Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed event types.• Worked with… Show more • Involved in writing heavy T-SQL stored procedures, complex joins, new T-SQL features like Merge, Except commands• Developed data standards, data exchange, XML data standard or data sharing model.• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy LookUps, and Derived Columns with Multiple Data Flow tasks.• Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task Failed event types.• Worked with re-directing outputs into different formats including XML Files and various other data sources.• Involved in automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third-party tools.• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.• Worked on XML Web Services Control Flow task to read from XML Source.• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.• Developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File and DB2 into the data warehouse.• Interpreted data, analyzed results using statistical techniques and provided ongoing SSRS and Power BI reports.• Created, maintained and updated ETL packages loading from/to both OLTP and OLAP database tables.• Developed and implemented data collection systems and other strategies which optimize statistical efficiency and data quality.• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks). Show less

• Created Complex ETL Packages using SSIS for extracting, cleaning, transforming and loading data from staging tables to partitioned tables with incremental load.• Developed, deployed, and monitored SSIS Packages.• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.• Created number of standard reports and complex reports to analyze data using Slice & Dice, Drill Down and Drill Through approaches using… Show more • Created Complex ETL Packages using SSIS for extracting, cleaning, transforming and loading data from staging tables to partitioned tables with incremental load.• Developed, deployed, and monitored SSIS Packages.• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.• Created number of standard reports and complex reports to analyze data using Slice & Dice, Drill Down and Drill Through approaches using SSRS.• Participated in design discussions with Database architects and Application architects.• Designed the Data warehouse and done the mappings from Source to the Target tables.• Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.• Identified the dimension, fact tables and designed the Data-Mart using Star schema.• Created Indexes for faster data retrieval from the database.• Wrote Stored Procedures and Functions for better performance and flexibility.• Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.• Coordinated with Users in different testing phases.• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and Snow Flake Schema) using SSAS.• Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS• Developed Multidimensional Objects (Cubes, Dimensions), designed Dimensional Modeling and created Hierarchies using SQL Server Analysis Services (SSAS). Show less