SQL & Database Analyst Resume
LOG IN OR REGISTER TO CONTACT ME
This button will open the login/register page in a new tab. After logging in, come back to this page and refresh your browser.
Resume:
A professional having experience in a variety of information systems. Has ability to learn quickly, be flexible, and provide solutions in day to day challenges. I’ve worked with MS SQL Server, Sybase, SAP, Peoplesoft, and iVantage. Possess strong communication and writing skills.
TECHNICAL SKILLS
|
|
Prudential Center/New Jersey Devils, NJ Nov - Present
SQL & Database Analyst
- Support upgrade, administration, and maintenance of sales & marketing systems including all testing,
project management, adherence to deadlines, etc.
- Sharepoint Development including documents, sites, installation, troubleshooting and workflows.
- Write & Scheduled Stored Procedures for maintenance, data manipulation & database administration.
- Report Writing/SQL Queries including Excel, MS Access, Crystal Reports and MS ReportServer.
eSchoolData, Bohemia, NY Mar -
Consultant/Data Manager
- Performed data migrations for school districts. Receive data in raw formats, convert and migrate to MS SQL database.
- Maintained and implemented reporting changes in MS Access database.
- Wrote Stored Procedures to update and maintain data in the database.
Unicredito S.p.A, New York, NY Jan - Dec
HRIS/Compensation Manager
- Managed HRIS system including updates, upgrades, new functionality. Saved $, in consulting.
- Assumed overall financial accountability for HRIS system, managing a yearly $, maintenance budget.
- Administered requirements for MS SQL Server/HRIS system including upgrades, updates, and new functionality.
- Managed full life cycle testing process and methodology of system upgrades. Upgrade was % successful.
- Regularly evaluated updates for HRIS system in order to keep current version running at its highest performance.
- Interfaced HRIS system to ADP for monthly payroll process. Ensured that interface ran successfully each month.
- Implemented Employee-Self Service time keeping system. Increased return on investment of HRIS system through use of Employee Self-Service system. Moved participation from % to %.
- Identified training needs of end users. Developed and delivered training to meet requirements. Created training for users for Employee-Self service system. Delivered in class and online improving system utilization by %.
- HRIS reporting and analysis, responsible for ad-hoc and analysis reports for Head Office including monthly headcount, compensation reports, turnover analysis, and hiring reports. Provided pertinent, information to head office in Munich to increase transparency with Head Office controlling group. Delivered accurate and efficient monthly reporting of budget numbers. Contributed to the accuracy of Head Office reporting.
- Developed home grown Microsoft Access databases to combine data from disparate sources so users can access and utilize data.
- Created four, web-based, HR compliance training programs to replace old legacy system. Worked with vendor to produce and deliver training to employees. Created security profiles, and email communications to employees and ensured smooth transition from old system to new.
- Maintained User Manual. Wrote and maintained HR processes.
- Wrote up new user requirements for development with HR Technical team.
- Performed Job Analysis with Managers and HR Director. Coordinated effort of over departments.
- Evaluates and analyzes salary data and administers compensation programs to employees.
- Completed bonus cycles accurately, and on time for payroll cut off. Uploaded over bonus, guarantee bonus, merit increase and special payments to payroll to local HRIS system. This was then interfaced to ADP payroll system.
- Coordinates with Senior Management and communication to employees of latest compensation trends.
- Ensures various national and international databases reflect changes.
- Created bonus letter application in MS Access to create individual bonus letters with no errors.
- Managed McLagan process for compensation program, including matching, surveys and reporting. Ensured fair pay practices, strengthened salary negotiations and provided the ability to bring in better talent to the organization.
- Ensured compensation system based in Munich was current and accurate between Head Office and US Operations.
- Wrote Job Descriptions based on McLagan data and direct communication from Managers.
HSBC, New York, NY Feb -Dec
HR MIS Manager/Reporting Analyst
- Managed and coordinated all aspects of the design, development, and support of enhancements to HR information systems. Liaison to head office operations of all new projects implementing HRIS. Guaranteed that the global implementation team was meeting local needs, and requirements. Improved interaction and response from global implementation by %. Was able to foster relationships with team that was largely unreachable prior to efforts.
- Oversaw maintenance and processing of employee data records and reports, ensuring the integrity and accuracy of all HR applications for up to employees.
- Coordinated effort to maintain all setup tables, code lists and back up documentation for Peoplesoft to support local needs; maintained all internal paper files as backup for Audit to support data changes made to system. Ensured that Audit would pass department.
- Ensured timely and accurate dashboard reporting for Human Resources department and Executive Management, Audit tracking, Core Leave, and Operational Risk. Provided information to executive management to keep team abreast of any issues that were arising within the departments.
- Created dashboard and tracked million salary budget for employee population, and million bonus pool. Demonstrated volume, and return on investment of up to operational HR transactions per month.
- Improved work processes; which streamlined operational workflow for all HR activities; developed recommendations to change systems, policies & procedures; ensured timely and accurate implementation.
- Designed and prepared complex ad-hoc reports for HR team as needed for Payroll & Benefits.
- Lead contact for employee payroll & benefit issues for research and resolution. Troubleshoot difficult benefit and payroll issues with employees and central office in Chicago.
- Wrote HRIS documentation manual coordinated end user training as needed with HR staff.
- Ensured compliance monitoring is in place, including processes for management of operational risk, in accordance with HSBC and regulatory standards.
Impact Innovations - Peoplesoft . - Security setup, query tree creation, user support at Cushman & Wakefield.
VIVENDI UNIVERSAL (formerly Joseph E. Seagram), New York, NY
HRIS, Supervisor and Specialist
Team Lead HRIS support staff consisting of approximately employees and consultants. Responsible for HRIS staff, global applications and application setup, training, security and reporting schedules; regular department, government and ADHOC reports in Crystal, PSQuery, SQR and MS Access.
- Oversaw the implementation of global security, security procedures, implementation and setup for users.
- Implemented Webtrends for HR an intranet reporting system.
- Managed team of developers. Designed, developed and converted legacy reports to Crystal, PS Query and SQR.
- Delivered training programs for Peoplesoft, to various sites in US, Europe, Latin America and Canada.
- Lead member of Fit/Gap Analysis for Peoplesoft , ., .., . & .
- Analyzed security requirements, created specifications, and implemented new business process for users.
- Created culturally sensitive and successful roll out plan for training sessions utilized in Europe.
- Wrote extensive training programs for PS Data Entry, Navigation, Query, Advanced Query and Crystal.
- Conducted formal classroom training sessions for up to students, in the US, UK, Scotland, France and Canada.
- Updated processes in Europe, Asia, Latin America and U.S with new requirements added translations as needed.
- Managed and maintained Citrix security, Peoplesoft user IDS, user profiles, and permission lists.
- Production environment was HRMS ., Oracle ., Oracle ., HP-UX ., HP-UX ., Citrix Metaframe application servers and an EMC Symmetrix disk array.
- Ran helpdesk for PeopleSoft support requests, implemented and trained HRIS staff on change management policies.
- Gathered and wrote user specifications for modifications and enhancements to PeopleSoft system.
- Active participant of person testing team and helped write test case scenarios.
- Lead member of person PeopleSoft upgrade team and process design project.
- Decision making partner for HR business processes team to ensure all requirements were managed within system.
- Developed project plan and wrote specifications to convert reports to Crystal, PS Query, SQR and MS Access.
- Project lead in JAD sessions for global reporting and global security. Six countries were represented on team.
- Oversaw the development and design of Learning Center, Employee Self-Service and The Benefits Center. All online employee web information sites.
EDUCATION – New York University
B.S. in Information Systems Management - G.P.A. .
E-Commerce Technologies – Multi-media Communications
CERTIFICATION
MCTS - MS SQL Server – obtained in
