SUMMARY:

• A highly driven and dynamic IT professional with 7+ years of IT experience in the Healthcare, Financial, and Banking domain. Experienced in Data Analysis, Research and Reporting in different Visualization formats and from various sources. Very passionate about projects and savvy with business requirements A great team player, who can relate and work efficiently with diverse groups, and always ready to leverage the skills and knowledge acquired over the years for the development and progress of the organization and to maintain strategic vision of the organization and link it with everyday work.
• 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, SAS, Microstrategy and PowerBI.
• Experience in Data Munging (data scrubbing and cleansing).
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Frequent update and exposure to new technologies and new business lines.
• Epic Care System - Inpatient (ClinDoc, CPOE, Beacon, Optime, Him, Homehealth, Stork), Ambulatory (CPOE, Beacon), Cerner Millennium, Sorian, McKesson, Meditech, Allscript.
• Excellent knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
• Excellent knowledge of portfolio analysis, wealth management, customer segmentation, ICD code, CPT code and Healthcare terminologies.
• Skilled in using SAS statistical procedures like PROC Report, PROC TABULATE, PROC CORR, PROC ANOVA, PROC MEANS, PROC TEST, PROC FREQ, PROC UNIVARIATE, and PROC LOGISTIC.
• 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 professionally and collaboratively with all levels of staff to ensure successful implementation of assignments.
• Excellent interpersonal skills, strong adaptability to change in a fast-paced environment.

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

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

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, 10.2, 10.4, 10.5, Microstrategy, Excel and PowerPivot, PowerBI, SSRS, SAS, Crystal Report

PROFESSIONAL EXPERIENCE:

Tableau Developer & Analyst (Contractor)

Confidential, New York

Roles & Responsibilities:

• Use data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their Data
• Designing the Reports as per client Requirement and created the reports using Excel file, SQL Server and Oracle databases.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Utilize SAS, and other software, to provide ad hoc reporting, tables and listings and graphs for clinical trials data, regulatory submissions, Risk Based Monitoring, and publications
• Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary reports and dashboards using KPI's
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created demos in Tableau Desktop and published onto Tableau Server.
• Produced Logical Data Models/Physical Data Models.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Documented a whole process of working with Tableau Desktop and evaluating Business Requirements.
• Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering with Erwin tool.
• Interacted on a day to day basis with several different groups to achieve a common deliverable.
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.
• Hands on experience to extract, manipulate and built complex formulas in Tableau for various business calculations.
• Involved in resolving reporting issues and design issues throughout the reporting life cycle.
• Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Ensured all project requirements and objectives are properly documented and pursued.
• Created conditional filters to filter the data on dashboard.
• Creating Parameters for desired functionality.
• Responsible for developing, analysing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
• Work with client and team members to understand and clarify visualization requirements
• Written complex SQL queries and optimized queries for performance tuning.

Tableau Developer, Data Analyst (Contractor)

Confidential, New York

Roles & Responsibilities:

• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Created Views and Database Triggers, Stored Procedures and Functions using SQL such that information entered by a certain WM can make appropriate changes to the respective tables.
• Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
• Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and also used concepts like Explain, Stats, Cast and volatile tables on SQL server
• Analysed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
• Experienced in Data mapping, Data transformation between sources to target data models.
• Analysed reporting requirements and developed various Dashboards.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
• Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Used SAS to solve problems with data and analytics.
• Reviewed coding done to SAS and Python application upgrades and extensions.
• Used statistical techniques such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design, etc. to solve business problems.

Data Analyst/Modeler

Confidential

Responsibilities:

• Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
• Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.
• Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Cast, CTE’s and table expressions against SQL server database and oracle.
• Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
• Utilize SAS, and other software, to provide ad hoc reporting, tables and listings and graphs for claims data, regulatory submissions, Risk Based Monitoring, and publications
• Developed and deployed reports to provide operational and analytical information to administration, interpret data, analyze results, and construct ongoing reports by using SAS.
• Developed queries to retrieve and analyze data from various sources for projects, program, or reports . Work with vendors for evaluation of data reporting enhancement.
• Developed, validated, published, and maintained LOGICAL and PHYSICAL data models using Erwin Data Modeler.
• Evaluated existing data models and physical databases for variances and discrepancies
• Served as the business modeler / data analyst for data projects and initiatives, created conceptual and logical business models used to generate physical data models and database schema using the Erwin Data Modeler tool.
• Developed several operational reports using SSRS.
• Utilized IMPORT and EXPORT features in MS SQL to load data onto the data warehouse
• Created numerous Permanent tables, Volatile tables and Global Temporary tables
• Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)
• Ensured that data warehousing design was scalable and maintainable
• Utilizing tableau for visual analytics and dashboard developments
• Ability to comprehend the details of complex system software

Confidential, Arizona

Epic Inpatient Support - Inpatient

• Helped nurses navigate patient encounter for documentation in Doc flow sheets and helping them access their work list and add task when needed.
• Providing assistance in trouble-shooting issues on the MAR having error in data accumulation with input and out of medication recordings.
• Assisting physicians and nurses through hyperspace navigation, using Smart Tools, specialty workflows, and creating preference lists.
• Assisting nurses navigate through the workflow process of looking and charting patients, opening and closing of encounters.
• Assisting physicians with smart tools (creating smart phrases and identifying appropriate smart links for their progress notes).

Confidential, New York.

Epic Inpatient

• Assisted physicians with reconciling medication list, print medication script, creating favorites, setting up dictation access, creating daily and weekly patients list, creating orders, setting up order sets, staging and adjusting therapy plans, changing medication dosages for particular therapy plans and managing their In-basket.
• Assisted providers with Dragon Medical Version 10.1 to create documentation efficiency.
• Assist nurses with checking up and documenting patient vitals, labs and reviewing orders entered by the physicians; Also helping the physicians with CPOE, and medication reconciliation for admissions and discharges.