Post Job Free

Resume

Sign in

Data Analyst, MS Excel

Location:
Teaneck, NJ
Posted:
August 09, 2016

Contact this candidate

Resume:

Stephen Bernard

Summary:

**+ Yrs. Experience in Business and Finance systems, and data analytics.

Business Systems / Data Analyst with over 10 years of experience, supporting Finance and Accounting, Sales and Marketing, Logistics and HR functions.

Experienced in design and development of reporting applications and dashboards for supporting the business analysis and corporate wide reporting.

Data Driven Analyst highly effective in dynamic, large-scale system environments.

In-depth knowledge of Integrated Reporting Information System (IRIS).

Strong ETL (System Interfaces / Data transformation) design and development skills.

Proficient in writing and modifying existing SQL syntax using MySQL, SQL Server, MS Query, or MS Access

Experienced in using Advanced Microsoft Excel / Access techniques for the purpose of data Extraction from various data sources, Transformation by applying advanced data manipulation, cleansing or data mapping rules and Loading into other databases (direct or thru creating compliant load files) or creating Reports (pivot tables/graphs).

Experienced in administering and providing technical support on Global Applications.

Education:

BS Information Technology, Colorado Technical University, Colorado Springs, CO, 2017(Pursuing)

Skills:

SAP Business Warehouse, SAP BEX Query Designer, SAP Business Objects, Business Objects, Dashboard Designer (Xcelsius), SQL, Microsoft Excel / Access / Modeling and Application Development, Hyperion Enterprise, Essbase, Cognos / Crystal Reporting, Microsoft PowerPoint / Visio/Word, Salesforce.com

Experience:

A1 Analytics LLC. (Data and Systems)\Consulting Services Jan 2014 – Present

Office Depot Corp. Boca Raton, FL / Help Assist, LLC.

Sunrise, FL / Tech Link Shoppers, Miami, FL

Data Analyst

Responsibilities:

Extracting and Transformation large amounts of data using Microsoft Excel / Access while understanding related object/field functions for the purpose of providing Sales Team with adhoc reporting/analytical needs and loading data into Third-Party Systems.

Create and maintain documentation on processes, application configuration, and training material for users.

Regularly perform database de-duping and cleanup procedures in Microsoft Excel / Access. Ensure data quality through clean- up efforts (monthly reporting, lead clean up, etc)

Created new and modified existing complex SQL join queries to develop Microsoft Excel / Access Reports and Analytical workbooks for the purpose of identifying and understanding program exceptions (Merchandising user setups issues vs. systematic), identify trends and fix exceptions

Enhance existing daily audit report to include key fields using Vlookups to Master data tables for Product descriptions and groupings, and created an index of exceptions using error codes as key fields to summarize audit report in pivot table format. Enhancement increased the rate of identifying and fixing errors.

Provide deep diving data analysis using SQL queries data dumps into MS Excel of findings to other Analyst and Managers to help team understand exceptions root cause in product setup in source systems (Office Depot Oracle/Mainframe versus OfficeMax SAP).

Designed and developed Microsoft Excel / Access Solutions (Business Process and Reporting) for business users.

Interfaced solutions created with their existing POS system Microsoft Dynamic RMS system.

Created for Company Owners and Business Managers Retail Sales and Drop shipment Order Reporting to track performance daily, weekly, month to date and year to date, help better manage in house inventory levels, and assist in business forecasting activities.

Eastman Kodak, Rochester, NY Dec 2008 – Dec2013

Business Systems Analyst

Responsibilities:

Used Microsoft Excel / Access advanced techniques for data analytical tasks such as data cleansing, data validation, data modeling, automation of extraction using MS Query, ODBC links to source data or Bex Query for SAP BW extracts, transformation of data by applying similar rules to ETL Processes, data preparation for loading 3rd party databases, visualization/dashboard reports (Xcelsius), pivot table reports.

Synchronizing and Centralizing Master Data Management (MDM).

Worked on project teams to deliver New / Enhancement DataWarehouse (DW) Applications Analytical Tools / Reporting Solutions and ETL components.

Successfully worked in all phases of the Solution Development Life Cycle (SDLC) on various DW Apps projects which include SAP Business Objects BI Reporting and Analysis Tools, SAP BW Applications and SAP Bex Reporting.

Worked on various Datawarehouse initiatives by providing needed information from either DW or offline data stores.

ETL and Data Transformation processing efficiency.

Elimination of Redundant data by understanding business needs and consolidating overlapping data requirements, educating business users to existing reporting structures and making enhancements to data structures and reports to meet the business present informational needs.

Provide data analysis during Requirements/Design phase that impact scope and delivery.

Data modeling, proof of concept in identifying where required data resides.

Utilization of existing data structures with the addition of requested calculated key fields.

Creation of new structures which support existing business needs versus future needs or cross functional data needs.

Provide system analysis to translate business requirements into Functional Requirements document.

Creating requirements for functional improvements and enhancements detailing process or data flows, business rules, models, and database schema.

Migration of impacted objects into Production environments, schedule data loads to populate new data targets, generate reports and final output for verification.

Financial Systems Analyst, Stamford, CT Jun 2000 – Nov 2008

Kodak Polychrome Graphics

Responsibilities

Global Hyperion System Administrator, Finance Intranet (Sharepoint) Administrator

Interfaced with broad range of business users to gather functional requirements, and analyzed requirements to produce specifications for various systems enhancement work and reporting request.

Designed and developed various financial reporting applications, data marts and Sharepoint report distribution systems for financial services, marketing and manufacturing managers.

Provided data analysis and created analytical tools, and Financial and Business Models using advanced MS Access (ODBC, VBA) and MS Excel (ODBC, VBA, pivot tables, pivot charts) and transforming SQL system extracts.

Global Implementation and Administration of Hyperion Enterprise Financial Consolidation and Reporting System. Reduced organizational operating costs 10% by streamlining Financial Closing processes and reducing the number of closing days from 5 working days down to 2 days.

Worked with Corporate Controller, Regional Finance Directors, and Hyperion consultants to produce business requirements and technical specifications.

Identified "bottlenecks" and implemented new and improved processes and policies.

Global Chart of Accounts: Used to align Region/Country Ledger Owners with Corporate Finance.

Global GL Account to Hyperion Consolidation System Mapping: Streamlined the monthly submission of local General Ledger (GL) results and Corporate Consolidation process as well as reduced errors in translation to Global COA.

Performed Hyperion Enterprise system Design/Build

Hyperion Structures (Hierarchy, Entity and Chart of account, and Data Views (Actual/Forecast/Budget/Annualized)

Consolidation logic / special calculations

User system security (allowing users to view/modify authorization based on their roles)

Reports (Variance Analysis/Reports for Legal and Management P&L/B/S, Detailed Operating Expense, and Supplemental (Statistical) Data

Design and Develop additional tools to streamline financial data submission from source system GL and supplemental data to Corporate Hyperion Enterprise Consolidation system.

Design / developed system interface SOURCE: Local country GL (CODA and Great Plains) TARGET: Corporate Hyperion Enterprise Consolidation system, using advanced MS Access (ODBC, VBA). Output from interface was a text file data feed for loading into Hyperion system.

Design / developed Data Input template to capture Key metrics and statistical data for Country GL finance members using Advanced MS Excel (VBA, Pivot Tables). Output was a text file data feed for loading into Hyperion system.

Interface was distributed to all country general ledger owners for submission of their month end closing for financial consolidation and management reporting at local country, region, and global levels.

The tools created increased level of detail visibility in the consolidation process and reporting and it reduced the data submission process by changing process from manual data input into a systematic solution.

Travelled to each region HQ (Europe - Paris, France, Asia Pacific Region - Singapore, Japan - Tokyo) to provide additional training on Hyperion Enterprise system and additional tools.

Created Go Live plan which included running parallel (old versus new submission/consolidation/reporting method) for 2 consecutive financial month end closings to verify system design met Financial Closing requirements, prior to cutover to new system.



Contact this candidate