SUMMARY

• Passionate IT professional with track record of delivering high quality software products by building strong relationships with customers.
• More than 10 years of professional experience in Business Analysis, System Analysis, Data Analysis, Project Management in Health care and Financial Services domains.
• Extensive experience in building solutions for Data Integrations, DataWarehouse, Analytics, Business Intelligence, web applications, SOA web services.
• Expert in eliciting, analyzing and documenting - Business Requirements, Functional Requirements, Non Functional Requirements, Transition Requirements, Use Cases and Use Case Narratives.
• Proficient in creating Activity, Use Case, Swim lane, Entity Relation, Conceptual and Logical Data Flow diagrams using MS Visio and MS Word.
• Expert in doing deep dive data analysis to build highly visible data-driven solutions.
• Proficient in writing highly complex SQL queries using advance analytical OLAP functions.
• Experience in facilitating JAD sessions, brainstorm sessions and workgroup meetings.
• Excellent experience working with Senior Executives and recommend actionable process improvements
• Managed projects from inception to completion. Phases included: Analysis, Design and Development, System Testing, UAT Testing, Training and Deployment.
• Delivered numerous multi-million dollar projects on scheduled time.
• Proven record of leading multidisciplinary teams, located on site and around the globe.
• Certified Business Analyst Professional (CBAP) conducted by International Institute of Business Analysis (IIBA).
• Worked on Waterfall and Agile/Scrum Software development methodologies.
• Continuously improving my business and technical skills by enrolling in courses.

TECHNICAL SKILLS

Modeling and requirement management tool: MS Visio, Rational Rose, Rational RequisitePro requirement management tool

Software Development Methodologies: Agile/Scrum, Waterfall and Extreme Programming (XP)

Business Intelligence and ETL tools: Cognos, Informatica

QA Tools: Quality Centre

Programming Languages: C and C++, SQL

Database Management Systems: Oracle, DB2, TOAD and MS Access

Web Technologies: SOA Web services, HTML, XML, Content Management system

Application Tools: MS Office, MS Visio, MS Project, iRise (web screen prototype tool

PROFESSIONAL EXPERIENCE

Confidential

Lead IT Analyst/Project Manager

Responsibilities:

• I am responsible for building requirements and design for several data exchange and integration interfaces. Many interfaces are significantly critical and have enterprise wide visibility such as integrating more than 500,000 members of other Blue Cross Plans into the existing BCBSMA Datawarehouse for Quality Improvement, Provider Contracting. Assigning Provider to PPO members for overall care coordination and incentive payments.
• Conducted several full day long JAD sessions to elicit requirements with Business partners and IT SMEs
• Presented approaches and recommendations to IT management and Business areas for data integration efforts
• Working with several BCBSMA business and technical teams to elicit requirements and build interfaces for PPO Payment Innovation program.
• Authored more than 10 functional requirements for PPO Payment Innovation program, which includes Host data integration, host PPO member attribution and so on.
• Working as Project Manager for scoping, planning, executing, and monitoring multiple projects within the PPO Payment Innovation program.
• Created and provided estimation to the Project Management Office (PMO) to approve the project funding.
• Wrote complex SQL queries to do research on host eligibility and Claims data. This was to ensure that incoming data values will be created to meet BCBSMA Data Standards for example, creating the unique host member keys across all 37 Blue Cross Plans.
• Developed and documented technical and functional requirements that translate Value Base Program needs such as Attributing Host members with BCBSMA contracted providers, extracting and submitting Case Management, Disease Management and Utilization management data to other blue plans.
• Created end to end Data Flow diagrams for several data exchange interfaces
• Working with external vendors, internal QA and SME to improve the data submission success rate for historical RTMS member file from 75% to close to 99%

Confidential

Lead Analyst/Project Manager

Responsibilities:

• Working with the CMS to gather on-going CROWNWeb requirements
• Working with Fresenius Subject Matter Experts (SME) to elicit, analyze, document functional requirements to meet CROWNWeb needs.
• SMEs include- VP Corporate Research, Corporate VP of Quality Management, Directors of Clinical and Billing System, Clinical Managers and Operational users.
• Creating the Data Mapping requirements for Extract, Load and Transform (ETL) programs to load Patient and Clinical information from the several Billing and Clinical Systems to newly created Data warehouse of the CROWNWeb project.
• Working with development team to create and submit EDI transactions via batch to CMS
• Creating complex SQL queries (including OLAP function) to do Data Analysis, Data Quality and to create analytical reports for Clinic Managers.
• Represented Fresenius on the bi-weekly CMS calls.
• Presented actionable recommendations to senior management to improve operational processes.
• Interviewed application users to elicit requirements to create new clinical web application that allows clinicians to enter the patient’s Vascular Access.
• Reengineered existing error monitoring process of highly visible Order interface. The new process helped users to view errors using GUI based application. Prior to this project, users were receiving emails whenever an error was raised.
• Created new interface to extract Prescribed Treatment Medications from clinical system to data warehouse. These treatment medication data was included in several outbound data feeds; analysis and reporting

Confidential

Sr Business Analyst

Responsibilities:

• Created functional requirements, use cases and screen wireframes for database driven web application, which provides users to visualize and sort data.
• Created tool to elicit AS-IS Application attributes and Non Functional requirements of more than 700 applications that are in-scope for the data center migration. This tool is being used by the 5 business areas and more than 200 business and technical subject matter experts to provide the information of the key attributes Responsible for analysis of applications to determine logic interdependencies across applications to ensure logical groupings will maintain during migration of applications to new data center.
• Created new Process Flows, analyzed and suggested measured to improve existed process flows.

Confidential

Lead Business System Analyst

Responsibilities:

• Lead Analyst and core member of a very complex Financial Brokerage and Bank integration projects, which were significant in sizes and complexities.
• Understood the Pre Trade Operations, Compliance Activates and Post Trade Operations to create functional specifications to migrate applications from legacy systems to new systems.
• Worked extensively on Mutual Funds, Order Management, Security Master, Products, Account, Rep (Broker), and Branches data to create data structures.
• Created Functional Requirements document and Use Cases that define functions of the applications.
• Worked closely with the Business areas and technical teams in defining and documenting Transition requirements.
• Responsible for data analysis, data profiling, and in creation of conceptual and logical data models for multi-dimensional designs.
• Created Source to System Analysis (SSA) documents to analyze of Asset, Revenue/Commissions, and expenses by Account, Branch, Financial Advisor, Security and Product.
• Created complex SQL queries to calculate performance metrics such as Year to Date (YTD), Last Year(LY) and Trailing months (3, 6, 12, and 18) metrics.
• Performed Impact analysis and getting required data/files from Thomson Transaction Systems (TTS)/ Beta System to load into Brokerage Data warehouse.
• Managed and mentored System Analysts and Quality Analysts.
• Worked with business users on regular basis to do User Acceptance Testing (UAT).

Confidential

Senior Business Analyst

Responsibilities:

• Worked with the relevant business partners to Discover, Describe, and Document detailed Business Functional Requirements (BFR) and Informational Requirements for new projects, modifications to improve existing systems.
• Created process models and improved existing processes based on the discussion with the Senior Executives.
• Involved in business scoping activities and ensuring that solutions support business processes.
• Met with project business stakeholders to determine the scope of the several projects.
• Studied interdependencies among various applications. Model these interdependencies in the form of Swim Lane Diagrams in MS Visio so that applications can be combined and migrated accordingly.
• Managed team of 1 to 3 Business System Analysts to meet project goals.
• Conducted JAD sessions to elicit requirements, allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Represented requirements using alternative views such as analysis models (diagrams), prototypes and scenarios.
• Created UML diagrams for Use Case, Activity, Sequence and Logical Data Flow using MS Visio and MS Word.
• Led multidisciplinary team from 4 to 14 developers, designers and testers.
• Assisted Senior Project Managers in Project Management tasks that include scheduling projects.
• Provided technical and functional support during UAT and trained business users and testers.
• Investigated requirements and carried out analysis of business processes and use cases to define workflows.
• Created Context diagrams, Activity diagrams, Entity relations, Use Case, and work flow diagrams.
• Served in a liaison role between business, developers and webmasters to ensure that applications meet customer needs, integrate well with other applications and support the delivery of the expected value.
• Created the Volume test strategy to describe approach and methodologies used to execute the volume test of one of the key application - Enterprise Front End system. The results were further used by infrastructure architect teams to enhance network infrastructure. The volume testing methodology and document was later used by many projects as a benchmark.
• Worked with UI teams to create the prototypes of the web screens using the iRise tool and MS Visio.
• Provided weekly status to senior Management.