We provide IT Staff Augmentation Services!

Sr Datawarehouse Developer/analyst Resume

4.00 Rating

New York, NY

SUMMARY

  • 10 Years of experience in Analysis, Modeling, Design, Coding, Testing and Production support in Enterprise Data Warehouse, Data Migration and Client Server Applications. Currently working as a Senior Datastage/Data warehouse Developer, specialized in developing jobs using ETL tool IBM Datastage Versions (7.5.x, 8.x).
  • Worked in Data modeling with tools Erwin, Enterprise Architect. Experience in executing and implementing Datastage/SAP implementation projects, performance tune in ETL tool IBM Datastage as part of various projects executed for major clients across US.
  • Strong background with ETL Design and coding for Data loading, Data cleansing, Data Validation and Data Integration for enterprise data migration systems.
  • Architect, Design and Build common re - usable ETL components to define audit processes and capture DQ exceptions, Job monitoring and ETL logging processes.
  • Create Source to target mapping (ETL Mapping) from various source systems into target EDW (Enterprise Data warehouse) detailed design documents.
  • Specializes in logical and physical data modeling, data architecture, data analysis, data mapping, data conversion, data integration, database design, business analysis, data quality analysis, functional design and different aspects of data/information management.
  • Extensive experience interacting with cross-functional, global teams and communicating project information to multiple levels in an organization.
  • Handles complex systems, project integration, and technical designs. Possesses design, plan, and team coordination expertise.
  • Works directly with clients and management to resolve conflicts and issues that may arise. Has worked extensively with SQL, including performing query optimizations.
  • Possesses strong mentoring ability. Has ETL Design/Implementation experience. Quick learner, detail oriented and quality conscious. Industries/areas worked in include: Retail, financial, banking, utilities, pharmaceutical, health care and insurance
  • Working as part of EPM solution team at Infosys providing various DW-BI solutions to various clients across US. In process gained strong domain knowledge and process practice.
  • Participate in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.
  • Perform data profiling and identify possible data quality issues in the EDW.
  • Design and Develop ETL (Datastage PX) jobs to Extract, Transform and load Enterprise Data warehouse.
  • Create Data Standards and Practices document, Data Dictionary.
  • Create Logical, Physical data models to ensure an information system to be useful, reliable and adaptable.
  • Create ETL processes to ensure data integrity (error handling) and document appropriate procedures.
  • Document processes necessary to maintain and expand the ETL processes to support future Needs
  • Expert in using SAP R/3 Pack 6.5.x in Datastage for SAP Implementation
  • Expertise in Implementation of SQL queries, PL/SQL packages, stored procedures, functions and triggers using Oracle SQL.
  • Expertise in using UNIX shell scripts with Datastage.
  • Expertise in FTP process using UNIX shell scripts.
  • Expertise in using SAP interfacing stages in Datastage 7.5.x,8.x.
  • Expertise in using External Source, XML input and Output Stages.
  • Expertise in working with Websphere MQ connector stages and MQs in DataStage 7.5.x, 8.x.
  • Knowledge in creating Inbound/Outbound interfaces in SAP PI.
  • Knowledge & Experience in creating BIRS, DRS, Bex Reports in SAP BI.
  • Experience in understanding/debugging SAP package errors due to Idoc, Bapi and Abap.
  • Extensive Experience in creating/implementing one-time/ongoing Conversions/Interfaces to SAP
  • Experience resolving workflow issues in SAP Document Management/ Records Management in Energy and Utilities sector.
  • Experience and exposure to installation and configuration of Datastage, SAP R/3 Packs,GnuPG
  • Write System test cases and perform system and integration testing.
  • Experience in writing UNIX scripts, Windows Batch Scripts, Basic routines, Job Control and Control-M scheduling.
  • Expertise in defining the ETL Integration architecture, development of best of breed ETL environment,defining and implementing ETL Methodology, designing, defining, creating and implementing ETL components, mentoring the ETL team and troubleshooting integration issues.
  • Expertise in handling Data sources likes Oracle, DB2 UDB.
  • Good analysis skills, able to work independently or in a team environment and a self-motivated learner.

TECHNICAL SKILLS

ETL Tools: IBM Data stage (Parallel Extender/Server) 8.x, 7.5.x, SAP R/3 6.5.x Pack for Datastage, Knowledge on Quality Stage, DTS, SSIS, Informatica and Ab Initio

Languages: PL/SQL, SQL, UNIX Shell Script, Windows Batch Script.

ERP: SAP R/3, SAP BI, SAP Document/Record Management

Data Modeling Tools: Erwin Data Modeler r7, Enterprise Architect, Microsoft Visio

Databases: Oracle 9i, SQL Server 2000, 2005 (Yukon), DB2, MS Access

Other Tools /Web Scheduling Tool: TOAD, MS-VSS, XML, Autosys 4.5, CronTab, UC4, HP Quality Centre, Mercury, GnuPG

Environment: AIX UNIX 5.2, Windows 98, Me, XP

Methodologies: Data Modeling, ER Modeling, CIM Modeling.

Reporting Tools: Actuate Crystal Reports, Bex Reports, and SSRS.

Project Management: Microsoft Project Plan

PROFESSIONAL EXPERIENCE

Confidential

Sr Datawarehouse Developer/Analyst

Responsibilities:

  • Implement integration of multiple ERP systems (JD Edwards, SAP ) using Datastage 8.1
  • Implementation using IDOC,BAPI stages
  • Periodical Maintenance of the Development & Production environments which involves Server bounce, Log clean up, Performance Tuning of the Jobs using pipeline partition and parallelism.
  • Define Best Practices/Technical Review of the Code/Functional Testing at various stages in the SDLC process
  • Automate Quotas and Commissions for Sales Force

Environment: IBM DataStage 8.1, Unix, SAP R/3 Pack 6.5.x, DB2, Sql Server

Confidential, New York, NY

Sr DataStage Developer

Responsibilities:

  • Thorough review of Functional Specifications, Draft Technical specifications to implement Interfaces using Datastage
  • Install/Configure SAP Pack 6.5.x
  • Implementation of SAP using ABAP,IDOC,BAPI stages
  • Extraction, Transformation and Load of data from source systems with Secure FTP,SAP,Sql Server,XML
  • Creation of Windows Batch Scripts to automate the schedule of DataStage jobs.
  • Performance Tuning of the Jobs using pipeline partition and parallelism.
  • Periodical Maintenance of the Development & Production environments which involves Server bounce and Log clean up.
  • Define Best Practices/Technical Review of the Code/Functional Testing at various stages in the SDLC process

Environment: IBM DataStage 8.1, Windows 2000, SAP R/3 Pack 6.5.x

Confidential, Peapack, NJ

Sr DataStage/Data warehouse Developer

Responsibilities:

  • Design of Server and Parallel jobs using the DataStage Enterprise Edition.
  • Development of Control Batches using DS Routines to call a series of DataStage jobs and shell scripts.
  • Creation of different Database Objects like Triggers, Stored Procedures, Cursors and Packages to perform data overrides/updates after loading the Fact tables.
  • Implementation of Change Data Capture using the IBM Live Audit tool.
  • Conversion of Server jobs to Parallel jobs to improve performance.
  • Extraction, Transformation and Load of data from source systems which include AS400, SAP BI and SQL Server.
  • Build Reports and Cubes using SQL Server Reporting Services & Analysis Services.
  • Creation of Logical and Physical Data Models using Erwin Data Modeler.
  • Creation of Shell Scripts to automate the schedule of DataStage jobs.
  • Performance Tuning of the Jobs and Oracle Scripts by making use of the right stages and apt combination of indexes and partitions.
  • Periodical Maintenance of the Development & Production environments which involves Server bounce and Log clean up.
  • Migration of Jobs from DataStage 6.0 to DataStage Enterprise Edition.
  • Technical Review of the Code before the changes gets migrated to Production.
  • Provide Level 3 Support for critical production issues.

Environment: IBM DataStage 7.5.3/8.1, AIX 5.3, LINUX, Microsoft SSRS,UC4, CronTab

Confidential, San Francisco, CA

Sr DataStage Analyst/Developer

Responsibilities:

  • Requirement gathering and analysis
  • Designing ETL architecture
  • Format Transactions to XML in conformance with ESB and message them to remote Queue using MQ plug-in
  • Designing integration between ETL and ESB Server
  • Designing the rules for Item Master Staging Data
  • Actively performing the System Integration testing tasks involving whole team
  • Preparing Implementation plans/co-ordination, implementation for the phased release
  • Collecting the job statistics using common components
  • Understanding Retail Domain, Item Master Application.

Environment: IBM DataStage 7.5.3, AIX 5.3, ESP Scheduler, MPP

Confidential, San Onofre, CA

Sr Systems Analyst

Responsibilities:

  • There is need to improve the workflow system in SAP at SONGS and I have been involved in Continuous Improvement of the Workflow system in SAP Document Management system
  • Involved in setting up application and environment. Involved in gathering Business Requirement and Requirement analysis.
  • Involved in creating Functional Design specifications for Conversions and Interfaces to DM/RM.
  • Involved in creating Technical Design specifications for Conversions and Interfaces to DM/RM.
  • Involved in Coordinating Legacy team with ERP team to understand the best solutions for Conversions and Interfaces. Provide technical and architectural support to the team.
  • Primarily involved in Production support, technical reviews and troubleshooting of objects.
  • Expertise in using SAP R/3 stages like ABAP, BAPI and IDOC. Role of Senior Systems Analyst.

Environment: Datastage 7.5.x, SAP DM/RM, SAP BI.

Confidential, New York, NY

Data Analyst

Responsibilities:

  • Define Source Data Maintenance Procedures. Determine data sources for Business Rules. Create Data Dictionary, Data Standards and Practices documents.
  • Create the Logical, Physical model for OSS. Define Application Data Model. Define Asset/Equipment interfaces Data Model. Define system Interfaces Data Model.
  • Create Solution Data Model. Develop Data Migration/ Data Mapping documents. Identify list of fields for Reports, Adhoc Queries.

Environment: Erwin Data Modeler r7, Enterprise Architect, Microsoft Visio 2007, Sql Server 2000,Sql Plus.

Confidential, Irwindale, CA

ETL Development Lead

Responsibilities:

  • Designing the base architecture for the application. Involved in setting up application and environment. Involved in designing Unix shell scripts and use them in Datastage.
  • Requirement analysis and gathering Provide technical and architectural support to the team. Primarily involved in job design, technical reviews and troubleshooting of objects.
  • Involved in resource planning, scheduling and tracking, effort estimation Expertise in using SAP R/3 stages like ABAP, BAPI and IDOC.
  • Expertise in using XML to extract data from XML document, importing XML Metadata Expertise in using XML to generate target XML files. Role of technical architect.

Environment: IBM Datastage 7.5.1., AIX, SAP, XML, Datastage Version Control, AQT

Confidential, Lake Forest, CA

ETL Senior Developer

Responsibilities:

  • Involved in study of existing operational systems, data modelling and analysis
  • Involved in scope definition, requirements gathering analysis, logical and physical model creation of the database.
  • Involved in preparing Detailed Design, Design Reviews,DB design,performance tuning
  • Performed Project Planning and Tracking using Microsoft project Plan
  • Mapping of business requirements to transformation rules, design, code, test cases, & test results by Preparing and maintaining Requirements Traceability Matrix
  • Preparation of High Level Design, Review of Detail Design for Datastage Jobs
  • Reviewing Datastage Job designs, Refine Guidelines, Check Lists & Test Plans
  • Database redesign to enhance performance and handle huge volume of data.
  • Efficient Onsite-Offshore coordination of ETL developers to deliver design and code in time

Environment: IBM Datastage 7.5.1 on UNIX, Citrix, VSS 6.0, TOAD v8

Confidential, Cypress, CA

ETL Developer

Responsibilities:

  • Involved in design and development of Parallel and Server Jobs.
  • Developed the Technical Design and Unit Test Plans for Projects
  • Created process flow diagrams using Microsoft VISIO.
  • Developed parallel jobs in SMP architecture using Parallel Extender for the speed in performance.
  • Involved in modifying Configuration File for Parallel extender as per number of processors available to process the data by using DataStage Manager.
  • Developed the audit component to ensure the ftp source file has properly landed in the landing zone.
  • Involved in the development of Common Error Management to capture and handle the error records.
  • Developed various user-defined routines in Universe Basic for transformations and validations.
  • Developed various DataStage jobs in Enterprise Edition (parallel Extender).
  • Used various stages like transformer, funnel, lookup, join, merge, remove duplicates, change capture, filter, aggregator etc.
  • Developed job sequencers and implemented restartability using various checkpoints.
  • Extensively worked on Data Stage Director, Data Stage Manager and DataStage Administrator.
  • Used Data Stage Designer for developing various jobs to extract data from different sources and loading data into temp tables for validation testing and Production run.
  • Used Data Stage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
  • Used Data Stage Manager for managing DataStage repository (view and edit), defines custom routines & transforms.

Environment: Ascential DataStage 7.5(parallel Extender), Datastage Version Control, Oracle 9i, SQL Server2000, DB2, TOAD, SQL, PL/SQL, Erwin 4.x, AIX-UNIX 5.2, Microsoft Visio and Windows 2000.

Confidential, Seattle, WA

ETL Developer

Responsibilities:

  • Actively involved in all phases of the project. Involved in the design of the data warehouse, creation of tables and stored procedures using SQL Server.
  • Involved in coding Stored Procedures for the application. Involved in the development of cubes for the above project. Involved in the development of Reports for the above project.
  • Involved in using Integration services for loading data from different sources. Involved in writing Manual Test Cases for the Project.

Environment: DTS, SQL Server 2000

Confidential, New York, NY

Developer

Responsibilities:

  • Actively involved in all phases of the project from requirements gathering to deployment.
  • Developed Rules engine using PL/SQL to do the entire compensation processing.
  • Involved in the design of database schema, creation of tables and stored procedures using Oracle 9i.0 Involved in coding Stored Procedures for the application.

We'd love your feedback!