Project Data

Email: ac6g42@r.postjobfree.com Ph: +1-804-***-****

Summary of Qualifications

Around 10 years of experience as a techno-functional BA/Quality Analyst with exceptional record of delivering cost effective, high performance technology solutions to meet challenging business demands. Extensive qualifications in all facets of information systems methodology from conceptual design through documentation, implementation, quality review, and enhancement. Worked extensively with Fortune 10 companies.

Hands on experience in Java, Oracle, PL/SQL, SSRS, TOAD.

Experience in writing Cursors, Stored Procedures, Functions and Packages in PL/SQL.

Experience in SSRS, Tableau.

Experience in workflow testing including unit testing, integrated system testing, regression testing, procedure testing, report testing.

Experience in documenting process flows and data mapping.

In depth knowledge of healthcare (claims, adjudication and enrollment domains), e-commerce and pharmacy domains.

Develop test plans for medium to complex systems to ensure application functionality meets original requirements to project.

Experience in Agile Methodologies, Extreme programming (XP) practices of continuous integration.

Experience and proficiency in preparing planning documents and written reports.

Experience in Medicare and Medicaid.

Ability to produce high quality requirement specifications to support ERP functional design development.

Writes detailed functional test plans to ensure system changes work properly, existing processes remain unaffected, and the needs of the users are met.

Creates scripts for training all internal users, support personnel, and external customers on ERP system changes and new procedures.

Experience with MS Office (MS Word, Excel, PowerPoint and Project)

Assisted client with preparation of production procedures and participate in troubleshooting.

Involved in Project Planning, Coordination and implementing various methodologies.

Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.

Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.

Work independently with users to define concepts and under direction of project managers.

Certifications & Trainings

Scaled Agile, SAFe Practitioner

Six Sigma (Green Belt) certified

Skills

Requirements Gathering & Analysis User Acceptance Testing (UAT) and Functional testing

Project Management Enterprise Implementations

Fill Lifecycle Implementation Stakeholder communication

Date Mining & Analytics Risk Management

End User Training Root Cause Analysis

Technical Skills

Programming Languages

Core Java

Functional Skill Areas

Supply Chain/Health Care/Aerospace

Client/Server and Web Technologies

Java, Swing

Database

MySQL, Oracle 8i/9i/10g, SQL server

Operating Systems

Windows 10/8

Testing and Build Tools

Rational Robot

Tools

UML, Visio, ERwin, JIRA, Rational Robot, TOAD

IDE

Eclipse, JBuilder, IntelliJ

Methodologies

Agile programming [XP/Scrum, Sprint], Waterfall model

Reports

SSRS, Tableau

Project profile

Company : McKesson Specialty Health, The Woodlands, TX (Sep 2017 - Present)

Role : Business Analyst

Team Size : 3

Software : SQL Server2008, MS-Excel, PowerPoint, Visio

Oversee the precision implementation of action plans; supervise the identification of functional requirements, project design and development, implementation and go-live. Track and report workgroup status/issues and risks decisions to ensure project status transparency to leadership. Facilitate meetings with stakeholders to develop strategic plans involving prevailing business processes and workflows to determine project requirements.

My Role:

Completed in-depth analyses for business-optimization projects, reporting tools.

Provided executives with analytics and decision-support tools to metrics related to physicians and practices.

Implemented payer profile dashboards to track major payers by practices and how their contracts perform.

Worked closely with key payors, departments, physicians, stakeholders and IT leadership to ensure successful outcomes of the software migration.

Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as a primary driving force behind a 5% increase in margins this fiscal year.

Involved in delivering multiple projects across various platforms ranging from drug distribution, metrics tracking, payer fee schedule, CMS related projects.

Develop and contribute supplemental presentation materials adopted for use by additional personnel.

Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.

Performed quality assurance, system integration and user acceptance testing facilitating on-time, on-budget and acclaimed “go-live” of enterprise implementations for up to 107 practices.

Documenting Business Requirement Specifications, Functional Requirement Specifications and System Requirement Specifications, Process flows and data mapping.

Developed test cases, test reports, test scenarios and make sure every defect is logged.

Regression and Smoke Testing on Tableau dashboards.

Work closely with the LTAs (Lead Technical Architect) and stakeholders.

Involved in sign-off and performance tuning of the application.

Worked on multiple phases of the Software testing life cycle (SLTC), leading more efficient execution and reduced effort.

Ability to communicate bugs to developers and stakeholders and focus on deadlines and deliverables.

Report creation in Tableau.

Company : UnitedHealthCare (Dec-2011 – Mar 2017), Bangalore India

Role : Team Lead - BA

Team Size : 8

Software : SQL Server2008, SSRS (Visual Studio 2005/2008), MS-Excel, PowerPoint, Visio

The project is dedicated to offering healthcare programs and services that help improve the quality of care for Medicare beneficiaries with chronic illnesses. It provides innovative chronic care solutions for Medicare beneficiaries and providers that encourage better management of chronic diseases such as diabetes and heart failure.

My Role:

Completed in-depth analyses for business-optimization projects, reporting tools, back-office programs.

Provides expertise to the training department on HEDIS and STAR measures and tools that support. collection of and communication about HEDIS and STAR to the enterprise.

Develops HEDIS, STAR member and provider engagement strategies.

Collaborates with Optum executive teams to execute HEDIS and STAR strategies.

Implemented the company highly profitable Medicare Risk Adjustment Factor (RAF) program.

Using SQL, developed processes and applications to meet the data demand to achieve the financial goals of the RAF department.

In depth knowledge of claims, adjudication and enrollment domains.

Requirements analysis through JIRA (Creation of Epics and Stories).

Develop requirements specifications according to standard templates.

Develop BRD and workflow information using UML.

Involved in unit testing and functional testing using Rational Robot.

Generating SSRS reports using customized queries.

Effectively communicating with internal teams and external clients to deliver functional requirements like GUI, screen and interface designs.

Documenting and analyzing the required information and data.

Provided executives with analytics and decision-support tools used as the basis for reorganization, consolidation and relocation strategies.

Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as a primary driving force behind a 5% increase in margins this fiscal year.

Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.

Report creation in SSRS.

Project : Cloud Based SCM (May 2011 – Dec 2011), Bangalore India

Company : GT Nexus

Role : Developer/BA

Client : Adidas, GAP

Team Size : 24

Software : Java, JSP, SQL Server2005, MS-Office, Jira, Bugzilla

The project provides a single cloud-based collaboration platform at the center of a huge but enormously inefficient industry global trade and logistics and give companies a rapid, low-cost way to enable hundreds of inter-company supply chain processes on a global scale, across entire trading communities.

My Role:

Requirements analysis and information gathering.

Develop requirements specifications according to standard templates.

Effectively communicating with internal teams and external clients to deliver functional requirements like GUI, screen and interface designs.

Documenting and analyzing the required information and data.

Technical design and code update in implementing customer requirements.

Project tracking through Jira.

Tracking project bugs through Bugzilla and prioritizing them.

Collaborate with customers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.

Be the liaison between the business units and support teams.

Project : Validation and Verification/Selection (Oct 2005– Dec 2007), Bangalore India

Company : Honeywell

Role : Developer/BA

Team Size : 3

Software : PL/SQL

SCM Tools : CM21

Every 28 days, Honeywell takes Aeronautical data from various data suppliers in ARINC 424. CorePT tool stores this Aeronautical data into Oracle database and then process on these data and produces Navigational databases in several binary formats used by Honeywell products. This Navigational data can be viewed using CorePT Data Utility or by OneNav Tool.

The main aim of V&V/Selection is to produce navigational data that is used by airliners to fly across destinations daily. To produce navigational data, we used PL/SQL programming as a back end and Oracle Forms and Reports as the GUI. We followed Design for Six Sigma methodologies in all the phases of life cycle and one of the Extreme Programming Methodologies (Pair Programming) during Implementation and Testing Phases.

My Role:

Analysis of requirements.

Representing the team in program level (group of projects).

Create Logical and Physical data models using ERwin tool.

Understanding business process management and business requirements of the customers and translating them to specific software requirements.

Implement Forward and Reverse engineering on the database using ERwin tool.

Use Erwin tool to script SQL Data definition language, directly executing on the database.

Heading GUI design and Database components design.

Involved in generating monthly database for airliners.

Involved in product demonstration to the customers.

Development Environment:

PL/SQL, Toad, Oracle 6i Forms and Reports, Rational Robot

Project : Consultant/Technical Support for Web (Dec 2006– Dec 2007), Bangalore India

Company : Honeywell

Role : BA

Team Size : 8

Software : PL/SQL, JSP

SCM Tools : CM21

Navigational database is produced by production engineers using the PL/SQL code and the data sent by data suppliers. The database is then sent across to airliners which aid in navigation. This is done on a monthly basis. To reduce the burden on the production staff WEB implementation was initiated. The database and the code to produce the data remained the same while work on GUI was initiated to speed up the process using WEB.

My Role:

Analysis of requirements.

Involved in database design.

Involved in design translation from pre-existing Oracle forms and reports into JSP.

Heading GUI design and Database components design.

Implementation of aeronautical data selection based on graphical display of World map.

Perform Black box testing.

Technical Support for design of GUI.

Representing the team in program level (group of projects) meetings.

Involved in product demonstration to the customers.

Development Environment:

Oracle 9i, JSP

Project : Tool to aid in metrics development (Apr 2005– Oct 2005), Bangalore India

Company : Honeywell

Role : Developer

Team Size : 2

Software : Visual Basic 6.0, MS-Access

Tools : CVS

Tool to plot project metrics effectively using real time data.

My Role:

Analysis of requirements.

Gathering aeronautical data.

Come up with the association among different sets of real time data.

Design and development of GUI.

Design and development of database.

Perform White box testing.

Plot the metrics in a graphical representation using Visual Basic 6.0 and MS Access.

Development Environment:

Visual Basic 6.0, Access

Project Intern: Worked at TATA Consultancy Services (TCS) from March 2005 till Jul 2005.

Client : American Express

Team Size : 3

Had to develop GUI for project managers to assign work to respective teams and keep track of the schedule and the slippage.

My Role:

Analysis of requirements

Design and development of GUI using Core Java

Design and development of database using MS-Access

Perform White box testing

Involved in weekly updates about the tool

Development Environment:

Core Java, MS-Access

Contact this candidate