Analyst Sales

Vikas Baranwal

Cell – +1-717-***-**** Email – ************@*****.*** LinkedIn – vikas-baranwal-95293048

SUMMARY:

Operations and Project Management professional with 12 years of experience in Banking and Operations industry, hands on experience in handling Projects, Migrations and UAT. Holding a bachelor’s degree in Commerce plus a Diploma Degree in Business administration, currently studying MS in Project Management from Harrisburg University with CPT, OPT and STEM work authorization.

PROFESSIONAL EXPERIENCE:

WLXT LLC March 2020 – Till Date

Business Analyst – New Jersey USA

Currently looking after the Transitioning of inventory software program ARMS.

Performing manual testing on various functions of ARMS software and raising issues to the production and getting the queries resolved about different bugs.

Raising request and making BRD, FRD for new features in the ARMS software in terms of reporting.

Contributing in Building new products, attending conference calls with vendors, clients, Partners, and Sponsors on managing product quality operations according to quality agreements.

Working on reporting activities relating to sales, returns, transfers and performing reconciliation activities.

KOTAK MAHINDRA BANK LTD February 2017 – December 2018

Senior Manager Operations – Mumbai, India

Kotak Mahindra Bank was one of the largest banks in India in terms of deposits and mortgages. MISys application is used by the employees of the Bank to manage the flow of the work, same is used to create payments, booking loans and cash collateral, balance transfers and reporting. I was involved in testing this cloud-based banking application.

Worked in Waterfall Environment.

Participated in formal review of business & functional requirements and in application design phase. Written the Test Plans, Test cases and executing the test cases.

Coordinated test schedules and assisted in managing the overall progress of all test activities against the test plan. Reported the Defects using JIRA.

Looked after the manual testing on the Applications, attended walkthrough meetings with Business Analysts and Developers.

Coordinated with Developers and PMs to ensure smooth delivery of test deliverables, Involved in Functional, Regression, System and GUI Testing.

Responsible in providing regular test reports, status reports to the project team and Created quality assurance relevant documentation.

Created the Requirement Traceability Matrix (RTM) to ensure the coverage of requirements.

DEUTSCHE BANK GROUP January 2012 – February 2017

Senior Business Analyst – Pune, India

Handled STP Discounting process for US, Europe, Spain and Asia branches for both Accounts Payable and Receivables along with various functions like reconciling accounts, Preparing MIS, Revenue, Performance reports on weekly, monthly and adhoc basis.

Coordinating on mails and calls with product, branch, sales, client service, cash operations, implementations and IT support in order to get the issues resolved in a timely manner.

Conducted UAT, Sanity Testing for system up-gradation.

Effectively handled projects for Migrating clients from manual platform to STP platform, which helped organization to save on $25K to $50K annually by eliminating contract position(s) for data gathering and analysis.

Managed and developed global standard configuration for the ACH and Fedwire payment systems for the Global wholesale settlement product.

Worked with business resources as technical expert to define data collection and reporting requirements for the ACH and Fedwire payment systems.

Selected by management to lead the implementation of strategies in migrating the manual operations to an automated STP process in North America and Europe.

Responsible for the success of reporting changes in the converting business and for the success of the implementation of the E-Bills application.

Developed web-based reports and analysis tools for the business using SQL stored procedures, Visual Basic and Visual Basic for Applications (VBA).

Successfully met challenges of language differences and an aggressive implementation schedule.

JP MORGAN CHASE June 2011 – December 2012

Senior Business Analyst – Mumbai, India

Effectively worked on improvement of ACH payment/settlement systems (GTB – Global Transaction Banking) in order to ensure the smooth flow of various payment swift messages like MT103, MT100 and MT202 which helped in reducing errors and reduced delays in payments to the clients.

Acquired and documented the business requirements.

Responsible for analyzing and reviewing validation deliverables like User Requirement specification and Functional requirement Specification.

Customized and validated different features of the GTB.

Prepared Validation Master Plan (VMP) for validating GTB.

Analyzed and reviewed Installation Qualification (IQ), Operation Qualification (OQ), Performance Qualification (PQ) protocols.

Developed and reviewed test scripts and test cases for automated and regression testing.

Executed the test cases stored in the Test Plan and reported the defects.

Performed user acceptance testing to the check the various functionalities of GTB.

Generated Validation Summary Report to summarize and document all validation activities.

Developed and reviewed Standard Operating Procedures (SOPs), Requirement Traceability Matrix and Work Instruction for various functionalities of the system.

Used Defect Management grid of Quality Center in logging and analyzing issues.

Conducted GAP analysis and prepared Remediation Plan.

Responsible for ensuring the compliance of OFAC and AML regulations.

CITIGROUP GLOBAL SERVICES LTD February 2007 – June 2011

Business Analyst – Mumbai, India

Handled LC Import and Export Payment transactions for 18 Latin American branches, queries for countries like North America, Latin America and Europe regions Via swift and Telex, email queries and escalation mails.

Taking conference calls Related to projects like process and system improvement, training, consultancy guidance and user support to new team members.

Developed Performance Improvements via (SLAs), escalation and triage procedures coordinated with cross-functional support teams to prevent and or minimize production downtime.

Maintained adequate staffing and coverage levels to exceed customer expectations and deliver superior customer satisfaction.

Ensured proper training and team certifications to meet customer needs and employee development.

Encouraged root cause analysis for re-applying lessons learned to preventive strategies using formal problem-solving approaches.

EDUCATION

Harrisburg University Expected completion date – December 2020

Master’s in Project management

ICFAI Business School June 2011

Diploma in Business Administration

Mumbai University July 2005

Bachelor of Commerce

TECHNOLOGY: Microsoft Outlook, MS Project, Word, Excel and PowerPoint, MySis, GTB – Global Transaction Banking system for wholesale ACH settlements, Trims, Titan, Pega, Citi-Checking, Citi-Direct. DBDI, IDMS, TF3, E-Bills, FSC.

SKILLS: Trade Finance Operations - Letter of Credit, Collections, Standby Letter of credit and Supply Chain Finance. Account Payable and Receivable. Cash Management Operations, Global Payments and settlements Swift Messages - WIRE Transfer and Foreign Remittance, Reconciliation, Audit, Experience in UAT, developing testing plans, site operations. Migration and Client Service Strong leadership and collaborative skills, especially as a liaison between business and IT Dev team Strong project management skills with proven track record of delivering high quality work under tight timelines. Strong strategic and analytical thinker with exceptional execution and problem-solving capabilities.

Contact this candidate