SUMMARY

• 3+ years of extensive experience in the field of Healthcare Data Analyst working with the technical staff to implement management and staff's business requirements into the software application in Healthcare Industry.
• Good understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile .
• Experience designing and developing SQL statements and queries for Oracle and SQL Server database.
• Excellent Knowledge in Electronic Medical Record ( EMR ) / Electronic Health Records ( EHR ) modules and process flow.
• Developed reports using SQL Server Reporting Services ( SSRS ).
• Expertise in broad range of technologies, including business process tools such as Confidential Project, Primavera, Promodel, MS Excel, MS Access, MS Visio , technical assessment tools, Data Warehousing concepts and web design and development.
• Experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and validation of data across all the integration points.
• Experience in using Informatica Metadata Manager to perform data lineage.
• Experience in using R for the predictive modelling and data visualization by using MySQL database and text files as source.
• Experience in creating visualizations using Python .
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Mastered ability to Preparing dashboards using calculated fields, parameters, calculations, groups, sets, hierarchies, advanced functions like Level of Detail (LOD) Expressions, and Localization in Tableau.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Programming Languages: Python, R, SQL

Reporting Tools: MS PowerPoint, SSRS Google Analytics, MS Office

Databases: SQL Server, Oracle, MS Access

ETL Tools: SSRS, SSIS, SSAS, Informatica

Python libraries: NumPy, Pandas, Matplotlib

Methodologies: SDLC, Agile, Waterfall, Scrum

Operating Systems: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential, IN

Data Analyst

Responsibilities:

• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Implemented an MDM process to take strategy to roadmap and design development activities. Delivered MDM roadmap & MDM Architecture.
• Analysed and document business and functional requirements via uses cases for Medicare billing transaction - based middleware/database layers with SOA & XML.
• Created Teradata Tables, Views and Stored Procedures for loading the data from Oracle to DW.
• Extensively used SQL procedures in SAS for creating SAS datasets and generating reports using them when Teradata was offline for maintenance.
• Designed and developed Sub-reports, Drill-down reports, Matrix and Summary reports in SSRS .
• Used Python NumPy, SciPy, Pandas packages to perform dataset manipulation.
• Data cleansing, Exploratory analysis, Explanatory Analysis and Data Visualization using Python to extract relevant by using Data Modeling, Data Warehousing, and ETL concepts.
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Reported and analysed all application defects, user issues and resolution status to the higher manager using Mercury Test Director.

Confidential

Data Analyst

Responsibilities:

• Formulated procedures for data extraction, transformation and integration of health care data.
• Conducted assessment to ensure data quality and completeness with validation techniques.
• Assisted in designing and development of health-related analytical products for overall enterprise.
• Provided assistance for quantitative data analysis with health care, biometric and survey data.
• Designed and developed continuous outcomes reporting for multiple intervention programs.
• Coordinated with technical teams for research and evaluation of healthcare and operational problem.
• Participated in critical review and revision of existing systems for updates and enhancements.
• Supported technical teams for development and execution of supplemental analytical tools and methods. Conducted independent statistical analysis, descriptive analysis, hypothesis testing and logistic regression.
• Provided assistance for health care projects through SAS statistical and analysis software tools.
• Assisted in development of data formatting and cleaning criteria from various data sources.
• Generated database reports, presentation and documentation of analytical methods.
• Performed ad hoc analysis of data sources for all external and internal customers.
• Coordinated with clients for management of data mining and recovery projects.
• Supported technical team members for technologies such as SSAS, Confidential Excel and SQL server.
• Participated in refinement and technical documentation of database reporting requirements.