SUMMARY

• 10 years of experience in Enterprise Data Warehouse (EDW) Implementation, ETL - BI/DW Data Architect.
• 4+ years of experience working as a ETL Data Architect building data warehouse and operational system for very large corporations.
• Extensive experience in building and maintaining Data Warehouses systems using IBM Datastage v8.5/v8.1.x.v7.5 (Administrator, Director, Manager, Designer).
• Extensively worked on building DataStage jobs to process, merge teh data using various stages like Transformer, Modify, Funnel, Join, Merge, Look-up, Pivot etc.
• Experience in creating DDL scripts for Operational Data Store and ETL Source to Target mapping documents. Hands on experience in dimensional modeling - Star schema, Snowflake schema.
• Very good understanding of DataStage Parallel framework, Partition and pipeline parallelism techniques and APT Configuration file.
• Experienced in troubleshooting DataStage jobs, enhancement of jobs and addressing production issues like Performance tuning and Enhancement
• Extensively worked on Oracle 9i, Teradata 12, 13.10, IBM DB2 UDB 8.0/7.0.
• Experience in designing Job Batches and Job Sequences for scheduling Server and Parallel jobs using DataStage Director, UNIX scripts.
• Worked on defining dependency and scheduling DataStage jobs using enterprise-scheduling tools such as Autosys.
• Expertise in writing Teradata SQL, Oracle SQL, Stored Procedures and performance tuning of Teradata queries.
• Worked wif Teradata Load utilities like Multi Load, Fast Load, BTEQ and Fast Export.
• Designed relational and dimensional models for OLTP and OLAP systems. Experience in creating Physical data models and managing metadata information using data modeling tools CA Erwin and ER Studio.
• Driven two Hadoop and seven Data warehousing and one Compliance projects for leading banks in United States of America & Canada.

PROFESSIONAL EXPERIENCE

Confidential, Virginia

ETL DataStage Lead

Responsibilities:

• Played a role of Data Architect working directly wif Business Partner on Data design and sourcing to be able to leverage existing BI capabilities to scale applications for future advance analytics.
• Designing of ETL jobs from end to end independently to read all teh Position, Account from all teh regions from VW Global and populate teh warehouse.
• Developed ETL jobs for DataMart and written reconciliation scripts from Infomart to Datamart
• Involved in enhancement to teh existing jobs as per teh CR request
• Involved in writing functions and triggers in Oracle which will be used across teh application for reconciliation of customer data like telephone number etc.,
• Developed ETL outbound extracts for different downstream like sandbox and Developed Autosys scripts for outbound extracts.
• Given support in production for teh jobs/scripts which we have developed
• Supported to SIT/QA environment. To resolve all teh data related issues and solving teh defects raised by QA team. Code migration between SIT/QA/UAT environments. Preparation of release note to teh production.
• Work wif BA’s to get teh business knowledge and get teh work that that needs to be done.
• Achieving basic validations on teh source systems and achieving intermediate tasks using Unix Shell scripting and testing of teh artifacts and development of Parallel Jobs.
• Designing, developing and implementation of Metadata driven framework wif Multi-Time zone source integrations, Staging, Homogenization, Error and Audit process, SCD-1, SCD-2, Surrogate keys generations, variable frequency loading by handling Late Arriving Dimensions.
• Source system analysis, data analysis, analysis of integration between modules, analysis of business sense of source entities and relationships.

Confidential

Senior ETL DataStage Consultant

Responsibilities:

• Interview stakeholders, understand teh business requirement and scope of teh projects to direct Data teams on future ready architecture designs.
• Identify repeated data transformations and processes to narrow teh process streams like batch processing, message processing.
• Conceptualized and designed teh solution framework for teh use-case and evolve wif KPIs for measuring ROI by doing event data analysis to keep a check on various business metrics which includes teh performance of teh marketing team.
• Responsible for migration of EDW applications from their old system to new system besides incorporating minor enhancements to teh applications.
• Analysis of existing applications - its High level design, UNIX, Database and ETL components to be converted, downstream and upstream application dependencies.
• Identification of potential dependency issues, suggesting a suitable road map to migrate applications to minimize dependency conflicts and workarounds.
• Tuning teh Teradata queries as part of dis migration. Resolved teh formatting issues in Teradata that are not matching after data comparison
• Documenting teh findings, mentoring my team to perform code conversion and testing besides participating in teh same.
• Application code conversion which included UNIX and Autosys script changes to point to new system and environment. Post production support and stabilization.
• Coordination wif various teams to perform and validate Production parallel runs between old and new applications followed by Signoff.

Confidential, Cincinnati, Ohio

Big Data Architect/Supervisor, Analyst & Designer

Responsibilities:

• Implemented Account Based Costing (ABC) techniques and reveal actions to decision makers which can be taken to increase throughput or reduce spending to convert teh savings into increased profits.
• Overseeing a team of 35 and ensure timely delivery wif highest quality of teh software. Bea backbone for teh baseline team of teh bank and identify tasks that can be automated.
• Develop / Manage functional architecture design requirements wif teh vendor if required, suggest data quality inconsistencies in teh application architecture and method to improvise.
• Create Data Flow Diagrams (DFD) and recommend Data Models suitable for teh environment wif overall Technology Landscape in scope.
• Identified 970 application after Data Lineage for FSLDM migration.
• Estimation of Projects (Hadoop and Data warehouse), preparing Request for Proposals (RFPs), SoWs and brainstorm on architectural design recommendations.
• Create Requirement documents for bringing data from various sources to Operational and MOSAIC Data Warehouse models. Provision of OLTP and OLAP data models.
• Create Logical and Physical data model using ER Studio for operational and data warehouse and get teh design reviewed and approved by teh Data Architect Manager and tan publish and distribute teh changed / new model to various stakeholders and teams.
• Streamline teh design process to provide better design. Introduced more processes to improve teh design standards
• Interacted wif reporting and ETL team to make them understand teh design so that all teh teams can be up to speed to understand teh project.
• Create DDL scripts for teh change for Teradata DB and work wif DBA to create teh tables. Validate teh results and work for production implementation.

Confidential

Solution Architect/Subject Matter Expert/Business

Responsibilities:

• Define, develop and implement all related changes to policies, processes, governance, systems, data and reporting in support of meeting teh BCBS 239 Principals. (RDARR - Compliance)
• Developed and Managed product development plan, manage delivery to teh plan and identify risks in data replication strategies.
• dis project involved in loading data from network dis is used by network operation team. Loading around 200 Billion rows every day. Involved in Database migration (Migraiton CoE).
• Analysis and design of teh client requirement on release to release. Actively participated in tuning teh long running queries. Physical model by using ERWIN tool. Involved in sizing teh database.
• Interact wif all upstream and downstream teams to gather right information to provide accurate and efficient solution.
• Interacted wif reporting and ETL team to make them understand teh design so that all teh teams can be up to speed to understand teh project teh project
• Involved in Dynamic and static partition maintenance on all env.
• Lead, Develop, Design, Implement and act as SME for end-to-end Support for teh Program Creditor Insurance Critical Illness
• Decent experience scheduling (Zeke/Autsys/Cron-tab) and trouble-shoot production issues w.r.t all components of IBM Datastage, migration of code across Dev, Test environments.

Confidential

Software Engineer

Responsibilities:

• Design, build and testing of teh development of Parallel Jobs in Datastage & Qualitystage.
• Achieving basic validations on teh source systems and achieving intermediate tasks using Unix Shell scripting.
• Designing, developing and implementation of various approaches achieving Metadata driven ETL framework wif Multi-Time zone source integrations, Staging, Homogenization, Error and audit process, SCD-1, SCD-2, Surrogate keys generations, variable frequency loading by handling Late Arriving Dimensions.
• Decent experience scheduling (Zeke/Autosys) and troubleshoot production issues w.r.t all components of IBM Datastage, migration of code across Dev, Test and Prod environments.
• Tools & Technologies: Oracle 9i SQL, Datastage8.1, Autosys for Scheduling for Parallel Jobs.