SUMMARY

• Over 7+ years of experience in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Proficient in querying various RDMS like Oracle, Teradata, DB2 and SQL server.
• Good knowledge in data analysis, data requirement analysis and data mapping for ETL processes.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good working knowledge of MS Visio, MS Projects,SASand MS Office tools.
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Exceptional communication and presentation skills and established track record of client interactions

TECHNICAL SKILLS:

Platforms: UNIX, Linux, Windows

RDBMS: Oracle, Teradata, SQL SERVER

Data Modeling Tools: MS Visio

Test Tools: Quick Test Professional, HP Quality Center

Querying Tools: Teradata SQL Assistant, TOAD, SQL Server Management Studio, SQL Plus, SQL Developer, Teradata-BTEQ

ETL/Business Intelligence tools: SAS, Stata, Business Objects, Informatica, Tableau

PROFESSIONAL EXPERIENCE

Confidential, MA

Sr. Data Analyst

Responsibilities:

• Involved in the entire SDLC of the project. Requirement & Analysis, Design, Development, QA, UAT and Implementation.
• Identifying areas for business improvement specifically in Facets claim processing for the insurance.
• Was part of the requirements workshop and assisted in requirement gathering from the users and creation of BRD. Prepared the FBTR (Functional, Business and Technical requirement document) based on the BRD.
• Worked with accounting department in matters concerning billing and billing reports in Facets Solution.
• Created BRD and FRD for Medicaid managed care requirements and documenting them.
• Gathered required business rules for data transformation
• Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.
• Heavily involved in all aspects of theFacetsupgrade processesthat includedreviewingnew versiondatamodel, batch jobs, online functionand SQL source programs, comprehensive infrastructure planning, deep troubleshooting of customizedInterface Application and batchjobs, and testing ofFacetsCoreAdministrationSolution Application to ensure valid functionality for deployment
• Prepared the business requirement document (BRD) and system requirement document (SRD).
• Creating reports inSAS, Business Object/Crystal reports depending on the complexity of the report.
• Responsible for checking member eligibility, provider enrollment, member enrollment for Medicaid and Medicare claims.
• Wrote FRDs for the defects and enhancements and got approval from business for the developers.
• Worked on Technical design documentation (TDD) of the claims processing system.
• Documented the dimensional models of ETL system.
• Worked on Data Mapping to map Facets data to outbound eligibility extracts.
• Actively involved in understanding the business requirements, collecting data, performing data analysis and data migration as per the business needs to maintain data warehouse/data mart.
• Wrote complex SQL queries to extract and validate the data from the Facets database for member and claims data.
• Created and maintained data mapping document(s) in reference to the HIPAA transactions: 270/271, 276/277, 837, 834 and 835.
• UsedSASto extract, analyze and transform data from legacy databases.
• Experience in all the latest BI Tools focusing on Tableau and Qlikview Dashboards in latest Design, Presentation and solving client's reporting needs.
• Wrote Excel Macros/VBA for data validation, data manipulation and generating reports.
• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. This includes HIPAA 837, 835, 270/271, and others.
• For data validation purposes, manipulated member’s information in the Testing environment through Facets front-end application
• Support maintenance of database schema, tables, procedures and users/user access levels for each segment of database and modify existing databases and database management systems.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Worked on electronic Medicaid eligibility verification system & the Medicaid & Medicare intermediary along with their roles in claim processing.
• Extensively used SQL and BASICSASfor data extraction and took part in User acceptance Testing (UAT)
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Coordinated with the developers and IT architects to design the interface of the new system according to the X12 (270, 276, 278, 834, 837 (I,P,D) and 820) standards
• Work as part of a project team to coordinate database development and determine project scope and limitations. Review project requests describing database user needs to estimate time required to accomplish project.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment.
• Worked extensively with client gathering requirements to generate customized SQL reports.
• Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardizations.
• Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for processing of Medicaid Claims.
• As part of technical team that focuses on ensuring compliance to the data models, data standards and overall data architecture. Monitored compliance by conducting reviews of the project logical and physical data models.
• Performed Work Product Review (WPR) to ensure that the documentation was up to the standard and without any errors.
• Written SQL queries for validation of ETL Reports from Source to Target system
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Developed ER diagrams and Physical Data-model along with the testing team so as to provide a clear understanding of the system under development and for reference of the testing tem
• Extracted data by running SQL queries, and analyzed financial and customer metadata that gets populated on the web application
• Extensively used ETL to load data from XML files, Flat files data also used import data
• Worked with technical team to verify and validate the metadata and database against theSASdatasets.
• Analyzed, designed, built and tested reports while working directly with end-users.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
• Designed the Unit test cases required for Unit testing before migration to the Testing Environment.

Confidential, Brentwood, TN

Business Analyst/Data Analyst

Responsibilities:

• Ensure all artifacts complied with HIPAA 4010 policies and guidelines.
• Formulates and defines systems' scope and objectives through research, data mining, analytics and fact-finding.
• Articulates and presents business analysis results clearly and concisely to programming staff and senior management. 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
• Worked with FACETS Team for HIPAA Claims Validation and Verification Process (Pre-Adjudication)
• Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports.
• Performed Requirements Gathering and Analysis, interviewed the SME and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.
• Gathered detailed business and technical requirements and participated in the definitions of business rules and data standards.
• Used advancedSAStools automate the reporting systems to generate daily and monthly reports.
• Using of Request Tracking System, which is a part of the proprietary CMS application for fulfilling actions on different actions codes relating to a corresponding number of actions.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse, Data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• 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.
• Tested validity and integrity of the calculation engines for Deferred Annuities, Past Services Pension adjustments
• Facilitated SME interviews and assisted in identifying and analyzing the possible technical solutions
• Developed reports using SQL in MS SQL Server environment
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams
• Tested the changes for the front end screens in FACETS related to following modules, test the FACETS batches (membership, Billing, Provider, etc.)
• Retrieved the data from flat files, oracle database with the SQL pass through facility and createdSASData sets for analysis.
• Worked with major components of EDI 837 or hardcopy claims input and 270/271, 276/277 queries.
• Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, plan codes, benefit set-ups, fee schedules, provider pricing, capitation set-ups, etc. from Legacy system to FACETS (Client Server based system).
• Worked on a database driven web based CTMS solution for tracking regulatory and clinical data in a clinical trials environment.
• Works with business users to document current end to end work flow processes and collaborates with users in identifying, defining, and documenting process improvement options and alternatives, as directed by business needs.
• Experienced in relational databases (RDBMS) like Oracle, SQL, and MS Access.
• Utilized SAS reporting to com-up with prediction models with graphical presentations generated daily reports using SAS to enhance the monitoring of various business processes.
• Works with business users to define and document business rules

Confidential, Knoxville, TN

Data Analyst

Responsibilities:

• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Developed schemas for extraction, transaction, and loading (ETL) to expedite data integration between systems
• Development of conversion related documentation including data mapping documents and conversion strategy documents.
• Involved In Testing the EDIs according to HIPPA code set 834 enrolment and disenrollment in a health plan using QTP
• Worked on technical knowledge specific to Cognos tools and the existing data model to other team members.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Responsible for designing and developing universes for development of reports using business object designer
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams
• Worked as a liaison between business users, testers and application development team
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update strategy, Joiner, Normalizer, Union, Store procedure and XML transformations
• Ensured systems compliance with meaningful use guidelines
• Routine Clinical Documentation on Electronic Medical Record Software
• Performed numerous data extraction requests involving SQL scripts and UNIX
• Performed data migration between different environments and Third Party Databases
• Performed drill down analysis reports using SQL server reporting services
• Tuned SQL queries using optimal indexing and analyzing tables. Used EXPLAIN PLAN to understand the execution path of the SQL queries.
• 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.

Confidential, Pittsburg, PA

Data Analyst

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Experience in Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Extensively used ETL to load data using Power Center from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Design and Development of ETL routines, using Informatica Power Center Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Analyzed and determined the most complex transformations
• Used Update strategy and Target load plans to load data into Type-2 Dimensions
• Designed the complete workflow for all the extracts (mappings) to serve the business requirements with dependency hierarchy.
• Developed, monitored the workflows and responsible for performance tuning of the staging and 3NF workflows.
• Responsible for monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings that failed.
• Created PL/SQL packages, Stored Procedures and Triggers for data transformation on the data warehouse.
• Created the parameter file to run the workflow.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels
• Created Snapshots, Summary tables and materialized views in Database to reduce the system overhead.
• Developed and maintained Reports using Business Objects.
• Involved in Designing BO reports & Universe & guiding designers and developers for each component.
• Generated, published and scheduled reports in Web Intelligence.