Summary:

• Senior Analyst with 7 years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Industry experience as a Business/Data Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Modeling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• In-depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
• Knowledge in the ETL Extract, Transform and Load of data into a data ware house/date mart and Business Intelligence BI tools like Business Objects Modules Reporter, Supervisor, Designer, and Web Intelligence .
• Experience in Designing, Creating and maintaining the Universes, Business object reports, WEBI reports and Domains Security, Universe, Document in Business Objects.
• Results-oriented Joint Application Development JAD Facilitator and meetings coordinator with excellent interpersonal skills.
• Expertise in the EPIC Medical software application EMR .
• Knowledgeable of HL7 Messaging protocols.
• Extensive experience in all phases of RUP and SDLC processes
• Managed content using Docushare 5 and DocushareCPX and integrated it with other products like Liberty, Xerox Advanced Multifunction Devices
• Assisted in SOX and Six Sigma Procedures
• Extensive experience with the SAS programming and in data step and with various SAS Procedures in Base SAS and SAS/Stat, including thorough knowledge of SAS Macro.
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.

TECHNICAL SKILLS:

• Programming Languages : C,C ,C ,VC ,VB,VB.NET,C .NET, ASP.NET, Java, SQL, PLSQ
• Development Methodologies : RUP, AGILE, Waterfall, ESDM, STV
• Databases : MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase
• Application Servers : IBM Websphere, ATG Dynamo, BEA WebLogic.
• Internet : HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.
• Automation Tools : MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum
• Bug Tracking Tools : Mercury TestDirector, Rational ClearQuest
• Utility Tools : MS Office Suite, MS Project, TOAD, Adobe Photoshop
• Reporting Tools : Crystal Reports, SQL Server Reports SSRS
• Data warehousing Tools : Informatica, Business Objects, Cognos, Erwin
• Testing Tools : Quick TestPro QTP , TestDirector, WinRunner, LoadRunner,
• Niku Project WorkBench

Experience:

Confidential

Sr. Business Analyst

Responsible for systems and applications start-up of FCHP a hospital-based community health plan payer . Responsible for the Claims Adjudication System Managed Care application training for all departments administration of control files, formulary, provider demographic, provider payment, enrollee maintenance, benefit configuration Claims Systems Processing, fee schedules, capitation schedules, data warehouse, on-line pharmacy over 200 pharmacies claim and benefit troubleshooting, ID cards, and system generated Plan correspondence design and maintenance.

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Defined Functional Test Cases, documented , Executed test script in Facets system.
• Analyzed trading partner specifications and created EDI mapping guidelines.
• Healthcare system implementation including enterprise Electronic Medical Records EMR software.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Troubleshooted file transmission problems and assisted customers in a call center environment with EDI and Medicaid Insurance claim related inquiries explained and enforced guidelines in the X12 Implementation guides 837P, 837I, 837D, 270/271 .
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Created surrogate key tables to map the required dimensions.
• Data transfers from text files and Access databases using BCP and DTS Data mapping and transformations while loading data using VBScript
• Developed estimates, project plans Microsoft project , training material, BI reports using Microstrategy

• Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.
• Assisted in monitoring ancillary data transactions and addressed problems with HL7 messages.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Creation of UML Diagrams including Context, Business Rules Flow, and Class Diagrams
• Created Business process workflow diagrams using IBM business process modeler

• Implemented RUP recommended visual models to draft business requirements by using Use Cases.

Environment:

Microsoft Office 2003 Professional Outlook, Word, Excel, Visio, Access, etc. , Microsoft SharePoint 2003,UML, RUP, UAT, db2, Peoplesoft GL,Mercury Test Director, SQL, .NET, Clear Case

Confidential

Business Analyst/ QA Analyst

Confidential is a leading provider of wide range of employee benefits that includes health, dental, group, life, disability, consumer directed and long-term health care benefits. The project involved streamlining and standardizing of the claims process which was achieved by incorporating the business rules to increase automation, enhanced interfaces for seamless integration with back-office systems and claims tracking system.

Responsibilities:

• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Managed the team of consultants responsible for developing on-demand Medicaid Management System reports.
• Analyzed, designed, and coded several online subsystems for the Medicaid System.
• Conduct complex documentation and user needs analysis. Interface with team and staff to develop HL7 integration.
• Developed HL7 messaging for bi-directional case and disease report exchange, in text and XML formats, in accordance with HL7 specifications
• Conducted Functional Walkthroughs, User Acceptance Testing UAT , and supervised the development of User Manuals for customers.
• Extensively involved in data modeling
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Perform Gap Analysis of the processes to identify and validate requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Extensively used calculations, variables and sorted inputs, drill down, slice and dice, alerts for creating business object reports.
• Generated complex reports using business object XI and web intelligence
• Scheduled business object reports using Broadcast agent
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Involved in jobs and analyzing scope of application, defining relationship within between groups of data, Star Schema etc
• Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed executed several Optimized queries in SQL on this data.

Environment:

RUP, UAT, GAD Gap Analysis Document , Microsoft Office 2003 Professional Outlook, Word, Excel, Visio, Access , Microsoft SharePoint 2003.

Confidential

Business Analyst/QA Tester

Confidential has supported the Department of Health, NY for Health and Dental Insurance Claims and Eligibility efforts. The core data is in MMIS Legacy system and can handle the processing of different Claims within POS in MVS Site D and AIX Box. The MMIS can handle the HIPAA transactions such as 835, 837 P, D, I 276, 277, 278. The Inbound and Outbound is run through JCL in batch mode.

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting a document that contains the essential business elements and detailed definitions.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Accurate processing of Medicare claims using the Diamond system
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Troubleshot the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
• Prepared Demo on SharePoint for various Business to get new approvals like the Therapist and Nursing divisions.
• Designed workflows and allocated permissions within SharePoint.
• Wrote detailed specifications for various reports generated using Cognos
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Performed felid-by-field mapping of interface between parent EMR system and downstream system.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Responsible for designing and developing universes for development of reports using business object designer
• Used Query Analyzer, Execution Plan to optimize SQL Queries.

• Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses since Stored Procedures passes the whole block at one time.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Identifying and modeling Use case diagrams, Sequence diagrams, Activity diagrams, Collaboration diagrams using UML.
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.

Environment:

Java, J2EE technology, Windows 2000 Advanced Server, Liberty,UNIX / Oracle Platform, MS Visio, RUP, UAT, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot.

Confidential

Business/Systems Analyst

• Confidential serves full range of managed healthcare, life and disability insurance, and retirement savings products and services. This current system only provides complete information regarding benefits about various product lines and product offered by the company. National Health was looking for a new system to automate the appointment processes, a system for single sign-in process and a system that automatically calculate the policy rating. The new systems were designed to increase productivity, and reduce costs.
• Performed Loss/Claims team leader and lead analyst duties for much of tenure. Responsible for requirements analysis, specification design, development and testing of software for Client/Server - Mainframe communications for system that allowed processing of claims in field offices. Played a major role in the development and testing of the system processing the claims.

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collects requirements from department managers and users for enhancements. Acts as liason between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Used IBM WebSphere Business Modeler to fully visualize, comprehend, and document the business processes. To model and optimize the business-critical processes. Define and refine process models through the company's best practices.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Developed straightforward DBMS queries, knowledge of HL7 and xml interface messaging.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2005.
• Tested Performance Accuracy related queries under SQL Server
• Designed and implemented basic SQL queries for testing and report/data validation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development JAD sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design UI screen using Microsoft Visio.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, IBM Websphere Business Process Modeller, ACORD, XML,Business Objects, TestDirector, LoadRunner,

Confidential

Business Analyst

This project involved creating the medical claims processing system for Aetna. It consisted of different modules like provider enrollment, member enrollment, programs and coverage. This project also involved the maintenance of claims workstation that automatically handles the entire claims life cycle.

Responsibilities:

• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Worked on HL7 and xml interface messaging.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose UML .
• Prepared Functional Specification Documentation FSD and communicated these to the stakeholders.
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Used MS Visio for Process modelling and Business Process flow diagrams.
• Extensively involved in regression testing during various phases of the application.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Troubleshot the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Environment:

Rational Enterprise Suite Rose, RequisitePro, ClearCase, ClearQuest UAT, RUP, WinRunner, LoadRunner, MSOffice2000