SUMMARY:

• Detail oriented Information Technology professional with in depth expertise in financial reports and management reports.
• Crystal Report/BO development (ver. 7 to Xl R2), Access database development and R&R reports report development.
• Record of success in providing Oracle 10 database and Microsoft SQL database management.
• Knowledge of Confidential Cycle Meter Reading System
• Demonstrated project and budget management skills.
• Knowledge of Itron FCS application System

PROFESSIONAL HISTORY:

Access Developer and Reporting Analyst

Confidential

Responsibilities:

• Design physical databases using MS - Access exported from PeopleSoft system
• Analyze and develop complex analytical Crystal reports
• Responsible for data upload and downloads to support the data flow within Access/SQL database
• Gather and execute on requirements for database enhancements and report generation

Data and Report Analyst

Confidential

Responsibilities:

• Writes reports utilizing SAP Crystal/BO, WebI, MS SQL, MS Excel, and Access.
• Develops and provides support for reports in a timely manner, prioritizing multiple requests.
• Created SQL scripts for extraction of data from various data sources.
• Analyzes and understands various data models in depth; proactively define data structures additions (views, intermediate tables) that would improve performance.

Data and Reporting Analyst

Confidential

Responsibilities:

• Developed and designed reports to assist users in planning and analysis of business process.
• Maintained and created matrix report in compliance with city and state agencies.
• Gathered analyses and documents for business requirements for new or modified reports.
• Created and maintained SQL scripts, tables, views and complex queries for data analysis and extraction.
• Built reports using Crystal Reports/BO.
• Performed Data Analysis with T-SQL

Data and Reporting Analyst

Confidential, New York, NY

Responsibilities:

• Developed and designed reports to assist users in planning and analysis of business process.
• Gathered analyses and documents for business requirements for new or modified reports.
• Created and maintained SQL scripts, tables, views and complex queries for data analysis and extraction.
• Built reports using Crystal Reports/BO, Cognos and Excel.
• Assisted with administration of Title Management (TMM) and Production Module (POMS) such as handling user access, data security and adding new fields.
• Maintained report request within Action Register management tool.
• Performed Data Analysis with T-SQL

Data and Reporting Analyst

Confidential, Brooklyn, NY

Responsibilities:

• Developed, analyzed and modified SQL data and Crystal Reports for all agency contracts.
• Maintained and modified compliance reports for state and funding agencies.
• Integrated Medicaid billing data into local database system.
• Developed and created ad hoc reports based on director’s specifications.
• Converted legacy data into Access/.NET databases for the management and matrix analysis of personnel performance.

Account Billing Assistant

Confidential, New York, NY

Responsibilities:

• Ensured proper process of health related transactions.
• Calculated payments and updated and maintained files and records.
• Provided suggestions that improved existing policies and procedures, and handled inquiries requiring addition investigation and/or specialized knowledge.
• Made recommendations or decisions in individual cases or problems.
• Assigned and reviewed work of and trained a small number of students and/or casual employees engaged in routine tasks.

Data Management & Reporting Coordinator

Confidential, New York, NY

Responsibilities:

• Performed data administration and advanced reporting for External Relations division.
• Wrote Crystal Reports based on systems analyst specifications.
• Oversaw all advanced database projects, data synchronization, data exchanges and programming.
• Analyzed complex information and resolved issues onsite with T-SQL
• Oversaw Millennium database enhancement objective.
• Collected, classified and analyzed data.
• Created queries and Crystal Reports to provide quantitative information to meet needs of External Relations division.
• Resolved data discrepancies and ensured data accuracy.

Data Analyst/Contractor

Confidential, New York, NY

Responsibilities:

• Performed data scrubbing.
• Analyzed, inspected, reconciled and appended existing data based on findings in the City’s payee/vendor databases.
• Modified existing Crystal Reports and performed needs analysis for new and ad hoc reports.
• Maintained and modified compliance reports for city, state agencies.
• Converted Excel data into Access/.NET databases for the management and matrix analysis of personnel performance.

Crystal Report Developer

Confidential, Melville, NY

Responsibilities:

• Converted concentric R&R reports into Crystal Reports VI format.
• Served as technical resource for the IT staff and assisted them to create ad hoc reports using Crystal Report server and developed report design specifications.
• Used SQL to query complex relational databases and validate reporting results.
• Supported business views, universes and SQL server and Web Intelligence

Crystal Report Analyst/Contractor

Confidential, Morris Plains, NJ

Responsibilities:

• Converted Macola Progression (ERP) and Excel spreadsheet P&L reports into Crystal VI format.
• Analyzed underlying table structure to determine tables needed to create/convert report formats.
• Developed ER diagrams with Embarcadero‘s ER/Studio of IFS© Oracle 10g database system.

Programmer/Analyst

Confidential, New York, NY

Responsibilities:

• Converted legacy database systems into Autotask© CRM system.
• Analyzed various data sources such as Access, Excel Spreadsheets, Dbase files and Word documents for inclusion into CRM system.
• Created SQL scripts for extraction of data from various data sources.
• Supported the creation of Crystal Reports against CRM database and.Net forms for data entry.

Administrative Coordinator

Confidential, Metro Center, New York, NY

Responsibilities:

• Reported to the project director of the school partnership program.
• Maintained and updated tutoring information for 32 graduate research assistants.
• Added new records for students as they joined the tutoring program, which consisted of 400+ students at the start of the academic year.
• Printed and distributed weekly intake forms for new students and blank tutoring hours report for weekly hours tutored.
• Performed maintenance on database tables/fields and input forms.
• Converted DOS-based program into Windows Access program.
• Planned and coordinated special events and activities, including the ordering of food, renting of space and setup of equipment.

Assistant Budget Coordinator

Confidential, New York, NY

Responsibilities:

• Assisted in preparation of budget format and projection based on established University and Corporation yearly budget directives.
• Assisted in monitoring and maintaining budget within projected spending and cash rates.
• Assisted in auditing and maintaining budget records.
• Monitored functions for grants, university accounts and affiliation funds.
• Developed and implemented a departmental database in an xbase programming language (preferable FoxPro) for the management of departmental data.
• Escorted corporation personnel on floor audits.