SUMMARY

• Over 7+years of ETL and Data Integration technical experience in IT Industry as a developer in System Analysis, Design, Development, Testing and Production Support of projects with different clients ( Confidential, Confidential, Confidential, BOFA, Standard Charted Bank) using DataStage 8.5/9.1/11.3/11.5.
• Experience in Software Development Life Cycle - SDLC (Analysis, Design, Development and Testing), requirement gathering, client interaction, Use Case Design and understanding.
• Have hands on experience in design and development of complex DataStage jobs, sequencers and FastTrack, Metadata Workbench and Business Glossary.
• Have hands on experience in Autosys and Control-M job schedulers. Experience in UNIX scripting, troubleshooting and file handling on the UNIX system.
• Good hands on experience in RDBMS like Oracle, Netezza, SQL Server, Teradata and DB2. Working experience in data modeling and implementing stored procedures using PL/SQL. Extensive noledge of writing complex queries using SQL.
• Experience in working with SAP & Salesforce API’S to load the data into different databases.
• Demonstrated work experience in using the state of art DataStage Grid environments. Experience in Data Integration, EDW and Data Mart projects.
• Strong noledge in OLAP and OLTP Systems, Dimensional modeling using Star schema and Snowflake schema. Demonstrated work experience in Mainframe to DataStage Migration projects.
• Working experience in DB2 cursors, PL/SQL triggers and stored procedures. Experienced in designing and using several process tracking mechanisms and communication designs that give a snapshot of the status of the jobs in an application/system.
• Worked on integrating data from sequential files, flat files, COBOL files and XML files. Used Toad for analyzing data, writing SQL, PL/SQL scripts performing DDL operations.
• Experience in working closely with mainframe applications for the ETL interactions. Prepared High-Level design document, Low Level design document, Technical design document for various projects and good at Bug fixing, Code reviews, and Unit & System testing.
• Experience in working in a Multi-Dimensional Warehouse projects. Experience in reading and loading high-volume Type 2 dimensions by implementing SCD (Slowly Changing Dimensions).
• Hands on Experience in working with BOXI for report generation. Good experience in designing metadata for all data moves and to re-use them during the job designing with the halp of Metadata.
• Management and FastTrack Mapping specifications.
• Providing 24X7 productions supports for the application stability. Worked on Agile Methodology.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix shell scripting, COBOL

ETL Tools: Datastage 8.5/9.1/11.3/11.5 Designer, Administrator, DirectorFastTrack, Metadata Workbench, Business Glossary

Databases: Oracle 10g, DB2, Netezza, BluMix, Teradata, SQL ServerSoftware s TOAD for oracle, TOAD for DB2, WINSCP, MS SQL server 2008 Management Studio, SQL Developer, AQT for DB2, AQT for Oracle, MAINFRAMES

Other Tools used: ClearCase, Tortoise SVN Sub Version, HP ALM

Operating Systems: UNIX (AIX), LINUX, Windows 95/98/2000/XP/2003, MS-DOS.z/OS

Scheduler Tools: ASG-ZENA, CA7, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

DataStage Developer

Responsibilities:

• Involved in understanding of business processes to learn business requirements. Extracted data from different systems into Source. Mainly involved in ETL developing.
• Analyzed all the source Data and Design DataStage jobs in 11.3 & 11.5 and load SCD-type1 dimension tables.
• Design DataStage Fact load jobs and ensure the order of sequence is followed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used Data Stage Director and its run-time engine for job monitoring, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis
• Fix defects and deploy code into production on time.
• Develop ASG-ZENA scheduling tool jobs and automate the DataStage load jobs.
• Do DataStage code check in Visual Studio team foundation server and follow deployment t guidelines.
• Support DataStage jobs in production for any job failures.
• Follow Agile frame work and participate in Daily stand ups meetings and update user stories and tasks in timely fashion.

Environment: Confidential Infosphere DataStage 11.3, 11.5, Confidential AIXUNIX, Sybase, MS SQL server 2012, DB2, Microsoft Visual Studio 2015, ASG-ZENA scheduling tool.

Confidential, Littleton, MA

ETL DataStage Developer

Responsibilities:

• Understand and gathering business requirements and mappings and prepare design flow and technical specification documents.
• Creating DataStage jobs in Dev Env and deploying into Test, Uat & Prod Env. Scheduling and Monitoring the Daily, Weekly & Monthly Jobs
• Knowledge in using PL/SQL to write stored procedures, functions, and triggers. Involved in updating Stored Procedure, performance and testing of Stored Procedure DataStage jobs.
• Defined and implemented approaches to load and extract data from database using DataStage.
• Migrating the data by using Web services URL or API’S URL loading data into databases through hierarchical Stage & Extract Stage.
• In SAP & Salesforce website by using Username and Password then we need to call the login operation, in that we can find the server URL and session ID, This will connect the API’S.
• me have used the query more call to retrieve records if the result is more than 2000.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
• Used aggregator, look up, join, merge, dataset, transformer, sequencer, sequential file DB2 bulk load, hashed file stage, surrogate key generator.
• Involved in developing the Cognos reports by writing complex SQL queries. Executed jobs through sequencer for better performance and easy maintenance.
• Involved in unit, performance and integration testing of Data Stage jobs. Used Data Stage Director to run and monitor the jobs for performance statistics.

Environment: DataStage 8.5/11.3, Oracle, Netezza, DB2, API’s, CRM Application, Ramp Servers, Dashboard, RTC Tool, Agile.

Confidential, Providence, RI.

ETL DataStage Production Support

Responsibilities:

• Defined and implemented an end-to-end enterprise data integration strategy. Promoted data and business rules reuse and understanding. Standardized the data content.
• Created DataStage 8.5 and 11.3 jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, and Surrogate Key.
• Column Generator, Difference, Row Generator, Sequencer, Email Communication activity, Command activity. Centralized the business rules management
• Used several stages like Sequential file, Hash file, Aggregator, Funnel, Change Capture, Change Apply, Row Generator, Peek, Remove Duplicates, Copy, Lookup, Join, Merge, Filter, Datasets during the development process of the DataStage jobs.
• Worked on standing up the Performance Environment by creating Value Files, Parameter Sets, Unix Shell Scripts, running one-time PL-SQL scripts for inserting/updating values in the various tables. Deploying the code into all other test environments and making sure QA to pass all their test cases.
• Measured and improved data quality. Enabled Enterprise data warehouse. Designed and developed solutions to complex application problems.
• Maintained and provided support in the existing systems. Developed new functionality and interface as per the business requirements and integrated them with the legacy application.
• Identified the areas of application where improvement and automation of the manual process was required and implemented the process improvement.

Environment: Netezza, Oracle, DataStage 8.1, 11.3, CA7 Scheduler, Unix Shell scripting, MS SQL Server 2008 R2.

Confidential - Windsor, CT

DataStage Developer

Responsibilities:

• Involved in gathering Business Requirements from Business users. Analyzed all jobs in the project and prepared ADS document for the impacted jobs.
• Made the required changes in the job according to the Business requirements. Coordinating offshore team and making the offshore team work smoothly and getting the quality work from offshore on time.
• Used SQL and PL/SQL explain plan in Query man, SQL Developer to fine tune the SQL codes which were used to extract the data in database stages
• Designed, developed and tested the DataStage jobs using Designer and Director based on business requirements and business rules to load data from source to target tables.
• Modified the existing job with new functionality in the code. Prepared the test cases for system test.
• Excellent with PL/SQL, T-SQL, Stored Procedures, Database Triggers and SQL * Loader. Resolving the defects which have been raised by QA.
• Established best practices for DataStage jobs to ensure optimal performance, reusability, and restart ability.
• Used Autosys to schedule, run and monitor DataStage jobs.
• Extracted the data from the DB2 database and loading into downstream Mainframe files for generating the reports.

Environment: Confidential Infosphere Information Server DataStage 9.1, Netezza, UNIX, AIX, DB2, Mainframe files, CA7 Job control.

Confidential

DataStage Developer.

Responsibilities:

• Identified source systems, their connectivity, related tables and fields and ensured data suitability for mapping.
• Prepared FastTrack Mapping Specifications, created metadata layouts in Metadata Workbench and update Business Glossary.
• Prepared Data Mapping Document and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements& Design.
• Studied the PL/SQL code developed to relate the source and target mappings. Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the Confidential DB2 database.
• Used Data Stage Director and its run-time engine for job monitoring, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis. Also worked for different enhancements in FACT tables.
• Performed Performance testing with different sets of node configuration, different queue and different volumes. Prepared the DML’s for maintenance tables, review, and test and execute them.
• Used Tortoise SVN version control tool for version controlling and movement of code to upper environments like SIT, UAT, Pre-production and Production.

Environment: Confidential Web Sphere DataStage 8.5 Parallel Extender, Grid environment, FastTrack, Metadata Workbench, Business Glossary, Web Services, Quality Stage 8.5, Microsoft Visio, Confidential AIX 4.2/4.1, SQL Server, Confidential DB2, ORACLE 11G, Autosys Scheduler, Unix, Windows, HP ALM

Confidential

DataStage Developer

Responsibilities:

• Studying the business requirement, preparing the impact analysis document. Prepared technical specification document, upon review of the solution developed the solution using DataStage jobs and sequencers.
• Used sequential file stage as the source for most of the source systems. Developed a file check process that checks the format, volume and date in the file decides whether the right file is being sent by the source and whether the right file is being loaded into the database.
• Created DDL statements for new tables, changes to table structure, index changes, and creation of triggers and stored procedures. Prepared unit test cases and test plans.
• Executed the test cases, captured the results. Supported the SIT testing, UAT testing. Worked on packaging the code with the halp of tortoise SVN version controlling tool and worked with respective teams to deploy the code.
• Supported the system post production and worked in co-ordination with the production support teams to resolve any issues.

Environment: DataStage 8.1 (Designer, Director, Manager, Administrator) Enterprise Edition, SQL Server 2005, Confidential DB2, AS/400, ERwin4.0, MS Visio 2000