Professional Summary:

• Senior Analyst with nearly 9 years of experience in Business analysis/modeling, business requirements gathering, database design and development of Web Based, Client/Server applications, Testing, Implementation and Post-Production Support of applications using Informatica Ver 7/8, Business Objects 6.5/XI R2 , Cognos 7/8 and Oracle9i/10g.
• Experience as Business Analyst with expertise in Insurance, Healthcare processes, Business Process Engineering, Systems/ Solutions Engineering, Strategic Planning, and Systems Analysis.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Proficient in business process modeling, documentation, and testing using Rational Suite Rational Rose, RequisitePro, SoDA, ClearQuest, Robot as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
• Hands on Experience in Extracting and transforming Data by using DTS and SSIS to diff kinds of databases like oracle, MS Access, Excel, DB2 and Sybase.
• Experience in creating cubes for OLAP databases using SSAS
• Experienced in SQL Server Reporting Service SSRS , Executing Queries and Running Store Procedures.
• Gained experience in utilizing statistical tools like SAS, SPSS, MS office suite, MS projects, MS Visio and requirement management tools.
• 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.
• Experience in various programming languages SQL, XML and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Experience with Data Mappings including HIPAA ANSI X12, 4010 and 5010 ICD9 and ICD-10 implementation guidelines electronic formats including for institutional, professional, and commercial claims.
• Solid experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting
• 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.
• 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, SAS, SPSS,COBOL , Java, SQL, PLSQ
• Development Methodologies : RUP, AGILE, Waterfall, ESDM, STV
• Databases : MS-Access, MySQL, SQL Server, Oracle, OBIEE,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
• Bug Tracking Tools : Mercury TestDirector, Rational ClearQuest
• Utility Tools : MS Office Suite, MS Project, TOAD, Adobe Photoshop
• Office tools:MS Office 2007 Word, Excel, Power Point, Outlook , MS Visio, MS Project, and MS
• FrontPage
• 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

Professional Experience:

Confidential

Sr. BusinessAnalyst

Uniprise Technologies is a part of Presbyterian healthcare System, a Fortune 500 company and a leading player in the Health Insurance and services market. UHCI specializes in Network based care co-ordination health care services for small groups, government and specialized groups and commercial employers. The system streamlined patient registration, patient scheduling, and medical insurance checking, claims processing, and reporting. The purpose of this project involves population of the Enterprise Data Warehouse EDW which is used in critical reporting and analysis. Informatica was used for ETL process and Business Objects 6.5.1 XI R2 are used for Reporting duties.

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• 0Designed a claim processing system for the healthcare management client system. It allowed the user to inexpensively capture information regarding patient, summary of medical history, symptoms ICD-9, ICD-10 codes , and treatment CPT .
• Created use case scenarios and documented work flow and business process using Rational Rose
• Captured business requirements for reconciliation reports and designed metrics in Microstrategy
• COBOL is used as a front end application and DB2 as a back end.
• Install, configure SSRS and troubleshoot reporting services issues.
• Created different types reports like graphs, pie charts etc. based on user requirement by using SSRS
• Monitored the compliance mapping of transactions to the EDI transactions standards ANSI -X12
• Reviewed Stored Procedures for reports and wrote test queries against the source system SQL Server to match the results with the actual report against the Data mart Oracle .
• Development and design of Risk Datamart involving Informatica 8 and Business Objects 6.5/ Cognos 8
• Worked on Informatica Power Center 8.1.1/7.1.3 client tools - Mapping designer, Workflow manager, Workflow monitor, Repository manager.
• Developed estimates, project plans Microsoft project , training material, BI reports using Microstrategy
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• 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.
• Demonstrated expertise with Medicare and Medicaid, including Claims, Adjudication and Billing. Extensive experience with HIPAA regulations, and EDI standards X12 and HL7
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Extensive experience using SQL for report generation and support using SAS modules
• 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 .
• Debugging and Troubleshooting Informatica Mappings
• Hands on experience in writing UNIX scripts for various purposes FTP, Creating Parameter Files, Automation and running Informatica workflows .
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives
• Responsible to import the data from Crystal reports by using Business Objects Live office into Microsoft Excel and Word.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Developed estimates, project plans Microsoft project , training material, BI reports using Microstrategy
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• 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.
• Worked in mainframe environment and used SQL to query various reporting databases
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.

Environment:Microsoft Office 2007 Professional Outlook, Word, Excel, Visio, Access, etc. , Microsoft SharePoint 2007, Notes SAS, SSIS, SSRS, SSAS,SPSS,COBOL,TOAD, OBIEE,Crystal Reports XI/XI R2, UML, RUP, UAT, DB2, Mercury Test Director, SQL, .NET, Clear Case

Confidential

Business Analyst

The Confidential for the self-employed, individuals and families, as well as small businesses. Project involves integrating Market Prominence and the Claims processing System with the data warehouse to support the reporting requirements. This project also implemented ETL process using Informatica. This application provides business intelligence analysis to decision-makers using an interactive OLAP tool Business Objects with its Web Intelligence module.

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.
• Translated Business processes into Informatica Mappings for building Data marts.
• Importing various Requirements Gathering, Business Analysis, Sources, Targets, and Transformations using Informatica Power Center 7.1.1 - Server Manager and Designer.
• Develop, build and manage Reporting Services SSRS reports using both SSAS cube and relational database sources including distribution of reports using subscription services
• Advanced ad-hoc and standard report development, including data analysis through the use of Oracle Discover, Business Objects, TOAD, Excel, Access, SPSS, SQL, and Oracle Reports.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft SET and Teradata
• Used knowledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Designed High level design, for New process, integrating with legacy and Facets
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
• Conducted Functional Walkthroughs, User Acceptance Testing UAT , and supervised the development of User Manuals for customers.
• Create and maintain data model/architecture standards, including master data management MDM
• Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Working knowledge of inpatient and outpatient claims processing including ICD-9, ICD 10-CM, ICD-10 PCS, CPT, HCPCS, and set up system related components to ensure accurate claims adjudication by health systems
• Used SAS ODS to create output files in different formats including PDF and RTF
• Worked on creation of Cognos 7.1 packages and performance tuning of backend SQL generated for Cognos reports for faster report output.
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program. Used Microstrategy dashboards for data analysis and custom reports.
• Used Informatica Designer to import, create and edit the metadata.
• Incorporated HIPAA standards, EDI Electronic data interchange , transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD-9 ICD-10 coding and HL7.
• Created Technical Design documents for two applications RMV and GainLoss . Created Stored Procedures using Sql Server 2000 T-SQL to extract the data from one database and upload into another database and created script using perl to verify if the data is loaded in the database tables.
• Extensively involved in data modelling
• Extensively used transformations of Informatica for various types of Data Conversions
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Normalized the database up to 3NF to put them into the star schema of the data warehouse.
• Worked on UNIX shell scripts to create tar of the project files and load the code at the clients' instance.
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Developed the correlations of claims to the Billing and their respective Enrolments
• 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 creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• 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.

Environment: Crystal Reports XI/XI R2, SAS v9.0, SPSS,SSIS, SSRS, SSAS,DB2, RUP, UAT, OBIEE,COBOL , GAD Gap Analysis Document , Microsoft Office 2007 Professional Outlook, Word, Excel, Visio, Access , Microsoft SharePoint 2007.

Confidential

BusinessAnalyst

Cigna major service lines include workers compensation claims administration and healthcare management services, property and casualty claims management, class action services and risk management information services.

As a Business Analyst in Cigna I was involved in development of claim management data warehouse to assist claim professionals to analyze and administer the claims in an efficient manner. The operational data came from multiple sources and was then loaded into claim management data warehouse. Worked on the entire reporting process Interacted with the ETL team, developer s , management, and account holders to get the requirements, document them, design templates, and write specifications.

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Wrote SQL Queries for DataMigration Module.
• 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.
• Developed and provided formal training and presentations/lectures to all DWH users ensuring an understanding of the dimensional model, metadata, and effective usage.
• 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.
• Participated in designing and coding for web forms of the application with ASP.NET.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Designed and Developed ETL Extract, Transformation Load strategy to populate the Data Warehouse from the various source systems feeds using Informatica PowerMart, PL/SQL.
• Imported Sources and Targets, Created Mappings and developed Transformations using Informatica PowerMart designer
• Facilitated UAT User Acceptance Testing with Business Users
• Extracted data from disparate sources by SAS/ACCESS.
• Created SAS programs that are used for data validation, statistical report generation and program validation and automated the Edit Check programs using Macros
• Maintaining and updating the HRIS database information for all employees across various client sites in the US and participating in HR related projects such as performance reviews, benefits enrollment etc.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Worked on SQL Server 2005 concepts SSIS SQL Server Integration Services , SSAS Analysis Services and SSRS Reporting Services .
• Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Worked on UNIX shell scripts to create tar of the project files and load the code at the clients' instance.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Responsible for cost estimation and timelines for various Business Intelligence reports
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Organize requirements into high level Use Cases and low level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Review the Test Plan developed by the testing team for testing the application.
• Assist the QA personnel in the creation of Test Cases using Rational Test Manager.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.

Environment: Java, J2EE technology, SAS/BASE,SPSS,SSIS, SSRS, SSAS,DB2, MS Visio, MS Excel, RUP, UAT, COBOL, Oracle, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot.

Confidential

BusinessAnalyst

Nationwide is one of the largest insurance and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments. Nationwide currently has about 35,000 employees, and is ranked 98 in the most recent Fortune 100. The Data Warehouse was developed to integrate Nationwide in designing the end user web-based interface, which involved OLAP reporting system implemented in Business Objects to provide business intelligence capability to Asset Managers. This project also implemented ETL process using Informatica.

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Conducted user interviews and documented business and functional requirements.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Involved in creating business processes and modeling diagrams using Rational Unified Process RUP .
• Involved in project management using MS Project
• Involved in Service Oriented Architecture SOA of the claims processing system
• Used Crystal Reports to design a complex, on the fly, report that displayed complete charts based on the parameters.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS .
• Built reports and report models using SSRS to enable end user report builder usage.
• Extracted data from disparate sources by SAS/ACCESS.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Develop and maintain reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft SET and Teradata
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment
• Create technical design documentation for the data models, data flow control process, metadata management.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Created source table definitions in the DataStage Repository by studying the data sources.
• Generated Surrogate ID's for the dimensions in the fact table for indexed and faster access of data.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Incorporated Rational Unified Process RUP to create Requirement Document Specifications using Visible Analyst.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Involved in writing the detailed Test Plan using Mercury Quality Center, after analyzing business requirements and software/functional requirement artifacts.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Used UML notations for Object Oriented Design and Documentation.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Did Integration Testing, GUI testing, Smoke and Sanity Testing, and Acceptance testing in the new builds for Basic Functionality Checking.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.
• Used Crystal Reports to design a complex, on the fly, report that displayed complete charts based on the parameters.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, COBOL, DB2, SAS/ACCESS,SSIS, SSRS, SSAS,SPSS,Windows NT/XP, UNIX, Oracle, SQL, SQL Server, Sybase, DB2, EVPN, ACORD, XML,Business Objects, TestDirector, LoadRunner,