Anu Garg

Phone: 480-***-**** ac2sae@r.postjobfree.com

** ******** **, **********, **

Professional Summary

Over 10 years of strong experience as Business Analyst in devising IT/ERP (Peoplesoft) solutions across multiple industries.

Certified Scrum Master with experienced in facilitating team scrum meetings (daily, sprint planning, sprint review, retrospective, backlog grooming sessions) using tools like JIRA Agile, Confluence.

Led project teams of system analysts, data analysts and business analysts, to achieve project goal on complex, multifaceted projects.

Proficient in gathering business and systems requirements; analysis at code and data level such as data mapping and data conversion analysis.

Expertise in writing & executing complex SQL, MS-SQL queries and stored procedures in Oracle, DB2, Teradata.

Successfully designed, implemented, and supported systems ranging from project-based applications to large, complex, corporate-wide programs in a number of organizations.

Developed business cases, stories for the requirements and gap analysis, prepared and executed test plans for System and UAT testing, executed the test cases and facilitated the testing in various phases.

Well versed with all phases of Software Development Life Cycle (SDLC) including analysis, design, development and testing of software application in methodologies such as Agile (SCRUM), Waterfall, Rational Unified Process (RUP).

Strong technical experience in Relational databases, defining schema and business rules.

TECHNICAL SKILLS

Database

My SQL, Toad, SQL Server, Teradata,Oracle 9i, 10g, SQL Server, IBM DB2,UNIX

Languages

SQL, XML, SQRs

Operating systems

Oracle 9i, 10g, SQL Server, IBM DB2

Methodologies

SDLC, Waterfall, RUP, Agile- SCRUM

Management tools

SharePoint, STAT, MS Office, MS-Visio

Professional Experience

United Health Group, Hartford, CT Mar 2016-Jun 2017

Senior Business Analyst

Working in Reconciliation for different source systems in Medical, Pharmacy and Membership claims.

Evaluate business requirements and prepare the detailed functional and technical specifications that follow project guidelines.

Act as the liaison between Business and Systems Analysts, Developers and project management groups.

Perform walk-through of the requirements with Developers and Quality Assurance Analysts to ensure requirements and design are completely understood.

Communicate design to all stakeholders and varying levels of the organization.

Work closely with business teams to strategize solutions that support long term business objectives.

Work and assist business in user acceptance testing.

Create and execute test scripts, test cases and data sets with business team when needed.

Worked on reconciliation work that involved building complex SQL queries in Teradata.

Rabo Bank, Manhattan, New York Aug 2015 – Feb 2016

Business Analyst

Configuration of Reconciliation tool for capturing data for Financial modules like GL, Account Payable.

Working with users to develop and implement Reconciliation tool.

Developing table structure based on input file and help team in developing tool.

Developed complex SQL queries.

University of Connecticut, Storrs, CT Nov 2014 – July 2015

Business Analyst

Lead the testing of new/modified applications to ensure applications and results meet HR needs.

Migrate Third party data to UCONN Recruitment Solutions for process efficiency of Recruitment process.

Develop relational databases and Data table structure using business processes and business requirements

Monitor production batch and ad hoc jobs to ensure proper functioning and completion of business operations for smooth business operations.

Present and conduct business and technical walkthrough sessions to validate business needs.

Implement HR technologies such as PeopleSoft, Java with other integrated systems.

Implement and plan production support and user training needs.

Analyze data for mining, scrubbing, conversion and mapping.

Trinet, San Ramon, CA Feb 2014- Oct 2014

Business Analyst

Configured Benefits systems, including: HRAs for Medicare eligible retirees, Health Savings Account, Limited FSA, Benefit Plan Coverage Levels / Eligibility.

Maintained HR related Oracle ERP modules; analyzed system functionality in relation to departmental work flow for the purpose of continuous improvement and efficiency.

Collected and researched specific requirements for reported issues or requests, identified requirements, gathered workflow data and basic system and reporting specifications.

Created test strategies, test scripts, and executed testing in support of system and user acceptance testing.

Developed, integrated and supported PL/SQL stored procedures.

Employer - IBM

Client - RAYMOND JAMES Reimplementation Project, Pittsburg, PA Sep 2011-Jan 2014

System Analyst

Provided system support for couple of new application as well as production support operations for reimplementation of Oracle ERP modules.

Collaborated with project Business team to gain an understanding of business processes.

Conducted impact analysis and collaborated with the team to resolve complex business requirements.

Collaborated with offshore development team; identified and resolved potential project risks, resulting in quality code with fewer design defects.

Streamlined implementation and support of project related systems changes.

Planned UAT testing- develop test strategy, plan and scripts.

Ensured due diligence on defects and enhancements reported during the course of the project.

Employer - CSC Computer Science Corporation

Client - RBS Global HCM/Finance Implementation, Gurgaon, India Aug 2009-Aug 2011

System Analyst

Merged the ABN AMRO bank functionality with existing RBS functionality with taking care of current business.

Loaded the ABN data in RBS systems using Component Interface (CI) for different countries like Luxemburg, Norway, Greece, Belgium etc.

Implemented procedures to help business users increase productivity and streamline their global processes.

Led user acceptance testing to ensure that all functional subject matter experts have the necessary information to test and execute any changes to their business processes.

FORD Time and Labor Implementation, Chennai, India Nov 2008-Aug 2009

System Analyst

Implemented Oracle ERP Time & Labor module, replacing existing mainframe PERSY system.

Conducted Gap Analysis between the old mainframe legacy reports and the New Built reports to incorporate all the necessary information in the new reports.

Developed High Level Design Document, Low Level Design Document and test plans.

Developed application and system code, participated in code reviews, created technical designs, conducted module and user interface testing and performed ongoing maintenance.

PFIZER Upgrade Project, Chennai, India Jul 2007-Oct 2008

Associate Engineer

Upgraded the Pfizer Oracle ERP HR module from 8.3v to 9.0v.

Analyzed customized batch objects.

Performed data mapping and functionality mapping analysis between the 8.3 and 9.0 versions

Prepared Data Conversion Scripts.

Education & Credentials

Master of Technology: IIT, Delhi

Master of Science: IIT, Delhi

Bachelor of Science: CCS University

Contact this candidate