Business Analyst

SUMMARY OF SKILLS

• Over Nine (9+) years of IT experience in business analysis, design, implementation and software testing.
• Experience with analyzing business needs, gathering requirements, planning, organizing, documenting, and testing software applications.
• Hands on implementing web, portal, web-services and enterprise applications using object oriented analysis and design (OOAD) methodology.
• Methodologies: experienced with rational unified process (RUP), agile (Scrum) software development, waterfall methodology, six sigma standards and UML.
• Experience in participating JAD sessions for project definition, analyzing requirements,
• Documentation includes: Business process documentation, business process modeling, HLDD's (SRS/SSR/BRD) and LLDD's (FRD/RTM).
• Experience in creating prototypes, wireframes and UIDD's. Developed use case diagrams, sequence diagrams, state diagrams and activity diagrams.
• Experience in business process definition, risk analysis, use case analysis and process flow diagrams.
• Strong analytical skills, evaluation and high degree of initiative. Coordinate all aspects of project - planning, scheduling tasks, tracking, and monitoring risk analysis.
• Worked extensively with dimensional modeling, data migration, data transformation, data loading, data modeling, metadata model, catalog creation, cube modeling, SDK development and performance tuning.
• Experience in understanding database structures and write SQL/PLSQL.
• Extensive experience in data analysis, ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Adept at writing data mapping documents, data transformation rules, maintaining data dictionary, data migration documents and interface requirements documents.
• Experience in gathering reporting requirements from the business users for business intelligence, data warehouse application.
• Experience in writing test plans, test cases, generate test scripts and maintain reports for defect tracking.
• Experience in test automation, identifying tests to be automated, designing test automation framework, building automated scripts, modifying existing scripts, executing and result analysis.
• Experience in integration testing, system testing, user acceptance testing (UAT), functional testing/black box testing, grey box testing, regression testing, GUI testing, performance testing.

BUSINESS SKILLS

• Experience in Healthcare and Financial Domain.
• Facilitator for JAD sessions and business/technology interactions. Ability To influence Subject Matter Experts with strong Communication, analytical and Presentation skills
• Experience in Gap Analysis, Risk Analysis and Impact Analysis
• Experience in Mapping Data Elements for information exchange between two systems
• Ability to priorities changing requirements, meet client expectations and ensure that projects are delivered on time within budget
• Experience in documenting Technical User Manual.

TECHNICAL SKILL SET

OOAD and DESIGN: RSA7 (Rational Software Architect), Rational Rose, UML with Class, Sequence and Use case diagrams, Visio and Enterprise Architect Operating Systems: Windows, UNIX, Linux, Z/OS and AIX Languages: COBOL, SQL, PL/SQL, VB, C++, C#, Java, JavaScript, HTML, XML Packages: Rational Rose, Requisite Pro, Clear Quest, I log J-Rules Databases: MS Access, Oracle 8i/9i, DB2, MS SQL Server Office tools: MS Office 2003/2007 (Word, Excel, Power Point, Outlook), MS Visio, Lotus Notes, Microsoft Share Point, and MS Project. Testing Tools: QTP 8.0, Rational Functional Tester, Rational Requisite Pro, Quality Center, LoadRunner, WinRunner, Clear Quest and Bugzilla Reporting Tools: Crystal Reports, Cognos Version Control: PVCS, SVN, CVS, Clear Case

EDUCATIONAL COMPETENCIES:

• MBA in Marketing
• PGDCA.
• Bachelor Of Commerce.

PROFESSIONAL EXPERIENCE

Project #1: Health Rules Payor (Health Care)

Confidential, MA, USA, Feb’11 – Till date

Sr. Business Analyst- Conversions

Health Rules Payor is a next-generation claims and benefits administration solution that enables payor organizations to quickly offer the innovative products the market demands, while simultaneously reducing administrative costs and increasing operational efficiencies. HealthRules Payor enables organizations to confidently take on any type of new business while simultaneously automating and streamlining all of their existing lines of business.

Roles and Responsibilities

• Responsible for interacting with customer (Independent Health) to scope and deliver a wide range of technical services from a functional and design perspective.
• Support developments by clearly articulating the customer’s business needs while continually verifying that the implementation approach and resulting technical developments meet the needs.
• Engaged in a series of working sessions with customers to gather requirements for systems integration. Work with customer to facilitate large scale and complex data conversions.
• Created overview document for data conversion, data mapping documents, detailed instructions, specification documents, pre-requisites, sample files, loader formats and business test cases.
• Obtain understanding of customer's business model and intended use of HealthRules.
• Provision appropriate environments for staging, analysis, executing and testing conversions
• For every conversion entity (accounts, accumulator adjustment, authorizations, claims (converted), customer service, fee schedules, membership (& subscription), premium billing and provider) able to define and document business use cases with customer.
• Advising customers on conversion data sourcing, mapping, transformation, and load technical developments
• Responsible for writing user stories to provide a definition of each requirement so that the developers can produce a reasonable estimate of the effort to implement it.
• Responsible creating use cases, usage scenarios and traceability matrix.
• Using an iterative agile methodology was able to work side-by-side with the customer and the developers to create the technical developments throughout a series of rapid iteration deliverables.
• Engaged with the customer to demonstrate and test the iterative work product while making sure along the way that the developments meet their needs. Involved in conducting manual testing at various phases of conversion process.
• Able to advise customers on accessing the correct web services, database schemas, conversion loaders and other technical components that are part of the HealthRules product.

Environment: DB2, Data stage, CDMA, ERWIN, JPA, EJB, JCL, COBOL, OLTP, OLAP, XML, Web Services, Informatica, Cristal Reports, SQL, Ms Visio, Share Point 2010, QTP, Quality Center, HIPAA, Health Rules, Agile methodology.

Project #2: Data Analytics Solutions (Health Care)

Confidential, MO, USA, Nov ’09 – Jan’11

Business Data Analyst

The scope of the project is to deliver a data warehousing solution to a healthcare product company. This company provides solutions in healthcare domain and serves hundreds of customers. The Project involves building a data warehousing system for a specific subject area to address some of the key pain points in existing reporting system. The new proposed system will be packaged and integrated with the existing product.

Roles and Responsibilities

• Performed requirement gathering & analysis by actively soliciting, analyzing customer requirements and prepared the requirements specification document for the application.
• Involved in gathering reporting requirements from the business users. Involved in building data warehouse application,
• Developed information cycle diagrams, data flow diagrams, in MsViso.
• Writing data mapping documents, data transformation rules and maintaining data dictionary, data migration and interface requirements documents. Able to update Microsoft share point portal with the updated project documentation.
• Created logical data modeling using tools like CA ERwin data modeler
• Able to analyze and Map source to target mappings using client Tool CDMA (Code and Data Mapping Application) to further develop enterprise data warehouse for Blue Cross Blue Shield.
• Applying Master Data Management (MDM) concepts for data alignment, maximizing analytics and business intelligence promoting corporate objectives and initiatives
• Performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Experience in gathering reporting requirements from the business users for business intelligence.
• Updated requirement documents as per business user feedback and changes, involved in generating test plans and test specifications as per business requirements
• Involved in conducting manual and automated testing at various phases of the project development.
• Prepared test data for positive and negative test scenarios as per application specifications and application requirements and wrote test plans.
• Manually performed integration and build verification testing.
• Knowledge in relational database concepts like tables, primary and foreign keys, views and referential integrity. Proficient in the data manipulation using SQL for the retrieval of data from the relational database.
• Responsible for defect tracking and reporting. Participated in the bug review meetings.

Environment: DB2, CDMA, ERWIN, Data stage, Informatica, Cristal Reports, SQL,Ms Visio, Share Point 2010, Quality Center, HIPAA, Medicare, Medicaid, Facets.

PROJECT #3: Patient Keeper (Health Care)

Confidential, USA, Mar’07 – Oct’09

Sr.Business Analyst

Patient Keeper is a data management system which keeps track of patient information, including history and physical, notes, labs, tests, to-do, problem lists. Access to critical up to date patient information, automate administrative work, and provide tools to collaborate with other physicians. Using Patient Keeper, Mobility and portal applications clinicians save time, to get the information they need, and spend more time with their patients.

Roles and Responsibilities:

• Performed requirement gathering & analysis by actively soliciting, analyzing customer requirements and prepared the requirements specification document for the application using Microsoft word.
• Involved in creating business process documentation for mobility and portal applications.
• Created activity diagrams and sequence diagrams to analyze the requirements and recommend solutions. Involved in creating UML, use case diagrams activity diagrams and state diagram using enterprise architect.
• For project management purpose worked on Microsoft project, used Microsoft share point for maintaining the updated documentation.
• Facilitated Joint Application Development (JAD) sessions with all IT groups for communicating & managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy and to collaborate resource allocation and project completion.
• Created prototypes for internet and intranet application, worked with ui team in designing of WebPages and micro site for portal application.
• Updated requirement document as per business user feedback and changes in the functionality of the application.
• Involved in generating test plans and test specifications as per business requirements.
• Involved in conducting manual and automated testing at various phases of the project development.
• Prepared test data for positive and negative test scenarios as per application specifications and application requirements and wrote test plans.
• Performed integration testing, build verification testing and system testing.
• Involved in white box testing of the java code with developers in the unit testing phase
• Responsible for defect tracking and reporting. Participated in the bug review meetings,
• Organized meetings to discuss outstanding issues with QA team and developers.
• Involved in user acceptance testing.

Environment: RAD, IBM Web sphere, Mainframe, UNIX, CICS,LDAP, JPA, EJB, JCL, COBOL, OLTP, OLAP, XML, PMBOK, Meditech, Patient Keeper, Data warehouse, Lotus Notes, Tivoli Access Manager, Microsoft Share Point, Rational Unified Process (RUP) and Quality Center.

PROJECT #4 : PBM – Benecard (Health Care)

Confidential, PA, USA, July’04 – Feb’07

Sr.Business Data Analyst

Prescription Benefit Facilitator (PBF) is a web based application and provides a fully integrated solution that facilitates the end-to-end business process required for the Pharmacy Benefit Management service provider. The system uses the rule engine to govern the claim adjudication process. The PBM Services staff is the primary users of the system. It provides user interface to their internal and external Users to maintain updated client/customer and provider information. PBF can interface and integrate with the external sources for the information related to the Pharmacy, Prescriber, Client and Drug files.

Roles and Responsibilities:

• Responsible for gaining a good understanding of user needs and accurately representing them in a well-documented software functional specifications document.
• Gathered business requirements, interacted with the business users, designers and developers, project manager and QA team to get a better understanding of the business processes.
• Involved in creating project management documentation, fallowed PMBOK standards.
• Interacted with the “End-Users” by interviewing them, by preparing appropriate questionnaire to better understand end-user needs and the business process.
• Followed a structured approach to organize requirements into logical groupings such as requirements for customer, client, group, member, eligibility, prescriber, pharmacy, COB, CRM, AR /AP and Reporting that critical requirements are not missed.
• Involved in creating business process documentation. Identified use cases from the requirements.
• Created UML diagrams including use case diagrams, activity diagrams, sequence diagrams, and collaboration diagrams using MS-Visio.
• For project management purpose worked on Microsoft project, able to update Microsoft share point portal with the updated project documentation.
• Created Prototypes for Internet and Intranet application, worked with UI team in designing of WebPages and Micro site for portal application.
• Analyzed and optimized the process, prepared business requirement document and managed requirements using Rational Requisite Pro.
• Worked with project teams in preparing Software Requirement Specifications (SRS), Software Design Documents (SDD), and User Interface Design.
• Facilitated JAD sessions with business and technical units to fine tune, prioritize and detail requirements and use cases.
• Identifying and understanding the business critical areas from the user perspective.
• Managed change of the requirements and associated requirements to other requirements for traceability.
• Involved in risk-management process whereby identified critical areas of business risk and modified the business process to reduce the same.
• Involved in drawing data flow diagrams and process flow diagrams using Enterprise Architect for the Claim Adjudication module.
• Identified business rules, built a rule based application that automates fine-grained, variable decisions used for claim adjudication, in Ilog Jrules.
• Involved in data mapping of EDI transactions, creating work flow and activity and use case diagrams. Created validation documentations for the claim process.
• Writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary, Data Migration and Interface Requirements Documents. Able to update Microsoft Share Point portal with the updated project Documentation.

Environment: MyEclipse, Java,IBM Websphere, DB2 on Z/OS, Struts, JAXB, XML, XPATH, JPA, EJB3.0, JMS, JAAS, RSA (Rational Software Architect), Cognos, UNIX ,UML, JSF, Spring, Hibernate, SSO, LDAP, Informatica, Web 2.0, AJAX, GWT, ANT, Clear Case, OLTP, OLAP, Web Portal, Apache Directory Studio, Tivoli Directory Server, JProfiler, GIS, Data Migration, Data Warehouse, PMBOK, Microsoft Share Point, Dream Viewer, HIPAA, iLog JRules, Rational Unified Process (RUP), Rational Requisite pro, Enterprise Architect, Rational Functional Tester and Bugzilla.

Project #5: Mortgage (Financial).

Confidential, July’02 – June’04

Business Analyst

The objective of bank mortgages (loan against security of collateral for housing purpose) is to cater to the software requirements of the departments involved in sanction and disbursal (pre and post) of loans against the collateral for housing purpose, in order to provide efficient customer service.

Roles and Responsibilities:

• Actively engaged client and third party integration partners in requirements gathering and validation. Conducted and lead requirements elicitation meetings with client end users to document system requirements and used Requisite Pro for management of these requirements.
• Developed business use cases using UML for new product functionality after conducting requirements elaboration sessions with client teams.
• Used tools such as MS Visio, Rational Rose to define business use cases, activity diagrams, state and sequence diagrams.
• Maintain the data architecture activities. Responsible for creating and maintaining multi-dimensional data models.
• Experience with Software development life cycle (SDLC) methodology, Framing out Business Transaction rules and related Documentation, creating Test Plans based on Functionality and Business rules, creating Test Cases, Test scripts out of Manual Test Scripts/Test Cases.
• Responsible for working with the manager and other users and creating Work flow diagrams as per the data analysis.
• Involved in generating Test Plans and Test Specifications as per Business requirements
• Involved in conducting Manual and Automated testing at various phases of the project development.
• Prepared test data for positive and negative test scenarios as per application specifications and application requirements and wrote test plans.
• Performed Integration testing, Build Verification testing, System testing manually.
• Responsible for defect tracking and reporting.
• Participated in the bug review meetings, updated requirement document as per business user feedback and changes in the functionality of the application.

Environment: Tomcat5.0, Apache HTTP Server, IIS6.0, C#.NET, Asp.Net, MySQL, Java, Struts, SOAP(Webservices), C++,MS-SOAP, Acrobat SDK, PKI, Thawte, XML, XPATH, Ms Visio, Load runner ,Win runner, QTP.