Suseel Kumar Email & Phone Number

South Plainfield, Nj, Us

St Louis, Missouri, United States

• Performed data extraction, transformation, and loading (ETL) between systems using SQL tools such as SSIS.• Create SSIS packages using various control flow and data flow tasks to extract the data from multiple sources like Excel, XML, JSON, and OLTP and consolidate them into staging tables.• SQL Query Optimization and Performance Tuning, Optimizing Stored Procedures and long-running queries using indexing strategies and query optimization techniques.• Use SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse databases.• Work on managing ETL processes by pulling large volumes of data from OLTP to a staging Database using SSIS for data transformation.• Expertise in writing complex DAX functions in Power BI and Power Pivot.• Work on SSIS performance tuning using counters, error handling, event handling, and re-running of failed SSIS packages using checkpoints.

Hyderabad, Telangana, India

• Responsible for the design and development of a Sales Data Warehouse project leveraging the Informatica Power Centre ETL tool, Teradata database, and Micro Strategy reporting tool. • Worked on Informatica Power Centre tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.• Parsed high-level design specifications to simple ETL coding and mapping standards. • Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.• Designed and customized data models for Data warehouse supporting data from multiple sources in real-time• Involved in building the ETL architecture and Source to Target mapping to load data into the Data warehouse.• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.• Imported various Sources of data and created Targets and Transformations using Informatica Power Centre Designer (Source analyser, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).

Bengaluru, Karnataka, India

• Created complex SQL stored procedures using Microsoft SQL Server 2014 and 2012• Developed SSIS ETL packages using data warehouse architecture model by creating fact table’s role playing and conformed dimensions.• Developed SQL queries to fetch complex data using Inner/Outer joins, sub queries, CTE, Tally tables accommodating complex filters and database links.• Strong Data Modeling experience using dimensional data modeling, star schema modeling, snow-flake modeling using tools like Erwin.• Experience in developing reports using SSRS 2014 and SSRS 2016.• Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements• Created SSIS-ETL packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task• Created SSIS packages to other SQL Server instances in SSIS 2014.