Chetan Prasadh Email & Phone Number

Gurugram, Haryana, India

Gurugram, Haryana, India

Noida, Uttar Pradesh, India

Duties & Responsibilities as a Senior Software Engineer:• Implemented incremental and full load in SSIS using different method such as lookup, ole db command and cache transformations, merge statement and CDC.• Created integration packages using SSIS to fetch data from different sources such as Flat File Sources (UNC and SFTP), MS SQL Databases, MS MDS, IBM MQ and Azure DB.• Created integration packages with error handling and failure notification as per business requirement using system variables and checkpoints.• Created secured and light weighted data transfer package with the help of encryption & compression techniques such as GNUPG, WINZIP and 7-Zip.• Created integration packages using SSIS transactions and checkpoints which help the integration to perform consistency of package and data.• Identifying the process which has a scope of improvement in performance.• Developed the automated anonymization process which anonymized the GDPR compliance data in test and development environments.• Handled small and medium size development team along with code review and release plan.

New Delhi Area, India

Duties & Responsibilities as a Consultant BI:• Performed ETL using SSIS from Advance ERP to Staging DB.• Create dynamic stored procedures and functions using T-SQL.• Design Invoices (paginated) using SSRS and binding with parameterized stored procedures.• Optimized stored procedures and reports.

New Delhi Area, India

Laxmi Nagar

Created and modified transformations according to the Mapping Sheet designed by the Informatics lead.Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 8.6.Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.Worked extensively with the connected lookup Transformations using dynamic cache.Worked with complex mappings having an average of 15 transformations.Created and scheduled Sessions, Jobs based on demand, run on time and run only once. Monitored Workflows and Sessions using Workflow MonitorWriting unit test case document for mappings developed by me.Performing Unit testing of sessions and Workflows developed by me.Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process

Master Of Computer Applications - Mca, Computer Engineering, A

Activities and Societies: Armageddon(Gaming), Dance, IndiaCom

Bachelor'S Degree, Computer Science, A