Data Analyst Resume Miami, FL - Hire IT People

SUMMARY:

Experience in performing Business Data Analytics, Business Intelligence, Statistical Analysis and Reporting.
Overall understanding of dynamics of Operations, Finance, Accounting, Sales, Marketing, and Technology.
Experience in SQL Server, Databases/RDBMS, ERP (SAP), programming, Access, MySQL, Tableau.
Experienced in performing data analysis in MS Excel, primarily VLookup, Pivot tables, Functions, regression analysis.
Problem solver with very high ability of Analytical and Quantitative skills.
Ability to program and build models.
Can work equally well in teams or individually. Good communication skills and a fast learner.
Detail oriented and able to deliver quality work on time. Able to prioritize and multi - task.
Ability to think at varying levels, from high-level concepts (conceptualize/design) to low-level details (programming)
Possess MBA and MS Finance from AACSB accredited universities in the US. Electrical Engineer from IIT, India.

SKILL:

Modelling: Data, Workflow and ER diagrams, databases, statistical/financial modelling.

Databases/RDBMS: SQL Server, Sybase, Access, MySQL

Data Tools:: Tableau, Excel, Alteryx, Trifacta, Google Refine

ERP: SAP ECC 6.0, MM, FI/CO, BI/BW, SD

Languages: C, SQL, T-SQL, HTML, PHP, Perl/CGI, Java, R, Python

Misc.: Visio, Project, Crystal reports, SPSS, Microsoft Excel, Excel, V-Lookup, Pivot, Word, PowerPoint, Access, Lotus.

PROFESSIONAL EXPERIENCE:

Data Analyst

Confidential, Miami, FL

Responsibilities:

Analyzed the PCR (Program Contents Right) process workflow to seek opportunities for improvement.
Analyzed discrepancies in SAP financial data and compare with data from Landmark program scheduling system.
Tested the SAP system for errors and inconsistencies by creating test scenarios and troubleshooting.
Liaised with SAP, Finance, IT and Informatica (middleware) team to find the root causes, planning fixes and testing.
Verified the integrity and accuracy of accounting data so that it is ready for reconciliation and closing.
Developed and Exceptions database to integrate data from other regions in future, using SQL Server, Access.
Cleansed and prepped data for integrity, loading. Created data relations, developing SQL queries and testing.
Building exception reports and data visualizations in Tableau for Management and accountants.

Data Analyst

Confidential, Miramar, FL

Responsibilities:

Providing analysis and reporting to support Fraud Prevention in Medicare and Medicaid for US Govt.
Wrote SQL queries to extract data in SAS. Created reports in Business Objects for management oversight.
Performed statistical analysis on data and compiled information for investigators and law enforcement.
Presented data to upper level management using graphs, charts, pivot tables and dashboards.
Experience with querying and analyzing SDOH Data for Beneficiaries and Registration data for providers.
Search for fraudulent providers and beneficiaries on Fraud Prevention System based on given criteria.

SAP Data Analyst

Confidential

Responsibilities:

Provided ERP support and ensured the timely resolution of SAP MM Issues/Tickets
Analyzed data for critical issues, performed root cause analysis and proposed the preventive actions.
Defined, configured, implemented/enhanced and tested business processes related to SAP.
Performed data analysis in MS Excel, primarily VLookup, Pivot tables, Functions and advanced analysis.
Wrote SQL queries to extract data and create reports in Business Objects
Checked data for integrity and accuracy. Created pivot tables in Excel to analyze data.

SAP Data Analyst

Confidential

Responsibilities:

Worked on multi-million dollars project which involved rollout of SAP projects in Japan and China.
Analyzed data and built SQL queries on Infocubes and reports using Bex Tools in SAP BW.
Created and enhanced Business Process Procedures in SAP ERP System.
Performed Gap Analysis, validated BPML (Business Process Master List) for various SAP modules.
Developed testing scripts, performed Unit and integration testing.
Assisted in UAT testing before Go Live.

SAP MM Consultant Support & Maintenance

Confidential

Responsibilities:

Provided after-hours emergency support as part of major incident management, during the period of system failure.
Managed the critical issues, performed root cause analysis and suggested the preventive actions.
Managed and analyzed the change requests and Issues, as well as process optimization.
Coordinated with key users to perform testing for all business scenarios.
Collaborated with business users & managers for process improvement.
Prepared functional specifications for customized reports and transactions.
Updated the PMO and project managers about project status and issues that may impact client relations.