Description
Need to change format of existing Resume Need to change format of existing Resume
Need to change format of existing Resume
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hello.Your work is complete.Kindly feel free to contact me for additional editing or any other concerns.Also feel free to reach contract me for future work.Chao!
SUDEEP REDDY
781-499-2656
Sudeep8621@gmail.com
https://www.linkedin.com/in/sudeep-reddy
Profile Summary
Data Stage developer having 5 years of experience and broad skill sets in ETL programming using Web Sphere Data Stage
(parallel version)8.1v/11.5 v and Strong background in Data Warehousing, Star Schema, snowflake schema and ETL jobs.
Good logical ability and systematic approach to problem-solving analysis, Integration Management solution design and
strong debugging skills. Able to quickly learn and understand the business domain and behave to deliver business value
on a consistent basis. Excellent team player with strong written, communication and analytical skills. Capable of working
under a high-stress environment with resource constraints.
Core Competencies
•
•
•
•
•
•
•
•
•
•
•
Data stage Designer
Linux and shell scripting Experience
Design & Develop ETL Jobs
Business Analysis
Data Stage/SQL.
Cloud database (snowflake)
Project Planning and Execution
PL/SQL
Technical Support and Service
Leadership and Development
Interpersonal Relations
Professional Skills
•
•
•
•
Having strong knowledge in extracting data from legacy systems to stage and then Cleanse, Process and
Loading into Data Marts and Data Warehouse.
Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort,
Copy, Merge, Funnel, CDC, Change Apply, Filter, Datasets, Change Data Capture, Row Generator and many
other stages in accomplishing the ETL Coding.
Experienced in integration of various data sources ( SQL Server, PL/SQL, Oracle, PostgreSQL, Greenplum,
MySQL) into the data staging area.
Experienced in creating data warehouse documentation including, but not limited to requirements, technical
specifications, and source to target mappings.
Sudeep Reddy – Resume
•
•
•
•
•
•
•
Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the Data Stage
jobs.
Experienced in Database programming for Data Warehouses (Schemas), proficient in dimensional modelling
(Star Schema modelling, and Snowflake modelling).
Hands on experience in Tuning Jobs, bug identifying and resolve performance in Parallel Jobs in Data Stage.
Maintaining and running regular database backup’s
Troubleshooting Data stage jobs (ETL)
Developed Data Modeling in snowflake
Working experience in various domains like Retail sales, insurance.
Technical Skills
ETL Tools: IBM Data stage 11.5
Databases: SQL Server 2008, Oracle 11g/10g/9i, Greenplum
Database Tools: TOAD, SQL Plus, SQL Developer
Languages: SQL, Transact SQL (T-SQL), PL/SQL, UNIX Shell Scripts, C, C++, HTML, XML
Load Utilities: SQL Loader
Scheduling Tools: Control-M, Autosys, Tw’s
BI Reporting Tools: Tableau
Operating Systems: UNIX, Linux, Windows 9x/2000/NT/XP, 2003/2008 Windows Server
Relevant Work Experience
Sr Data stage Developer | Feb 2018-Till Date
Stanley Black and Decker - New Britain, CT
Our Client large customers continually ask them how much their doors cost them and when
they should be serviced or replaced. This process is a time -consuming manual effort today that
requires automated reporting capabilities.
Duties and Accomplishments:
▪
Used various sourced and designed and developed jobs in order to facilitate the integration
process of the expenditures.
▪
Analyzed reports made by the 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 Data stage code in SVN tortoise to maintain different versions in different
stages of the project life cycle
Built the SQL queries to fetch the data from the Database as per the business requirement
and used the SQL queries in the Data stage 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.
Environment: Data stage 11.5, SQL Server, UNIX Shell Scripting, Autosys
Sr Data stage Developer | Mar 2017 - Jan 2018
All State- NC, Charlotte
Duties and Accomplishments:
▪
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 Data stage 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.
Environment: Data stage 11.5, Oracle, UNIX Shell Scripting, Control -M
Sudeep Reddy – Resume
Sr Data stage Developer | Feb 2015 - Dec 2015
Stanley Black and Decker – Hyderabad, India
Duties and Accomplishments:
▪
Migrated jobs from 11.3 to 11.5.
▪
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.
Captured results compared result sets of 11.3 and 11.5.
▪
▪
▪
Tuned the parallel jobs for higher performance and replaced old stages with new stages in
the migrated jobs.
Resolved compilation/run time errors in the migrated jobs and End to End tested the
output data of the migrated jobs in the new environment.
▪
▪
Worked on changes to be made to jobs in 11.5 in case of errors.
Worked on data issues in source files.
▪
▪
Communicated with the client in case of code changes in 11.5.
Worked in performance tuning phase.
▪
▪
Monitored jobs in 11.3 production and 11.5 production.
Prepared track sheets for understanding performance improvement
Environment: Data stage 11.3, SQL Server, UNIX Shell Scripting
SR Data stage Developer | June 2014 - Jan 2015
Rafter Inc. - India, Pune
Duties and Accomplishments:
▪
▪
Responsible for the complete working of data warehouse
Running daily batch jobs from OLTP to OLAP
▪
▪
Involved /Responsible for various data integration processes/applications
Error handling and debugging on batch jobs
▪
▪
Enhancements based on client requirements.
Responsible for running data processing smooth
▪
▪
Developed and modification on SCD’s through various scripting
Collaborate with other function leaders in evaluating correcting DW strategies and goals
and implement changes as needed
▪
▪
24x7x365 operation management of Data Warehousing group that includes business
analysis, ETL processing, reports and technical support to the environment.
Also, responsible for reporting and Dashboards using LOOKER
▪
Migration of dat...