Data Quality

Jag Gaikwad

Business / Data Analyst

Greater New York Area

**********@*****.*** 201-***-**** (US Citizen)

Experienced Business Analysis and Data Quality Governance professional

Specialization in Financial Industry Financial Advisor / Asset Management / Wealth Management / Investor Services Shareowner Services / Banking / Equity Compensation / Executive Compensation / Vendor Management /Governance Risk / Compliance, Stock Plan Services Options, Swaps/Reloads / Share Reinvestment, Equity Expensing.

Excellent in Requirement Planning and Management (Gathering, Analysis, Documentation, Communication, Governance), BRDs / FRDs (Business / Functional Requirement Documents) Reviews / Analysis. Good understanding of SDLC. Ability to communicate with SMEs, Business Stakeholders and Technology Experts.

Gap Analysis Expertise Analytical Qualitative Data, Business, Process, Framework and Quality Gap Analysis.

Hands on experience of all aspects of Data Quality Governance Data Cleansing, Data Profiling, Data Validations, Data Correction, Data Reconciliation, Data Integrity, Data Calculations / Manipulations, Data Transfer Process setup. Data Process Control and Data Process Error handling. Data ETL process execution. Data Protection Control Identification and Implementation, Understanding of Information Security.

In-depth knowledge and Experience of Quality Assurance practices. Writing and executing Test Plans, Test / Use cases, Test Data Creation, performing UAT with Strong understanding of Quality Assurance and Data Risk Management.

Software : All Microsoft Office programs (Excel / Visio / Flow Charts / Swimlane Diagrams)

Reporting Tools : Crystal Reports, Business Objects (Read / Write SQL queries)

Financial Tools :Salesforce, NaviPLan, Asset Map, e-App, Aegis, e-dox, Join Me, PaperClip, Suitability Review

System (SRS), Award Choice, TradeLink, Benefits OnLine, EOWIN, Sapphire, EOS, Option

Navigator, EASi, EquiLink,

Governance, Risk, Compliance, Information Security Tools : Archer / Ariba

Quality Assurance Tools : HP Quality Center 12.20, Application Lifecycle Management (ALM)

Educational Qualification

Bachelor of Engineering

FINRA / Other Certifications

Series 7, Series 63, Life and Health

Experience

New York Life Securities Sep 2017 – Present

120 Broadway, NYC

Axa Advisors, Morristown, NJ (May 2016 – Aug 2017)

Financial / Business Professional Analyst

Salesforce, NaviPLan, Client Profile, Asset Map, e-App, Aegis, e-dox, Join Me, PaperClip, Suitability Review System(SRS),

Portfolio Allocation

Gathering client’s financial information and creating NaviPlans presenting their Fianacial needs analysis

Creating Asset Maps and Client Profiles from client review sessions. Conducting Join Me meetings.

Generating reports and illustrations for client review and presentation, helping them make Financial decisions

Maintaining SalesForce system, creating leads, prospects, clients, events, meeting, action items.

Submitting e-Apps, document maintenance with PaperClip, creating and maintaining e-dox.

Resolving compliance issues through Suitability Review System(SRS)

Bank Of America / Merrill Lynch Oct 2015 – Jan 2016

Pennington, NJ

Business Analyst Level III

Award Choice, Benefits OnLine, TradeLink, Equities, Stock Options

Retirement Eligibility Taxation for Restricted / Performance Awards, Pro-Rata Termination / Retirement Taxation,

E-Reporting, I- Reporting, Inbound Outbound Data Transfer, Client Parameter Setup

Understanding and Implementing Global Wealth and Investment Management (GWIM) Technology initiatives. Application Lifecycle Management using HP Quality Center ALM 12.20

Release Cycle Analysis - Analyzing High Level Design (HLD) and Low Level Design (LLD) documents. Performing document reviews and giving business approvals

Requirements / Enhancements understanding and setup in HP QC. Ensuring Requirement Coverage

Report Execution and Validation, Inbound and Outbound file enhancement validation. Ensuring reporting Data Integrity and Accuracy. Creating Adhoc report specification, testing and sign-off.

AIG July 2014 – Mar 2015

Jersey City, NJ

Business Analyst – Governance, Risk, Compliance, Data Quality

.

Created and implemented process for cleaning up Exit Strategies in the Vendor Governance System. Designed process flow charts with Visio. Created Swimlane diagrams. Performed UAT activities and coordinated QA testing.

Responsible for generating MIS from Archer and Ariba related to Vendor Management and Governance

Conducted analysis and produced MIS for Risk Rating of strategic Vendors.

Analyzed and created process for major Data Cleansing effort resulting in the elimination of over 10,000 duplicate vendors, using SQL queries, Archer Adhoc Report and Advance Excel.

Developed process and MIS for syncing Contract Owner information between HR system and Ariba/Archer and ensuring that all Contracts were assigned to the correct Organization.

Daily Data Quality Monitoring of Data Transfer Processes between multiple interrelated systems.

Provided daily / weekly / monthly Data Quality Activities Metrics, Reports and Charts for Management Committee Meetings.

Bank of New York Mellon / ComputerShare Feb 2006 – Mar 2014

Jersey City, NJ

Senior Business Analyst – Shareowner and Investor Services / Stock Plans

Maintained highest standards of Data Quality Management activities to resolve any errors and data issues.

Identified and implemented Data Protection Controls for maintaining Confidentiality, Integrity and Availability of information as per the Security Policy / Standards adopted by the company.

Process Implementation, Monitoring and Control, Error Handling and Corrections. Maintaining and Monitoring FTP Data Transfer outbound and inbound Data exports.

Actively involved in all phases of New Client Implementation / Client Onboarding Process, KYC activities Pre-implementation, In-implementation, Go-live in CRM and Stock Administration system, specifically performed all activities related to New Client Data Migration, Data Gap Analysis / Mapping and Data Modification for smooth transition and transfer.

Business Objects report analysis, specification documentation, validations, testing / UAT. Creating Business Objects Adhoc reports SQL queries for Master / Reference Data Extraction / Maintenance .

Business Analysis of system changes / enhancements required for multiple integrated systems and documenting the business/functional requirements (BRDs / FRDs).

Worked on documentation for SAS70 certification for Data Management Process.

Citigroup Aug 2004 – Feb 2006

111 Wall Street, NYC

Data / Quality Analyst – Stock Plan Investor Services

Responsible for the ANALYTICAL QUALITY ASSURANCE of the various operations / functions of the Stock Plan Services

Pfizer / Pharmacia Aug 2000 – July 2004

Peapack, NJ

Business IT Strategy / Support for Pfizer (Legacy Pharmacia) Stock Options

Contact this candidate