SUMMARY

• Dynamic technology professional with more than five (5) years of IT experience, including extensive technical background in DB applications, Data Analysis, ETL Development, Data modeling and warehousing and Systems Administration.
• Strong knowledge of Oracle/SQL Server Architecture, schema, and Transaction management.
• Keen researcher with robust resolution pedigree; utilizing knowledge of relational databases and Business Intelligence models to improve on efficiency and effectiveness of organization’s IT functions towards achieving a goal.
• 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.
• Experience in data scrubbing and cleansing.
• 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.
• Self - motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Used SAS to import and export data from and into Teradata tables. Excellent 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.
• 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.
• Experience in data scrubbing and cleansing.
• 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.
• Experience with DATA MINING.
• 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 and Minitab.
• 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

Databases: MS SQL Server, Oracle, Snowflake

Querying /Programming Language: SQL (PL/SQL, T-SQL), NoSQL, SAS

ETL/Other Tools: SSIS, SAS Base 9.x, Erwin Data Modeler, Alteryx, Jira

Business Intelligence Tools: Tableau, PowerBI, SSRS, Excel, PowerPivot

Operating Systems: Mac, Windows

PROFESSIONAL EXPERIENCE

Confidential - Tampa, FL

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 manipulated 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.
• Analyzed 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.
• Analyzed 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.
• Responsible for developing, analyzing, 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.

Confidential - Princeton NJ

Financial Data Analyst

Responsibilities:

• Utilized SQL to develop stored procedures, views to create result sets to meet varying reporting requirements.
• Built and supported the transformation of various data inputs into the companies Data Warehouse.
• Analyzed and designed solutions create technical integration and consult with QA personnel on their tasks related to the imports and extracts.
• Designed and developed Insurance, Reinsurance, Claims and Financial Reports Using SSRS.
• Identified Data discrepancies and worked with database team to find better solutions.
• Supported business lead for special assignment and to ensure production efficiency.
• Data analysis, reporting using Tableau and SAS.
• 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.
• Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.
• 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.
• 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

Confidential - New Brunswick, NJ

Business/Data Analyst

Responsibilities:

• Provided data architecture and modeling to ensure that data within the Claims Management System (CMR) was in line with compliance guidelines.
• Supported the company’s healthcare software functions, implementation and training.
• Make business recommendations based on data collected to improve business efficiency.
• Collected data from all clients and made recommendations for improvement.
• Ad-hoc data extraction through queries in SQL Server 2008, Excel, SAS, Tableau report or PDF.
• Supported business lead for special assignment and to ensure production efficiency.
• Data analysis, reporting using Tableau and SAS.
• Perform data mapping for different data migration processes
• Inserted checkpoints in Oracle database to check the functionality and data integrity of the AUT.
• Performed ETL data loads from flat files, DB2, Teradata 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