SUMMARY

• Over 7 + years of working experience as a Data Modeler and Data Analyst wif high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Extensive experience working in all stages of system development Life Cycle. Extensive experience leading, facilitating conducting Joint Application Development (JAD) sessions among user community, stake holders and technical management, creating project plans and schedules and managing changes.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Having good experience wif Normalization (1NF, 2NF and 3NF) and De - normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle SQL Server and UNIX and Teradata.
• Used Excellent Software Development Life Cycle (SDLC) wif good working noledge of testing methodologies, disciplines, tasks, resources and scheduling
• Excellent noledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Excellent experience on Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and FastExport.
• Experienced in using Excel and MS Access to dump the data and analyze based on business needs.
• Excellent noledge on creating reports on SAP Business Objects, Webi reports for multiple data providers.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Excellent noledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders
• Importing, cleaning, transforming, validating or modeling data wif the purpose of understanding or making conclusions from the data for decision making purposes.
• Strong skills performing data analysis, impact analysis, risks analysis, writing test cases for User Acceptance Testing, Gathered Functional and Data Requirements, analysed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
• Expert in creating Use Cases, Use Case Diagrams, Class Diagrams, Sequence Flows using MS Visio and Rational Rose using UML concepts.
• Solid experience wif IBM Informatiion Analyzer, Informatica IDE/IDQ and data profiling tools.
• Excellent oral and written communication skills, analytical skills, problem solving, leadership and management capabilities wif quick learning abilities Experience in performing root level analysis for data problems by identifying the system processes dat lead to inaccurate data

TECHNICAL SKILLS

Methodologies: RUP, Full SDLC, Agile, Waterfall

Business Modeling Tools: Rational Rose, Microsoft Visio, EA, BPMN1.0, 1.2, 2.0

Change Management Tools: Rational Requisite Pro, ClearQuest

Version Control Systems: Rational ClearCase

Testing Tools: Rational Enterprise Suite

Operating Systems: Windows Family, MAC OS, UNIX and Linux

Other Tools: HIPAA, SOX, ISO, Six Sigma, CMM, FACET

PROFESSIONAL EXPERIENCE

Business Data Analyst

Confidential, Oak Brook, IL

Responsibilities:

• Facilitate requirement gathering workshop wif report users and report developers and prepared user interface mockups to verify wif users.
• Also researching existing reports to extract underlying data and originating data source to determine Data Elements.
• Documenting data ware house requirement such as Data standards and quality rules.
• Data mapping - source to target - including of capturing data acquisitions and transformation rules by analyzing different data tables by writing SQL queries and creating mapping requirements.
• Developed gap analysis and risk assessments for the FACETS upgrade project including TEMPeffects on internally developed extensions and third party software for pricing and contract configuration.
• Served as a point of contact for CMS and trading partners to do the testing for various types of claims and real time transactions for Medicare and Medicaid programs in FACETS.
• Worked on customizing the claim module of FACETS for repricing Nursing home claims.
• Data mapping on Enrollment Module (EDI 834) of FACETS.
• Analyzed the functionality and came up wif test scenarios for split-billing process on FACETS.
• Conducting workflow, process diagram and GAP analysis to derive requirements for existing system term considerations, the long term considerations and its benefits.
• Conducting process improvements, status meetings, monitored and tracked progress of project following Agile methodology.
• Source to target mapping from the ODS Legacy System to new EDW.
• Worked closely wif Data Architect to review all the conceptual, logical and physical database design models wif respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design dat feeds the logical data models of new the EDW.
• Capture different kinds of DQ validation rules to ensure dat the EDW gets the cleansed data for report generation.
• Also Creating Use Cases and Test Cases for each of the allocated requirements and forwarding them to the Developers for the design and development of the system.
• Established and enforced enterprise data warehouse architecture standards, including table structures, naming conventions, key definition and generation, optimization etc.
• Responsible for claim adjudication likeMedicare claims, professional claim,institutional claims.
• Responsible for the full HIPAA compliance lifecyle from gap analysis, mapping, implementation and testing for Medical claims.
• Responsible for gap analysis in changing old MMIS and Involved in testing new MMIS. Also, accountable for Medicaid Claims Resolution/Reimbursement.
• Worked wif the business users to define business requirements, data requirements and analyze the possible technical solutions.
• Tested the data using the Logs generated after loading the data in to EDW.
• Conducted user interviews, gathered requirements, analyzed, and documented business requirements based on the analysis of loan processing workflow model.
• Created workflow, process diagram and gap analyses documents to derive requirements for existing systems enhancements.
• Participated in data analysis and data dictionary and metadata management -Collaborating wif business analysts, SMEs, ETL developers, data quality analysts and database administrators.
• Profiled large datasets and datafiles using SQL as primary language to check the quality of the source data.
• Performed impact analysis on required changes to data and data structures and respond in an expeditious manner.
• Translating business requirements into data requirements.
• Serving as a data subject matter expert in support of technical and testing teams to clarify and rapidly resolve issues and questions needing source system resource cooperation and expertise.
• Developing technical data mapping documents and related functional specifications.
• Understanding and interpreting how data mapping choices effect business programs / reporting requirements.
• Designing the business requirement for the project scope, more efficient ETL process and Software Development Life Cycle methodology. Also halping in designing and developing database model.
• Performing data analysis and created and used complex SQL extensively for analysis and business logic validation.
• Gathered user and business requirements through brainstorming sessions and other requirement gathering Created the Data Mapping Document to specify the Mapping from various sources to the target database, performed Data Archiving conducted Data Analysis and received Data Feed from updated Data Sources.

Confidential

Business Systems Analyst

Responsibilities:

• Manage national product/service launches wif the ongoing maintenance and ensure they appear on site
• Serve as B2B lead for content development representing Verizon Enterprise on all national product/service related projects as part of their GTM initiatives
• Responsible for the configuration of business requirements in the Facets system for multiple customers, specializing in Agreements, pricing, Network Fee Schedules and Medical product builds.
• Conducting JAD sessions wif different Business Users to develop new policies and procedures for the Service Catalogue, Charge Capture and Service Worklist /Charge Router, Hospital billing, coding, special coding requirements for Confidential and Claim processing.
• Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for Medicaid Claims.
• Served as a liaison between the internal and external business community (Claims, Billing, Membership, Capitation, Customer service, membership management, provider management, advanced Healthcare management, provider agreement management) and the project team.
• Actively analyzed current business processes (Claims, Recipient eligibility and enrollment etc.) and worked wif management to improve and implement enterprise solutions to ensure compliance
• Participated in ISO External Audit.
• Sound noledge on Group/Class-Plan/Subscriber/Member front end configuration.
• Identify and deliver on operational opportunities to improve processes, communication, applications and customer experience
• Provide support to internal stakeholders and account reps as a Subject Matter Expert in device builds, launches, and troubleshooting
• Analyze reporting data to identify improvements to increase utilization of Business Internet platforms
• Generated data extracts for reporting annual costs on medical prescription plans wif On-Line Reporting, RIMS, and NDB and presented findings to resolve cost discrepancies; Reviewed testing specifications on proposed application/systems modifications; provided testing feedback to IS/IT developers and assisted in resolving problematic functionality of implementation changes.
• Validate changes to ensure accurate customer experience during pre and post releases
• Investigate production related issues and provide a readout and solution to manager
• Interface wif internal stakeholders to ensure alignment and collaborate wif IT and develop process improvements
• Serve as HQ Lead for B2B online content on projects and participating on command centers
• Support Enterprise Releases to ensure all builds and content meet expected outcome
• Support User Acceptance Testing as needed to meet the needs of the enterprise customer

Confidential

Business System Analyst

Responsibilities:

• Created Business Requirement Document and Functional Requirement Document (FRD)
• Elicited business requirements from clients and translated them into functional specifications and assisted in technical design
• Created and implemented business partner feedback mechanisms
• Created Use Cases to make developers understand the requirements in more easy way
• Contributed to the creation of business plans (including business cases) to assure plans meet company goals
• Integrated business plans wif technical programs and project plans
• Served as liaison between architects, developers and designers, and wif internal business partner and/or vendor companies
• Provided technical/functional assistance in identifying, evaluating and developing systems and procedures dat are cost TEMPeffective and meet user requirements
• Served in a consultant role in Software Development Life Cycle (SDLC) models
• Lead cross-functional teams to address business or systems issues
• Actively involved in updating internal processes (submit claims, check eligibility), updating data collection and data reporting
• Supported team by assisting wif functionality questions, testing, and implementation
• Conducted technical/non-technical presentations to the management and training workshops for the clients.

Business Data Analyst

Confidential, Irving, TX

Responsibilities:

• Eliciting, documenting / detailing functional, non functional/ supplemental requirements, business rules/web intelligence rules from users, existing systems for the evolving applications.
• Assigned tasks among development team monitored and tracked progress of project following Agile methodology.
• Facilitated Joint Application Development (JAD) sessions. Gathered requirements using interviews, document analysis, requirements workshops, storyboards and surveys
• Participated in creating E-R diagrams and class diagrams during the central repository implementation phase. Gathered requirements for the reporting system which was based on the central repository
• Performed risk management for identifying, analyzing and managing existing and expected risks in the project by creating Risk Management and Response Action Plan
• Identifying external, internal Interfaces, data exchange points ECM and EDW requirements, work items, hand-offs, compliance rules, financial report requirements and documenting/managing deliverables.
• Creating/Updating Use Cases, activity diagrams, class diagrams, data Models/ data flow diagrams.
• Created and executed SQL queries (using Rapid SQL and MS Access) and scripts to validate data movement and generate expected results for UAT.
• In depth analyses of data report was prepared weekly, biweekly, monthly using MS Excel, SQL & UNIX
• Eliciting requirements for relational databases, batch processing systems and various reports.
• Writing User Acceptance Test Cases from requirements and managing them in Mercury Quality Center.
• Test defect tracking in Quality Center and coordinating bug remediation.
• Managing, version controlling, distributing project documents, release review decks via Sharepoint.
• Process measurement (metrics), process monitoring, process simulation, process improvement.
• Training users, peers on various deliverables, process steps/methodologies, tools, applications.

Business Data Analyst

Confidential, TX

Responsibilities:

• Requirement gathering from business users to prepare an Interface Specification Document to be provided to various LOBs for sourcing data.
• Involved in gathering requirements from the Business Users in creating an TEMPeffective data model to capture all the required data attributes.
• Data modeling for different domains in staging layer.
• Involved in performing a gap analysis on the existing data model of the staging layer versus the requirement on Data Management Portal.
• Providing pseudo code to ETL development team for capturing exceptions as a part of DQ process.
• • Preparing S-T mapping document incorporating different business transforming logic for implementation of the ETL process.
• Involved in exception handling process by create work flow to escalade it to the respective LOBs.
• Run a BO report to validate the process developed in DM Portal for report generation.
• Worked closely wif the Project Manager in creating the process swim lane.
• Involved in a periodic reconciliation of data between the various source and the end target system and create a BO report on the reconciliation breaks to be displayed in the DM Portal.
• Provide SQL queries to extract data from the Legacy System on alerted accounts and customers information to feed into the Portfolio Analyzer system.
• Analyzing feed metrics data as a result of the ETL process to come up wif the efficient SLA time to provide to the Operation team.
• Creating a Monthly Release Notice to communicate and aware various business partners on upcoming releases and implementations.
• Involved in creating a detailed user manual on the DM portal applications to be provided to the users.
• Data profiling using InformaticaAnalyst tool, generate score cards.
• Involved in writing use cases for UAT testing and writing validation scripts using SQL and UNIX
• Creating Data Model for Feed Management.
• Brain storming on possible BLT exceptions dat can arise as a part of the ETL implementation.
• Performed Data Analysis and Data validation by writing complex SQL queries.
• Worked on automation process to maintain Reference Data from various systems to refresh the data periodically.