We provide IT Staff Augmentation Services!

Etl Architect And Onsite Coordinator Resume

OBJECTIVE:

Experienced DW/BI and ETL Architect, Lead and Developer with close to 10+ years of work experience in IT industry with huge exposure in design and development of data warehousing projects. Looking for an ETL/ELT Architect/Lead position in an organization which gives me an opportunity to utilize my leadership, technical and analytical skills to build solutions and deliver expectations thereby can put forth my effective contribution to the organization's growth.

SUMMARY:

  • 10+ Years of Total IT experience in the Analysis, Design, Modeling, Development, Testing and Implementation of Data Warehousing applications.
  • Extensive experience in IBM Datastage versions(9.1/8.x) using components like DataStage Designer, DS Director, DS Administrator, Quality Stage and Information server.
  • Extensive Experience in Informatica Power Center and its components like Repository Manager, Designer, Workflow Manager and Workflow Monitor
  • Extensive Experience in ELT tool Oracle Data Integrator and its components like Topology Manager, Designer, Security Manager, Operator) and the execution agents (Agent).
  • Extensive Experience in Microsoft SSIS and its components.
  • Experience in the implementation of Actimize based AML - CDD, WLF, OFAC and SAM and RCM solutions.
  • Experience in data profiling and data lineage using IBM Information Analyser.
  • Excellent knowledge and experience in Data Warehouse Development life cycle and concepts like ETL, OLAP, OLTP, Dimensional modeling, Repository management and administration.
  • Excellent understanding and experience on Data Cleansing using Datastage, UNIX Shell Scripting and SQL scripting.
  • Involved in Data Modeling using Star Join Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling for OLTP, Enterprise Database Integration and Management among Oracle and MS SQL Server, Database Design (Physical and Logical), Data Administration and Maintenance, Application Support, Performance Tuning, Optimization.
  • Extensive knowledge and experience on Databases like Oracle 11g/10g, SQL Server 2003/2005
  • Extensive knowledge in automation using Unix Shell Script and Jython Scripting.
  • Experience in Data Conversion projects, Data Migration projects and reverse engineering.
  • Experience on scheduling tools like BMC Control-M and Autosys.
  • Extensive Experience in creation of Database objects like Stored Procedures, Functions, Partitioning, Index, scheduling and Triggers in database languages like PL/SQL.
  • Extensive Experience in Working and Design and populated dimensional model (star and snowflake schema) for a Data warehouse and data marts and Reporting Data Sources.
  • Diverse knowledge of data dependencies using Metadata of DataStage, Informatica Oracle Data integrator and preparing job sequences for existing jobs to facilitate scheduling of multiple jobs.
  • Excellent work experience in AGILE project methodology and development.
  • Optimistic Team player with good interpersonal and Co-ordination skills.

TECHNICAL SKILLS:

Operating Systems: UNIX - AIX, Linux, Windows

Databases: Oracle 11g ( Exadata Box) /10g, MS SQL Server

Tools: Visio, Share Point, Putty, Telnet, WINSCP, TOAD, SQL Developer

Scheduling Tools: Control M and Autosys

Programming Languages: PL/SQL, SQL, UNIX/Linux shell scripting, Jython Scripting, Pro *C Programming

ETL Tool: IBM InfoSphere DataStage and Quality Stage (version 11.3, 9.1, 8.5)

Oracle Data Integrator: MS - SQL Server

Integration Services: Informatica Power Center 9.1

Version Control Tools: SVN, Star Team

Profiling and Data Modeling: IBM Information Analyzer (version 11.3), Erwin 4.1.2/3.x

Reporting Tool: Cognos 7/8, OBIEE 10g and SQL Server Reporting Services.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Architect and Onsite Coordinator

Environment:

Database: Oracle 11g (Exadata)

Technologies: Actimize AML, Fraud and RCM.

Tools: IBM InfoSphere DataStage and Quality Stage, IBM Information Analyzer, Star Team, Erwin, OBIEE, Serena release control, ACCE - Autosys migration

Responsibilities:

  • Involved in Release Planning, Business Requirement gathering, mapping document review, Technical Design development & review meetings along with Business Analyst and QA team.
  • Perform ETL design, data architecture, data management and data analyze.
  • Provide planning, estimation, scheduling, prioritization and coordination of technical activities related to system development
  • Manage the technical delivery of medium to large, moderately complex projects on-time, on-budget and with targeted zero defects
  • Ensure system alignment to Enterprise Architecture policies and best practices also ensure that process methodologies are followed in system development
  • Oversee creation and approval of technical documentation including the Solution Definition document and Technical Design document; ensure documentation is aligned to the Functional Requirements and uses document templates that meet SDLC standards
  • Manage day to day technical challenges and communicate to project manager any risks or issues associated with the development activities
  • Coordinate with offshore on coding and unit testing phases of system development and facilitate Code Reviews.
  • Identify opportunities for system reuse and system simplification.
  • Developed the Datastage jobs, PL/SQL, and UNIX scripting to have a more flexible ETL code.

Confidential

ETL Lead

Environment:

Database: Oracle 11g

Tools: Informatica 9, .Net and Erwin

Responsibilities:

  • Understand the requirement from Data Modelers, business analysts and excel-based model that is currently being used by management team.
  • Developed and implemented ETL Process using the ABaC Framework/Solution and ETL Dashboard to audit, reconciliation, job control, report generation, error handling and notification.
  • Involved in designing of Rule base engine architecture for excel-based model.
  • Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
  • Created technical specification documents based on the requirements.
  • Created the High-level design documents and Low level design documents based on requirements.
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and data warehouse.
  • Develop code as per the coding standards and coordinate with Data Integration and ETL Technologies group.
  • Developed the PL/SQL to have a more flexible ETL code.
  • Prepared test Scenarios and Test cases and involved in unit testing of mappings, system testing and user acceptance testing.
  • Tuning ETL Process and SQL with ability to maximize data flow and minimize time and hardware resources.
  • Involved in setting up for Development, Test, UAT and Production environment
  • Involved in code migration from development environment to QA and PROD.
  • Played as Lead and architect to guide ETL team and fill functional gaps.

Confidential

ETL Senior Developer/ Lead and Onsite Coordinator

Environment:

Database: Oracle 11g (Exadata)

Technologies: UNIX Shell Scripting, Perl Scripting

Programming language: PL/SQL, Pro- C Programming, Perl Scripts

Tools: Informatica 9, Control - M, SAS, Erwin

Responsibilities:

  • Gathering requirement from business analysts, understand process and data flow from various source system teams, create mapping documents for ETL systems and reports.
  • Involved in environment setup of DEV, UAT and Production.
  • Administered the repository by creating folders and logins for the group members and assigning necessary privileges.
  • Prepared ETL standards, Naming conventions and wrote ETL flow documentation
  • Created technical specification documents and mapping document based on the requirements
  • Created of High level design documents and Low level design documents.
  • Developed and implemented ABaC framework to supports heterogeneous sources to handle data issues providing data integrity, validation, accuracy, trending, alerts and reports.
  • Implemented the approaches to automate the Control-M jobs, migration of the existing data from CDW to EDW, Extraction Transform and Loading logic which includes Rejection, Re-processing, and Error handling for delta load.
  • Developed ETL mapping to Extraction, Transformation and Loading of EDW and report mart tables using Informatica and Stored Procedure.
  • Developed the PL/SQL, Pro-C programming, Perl Scripts, and UNIX scripting to have a more flexible ETL code.
  • Implemented the automation process for Code migration from Development to UAT and production environment.
  • Involved in System Integration testing of EDW tables and report mart tables.
  • Prepared test Scenarios and Test cases and involved in unit testing of mappings, system testing and user acceptance testing.
  • Mentor the Confidential and SingTel team members by providing technical and functional assistance on environment.
  • Provided support for all the EDW jobs on warranty period and fine-tuned the mappings and stored procedures.
  • Maintain the database for the entire environments still handover to client support team.

Confidential

ETL Developer

Environment:

Database: Oracle 10g/11g

Technologies: UNIX Shell Scripting, Jython Scripting, Perl Scripting and Java

Programming language: PL/SQL

Tools: Oracle Data Integrator, OBIEE

Responsibilities:

  • Working with business users and business analyst for requirements gathering and business analysis.
  • Design and developed ODI mappings and Scenario to load warehouse from different sources system like E-BAO, MDM, Oracle Finance and CRM.
  • Design and Developed the ABaC Frameworks to supports heterogeneous sources to handle data issues providing data integrity, validation, accuracy, trending, alerts and reports.
  • Design and Developed the ETL Scheduler to schedule the ETL packages and report generations.
  • Design and Developed the ETL Dashboard to identify memory usage, object dependencies storage availability, long running jobs, failure details and log details.
  • Developed the PL/SQL, Jython Scripts and UNIX scripting to have a more flexible ETL code.
  • Customizing Oracle Data Integrator - Knowledge management for Extract and loading data.
  • Created technical specification documents based on the requirements.
  • Involved in the preparation of High level design documents and Low level design documents.
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and data warehouse.
  • Prepared ETL standards, Mapping Document, Naming conventions and wrote ETL flow documentation for Stage, ODS and data warehouse.
  • Involved in the preparation of test case and defect log documents for mappings.
  • Involved in Design and Development of Operational reports, IRDA (Insurance Regulatory Development Authority) reports, Dashboards and Analytics using OBIEE.
  • Optimize and enhance long running ETL packages, develop ETL packages and reports as per requirement.
  • Taking care of setting up for Development, Test, UAT and Production environment.

Confidential

ETL Developer

Environment:

Database: SQL Server 2005

Tools: SSIS, SSRS and Business Objects

Responsibilities:

  • Working with business analyst for requirements gathering and business analysis.
  • Converted business requirement into high level and low level design.
  • Created SSIS Packages to extract data from Excel Files, MS Access files and SQL server 2005 Database to generate data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Developed ETL process for Audit, Reconciliation, Error handling and Customizable Notification.
  • Developed the SSIS mappings, SQL Server Stored Procedures and SQL server views.
  • Involved in preparation of unit test case, technical specification and error handling document.
  • Unit testing to ensure the development as per the business functional.

Confidential

ETL Developer

Environment:

Database: Oracle 10g

Technologies: UNIX Shell Scripting

Programming language: PL/SQL

Tools: Informatica, Crontab scheduler.

Responsibilities:

  • Involved in studying of existing system.
  • Developed UNIX Scripts to automate the ETL process for Reconciliation, Error handling and Customizable Notification.
  • Developed UNIX Scripts and PL/SQL procedures to have more flexible ETL code.
  • Developed the automated process to schedule the Informatica jobs using the Crontab UNIX scheduler.
  • Need to prepare unit test case, technical specification and error handling document.
  • Provided to teammates in UNIX and Perl Scripting.
  • Performed Unit Testing and ensure the development as per the standards.

Confidential

ETL Developer

Environment:

Database: SQL Server 2003

Tools: SSIS and Cognos 8

Responsibilities:

  • Worked with business analyst to understand the Business logic.
  • Created SSIS Packages and mappings to extract data from Excel Files, MS Access files and Semi structured data and SQL server 2005 Database to data warehouse.
  • Developed Cognos framework model, Reports, Dashboards and Analytics.
  • Developed ETL process for Audit, Reconciliation and Error handling.
  • Taking care of code migration from development environment to QA environment.
  • Need to prepare unit test case, technical specification and error handling document.
  • Performed Unit Testing and tuned for better performance.
  • Unit testing to ensure the development as per the business functional.

Hire Now