Kavya Sree Polu

Client : General Motors

• Designed mapping sheets based on the data model to ensure accurate data transformation and integration.
• Worked closely with stakeholders to address business needs by providing data-driven insights and solutions.
• Created ETL processes to extract data from Oracle Database, transform it based on business requirements, and load it into the appropriate target database tables.Developed various parallel jobs in DataStage Designer following mapping specifications and using SQL queries to load data into Salesforce Automotive Cloud.
• Designed and developed sequence jobs with restart capabilities, checkpoints, and proper failure handling to ensure job reliability.
• Used DataStage Director for scheduling, running, and debugging ETL jobs.
• Designed jobs for catch-up loads, reprocessing rejected data, and implementing audit frameworks to maintain data integrity.
• Performed unit testing and system integration testing in development and UAT environments by writing complex SQL queries.
• Troubleshot and optimized the performance of DataStage jobs to improve efficiency and ensure smooth execution.
• Monitored the performance of ETL jobs and implemented enhancements to improve processing times.Ensured the accuracy of data through comprehensive testing and validation during the ETL process.
• Analyzed data loaded into Salesforce and resolved data issues by identifying root causes and applying fixes.
• Performed data cleansing by writing SQL patches and investigating ETL jobs to identify and address data gaps.
• Analyzed rejected data to provide clients with clear explanations and actionable insights.
• Managed the deployment of ETL code into DVT and PROD environments.
• Utilized GitHub for version control to ensure proper code management and collaboration.

Client : Air Canada

• Monitoring pipelines and keeping track of failures
• Monitoring pipelines until it loads the data successfully.
• Debugging failed pipelines

A request for proposal (RFP) is a business document that announces a project, describes it, and solicits bids from qualified contractors to complete it. As a part of this project ,used IBM Content intelligence for RFP documents which will help to identify generic topics and capture the details in a Database table. All the details would be contained in the Database tables. The Project proposer can refer the common details by simply querying the database tables instead of going through multiple reference RFP documents.

Worked on loading the RFP document,extraction of text from the image using content intelligence. Worked on extracting the matching text from the RFP documents using a configuration file with Fuzzy Lookup and loading the data to Database

Client : Reckitt

• Analyzed business requirements, evaluated technical solutions, and suggested effective solutions for implementation.
• Worked closely with stakeholders to address business needs by providing data-driven insights and solutions.
• Created ETL processes to extract, cleanse, transform, and load data into target systems.Used DataStage Designer to define tables for CSV and sequential files, import/export projects, and package jobs for deployment.
• Designed and developed parallel jobs according to mapping specifications, ensuring appropriate transformations and integrations.
• Performed data cleansing by writing SQL patches and investigating ETL jobs to identify and address data gaps.
• Analyzed rejected data to provide clients with clear explanations and actionable insights.
• Managed the deployment of ETL code into DVT and PROD environments.
• Conducted unit testing and system integration testing in development and UAT environments to ensure data accuracy and process integrity.
• Wrote and executed complex SQL queries to test the ETL process and validate data transformations.
• Troubleshot and optimized ETL job performance, ensuring efficient data processing and minimal resource usage.
• Continuously monitored job performance and implemented enhancements to improve execution speed.

• Assist in Software Development.
• Help identify, diagnose, and resolve software bugs and issues.
• Gain hands-on experience with various programming languages, frameworks, and tools used by the team.
• Participated in code reviews, contributing to maintaining high-quality standards in development projects.