North American Data Quality

Professional summary:

-**+ years of Industry experience with 16+ years working for leading North American Banks: American Express, Royal Bank of Canada, and TD Bank.

-Expertise with:

oEliciting requirements through interview, job shadowing, reviewing exiting documentation to determine the as-is process.

oFacilitating business requirements, elicitation sessions with multiple stakeholders.

oAnalyze requirements and depict them in the form of a visual diagram to showcase the ‘to-be’ state.

oCreating and executing of technical and functional test cases for various Scenarios, development, and testing.

oTranslating business needs into functional and non-functional requirements, collaborating with cross-functional teams to ensure alignment.

oReporting competing priorities to the stakeholders in a timely manner, suggesting alternatives, and providing added value to existing applications.

oPrioritizing business needs of the product and incorporate the criteria to develop the product’s functional releases.

oExcellent Co-ordination with other teams like Mapping Team, Data Quality Team, SIT & UAT Teams.

oProviding strong Customer relationships, Product design and development, Testing and conducting customer reviews.

oJira, Confluence, change requests, stakeholder approval processes, MS Project, MS Office Suite (Visio, Excel, PowerPoint, Word).

oCreating BRD, FRDs, UML and flow diagrams

oConducting a gap analysis between to current state & the desired state

oTest plan formulation from requirements, Test scenario creation from use-cases, and Test case design from design document.

oManaging changes to requirements, assessed impacts, dependencies, and risks in accordance with the change management process.

oHighlighting detailed metrics and acceptance criteria for system testing, ensuring new applications and features met requirements.

Strengths:

-Highly motivated, flexible, have strong analytical and logical reasoning skills, with the ability to perform efficiently, independently and as part of a team.

-Focus on the big picture to understand business requirements and to derive solution options to achieve it.

-Excellent written and oral communication skills

-Rapid learner of new systems, a critical reviewer, and a keen problem solver

Technical Skills:

Databases: DB2, DB2 Stored Procedures, Teradata

Tools: BPMN, Jira, Microsoft Office, Confluence, Microsoft Visio, Figma, Tibco Mailbox, Service Now

Methodology: SDLC, Waterfall, Agile

Mainframe: MVS, Z/OS, TSO/ISPF, COBOL, JCL, UNIX, SQL, SAS, TSO ISPF

Recognition:

TD Appreciate awards:

-Appreciation from Business to execute with speed and impact.

-Appreciation from peer1: Develop our colleagues.

-Appreciation from Business: Think like a customer, Above and Beyond

-Appreciation from user: Think like a customer and act like an owner.

-Appreciation from peer2: Develop our colleagues.

-Appreciation from Manager: Great work (2020)

-Appreciation from VP North American ATM Channel: Think BIG (2020)

-Appreciation from Manager: Above & Beyond (2020)

-Appreciation from Sr. Manager: You ROCK: For organizing Employee Appreciation Week celebrations. (2020)

-Appreciation from Interfacing application: Collaboration (2021)

-Appreciation from Manager: Above & Beyond (2021)

RBC Performance (Bravo) awards:

-Recognized and rewarded for the first key change process and for documenting it for future annual key changes.

-Recognized and rewarded another award from the Support team for knowledge transition and help extended while supporting the new process.

-Recognized and rewarded for strong analytical skills and due diligence for UNIX server upgrade.

IBM Performance award (2005):

-Annual IBM Performance award for best developer in the department

Community Services:

-Volunteer at Vibha-Raleigh chapter

-Volunteer at CORDUSA

-Volunteer at local food bank, Canada

-Volunteer at TD Tree days, Canada

-Scouter for Scouts Canada (2016-2018)

-Pioneer of the IBM-Diversity program (2003-2006)

-Treasurer IBM Diversity program (2003-2006)

-Editor of the IBM-Newsletter (2003-2006)

-Treasurer for Institution of Engineers (India) (1998-2000)

-Secretary for Institution of Engineers (India) (1997)

Experience:

Quality Assurance – Blue Cross Blue Shields of Kansas (Jul 2023 – till date)

Databases: DB2

Tools: Manual testing

Methodology: Agile

Responsibilities:

-Integration, Regression testing for all changes made within the Membership Eligibility system.

-Raise any observations for any functionality that is not performing as expected.

-Demo the testing to Product owners before it can be handed to client testers. Final gate before the change is handed from Delivery to Business.

Sr. BSA – TD Bank – Canada (Oct 2018 – Jul 2023)

ATM Channel.

Databases: DB2

Tools: Tibco Mailbox, Service Now, Jira, Confluence

Methodology: SDLC, Waterfall

-Dynamic Currency Conversion:

This project was to provide Dynamic Currency Conversion for eligible non-Canadian currency VISA cardholders when they visit a TD CAD dollar ATM. Conversion by TD will be presented and processed in the card holder’s home currency with a disclosed foreign exchange rate. TD earns revenue when this option is selected.

-Multi-Currency ATM:

While the name was Multi currency, it is a Dual Currency project. Before this project, TD ATMs in Canada dispensed either CAD or USD, but not both. The purpose of this project was to enable the ATMs to dispense CAD, & USD from the same terminal.

-Adding new Sales offers or enhancing existing ones.

-Served as the single point of contact for ATM Sales offers and ATM Cash forecasting Production inquiries.

-Changing the Vendor for TD Cash Management services as per current market price and services.

-Changes for adding new acquisitions. (Currently First Horizon)

-Handling customer inquiries, concerns

-Business inquiries on transaction details

-Analysis of Fraudulent transactions at the ATM

-Pilot Sales offer set up.

-Files not sent / received from to vendors.

Full time mom at home / away from work (Sep 2014 - Sep 2018)

Sr. Technical Systems Analyst – Royal Bank of Canada – Canada (May 2013 - Sep 2014)

As an onshore-offshore lead, Meghna also worked with the client to elicit requirements and prepare the SRS and the Technical Design document for the team.

Maternity Leave (Apr 2011 - May 2013)

Sr. Technical Systems Analyst – iGATE Corporation, Client - Royal Bank of Canada – Canada (Sep 2008 - Apr 2011)

Enterprise Client Solutions Enhancement, Maintenance

Mainframe: MVS, Z/OS, TSO/ISPF, COBOL, JCL, UNIX, SQL, SAS, TSO ISPF

Databases: DB2, Teradata

Tools: File-Aid, Xpeditor, Endevor, Zeke, SPUFI, Connect:Direct,

Methodology: SDLC, Waterfall, Agile

-Maintenance & Enhancement Lead for 4 applications bearing complete ownership and responsibility for offshore and onshore team’s technology delivery from high-level design, technical design, code reviews, implementation plan, post-implementation verification and warranty support.

-Responsible for Planning/supporting the project manager in estimation, resource planning and tracking risks/dependencies.

-Work with development leads to define code drops and coordinate the alignment of code-drop dependencies.

-Active involvement in QA test case reviews and Test results review

Technical Lead – iGATE Corporation, Client - Royal Bank of Canada – India (Jul 2007 - Sep 2008)

-Complex analysis of 3 interfacing applications (SRF, VISA and TSYS) in the client systems area of RBC banking to identify any out-of-sync scenarios (transaction overflow); This was a 30+ year old application and the focus was to identify and resolve application latencies.

-Track the transaction flow from start-to-end, document the entire flow and determine out-of-sync scenarios.

-Conduct rigorous brain-storming sessions with the team to ascertain the validity of the identified scenario and derive a fix for the out-of-sync scenario.

-Prepared process mapping charts and studied operational procedures.

Developer to Senior Developer - IBM, Client – American Express – India (Nov 2002 – Jun 2007)

Mainframe: MVS, Z/OS, TSO/ISPF, COBOL, JCL, SQL, TSO ISPF, CICS

Databases: DB2, DB2 Stored Procedures

Tools: File-Aid, Xpeditor, CHANGEMAN, INFOMAN, JobTrac, SPUFI, ICETOOL, Connect:Direct, Service Now

Methodology: SDLC, Waterfall

-Planning, Estimating, Requirement Analysis, High Level and Technical Designing, Coding, Unit & System Testing

-Review design, code, and test results & coach junior team members

Developer – Syntel Inc., Client - Target Corporation – India (Jul 2000 - Nov 2002)

Mainframe: MVS, Z/OS, TSO/ISPF, COBOL, JCL, SQL, TSO ISPF, Expediter, CICS, MQ

Databases: DB2

Tools: File-Aid, Xpeditor, Endevor, SPUFI

Methodology: SDLC, Waterfall, Agile

-Analysis, Detailed Technical Designing, Coding, Unit, System, and Integrated Testing

Academic

-Bachelor of Electronics Engineering, Mumbai University, 2000, India

-IBM DB2 Universal database v8.1 [Exam 700]

Training

-SAS (2010),

-CICS (2000),

-Requirement Elicitation,

-Root-cause Analysis,

-Change management,

-Fundamentals of Project management

Contact this candidate