SUMMARY

Over * years of experience as Business Analyst on large time boxed projects with strong domain knowledge in healthcare, finance and insurance.

Extensive experience in defining system requirements, writing use cases and functional specifications, documenting business requirements and potential solutions, modeling current and future state process flows, and creating system documentation.

Experience in creating UML (Unified Modeling Language) diagrams such as activity, use case and sequence diagrams.

Analysis and Review of Software and Business Requirement Documents.

Provided data summaries and reports using Data Collection.(SQL queries are written to extract the data from various sources)

Possess SQL programming skills, understanding of data warehousing concepts and experience in working with databases.

Demonstrated proficiency and experience in producing reports utilizing dashboards.

Excellent oral and written communication skills with ability to communicate with all levels of management and team members.

Possess exemplary technical writing, presentation, listening, time management, JAD session facilitation, interpersonal, organizational, interpretation, problem escalation, leadership, decision making, motivational, issues management, and influencing skills.

Ability to solve complex problems independently and generate innovative solutions.

Ability to manage group dynamics, facilitate team interaction & negotiate effectively.

SAS certified programmer, Proficient in developing study designs and analyzing large databases in pharmaceutical or clinical trial environment - SAS/BASE,SAS/TABLES,SAS/SQL in UNIX environment

Experience in Data Manipulations procedures such as SAS Formats, Merge, Proc Append, Proc Datasets, and Proc Sort.

Extensive experience in Microsoft Excel, Access, PowerPoint.

Excellent background in project planning, scheduling, and implementing.

Programming knowledge with ASP, HTML, PHP, Visual Basic, C++, and Database Management Systems like Oracle, My SQL

Create and present executive reports using Microsoft Excel, PowerPoint, Access and Word.

Developed Traceability matrix in the process of managing the requirements.

Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio, Rational Suite and SQL.

Highly motivated self-starter with excellent communication, presentation and interpersonal skills, can perform well both independently and with a team, always willing to work in challenging and cross-platform environments.

EDUCATION

MS in Computer Science – Gujarat University, India

BS in Computer Science – Sardar Patel University, India

SAS Certified

Business Analysis Certified – Liberty Institution Inc.

TECHNICAL SKILLS

Operating Systems: Win 95/98/NT/2000/XP

Business Modeling Tools: Microsoft Visio, UML, Rational Rose

Project Management: Microsoft Project, Microsoft Office (Word, Excel, PowerPoint)

Testing Tools: Rational ClearQuest, WinRunner

Databases: MS Access, SQL Server 7.x/2000, 2005,Oracle 8/8i

Programming Language: SQL, PL/SQL, Visual Basic, Java,J2EE

Web Technologies: HTML, XML, JavaScript, VB Script

Content Management Tool: Microsoft SharePoint server

PROFESSIONAL EXPERIENCE

UNITED HEALTH GROUP, Atlanta, GA

FULL-TIME employee

June,2013 - present

Government Business Analyst

Aetna, Orlando, FL (Full-Time Position)

ASRX(Aetna Specialty Pharmacy), Orlando, FL

September 2011 – January 2013

Business Analyst

Aetna offers a broad range of traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioral health, group life and disability plans, and medical management capabilities and health care management services for Medicaid plans. Depends on the client a requirement, the data collection is performed on Data Warehouse (Database for claims data).

Responsibilities

Performed research and analyzed complex healthcare claims, and pharmacy data. Provided data summaries and reports using Data Collection.(SQL queries are written in MS Access 2010)

Performed all aspects of data analyses (i.e., data acquisition, data management, programming and documentation) and identified data issues.(Using SQL and Access 2010 and Visual Basic Scripts)

Created complex queries and worked on technical report/programming. Developed macros and forms

Developed system work flow diagrams.

Worked on different kinds of requests from different department’s clients. (Adhoc requests). Submitted Daily, monthly, quarterly standard reports for various departments of Aetna.

For any Adhoc request from the client, SDLC method was followed to analyze, design and code.

Assesses the quality of analysis data and performs cross-study analysis to identify and correct data issues and combine data from various sources like Data Warehouse(where all medical and Pharmacy claims data resides) and Compass (where all day to day tasks of ASRx(Aetna Specialty Pharmacy) information resides)

Builds statistical models using multiple data sets to predict the likelihood of events or outcomes

Developed and implemented advanced analytic and data-mining methods.

Created reports provides data quality, consistency using Crystal Reports 2008 and worked on OBIEE(Oracle Business Intelligence Enterprise Edition)

Participated in JAD Sessions for enhancing results.

Performed analysis and translates business needs to create high-quality Business Requirements and Functional Specifications documentation within specified time frames to solve moderately complex problems (multiple interfaces with other systems within a business unit)

Technologies: - Visual Basic, SQL, MS Access, Crystal Reports 2008,MS Excel, MS Visio, Share Point, Sales Force

Fiserv, Lake Mary, FL

Nov 2010 – Aug 2011

Business Analyst/ QA Analyst

Fiserv is a diversified financing solution provider serving consumers, retailers and businesses around the globe in Commercial Lending and Leasing. The project was how interest should be applied to businesses who borrowed money from Banks. The project was built on Fiserv Technologies which will allow businesses and banks to allocate interest and allow businesses and banks to run and view reports.

Responsibilities:

Analyzed software requirement specification documents. Created processing model diagrams in UML/Visio using the business process information captured in the business context analysis documents.

Elicited requirements by employing information-gathering techniques (e.g., Interviews, surveys, business process analysis), competitive product analysis, reverse engineering of existing systems, etc.

Participated in the corporate wide BPR roadmap process to define the “To be” process based on Design for Six Sigma Methodology.

Developed functional requirements and a proposed data warehouse strategy for supporting employee compensation and compliance reporting/analytics.

Presented high level requirements and interaction diagrams using use cases, to user groups, as well as documenting requirements and getting them reviewed and base lining the same.

Analyze business requirements and segregated them into high level and low level Use Cases, activity diagrams using UML methodology.

Prepared Business Workflow models that cover "How" business processes are accomplished.

Involved in process modeling, reviewing and writing URS and Functional Requirements.

Participated in periodical Joint Application Development (JAD) sessions with the management and IT teams.

Interviewed business experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical communities.

Utilized Rational Unified Process (RUP) to configure and develop processes, standards, and procedures.

Performed UAT and Performance testing on the application.

Executed test scripts, verified defects with expected result and logged defects

Wrote SQL queries for multiple scenarios

Actively participated in Test Plan review meeting, walk through and defect report meeting

Created automated test scripts of the major functionalities of the application for functional testing

Interacted with business analyst, system analyst and developers to resolve technical issues and software faults

Used MS Office extensively (Word, Excel, Visio, Power Point, Outlook, Project) for analysis, presentation and documentation throughout the project.

Technologies: Windows 2000/XP, Rational Requisite Pro, MS Office, SQL Server, MS Project, MS Access, UML, SharePoint, Sales Force.

Wyeth Pharmaceuticals, Paoli, PA

Jul 2009 – Oct 2010

Business Analyst

FACETS Online Tool

I was working as a Business Analyst on a web portal development project- FACETS. The objective of the project was to develop an web portal based service delivery survey tool and customer feedback and escalation tool which had an end-to-end business process. It was a direct communication method for B2B clients.

Responsibilities:

Responsible for identifying scope, business and data requirements and artifacts of the project

Conducted personal interviews and surveys with customer/liaison managers for process pulse check

Interacted with cross-functional teams to facilitate gathering of business requirements

Responsible for organizing meetings between various functional departments and development team in order to understand ‘As Is’ customer escalation process workflow and ‘To be’ role based, function wise escalation process workflow needed to be automated in the tool

Built wireframes for the application using MS Visio

Analyzed Business Requirements and translated them into Use Cases, Activity Diagrams using MS Visio. And Requirements are imported to the software Rational Requisite pro for managing them properly.

Created the wire frames for application web pages

Assisted the business resource manager and the project manager throughout the inception and elaboration phases

Convened the SRS, ERD and SDD reviews and walk-through with designers, developers and stakeholders and facilitated document sign off. (The system Development Life Cycle (SDLC) method was used to work with the project requirement analysis and design).

Participated in UAT, identified software problems, wrote easy-to-follow bug reports, logged them into bug tracking database, monitored their progress and verified their fix Using QC

Attended project meetings, release meetings, and QA status meetings

Technologies: - MS Visio, MS Project, QC, QTP Storyboards, Java, LAMP, XML, Rational Requisite Pro, UML, MS Excel, Java, Wire frames, Win Runner,

JP Morgan Chase, Tampa, FL

Mar 2008 – Jun 2009

Business Analyst

JP Morgan Chase is a leading global financial service in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management and private equity. This project was developed specifically to support Wealth Management Groups to provide most valuable advisory services to clients on Asset Projections, Equity, Options, futures, Fixed Income, Credit Management, Risk Analytics, Portfolio Rebalancing, Investment Holdings, Trading, Liquidity needs and Future goals. The systems solutions advise the clients on wealth management strategies, provide clear and complete picture of the clients’ assets in position, full brokerage capabilities, research data, tax and insurance information.

Responsibilities:

Gathered high level requirements from stake holders located globally and developed scope along with the PM of the project for the implementation.

Developed a SOX remediation framework, prioritize audit issues, address audit issues and assisted the client in improving the legacy audit processes by providing best practices recommendations on streamlining audit and compliance processes.

Conducted weekly meetings for deciding and reporting on the Policies and Procedures to be followed.

Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.

Provided input (scope, goals, risks, constraints, timelines and interfaces) to PM for project planning and control.

Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.

Reviewed the Business Requirement Documents (BRD) with the cross functional team to analyze the High Level Requirements. To manage the requirements properly, the Rational Requisite Pro was used for the project.

Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.

Developed process flow depicting business activities, and performance metrics.

Conducted interviews, meetings and JAD sessions with financial advisors during the Requirement Gathering process.

Planned and documented procedures for data processing and prepared data flow diagrams for the application.

Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.

Prepared Functional Design Specifications (FDS) employing Use case scenarios, sequence diagrams, DFDs and class diagrams.

Identified and clearly defined functional issues and supported IT development staff throughout the design, development, unit testing, and implementation phases of the software development life cycle.

Documented the Requirement Traceability Matrix for tracing the Test Cases and requirements.

Documented and assisted the QA Team with the Test Plan.

Performed User Acceptance testing and documented results.

Trained customer team on new processes and operational procedures

Technologies: Rational Requisite Pro, Rational Rose, MS Word, MS Power Point, MS Excel, MS Project, Visual basic 6.0, Oracle 11i,.NET.

CIGNA Healthcare, Philadelphia

Nov 2006 -Feb 2008

SAS Programmer

Project Description:

CIGNA Corporation has been serving people to live healthier and more secure lives. CIGNA is now developing a new Consumer Driven Product Line as “MYCIGNA.COM”, which offers a very user friendly featured web portal for the members as well as the providers based on several features including the Medicare Part –D (pharmacy) and Medicaid features. MYCIGNA helps consumers manage health care benefits and provides access to WebMD's suite of health information and decision support tools.

Responsibilities:

Developed study designs and analyzed large databases of Cigna using - SAS/BASE, SAS/TABLES, SAS/SQL. The resulted data were submitted for analysis. For example, working on members and providers Medicare and Medicaid data using SAS programs and using it for project analysis.

Responsible for the detail design documentation, unit testing and maintenance of internally developed applications and externally purchased software products

Write code for system designs that span platforms

Code to and create Application Programming Interfaces (APIs)

Write code for enhancing existing programs or developing new programs

Write detailed technical specifications for subsystems and identify integration points

Estimate project timelines and resources required to complete programming projects

Perform unit testing and debugging and set test conditions based on code specifications

Supports application throughout the Product Development life cycle

Coordinate with areas for integration architecture solutions and determine the integration approach,

Review vendor research and gap analysis, make vendor recommendation to technical team and client

Worked with all members of the project team, following the project through the Systems Development Life Cycle and ensuring business objectives are met (extensive project life cycle experience).

Technologies: MS Visio, MS Office (MS Excel, MS Word, MS PowerPoint), - SAS/BASE, SAS/TABLES, SAS/SQL in UNIX environment and Microsoft SharePoint.

Gentiva Healthcare (GTIV)– Tampa, FL

Aug 2005 – Nov 2006

SQL Developer

The Gentiva family of companies has been bringing great healthcare home for nearly four decades. Gentiva nurses, therapists and other healthcare professionals are dedicated to educating and empowering patients to take charge of their own care, so they can achieve the highest possible level of health and independence.

Responsibilities:

Involved in development and testing of Oracle data scripts

Developed Oracle database including analysis, design and modeling; created tables, constraints, views, sequences, triggers, stored procedures; tuned SQL statements. MS Visual Basic was used for user interface, MS Access; SQL Server was used as a back-end database.

Responsible for creating reports based on complex queries.

Gathering the client’s requirements,handling client queries

Analyzed Database Reports and Prepared graphs using the modified data for business analysis.

Technologies: MS Office, SQL, MS Excel, MS Word, MS PowerPoint, MS Access and Microsoft Share Point, Apache server

Contact this candidate