Sr Business Analyst
Resume:
Chirag
Sr. Business Analyst
******.***.*******@*****.***
PROFESSIONAL EXPERIENCE
SUMMARY
. Over 8 years of IT experience working as a Business Analyst with the
ability to work independently and manage business expectations with a
delivery-focused approach to work; ability to build and maintain strong
working relationships with senior and junior business sponsors; as well
as technical specialists.
. Expertise in Business Requirements gathering, Understanding the Business
Process Flow, Business Process Modeling and Analysis and in testing the
Deliverables.
. Extensive experience in implementing Software Development (SDLC)
principles and methodologies such as Agile, Rational Unified Process
(RUP), and Waterfall Method in development.
. Thorough understanding of the workflows of diversified industry sectors
including Healthcare, Banking and Finance
. Expertise in creating Business Requirement Documents (BRD), Use Case
Specifications, Functional Requirement Specifications (FRS), System
Requirement Specification (SRS).
. Extensive Documentation Skills including preparing test plans, user
instruction manuals, programming procedures and guidelines.
. Extensive experience in developing Use Cases, creating Screen Mockups,
conducting Gap Analysis, Impact Analysis, SWOT Analysis, Cost Benefit
Analysis, & Risk Analysis.
. Competent in Creating Unified Modeling Language (UML) diagrams such as
Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence
Diagrams to support the development team and business groups.
. In depth understanding of the AS-IS and TO-BE business processes and
experience in converting these requirements into technical specifications
for preparing test plans.
. Strong experience in conducting User Acceptance Testing (UAT) and
documentation of Test Cases. Expertise in designing and developing Test
Plans and Test Scripts.
. Responsible to Track, Document, Capture, Manage and Communicate the
Requirements using Requirement Traceability Matrix (RTM) which helped in
controlling numerous artifacts produced by the teams across the
deliverables for a project.
. Steered JAD sessions interviewing and assimilating information from
Subject Matter Experts (SMEs), domain experts and disseminating
information to project managers, architects, development teams and
various other stakeholders.
. Involved in Test Planning, Test Preparation, Test Execution, Issue
Resolution and Report Generation to assure that all aspects of a Project
are in Compliance with the Business Requirements.
. Strong knowledge on MMIS system including MMIS security, reporting,
information retrieval system.
. Working Knowledge on Medicaid regulation, State and Federal Healthcare
policy
. Facilitated Change Management across entire process from Project
Conceptualizations to Testing through Project Delivery, Software
Development and Implementation Management in diverse Business and
Technical Environments.
. Successfully coordinated efforts between the business team and the off
shore development team in ensuring completion of projects within the
tight time schedules.
. Extensive exposures to working with cross-functional teams on impact
analysis.
. Exposure to creating project schedule, project management plan, budget,
forecasts, resource management, project tracking & status reporting
. Comprehensive knowledge of the testing lifecycle within web, experience
with Six Sigma and KANBAN Methodology, Project Management and Client
Server Environment.
. Interface with clients from Operations, Marketing, Sales, Technologies,
and Outside Vendors and act as their customer interface point of the
Projects.
. Excellent interpersonal skills, analytical, problem solving and
presentation skills.
TECHNICAL SKILLS
Functional Modeling Tools MS Visio, Rational Rose, Rational
Requisite Pro, Share Point, IBM Lotus
Notes
Databases/ERP MS SQL Server, Oracle 9i, MS Access,
Sybase, SQL Navigator, Query Analyzer,
Management Studio
MS Office (Word, Excel, PowerPoint), MS Access, MS
Project
Mercury Quality, Test Director, QTP, SPSS,
TFS
SDLC Methodologies Agile, Scrum, RUP, RAD, Waterfall
Requirements Management, JAD Sessions, and
Project Deliverables, Artifacts, Six
Sigma, HLD and LLD
UML Activity Diagrams, Use-Cases, Class
Diagrams, Object Oriented Analysis and
Design RDBMS, Data Modeling, Data Mapping
Testing User Acceptance Testing, Black-box
Testing, Regression Testing, HP Load
Runner, HPQC, Rational Clear Quest,JIRA
EDI Standards ANSI X12, HIPAA Security Protocols, EDI
4010 / 5010
PROFESSIONAL EXPERIENCE
DME Automotive, Jacksonville, FL
March 2014- Current
BA/QA Analyst- Database Testing
DMEautomotive (DMEa) is the industry leader in science-based, results-
driven automotive marketing, and provides turnkey marketing to the largest
and most innovative automotive organizations. DMEautomotive specializes in
database marketing, on-demand marketing, sales & service retention and
reactivation programs, data analytics, real-time campaign reports and
tracking, Virtual BDC, on-site telephony services. The main role involved
data validation and check data integrity.
Responsibilities:
. Worked with System Analysts, Developers and other IT staff to test new
and existing legacy, network and xml web based applications
. Analyzed and interpreted design specifications, business requirements
and end-user feedback to apply information to the testing process.
. Used application specifications to create robust test plans and test
cases utilizing JIRA.
. Developed test scripts using Mind Maps and SQL.
. Created applicable test environments, when required.
. Linked system requirements documentation to test cases utilizing
JIRA.
. Performed User Interface, Functional, Integration and Regression
testing.
. Documented and discussed test execution results and created defect-
tracking records for discovered problems.
. Collaborated with Support and Development to research and test
production issues.
. Performed testing responsibilities with little to no supervision and
within specified time frames.
. Reviewed existing database to understand the gaps and design a data
cleansing strategy for database migration.
. Extensive interaction with Business, on missing data and steps ahead.
. Data validation and Data Analysis using SQL Queries.
. Created stored procedures through series of SQL statements for
achieving a consistent implementation of logic across applications.
. Run and maintain reports for business discussion.
. Support in Database migration from Legacy systems to new platform.
o Check data for duplication
o Rerun scripts after database upgrades to ADMIN TRACKING and
supplemental fields.
. Data testing and Data Review on the production DB post the fields are
populated
Environment: MS Word, MS Excel, MS Power Point, MS Visio 2003, Agile, SQL
Server 2008, MS TFS, JIRA, Mind Maps
AGL Resources, Inc., Atlanta, GA
December 2013- February 2014
System Analyst
The project scope was to upgrade Risk and to convert current Risk
Master Database to new version. Also, to Convert STARS database and Legal
Files database to Risk Master. Create a more efficient claims management
process within AGL Resources through one Risk Management /Claims
Management/Safety Performance System (Relational database that automates
current manual processes).
Responsibilities:
. Reviewed existing database to understand the gaps and design a data
cleansing strategy for database migration.
. Extensive interaction with Business, on missing data and steps ahead.
. Data validation and Data Analysis using SQL Queries.
. Testing for data integrity and data reconciliations.
. Run and maintain reports for business discussion.
. Support in Database migration from Legacy systems to new platform.
o Data Analysis for Vehicle and General Claims during UAT
o Check data for duplication
o Rerun scripts after database upgrades to ADMIN TRACKING and
supplemental fields.
. Data testing and Data Review on the production DB post the fields are
populated
. Coordinated with the IT team and Product Owners for Reviews of
documents and Sign Off's.
Environment: MS Word, MS Excel, MS Power Point, MS Visio 2003, Agile,
SharePoint, SQL Server 2008
Med Assets, Alpharetta, GA
February 2011- October 2013
Sr. Business Analyst
Responsibilities:
. Gathered and Analyzed the requirements and converted them
into Business Requirement Specifications (BRS) and Functional
Requirement Specifications (FRS) for the designers and developers and
QA Team to understand them as per their perspective
. Designed and developed use cases, activity diagrams and sequence
diagrams using MS-Visio
. Created "As-Is Business Models" to understand the existing claim
settlement process flow through interacting with SMEs, underwriters
and Finance department.
. Shared Knowledge by performing Impact Analysis on transition from ICD
9- ICD 10, made suggestions on UI and other changes required to be met
during transition
. Worked intensively with Medicare & Medicaid claims and claims
processing for 5010 X12 transactions.
. Assistance in client engagement including MMIS Compliance, Claim
Billing, and consulting on Reimbursement Criteria and Benefit testing.
. Consulting on Claim billing, claim analysis on Medicaid data and
reimbursement.
. Performed Gap Analysis for new functionality requirements, as well as
prioritized them based on actual business needs so as to align them
with the product release roadmap
. Involved in testing the conversion of the application by generating
test scenarios in test plan document, creating HLD and LLD.
. Validated data at the backend to ensure that all the Claims related
data has been loaded to the corresponding Data Sets in the Backend and
the pricing for these Claims is done as per the Standards
. Analyzed the results, generated reports and tracked the defects using
Quality Center
. Used SQL statements for Back-end testing
. Created and maintained the Test and Traceability Matrix
. Conducted System, Integrated and Regression testing to the application
using Business, Functional, User Acceptance and Usability testing
. Prepared test data in HIPAA compliant X12N format for both inbound and
outbound healthcare EDI transactions
. Trained implementation managers to work on the new application
. Extensively facilitated meetings/conference calls with stakeholders,
project managers, developers, QA Analysts and other end users based
onsite/offshore to deal with business and technical issues and
resolving the issues
. Lead a team of dedicated resources to focus on Project Compliance and
handover.
. Actively participated in all phases of testing lifecycle (Design,
Planning, Development and Results)
Environment: Windows 7, MS Excel, MS Visio, MS Project, SharePoint, UML,
SQL Server 2008, SDLC/Agile, Quality Center, Informatica, DB2
United Health Group, Hartford, CT
July 2009 -December 2010
Business Analyst
The project scope was to implement business process reengineering interface
to improve efficiency and effectiveness for data warehousing. The project
also involved database migration application to meet the reporting needs.
Responsibilities:
. Assisted in the initial project planning with the management along
with project scope, budget, timelines and other parameters.
. Preparation of system requirement specification documents to create
HLD and LLD, Test Cases and Test plans were extensively reviewed and
analyzed.
. Gathered user requirements through interactions with clients from
various corporate departments and converted these requirements into IT
specifications.
. Internal and External stake holders were updated on the progress
and changes were communicated throughout the project life cycle.
. Worked with ETL team for data upload process, helped in data
mapping with data mart and source systems.
. Reviewed stored procedures for reporting with actual report, Data
Mart (Oracle)
. Helped in Data mapping between data mart and source systems
. Acted as a liaison between users, business stakeholders and technical
team to keep them in sync with the project progress.
. Conducted GAP analysis to determine the project's current status
against the expected.
. Extensively used Rational Unified Process (RUP) guidelines through the
SDLC
. HIPAA 837i/p/d; 270/271, 276/277, 835, 275, 4010 and 5010 use cases
and design specifications were developed along with 837s and multiple
eligibility (270/271) healthcare claim status (276/277) along with in
depth knowledge of ICD- 9 & 10
. Traceability Matrix was used throughout the project to track changes.
Environment: Rational Unified Process (RUP), Windows, MS Office, HTML,
Windows, Oracle, Informatica, Microstrategy, DB2, Crystal reports
SunTrust Banks, Inc. - Atlanta, GA
Jan 2009-June 2009
Business Analyst
Worked on the online services project to help customers to manage their
accounts, which includes the tab for processes, such as, to obtain mortgage
loan information, make online payments, manage personal and amortization
schedules, obtain Documents, Forms, Payoff Statements and manage automatic
account drafting.
Responsibilities:
. Met with client groups to determine user requirements and goals. Utilized
Rational Unified Process (RUP) to configure and develop process,
standards, and procedures. As a liaison between the developers and
clerical staff, was instrumental in resolving conflicts between clerical
and technical development teams.
. Analyze business requirements and segregated them into high level and low
level Use Cases, activity diagrams,/State Chart Diagrams and Robustness
Diagrams using Rational Rose according to UML methodology thus defining
the Data Process Models.
. Development of standard documentation package (Requirements,
Specification, Design, Operations, and Quality Testing Plans).
. Created Use Cases, Collaboration, Object Sequence, Object Interaction and
State Diagrams for new features using rational.
. Developed Vision Document, SRS, and Use Case Documents. Derived
Functional Requirement Specifications (FRS) based on User Requirement
Specification (URS). Preparation of High Level (HLD) and Low-Level (LLD)
documents.
. Understand and articulate business requirements from user interviews and
then convert requirements into technical specifications.
. Interviewing Subject Matter Experts (SMEs), asking detailed questions and
carefully recording the requirements in a format that can be reviewed and
understood by both business people and technical people.
. Set up definitions and process for test phases including product test,
integration test, and system test. Work to fully implement test phase
entry and exit quality criteria, standard test reporting metrics and
standard test artifacts.
. Drafted test strategies, test plans cases and test scripts for the
installation, GUI, functional, Security, Recovery, performance and
integration testing for multiple software releases using Requisite Pro.
. Created different Traceability views to maintain the Traceability of the
requirements.
. Performed System Testing to ensure that the compiled software components
of the Applications adhere to Project Standards, Performance Criteria and
Functional Specifications.
. Frequently updated the requirement and defect status as per the current
status of the testing project in the Clear Quest.
. Actively involved in walkthroughs and meeting with development team to
discuss related issues.
Environment: MS Project, SQL, Rational Unified Process (RUP), Rational
Requisite Pro, Rational Rose, Clear Quest, Microsoft Visio
Principal Financial Group, Raleigh, NC
Dec 2007-Nov 2008
Business Analyst
The Project was to build a new trading Platform for Non-Qualified Plans
team and developing a web interface to market the plans offered by
Principal group (PFG), which sells Mutual Funds for Non-Qualified Plans.
Which would market the plans and PFG would trade daily-based transactions.
The Trading Platform was built using SQL Server as back-end. The web
interface was built using Java application. It also included developing an
Investment Management System to help users to view the portfolio and
transactions.
Responsibilities:
. Closely worked with development team to make sure whether the software
application fits within the architecture and has the required behaviors.
. Performed Credit Derivatives and Fixed Income Derivatives Gap Analysis to
identify the holes in the requirements.
. Accountable for managing Credit Derivatives and Fixed Income Derivatives
Design Specifications within ReqPro, Requirement traceability from Scope,
track dependencies and changes which helped in controlling numerous
artifacts produced by the teams who are working on the same project by
keeping track of simultaneous update, change notification, multiple
versions (using Version Control).
. Review the current BRD (Business Requirements Document) and SRD (System
Requirements Document) to create HLD (High-Level Design Documents)
and LLD (Low-Level Design Documents) to describe all detail component
changes for specific programs.
. Provided Credit Derivatives and Fixed Income Derivatives key initiatives
in working with users in defining Business & System Requirements.
Followed Agile Methodologies in the complete context.
. Translated the business needs into system requirements, communicating
with the business on a non-technical level, and with the Credit
Derivatives and Fixed Income Derivatives System Analyst on a more
technical level.
. Responsible for syncing requirements from ReqPro to Quality Center using
sync tool.
. Articulated UML through Use cases, use case document by specifying
actors, normal flow, sub flow, alternative flows.
. Collected and documented policies, calculation methods, business
processes as well as business rules.
. Responsible for identifying and documenting business rules, created
detailed Use Cases and conducted Credit Derivatives and Fixed Income
Derivatives User Acceptance testing.
. Worked closely with test team for user testing of systems, developing and
maintaining quality procedures, and ensuring that appropriate
documentation is in place.
. Developed the test scenarios and test plans based on business
requirements, technical specifications and/or product knowledge in
Quality Center.
. Assisted in development of training materials for new technology and
process improvements.
Environment: IBM Rational Requisite Pro, Rose, Clear Quest, clear case, MS
Visio, MS Project, Oracle, Quality Center, Windows NT.
Emory University, Atlanta, GA
April 2006- November 2007
Business Analyst
Responsibilities:
. Reviewed BCBSMA's existing documents to understand the gaps in their
As-IS process and design a strategy for process re-engineering.
. Worked with the Project Manager on various Project Management
activities like keeping track of Project Status, Action Items,
Deadlines, Environment Request, and Compliance Issues.
. Was responsible for creating and maintaining Product and Sprint
Backlogs.
. Documented the User Stories, FSD's and Use Cases for different
functionalities.
. Coordinated with the IT team and Product Owners for Reviews of
documents and Sign Off's.
. Was responsible for coordinating Benefitfocus (external teams) to
track system issues based on EDI-834 HIPAA and business validation and
resolve them.
. Followed the Agile (Scrum) methodology for the entire SDLC.
Environment: MS Word, MS Excel, MS Power Point, MS Visio 2003, Agile,
SharePoint,
EDUCATION
Master of Business Administration (MBA) Hult International Business School,
Boston, MA
Bachelor of Business Management, Bangalore University Bangalore, India
Contact this candidate