We provide IT Staff Augmentation Services!

Tech Lead/ Onsite Coordinator Resume

Irving, TexaS

SUMMARY:

  • Over 7+ years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Business Intelligence Applications using IBM Data Stage 8.0.1/7.x, AbInitio (GDE 3.1.7, Co - op 2.14), and Informatica.
  • ETL expertise with excellent exposure to DataStage (8.X), AbInitio (GDE 3.1.7, Co-op 2.14),and informatica in high volume, parallel processingdata environments.
  • Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
  • Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
  • Proven Success as a Tech Lead and cross-organization collaborator, contributing effective and creative Data Integration Solutions.
  • Vast experience in Production Support and Testing
  • Having Hands on experience with agile development methodology.
  • Expertise in Abinitio Coding, shell scripting, designing job flows, scheduling and Teradata queries
  • Designed and Developed the graphs using the GDE, with components like partition by round robin, partition by key, rollup, sort, scan, dedup sort, reformat, join, merge, gather Normalize, concatenate, fuse, continues components,ICFF,XML etc .
  • Handled Batch processing projects and the various NDM/FTP involved to get and send source and target data according to requirement.
  • Worked on creating jobs/jils and scheduling the projects as per requirement in Autosys schedulers.
  • Expertise in ETL Tools: DataStage (8.X), AbInitio (2.14, 3.1.X) and Informatica Power Center 8.5in Linux UNIX and Windows Environments
  • Experience in Teradata (V12, V13) utilities- BTEQ, Fast Load, Multi Load, TPump, TPT, Fast Export and Query Man
  • Having very good experience in implementation of migration projects that include database, UNIX migration to different software and Ab initio version upgrades.
  • Familiar with AbInitio Server (UNIX) Configurations and setup activities
  • Worked with end users and developers to understand the data needs of an application
  • Expertise in dealing global projects involving multi-vendor and multi locations.
  • Proficient in Analyzing Business requirements, Active participation in Business discussions for Requirements Gathering and Data Quality Analysis
  • Excellent Interpersonal Communication skills and Documentation.
  • Worked as Onsite/Offshore Coordinator/Module lead for managing team and delivering the projects handled.

SKILLS/TOOLS:

ETL Tools: AbInitio - Co-op 2.1.4, GDE 3.1.7; IBM InfoSphere DataStage 8.X

Operating System: DOS,UNIX, Linux, Windows 7/XP, 97, Windows Server 2003

RDBMSand Utilities: Teradata V12, v13, BTEQ, TPT, MLoad, FastExport, MSSQL, Oracle9i with emphasis on PL/SQL

Data Modeling: Erwin

Quality Management: HPQualityCenter 10, Clear Quest, Rally

Reporting Tool: Cognos Reporting

Scheduling Tool: Tivoli(OPC), Autosys

Documentation & Collaboration: MS Office, Visio, Share-point, Outlook, Lotus Notes, Open Office

PROFESSIONAL EXPERIENCE:

Confidential, Irving, Texas

Tech Lead/ Onsite Coordinator

Responsibilities:

  • Develop a thorough understanding of business specifications and produce design and code artifacts that meet the specifications
  • Providing Resource, Effort Estimation and planning to the PMO groups
  • Identification of Impacts based on the new requirement in the existing system and identifying the development efforts required
  • Preparation of Detailed level design document based on the requirement and the impacts (if any).
  • Participating in Business Analysis discussion to come up with the ETL Data Mappings
  • Providing Design Specifications and ensure map specifications to the Requirements
  • DevelopingDatastage Jobs, AbInitio graphs to match the Specifications.
  • Guiding team for the daily development effort and conducting regular status meets
  • Implementation of change requests to support the ongoing requirement changes
  • Coordination with Data Modelers & DBAs for DDL changes, to keep in synch the other countries Data warehouse model
  • Involved in Unit/System test plan creation based on the requirement and design document
  • Supporting QA and UAT testing Cycles
  • Coordination with System Testing team and resolving QA & Testing issues/Problems
  • Migrating and deploying the ETL code in QA and UAT environments
  • Preparing job flow and execution order through AutoSys scheduler
  • Testing the schedule in test region
  • Implementation in Production, Parallel support.
  • NDM connectivity and initial project setup
  • Post Implementation support for initial few days
  • Preparing required Documentation, Materials and Support Plans to the Production Support Team
  • Provided production supportuntil the support team as up and ready.

Environment: IBM InfoSphere DataStage 8.X, AbInitio 3.1.4, UNIX, Teradata, Oracle, Autosys, Cognos.

Confidential, Irving, Texas

Senior Developer

Responsibilities:

  • Initial requirement analysis and Impact analysis
  • Understanding the data model, table structure to build in Teradata which is equaling
  • Extensively involved in all the phases of development, right from HLD preparation to Prod support
  • NDM connectivity and initial project setup
  • Preparing ETL mappings required for EDW by coordinating with business analysts
  • Preparing the wrapper scripts as part of ETL Jobs execution
  • Creation of mappings using different types of transformations
  • Development and unit testing of complex graphs
  • Involved in preparation of unit test plans and unit testing
  • Tracking the Test Plan/Test Specification vs. Requirements
  • Coordination with System Testing and User Acceptance Testing teams, resolving QA Testing issues
  • Preparation of materials and operational manuals
  • Migrating and deploying the ETL code in QA and UAT environments
  • Preparing job flow and execution order to schedule the jobs in Auto Sys Scheduler
  • Testing the schedule in test region
  • Implementation in PROD, Prod parallel support
  • Capturing best practices, new leanings and spreading KM and KC awareness within the team
  • Doing production support with the tool Infoman, where the failed job details will be queuing.
  • Participating in code promotion using Service Now tool.

Environment: AbInitio, UNIX, Teradata, Auto SYS, Service Now, Shell Scripting.

Confidential

ETL Developer

Responsibilities:

  • Initial requirements and Impact analysis
  • Create ETL mappings using different types of transformations
  • AbInitio (DW) graphs as per the mappings rules
  • Developed Unix wrapper scripts to run the graph’s deployed Unix scripts
  • Develop Shell Scripts to run the jobs in UNIX environment
  • Involved in preparation of unit test plans and unit testing
  • Tracking the Test Plan/Test Specification vs. Requirements
  • Coordination with System Testing team
  • Support testing cycles, provide code fixes
  • Preparing job flow and execution order through OPC scheduler
  • Testing the schedule in test region
  • Performancemonitor the graphs and tune for the best performance
  • Coordination with the Data Modelers and DBAs for any model changes and implement the DDLs accordingly
  • Preparation of materials and manuals
  • Migrating and deploying the ETL code in QA and UAT environments
  • Implementation and Post Implementation Support

Environment: Ab Initio, Teradata, Unix Shell scripting, SQL, Tivoli Scheduling

Confidential

ETL Developer (AbInitio)

Responsibilities:

  • Initial requirements and Impact analysis for any changes
  • Provide the impact analysis on other product processor, during the new change reqeust
  • Worked on numerous major and minor change requests
  • Developed many reusable graphs and scripts to support Maintenance activities
  • Supported SIT and UAT activities for all the change requests
  • Implementation of the application changes
  • Provide job flow and schedule changes
  • Resolving the QA & Testing issues/Problems with in the time.
  • Involved in preparation of unit test plans and unit testing.
  • Preparation of materials
  • Supporting during QA and UAT testing process .
  • Migrating and deploying the ETL code in UAT and Production environment.

Environment: AbInitio, UNIX, Oracle, Quality Center

Confidential

ETL Developer

Responsibilities:

  • Worked on the role of AbInitio Developer.
  • Involved in migration of all the graphs developed in abinitio 1.14 for NEXTGEN, R2 DW and R4 applications.
  • Unit testing all the Graphs under different applications in new abinitio server.
  • Involved in migration of platform from UNIX to LINUX.
  • Worked in creating the new projects and sandboxes as part of migration.
  • Unit testing all the soft links has deployed properly in new platform.
  • Good Exposure to Sandbox and EME implementation.
  • Worked with multifiles (MFS) as well as serial file Systems.
  • Implemented most of the Sort components.
  • Unit testing the Graphs.
  • Implemented Phasing to avoid deadlocks and proper data loading.
  • Debugging the Graphs using Check Points and log files.
  • 1Communicating with on-site coordinator to get the requirements.

Environment: Abinitio, DB2, UNIX, Oracle.

Confidential

ETL (Informatica) Developer

Responsibilities:

  • Preparation of detailed design approach for the XPX extraction logic for revenue reconciliation by identifying various components that make up the perfect design
  • Designed various mappings for extracting data from various relational tables in Kenan customer and admin Databases
  • Different transformations used: Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Sorter Transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
  • Created Sessions, workflows and mapplets with reusable transformations

Environment: Informatica, UNIX, Oracle, Shell scripting

Confidential

Developer

Responsibilities:

  • Support the System Testing Team while ST and UAT and provided the required clarifications and solutions for smooth Production Roll-out.
  • Provided the analysis for many Bugs and flaws and fixed it within less time to make sure it won't impact the large group of customers.
  • Provided the Guidance and support to the team while doing the analysis and in bug fixing.
  • Having Discussion for the Solutions, Fixes and impact analysis with Team and Onsite Counterpart.

Environment: C++, UNIX, Oracle, Shell scripting

Hire Now