PROFESSIONAL SUMMARY:

• Experienced and distinguished Business System Analyst / Data Analyst around 8 years of experience in Software Development Life Cycle (SDLC) and Business Process Reengineering.
• Excellent communication, writing and client handling skills to deliver solid Business Intelligence solutions based on client needs.
• Experienced with the latest in BI and data analysis skills.
• Extensive experience in requirement gathering, data analysis, verification, validation, analysis and design.
• Involved in providing solutions for clients data needs and identifying sources for the relevant data.
• Create relevant artifacts to support usage of the Agile Framework such as: Business Owner View, Process Flows, User Stories, Use Cases, and User Interface Requirements.
• Expertise in enhancement and testing of the EDW application for client reporting.
• Strong organizational and planning skills, ability to work well under pressure, result - oriented, self-motivating and versatile in problem solving.
• Experienced in Agile and Scrum, and the development of associated project artifacts (i.e., user stories, acceptance criteria).
• Skillfully used techniques like interviews, surveys, workshops, JAD, JRP sessions by using design modeling tools like Microsoft Visio.
• Prepared data flow diagrams by analyzing “As Is” and “To Be” scenarios
• Inclusive knowledge in Software Development Life Cycle (SDLC) involved in all stages Including Defining, Designing, Developing, Debugging, and Deployment of applications using different methodologies such as Agile, Waterfall and RUP.
• Firm understanding of Extract, Transform and Load processes using tools like Informatica for data mapping, data modeling and data warehouse concepts.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Experience in data warehousing techniques forData Analysis,Data Profiling, Data Cleansing, Transformation, Consolidation, Integration, Data Import, Data Export using various source (Oracle,MS SQL Server,DB2,Teradata,XMLandFlat files)and target.
• Experience with front end reporting tools like IBM Cognos, Tableau, and SAP Business Objects.
• Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
• Developed thorough artifacts like BRD, functional specifications, Use Cases, UML diagrams, data mapping documentation, pre and post RTM, weekly reports, Data flow diagrams using Microsoft Visio.
• Capability to communicate with configuration manager, production manager and end users.
• Expertise in handling onshore and offshore development team through WebEx.
• Experience conducting User Acceptance Testing (UAT) and writing test cases for the same.
• Knowledge of QA methodologies and processes.
• Involved in test planning, test preparation, test execution and issue resolution and report generation to assure that all aspects of the project are in compliance with the business requirements.

TECHNICAL SKILLS:

Project Methodologies: Rational Unified Process (RUP), Agile, Waterfall

Business Modeling Tools: Rational Rose, MS Visio

Defect Tracking Tools: Rational Clear Quest, Mercury QC, Jira

Operating Systems: Windows NT/XP/2000/2003, UNIX

Databases: Oracle, SQL Server, MS Access, DB2

Languages: C, SQL, HTML, PHP, ASP

Quality Assurance: STLC, Bug Life Cycle

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. Business System Analyst

Responsibilities:

• Formulated and defined systems scope and objectives through research, data mining, analytics and fact-finding.
• GAP Analysis: Analyzed the client’s applications programs to determine the impact of the HIPAA final rule on EDI Transaction Set and Code List implementation and defined the changes to bring the affected systems into HIPAA compliance
• Used Agile methodology during the development of the project. Involved in Scrum Calls, Stand up meetings
• Wrote Business Requirement Document after collecting requirements through conducting interviews, JAD Sessions and brain storming sessions.
• Created ETL documentation such as EDI X12 837(P,I), 834 and 835 Data Mapping, Transformation logic for Main Frame Layout, Updating Meta data documents for new Platform.
• Creating and validating data using SAS functions and procedures.
• Systems Documentation included Business Requirements Document (BRD), Systems Requirement Specification (SRS) and test plans using Requisite Pro.
• SME for Oracle Letter generation based on the HIPAA guidelines involved in protecting the patients information
• Contributed in the writing of5010 Implementation, Companion Guides for all ANSI X12transactions.
• Worked on the EDI 834 inbound and 834 outbound data movement with our trading partners.
• Analysis and Design of the Trizetto FACETS Data Model to ensure optimal system performance and tuning.
• Involved in gathering requirements, configuration, and data conversion of the Facets application modules like Enrollment, and Claim.
• Assisted the EDI team in the development and documentation of the test strategies for the EDI transactions which included all standard transactions, auditing and error correction processes, and the creation of the transactions.
• Re-engineered and captured EDI transactions with legacy systems Enrollment -834, Eligibility Transaction (270/271), Claims (837), Claim Status Request and Response (276/277), Remittance (835) .
• Conducted business validations, covering the following deliverables: FACETS Providers, Facets Claims and Facets and Operational reports.
• Analyzed User and Functional requirements to point out gaps between used SQL queries to extract the data from the database.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models.
• Worked closely on 834 transaction code for Benefit Enrollment and was involved in Validation of HIPAA for 837, 270/271, 276/277,835, 834 EDI transactions.
• Worked on configuration of FACETS with Benefits, Claim processing and Enrollment
• Analyzed EDI transactions in XML and X12 responses.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Identified Actors, Activities, Artifacts and Workflows and developed use case diagrams using Rational Rose.
• Developed reports using SQL in MS SQL Server environment
• Performed Functional, Regression, and system testing for Pricing Application
• Maintained a traceability matrix of the requirements and created test cases, as well as testing matrix of the test cases and any corresponding defects. Conducting business validations, covering the following deliverables: FACETS Providers, Facets Claims and Facets and Operational reports.
• Used Data warehousing for Data Profiling to examine the data available (Data Analysis) in an existing database
• Developed tables, Views, Stored Procedures and Triggers using SQL Scripting.
• Established Inner Join, Outer Joins and created primary key indexes (paired with foreign keys) for dimension tables whenever necessary.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
• Documented the dimensional models of ETL system.
• Involved in design of the data warehouse using Erwin, created Informatica source and target definitions and mappings.
• Involved in preparing several Use Cases, Business Process Flows, and Activity Diagrams using Microsoft Visio.
• Extensively usedExcel/Accessand VBA for the ad hoc analysis of the data.
• Collaborates with Informatica Developers to deliver database designs, information models (logical, physical, dimensional, etc.) data migration plans and data warehouses.
• Created ad hoc reports inquired by the client and/or internal staff.
• Developed test scenarios and implemented test plans for Product test, integration test, system test and user acceptance test (UAT).
• Reported Bugs using Quality Center.
• Involved in extracting the data from various source systems like Sybase, DB2, Oracle and flat files and loaded to a relational data warehouse and flat filesR
• Followed the UML based methods using Rational Rose to create: Use Cases, Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Planned the UAT testing, test plans, test cases and worked with the business users for UAT test execution in developing the documentation.
• Reported and tracked defects using Quality Center.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases.
• Microsoft Office (Outlook, Word, Excel, Visio, Access) at various phases of development for documenting the requirements.
• Experience in relational databases (RDBMS) like Oracle, SQL, and MS Access.

Confidential, Durham, NC

Sr. Business Intelligence Analyst/ Data Analyst

Responsibilities:

• Created system models for the “As-Is” Systems and for the “to-Be” system using Unified Modeling Language.
• Worked on EDW gaps which came into existence after small group migration for EDW client on subject areas like product & group.
• Used requirement elicitation techniques like interviews and JAD sessions to gather and document information regarding upcoming changes.
• Responsible for designing Data warehouse and creating Data Movement Specification as per Business Requirement Document (BRD), and developed Use Cases, and UML diagrams.
• 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.
• Worked extensively with Data modeler’s & data to update the EIM model.
• Conducted detailed requirements gathering sessions for Business Intelligence project.
• Involved in creating conceptual business documentation where I worked on different subject areas and mapping all the data attributes within all the major systems.
• Prepared separate FRD for Data Warehouse piece. Highly involved in both ‘Data Integration’ and ‘Business Intelligence’ (Reporting) section.
• Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
• Worked on FACETS Benefits, Claim processing, Providers Configuration to simplified benefit plan maintenance, open enrollment and renewal processes.
• Performed data mapping and data modeling and used canonical data model to map data from X12 834 transactions.
• Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports.
• Tested the changes for the front end screens in FACETS related to following modules, test the FACETS batches ().
• Worked with Trizetto Facets System implementation, Claims and Benefits configuration set-up testing, Inbound/Outbound Interfaces and Extensions, Load and extraction programs involving HIPAA 837 and proprietary format files and Reports development.
• Analysis of existing data requirements using SQL to document functional requirements from high level User Stories.
• Participated in JAD Sessions to understand the full scope and needs of the project.
• Extensively involved in creating and entering dummy data to test the functionality of various modules of EDW and how the modules integrated with the EDW database and the Facets database in the backend.
• Conducted Data analysis using SQL on the backend databases for producing mapping documentation and transformation rules for developers.
• Worked on the FACETS front end and backend for testing and for documenting the Business requirement documents.
• Worked in the areas of NetworX Pricer, HIPAA 837 mapping & Facets Claims processing, HIPAA 834 mapping.
• Facets Class/Plan Product & Benefit set up and data modeling. Member/Subscriber set up and data modeling.
• Worked closely with EDI to ensure accuracy in data transmissions and shared processes. Transaction sets processed (837P, 835, 834).
• Served as an internal point of contact throughout the business for participating provider information, questions and issues. Assisting in various mandatory projects such as data cleanup, work-flow revisions, upkeep of maintenance and other projects as assigned.
• Documented data flow and data gathering schedules for the newly developed Dashboard application from various sources
• Proactively monitored the accuracy of provider data, and instituted regular audit processes to continuously improve data integrity.
• Familiar with Informatica and business objects by working with the BI team for generating reports using crystal reports for the above projects.
• Involved in daily scrum meetings and walkthroughs for updates.
• Created Use Cases and Requirements documents to document business needs.
• Ensured use cases were consistent and covered all aspects of the requirements document.
• Developed individual test case specifications and test case format.
• Provided backup for other test analysts in the team to co-author and review their documents.
• Involved in giving presentations explaining the test design documents authored by me to other analysts and upper management.
• Worked on Business Intelligence reports development by working closely with Microstrategy, Teradata, andETLteams.
• Set up Enterprise Data Warehouse (EDW) and associated ETL service to generate business reports.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
• Involved in writing Use cases and prepared the Business Requirements Documents for various requirements collected from the business users. Used MS Visio and UML for generating class diagrams and activity diagrams.
• Used MS Excel Pivot Tables for data analysis and reporting for status update and presentation.
• Designed and created SQL Databases tables, indexes, and views, User Defined Functions, Stored Procedures and Triggers based on user requirements.
• Worked collaboratively with Business Intelligence andETLresources to design and develop effective solution. Key role in data analysis, relation modeling and data migration, query tuning /Optimization.
• Involved in data warehouse design/development.
• Involved with the requirement validation for Enterprise Data Warehouse (EDW) with the state stakeholders. Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Performed numerous data extraction requests using SQL scripts to prepare ad hoc reports. Created and executed test plans that improved data warehouse report quality using Word, Excel and Access.

Confidential, Richmond, VA

Business Analyst/BI Analyst

Responsibilities:

• Used agile methodology processes to promote sustainable development by stakeholder, by creating System Requirement Documents (SRD), Business Requirement Document (SRD) and provide delivery of products in required time Frame.
• Involved in all SDLC stages under Agile process requirement analysis, implementation, testing (functional and use acceptance) and deployment.
• Facilitated requirement meetings with business and technical stakeholders to capture requirements in the form on BRD, SRD and resolve conflicts to drive decisions.
• Performed the GAP analysis to find the Root Cause of the issues.
• Partner with business units, project teams and technical groups using storyboards to plan and complete all phases of the development lifecycle.
• Resolved and recommend solutions for improvement.
• Acted as a liaison to promote collaborative communication and bridging gaps between business objectives, the user experience, and technic al implementation.
• Communicated with clients during venture conceptualization to define scope and outline project methodology and associated deliverables.
• Collected and analyzed the BRDs, SRDs, and RFCs to cover all the test scenarios efficiently.
• Led sessions with future users to develop a comprehensive understanding of business processes and document business requirements.
• Developed operational workflow maps that model current and future process workflows including interactions with computerized systems.
• Independently facilitated meetings with diverse individuals at all organizational levels to ensure that developed processes and system functionalities benefit all constituents.
• Evaluated existing business rules, and define future business rules to guide system logic with Tableau BI and Analytics tools.
• Responsible including project plans, meeting minutes, and action items.
• Responsible for coordinating project team schedule.
• Formed advanced SQL Queries and used Microsoft Excel to investigate data issues in the Data Warehouse and worked with the Users and Technology Team to formulate a solution to resolve the issue.
• Worked extensively on Business Requirements, Functional Specification, Data-Integration, Data Mapping, and Data Warehouse access using SQL and Crystal Reports, ETL process, use cases modeling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards.
• Detected, Tracked and Reported defects to developing team lead using JIRA and QC following up the status of defects.
• Involved in writing complex SQL queries including joins, group by, having clause etc.

Confidential

Business Analyst

Responsibilities:

• Assisted in developing a trading platform for equities and fixed income instruments.
• Gathered user and business requirements through conducting marketing surveys and interviewing investment managers.
• Worked with a cross functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus for BRD and FRD and business docs.
• Participated in all Iteration, Scrum, Daily stand-ups and Iteration review meetings working in an agile development methodology.
• Used UML to define system requirements as Use Cases, Use Case Scenarios and Use Case Narratives and created activity and sequence diagrams in MS Visio.
• Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system.
• Prepared Business rules document based on user requirements and industry protocols.
• Advocated standardization of financial information exchange by implementing Financial Information Exchange (FIX) protocol and helped the testing team to test the entire routing using FIX Protocol.
• Analyzed and prioritized user and business requirements data migration inHadoopsystem.
• Developed Release to Manufacturing (RTM) to define the relationship between entities at conceptual level.
• Facilitated Joint Application Development (JAD) sessions with Subject Matter Experts (SMEs) and users for resolving issues.
• Scheduled meetings with developers and testers to collaborate resource allocation and project completion using MS Project.
• Created Mock-up forms in MS Access for better visualization and understanding of the software solution.
• Assigned problems to appropriate software development team for fixes via MS Project.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing using Mercury's Win Runner.
• Created and managed project templates, use-case project templates, requirement types and traceability relationships in Rational Requisite Pro.
• Worked with teams to share documents using SharePoint.
• Worked extensivelywith Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, PowerPoint, Access and Lotus Notes.
• Created SQL queries to read data from databases.
• Authored progress and completion reports, submitted to project management on a weekly basis.
• Developed SQLs for Extracting data from database and built data structures, reports.
• Designed and developed various Ad hoc, Daily, Weekly, Monthly and year-end reports for the Business Analyst using SQL, Ms Excel, Ms Access and Teradata.