Data Analyst Resume
West Paterson, NJ
Summary
Professional with twenty five plus years of experience servicing managerial, technical
and operational functional areas with analysis, reporting and administrative support.
Professional Experience
Confidential West Paterson, NJ
Data Analyst - Information Technology (1997-2009)
Member of the corporate data warehouse team involved with administration,
maintenance and development of global information for reporting and analysis.
- Gather and document data requirements for use in report development
- Develop reports, data cubes and dashboards using COGNOS Impromptu, Powerplay and Framework Manager
- Publish reports to corporate intranet site using COGNOS Upfront portal.
- Define, document and create interface files for data transfers from multiple sources into the data warehouse
- Create and maintain Email notifications to all users regarding report status
- Develop control processes to monitor and verify data accuracy
- Research and resolve data exceptions
- Provide application training and ad hoc report guidance for end users
- Provide assistance to end users to troubleshoot and resolve data, technical and application issues
- Develop and maintain technical and user documentation for data warehouse
- Partner with end users to document business needs and translate into technical Requirements
- Analyze and model end user business data and processes.
- Map and convert data from legacy systems to the data warehouse.
- Assist in the development of procedures and standards for enterprise and IT Operations
- Partner with IT technical support on data warehouse redesign and upgrades
Financial Systems Analyst (1993-1997)
Member of the financial team involved with administration and maintenance of
information into the Cytec Financial applications
- Collect monthly Income Statement, Balance Sheet and Sales and Cost details via EXCEL spreadsheets and load into the Cytec Financial applications.
- Facilitate budget data loads and extractions from global subsidiaries into budget applications and corporate general ledger
- Provide user and administration support to corporate general ledger system
- Liaison for financial and ad hoc report requests from American Cyanamid applications during the spin off period.
- Create and post Journal entries
- Coordinate monthly and annual rollover of corporate general ledger system.
- Provide technical support for data submission of quarterly and annual earnings to Bloomberg newswire services.
- Provide assistance to end users to troubleshoot and resolve data and application issues
- Respond to requests for ad hoc reporting
- Provide general ledger account analysis
- Member of the financial re-engineering team involved with the implementation of the general ledger system. Implementation included documentation, analysis, mapping, conversion and review of pre spin-off and post spin-off processes and procedures.
Confidential Wayne, NJ
Financial Systems Analyst Confidential (1987-1993)
- Collect and load monthly Income Statement, Balance Sheet and Sales and Cost details viaEXCEL spreadsheets from foreign subsidiaries into front end financial application for review and analysis prior to posting to corporate general ledger.
- Consolidation review and report distribution of Agricultural division global research and development expenditures by project
- Review and report distribution of departmental expense analysis
- Research and resolve reporting issues
Confidential Edison, NJ
Corporate Analyst (1985-1987)
- Member of the corporate accounting group involved with the analysis, reconciliation and distribution of product line profitability reporting using SAS software in a mainframe environment
Confidential (1982--1985)
- Identified and automated various manual business processes thru the use of personal computers and Lotus software.
- Automated the Cost Accounting group\'s budget reporting processes with the use of personal computers.
EDUCATION:
- Bachelor of Arts
COMPUTER SKILLS:
- Internet
- Microsoft Office (Excel, PowerPoint, Word, Visio, Access, Outlook, Project)
- COGNOS Impromptu, Powerplay, Upfront, Framework Manager
- Infinium Financials (AS400)
- BPCS (AS400)