OBJECTIVE:

• Secure a challenging position that utilizes my project management, coding, database and reporting experience.

SUMMARY:

• Integration from legacy Healthcare HR management systems to Workday system - 8000+Employees. Coded Import and export Data Transforms including Java XSLT. Setup security in rollout.Web Development - Visual Studio 2005 and 2008
• ASP.net and VB.net, C# within Visual Studio 2005 and 2008.
• Designed and Administered Internal Confidential Website. Developed user interface for Access and SQL databases. Utilized ASP, HTML, Java Script, VB Script, SQL Queries, CSS files and Include files.
• SQL Reporting Services - Modified and maintained reporting for corporate dashboard.T-SQL and SQL Server 2008/2010 Database Development
• Triggers, views and stored procedures with cursors. SQL Query analyzer, SQL Profiler, Database Backups and Restores, and Job Scheduling. Advanced T-SQL and joins including Sub-Queries and UNION Queries.
• Setup DTS and SSIS packages for importing and exporting data.
• Experienced in all development phases; gathering requirements, programming, final rollout and
• Established security processes and logins. Developed table structure of database. Utilized indexes and normalization.Crystal Reports
• Developed reports in Crystal 8.5, 9 and XI. Utilized sub-reports, formulas, hyperlinks, advanced charting and web.
• Completed corporate dashboard for displaying summary reports - utilized drilldown to display further detail.
• Condensed multiple 8.5 and 9 reports into XI saving customer millions in reporting expenses.Access Database / Excel/Visual Basic Development
• 15 years development experience. Access 2000, 2003, 07. Access 2000 Development Certified.
• Visual Basic expert - 10 years programming experience.
• 15 Years MS Excel experience. Advanced charting, pivot tables, macro programming, formula auditing, functions expert (including financial, statistical and lookup), sorting, file linking, data filtering. Cost accounting and financial modeling experience.

TECHNICAL SKILLS:

Other Skills: Rational ClearQuest, Rational Requisite Pro, WINSQL, MS Sharepoint

PROFESSIONAL EXPERIENCE:

Confidential - Rochester, NY

HRIS Analyst

Responsibilities:

• One year integration project from legacy HR management systems to Workday system .
• Coded import and export data transformations from existing vendors including ADP, BCBS and HCS Position Manager to and from Workday. Java XSLT coding for integrations.
• Worked with Confidential to setup security in workday for 8000+ employees.
• Other Projects: Employee Flu shot tracking for Hospital, United Way contributions tracking, Management reporting using SSRS, Setup/maintained Database in SQL 2010 for Tracking Employee demographic data.

Confidential

Software and Database Consultant

Responsibilities:

• RGHS/ViaHealth: Developed and launched a benefits website for open enrollment for 8000+ employees. Worked directly with Human resources and met aggressive delivery schedule to complete website in time for benefits enrollment. Developed reports in SSRS and Crystal Reports. Developed Access Databases and complex Excel files including VBA.
• SQL Server 2008/2010 - DTS & SSIS, Stored Procedures, Query Optimization
• Visual Studio 2005/08, VB.net, VBA for Excel and MS Access, ASP.net.
• Reporting Services for corporate dashboard and HR reports.
• Scrubbed data and imported into SQL server from Cyborg Benefits software package.

Confidential - Rochester, NY

Database Consultant/Software Engineer

Responsibilities:

• Crystal Reports Development and Advanced T-SQL writing
• Lead Crystal programmer/support contact responsible for Ad-hoc financial and Asset reports for Multi-Million dollar customer. Programmed advanced Crystal formulas, summaries, sub-reports, commands, advanced charts; scheduled hundreds of reports for delivery
• Supported customers in Europe and South America; Lead developer responsible for transitioning new South American customer; Developed and supported Managerial reports
• Programmed advanced T-SQL Commands including Union Queries, optimized performance, exported to Excel with advanced VBA macros.
• Beat aggressive delivery schedules on conversation projects of 500+ reports from version 8.5 to XI
• Lead programmer for monthly Executive Summary- improved delivery time by 50% through advanced VBA

Confidential - Rochester, NY

Database Consultant/Software Engineer

Responsibilities:

• SQL Server /Crystal Reports XI and 8.5 - coded ad-hoc reports for multi-million dollar customers
• Programmed stored procedures, functions, and triggers to generate web reports in SQL
• Developed in Crystal reports to generate a report summary dashboard. Reports utilized by senior management.
• Developed DTS and SSIS, SQL Query Analyzer, SQL Profiler, Job Scheduling, Backup/Restores and Indexing tools
• Set up SQL database on server. Initiated improvements within table structure design.
• Access Development - developed Access database to improve productivity and accuracy for system analysts.
• Database to track scripting changes to Government regulated database that tracked private customer information.
• Utilized VB, complex SQL queries, ActiveX controls and unbound forms in database design. Database security implemented by splitting database, utilizing MDE’s, UserID’s and Passwords, and database passwords.
• Database Conversions - Access 2000 database to SQL Server 2000.
• Utilized DTS to transfer data. Made proper adjustments and corrected errors to table settings in SQL.

Confidential - Rochester, NY

Unix Systems Administrator

Responsibilities:

• Completed basic UNIX and NIS/NFS system administration on Solaris 8 machines
• Performed setup on new machine including disk partitions and network connectivity
• Administration tasks included adding new users, data recovery, data backup using Legato 6.1.1 for Sun L3500
• Installed and configured Red Hat 8 operating system. Setup several database servers using Windows 2000.
• Lead Engineer for Database with 250+ users. SQL Server 2000 backend and Web Front End.
• Programmed triggers, views, and stored procedures. Set up Multi-level security for users, managers and administrators.
• Improved database performance through T-SQL improvements, stored procedures, triggers and indexes.
• Front end utilized HTML, ASP, VB Modules, Java Script, SQL Queries, CSS files and Include files.
• Site includes many Managerial level reports. Database established to meet CMM Level 3 requirements.
• Database conversion. Converted Access 97 and SQL Server 7.0 databases into SQL Server 2000 databases.
• All delivery schedules met or exceeded for database releases.

Confidential

Systems Analyst

Responsibilities:

• Developed several Access 97 databases through all phases of development.
• Designed Access 97 link to Oracle database - link used to generated reports and create user interface
• Reduced 40+ hours per month of employee data entry time by implementing electronic data feed to databases from other external databases; this also eliminated human entry errors

Confidential - Rochester, NY

Asset Management Analyst

Responsibilities:

• Developed, programmed and maintained Access 97 database to track company leased vehicles
• Programmed in Access 97 and 2.0 and Excel Macros
• Performed month end closing activities related to asset capitalization and depreciation

Confidential - Rochester, NY

Financial Analyst

Responsibilities:

• Managed PC electronics and wiring upgrades on Access 2.0 database for balance sheet - $32M project
• Developed, programmed and maintained large MS Access 2.0 database for new line of products. Acceptance of new products based on financial targets generated from database.
• Generated cost reductions through benchmarking - with successful teamwork $12 Million in savings captured.
• Performed financial modeling for products using excel. Developed profitability model.

Confidential - Rochester NY

Responsibilities:

• Through teamwork, developed a business plan for small local investment firm
• Part of team that reengineered MBA curriculum to improve and condense program - RIT
• Completed time value of money analysis on purchase decisions