Informatica Developer Data Analyst

RUCHI AGARWAL

***** ********** ****** · North Hollywood, California 91602

(+1) 626-***-**** · **********@*****.***

SENIOR DATA GOVERNANCE ANALYST

Dynamic and innovative analyst with more than 16 years of experience in IT Industry. Accomplished professional demonstrating hands-on management style with ability to ascertain requirements and provide accurate development. Successfully executed numerous projects. Adept working in fast-paced, deadline oriented environments. Proven data processing and statistical analysis experience. Sound logical approach to problem solving in relation to both business and technical issues

EXPERTISE

Change Management · Regulatory Reporting · Data Quality · Data Stewardship · Data Warehousing

· Client and Vendor relations · Data Modeling · Implementations · Data Warehousing · Data Profiling ·Source to Target Mapping · Data Validation · Informatica Product Suite: Repository Manager / Designer / Workflow Designer / Monitor / Data Quality/ Axon/ EDC · ETL Coding · Banking · Retail ·Education · Insurance

· Health Care · Data Governance · Technical Specifications Documentation

TECHNICAL SKILLS

Oracle 8i/9i/10g/12g SQL · PL/SQL · Database Administration using Oracle 9i · DB2 9.1 · Sql Server 2008

· PostgreSQL · Unix · Windows 2000

TOOLS:

Toad · Erwin 4.0 · Informatica Power Center 9.x/8.x,7.x/6.x · Cognos Impromptu 7.0 · Mercury Quality Centre

· Control-M · Microsoft Visio · Microsoft Office · Jira · SAP BODS 4.1· Tableau · Clarity Database

· Informatica Data Quality · IBM Cognos Business View Point 10.1 · Maximo Asset Management

· Appian · Collibra · Informatica Axon

PROFESSIONAL EXPERIENCE

CITY NATIONAL BANK, Los Angeles, California · 12/2016 till date

Subsidiary of Royal Bank of Canada, RBC USA Holdco Corporation

Senior Data Governance Analyst

Assist in the development and execution of the Data Governance strategy

Coordinate with operational and reporting data stewards to create data controls, identify measurement definitions and manage then using dashboards

Collaborate with the data stewards, data custodians and report developers to ensure consistent use of data definitions, authorized data sources and calculations. Additionally, enlists business unit support to take ownership and responsibility for consistent definitions and quality of their data.

Establish and maintain programs to monitor and measure the data governance adoption and achievements.

Responsible for maintaining an accurate enterprise critical report library with associated reporting metadata.

Documents and maintains data governance activities, maintains logs, and records issues and corresponding resolutions

Serve as a liaison between business, functional areas and technology to ensure that data-related business requirements are clearly defined, communicated and well understood and considered as part of operational

Responsible for providing financial analysis and reporting in support of Comprehensive Capital Analysis and Review (CCAR) process

Responsible for understanding and preparing the Bank's regulatory reports in compliance with legal and regulatory requirements, company policies and procedures. Apply both technical and analytical skills to monitor and analyze large data set and prepare quality variance analysis

Possess project management skills to perform and prioritize a variety of tasks to support new initiatives and requirements like Data Lineage etc and assist other department members when appropriate

Implementations using Agile methodology

Achievements:

Managed the Data Governance tool for correcting the data at source system of records via workflow tool (Appian) as part of implementing data governance strategy across enterprise

MUFG UNION BANK, Los Angeles, California · 04/2016 – 11/2016

Subsidiary of holding company MUFG Americas Holdings Corporation and a member of the Mitsubishi UFJ Financial Group

Senior Data Analyst

Responsible for analysis of IHC/CCAR Regulatory reporting requirements

Provided consistent data sourcing, profiled data and integrated in alignment with current standards established by Data Governance teams

Contributed to the oversight of firm-wide data sourcing for financial, management and regulatory reporting requirements. Centralization and ownership of the data repository ensuring a strong control framework including financial and data reconciliations and the supporting operating model

Interacted with various management, SME’s and executive stakeholders from cross functional areas such as Controllers of the Americas, business Units to understand client business processes

Worked with teams and customers to understand the data sourcing and integration requirements for each of the assigned program work streams, ensuring long lead integration activities are identified, coordinated and feed into the portfolio planning, data governance, data quality and master data management activities

Collaborated with key stakeholders/application teams to understand, document and prioritize the critical data elements (CDEs) required to support key business measures / KPIs needs

Performed data analysis by accessing the data using queries or reporting tools, including mapping the business functions to the data and data model, data reconciliations, gap analysis

Developed functional requirements and obtained timely sign-off by all respective parties

Worked closely with business users and IT development team throughout the various phases of the project.

Participated in testing along with QA & UAT teams

Demonstrated strong interpersonal skills with the ability to work effectively with upper management and excellent leadership skills in motivating others

Experience in process mapping / process flows / process modeling required

Developed functional requirements and obtain timely sign-off by all respective parties

Achievements:

Created and implemented new standards, processes, and procedures related to master data management using Collabra Data Governance Tool

BANK OF THE WEST, San Ramon, California · 03/2015 – 03/2016

Subsidiary of BNP Paribas, one of the six highest rated banks in the world

Informatica Lead Consultant / Data Analyst

Spearheaded business requirements gathering and translated into business specifications for regulatory requirements CCAR/IHC

Performed data analysis by accessing the data using queries or reporting tools including mapping the business functions to the data and data model, data reconciliations, gap analysis

Created mapping documents outlining data flow from sources to targets, established Entity Relationship diagrams, and developed design specifications

Directed task delegation and performance management of developers, ensuring alignment with scope and quality objectives

Led design and development walkthrough, participated in data models and database design reviews, and delivered key contributions to implementation of best practices and standards for data integration environment. Provided technical assistance to team members and bolstered troubleshooting and alternative development solutions.

Developed ETL jobs utilizing various transformations as per technical specifications, extracted data from flat files and other RDBMS databases into staging area and populated onto data warehouse

Prepared migration document moving mappings from development to testing and production repositories. Coordinated with QA Team for Integration Testing/UAT bug fixes Involved in data load activities for historical loads via ETL jobs and Unix shell scripting

Assisted in determining impact of operational issues and delivered recommendations for resolution via data extraction and quantification

Coordinated and prioritized all escalated activities including testing, implementation of system upgrades, enhancements, and bug fixes and provide support and on-call coverage

Achievements:

Facilitated delivery of 200 components migrated to Production Environment within tight 2 week deadline for going Live Action through close collaboration with various teams including DBA, Operation Support, Release Management, Project Manager, QA, and Business Users creating defined process for migration

NEW YORK CITY HOUSING AUTHORITY, New York, New York · 05/2014 – 02/2015

Increase opportunities for low and moderate income New Yorkers by providing safe, affordable housing and facilitating access to social and community services around the five boroughs in New York City

Informatica Lead Developer / Data Analyst

Analyzed data across various assets for data loading requirements

Participated and provided feedback in technical review meetings ensuring conformity to ETL standards

Performed source data analysis and data profiling in support of ETL design

Created source targeting data mapping documents and reviewed design and transformation rules with developers

Translated project requirements into detailed design activities and artifacts, represented artifacts at appropriate governance, quality and status meetings, and performed data loading utilizing Informatica and Maximo asset management tool

Conducted code review and test plan review for quality and adherence to ETL standards, led unit testing and integration testing activities, and utilized various transformations such as Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union in development of robust mappings within Informatica Designer

Achievements:

Successfully created automated process comparing data from various sources via Excel spread sheets

ANALYTICS 8 AUSTRALIA, Sydney, Australia · 09/2012 – 12/2012 · 08/2013 – 10/2013

Consulting Services Company delivering analytics, data warehouse, business intelligence and big data projects, in Australia and the USA. Clients include Pernod Ricard, Australia and University of Sydney

Informatica Lead Developer

Liaised with internal business team comprehending data loading requirements

Installed Informatica Server with add-ons for Essbase facilitating understanding of existing ETL code within development environment.

Extracted data from Essbase employing Informatica Power Exchange, developed various ETL mapping processes for data loading utilizing ETL frameworks per Detailed Design Document.

Served as integral team member on ETL application architecture design for ETL components

Identified data source alternatives for missing or inadequate data elements for reporting requirements

Defined data entities and relationships ensuring achievement of business requirements and performed data modeling activities

Coordinated data on-boarding processes with internal and external stakeholders

Conducted full SDLC for metadata and client requirements tracking system by managing source to target ETL rule evolution, business terms, and data dictionary. Developed procedure manuals per Business Protocols for deployment

Implemented Informatica recommendations, methodologies and best practices. Partnered with Quality Assurance Group by assisting with functionality, data quality, and testing unit / system / stress / performance and UAT

Achievements:

Facilitated business users in running reports for calculating Sales Figure of Sales in Australian market via extracting data from datamart through conversion of existing code base in Hyperion and Essbase into Informatica ETL code

Cleansed data for University of Sydney SIBI (Strategic Information & Business Intelligence) group as data coming from various research publications such grants, grants from private enterprise and joint ventures prior to loading in data warehouse by creating data quality standards using IDQ

NSW SELF INSURANCE CORPORATION, Sydney, Australia · 11/2011 – 05/2012

Statutory body that operates under the NSW Self Insurance Corporation Act (2004)

Data Quality Supervisor

Established and implemented policies and procedures manuals based on relevant data as per business protocols and specific data requirements

Defined enhancements / modifications to SICorp data warehouse, paired with internal business team generating functional specifications for changes to data warehouse for development team

Performed User Acceptance testing of changes for implementation to production, ran processes extracting data for external service providers including actuarial and risk manager providers

Achievements:

Created process for all insurance companies across Australia to adhere to data quality standards while sending data to SICorp through design of process utilizing Cognos Data Manager tool rejecting any data in staging layer not adhering to rules

WESTPAC PTY LIMITED, Sydney, Australia · 02/2010 – 02/2011

Australian bank and financial-services provider

Informatica Developer

Interpreted Detailed Design documents, developed Informatica mappings utilizing various transformations and performed Unit testing, Integration testing, System testing, and Regression testing of Informatica jobs

Designed and developed UNIX shell scripts handling pre and post session processes

Employed Unix shell scripts automating day-to-day operations

Deployed Informatica mappings testing environments, fixed bug in test environments and assisted business users with retesting

Prepared documentation for production implementation as per Westpac standards, supported smooth implementation in production environment, and provided production warranty support after implementation

Achievements:

Facilitated offshore team in taking reigns of production support ETL jobs along with business and various escalation procedures avoiding any business impact by providing extensive training to offshore support team

ING DIRECT, Sydney, Australia · 06/2009 – 12/2009

ING Bank (Australia) Limited (trading as ING) is an Australian direct bank and a wholly owned subsidiary of the multinational Dutch bank, ING Group

Informatica Developer

Interpreted Detailed Design documents, developed Informatica mappings utilizing various transformations and performed Unit testing, Integration testing, System testing, and Regression testing of Informatica jobs

Designed and developed UNIX shell scripts handling pre and post session processes

Employed Unix shell scripts automating day-to-day operations

Deployed Informatica mappings testing environments, fixed bug in test environments and assisted business users with retesting

INSURANCE AUSTRALIA GROUP, Sydney, Australia · 10/2007 – 10/2008

Parent company of a general insurance group with controlled operations in Australia, New Zealand, Thailand and Vietnam, employing more than 15,000 people.

Informatica Developer

Performed Requirement Analysis and Effort Estimations of deliverables

Oversaw preparation of design documentation for reconciliation processes between Edw2, CRODS, and HUON

Handled development and testing of reconciliation processes

Executed preparation of unit test cases for integration and system testing, performed unit test and bug fixing for Edw2 phase2, and provided production support for Edw2 phase2 regarding resolution of production issues, data analysis, and performance tuning

Designed and developed ETL jobs, Db2 stored procedures for various enhancements, as well as, Edw2 phase 4 policy, asset, coverage, and products

Achievements:

Garnered recognition award for best performance for completion of EDW2 Phase2 Bugs and on-time production deployment through analysis of customer data and coordination with various teams

TATA CONSULTANCY SERVICES, Mumbai, India · 11/2000 – 02/2007

Subsidiary of Tata Group and Global Leader in IT Services, Consulting, Technology and Digital Solutions with a Large Network of Innovation & Delivery Centers across Globe

IT CONSULTANT

Managed requirements gathering, discuss solution, perform system analysis, complete high level sizing and finalize technical/functional specifications

Prepare Microsoft Visio diagrams, complete high/detailed design documents for the project

Holding review meetings to monitor progress of the project as per schedule/budgets and ensuring timely completion and delivery of the project to the client/end users

Understanding the technical & functional specifications

Design, development, testing, troubleshooting and debugging of the application

Manage smoother implementation and testing of the developed applications at client location

Provide post-implementation, enhancement and maintenance support to clients for application

Extending post go-live and application maintenance support to the client/end users

Worked for several clients like HP, GE Plastics, GE Medical Systems, GE Aircraft Systems, 20th Century fox and involved in various phases of SDLC.

EDUCATION

Bachelor of Science – Computer Science and Engineering

National Institute of Technology Durgapur / Burdwan University – Durgapur West Bengal, India

Contact this candidate