Ibm Datastage Lead Consultant Resume
Lynchburg, VA
SUMMARY:
- Over 12 years of extensive experience in design, development and implementation in the fields of data warehousing (Building EDW, data migration, data conversion and data integration) and developing Client server application using IBM Info Sphere Information Server/Ascential Data Stage 11.x/9.x/8.x/7.x) And experienced in IBM Mainframes with excellent skills on COBOL, JCL, VSAM, and DB2.
- 7 + years of experience in design, development and implementation of applications using variety of data warehousing tools with proficiency in IBM Info Sphere Information Server/Ascential Data Stage 11.x/9.x/8.x/7.x)
- 5 + Years of solid experience in Analysis, Estimation, Design, Development, Maintenance, Coding, testing, documentation, quality assurance and implementation of Mainframe applications on full life cycle projects using VS - COBOL II CICS, DB2,CLIST,VSAM,JCL
- Extensive experience in requirements gathering, design and development.
- Developed, implemented and supported complex extraction, transformation, and load (ETL) processes.
- Developed ETL Mappings, ETL functional and Technical documents.
- Data warehousing techniques for data cleansing, slowly changing dimension phenomenon, surrogate key assignment.
- Proficiency in data warehousing techniques for data cleansing, Data Analysis, Data Lineage & Reconciliation Surrogate key assignment and CDC (change Data Capture)
- Writing UNIX Shell scripts for performing file validations and job scheduling on various flavors of UNIX.
- Data modeling(ER, LDM, PDM) and creation of Star Schema and Snowflake dimensional data marts using ERWIN/IBM Data Architect tools.
- Expertise in using advanced Data Stage plug in stages like Web services, XML Read, XML Write.
- Worked on various Projects with Water fall /Agile/Scrum methodologies
- Extensively used Teradata utilities like Multiload, Fast load and Fast Export.
- Good experience on running Bteq scripts for loading data in Teradata
- Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE
- Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports)
TECHNICAL SKILLS:
ETL Tools: IBM Info Sphere/Ascential Data Stage 11.X,9.X/8.x/7.x, Enterprise Edition, (Designer, Director, Information Analyzer, Business Glossary, Metadata Work Bench, Fast Track), Informatica 7.1, SSIS
Databases: IBM Pure Data Analytics(Netezza), Oracle 11g,10g, 9i, 8i, SQL Server 2012, DB2 UDB 8.1, MS Access, Sybase, Teradata
Data Modeling Tools: ER Win 4.0, IDA (Infosphere Data Architect)
Programming Languages: UNIX Shell Scripting, C++, SQL, PL/SQL, COBOL,CICS,JCL, ASP.Net, C#Database Tools: Aginity,SQL Assistant,TOAD, SQL Developer
Reporting Tools: Cognos, OBIEE, SSRS, Power BI
PROFESSIONAL EXPERIENCE:
Confidential, Lynchburg, VA
IBM Datastage Lead Consultant
Key Responsibilities:
- Building the Enterprise Data Warehouse (EDW) as per IBM UDMH Dimensional model which source the data from McKesson Star and Horizon Clinical Integration systems.
- Integrate the data to Enterprise Data Warehouse from different source systems like Emergency Department, Clinical, and Ambulatory etc.
- Perform source system analysis, identification of key data issues, data profiling, and development of normalized and star-snowflake physical schemas.
- ETL design, development, optimization, and support, create and implements scheduling strategy, and develop error handling processes.
- Responsible for contributing technical functional design, coding, testing and implementation.
- Lead and guide development of an IBM Infosphere Information Server Data stage based ETL architecture.
- Implement an IBM Infosphere Information Server Data stage based ETL solution fulfilling stringent performance requirements.
- Designing ETL Parallel jobs incorporating complex transform methodologies using IBM Infosphere Information Server Data Stage tool resulting in development of efficient interfaces between source and target systems.
- Perform as active, leading role in shaping and enhancing overall IBM Infosphere Information Server Data stage architecture.
- Identify, recommend and implement ETL process and architecture improvements.
- Assist and verify design of solution and production of all design phase deliverables.
- Providing effort complexity and Estimates depending on the design. coordinating with client managers, business architects and data architects for various sign offs on data models, ETL design documents, testing documents, migrations and end user review specifications.
Environment: IBM Info Sphere Data Stage Enterprise Edition 11.5, Oracle 11g, Netezza, Linux, PL/SQL, Aginity, Subversion, Power BI, Sqlserver 2012, IBM Workload Scheduler
Confidential, Carrollton TX
IBM Datastage Lead Consultant
Key Responsibilities:
- Analyzed and converted functional requirements to detailed ETL Source to Target (STM) Mapping documents
- Worked with Senior Architect and made changes to the existing design, developed the data stage parallel jobs
- Analyzed, designed, developed and test the code in DataStage 11.3
- Used SAP BW Open hub stage, ODBC Connector stages for Extracting the SAP BW data
- Used HDFS Connector stage to load the data in to Hadoop
- Developed Incremental, full load jobs
- Technical walk thru the code created by team members and mentor them
- Keep project sponsors up to date with project movement as per defined timeline
- Converting functional requirements to detailed ETL technical design specs.
- Designing ETL Parallel jobs incorporating complex transform methodologies using DataStage tool resulting in development of efficient interfaces between source and target systems.
- Customizing the Datastage Parallel jobs as per current business enhancements.
- Writing UNIX scripts for running and validating the job.
Environment: IBM Info Sphere Data Stage Enterprise Edition 11.3, SAP BW HANA, Oracle 11g, Linux, PL/SQL, TOAD,Hadoop HDFS, HIVE, Subversion
Confidential, Dallas, TX
IBM Datastage Lead Consultant
Key Responsibilities:
- Lead the Offshore team and support production application.
- Work with team to deliver the complete DWH solution on timely manner.
- Analyzing and converting functional requirements to detailed ETL Source to Target (STM) Mapping documents
- Working with data modeler and make changes to the existing mapping documents and export & import Mapping Specifications in Fast track
- Analyze, design, develop and test the code in Unix shell scripting, SQL queries (Netezza, Sqlserver) and DataStage 11.3.
- Used Netezza Connector stage for doing loads into Netezza Database.
- Work with QA Lead to ensure formal QA/UAT acceptance on test plans
- Coordinate with release management for detail implementation and rollback activities in Production environment and supported production application
- Technical walk thru the code created by team members and mentor them
- Keep project sponsors up to date with project movement as per defined timeline
- Converting functional requirements to detailed ETL technical design specs.
- Designing ETL Parallel jobs incorporating complex transform methodologies using DataStage tool resulting in development of efficient interfaces between source and target systems.
- Customizing the Datastage Parallel jobs as per current business enhancements.
- Writing UNIX scripts for running and validating the job.
Environment: IBM Info Sphere Data Stage Enterprise Edition 11.3, Netezza, Sql Server 2012, Informix, Linux, PL/SQL, IBM MDM,Aginity,Citrix,IBM Fast track
Confidential, Austin TX
Sr Datastage Developer
Key Responsibilities:
- Analyzing and converting functional requirements to detailed ETL Mapping Documents.
- Unit Testing of data stage components
- Experience in implementing Netezza, DB2, DB2/UDB, Oracle, SQL Server, PL/SQL, and SQL*Plus database applications.
- Providing effort complexity. Estimates depending on the design
- Co-coordinating with client managers, business architects and data architects for various sign offs
- Data stage 8.5 used to transform a variety of financial transaction files from legacy platform to DB2.
- Configured the DB2 tables in IDEP (Info sphere Data Event Publisher)
- Made the changes to existing data model using Info Sphere Data Architect(IDA) tool
- Optimizing the Queries for maximum performance.
- Worked with stages like MQ,Transformer, Aggregator, Sort, Join, Lookup, and DTS(Distributed Transaction Stage)
- Developed Datastage Parallel jobs with WISD, XML input and XML output stages
- Used Web Services Client stage for data retrieval
- Identifying the Data Lineage
- Used the Information services director to monitor the web services jobs (WISD)
Environment: IBM Info Sphere Data Stage Enterprise Edition 8.7, Infosphere Data Architect, IBM DB2, ADABAS, JCL, Sequential Files, Webservices,AIX, IBM Mainframe, Tivoli
Confidential, Bentonville, AR
Sr Datastage Consultant
Key Responsibilities:
- Business requirements gathering.
- Converting functional requirements to detailed ETL technical designs (Low level design).
- Designing ETL Parallel jobs incorporating complex transform methodologies using Data Stage tool resulting in development of efficient interfaces between source and target systems.
- Providing effort complexity. Estimates depending on the design
- Involved in the migration of the jobs from DB2 to Netezza.
- Co-coordinating with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.
- Leading the Data stage & Mainframe Offshore teams.
- Used different routines extensively for conversion related tasks.
- Optimizing the QMF Queries for maximum performance.
- Working with stages like Z/os, Complex Flat File, and Transformer, Aggregator, Sort, Join, Lookup, and Data masking pack.
- Extensively worked on different transformations Viz Source Qualifier, Expression Filter, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner, Router, Aggregator Transformation and SQL override.
- Improved the productivity of project involving data transfer and/or transformation like migration, installation of packages, and construction of secured databases for the Internet, installation of data warehouse and data marts, and synchronization of heterogeneous applications using Oracle Data Integrator (ODI).
- Implemented Oracle Data Integrator and architected the ODI interface
- Extracted, Transferred, and loaded data from SAP R/3 system using SAP Plug-ins (BW Open Hub Extract, IDOC EXTRACT, and IDOC LOAD)
- Support the Datastage Parallel jobs which are used to extract the data from SAP BW and Files as sources
Environment: IBM Info Sphere Data Stage Enterprise Edition 8.5, IBM DB2, Teradata, QMF, VSAM, JCL, Sequential Files, CA7 scheduler, UNIX, Windows XP, IBM Mainframe,ODI,OBIEE
Confidential, Dallas, TX
Sr Data Stage developer
Key Responsibilities:
- Business requirements gathering.
- Designing ETL Parallel jobs incorporating complex transform methodologies using Data Stage tool resulting in development of efficient interfaces between source and target systems.
- Providing effort complexity. Estimates depending on the design
- Co-coordinating with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.
- Interaction with Offshore team
- Strong experience with converting data sets from EBCDIC to ASCII.
- Involved in creating documentation for conversion and migration related processes.
- Preparing the Data Lineage documents and Source to Target (STM) Mapping documents
- Data stage 8.5 is using to transform a variety of financial transaction files from different product platforms into standardized data mart.
Environment: IBM Info Sphere Data Stage Enterprise Edition 8.5, IBM DB2, QMF, VSAM, JCL, Sequential Files, UNIX, Windows XP
Confidential, Dallas, TX
Data Stage developer (Contractor)
Responsibilities:
- Provided analysis, coding, testing, production support (maintenance).
- ETL jobs - IBM/Ascential Data Stage (ETL), Server Jobs, Parallel Extender.
- Developed in Oracle 10g PL/SQL, Oracle Forms and Reports, UNIX Shell scripts.
- Analyzed the client’s requirements.
- Prepared technical specifications.
- Prepared test cases to verify the jobs.
- Worked on Teradata utilities like BTEQ, Multiload, Fast load and Fast Export.
- Performed enhancements to previously developed Shell scripts, Perl scripts.
- Monitored the jobs and resolved the issues of the application.
Environment: Data Stage 8.1, Information Analyzer, Business Glossary, IBM AIX, Oracle 10g, Teradata, XML, Sequential files, PL/SQL, Oracle SQL Developer, SQL*Plus, Control-M, Windows XP
Confidential
Software Consultant
Key Responsibilities:
- Business requirements gathering -Lease Management.
- Converted functional requirements to detailed ETL technical design specs.
- Created standard templates for efforts estimations, unit / system / integration / UAT / production testing docs and delivery process reviews/checklists.
- Data modeling and creation of Star Schema data marts using ERWIN tool.
- Designed ETL jobs incorporating complex transform methodologies using DataStage tool resulting in development of efficient interfaces between source and target systems.
- Customized the DataStage jobs par with current business enhancements.
- Wrote UNIX scripts for running and validating the job.
- Scheduled staging, dimension (common, global and local) and fact jobs both on onetime / daily and on on-demand basis across all the EMP mart financial modules.
- Followed up deployment process of DataStage code migration on different environments (development, test and production) with admin team.
- Co-coordinated with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.
Environment: IBM WebSphere DataStage Enterprise Edition 7.5.1, Sql Server 2005, Clarity, Microstrategy8i
Confidential, Louisville, KY
Analyst Programmer
Key Responsibilities:
- Participating in the meetings for the collection of business requirements.
- Initial analysis on the requirement based on the high-level design specifications from the clients.
- Preparing the technical specifications and getting it reviewed by the business people for quality assurance.
- Coded the new programs and modified the existing programs in COBOL/MF-Cobol/IMS DB/DC/CICS/VSAM/DB2
- Review the Detail Design document, Traceability Matrix and Unit Test cases for Enhancements
- Performed analysis, coding, unit testing, integration testing, and system testing of modules.
- Responsible in identifying data quality issues
- Used sort, Syncsort, DFSORT, icetool for filtering the data into various formats as per the requirements
- Used XML for Caching, configuration files, parser, xslt.
- Worked on EDI.
- NDM various files from mainframe modify/send it to Client as per the request
- Used Remedy for raising the issues, downloading the documents.
- Coded and tested CLIST, REXX for Batch processing
- Used CA7 and Zeke for scheduling the jobs in mainframe and Unix platform
Environment: TSO/ISPF, Z/OS, Endevor COBOL, MF-Cobol, CICS, JCL, IMS DB/DC, AIX IBM, VSAM, MQSeries, JOBSCAN, File-Aid, CA11, oracle,remedy,insync,Zeke,File-Aid for DB2, IBM UTILITIES,VISIO, Expeditor,MS-WORD AND MS-EXCEL
Confidential, NYC, NY
Software Engineer
Responsibilities:
- Participating in the meetings for the collection of business requirements.
- Responsible for the impact analysis, Estimation, preparing the high level, low-level design document and identifying data quality issues
- Used Xpeditor to debug both online and batch programs.
- Involved in Coding and testing of the modules using COBOL, MF-Cobol, SAS, JCL, CICS, UNIX shell scripting/programming, DB2, VSAM, IMS/DB/DC, SQL
- Used CA7, Control-M and Zeke for scheduling the jobs in mainframe and unix platform
- Used JOBSCAN for validating the JCLS.
- Maintenance of JCLs, PROCs, PARMs and Loads for PACE application
- Create various VSAM clusters and GDG s using File-Manager
- Used SPUFI to retrieve, modify and insert data into test database.
- Write complex queries using SPUFI to perform various operations on database
- Used SAS, InfoPAC and EASYTRIEVE for viewing and for report generation.
- Generated reports using DYL280 based on the requirement
- Preparation, Review and execution of Unit Test Plans, System Test Plan, Unit Test Cases, Integration Test cases, Systems Test cases
Technologies: Z/OS, AIX IBM, Hogan Mainframes,MVS/ESA, HP-Unix,COBOL,MF-Cobol, JCL, DB2, VSAM, IMS DB/DC,FTP, CICS, MQ Series, File-Aid, XML,Syncsort,Control-M, File-Aid
Confidential, Savannah, GA
Software Engineer
Responsibilities:
- Participating in the meetings for the collection of business requirements.
- Initial analysis on the requirement based on the high-level design specifications from the clients.
- Preparing the technical specifications and getting it reviewed by the business people for quality assurance.
- Coded the new programs and modified the existing programs in COBOL/MF-Cobol/IMS DB/DC/CICS/VSAM/DB2
- Review the Detail Design document, Traceability Matrix and Unit Test cases for Enhancements
- Performed analysis, coding, unit testing, integration testing, and system testing of modules.
- Responsible in identifying data quality issues
Technologies: TSO/ISPF, Z/OS, Endevor COBOL, MF-Cobol, CICS, JCL, IMS DB/DC, AIX IBM, VSAM