Etl Developer Resume
Cincinnati, OH
SUMMARY:
- Over Twelve years of IT experience in Data Warehousing/Business Intelligence (BI), Decision support Systems and has Wide Experience in implementing Data Warehousing solutions to large corporate clients and has professional experience working with various industries such as Retails, Manufacturing and Finance.
- Six Plus years of experience in Data Warehousing in Design Analysis, Development, Data Modeling, building Data Marts, generating OLAP reports using IBM Websphere Information Server V 11.5/9.18.7/8.5/8.0/ Ascential DataStage 7.5/7.x/6.0 (Data Stage Manager, Data Stage Administrator, Data Stage Designer, Quality Stage, Data Stage Director, Parallel Extender),MDM9.0.
- Strong in defining and implementing the various components of a Data Warehouse such as Operational source systems, Data staging, Data presentation and Data access tools.
- Experienced in Converting the Business Logic into Technical Specifications.
- Over 7 years of experience in implementing Oracle database applications.
- Extensive knowledge with Teradata Load Utilities Fast Export, Fast Load, Multiload, BTEQ.
- Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries, SQL Performance tuning)
- Designed logical and physical database configurations for large - scale data warehouse and OLTP implementations using Erwin and Oracle Designer.
- Over 5 years of experience in AIX & SUN environment.
- Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 10g/9i/8.x, DB2UDB, COBOL Copybooks, MS SQL Server 2000/2005, Teradata, Sybase, People soft and SAP.
- Implemented SAP Adapters (ABAP,IDOC,BAPI)& Data stage Pack for SAP R/3 and SAP BW
- Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader.
- Worked with version control and defect tracking tools like clear case and clear quest .
- Expertise in Implementing SOX (Sarbanes-Oxley Act of 2002).
- Hands on experience in writing, testing and implementation of the Triggers, Procedures, and Functions at Database level using PL/SQL.
- Excellent team player with strong written, communication, interpersonal, analytical skills. Capable of working under high stress environment with resource constraints.
TECHNICAL SKILLS:
ETL Tools: IBM Web Sphere Data Stage v. 11.5/9.1/8.7/8.1 , 7.5.2/7.1/6.0/ (Parallel Extender, Quality Stage, MDM9.0, Information Analyzer/Profile stage), Abinitio1.14, Crystal Reports
OLAP Tools: Business Objects 6.5/5.0
Data Modeling: ERwin 4.0/3.5, Star-Schema Modeling, Snowflake-Schema Modeling, Fact Tables, Dimension Tables
Languages: SQL, PL/SQL, UNIX Shell( Bourne, Korn), Perl, C,JAVA, Visual Basic, COBOL II, JCL, CICS, HTML, VBscript, XML
ERP: SAP R/3,BW
Databases: Oracle 10g/9i/8.0, MS SQL Server 2000/7.0/6.5 , DB2 UDB9.0/8(LUW), Sybase SQL Server 12.0/11.x, Teradata v2 R5.0/R6, MS Access 7.0/ 97/2000
Operating Systems: Sun-Solaris 5.8, Hp-UX 11, Linux, Windows NT/2000/XP
Change Management: ClearCase, ClearQuest, Remidy, Pack 2000,GIT
Scheduling tool: Autosys, Harvest
PROFESSIONAL EXPERIENCE:
Confidential, Cincinnati, OH
ETL DeveloperResponsibilities:
- Designed, build, deploy and modify existing and new Datastage 11.x ETL’s based on the technical and functional requirements provided, while adhering to Company best practices
- Working as lead to manage team (offshore) and assigning tasks and sending status to upper management.
- Developed various jobs using stages DB2UDB enterprise, Lookup, Dataset, Join, Sort, Aggregator, Filter, Modify, Funnel, Peek (debugging stage), Remove Duplicate and Copy
- Developed multi instance jobs which load multiple tables by adding metadata dynamically utilizing RCP(Run time column propagation)
- Responsible for supporting Enterprise data warehousing production applications on a 24/7/365 on-call schedule basis.
- Responsible for running Remedy report and assigning task and make sure the task completed on time.
- Develop solution for most critical Datastage-Mainframe job which are not meeting the business requirement and facing data quality issue in production.
- Conducted technical walkthroughs of DataStage ETL for design and development solutions.
- Documented all the defect/issues occurred during daily production cycle to develop new solutions.
- Resolved the critical ETL (Datastage), Mainframe, DB2-Data related issue by coordinating with Business, Deployment, Quality Assurance, and Infrastructure support teams.
- Utilized Run time column propagation (RCP) to design jobs which have frequent changes in column name and types to meet end user requirements.
- Worked on maintenance and support of the existing interface DataStage processes including investigation of issues and production troubleshooting.
- Developed multi instance jobs which load multiple tables by adding metadata dynamically utilizing RCP.
- Create, update and publish documentation, system diagrams, presentations, workflows, project plans, risk logs and issues logs
- Worked on assessing high level functional and architecture impact on any changes recommended.
- Promote code on all SDLC environments and validate that the code is working as expected
- Automated daily manual process using unix shell scripts/Tivoli work station.
- Promote code on all SDLC environments and validate that the code is working as expected
Environment: IBM Info sphere Information Server-Quality stage 11.5,Oracle 10g, db2udbAIX 5.2,TWS,autosys,Pack 2000, Windows 2000.
Confidential
Sr.Datastage Developer
Responsibilities:
- Performed extensive data analysis, gap analysis and created detailed inventory/dataflow-diagrams for all existing process.
- Created inventory document to present the programs which need to be modified/redesigned to meet the upgrade standards.
- Working on existing program issues which are occurred during upgrade of Datastage11.5, DB2UDB 10.5 and Linux to find optimum resolution.
- Working with various infrastructure team to resolve environment issues which occurred during ETL-DataStage and DB2UDB upgrades.
- Re-design and developed most critical DataStage-Mainframe jobs which are not meeting upgrade version requirements by coordinating with respective application SME’s.
- Converted and redesigned old ETL programs which are developed in SQC, UNIX, JAVA and PLSQL in datastage11.5.
- Developed job by using RCP (Run time column propagation) which required frequent column name changes for reporting and end user requirements.
- Extensively worked on loading Star and Snowflake Datamarts like selling and servicing
- Developed
- Involved in defect resolution and supported SIT and UAT environment to make sure the code is up to the defined standards.
- Documented all the defect/issues encountered during the development/sit to meet production and future upgrade standards.
Environment: IBM Web sphere Information Server-Quality stage 11.5/8.7, DB2 UDB 10.5, Oracle10g, AIX 5.2,Linux, JCL, MVS,Autosys, GIT, Pack 2000, Windows 2000.
Confidential, Reston
Production support Analyst
Responsibilities:
- Plans and executes software engineering development projects, utilizing advanced software engineering principles, software architecture as well various standards.
- Identifies possible production failure scenarios for supported applications and document resolutions details in knowledge repository.
- Actively participates in SDLC design, Code and implementation phases and executes tested and approved run-book instruction per deployment plan.
- Reviews, approves and executes Data Correction/DBMODs and other ad-hoc production requests
- Continuously monitor production processes and recommend and implement process improvements to the Application.
- Worked with various business user to resolve the data related issues.
- Involved in writing and executing DQ(Data quality) and DCU’s(Data correction units) in production to correct the data related issue.
- Worked with various vendors(NYSE etc) to stream line the data files related issues.
- Worked with EPV team to onboarding the application id’s and encrypting passwords.
- Involved in onboarding the new BW server by working with TIBCO Adm. Team.
- Created service request to ECM team to set up ICART and configure ICART to point to new servers.
- Worked with Informatica admin team to create new project/folder to facilitate new code.
- Worked with database team to refresh lower environment data, creating new synonyms and resolving space issue.
- Design and develop the programs to automate the production process.
- Involved in writing Autosys jobs , JIL file for Box as well as Command jobs.
- Created run books for job information which is scheduled on Autosys.
- Manage incident and Change mgmt activities along with partnering with Dev teams and other project stakeholders
Environment: Informatica 9.6, MDM(Master data Management), UNIX (Sun Solaris 8/AIX), SOAPUI, JAVA,Linux 5, Remedy 7.0 ,Service now, Shell Scripting, FTP, SFTP, Autosys, Oracle 12 RAC, SQL, Sybase, SharePoint, Clear quest and Rapid SQL.
Confidential
Sr.Technical Analyst
Responsibilities:
- Worked with business user to achieve the end user financial reporting formats.
- As a Data Warehousing team member, Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the Financial Data from various source systems feeds into CDW using Data stage and Unix Shell scripts.
- Extensively worked on loading Star and Snowflake Datamarts like selling and servicing
- Developed various jobs using stages DB2UDB enterprise, Lookup, Dataset, Join, Sort, Aggregator, Filter, Modify, Funnel, Peek (debugging stage), Remove Duplicate and Copy
- Extensively worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources
- Developed Parameterized reusable Data stage jobs where you can use these jobs in multiple instances.
- Developed multi instance jobs which load multiple tables by adding metadata dynamically utilizing RCP(Run time column propagation)
- Created Parameter set file to utilize in data stage development.
- Primary 24/7- on-call level-III support for the maintenance and troubleshooting of CDW( Corporate data warehouse) datastage jobs in production system.
- Involved in executing DQ and DCU’s in production.
- Created Shell scripts to automate the data load processes to the target tables
- Migrated jobs from development to QA to Production environments.
- Worked with change management tool Clearcase for version controlling.
- Worked with Clear quest, Pack 2000 to track the defects.
- Modified/created Autosys Jil scripts for scheduling the Data Stage jobs.
- Involved in creating Designing documents and mapping documents for Data stage jobs.
Environment: IBM Web sphere Information Server-Quality stage 9.1/8.7, DB2 UDB 9.0, Oracle10g, AIX 5.2, Autosys, Pack 2000, Windows 2000.
Confidential
Sr. ETL Developer
Responsibilities:
- Collected the business requirements to integrate current system .
- Prepared detail design documents which contain job designs and functionality of each job.
- Migrated jobs from 8.0 to 8.7 as the IS-data stage got upgraded.
- Developed jobs in Parallel Extender using different stages like Transformer, Remove Duplicates, Sort, Join, Merge, Lookup, Data Set, Funnel, Copy, Modify, Filter, Change Data Capture.
- Extensively worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources.
- Created Parameter set file to utilize in datastage development.
- Converted old Eagle programs to datastage as they were difficult to improve performance and add new functionality to it.
- Modified and created existing production jobs as per current reporting requirements.
- Migrated jobs from development to QA to Production environments.
- Worked with JIRA, Pack 2000 to track the defects.
- Modified/created auotsys scripts for scheduling the Data Stage jobs with new parameters.
- Created designing documents and mapping documents for DataStage jobs.
Environment: IBM Info sphere Information Server-Quality stage V8.7/8.0, Oracle 10gSQL Server 2005, AIX 5.2,JIRA, Autosys, Pack 2000, Windows 2000.
Confidential
Sr.Technical Analyst
Responsibilities:
- Worked with Seller business user to collect the business requirements and converted them to ETL specifications.
- Actively participated in discussion sessions to design the ETL cycle.
- Worked with Data Modeler and DBA’s to build the data model and table structures.
- Compiled source to target mapping documents to design the ETL jobs.
- Prepared detail design documents which contain job designs and functionality of each job.
- Migrated data stage jobs from enterprise edition 7.5 to information server 8.5.
- Created Parameter set file to utilize in datastage development.
- Developed various jobs using stages Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages .
- Created Shell scripts to automate the data load processes to the target tables
- Migrated jobs from development to QA to Production environments.
- Worked with change management tool Clearcase for version controlling.
- Worked with Clear quest, Pack 2000 to track the defects.
- Modified/created Autosys Jil scripts for scheduling the Data Stage jobs with new parameters.
- Involved in creating Designing documents and mapping documents for Data stage jobs.
Environment: Ascential Data Stage 7.5.2, IBM Web sphere Information Server-Quality stage V8.5, DB2 UDB 9.0, SQL Server 2005, AIX 5.2, Autosys, Pack 2000, Windows 2000.
Confidential
Production Support Analyst
Responsibilities:
- Primary 24-hour on-call responsibility for the maintenance and troubleshooting of AWS production system.
- Provide technical support for AWS Production system.
- Monitoring the Production monthly and daily Autosys jobs.
- Analyzed Business Requirements by working closely with Business Area experts.
- Involved in tracking defects in ETL jobs and proposed solutions to Development team.
- Involved in writing Autosys jobs, JIL file for Box as well as Command jobs.
- Created run books for job information which is scheduled on Autosys.
- Involved in finding production status by using Autosys commands.
- Worked with Clear quest and Remedy support to track defects.
- Modified existing Unix Scripts to meet the requirements.
- Worked with DBA’s to tune SQL scripts for performance.
- Interacted with UNIX support group to resolve server issues.
Environment: UNIX (Sun Solaris 8/10), Linux 5, Remedy 6.3, Shell Scripting, FTP, SFTP, Autosys, Oracle 10g, SQL, ISQL, PL/SQL, Aqua Data Studio 4.7, Sybase, SharePoint, Abinitio1.14, Clear quest and TOAD.
Confidential
Sr.Technical Analyst
Responsibilities:
- Worked with Fas140 business user to collect the business requirements to Integrate current system.
- Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
- Developed jobs in Parallel Extender using different stages like Transformer, Remove Duplicates, Sort, Join, Merge, Lookup, Data Set, Funnel, Copy, Modify, Filter, Change Data Capture and custom stages.
- Used the Data Stage Director and its run-time engine to Schedule running the solution, Testing and Debugging its components, and Monitoring the resulting executable versions.
- Worked in FAS140-delivary services to run ETLs jobs from end to end to meet Business users requirements.
- Created Shell scripts to automate the data load processes to the target tables
- Migrated jobs from development to QA to Production environments.
- Worked with change management tool Clearcase for version controlling.
- Worked with Clear quest, Pack 2000 to track the defects.
- Modified/created Autosys Jil scripts for scheduling the Data Stage jobs with new parameters.
- Performed the Unit testing to validate complex business rules.
- Involved in creating Designing documents and mapping documents for Data stage jobs by following new SDLC.
Environment: Ascential Data Stage 7.5.2, IBM Web sphere Information Server-Quality stage V8.5,Information Analyzer 8.5, DB2 UDB 9.0,Oracle 10g, SQL Server 2005, AIX 5.2, Autosys, Pack 2000, Windows 2000.
Confidential, ST. Louis
Sr.ETL Developer
Responsibilities:
- Involved in gathering Business requirements from Business user and converting them to Technical specifications.
- Worked with business user to achieve the end user financial reporting formats.
- As a Data Warehousing team member, Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the Financial Data from various source systems feeds into ODS using Data stage and Unix Shell scripts.
- Involved in Data Extraction, Staging, Transformation, Pre-Loading, and Loading into ODS, Data mart.
- Extensively used IIServer 8.0.1 Quality stage component for standardize the seller address and names.
- Developed various jobs using stages DB2UDB enterprise, Lookup, Dataset, Join, Sort, Aggregator, Filter, Modify, Funnel, Peek (debugging stage), Remove Duplicate and Copy
- Imported Oracle schema in to data stage Manager for data mappings.
- Extensively worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources
- Developed Parameterized reusable Data stage jobs where you can use these jobs in multiple instances.
- Created Shell scripts to automate the data load processes to the target tables
- Worked with change management tool Clearcase for version controlling.
- Worked with Clear quest, Pack 2000 to track the defects.
- Modified/created Autosys Jil scripts for scheduling the Data Stage jobs with new parameters.
- Involved in creating Designing documents and mapping documents for Data stage jobs.
Environment: Ascential Data Stage 7.5.2, IBM Web sphere Information Server-Quality stage V8.1,Information Analyzer 8.1, DB2 UDB 9.0, SQL Server 2005, AIX 5.2, Autosys, Pack 2000, Windows 2000.
Confidential, Lakeland, Fl
Sr.ETL Developer
Responsibilities:
- Involved in entire product life cycle of SCPM(Supply Chain Performance Management, Forecast, Replenishment) development from the requirement gathering through implementing in production.
- Worked with SCPM business user to collect the business requirements and converted them to ETL specifications.
- Migrated data stage jobs from enterprise edition 7.5 to information server 8.0.
- Created Parameter set file to utilize in datastage development.
- Developed various jobs using stages Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages .
- Data Stage stages such as Tera data API, Tera data Enterprise and Tera data Mload used for loading transformed data into Tera data Database (EDW) based on the table type.
- Prepared BTEQ scripts to run before or after the data loaded in Target Tables in order to perform several operations on target tables.
- Extensively used Data Stage Sequencers to place the jobs in sequence to achieve final goal.
- Used Data Stage Director for scheduling the jobs, monitoring the running jobs, compiling the jobs and viewing the job logs.
- Used shared containers for multiple jobs, which have the same business logic.
- Improved performance of a poor performing Data stage jobs and database sql queries.
- Created Shell scripts to automate the data load processes to the target Data Warehouse.
- Used Harvest version control tool to migrate the code from one environment to the other.
Environment: IBM Websphere Information Server-Quality Stage V8.1/Information analyzer8.1, Oracle 10g, Tera data V2R6, Teradata BTEQWIN 6.0, DB2/ UDB 8.0, SQL Assistant, AIX 5.2, Windows 2000
Confidential
ETL Developer
Responsibilities:
- Worked with PE and Midas business user to collect the business requirements to Integrate current system.
- Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
- Extensively worked on loading Star and Snowflake schema tables
- Used Data Stage Manager for importing metadata from different sources and targets into data stage repository.
- Developed jobs in Parallel Extender using different stages like Transformer, Remove Duplicates, Sort, Join, Merge, Lookup, Data Set, Funnel, Copy, Modify, Filter, Change Data Capture.
- Extensively worked with Data Stage Job Sequencer to Control and Execute DataStage Jobs and Job Sequences using various Activities and Triggers.
- Developed Data stage jobs using Complexflat file stage to transform mainframe data from EBCDIC to ASC.
- Worked with copy books to import metadata from IMS system.
- Simplify the Data stage design, and used it as a common job component through out the project.
- Used the Data Stage Director and its run-time engine to Schedule running the solution, Testing and Debugging its components, and Monitoring the resulting executable versions.
- Involved in writing Autosys Jils for Box jobs as well as cmd jobs.
Environment: Data Stage 7.5 (Manager, Designer, Director, Manager),Profile stage 7.5, DB2 UDB V8.0, Autosys, UNIX-Aix, Clear case, Clear quest, Windows NT 4.0
Confidential
ETL Production Support Analyst
Responsibilities:
- Analyzed Business Requirements by working closely with Business Area experts.
- Involved in tracking defects in ETL jobs and proposed solutions to Development team.
- Involved in writing Autosys jobs, JIL file for Box as well as cmd jobs.
- Created run books for job information which is scheduled on Autosys
- Involved in finding production status by using Autosys commands.
- Worked with Clear case for version controlling.
- Worked with Clear quest and Remedy support to track defects.
- Modified existing Unix Scripts to meet the requirements.
- Worked with DBA’s to tune SQL scripts for performance.
- Involved in tracking the status of Java(J2EE) build Amortization Engine.
- Interacted with UNIX support group to resolve server issues.
- Involved in Documenting Monthly runs for
- Worked as Technical Analyst in FAS 91-production support team
Environment: Abinitio1.14, Oracle 10g, SQL Server 2000, AIX, Windows 2000, Autosys, Clear case, Clear quest, Remedy Support, TOAD.
Confidential
ETL Developer
Responsibilities:
- Analyzed Business Requirements by working closely with Business Area.
- Wrote Controls on Corporate Data warehouse (db2), finance, HR(people soft) databases to match sox compliances.
- Worked on Performance tests and resolve issues to ensure that the jobs can be run without compromise to the monthly close process/production schedule.
- Designed the proto type for new process of Extraction, Transformation and Loading (ETL) using Data stage.
- Extensively used Data Stage Manager for importing complex metadata
- Extensively used Data stage Designer to develop various jobs for Extracting, Cleansing.
- Developed Data stage jobs using Complexflat file stage to transform mainframe data from EBCDIC to ASC.
- Worked with copy books to import metadata from IMS system.
- Created Driver Tables to run Controls against Corporate Data warehouse tables.
- Developed SAS Ready SQL’s to run sql’s with in SAS Engine.
- Created Shell scripts to automate the production process for manually created SQL’s.
- Created Jil files for scheduling the sql's and created Run books for job information.
- Involved in observing the production jobs using autosys.
- Worked with change management tool Clearcase for version controlling.
- Worked as deployer to migrate the jobs to different Environments.
Environment: Data stage 7.5,DB2UDB 8.0, IMS/OS390,Sybase, Aix, Window’s 2000,Autosys,Clear case