Highly motivated and enthusiastic IT professional with experience in managing, developing, supporting and maintaining enterprise-wide systems. Outstanding analytical skills with an ability to forecast implications of the decisions. Ability to work autonomously and as a team player, with strengths in motivating, training and mentoring situations. Easily adaptable to change, with an eagerness toward learning and expanding capabilities.
MS SQL Server 2000 - 2014, Oracle 9i, FoxPro, IDMS, VSAM, Access, Paradox, dBase III & IV
Windows 8, Windows XP, MVS, OS/2, DOS
SAP Business Objects 4.0, Epic, Epic Reporting Tools, Crystal Reports, Component One Reports, PostScript, ArcGIS, BMS Mapping, Expediter, Arc, Elixir, Dreamweaver, Flash, Fireworks, Authorware, Director, Visio, MS Office, FTP, NDM, Photoshop, Doc 1
Manager, 01/2011 to CurrentYale Medical Group, Yale University － New Haven, CT
Manage a team of four (4) business analysts.
Manage and assist in the development of a self-service clinical/financial reporting system to support Yale Medical Group, Yale School of Nursing and North East Medical Group.
Partner/collaborate with customers, hospital IT staff and or university staff to complete assignments and projects.
Manage high priority projects for Chief Operating Officer of Yale Medical Group and Yale School of Medicine.
Guide team members in best practice for fulfilling project and operational needs for data leveraging Epic reporting tools like Clarity, Radar, Reporting Workbench, Cubes, Slicer Dicer, Cogito Data Warehouse, or the third party tool Business Objects Web Intelligence.
Create SQL queries to pull data for analysis and reporting.
Develop stored procedures to process data used in building universes for dashboards and reports built in SAP Business Objects tool.
Build universes, dashboards and reports to support the various functions of Patient Financial Services as well as the Yale Medical Group clinical departments and North East Medical Group.
Analyze data and develop Excel VB applications to format and automate distribution of reports from the GE Centricity system.
Develop VBScript and Windows Batch files to process Excel VB applications.
Processed SQL queries in GE Centricity to pull data used for reporting productivity, non-covered services, etc.
Manage upgrades of current software and purchase of new software to assist in reporting.
Programmer Analyst, 01/2007 to 01/2011World Wrestling Entertainment, Inc － Stamford, CT
Analyzed, developed and maintained ASP.NET code for the company intranet site.
Maintained VB.NET application used by travel department to book limousine transportation of company VIPs.
Analyzed, developed and maintained VB.NET application to produce file in XML format to send to the Canadian government reporting tax information for all vendors working or living in Canada.
Analyzed, developed and maintained VB.NET application to produce text file to send to the US government reporting tax information for all US vendors.
Updated Remedy Support application to add forms and fields to the helpdesk/change control application to improve functionality of the system.
Analyzed and developed Remedy reports and forms to meet user specifications.
Managed project to produce a Remedy application to track inventory of all items used to produce a company live event.
Analyzed, coded, tested and maintained Java pages for company intranet site to allow employees to request tickets for company live event.
Analyzed, coded, tested and maintained Java web application used to calculate ticket sales per event for all Live Events.
Analyzed, coded, tested and maintained Java web application used to produce 1099 forms for vendors and talent for tax filing purposes.
Maintained Visual Basic 6 application used to track all accounting transactions for talent including payment and royalties.
Created data transformation service packages to move and process data in SQL Server.
Created queries to pull data for reporting purposes.
Used SQL Navigator to develop and process SQL statements against the Oracle database for the various applications.
Developed and maintained report templates in Crystal Reports for printing talent payroll and royalty checks or reporting number of defects called into the Help Desk.
Programmer Analyst, 01/2003 to 01/2006Environmental Data Resources － Milford, CT
Analyzed, coded, tested and deployed Visual Basic .NET 2005 Windows Services to send email to the client with their report attached.
Created stored procedures in SQL Server to do all data processing for property reports.
Developed and maintained report templates in Component One that are then transfer to a PDF format for viewing in Adobe Reader.
Analyzed, coded and tested Visual Basic .NET and 6.0 applications used to enter in information for target property and any surrounding properties that may be found.
Created queries to manipulate Oracle data displayed in Visual Basic 6.0 application.
Used PL/SQL Developer to process queries to update, insert or delete information from the Oracle database.
Developed application to email reports to Account Executives alerting them of orders on hold that need to be resolved.
Developed and maintained various reporting templates using Visual Basic 6.0 Designer.
Analyzed, coded and tested Visual Basic 6.0 application to report end of month revenue and calculate commissions.
Developed application to view database information in an Excel spreadsheet to allow scanning technician to review.
Developed ASP scripts and HTML pages to display order information for each individual field researcher by running queries to pull the data from various tables Updated, inserted and deleted data from MS SQL Server tables.
Created and uploaded PostScript code to display logo and disclaimer changes.
Created maps in ArcGIS to view data coverage for particular area.
24-hour availability for problem resolution.
Application Specialist, 01/1997 to 01/2002GE Capital － Stamford, CT
Managed a team of 7 programmers to maintain the Statements Processing system while transitioning between Team Leaders.
Led third party vendor meetings as Statements Subject Matter Expert.
Managed several projects successfully through the system development life cycle.
Created and uploaded logos and overlays from Arc and Elixir software to mainframe.
Defined new and modified existing page and form definitions using PPFA for statement formatting.
24-hour availability to resolve critical production issues.
Created and modified COBOL II modules that generated mixed mode AFP print files using data pulled from IDMS tables, VSAM files, and flat files.
Developed SYNCSORT to arrange statement data by form code to assist in print room functions.
Analyzed, coded, and tested Doc 1 rules to create full AFP statement files for commercial clients.
Produced VSAM files with data extracted from IDMS databases.
Assisted in the production of Visual Basic program to track statement messages by client and cycle.
Created JCL and PROC to run modules that produced 4 billion customer statements per month.
Epic Cogito Clarity Data Model Certification:2014Sacred Heart University － Fairfield, CT
M.S:Computer Science & Information Technology,2004Computer Science & Information Technology
Six Sigma Green Belt CertifiedCUNY/Baruch College － New York, NY
B.B.A:Computer Information Systems,1996Computer Information Systems