SUMMARY

• An enthusiastic IT professional with Six (6) years extensive experience in Data Analysis, Data Extraction, Data Manipulation, Research and Reporting in different Visualization formats and from various sources.
• Seeking to utilize my skills, abilities, teamwork, and excellent organizational and problem - solving skills to achieve growth.
• Able to perform data analysis with proficient knowledge in statistics, mathematics, and analytics.
• Extremely passionate and focused on task and results driven.
• Performing multiple duties in business analysis, project or program management, and functional leadership.
• A wonderful team player who can relate and work efficiently with diverse groups.
• Proven ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and link it with everyday work.
• Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
• Experience with DATA MINING.
• Identified issues when reports are created from several and complex data sources.
• Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
• Strong ability to write SQL queries using PROC SQL.
• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
• Excellent knowledge and usage of reporting tools such as Tableau and SAS.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Exceptional organizational and time management skills and the ability to work independently.
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.
• Excellent knowledge and usage of reporting tools such as Tableau, SAS and PowerBI.
• Good knowledge of portfolio analysis, wealth management, customer segmentation, ICD code, CPT code, HIPAA regulations, and Healthcare terminologies.
• Strong ability to write SQL queries using PROC SQL.
• Experience in data scrubbing and cleansing.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2012/2014/2016 , Oracle 9i, 10g, 11g

ETL/Other Tools: SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant

Querying Tools: SQL Server Management Studio 2008/2012/2014/2016 , SQL Developer

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, 10.2, 10.4, Excel and PowerPivot, PowerBI

PROFESSIONAL EXPERIENCE

Confidential

Data/Business Analyst

Responsibilities:

• Work with end users, business, and IT users to understand, elicit and analyze reporting requirements.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Experience in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers, and appropriate User defined functions.
• Manages platform admin functionalities including installations/configuration, upgrades, patches, change management, performance tuning, standards/ best practices, mentoring, metadata management, cluster/distributed management, cache/ history management, user management, scheduling.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Performed Tableau type conversion functions when connected to relational and SAP BW data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.

Confidential

Data Analyst

Responsibilities:

• Gather information, analyze data, and presented reports.
• Experience with Centers for Medicare and Medicaid Services, health care provider data and online data submission process.
• Interface with database, data stage ETL and SAS development teams
• Use state-of-the-art decision support and neutral network tools to detect potential fraud and support investigations organizing case files, research violations and accurately and thoroughly document all steps taken in project development
• Used SQL Assistant front-end tool to issue SQL commands matching the business requirements to run reports for data on Providers.
• Provide data analysis support to the fraud investigation team in support of their investigation leads.
• Created tabular reports and deployed over report server to end-users.
• Troubleshoot client and operational issues timely and appropriately.
• Prepare reports working with database structures and data modeling including working knowledge of SQL.
• Perform on a regular basis ad hoc analysis of data sources for all external and internal customers.
• Generated database reports, presentation, and documentation of analytical methods.
• Conduct self-directed research to uncover problems in Medicare payments made to a variety of provider types including physicians, suppliers, hospital, and rehabilitation facilities.
• Handle Strong healthcare material including experience with transaction standards (e.g. HIPAA).

Confidential

Data Analyst/SAS Programmer

Responsibilities:

• Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub-queries and derived tables on SQL Server platform.
• Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST, and volatile tables.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
• Used SAS to import and export data from and into SQL Server tables.
• Planned, analyzed, and designed Universes using SAP Business Objects as per Business needs.
• Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and provides a 360 view of what is going on.
• Created numerous permanent tables, Volatile tables, and Global Temporary tables.
• Developed dashboards in Tableau Desktop and published them in Tableau Server.
• Fulfilled numerous data requests for financial profiling.
• Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2014 Reports Services (SSRS)