SUMMARY

• An IT professional with over 6+ years’ experience in various domains such as Finance, Insurance, Retail and Healthcare.
• An enthusiastic individual with extensive experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources.
• A wonderful team player who can relate and work efficiently with diverse groups.
• Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
• Skilled in using SAS statistical procedures like PROC Report, PROC TABULATE, PROC CORR, PROC ANOVA, PROC MEANS, PROC TTEST, PROC FREQ, PROC UNIVARIATE, and PROC LOGISTIC.
• Hands on experience in SAS programming for extracting data from Flat files,Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks.
• Strong ability to write SQL queries using PROC SQL.
• 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.

TECHNICAL SKILLS

Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix

Databases: MS SQL Server 2005/2008/2012 , Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

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

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata - BTEQ, PL/SQL,SAS

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, 10.4, Cognos, Excel and PowerPivot, SSRS

PROFESSIONAL EXPERIENCE

Data Analyst /Tableau Developer

Responsibilities:

• Pulling data from TriZeto claims systems to create operational reports for applications.
• Creating adhoc queries, stored procedures, and programming scripts with SQL.
• Utilizing SISS for ETL data modeling, data migration, integration, and analysis.
• Prepare high level analysis reports with SSRS, Tableau and Excel.
• Supporting data profiling activities.
• Creating Tableau dashboard for displaying monthly inventory analysis.
• Supporting logical data designs/models by reviewing with Business stewards.
• Working with member eligibility data, demographic data, claims (Medical, Dental, Pharmacy) data, premiums data by pulling from data warehouse and generating day-to-day reports in support of the Actuarial Finance department for pricing, catastrophic actuarial analysis and other purposes.
• Creating source to target mapping at the element level including specifications for data integrity, referential integrity in support of the Actuarial Finance Systems.
• Use data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their Data

Confidential | Philadelphia, PA

Data Analyst/Tableau developer

Responsibilities:

• Develop Tableau visualizations and dashboards using Tableau Desktop.
• Used Tableau server as a front-end BI tool and MS SQL Server 2012 as a back-end database to design and develop workbooks, dashboards, global filter page, and complex parameters-based calculations.
• Working with team of developers, designed and implemented a BI solution for Sales, Product and Customer KPIs.
• Create compelling dashboards using tableau dashboard and prepare user stories to deliver actionable insights.
• Connect Tableau server to publish dashboard to a central location for portal integration.
• Implement Tableau mobile dashboards via Tableau mobile application.
• Involve in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau.
• Develop Tableau workbooks from numerous data sources using Data Blending.

Confidential | Bethesda, MD

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)