Need to change format of existing Resume

User Generated

fehguv1104

Writing

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

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 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 high stress environment with resource constraints. CORE COMPETENCIES • • • • • Datastage 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 data staging area. Experienced in creating data warehouse documentation including, but not limited to requirements, technical specifications, and source to target mappings. 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 modeling (Star Schema modeling, and Snowflake modeling). 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 Datastage jobs (ETL) Developed the Data Modeling in snowflake Working experience in various domains like Retail sales, insurance. SUDEEP REDDY 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, Tws BI Reporting Tools: Tableau Operating Systems: UNIX, Linux, Windows 9x/2000/NT/XP, 2003/2008 Windows Server PROFESSIONAL EXPERIENCE Sr Datastage 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 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 cycle ▪ Built 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. Environment: Datastage 11.5, SQL Server, UNIX Shell Scripting, Autosys SUDEEP REDDY Sr Datastage Developer Mar 2017 - Jan 2018 AllState- 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 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. Environment: Datastage 11.5, Oracle , UNIX Shell Scripting, Control -M Sr Datastage 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 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: Datastage 11.3, SQL Server, UNIX Shell Scripting SR Datastage Developer June 2014 - Jan 2015 Rafter Inc. - India, Pune Duties and Accomplishments: ▪ Responsible for 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 SUDEEP REDDY ▪ ▪ ▪ ▪ ▪ ▪ ▪ 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 a 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 data warehouse from Greenplum to Snowflake. Environment: Datastage 8.5, GreenPlum, UNIX Shell Scripting, Tws Datastage Developer June 2013 - May 2014 AILFC- India, Hyderabad American Income Life Insurance Company (AILFC) seeks assistance in setting up a consolidated reporting system to help AFLAC Life Insurance management to manage their operations better. AILFC is an organization that needs to manage operations of two large and distinct insurance groups. Currently, one source of information, either database or reports, contains the data needed to present management with all of the information desired for managing these operations. This initiative is an attempt to achieve consensus about these definitions, so that management is able to compare the performance of all their insurance groups. Duties and Accomplishments: ▪ Understood the business rules completely and implements the data transformation methodology. ▪ Understood the Technical design document and Source-To-Target mappings. ▪ Designed Datastage jobs for validating and loading data. ▪ Used the Datastage Designer to develop processes for extracting, cleansing, transforming, integrating and loading into Data Warehouse. ▪ Extracted data from sources such as oracle, Flat files to transform and load into target Databases. ▪ Datastage Designer was utilized for developing mappings using stages, which includes Transformer, Join, Lookup, Merge, Funnel, Filter, Oracle Enterprise Stage, Sequential File, Dataset, File Set, Copy, and Modify Stage. ▪ Implemented SCD- Type II Techniques. ▪ Designed Sequencer to automate the whole process of data loading. ▪ Extensively worked with Datastage Shared Containers for Re-using the Business functionality ▪ Experience in running jobs using Job Sequencers, Job Batches. ▪ Involving in performance tuning jobs process identifying and resolve performance issues. ▪ Involved in unit testing of Datastage jobs. Environment: Datastage 8.5, XP, Oracle 10g, UNIX, Teradata
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags