Sudeep Thodeti Email & Phone Number

United States

Kansas, United States

Culver City,Ca

Used various sourced and designed and developed jobs in order to facilitate the integration process of the expenditures.Analyzed reports made by business user to extract data to effectively integrate expenditures from various sources.Evaluated the Data extraction from source to confirm for data irregularities and classify corrupt data to apply suitable transformation in the mappings in the jobs.Understand the business rules completely and implements the data transformation methodology.Involved in the Technical design document and Source-To-Target mappings.Extensively used Data Stage Designer for Developing Parallel jobs and performed complex mappings based on Business specifications. Involved in the design and development of the ETL process for the data warehouse.Implemented SCD 1 and SCD 2 Jobs.Design and implemented XML Jobs.Done performance tuning to long running source SQL queries in the jobs.Checked in the Datastage code in SVN tortoise to maintain different versions in different stages of project life cycleBuilt the SQL queries to fetch the data from the Database as per the business requirement and used the SQL queries in the Datastage for further processing.Developed few server jobs as part of the project.Developed sequencers to automate the parallel jobs and created looping jobs using sequencers.Responsible for Performance tuning for better performance.Involved in data analysis and support to QA.Created build & Release documents.

Charlotte, North Carolina Area

>24x7x365 operation management of Data Warehousing group that includes business analysis, ETL processing, reports and technical support to the environment.>Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.>Uses change requests (CRs) to release the code to production without negatively impacting or disrupting workflow, systems, and end users>Validated the current production data, existing data and the programming logic involved.>Used the Control -M job Scheduler to schedule the Datastage jobs to run the daily jobs and weekly jobs.>Identified all data sources and size of the data load, analyzed data and Responsible in identifying data mapping rules.>Implementation of all jobs in production for all newly changed jobs to improve performance.>Implemented SQL performance tuning on existing jobs.>Designed parallel jobs based on code enhancements.