Data Analyst Resume

SUMMARY:

Experienced Business and Data Analytics professional with a unique combination of technical skills, business experience and a well - rounded educational foundation. I am currently deeply involved in the successful transformation of a leading insurance company’s legacy tax, accounting and financial processes to a centralized system.

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Master Data Governance - Design and manage process to load data from SAP MDG into SQL Server Datamart via SSIS ETL
Develop reports, and BI metrics and visualization for various year-end, and ad-hoc reconciliation processes
Lead ETL analysis process from Legacy Tax Data to conversion to Appian/Tax Stream and Cognos reporting
Verify conversion data, and Cognos reports
UAT Tax system upgrades and implementation

Confidential

Consultant - QA/Report Analyst

As part of UAT Testing for a SAP FS-RI implementation, created “Expected Results” in a MS Access database to mirror re-insurance business rules
Successfully identified configuration and data-entry issues with test data, contributing to the timely completion of project implementation
Monthly and Ad-hoc reports using VBA in Access and Excel

Confidential

Pre-Sale Engineer

Pre-sale and Technical support for Business Intelligence dashboard and reporting product
Define data source physical layer, to logical model, through the final presentation layer. Design and build custom reports based on specifications gathered from customers
Consult with customer to generate KPI dashboards based on key metrics

Confidential

System Analyst

Designed new reconciliation process to reconcile General Ledger, Project Costing, Supply Chain, and other legacy feeder systems. Identified critical tables and fields, model and transform data to suit new environment
Provide data structure for year-end property tax filing by gathering relevant data and transforming into the correct format for individual state filings
Maintain PEOPLESOFT tables; create queries and reports to meet customers' business requirements

Confidential

System Analyst

Responsible for maintaining the integrity of Asset, Project Management, GL modules that span the Eastern U.S. seaboard states, with approximately 80 million records, and an Asset base of $100 Billion
Understand and system flows, and business rules. Perform functional design, write system and requirement specifications
Maintain PEOPLESOFT tables, create queries and reports to meet customers' business requirements