PROFESSIONAL PROFILE:

• An IT professional with over Eight (8) years’ experience in various domains such as Finance, Insurance, and Healthcare.
• An enthusiastic individual with extensive experience in Business Intelligence, Data Analysis, Tableau Developer, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources.
• Proven ability to learn, utilize in - house databases and systems to maintain strategic vision of the organization and link it with everyday work.
• Able to perform 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.
• Hands on experience in business process engineering and all phases of software development life cycle such as Waterfall and Agile (specifically SCRUM) involving Requirement analysis, Software design, development, implementation, testing, maintenance and Object-Oriented Design (UML).
• Experience in writing and testing SQL and PL/SQL statements, Stored Procedures, Functions, Triggers and packages.
• Excellent knowledge and usage of reporting tools such as Tableau, SAS, MicroStrategy and Power BI
• Ms-Business Intelligence experience using SQL Server Reporting Services(SSRS),SQL Server Integration Services(SSIS) and SQL Server Analysis Server (SSAS).
• Expert in ETL-Extraction Transformation loading, data warehousing, operational data store concept, data marts and OLAP- Online Analytical processing technologies.
• Deliver high quality code to realize business requirements, with an eye on keeping technical debt low and test coverage high. Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications .
• Experience in DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modelling experience using Dimensional Data Modelling, Star Schema, Snow-Flake, Fact and Dimension Table, Physical and Logical Data Modelling using Erwin 3.x/4.x.
• Experience in DATA MINING, scrubbing, and cleansing.
• Working experience and knowledge in creating tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Hands on Experience in development of Reports and Dashboard in Tableau. Experience with the design and development of Tableau visualization solutions.
• Created Parameters to achieve desired functionality and create risk metric analysis by co-ordinating with users.
• Experience in designing, publishing and presenting customized interactive dashboards in Tableau using Marks, Action, filters, parameter and calculations.
• 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.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, geographical maps, Gantt charts using show me functionality.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Possess strong computer and office administration skill with a vast knowledge of Windows and Microsoft office Suite (Word, Excel, PowerPoint, Access, and Visio).
• Knowledge of healthcare information systems, experience with Practice Management software and HIPAA Guidelines.
• An excellent team player with fast learning curve, strong analytical, problem solving, communication and interpersonal skills to work under time constraints and has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

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: 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, Excel and PowerPivot, SSRS

Programming language: SAS, TSQL, PL: SQL

WORK EXPERIENCE:

Confidential, Mars, PA

Senior, Data Analyst / Tableau Developer

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 and Oracle database.
• Created Tableau scorecards and dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• 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
• Provided data architecture and modeling to ensure that data within the Claims Management System (CMR) was in line with compliance guidelines.
• Perform data mapping for the process
• Performed ETL data loads from files, DB2, Teradata, PL/SQL etc. to transform data into complex scripts and codes for software application testing
• Enhanced the PL/SQL test scripts for data driven tests
• Developed and executed automated test case scripts Test for the Front-end applications
• Converted user requirements into business requirements, analyzed the same, and segregated them into high level and low-level business requirements
• Created User Interface Specifications and wire frames.
• Use advanced SQL concepts like OLAP, Group By and aggregate functions
• Use complex SQL queries in advance to fetch data from other tools.
• Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on Teradata platform.

Confidential, Pittsburgh, PA

Data Reporting / Tableau Developer

Responsibilities:

• Created SQL stored procedures using SQL Query
• Prepare reports working with database structures and data modeling including working knowledge of SQL.
• Handle Strong healthcare material including experience with transaction standards (e.g. HIPAA.
• Conduct self-directed research to uncover problems in Medicare payments made to a variety of provider types including physicians, suppliers, hospital, and rehabilitation facilities.
• Gathered Information, analyzed reports and presented reports.
• Experience with Centers for Medicare and Medicaid Services, health care provider data and online data submission process.
• 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.
• Provide data analysis support to the fraud investigation team in support of their investigation leads.
• Created, organized, customized analysis and visualized projects and Tableau dashboards to present to Senior Level Executives.
• Provided support for Tableau for various end users.
• 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.
• Executed Ad hoc reporting requirement team.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Confidential, Fairless Hills, PA

Tableau Developer, Data Analyst

Responsibilities:

• 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 used concepts like Explain, Stats, Cast and volatile tables on SQL server
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• 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 develop 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.
• 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.
• 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 statistical techniques such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design, etc. to solve business problems.
• Used SAS to solve problems with data and analytics.