SUMMARY:

Over 18 years of experience in Information Technology as ETL architect/ETL Tech Lead/ ETL Administration / On site - Offshore coordinator / Production support in Data ware house applications, Data Modelling, Metadata Management, Informatica Data quality, Master data, Data Governance in all phases of Software Development Life Cycle / Agile methodology includes Horizon phase, Concept assessment, requirement, analysis, architectural design and development and QA cycle, and Production Implementation and Production Support/maintenance of ETL applications.

TECHNICAL SKILLS:

ETL Tools: Ab initio co>op 3.2.2.5, Ab initio GDE 3.2.1, Metadata hub 3.22.5, Data profiler, Confidential /BRE, DQ Process, Informatica Data Quality 9.5.1(IDQ), Informatica Power Center 9.5, Informatica MDM 9.5.1

Data Modeling Tools: Erwin 3.5/3.5.2, Designer 2000, Rational Rose, S-Designer Data Architect

Hadoop Ecosystem: Hadoop, Map Reduce, HDFS, Hive, Pig, Sqoop, Flume, HIVE, PIG, SQOOP, FLUME, HBASE

Methodologies: Confidential Schema and Snowflake & Kimball Ralph, CDI

OS: Solaris 10, Linux, SunE3500, E250, E10000, HP-Unix 10.1/11.0.1 , Digital Unix4.0.6, AIX4.x, OS/2,OS/390, VMS 5.5,4.5 and Open VMS 6.2, Windows NT/95, and MS-DOS.

Languages: Java, C/C++, SQL, XML, Java Script, EJB, Servlets, COBOL

Databases: Oracle11.2, SQLServer7.0, Sybase, MS-Access, Teradata, Multi load, Fast load, T-Pump, TPT.

Oracle Products: SQL*Plus, SQL*Loader, Net8/Sql*Net, Server Manager and PL/SQL, Developer 2000Designer 2000.

Mainframe Products: COBOL, CICS, VSAM, JCL, FILEAID, INTERTEST, XPEDITOR, ABEND-AID, SPUFI, QMF, FILE-AID, HYPERSTATION

BI Tools: Cognos Impromptu, Power play, Microstratagy, Seagate Analysis, and MS-OLAP Services, Business Objects 5.1 and Business Intelligence 2.1,Brio, and OBIEE

Data Integration Tools: B2B, A2A, EDI

Schedulers: Cron, CA-7, Autosys. Tivoli, Control-M

Database Monitoring Tools: Toad.

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Abinitio Tchnical Lead

Responsibilities:

• Designed Ab Initio import process to extract metadata from various sources like EME, database catalogs, Excel files, and Erwin Data Model xml files and to load into the Abinitio Metadata Hub.
• Supported 8 MDR instances supporting 10K Users.
• Designed and developed metadata import rules to link the technical metadata imported from the database catalogs to the business metadata imported from the Erwin logical data model and excel files.
• Designed and developed Alters and Notifications to the Metadata Business community.
• Developed training documents for the end users about the new COTS product Ab Initio Metadata Hub and responsible for UAT support. upgrade the Metadata hub environments from 3.2.0 to 3.2.2 to 3.2.2.5 to 3.2.6

Confidential, Washington, DC

Responsibilities:

• Involved in the conceptual/Logical data model discussions for the future state.
• Developing data mapping, data dictionaries and metadata documentation.
• Analyzing the data for Transaction Management, Relationship Management, Master Servicing, Securitization, Master Servicing, special servicing and collected events and data objects.
• Involved in Analyzing the use cases and capture Data Elements for Loan Origination process.
• Validate business data objects for accuracy and completeness.
• Involved in Analyzing data for SFC, EUC for Multifamily Target state Business.
• Data analysis by querying PORMF04 (Acquisition, C&D, MFNT, MSFMS).
• Data Analysis by querying database PORMFH06 for ODS.
• Accessing different schemas for LAPROD (C&D), CF (MSFMS), AFKPROD (MFNT), PRP (Property collateral) for analyzing the Special Feature codes.

Confidential, Vienna, VA

Engagement Program Manager/SME

Responsibilities:

• Produced project status reports, managed the team and resolved day-to-day issues.
• Coach, mentor and lead personnel within a technical team environment.
• Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.
• We have used version one enterprise edition to manage Agile Sprint Planning, Sprint Tracking, and Sprint Review
• Proactively involved in creating stories and tasks and back log items for the project work.
• Daily stand up calls with the project team.
• Procure Hardware, software to build the Environments.
• Designed Ab Initio import process to extract metadata from various sources like EME, database catalogs, Excel files, and Erwin Data Model xml files and to load into the Metadata Hub.
• Designed metadata import rules to derive data lineage for important data elements for BASEL II which are ultimately stored in the BASEL data repository which are used for FFIEC(Federal Financial Institutions Examination Council reporting using Ab Initio Metadata Hub.
• Designed and developed metadata import rules to link the technical metadata imported from the database catalogs to the business metadata imported from the Erwin logical data model and excel files.
• Designed and developed Alters and Notifications to the Metadata Business community.
• Developed training documents for the end users about the new COTS product Ab Initio Metadata Hub and responsible for UAT support. upgrade the Metadata hub environments from 3.1.4 to 3.1.5
• Implemented Single Sign on (SSO) for Metadata hub
• Schedule the Jobs on Control-M
• Designed and developed profiles /custom profiles, drill down on profile Results for Informatica Data Quality.
• Creating expression rules, Creating Score cards, Run profile on Data sources
• Designed and developed exception models for data anomalies based on the data quality checks using the business rules provided by the users.

Confidential, Cleveland, OH

Ab initio ETL Solution Architect

Responsibilities:

• Created High level Business map to capture and load Metadata for Enterprise Business view.
• Interacting with Metadata Stewards group for their needs on Capturing the Mettadata.
• Proposing the Metadata capture in different cycles Canonical, shared Foundation and Business View.
• Designing new application under systems to align the Data Encyclopedia ontology.
• Extract the technical Metadata from Physical Canonical Layer, Shared foundation layer (ETL transformations)
• Creating Lineage from Harmonization through Canonical and Canonical to shared foundation layer.
• Daily status reports, managed the team and resolved day-to-day issues.
• Responsible for administration of Ab Initio Metadata Hub.
• Designed and developed XML files for object model extensions and view customizations for Ab Initio Metadata Hub.
• End user training and Demo’s.

Confidential, Atlanta, GA

Abinitio Architect/ ETL Technical Lead

Responsibilities:

• Works with and coaches Global Resources to be successful project and support Partners
• Demonstrates teamwork and ownership of assignments, goals and results
• Responsive to teammates expectations, meets level of service where applicable Progress/Results:
• Worked on several ETL Solution Architect/ ETL Technical Lead and deal with the different customers Infosys, Confidential, Accenture and integrating with several folks on site and offshore and helped to define the process flow and standards.
• Helped them in coaching technical design documents and helped several folks forany issues related to code, environment issues.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including Writing Unix scripts, Informatica Mappings and testing that culminate in client acceptance of the results.
• Expertise skills on Horizon phase, Concept assessment phase, DAP phase, Build phase, QA, Production Implementation phases.
• Expertise in data migration tools, Abinitio, Data stage, AIX/UNIX, UNIX, UNIX Shell Scripting, dimensional modeling, metadata repository, SQL server.
• Utilized as subject matter expert in several applications in gathering business requirements, brainstorming sessions and JAD Sessions. Expertise in technical documents writing.
• Experience with Ab Initio EME administration.
• Installed EME from the Standard Environment, created public and private projects as needed.
• Promoted the Projects from Co-Op version 2.11.8.m7 to 2.13.1.
• Created Generic graphs in Ab Initio as needed.
• Scheduled jobs for the ETL using Corn, CA-7 Schedulers.
• Implemented data validations, exception handling according to the requirements.
• Did Performance tuning on graphs.
• Provided 24x7 Production Support.
• Application Configuration Environment 3.1 /Business Rules Environment

ETL Architect / Data warehouse Architect/ ETL Tech lead

Confidential

Responsibilities:

• Enables users to access Confidential to perform application configurations tasks
• Helping developers create and maintain application templates.

ETL Architect / ETL Tech lead

Confidential

Responsibilities:

• Customizing Extending the Schema extension for the views, Info bubbles, reports, home page banners etc.
• Applying all the View customizations.
• Creating the war file and deploying on the application sever.
• Run the Imports for all the feeds

Confidential

Data warehouse Architect /ETL Architect / ETL Tech lead

Responsibilities:

• Involved in High level business requirements, Conceptual business requirements and mapping document discussions and designing the logical and physical designs.
• Involved in the design reviews and sign off process.
• Assign the development to onshore/offshore folks.

Confidential

Data warehouse Architect /ETL Architect / ETL Tech lead

Responsibilities:

• Involved in business requirements and mapping document discussions and designing the logical and physical designs.
• Involved in the design reviews and sign off process.
• Assign the development to onshore/offshore folks

Confidential

Data warehouse Architect /ETL Architect / ETL Tech lead

Responsibilities:

• Proof of concept for Running different abinitio Jobs in different modes-like API, utility, bulk mode Array modes and running on different set of nodes and compare different run times.

Confidential

Abinitio Architect / ETL Tech lead

Responsibilities:

• Involved in Horizon phase, Concept assessment phase, Design & Activation & Build & Testing phase, Implementation phase & Prod support.

Confidential

Abinitio Architect / ETL Tech lead

Responsibilities:

• Involved in Horizon phase, Concept assessment phase, Design & Activation & Build & Testing phase, Implementation phase & Prod support.

Confidential

Abinitio Architect / ETL Tech lead

Responsibilities:

• Involved in Horizon phase, Concept assessment phase, Design & Activation & Build & Testing phase, Implementation phase & Prod support.
• Identify/debug, troubleshoot, modify, document, test and fix production issues.

Confidential

Abinitio Architect / ETL Tech lead

Responsibilities:

• Involved in Horizon phase, Concept assessment phase, Design & Activation & Build & Testing phase, Implementation phase & Prod support.
• Identify/debug, troubleshoot, modify, document, test and fix production issues.

Confidential

Abinitio Tech lead

Responsibilities:

• Involved in Horizon phase, Concept assessment phase, Design & Activation & Build & Testing phase,
• Implementation phase & Prod support.

Confidential

Abinitio Tech lead

Responsibilities:

• Involved in Horizon phase, Concept assessment phase, Design & Activation & Build & Testing phase, Implementation phase & Prod support.
• Analyzed business needs, gathered user requirements and create UML Use Case models
• Data Architect with ERWIN Data Modeler
• Credit Data Provisioning (CDP), E-SERP (SunTrust Enterprise Risk Program)

Confidential

Tech lead

Responsibilities:

• Involved in business requirements and mapping document discussions and designing the logical and physical designs.
• Responsibilities:
• Involved in project estimates and resource estimates, storage estimates, Abinitio licensing.
• Involved in the design reviews and sign off process.

Confidential

Abinitio Tech lead

Responsibilities:

• Extensively involved in the transformation process using various Ab Initio components.
• Used Ab initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases Deploy and test run the graph as executable Korn shell scripts in the application system

AB INITIO senior developer

Confidential

Responsibilities:

• Developed several AB INITIO graphs for extraction, transferring, loading, cleaning and populating various Data mart.

Confidential

Ab initio ETL Developer

Responsibilities:

• Used Ab initio as ETL tool to pull data from source systems, cleanse, transform, and
• Load data into databases.
• Modified the Ab initio components parameters, utilize data parallelism and thereby
• Improve the overall performance to fine-tune the execution times.
• Extensive use of multi-file component and ABINITIO Parallelism to process a large
• Volume of data as part of Instant Credit Processing.