SUMMARY

Have extensive experience with outstanding analytical and problem solving skills, administration and support for several different applications over the years, experience in database administration, SQL scripting and stored procedure writing. I have implemented several system integration's due to company mergers and acquisitions. Communicate well both verbally and in writing. Deliver presentations and end user training. Performed proactive visits to internal and external customers to ensure vendor/customer partnership and act as primary liaison between business and technical support staffs. I am a fast learner and strive on tough assignments.

PROFESSIONAL EXPERIENCE

Confidential,Ramsey, NJ

MITS Analytics Manager

• Acted as Project Manager, built and maintained the procurement Renewals database & front end app,using Longtion App Builder, allowing to have a method of adding, updating, reporting and notifying clients of upcoming hardware/software renewals which allowed for a substantial revenue increase in that area. SQL used for all processes including the renewal email notifications and job completion status. This new database and process allowed for a substantial revenue increase in that area.
• Acted as Project Manager, built and maintained a Product Shipment Tracking DB process. Data extracted from online CNETs Channel Online Procurement system Channel Online and All Covered's GoBase ERP reporting process. Loading and all processes done in SQL. SQL Database and procedures were used to load and process each product tracking files sent in by each vendor. These were received via ftp or email and loaded into SQL tables. This data was then extracted out of SQL and into a Microsoft Excel Spreadsheet that was shared on SharePoint so internal personnel can see the status of their client’s procurement shipments and have knowledge of their clients procurement order status.
• Performed analytical reporting of procurement metrics, forecasting, revenue, manufacturer metrics and more to upper management. This data was exported from the procurement system Channel Online and the in grown All Covered GoBase ERP reporting process and then loaded into a SQL database, merged and reported on a daily, weekly, monthly and yearly, including Year over Year manufacturer metrics. Data then exported into Micorsoft Excel and Pivot tables built to display the data as needed for executive review.
• Assisted the business with the putting together their business requirements and documentation for the implementation of the Ariba procurement system.
• Developed and assisted with administration on the Remedy ITSM suite, which included supporting the team whenever needed including development and administrative tasks.
• Began training for PMP (Project Management) and completed high level training thru HavardMentor. High level concepts understood.
• Provided base level IT support to non - technical personnel within the business.
• Demonstrated professionalism and courtesy with customers at all times.
• Identified and solved technical issues with a variety of diagnostic tools to ensure optimal customer satisfaction.
• Conducted research to address customer concerns.
• Researched, troubleshot and resolved complex problems independently.
• Worked closely with team members to meet or exceed all customer service requirements.
• Developed and tested new product offerings. Reviewed technical documentation and procedures.
• Enthusiastically participated in job related training.

SAP Support Services

• Performed all prior responsibilities, position in transitioning to focus more on direct SAP Support opposed to 3rd party integrated support. This never happened due to full time administrative need for the Optimized Print Management System implementation, aka OPS (Printfleet) and ongoing service and support.
• Supported the OPS (Printfleet) application, this became a full time position.
• Acted as Project Lead under the Project Manager in the automation of all manual processes including the addition of automating OPS client creation, device and alert triggering processes and completed all prior to moving on to new position.

SAP Basis Administrator

• Acted as Technical Application Lead for new Optimized Print Management Solution (OPS), Printfleet application project, from project initiation thru go-live and continued as Administrator post go-live.
• Acted as Subject Matter Expert and Project Lead on other projects including, Creating processes to export data to SAP for billing, automate the activation of devices and create and evaluate alert thresholds so auto notifications can be sent to the main support center.
• Performed a considerable amount of sql scripting, stored procedure writing, DB maintenance, backups and restores, scripting of all reports and stored procedures in SQL2005.
• Performed Analytical review of data to proactively monitor the account and deliver just in time service to better manage client accounts.
• Acted as the primary technical liaison between business, clients, and vendor support staff to assure a successful connection between the client and our central server.
• Performed several projects on database migrations, to merge acquired entities into OPS.
• Developed and delivered training and training documentation.
• Performed Visual Presentations/Demonstrations to prospective clients and internal staff.

Senior Programmer/Analyst

• Continued support for Remedy Helpdesk 5.6
• Supported the In-House Importation System which monitored imported goods from foreign manufactures.
• Performed many enhancements/modifications made over the years to improve the overall performance and add new functionality due to many company merger and acquisitions. Unix OS, Informix 4gl and Informix Database Utilized awk scripting to perform many data lookups/replacements/conversions of flat files.
• Acted as the primary liaison and assigned Project Technical Lead for the Logistics business and OnDemand Exportation system Global Wizard being implemented. The aggressive project projection was successfully implemented within 6 months.
• Developed detailed project test plan, user acceptance with full go-live implementation.
• Assisted in the development layout of all export document templates and tested each one to assure all data elements were included and calculations were correct.

Programmer/Analyst

• Developed and Administered the Remedy Help Desk 5.6, built on Remedy AR System 6.2 with SQL 2000 backend database on Windows environment.
• Performed modifications and created new forms, filters, active links and escalations.
• Interfaced with scheduling application which emails alerts received from the SAP Control-M scheduling system into Remedy to automatically create support tickets and route them to the proper individual, bypassing Tier1 and going directly to Tier2 support, when job failure occurs.
• Created batch scripts to pull and link LDAP data.
• Installed software, modified and repaired hardware and resolved technical issues.
• Provided base level IT support to non-technical personnel within the business.
• Managed call flow and responded to technical support needs of customers.
• Resolved customer issues in a clear, courteous and straightforward manner.