SUMMARY:

• An IT professional with over six (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. 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 in multicultural environment.
• Excellent knowledge in usage of reporting tools such as Tableau and Power BI.
• Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
• Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
• Identified issues when reports are created from several and complex data sources.
• Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snow-Flake, Fact and Dimension Table, Physical and Logical Data Modeling using ERwin 3.x/4. x.
• Excellent knowledge and usage of statistical/mathematical analytics software like Stata, SPSS, SAS and Minitab.
• Used SAS to import and export data from and into Teradata tables. Good working knowledge of Teradata DWH platform including architecture.
• 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.
• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Good knowledge of portfolio analysis, management and customer segmentation.
• 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.
• Self-motivated individual with strong communication skills, great attention to details and the ability to work and deliver under pressure.

TECHNICAL SKILLS:

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

Databases: MS SQL Server 2005/2008/2012, 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, Informatica.

Querying Tools: SQL Management Studio 2008/2012, SQL Plus, SQL Developer, BTEQ, PL/SQL.

Querying language: SQL, TSQL.

Business Intelligence: Tableau 9.1, 9.2, 9.3, 10.2, MicroStrategy, Power BI, Excel and PowerPivot and SSRS.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Tableau Developer/ Analyst

Responsibilities:

• Designed, developed, tested and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich graphical visualizations with Drill Down and Drop-down menu option and parameters using Tableau.
• Extensively involved in creating graphs, Line Charts, Trends etc, by using measures and dimensions data from various databases by using data blending concept.
• Converted existing BO reports to tableau dashboards.
• Generated various KPI using calculated key figures and parameters as Business demands.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographical map, Pie Charts and Bar charts as deliverables.
• Worked extensively with Advanced analysis like Actions, Calculations, Parameters, Background images, Maps, Trend lines, Forecasts, Statistics and Table Calculations.
• Provided Production support to Tableau users and wrote custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with business users.
• Created dual-axis charts with multiple measures and synchronizes the axis.
• Responsible for creating calculated fields, combined field, bins, set, geo coding and hierarchies using Tableau Desktop.
• Implemented data blending to blend related data from different data sources with variations in Data Granularity.

Confidential, Laurel, MD.

Job Title: Senior Data Analyst.

Responsibilities:

• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• Configured the Data mapping between Oracle and SQL Server.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Use SQL High for level proficiency in database manipulation.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets.
• 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 SQL server platform.
• Work with ETL Process which includes SSAS, SSIS, and SSRS. Worked with Business Intelligent tools like Tableau and Power BI to Visualize Data intuitively, also worked with SQL server mainframe.
• Developed stored procedures, views, triggers, execute test cases and defect management for ETL and BI systems.
• Responsible for error handling, stored procedure, creating tables, views, triggers etc.

Confidential, New York, NY

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 training 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 need.