Project Manager Quality Assurance
Resume:
Karan Sakhalkar
**** **** **** ******, ********* CA
95747
**************@*****.***
SUMMARY:
. Over 8 years of diversified experience in Business Analysis,
Implementation and Developing schematics of web based and client
server applications with knowledge of the Software Development Life
Cycle.
. Strong Subject Matter understanding of Health Care Businesses, Retail
Banking, and Telecom sector.
. Excellent organizational, planning, project and time management skills
with ability to work under critical circumstances and ability to
effectively communicate Business Requirements to Tech Team.
. Extensive Experience in gathering requirements using Traditional
(Functional Requirements Specification (FRS) and System Requirements
Specification (SRS) and Use Case Methodology with strong experience in
writing Functional Use Cases.
. Extensive Experience in modelling business requirements using UML (Use
Case Diagrams, Activity Diagrams, Interaction Diagrams).
. Strong domain expertise in handling - 1) Insurance - Medicare /
Medicaid - Acute Care and Long Term Care - Claims Processing,
Provider/Member Services, Provider Enrollment, Contracts, Reporting 2)
Finance - Investment Processing Business, Banking - special focus in
Loan Processing, Cash Management, Asset Management, Financial
Reporting 3) Energy sector (Natural Oil and Gas) - Accounting,
Operations and production.
. Understanding of business process flows, and ability To effectively
write "As Is" vs "To Be" requirements
. Proven ability to bridge business goals and technology to provide
productive solutions.
. Effective communication skills for mediating between Management Teams,
IT Group, Business Group and Clients with particular focus on
specifications, requirements and documentation.
. Exceptional analytical, problem solving, strategic planning and
decision-making skills.
. Strong team building, conflict management, time management and meeting
management skills.
Technical / Software Skills
Operating Systems: UNIX/Linux, Ubuntu, Windows 7, and Mainframes Z/OS.
Languages: C, C++, JAVA, .Net, SQL, PL/SQL, and
COBOL.
Databases: Oracle 9i/8i/7.x, DB2 v9.2, Sybase, SQL Server, Informix, and
MS Access.
Software Quality Assurance: Unit, System, Integration, Migration,
Security, Smoke, Ad-hoc, Functional,
Regression, UAT, Manual and Automation.
QA Test Automation: Knowledge of Quality Center/Test Director, Clear
Quest, QTP, BPT, TAO.
ERP TOOLS: SAP CRM 4.0, 5.0, SAP BW 3.1c, 3.5, 7.0, Oracle Financials v11
AP, AR, GL, AOL, FA Modules.
P M & BA / BSA Methodology and Tools: Waterfall, Agile Methodology, UML
JAD Sessions, Interviewing,
Questionnaires, SDLC, Quality Assurance,
Test case design and Management, Training
Material Development and Delivery,
Operations Analysis, Process Flow
diagramming, Data Flow Diagramming Audit,
Compliance and Controls Analysis, Data
Mining.
Industry Standards: HIPAA, SOX, CFR 21 Part 11, CFR 21 Part 820, ISO,
Six Sigma, CMMI, Rational Unified Process
(RUP) Waterfall Capability.
Other tools: Business Objects, Crystal Reports, Data stage
7.x/8.0, Informatica, Toad, EDI, Share
Point, Clarity v12.0.0, IBM Lotus notes,
BI designer, Kintana.
Education:
Bachelors in Business Administration/ Information Technology
University of Texas at Arlington
Professional Experience:
DHHS-MMIS STATE OF NEBRASKA, Lincoln, Nebraska April
2010 - June 2011
IT Lead Business Analyst
Project I - Medical Home Pilot - Nebraska Medicaid Patient Centered Medical
Home Pilot is a health care delivery model in which a patient establishes
an ongoing relationship with a physician in a physician-directed team, to
provide comprehensive, accessible, and continuous evidence-based primary
and preventive care, and to coordinate the patient's health care needs
across the health care system in order to improve quality, safety, access,
and health outcomes in a cost effective manner.
Project II - PACE (Program of All-Inclusive Care for the Elderly) is a
Medicare program for older adults and people over age 55 living with
disabilities. This program provides community-based care and services to
people who otherwise need nursing home level of care.
Responsibilities with the current client:
. Under general direction, gather, define and document highly complex
business requirements.
. Facilitate meeting discussions between business users, business
analysts and technical analysts.
. Document organizational policies and procedures in the context of
system requirements
. Work with technical staff and business users to problem-solve and
identify workable solutions.
. Created Feasibility Study reports based on (TELOS) that covered all
aspects of feasibility such as Technology and System feasibility,
Economic feasibility, Legal feasibility, Operational feasibility,
Legal feasibility and Schedule feasibility.
. Develop work flows that demonstrate current and proposed business
requirements
. Prioritize and track Project Schedule in MS Project for multiple
project assignments, deadline and milestones.
. Worked with Teamsite Workflow Tool to generate custom reports for jobs
and tasks based on all possible combinations of workflow parameters.
. Create and execute test cases, test scripts, data sets and user
procedures.
. Ensure testing results correspond to the business user's expectations.
. Work with team leads, technical staff and key users to identify, track
and manage project issues as they arise.
. Provide user support, including training, help and instructions.
. Coordinate NPI, HIPPA 5010, ICD 10 project implementations.
. Responsible for 837P transaction in 5010 project implementation.
. Coordinate with the other 5010 EDI transactions - 270-271, 278, 820,
837I, 837D, 835.
. Involve in ICD10 business project plan sessions, orientation and
estimates.
Mainframes Z/OS, DB2 v 9.2, IBM Lotus Notes, Clarity v12.0.0, Share Point
2010, Microsoft Project, Microsoft Office, Visio and Access..
Texas Medicaid & Healthcare Partnership/Accenture (TMHP), Austin, TX
Sep'08 - Apr 2010
Lead Business Analyst
Project I - Enhancements to the TexMedConnect application (Claims
Processing) on tmhp.com. The enhancements include new template sort,
extending Eligibility Verification for Acute Care users and Medicaid
Eligibility Service Authorisation Verification (LTC) search extension
dates, display of Remittance & Status Report and, creating EV and MESAV
batch functionality, new navigation options, tool tips, default values, and
new Long Term Care Global template options.
Project II - Nutritional supplement products are provided as a benefit of
Texas Medicaid through the Texas Health Steps (THSteps) Comprehensive Care
Program (CCP) for client's age 20 years and younger. Provision of these
products is subject to medical necessity requirements and, in some
instances, prior authorization. The USDA has mandated that, effective
October 1, 2009; reimbursement should be coordinated so that Medicaid is
the primary payer of nutritional supplement products administered through
WIC.
Project III - Texas Medicaid enrollment guidelines currently require
creation of a distinct Texas Provider Identifier (TPI) for each performing
provider practicing at each group provider location that has its own TPI.
Consequently, a single performing provider is required to maintain multiple
TPIs based on the number of group locations linked to that performing
provider.
Responsibilities:
. Worked under the direction of Project manager in a team composed of
other business analysts, programmers, functional analysts, subject
matter experts, training staff, and testers.
. Gather Business User Requirements from the State Stakeholders and Peer
Review for sign off.
. Conduct Technical meetings with internal Consumers, Client and
Business Partners.
. Finalise Functional Design and System Specification Documents.
. Estimated technical Work Effort, Risks and Operations for all
changes/enhancements.
. Assemble, analyze, and represent Customer Business Requirements.
. Perform feasibility analysis, scope of the project, and recommend
alternative solutions and project strategy and deliverable
prioritization.
. Design, distribute and facilitate the execution of test plans.
. Assist with controls to provide Client and Operations visibility into
System and Program.
. Adhere to applicable process standards to maintain CMMI Level 4
certification.
. Maintain effective relationships with system users, stakeholders, and
other outside entities (i.e. vendors) within own area of
responsibility.
Quality Center 9.2, .Net, Compass21, CMS (Claims management system),
Portals: TMC (TexMed Connect), OPL (Online Provider Lookup), PEP (Provider
Enrollment Process), EDI, Phoenix, Vision21, Tandems/S86000, Business
Objects, MARS (Medicaid Administrative reporting system), STAT (Statistical
Reporting applications), Outside View, BPS Scan, VRS (voice response
system), AIS reader, BI designer, Kintana.
Chesapeake Energy Corporation Oklahoma City, Ok.
Feb'08- Aug'08
Sr. Business Analyst
Chesapeake Energy Corporation is the largest independent and third-largest
overall producer of natural gas in the U.S. Headquartered in Oklahoma City.
The current project involved in configuration specifications and functional
designing of business activities in various modules like CEMI Accounting,
Gas Marketing, Gas Balancing, MidCon, Operations and Production for Enertia
Jan'08 and July '08 Versions.
Responsibilities:
. Gather Business Requirements from business users, obtain feedback as
appropriate for recommended improvements, document and communicate
results using Word, Excel and Visio.
. Streamline processes in Accounting - Invoice processes (a/c's
receivables & a/c's payable), fixed asset depreciation, well head
allocations, revenue distribution, and management inquiry, set up tax
deck, deposit entry.
. Created Cost Benefit Analysis (CBA) reports to appraise, or assess,
the case for a project, program or policy proposal.
. Collaborate with technology staff, business units to streamline
operations and expedite configuration process for moving forward on
time.
. Analyse and identify business requirements for production module -
delivery systems, oil statement uploads, allocation meter, frac
meters, seals on tanks.
. Work flow analysis for contract set ups, goals generation, adding
zones to contract, correcting gathering contracts in gas marketing
module.
. Prepare business requirements and interview business users in Gas
Balancing area for MassGen Process, validation of correct settlement,
add sales to shipper contract, split connect and auto generation
wells.
. Supervised User Acceptance Test and used SharePoint for all the
documentation of the project.
Environment: Enertia (Jul, 07), Enertia (Jan, 08, Jul, 08), SQL server
2003, 2005, PDI, CST, SharePoint, Quality Center 9.5, Quick Test
Professional 9.5 version, MS Visio
J.P Morgan Chase Educational Finance, Madison, Mississippi
Jul'07 - Feb'08
IT Lead Business Analyst
Pulse (Platform for Unified Loan Support in Education)
Pulse Application provides a single platform for Global Sales, Global
Processing and Global Customer Service for Private Education Loans. It
provides functionality necessary to generate and support operational
efficiencies and application effectiveness required to meet the private
credit volume growth.
Presentation Service Layer: Provides a facade appropriate to consumption by
the Win Forms desktop/ Web application. Operations are specific to loan
processing and provides no common (across processing /sales) UI elements
leverage operations from this service.
Business Process Service Layer: Coordinates business processes (business
rule validation, identity verification operations) while at its core the
validation service is a utility service- its primary purpose are to
evaluate business rules and decision Services.
Application/ Utility Service Layer: Operations for making identity
verification requests to Experian and Operations for handling electronic
signature operations including generation of the signature and the signed
document.
Data Access Service Layer: Entity "CRUD" service and Search Engine Service
Responsibilities:
. Involved in project planning and coordination using Microsoft project.
. Creating business process flows, use cases, information modelling,
data mapping and gathering business requirements.
. Conducting JAD Sessions as a Facilitator to gather requirements from
the group
. Creating definition for terms use in different areas of the bank.
. Create a project intake proposal and plan
. Create a change management plan for the project
. Interaction and coordination with end users and management to identify
business system needs.
. Impact Analysis, Evaluation of solutions for business problems.
. Work closely with vendors to figure out the best methodology for
different work streams of the project.
. 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.
. Developed test plans, test cases and test scripts based on the
functional specifications.
. Maintained Traceability matrix, prepared and maintained the
Requirements traceability matrix (RTM).
. Create BRD for all the different work streams in the project
. Worked with other Business Analysts, Project managers and Business
users through the life cycle of the project.
. Used Test Director for error reporting and communicating between
developers, product support and test team members.
. Conducted functional walkthroughs and get sign offs
. Has knowledge of Enterprise Analysis, Requirements planning &
Management, Requirement elicitation, Requirements communication,
Requirements Analysis & documentation and solution Assessment &
validation.
. Supervised the development of User Manuals for customers.
Environment: MS Project, Test Director, Oracle 9i, SQL Server, .NET, HTML,
MS Office Suite, Business Objects, Kofax Asscent Capture, Infragistics
Test Advantage.
State of Washington-Health Care Authority (HCA), Lacey, Washington
Oct'06 - Mar'07
Business / Systems Analyst
Responsibilities:
. Developed standardized template for secure access to applications and
data restricted to a customized level per user.
. Enable ongoing ability to conduct quality assurance at regular
intervals to improve data quality from 80% to consistently over 99%.
. Involved project to link electronic birth and death records to injury
and violence prevention data initiatives by developing algorithm and
methodology along with infrastructure for seamless integration of
epidemiologists' research.
. Liaison to public groups -- reporting / clientele interfacing on
internal and external status of projects.
. Gather input requirements; design, program, implement unique
methodology based on strong algorithm combined with more secure
"wrapper" than that used in the industry to ensure privacy of
healthcare data implementation for HIPAA compliance.
. Build team of developers for healthcare tracking data repository to
include secure encrypted data transmission of healthcare patient chart
/ medical billing information; become subject matter expert in
hospital billing records.
. Improved quality of linkages at state level implementation and
streamlined documentation and preparation of software to accompany
project.
. Full life cycle initiating, planning, executing, monitoring and
closure for internal data gathering, software development, design &
analysis initiatives.
. Establish workflow, paper filing system for setting standards and
consistency; administer data security, develop backup procedures.
Environment: Quality Center, Quick Test Professional, XML, OOAD, JAD, Data
Marts, Visual FoxPro.
Regions Financials/Union Planters Bank, Memphis, TN
Dec '05 - Sep'06
Business / Systems Analyst
Global Credit Risk Management - IB Technology & Operations
Loan Analysis & Disclosure System (LADS)
Responsibilities:
. Involved in all stages of the SDLC, right from Gathering Requirements
to Testing the Build, in this Data warehousing Environment.
. Involved in Finalizing the Project Charter to firm up the High level
requirements.
. Facilitate regular meetings with the stakeholders and Conducting
Interviews with Subject Matter Experts to further clarify the detailed
functional requirements.
. Preparation of the Functional and Technical specification Documents
and analyze various project artifacts and deliverables. Also created
various checklists as regards: Files Layout, Connectivity - EDI and
Data Quality so as to keep checkpoints for the project.
. Actively participate in the brainstorming sessions to help improve the
Data Flow in LYNX and its impact on effective Delivery of Data Feeds
out to Consuming Systems.
. Working with the Build team to ensure EDI compliances are adhered to
and the Credit Risk Exposure Data Files are transmitted successfully
to consumers via Secure FTP or NDM, due to the Sensitive nature of the
Credit Risk Data and the Connectivity is Robust and tested. These
Files are either Fixed width or delimited files
. Ensuring the Requirements gathered are verified and confirmed by the
Business and the Subject Matter Experts, by conducting Inspection
Sessions and Obtaining Approval's and Sign Off's from Designated
Stakeholders.
. Working closely with the Build Team, to discuss Requirements and
confirm their understanding of the Consumer's Requirements by
conducting Requirements Review Sessions.
. Tracking Progress of technical Build and its adherence to the Project
Schedule and initiating escalations, if required.
. Coordinating and Executing SIT and UAT test cycles, develop and
maintain quality procedures, and validating that appropriate
documentation is in place, by Formulating Test Plans, Test Cases for
an effective Testing of the Build.
. Holding weekly Meetings with Project Manager to update status and
escalations, if any.
Environment: Oracle 10g, Java, PLSQL, MS Visio, MS Projects and Windows
XP/2000, MS Office Suite, MS Access, Toad.
LEXINGTON INSURANCE (AIG), Boston, MA.
Jan'05 - Oct '05
Business Analyst/QA
Property & Casualty and Personal Line:
. Defined, scoped and produced business requirements and policy-writing
solutions to Property/Casualty/Personal and Commercial Lines.
. Test matrices, UAT, Regression and User Training.
. Assisted in formulating testing documents like Test Plans, Test
Scripts, Traceability matrix and Test summary report.
. Developed system specifications as needed to support reporting, policy
and claims systems.
. Interviewed legal authorities like attorneys to gather requirements
regarding legal procedures.
. Analyzed business needs/requirements, incorporating regulatory
changes, ratings, re-engineering processes.
. Provided up-to-the-minute market/sales/claims data for decision-
making.
. Communicated directly with Clients to understand their business needs
and to resolve business issues.
. Ensured quality of system changes through the development and
execution of system test plans, built, and executed test plans.
. Managed small to medium-sized projects.
Environment: Windows XP/2000, JAVA/J2EE, Oracle, UML, Rational Rose, DOORS,
MS Project, MS Visio, TOAD, MS Office, Test Director.
Deutsche Bank, Wall Street, NY
Jan'04 - Sep '05
Business Analyst
BASEL II - RWA (Risk Weighted Assets)
Developments of a new feed FCL (Financial Consolidated Layer) and validate
its functionality for the Implementation of the BASEL II Statutes for Risk
Weighted Assets (RWA) for Global Equities and Credit. The ultimate project
goal is to streamline the current RWA reporting process through the
creation of an automated CRES - Credit Risk Exposure System feed.
Responsibilities:
. Chair weekly status update meetings
. Reconcile trade details between both the Financial Consolidated Layer
(FCL) and CRES (e.g. Interest Rate Swaps, Credit Defaults Swaps,
Swaptions and Total Return Swaps)
. Investigation of Electronic Trades transmitted via FIX Protocol using
OATS - Order Audit Trail System.
. Work with London IT to resolve exceptions noted as a result of UAT
Test work.
. Data Analysis of trade breaks using MS Access and MS Excel, perform
reconciliations, escalate issues to relevant BAC's and track issue
resolution.
. MIS reporting on a bi weekly basis of project status
. Coordinate with the BAC ( business area controls) and London IT for
any escalations
. Assist individual Business Area Control (BAC's) with UAT test work as
necessary
. Participate in bi-weekly testing update meetings.
Environment: Oracle 10g, Java, PLSQL, MS Visio, MS Projects and Windows
XP/2000, MS Office Suite, MS Access
Commerce Bank, Kansas City, MO
Feb '02 - Dec
'03
Business Analyst
The Project involves designing Online Banking Application. It will allow
tracking, managing and optimizing interactions with customers or members.
It closely tracks the Pricing of the Bank's Fee Based Services & ensuring
there are no gaps in Billing Initiative for services offered & its
integration into Financial Reports. It provides centralized access to
perform frequently used "banking" functions such as deposits, withdrawals,
transfers, loan payments as well as placing stop payments, placing and
removing holds and restrictions on the account, and quick issue of a card
agreement on Checking, Savings, Time Deposit, and Retirement accounts.
Responsibilities:
. Worked with the business team (SME's in Insurance, Investment
Management, and Annuities) to collect the business reporting,
reporting standards, security and service level requirements and
documented them in Business Requirement Document (BRD) to get a better
understanding of client's business processes and gathered Business
Requirements in Compliance with Basel II Accord, as regards Capital
Allocation and performed Business Process Re-engineering
. Interacted with various Business Heads to finalize the Business
Requirements for the application. Conducted joint requirements
planning sessions as a facilitator to gather requirements.
. Created Functional Use cases, Use Case Diagram, Process Flow Diagram,
Work and Navigation flow diagram using Unified modeling language (UML)
and implementing Rational Unified Process.
. Created Activity Diagrams & Sequence diagrams describing carrying out
of actions in MS Visio.
. Conducted JRP and JAD sessions with End User Community and the IT
Group ensuring that the software addressed all business needs.
Conducted many informal Sessions to develop an architectural solution
that the application meets the business requirements, resolve open
issues, and change requests.
. Utilized existing internal processes and improved those same processes
for software problem identification, escalation, and resolution and
facilitated project team meetings. Continually reviewed and revised
project processes to ensure accurate and timely results.
. Involved in Identifying & Managing risks, Resource analysis, Cost
analysis, Post project analysis & coordination among cross-functional
teams & follow-up with clients for settlement of project based issues
and integration with the Technology Team
. Responsible for organizing the walk through to explain proposed
changes. Coordinated with the test team to check the weekly status and
report the same to the project manager and discussed project manager
and other team regarding State Flow Process.
. Identified, prioritized, tested and proved essential business
functions to assure compliance with agents, brokers and internal
auditing team.
Environment: Oracle 9i, Java, J2EE, ASP, HTML, PLSQL, MS Visio, and
Windows XP/2000, MS Office Suite, Test Director.
Contact this candidate