PROFESSIONAL SUMMARY:

• 7 years of professional experience as a Business Analyst in Healthcare Industry wif extensive experience in HIPAA, ICD, Crystal Report, Big Data, MDM and other tools .
• Worked Data warehousing, Business Intelligence (BI) Solutions design & development, business Intelligence area dealing wif data analysis, solution design Metadata management and MDM, ETL.
• Worked on Crystal Reports 2011/2008/XI also worked on Oracle 11g/10g/9i, SQL Server 2008 R2/2008/2005, MS Access and other Database Applications.
• In depth knowledge of health care basics including Medicare/Medicaid (Part A, B, C and D) HIPAA, ICD9 and ICD10 and EDI Transactions.
• Extensive experience in analysing and requirements gathering and writing system functional specifications.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008/2012 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2012 .
• Responsible for Gap analysis in HIPAA 4010 to HIPAA 5010.Incorporated and implemented all teh HIPAA standards, Electronic Data Interchange (EDI), transaction syntax like ANSI X12, ICD - 9, ICD-10 coding.
• Adequate knowledge in Health Administration - Claims processing (auto adjudication), COB, EOB/Drafts, Claims pricing and testing, HIPAA, enrollment, EDI, Medicare, Medicaid, CDHP (consumer driven health plans).
• Proficiency in Data Modeling tools like Erwin, ER Studio and Power Designer, developing and modeling Entity Relationship diagrams, Transactional and Data Warehouse Databases.
• Experience wif SQL Server Suite of products (SSIS,SSAS and SSRS) involved in all phases of Software Development life cycle from gathering requirement, development, implementation, testing and support wif various business domains like Health Management and Insurance in agile environment.
• Developed data workflow, including legacy system profiling, mapping of data, documentation of business rule validations, and reconciliation of historical data for an enterprise integration.
• Translates data file formats (ETL) in Access, Microsoft Import/Export Wizard, SSIS also strong experience in RUP Business modeling process.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehouse Data Modeling and Design.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Extensively worked on store procedures for new system changes and troubleshoot teh existing store procedures to work more efficiently.
• Excellent knowledge and experience of creating source to target mapping, edit rules and validation, transformations, and business rules.
• Design and review of various documents including teh Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Highly motivated team player wif excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills.
• Strong working experience in teh Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Good command over Logical and Physical entity relationship data modeling using Erwin, Oracle Designer and Power Designer.
• Experience in Data Modeling, Data Mining and Data warehousing in SQL Server and Oracle environment.
• Experience in Extraction, Transformation and Loading (ETL) of Data from CTL in teh structured data warehouse.
• Hands on experience of tracking of various exercises and ensures dat data and process are consistent and possessing strong understanding in Data Life Cycle and Security Policies.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Solid understanding of Business Process definition, Risk Analysis, Agile and SDLC methodologies.
• Strong business analysis skills and a sound understanding of teh Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP) methodology.

TECHNICAL SKILLS:

• SQL, PL/SQL, Crystal Report
• Design of Data Warehouse
• HIPAA, ICD, Tableau, MDMS
• RUP, OBIEE, Master Data Management
• Eagle PACE, Business Intelligence
• Consultancy, Data Modeling
• BI Dashboards, BI Reporting
• SQL programming, Advanced Analytics
• Data Mining, Project Management, IBM Websphere, BI s, Presentations
• Requirement analysis,Crystal Report, Business rules, Data flow diagram
• Flowcharts, Business process modeling
• Cause and TEMPEffect Analysis, Decision tree, BRD, BRS, SRS .

PROFESSIONAL EXPERIENCE:

Confidential, Newyork, NY

Data Analyst

Responsibilities:

• Created reports using Crystal Reports 2008/XI wif Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Developed Crystal Reports to address different levels of teh organizational needs starting from Individual employees to an entire Line of Business.
• Involved in Health Insurance Exchange (HIX), an ACA/HIPAA compliant product for teh configuration.
• Created Business Rule Comparison (BRC) documents and Side-By-Side (SBS) comparison documents using 10 implementation guides for X12 transactions in Excel spreadsheet.
• Experience wif AGILE Tool and methodology. Responsible for teh full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for Medicaid Claims.
• Performed ad hoc data extraction using data mining techniques such as SQL, keyword search .
• Extensively involved in teh modeling and development of Reporting Data Warehousing System and implemented and Maintained teh compliance and regulatory reports out of Eagle PACE, Eagle Data Mart.
• Pulled campaign lists for various marketing programs using Multi-Channel Campaign Management (Aprimo MCM), SQL and SSAS.
• Responsible for extracting data from teh data warehouse using SQL and Report Builder related to Business Banking Activity. Produce reports, dashboards, and bonus calculations to provide management wif accurate information to make better business decisions.
• Other Responsibilities included modifying existing Crystal Reports to meet user requirements.
• Identified and prioritized strategic themes of teh business to align them wif IT strategies theirby growing revenue, improving profits through efficient quality of services.
• Collected key data metrics to determine mandatory and discretionary investments based on teh prioritizations and projected teh expected returns using MS Access.
• Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
• Created SQL queries to pull out data and metrics from teh database and assisted in creating teh Physical database for MDM and teh Data Mart.
• Exploited power of Teradata to solve complex business problems by data analysis on a large set of data.
• Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, Analysis and Reporting System
• Worked on teh ETL Informatica mappings and other ETL Processes (Data Warehouse) and wrote teh SQL queries on data staging tables and data warehouse tables to validate teh data results. Experience in creating UNIX scripts for file transfer and file validation.
• Created and Designed logical database schema for data warehouse (Teradata) environment to prepare for ETL.
• Worked wif financial executives to design and develop financial reports/budgets, built database and ETL (transform and load) process in SQL Server (SSIS).
• Utilize Pivot Table to analyze revenue by checking and reorganizing company invoices and manage company bank accounts and use Pivot Table and Vlookup to make monthly expense reports.
• Oversaw ongoing development and operations of Oracle 11g and 10g enterprise data warehouses (ETL using Data Integrator/Data Services, PL/SQL, Oracle Data Integrator, and SSIS). Backup support for Essbase and underlying database. Participated in unit, system, acceptance, and validation tests.

Confidential, Salt Lake, UT

Business Data Analyst

Responsibilities:

• Gatheird high-level requirement for all teh external projects in a release and conducted evaluation of bank’s data governance structure and identified gaps in structure, data and systems.
• Wrote test scenarios and determined preconditions for preparation of test data files, created, managed and executed test cases, and testing for processing of Medicaid Claims.
• Monitor and Analyze Epic Medical/Revenue Cycle (Financial), HIM (Health Information Management), Cadence, Radiant and HB (Healthcare Billing) workflow process information.
• Involved in various third party application migrations like Aprimo, Business Objects, Crystal Reports.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Generated parameterized reports, sub reports, tabular reports using SSRS and Use of data transformation tools such as SSIS, Informatica or DataStage.
• Created Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Expertise in HIPAA, 820,835, 837, 4010, 5010, X12 format, 997 EDI. Responsible for testing HIPAA EDI Transactions and mainly focused on PA and Eligibility Transactions.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS and Complete study of teh in-house requirements for teh data warehouse.
• Evaluation and selection of various MDM technologies and products in view of teh client requirements.
• Facilitated JAD sessions wif SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Executed PL/SQL on oracle table in order to view successful transaction of data and Built reports and report models using SSRS to enable end user report builder usage.
• Validated teh test data in DB2 tables on Mainframes and on Teradata using SQL queries and worked wif heterogeneous sources from various channels like Oracle DBMS, SQL Server, flat files, and web logs.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Conducted meetings for teh Data Modeling and Analysis and Helped wif Data Mapping between teh data mart and teh Source Systems.
• Used Command Objects and SQL extensively in many reports, also created reports wif drill down option.
• Linear Accelerator radiation delivery and Electronic Medical Record system (EMR) interfaced to Hospital Information System (HIS) for Registration, Scheduling, Reporting, Dictation and Billing.
• Created teh logical models and generated teh physical models in teh databases using Erwin.
• Involved in formatting data stores and generate UML diagrams of logical and physical data and developed project plans and managed project scope.
• Generate SQL reports using Business Objects interface, Crystal Reports, and core databases to publish Utilization Management reports and analyses for Corporate Executive Business Review; interpret trends, provide explanations, and proactively communicate recommendations to leadership based on reporting results.
• Evaluated testing results for each potential release build using Test Director, Quality Center and reports, listing summarized bug information in priority sequence, recommended viability of release for production.
• Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Data cleansing and creation of layouts and specifications for end-user reports, delivering an end-to-end Metadata Management solution in teh process.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Confidential

Business Data Analyst

Responsibilities:

• Performed GAP analysis of AS-IS business rules, business system processes, user administration, and TO-BE system.
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to has teh outputs of project dealt wif teh automation of correspondence directed to Insurance policy owners.
• Responsible for monitoring teh daily report for signs of intrusion in multiple areas and taking corrective action to prevent teh loss of information.
• Writing SQL queries and stored procedures to identify fraudulent claims and data analysis and data validation for various health insurance clients.
• Responsible for monitoring teh On Call email and service desk for access requests and deciding a course of action to allow or deny access to various applications, programs, databases, and remote access for both employees and Third Party contractors.
• Summarized newly enrolled appointment request for office of healthcare transformation and innovation.
• Performed Gap Analysis to check teh compatibility of teh existing system infrastructure wif teh new business requirements.
• Wrote test scenarios and determined preconditions for preparation of test data files, created, managed and executed test cases, and testing for processing of Medicaid Claims.
• Participated in developing Source to Target mappings using ETL process into new Oracle database system.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Involved in prioritizing teh defects and writing business requirements to resolve them and generated Jasper reports for teh client dat halps them in identifying fraudulent claims.
• Conducted JAD sessions wif management, SME, vendors, users and other stakeholders for open and pending issues.
• Gatheird requirements and modeled teh data warehouse and teh underlying transactional database
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin teh Oracle database
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Developed small applications wif Teradata at teh backend and created source table definitions in teh DataStage Repository by studying teh data sources.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisted in designing new UI and XML standards using ACOORD standards and Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel.

Confidential

Data Analyst

Responsibilities:

• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Worked on SQL-based data warehouse environments and created multiple custom database applications for data archiving, analysis, and reporting purposes.
• Prepared test Data sets and performed data testing using teh PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Designed and developed project document templates based on SDLC methodology and process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Gatheird and validated requirements, resulting in detailed business rules, functional requirements and process design.
• Worked in mainframe environment and used SQL to query various reporting databases and also involved in teh design and development of wholesale management system.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Worked on data modelling and produced data mapping and data definition documentation and designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Responsible for physical/logical data modeling; metadata documentation; user documentation; and production specs.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Assisted in development of materials for new technology and process improvements.