PROFESSIONAL SUMMARY:

• Having professional experience in Business Analysis, Design, Data Modeling, Development and Implementation of various client server and decision support system environments with focus on Data Warehousing, Business Intelligence and Database Applications.
• Over 7 years of ETL Consulting with Expertise in Data Integration, Data Governance, Data Stewardship, Data Profiling, Data Quality, Data Modeling, Data Architecture, Metadata Management, Reference data management and Master data management.
• Good experience in Financial, Health Industries in Data warehousing.
• Expertise in Basel compliance, CCAR, Firm wide, Non - Firm wide, AML (Anti Money Laundering), Risk Modeling, Credit Scoring projects in Banking and Financial Services industry.
• Experience in Banking and Financial services projects involving Card Services, Consumer Banking, Business Banking, Wealth management, Auto and Student loans.
• Expertise in healthcare domain projects involving Membership, Billing, Payments, Claims, Benefits, Provider, Customer service areas.
• Expertise in Abinitio, Metadata, Collibra, Informatica, Teradata, UNIX.
• Expertise as Data Custodian as well as Data Steward in multiple Projects.
• Development and implementation of a Data Governance Strategy.
• Requirements Gathering, Software Design, Development and Deployment
• Expertise in Data Governance, Collibra Software, and Business Analytics

SPECIALTIES:

• Business Intelligence Strategy
• Enterprise Application Integration
• Enterprise Data Management (EDM)
• Master Data Management (MDM)
• Data Quality(DQ)
• Customer Data Integration (CDI)
• Data Profiling
• Regulatory compliance
• Analytics
• Enterprise reporting

TECHNICAL SKILLS:

Operating System: UNIX, Windows

Languages: UNIX Korn Shell scripting, COBOL, JCL, PL/SQL and C.

Database: Teradata 15, Oracle 11g, SQL Server, Microsoft Access

Database Tools: SQL Assistant, BTEQ, BTEQwin, Teradata Administrator, Toad.

Data Governance Tool: Collibra DGC 5.0

ETL: Abinitio 3.2.5 (CO>OP, GDE, EME, EXPRESS>IT, DQE, BRE)Informatica Power Center 9.0.1/8.6/8. x/7.x, Power Exchange 8.1

Data Quality: Ab Initio Data Quality Environment (DQE)

Data Modeling: Star Schema Modeling, Snowflakes Modeling, FACT & Dimension Tables, Logical and Physical Data Modeling, Erwin 7x.

BI & Reporting: Micro Strategy, Tableau, QlikView, Cognos, SAS.

PROFESSIONAL EXPERIENCE:

Confidential

Abinitio Metadata DQE Consultant

Responsibilities:

• Working on the Mosaic Data Migration Project in SWA, where the Legacy Systems (Wizard & TRAX) needs to be migrated to new MXI Platform.
• Working with the Business Analysts in profiling various Data Sources which includes Flat Files, Spreadsheets, Oracle Tables and publishing those results in the Metadata hub for the Business to review those results and approve them. So that BSA’s will create a well-defined STTM for the developers.
• Working with Various Business Users on Creating Profiles based on different levels of complex relations between different attributes with in the same asset.
• Created lineage in the Metadata Hub for the new Application that will show the progress of the migration done for the project.
• Created Data Profiles for the Data loaded in the New Application so that the business will know the level of quality of the data using the metrics completeness, Accuracy etc..

Environment: Ab Initio (CO>Operating system 3.2.5, GDE 3.2.5, BRE, ACE, EXPRESS>IT, DQE, Abinitio Metadata Hub, Collibra DGC 5.0, Collibra Connect, Collibra DGC Connector, Mule ESB 3.8, Anypoint Studio 5.4, Eclipse 4.3.1, Activiti Eclipse BPMN 2.0, JSON, SOAP,REST, UNIX, SQL, PL/SQL, Teradata, Oracle, SQL Server, Perl, Autosys

Confidential

Abinitio Metadata/Collibra Data Governance Consultant

Responsibilities:

• Acted as a Data steward for a domain within the Enterprise Data Governance organization and supported key initiatives especially the Risk Data Aggregation, Risk Data Reporting, FRY14 and Capital Plan in addition to firm-wide strategic projects with data impacts.
• Assisted Data Quality team with establishing data quality rules, thresholds and quality reports and dashboards.
• Provided Analytical support to Business partners to identify critical data elements for the projects in scope, perform initial analysis and partner with MIS and Business teams to define and capture metadata, lineage, business rules and transformation logic.
• Managed risk exposure by analyzing root cause for issues identified and engages the right parties across the teams with recommended strategies for timely resolution.
• Develop key relationships with SME’s and data owners and drive discussions to standardize / rationalize attributes & metrics and assist with establishing clear ownership of data elements
• Collaborate with reporting analysis and data strategy functions to represent needs of the domain, assess and identify impacts across multiple complex projects.
• Worked on the Data Governance projects which are related to BCBS 239 & CCAR.
• Interacting with Metadata Users to get the business requirements required to implement their application in Abinitio Metadata Hub Portal.
• Creating Building Blocks Spreadsheets for the Metadata User Application.
• Creating Communities, Domains, Assets in Collibra.
• Building the code values, code lists, attributes etc in Collibra DGC.
• Customization of the workflows using Eclipse IDE.
• Defined policies, business terms, relations (between assets) and rules.
• Documented User Guides on how to create communities, domains, domain type, assets, asset types, relationships, traceability, lineage etc.
• Configured communities and domains for all the functional divisions of the bank to bring about better Data Management in the bank.
• Understood business traceability for better results to reduce complexity and redundancy of data.
• Creating Data Source Connections for various data source types like Oracle, Teradata, SQL Server etc.
• Creating Custom Feeds, Import Rules based on type of the source.
• Establishing the Stated Lineage/ Automated Lineage on Metadata Hub for Various applications based on the situation.
• Documenting the Steps involved in importing a metadata application into Enterprise Metadata Hub.
• Importing Metadata from various databases as well as source files.
• Establishing the lineage by importing the ETL Code from different ETL vendors Informatica, Data stage etc... And Reporting Tools like OBIEE, Micro strategy etc.
• Worked with Operational Risk Teams in gathering the requirements for 15 sources includes ORIS, LDRPS, TRIMS, Lotus Notes Strong Box, Iron Mountain, Payments, GL, BCP Central, SPARC, Hogan, which will feed into the Operational Risk Profile Report.
• Integrated the Abinitio Metadata Hub with the Collibra Data Governance Center.

Environment: Ab Initio (CO>Operating system 3.2.5, GDE 3.2.5, BRE, ACE, EXPRESS>IT, DQE, Abinitio Metadata Hub, Collibra DGC 5.0, Collibra Connect, Collibra DGC Connector, Mule ESB 3.8, Anypoint Studio 5.4, Eclipse 4.3.1, Activiti Eclipse BPMN 2.0, JSON, SOAP,REST, UNIX, SQL, PL/SQL, Teradata, Oracle, SQL Server, Perl, Autosys

Confidential

Metadata DQE Consultant

Responsibilities:

• Confidential Data warehouse is a large analytical database that houses integrated data sourced from across business transaction systems and other sources.
• The data is organized and designed to enable users to relate information across subject areas, from multiple source systems and over large periods of time, using common enterprise definitions and business rules. The Data Quality project relates to the fitness of data to serve its purpose in a given context, as measured against one or more data quality dimensions.
• It allows for the formal orchestration of people, processes, and technology that enable Confidential to control, deliver and enhance the value of its data and information assets.
• The Data quality profiles deliver the accuracy and completeness of all metadata for Confidential including physical data elements and lineage, as opposed to actual data content or values quality.
• The Data Quality project also serves as a way to implement Data quality rules for Government Regulations such as BCBS 239.

Environment: Ab Initio (CO>Operating system 3.2.6, GDE 3.2.6, BRE, ACE, EXPRESS>IT, DQE, Collibra DGC 4.5, UNIX, SQL, PL/SQL, Teradata, Oracle, SQL Server, Perl, Autosys

Confidential

Senior ETL Developer

Responsibilities:

• Confidential is a Master Data Management (MDM) system, which provides the healthcare id for Members of Confidential .
• Confidential project consists of consolidating Confidential EAST and Confidential WEST applications and connecting various E&B systems to the consolidated Confidential environments.

Confidential

Senior ETL Developer

Responsibilities:

• The main purpose of this project is to develop/enhance the ETL process where we get data from various OLTP sources which is being transformed as per the business logic and loaded into the ODS.
• The data loading is being done at real time as well in batch processing.
• The data loaded is used for the analytical and reporting purpose by the business users.

Confidential

Senior ETL Developer

Responsibilities:

• Responsible for providing strong Production Support, design, development and implementation skills to support loan accounting applications releases and Production Support.
• Participated in implementing enhancements, resolution of production defects, providing support to business partners and technical peers as needed.

Confidential

Senior ETL Developer

Responsibilities:

• Confidential Internet Services Group (ISG) was implementing new customer benefit schemes to help serve the customers better and also increase the customer base.
• Many new features like To Make an appointment, My Retirement Plan, Credit Options Guide etc were introduced and I was the ETL developer to these online tools.

Confidential

ETL Developer

Responsibilities:

• Implemented new products and services in providing AML expertise and directions, specifically around the new Product Analytics process/program to provide oversight and guidance related to the development and review of these reports, developing a globally sustainable process including governance, reporting and roles/responsibilities.