SUMMARY

• Over 5 years experience in data analysis in the finance and Healthcare domains. Very enthusiastic about project and astute wif business requirements; extensive experience in Data Analysis, Data manipulation, Data Extraction.
• Reporting in different formats from various RDBMS sources to make forward looking and prudent decisions to improve outlook of organization.
• Good ability to maintain strategic vision of organization and link it wif everyday work always ready to apply the skills and noledge acquired over the years for the development of organization.
• Possess a high - level of integrity and commitment wif excellent troubleshooting and analytical skills, looking for new opportunities.
• IT professional experience in web- based application development and support.
• Excellent noledge and usage of reporting tools such as Tableau and SAS.
• Experience wif creating Tableau dashboard development visualizations.
• Experience in data Analysis and ETL techniques for loading enormous amounts of data.
• Strong SQL query skills and Database Management expertise.
• Experience wif Data mining, Data migration, Data scrubbing and cleaning.
• 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.
• Used SAS to import and export data from and into Teradata tables, Excellent noledge of Teradata DWH platform including architecture.
• Experience in SQL programming Base SAS programming, Business intelligence, power BI, Tableau, SSRS, Data warehousing /data Modeling (SSIS, Erwin Data Modeler, ER Assistant).
• Excellent noledge and usage of statistical /mathematical analytics software like Stata, SAS and Minitab.
• Possess strong computer and office administration skills wif a vast noledge of Window and Microsoft Office suite (Word, Excel, Power-point, Access and Visio).
• Knowledge of healthcare information systems, experience wif practice management software and HIPPA Guidelines.
• Great understanding of SDLC Methodologies such as waterfall and Agile (specifically SCRUM).
• Experience wif Business intelligence tools
• Proactively reviews requirements and input documents to identify opportunities and implement functionality to improve upon the end user experience.
• Exceptional ability to deepen client relationships by providing a high level of reliable and timely customer centric service.
• Excellent team player wif demonstrated experience of working diplomatically and collaboratively wif all levels of staff to ensure successful implementation of assignments.
• Diverse Technical Background including database development data management and business intelligence.

TECHNICAL SKILLS

Operating Systems: Win XP, Vista 7, window server 2003, 2008(X32, X64) Unix.

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

ETL/Other Tools: Informatic 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, SQL Plus, Teradata SQL Assistant, SQL Developer, Teradata- BTEQ, PL/SQL.

Business Intelligence Tools: Tableau 9.1, 9.2. 9.3, 10.4, Cognos and power-pivot, SSRS.

Programming language: SAS.

PROFESSIONAL EXPERIENCE

Tableau Developer/Data Analyst

Confidential, NJ

Responsibilities:

• Work wif end users, business and IT users to understand, elicit and analyze reporting requirements.
• Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created a whole process of working wif Tableau Desktop and Evaluating Business Requirement.
• Created demos in Tableau and published onto Tableau Server.
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot, Radar).
• Used ETL process to Extract, Transform and load data into stage area and data warehouse.
• Created and updates of several SQL Index, Views, Complex stored procedure, triggers and appropriate User define functions.
• Strong experience using power BI filter, Visual - level filters
• Used different JOINS to match Query
• Used data visualization tools to provide easy to understand interface for end users to quickly identify key themes wifin their data.
• Experience in using different types of DAX functions, Calculate, Filter, Average, Sum.
• Developed SQL queries to extract, manipulate, and /or calculate information to fill data and reporting requirements including identifying tables and columns from which data is extracted. Deployed Tableau Dashboards and worksheets in clustered environment.
• Developed visual reports, dashboards and KPI scorecards using BI desktop.
• Business intelligent tool like tableau and power BI on SQL server mainframe.

Business Analyst/ Data Analyst

Confidential, Wilmington, DE.

Responsibilities:

• Performed required data analysis, interpretation, correction and document presentation for various assignments.
• Performed simple and complex SQL queries, created tables, and generated reports in BO.
• Gatheird Business Requirements by conducting detailed interviews wif business users, stakeholders, and SMEs.
• Designed reports as per client requirement for executive management team.
• Involved in creating conceptual and logical models used to generate physical data models and database schema using the Erwin data Modeler tool
• Used statistical techniques such as regression, cluster analysis, factors analysis, time series, forecasting, experimental and design to solve business problem.
• Prepared project progress reports, status report and submitted to the management.
• Provided BI Analysis for the marketing team to review impact on key metrics in relation to program.
• Analyzed duplicate data or errors in data to provide appropriate inter department communication and monthly reports.
• Wrote queries to fetch data from different table by using JOINs, Sub- queries.

ETL Developer/ SAS Programmer

Confidential, PA 

Responsibilities:

• Created DTS Packages for migration of data between MS SQL Server database and other database like MS Access, MS Excel and Flat Files.
• Used advanced SQL concepts like OLAP, Group By and aggregate functions.
• Used DTS to migrate tables to data warehouse. Handled Different DSS (Decision Support System) for various applications.
• Analyzed SAS code to find causes of errors and revise programs
• Wrote and Maintained documentation of changes to SAS code, programs and specifications.
• Utilized IMPORT and EXPORT features in MS SQL to load data onto data warehouse.
• Converted specification into SAS code to generate datasets and tables, listings, and Figures outputs.
• Revised program for corrections, enhancement, or system environment changes.
• Wrote complex SQL quires to retrieve data from disparate tables utilizing joins, sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server.
• Developed several operational reports using SSRS.
• Modified and maintained SAS programs written by others.
• Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts).
• Created numerous permanent tables, volatile tables and Global Temporary tables.
• Ensured data warehousing design was scalable and maintainable.
• Configured data mapping between Oracle and SQL Server.
• Used Query Analyzer, Execution plan to optimized SQL Queries.
• Created SQL Scripts for demonstrating the prototypes and verifying the result sets.