SUMMARY

• Around 5+ years of experience in Data analysis/modelling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Strong experience in System and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration and Metadata Management Services and Configuration Management.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Excellent industry knowledge on Membership, Claims processing, Provider, Prescription Benefits Management, Clinical Data, LAB data Value Based Care, Wellness Content Management, Medical Management and Medicare, HEDIS, EDI and Standard Medical code set (CPT, ICD9/ICD10, LAB etc.).
• Extensive Knowledge of HealthCare Data including claims, Pharmacy, Lab, Member, Providers, HEDIS Measures Knowledge, CMS and NCQA knowledge domain & Experienced in all phases of the Software Development Life Cycle (SDLC), Rational unified process (RUP), agile methodology.
• Experienced in Business Process Reengineering and Gap analysis to check the compatibility of existing system infrastructure with new business requirements. End to end experience in designing and deploying data visualizations using Tableau & Utilized knowledge of federal, state and local Healthcare legislation and policy to manage and lead offshore product development teams in designing strategic, information technology solutions to include: C - level dashboards, ad-hoc reports and free-text analysis.
• Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio, Rational Suite and SQL.
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyser and SQL Navigator.
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large enterprise data warehouse systems. Expertise in MS Access & Excel, Macros, Pivot Tables, and VBA & Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service (SSIS).
• Excellent presentation skills, and interpersonal; expert at managing multiple projects simultaneously. Experience in working well independently as well as part of a team. Experience working with business users as well as senior management & Excellent oral and written communication skills with ability to communicate with all levels of management and team members. Expertise on onshore-offshore model in IT and business environment.

TECHNICAL SKILLS:

Data Visualization: Tableau, Microsoft Power BI, Business Objects, BO Design Studio, Crystal Reports.

Data Analysis & ETL: SAS Enterprise Miner, Excel, Toad, SAP Business Data Warehouse, HANA

Programming: Advanced SQL & PL/SQL; Familiar with R, Python, VBA, JavaScript, Java, HTML, CSS

Data Analysis: Data Modeling, Data Warehousing, Data Visualization, Data Management, Data Migration, Data conversion, Data Manipulation, Data Mining, Data Cleansing, Data Extraction, Data Validation, Data profiling, Data Lineage, Data lake, Data Wrangling, Data Governance, Metadata Management, Business Analysis, Reporting, Predictive and Statistical Analysis

SAS Data Management: PowerCenter Informatica, SQL Server Integration Services (SSIS), Talend Studio for Data Integration, Oracle Data Integrator (ODI), Cognos Data Manager, Pentaho Data Integration, QlikView Expressor, Ab Initio, Pentaho

SAP Business Intelligence: MicroStrategy, SAS Business Intelligence, TIBCO Spotfire, Microsoft Power BI, Tableau, Oracle BI, QlikView

SQL Server Reporting Services: (SSRS), OLAP and OLTP, Crystal Reports, MS Excel, MS Visio, Sharepoint, SAP Business Objects, Amazon Web Services (AWS), V - lookups, Pivot Tables, SPSS, SSAS, Star Schema, Snowflake Schema, Inmon and Kimball approaches, Git, SVN, Hadoop, Pig, Hive, Spark, Oozie, Flume

PROFESSIONAL EXPERIENCE

Sr. Data Analyst

Confidential - Baltimore, MD

Responsibilities:

• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc. Converted the Objects and Data from the DB2 database to SQL Server Provider inquiry about the status of claims. This involved checking the MMIS claims subsystem to see the status of claims sent and informing the providers if the claims have been suspended / denied or paid.
• Identified the components of the software dat moved data from the source operational systems into the destination data warehouse /data mart. Designing and customizing data models for Data warehouse supporting data from multiple sources on real time & Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Developed the TPL lead structure for policy verification of recipient. Handling ISR jobs for all the interfaces in Third party liability subsystem in the project. Developed and implemented the MMIS Third Party Liability Subsystem.
• Involved in business presentations, reviewing and organizing data, with the halp of Tableau desktop.
• Transformed Waterfall project requirements (CRS) to agile user stories for the claims, member maintenance, and enrolment process. Designed, created, installed and maintained MS Access (VBA/SQL) systems. Wrote VBA code for new applications in Excel and Access to meet changes in business process. Updated VBA code in Access and Excel to meet department needs & Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL). Managed and trained an offshore team to run several MS Access databases.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers. Update and insert new data into SQL server database and PL/SQL Developer. Worked on oracle tools with my concern team. Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance & Created Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database. Gatheird requirements and modelled the data warehouse and the underlying transactional database.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modelling & Developed User Interactive Sheets & Reports as business needs. Writing SQL Scripts to load the relevant Data in QlikView Application.Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.

Data Analyst

Confidential - San Antonio, TX

Responsibilities:

• Integrated various systems with HEDIS and create design for HEDIS and other systems to pull data in HEDIS.
• Participated in HEDIS supplement file formatting to improve data quality for HEDIS.
• Participating in Business Requirement gathering from businesses, stake holders and converting them to Business Requirement Documents (BRD) and performed role of Business Analyst.
• Designed and Developed database for HEDIS and C-and D-Measures including Fact and Dim tables, ETL packages to load data from source to target tables, writing processes for claims, lab, pharmacy, Member Eligibility data from Source system & Design and Developed for HEDIS and C- and D-Measures processes to calculate denominator, numerator and exclusions based on CMS and HEDIS requirement for each measures requirement.
• Participated in URDS project (Re-Write of entire Database on dimensional model design using star-schema model) during initial phase of conception and design. Provided architectural assessment for design consideration (Data Type, Configuration tables, Control tables and Fact and Dimension tables and application use for different teams requirement such as HEDIS, C and D Measures applications)
• Responsible for the creation, maintenance and reporting all HEDIS (healthcare TEMPeffectiveness data and information set) measures for NCQA accreditation Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Worked on complex SQL Queries for performance tuning, space utilization, data integrity and consistency across entire application development. Analyzed existing SSIS package, make changes to improve its performances, add standard logging and configuration system. Carried out SQL Scripting, Transactional Data Analysis and Reporting on MS SQL database. Worked on reporting tool Tableau for Business Partner System dat halps ACG to run ad-hoc reports, so user group can act.
• Gather Business Requirements from the Subject Matter Experts (SMEs) and document the requirements in the BRD.
• Translated high-level business requirements into functional specifications for developers by creating documentation comprising of functional design requirements, test plans and screen level design specifications.
• Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).

Data Analyst

Confidential, NY

Responsibilities:

• Automated MS Excel spreadsheets and converted data into an MS Access database, Pass-Through SQL Queries from MS SQL & Worked with data warehouse concepts for data cleaning, data integration, data transformation and also a periodic data of refreshing.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects dat support the business requirement and process. Involve in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and ETL loading strategy designing. Involved with Data Warehouse team and generated reports using Oracle BI tool.
• Interacted with the project team in understanding the requirements and provided some inputs with required system information. Participated in JAD sessions with business stakeholders to integrate the requirements of the project.
• Analyzed existing Business units, Business process, System/ Application and their Interfaces with their capability through open-ended discussions. Created scheduled and ad-hoc reports for internal and external departments efficiently using Excel and MS Access & Maintained an MS Access (ADO, VBA, SQL, ODBC) Reporting database for tracking sales of individual employees with Daily Stats.
• Completed MS Excel project status reporting tool for updating to MS Access database on intranet & Set up data extracts from MS Access to Excel 2007 to create PivotTables, vlookups and other analysis tools with VBA.
• Work with upper management of medical management department to identify and brainstorm solutions for bottlenecks and errors of ongoing reports. Track current healthcare legislation initiatives for various areas.
• Reviewed state documents (policies, manuals, business processes, systems documents, banners, bulletins) from various divisions. Analyzed and performed quality assurance to determine areas impacted by HIPAA 5010 and ICD 10 related data & Incorporated integration with multiple applications due to Healthcare legislation to introduce the Medicare and Medicaid Plans review. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Validating and manipulating data within Oracle using PL/SQL. Wrote PL/SQL queries to perform Data Analysis.
• Designed and developed complex SQL scripts in SQL server database for creating tables for tableau reporting.
• Utilized corporation developed Agile SDLC methodology used Jira and Microsoft office software to perform required job functions. Maintained Requirement Traceability matrix throughout the project. Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
• Created a thorough Data Analysis document in order to gather the accurate data for the rewrite of the application and also to demolish the bad data. Ran SQL queries to create, modify, delete and update the Oracle database and to analyze the data.

Data Analyst

Confidential - Madison, WI

Responsibilities:

• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• The business design work involved in establishing the reporting layouts for various reports and the frequency of report generation & Identifying the information needs within and across functional areas of the organization.
• Modeling the process in the enterprise wide scenario & Field mapping work involved establishing relationships between the databases Tables, filter criteria, formulas etc., needed for the reports.
• Involved in full Software Development Lifecycle (SDLC) & Responsible for developing, implementing, and testing data migration strategy for overall project in database using SQL 2012 as platform with global resources.
• Developed Informatica mappings and tuning of mappings for better performance
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Created different source definitions to extract data from flat files and relational tables for Data mart.
• Used the dynamic SQL to perform some pre-and post-session task required while performing Extraction, transformation and loading. & Tuned the performance of queries by working intensively over indexes.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions Created, modified, deployed, optimized, and maintained Business Objects Universes using Designer & Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Performed testing and QA role: Developed Test Plan, Test Scenarios and wrote SQL plus Test Scripts for execution on converted data to ensure correct ETL data transformations and controls.
• Done automation of file provisioning process using UNIX, Informatica mappings and Oracle utilities.