OBJECTIVE

• Entry - Level Data Analyst, passionate about studying how to improve performance. Seeking to leverage data analytical skills to improve corporate performance as a data analyst. Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats. Able to perform multiple duties in data analysis, ETL development, data modeling and visual analytics leveraging Tableau and SSRS.

TECHNICAL SKILLS

BI Software/ Programming languages: Tableau 9.1, 9.2, 9.3, ETL Developer, SQL, SSAS, SSRS, SSIS, DataStage, Query Analyzer

Database: MS SQL server 2008/2012, Oracle, MySQL, PL/SQL, NO SQL, EMR, MS. Access, MS Excel, Power Point

Operating Systems: MVS, z/OS, windows, android, mac OS

Software Development: Testing and Documentation, Coding, Analysis, Designing, Low Level Design, High Level Design

Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64)

Databases: MS SQL Server 2005/2008/2012 , MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

ETL/Other Tools: SSIS (Visual Studio),SSAS,SSRS, Informatica Power Center 8.6.1/9, SAS Base 9.x, SAS Enterprise Guide, Erwin Data Modeler, ER Assistant

Querying Tools: SQL Management Studio 2008/2013, SQL Plus, SQL Developer, PL/SQL

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, Cognos, Excel and PowerPivot, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Claymont, DE

Tableau Developer/ Data Analyst

Responsibilities:

• Designed and developed Data Warehouse for the Profitability Systems and Reporting group.
• Provided technical support and development to the Reporting group and Profitability Systems. The group leveraged Microsoft's BI tools and Acorn's modeling software to implement accurate models, cubes, and reporting on customer and product profitability for the company's global business operations.
• Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and loaded to staging area and database/Data mart tables.
• Created and executed mapping using Slowly Changing Dimensions Type 2, Slowly Growing Target, and Simple Pass Through.
• Developed ETL framework for processing and monitoring import of flat files in SSIS for key client.
• Created conditional filters and parametrized SSRS reports.
• Enabled clients to align BI initiatives with business goals to facilitate competitiveness and productivity.
• Worked with line managers and end users to gather business requirements and conducted user acceptance.
• Design reports, dashboards and data visualization using Tableau.
• Created tabular reports and deployed over report server to end-users utilizing Tableau dashboards.

Confidential, Boston, MA

ETL Developer/ Data Analyst

Responsibilities:

• Gather information,analyze dataandpresented reports.
• Experience with Centers for Medicare and Medicaid Services, health care providerdataand online datasubmission process.
• Interface with database, data stage ETL and SAS development teams
• Use state-of-the-art decision support andneutralnetwork tools to detect potential fraud and support investigations organizing case files, research violations and accurately and thoroughly document all steps taken in project development
• Used SQL Assistant front-end tool to issue SQL commands matching the business requirementsto run reports fordata on Providers.
• Providedataanalysis support to the fraud investigation team in support of their investigation leads.
• Connected to SQL server sources to create shared data sources in SSRS.
• Created shared data sets in SSRS.
• Created tabular reports and deployed over report server to end-users.
• Troubleshoot client and operational issues timely and appropriately.
• Prepare reports working with database structures and datamodeling including working knowledge of SQL.
• Developed reports on SSRS.
• Kept maintenance and updated healthcare provider databases by using SSIS tools.
• Analyzed healthcare benefits across the board, and generated reports accordingly through the means of SSAS supported tools.
• Perform on a regular basis ad hoc analysis of data sources for all external and internal customers.
• Effectively integrated T-SQL with SQL to write stored procedures.
• Generated database reports, presentation and documentation of analytical methods.
• Conduct self-directed research to uncover problems in Medicare payments made to a variety of provider types including physicians, suppliers, hospitals, and rehabilitation facilities.
• Handle Strong healthcare material including experience with transaction standards (e.g. HIPAA).

Confidential, Northbrook, IL

Data Analyst/ ETL Developer

Responsibilities:

• UtilizedSQL to develop stored procedures, views to create result sets to meet varying reporting requirements.
• Used Visual Studio report builder to design report of varying complexity and maintain system design documents.
• Dataanalysis, reporting using Tableau and SSRS.
• Built and supported the transformation of variousdatainputs into the companiesDataWarehouse.
• Analyzedanddesigned solutions, createtechnicalintegration andconsult withQA personnelontheir tasks related to the imports and extracts.
• Designed and developed Insurance, Reinsurance, Claims and Financial Reports Using SSRS.
• IdentifiedDatadiscrepancies and worked withdatabase team to find better solutions.