SUMMARY

• Over 8 years experiences as Sr Business Analyst / Data Analyst solid understanding of Business Requirements Gathering, Business Process Mapping Evaluating Data Sources, Data Mapping, Translating Requirements into Specifications, Application Design.
• Expertise in System and Gap analysis, conducting workshops, analyzing existing business processes, and determining project scope, risks and complexity.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Written multiple Use Cases for EDI transactions (Inbound and Response) including 837, 276, 277, 835, 834, 820, 270, 271 transactions.
• Expertise in EDI HIPAA 4010 - 5010 project to convert EDI x12 healthcare 4010 transactions into 5010 complaint transactions.
• Extensive experience in writingSQLand PL/SQLscripts to validate the database systems and for backend databasetesting.
• Strong knowledge of Unified Modeling Language (UML), System Development Life Cycle (SDLC) methodologies like Waterfall, Rational Unified Process (RUP) and Agile/SCRUM.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing
• Extensive experience in ETL testing with thorough understanding of data warehouse concepts
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP).
• Implemented various HIPAA codes (270 and 276) used for Billing and Eligibility purposes of patient records.
• SME for Oracle Letter generation based on the HIPAA guidelines involved in protecting the patients information
• Experience inDataMining,Datamapping andDatamodeling and good understanding of the ETL tools like AB Initio, SSIS and Informatica Power Center.
• Developed Test Cases, Test Scripts and SQL to perform Unit Testing, System Testing and Load Testing. Worked with Operations and Platform teams to migrate ETL Code and DB objects from Development to Testing, UAT and Production.
• Good experience in performing Gap Analysis using AS-IS and TO-BE business processes.
• In depth knowledge of SDLC and implementation of the Rational Unified Process (RUP) in all four phases of a project: Inception, Elaboration, Construction and Transition.
• Comprehensive knowledge of RUP, Agile, Scrum, FDD, Waterfall Methodologies

TECHNICAL SKILLS

Operating System: Windows Server, Windows Server, Windows NT / XP and Windows

Languages: C++, HTML 5, Java Script, XML, XSD, SQL, PL/SQL, UNIX Business Intelligence shell Scripting, VBScript

Database Tools: SQL Plus, SQL Loader, SQL Developer, TOAD, Autosys, Zone, Serena, Teradata, ETL,Data Stage/Quality Stage,SAS

Tools: MS Office, MS Project, TOAD, MS Visio, Rational Rose, Rational Requisite Pro, Clearquest, Clearcase.

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, Doors Erwin Data Modeller, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modelling & Analysis, Business Environment and Market Research Analysis,Scrum Master Agile Project Manager, UML, Visio, RUP, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Augusta, GA

Sr.Business Analyst / Data Analyst

Responsibilities:

• Used Data warehousing for Data Profiling to examine the data available (Data Analysis) in an existing database
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Successfully managed the production support team for mortgage servicing application.
• In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Responsible for providing business requirements within an AGILE software development SCRUM environment.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Created design documentation related to system specifications including user interfaces, security and control, performance requirements, claim processing and data mapping.
• Identifying Business rules and specifications for Enrollment files, Medical Claim Files and Pharmacy files for the ACA Edge Server project
• Created Profiles and Roles based on Organizational role hierarchy, implemented Record-Level and Field-level security and configured their sharing settings.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Tested the application by writingSQLQueries and creating pivot views as to perform back-endtesting.
• Conducted Business Analysis and Requirements Analysis activities to in corporate HIPAA and Medicaid provisions for Design, Development and Implementation Project.
• Provided data access reports to Compliance and Security ensuring that data and roles are properly defined and transparent.
• Extensive experience in all phases of RUP and SDLC processes
• Used UML to produce Use Case models, Activity and Sequence diagrams, as part of the detailed design of interfaces.

Environment: RUP, Rational Requisite Pro, Visio, MS Project, MS Office,SQL, Security Controls, Datawarehouse, Scrum (Agile) implementation

Confidential, Rochester, MN

Sr.Business Analyst / Data Analyst

Responsibilities:

• Using Agile promoted Adaptive Planning, Evolutionary Development and delivery atime-boxediterative approach, and encourages rapid and flexible response to change.
• Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardization data structures, data base design, data warehouses, business
• Worked on Business Intelligence tools like Cognos, Business Objects.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Worked on data modelling and produced data mapping and data definition documentation
• Contributing to software process-reengineering efforts aimed at evolving current software development practices to adopt Lean/Agile and Scrum practices
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines and used agile methodologies (RALLY MANAGEMENT SOFTWARE) to in corporate rapid changes in the requirements and to assure Real Time Visibility in the project.
• Assigned tasks among development team monitored and tracked progress of project following Agile methodology. intelligence/analytic tools, SQL, ETL tools, and data integration methods
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Extensive experience in ETL processes in extracting data from Operational and Legacy Systems to Data Warehouse using Informatics.
• Worked closely with System Architect to implement Service Oriented Architecture (SOA), Client side Validations, Server side Validations, Web Services and Web Methods involved.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.

Environment: ETL, SQL Server, Rational tools like Rational Rose and Requisite pro, Rational Clear Quest, Informatica, Agile/Scrum, Business Objects, Test Director

Confidential, Schenectady, NY

Business Analyst / Data Analyst

Responsibilities:

• Worked with SSIS to load individual table and work with SSRS to generate reports.
• Worked With HIPAA compliant ANSI X12 837 formats for both professional claims and institutional claims.
• Experience in calling a Web Service, through SSIS Package
• UsedFACETSAnalytics for fast and easy retrieval, display and grouping of information for performing queries and generating reports.
• Worked with FACETS, Facets are extended enterprise of Trizetto's solution to assist payer organizations in staying ahead of trends in the employer benefits market
• Involved in extensiveDATAvalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Construction and test of incrementaldatamovement code (extract, cleanse, validate, transform, and load)
• Performed extensive task which include DataQuality Analysis,Datalineage andDataStandardizationdatastructures,database design,data warehouses, business intelligence/analytic tools, SQL, ETL tools, anddataintegration methods
• DevelopedDatastage parallel jobs using stages Transformer, Modify, Look-Up, Join, Merge, Aggregator, Remove Duplicate, Column Generator, Change Capture, Change Apply, Dataset, Sequential File stage etc.
• Extensively usedDatastageEnterprise Edition (Parallel Extender) to develop various jobs to extract, cleanse and load thedataand also involved in migration from DS to versions.
• UsedDatastageDirector to schedule, monitor, cleanup resources and run job with several invocation ids.
• Used SharePoint web application platform for content management, document management file management, business intelligence and process integration.
• Scheduled reports for daily, weekly, monthly reports for executives, Businessanalystand customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Worked with Waterfall methodology during the beginning of the project then transitioned to Agile methodology
• Worked on design and development inDatastage VTO develop ETL code including:
• Handled Source to TargetDataMapping, Technical Specs documentation, and ETL documentations such as EarlyDataInventory DesignedSSIS Packages to transferdatabetween servers, loaddatainto database on SQL Server 2005 environment and deploy the data.
• Support for creation and documentation of the ETL Detailed Design.
• Perform Metadata analysis of the Grants data dictionary from various grants systems;
• Modified existing program logic to improve overall system performance.
• Created Sequence jobs to control the flow of jobs and their dependencies
• UsedDatawarehousing forDataProfiling to examine thedataavailable in an existing database.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Working with the application and BusinessAnalystteam to develop requirements
• Translating process/technical solutions for business during defect analysis
• Used TOAD, PL/SQL developer tools for faster application design and developments transformation, and wherein you declare a variable with its URL link
• Participate in the scrum meeting and also represented the teamduring the meeting
• Working through the phases of SDLC using the Agile methodology
• Worked closely with Development team on ETL process,datainfrastructure,datamodeling, business intelligence reporting and dashboards
• Responsible forDatamapping testing by writing complex SQL Queries using WINSQL
• Reviewed ETL and Business Objects defects and proposed fix for defects as per the scheduled timeframe
• Configured SSIS packages to in corporate slowly changing dimensions for tracking historical data.
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server.
• Dealt with the EDI transaction 835 claims payments and remittance advice, which deals the payment from payer to provider.

Environment: IBM Information infosphere Informatica, SSIS, SSRS, COGNOS, Windows XP Toad for Oracle Version, SQL Developer, Agile, Waterfall, Oracle, MS Office tools, Facets, HP Quality Center, Windows, SharePoint, MS Visio.

Confidential, CT

Business Analyst / Data Analyst

Responsibilities:

• Experience in Data Validation, Data Modeling, Data Flows, Data Profiling, Data Mining, Data Quality, Data Integration, Data Verification, and Data loading
• Worked on generating variousdatamodeling reports and publishing model in various formats.
• Conducted review meetings with development, QA anddatateam to communicate business requirements.
• Experience in development of data integration solutions using leading ETL products.
• Worked on maintenance of model using the Complete Compare and Update Model features.
• PerformedDataAnalysis using procedures and functions in PL/SQL.
• Used MS Visio to represent system under development using case diagrams, activity diagrams and workflow diagrams.
• Produced functional specifications and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Performed analysis, review, and estimation of client requests; prepared and reviewed system requirements and client documentation.
• Aided management in standardizing Web applications by preparing GUI standards and recommending alternatives for in corporation in phased, iterative manner.
• Creating the as is and to be business process model to redesign to eliminate manual operations.
• Structured the Database and Wrote requirements for designingDataMarts that were used as the source for the various reporting systems in the company.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach
• Involved in Analysis, Design and flow of user interface in web application
• Worked with the DBA and Database developers to convert the functional specification to technical specification and generate thedatamodel.
• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation.
• PerformedDataModeling by creating Logical and Physical models of the database system in ERwin.
• Developed an Intranet Web Server for User Support and System-wide documentation.
• Implemented Agile Scrum methodology for the project life cycle and scrum framework for team management.
• Participated in Code and Design Reviews for the ODS project for backendDatapopulation and reporting system.
• Responsible for the project management activities of a web application including call center application,datawarehousing, customer relationship management,
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Scrum and Rational Unified Process, especially from the project management, requirements and architecture perspectives.
• Prepared interview questionnaires for the users and gathered requirements to writing specifications and shaping the software development process.
• Performed Forward Engineering to generate DDL scripts and Reverse Engineering of theDataModels.
• Consulted with SMEs and core team about the requirement and technical issues.

Environment: Erwin Oracle, PL/SQL, MS-SQL Server, Agile/Scrum, DB2, UNIX, MS-Office, MS-Visio, SAML, Windows NT

Confidential, Newark, NJ

Business Analyst

Responsibilities:

• Extensively studied the Rules & Policies that supported the Health Care Reform requirements.
• Independently created Business Requirement Document (BRD) for the whole project.
• Conducted meetings, Joint Application Development (JAD) sessions and interviews with the business users to gather requirements.
• Held team meeting with the SMEs to understand the Verifications and Validation process.
• Created and maintained the Requirements Traceability Matrix (RTM).
• Conducted walkthrough the BRD for the technical teams to help understanding the requirement.
• Constantly updated the BRD as per the changes in the requirement and informed the whole team regarding the new changes.
• Worked with FACETS edits and EDI HIPAA Claims (837/835/834) processing.
• Worked on EDI 834, 837, 835 and 278 files and validated the functionality according to HIPAA regulation& Facets.
• Reviewed EDI 837 claims and flagged HIPAA non­compliant claims received from the Payer side.
• Worked on Medical claims adjudication process of facets application.
• Understood complete claims processing cycle from the payer/provider perspective
• Performed UAT testing with the offshore team.
• Participated in defect review meeting and providing technical expertise on how to resolve the issues related to configuration and/or test scenarios
• Coordinating with the Release Management Team in order to complete the overall release.
• Worked with the QA team in testing the application using HP QTP.
• Logged application bugs and was involved in all stages of the bug life cycle.
• Dealt with Project lead, stakeholder and end users regarding any issues encountered during the project.

Environment: UAT, MS SQL Server, MS office, MS Visio, Quality Center, Agile, Clear Quest