OBJECTIVE

Obtain a challenging and exciting position in Information Technology, leveraging skills in Business Analysis, data analysis, software and custom report development, and application development and support.

SKILLS SUMMARY

• Database: Access 2.0 to 2010, SQL Server 7.0, 2000 and 2005 FoxPro 2.5-6.0, MySQL, others
• Programming: VBA Visual Basic 3.0 to 6.0 Visual Studio 2003 and 2005 - VB.Net and ASP.Net
• Reporting: Crystal Reports 6.0 thru X, XI and 2008 SSRS 2005 - SQL Reporting, SSIS 2005.
• Other: Microsoft Office Excel, Access, Word, Outlook, Visio, Powerpoint, etc.
• Data Analysis: Across all of the above environments.

EXPERIENCE

Confidential Consultant

Troubleshoot and make modifications to a large retail Point of Sale application which was not performing correctly, written in VB 6.0 and C , Visual Studio. Performed a thorough review of the code and analysis of data, made recommendations, and implemented solutions. Contracted ended April 1.

Confidential Consultant

• Develop new reports Sales History, Drop Order, Customer Retention, etc. in
• Crystal Reports 10 accessing data in a Counterpoint 7 Point of Sale system.

Confidential Software Developer

• Develop and support several dozen reports, in Crystal Report XI accessing a Cache database for an Avatar Practitioner Maintenance program.
• Develop new Access databases, data entry screens and reports Access 2007 for Internal Audit.
• Administrator and Developer for Salesforce Force.com application to store Prospect information for national Mentor recruitment effort. Rolled out Pilot with fifty Users to six States and then Go Live to thirty five states with 300 Users.
• Develop Salesforce Account Administration application to automate processing of Activations, Deactivations, Password Changes and Resets, Special Permissions, Routing and Transfer of Prospects through IT Service Center. Develop SSIS routines to move data for Oracle data of 30,000 employees to SQL Server, and SQL nightly inserts and updates of Active/Terminated Employees to SF Employee Staging table.
• Develop new reports in SSRS 2005 . Reports included summary, detail, and cross-tab reports for Accounts Payable, Accounts Receivable and Human Resources processing.
• Create and modify stored procedures SQL 2005
• Develop SSIS packages to port data from Oracle to SQL Server
• Develop and maintain workflows in Biscom using Faxcom Suite for Windows. Migrate enhancements through Development, Test and Production environments.
• Develop screen interface options in the Avatar Practitioner Management System.

Confidential

Consultant

• Enhance existing database system and reports developed in Microsoft Access Confidential VBA to include new features, forms, fields and tables. Improvements were needed to complete the product prior to distribution to Beta users and product launch/marketing.
• Reviewed software and advised on possible areas of improvement regarding ease-of use, support, and marketability.

Confidential

Consultant

Develop new reports in Crystal Reports Confidential, utilizing an Oracle data source, for Maintenance and Repair of Commercial and Military jet engines at Cheshire Connecticut and Singapore plants based on legacy VBA.

Confidential

Consultant

• Provide analysis, upgrade and enhancements to CASPR Contract Accounting Support Program , a database system which tracks forecasts and actual FIA Fleet Introductory Alliance and commission payments on Pratt Whitney's engines and aircrafts, developed in Confidential
• Modified to calculate extended sales and perform monthly Sales and FIA Cap escalations and generate new reports.
• Produced full documentation to comply with Sarbanes-Oxley requirements.

Confidential

Senior Systems Analyst/ Consultant Contract-to-hire

• As a Senior Systems Analyst in a contract-to-hire position, serve as Project Lead for all Business Systems. Oversee two business/programmer analysts, a Cognos Reports developer, and a Crystal Reports/Help Desk person. Interface with external consultants and all levels of users and management to pursue the goals of the organization.
• Produce new and modified reports in Crystal Reports XI.
• Support and development of a Vantage ERP system using VB.net customizations.
• Blackstone Medical is a publicly held corporation with 120 million year in revenue.
• This position ended because business operations in Springfield were closed and moved to Texas.

Confidential Consultant

• Develop reports using SSRS.
• Develop several SQL Server Integration Services SSIS packages to move Vulnerability data from MySQL to SQL and load the Risk Assessment System data.
• Develop reports in SQL Server 2005 Reporting, as well as ChartFX
• Design and develop a Risk Assessment System in ASP.net VS 2005 and MS SQL 2005, integrating several areas of IT Security including Applications, Exceptions, Patching, and Vulnerabilities.
• Maintain and enhance two Visual Studio 2005 ASP.Net applications, one which retrieves data from all UTC Vulnerability databases MySQL at all UTC companies and moves that data to MS SQL Server 2005 databases located at UTC Headquarters IT Security department the other, a Vulnerability Reporting Application, produces graphical reports using ChartFX from the SQL Server 2005 data.
• Modify Windows Server Update Services WSUS programs developed in ASP.net VS 2005 .
• Develop and maintain Workflow programs for IT Security Investigations, ID Requests, Policy Exceptions, Active Directory Requests, Forensic Imaging and others in a proprietary Workflow application developed by Hamilton Sundstrand.

Confidential Consultant

• Develop approximately 150 reports in Crystal Reports and integrate with MM Reporting and BI.
• Design and develop a reporting application, MM Reporting, in VB.Net Visual Studio 2003 and upgrade to Visual Studio 2005 to print reports developed in Crystal Reports XI. Application allows selection and storage of Print preferences, report criteria, and scheduling information and sends reports to file/screen/printer with auto generated emails. MM Reporting also provides for pre-processing of data retrieved from AS400/DB2 and Access 2003 databases and creation of data extracts for reports.
• Attend training in AWD/BI Automated Workflow Distributor / Business Intelligence by DST.
• Develop programs and databases in Access 2003 for auditing and quality control of Trading, Brokerage, Cashiering, New Accounts, and Account Maintenance departmental functions.

Confidential Consultant

• Design and develop an Intranet application using ASP.net/Visual Studio 2005 and SQL Server 2000 to allow Legal Staff and company engineers to enter, retrieve, and report on UTC Invention Disclosures, Patent Applications, and Patent information, as well as Competitor Patents. Program provided for the linking and maintenance of related documents, images, charts, etc., and the relationships between various Invention Disclosure, Application and Patent records.
• Migrate data from legacy Lotus Notes program and legacy Access 2003 tables to SQL Server.
• Develop downloads from Micro Patent Office to SQL Server and export routines from SQL Server to CSV and other file formats. Update functionality in Access 2003 program.

Confidential Consultant

Develop programs in VB.Net and Access 2003 to perform file input/output operations and various file conversions for integration with an AS400 environment. This included a Survey program and Time-punch program. Also support legacy Clarion databases and reports.

Confidential Consultant

• Provide new development and enhancements in VB6/Access Confidential on a remote/laptop based Order Entry module of an AS400 based accounting system.
• Spearhead development of software tools and develop several modules deployed in DLLs in addition to feature enrichments. Act as guru to other development staff and provide design recommendations and consultation to management regarding development on the Windows platform versus the character based AS400 .

Confidential Consultant

• Enhance existing reports and develop new reports using Crystal Reports 8.5.
• Convert Access 97 VB application to Access 2003 and develop a conversion program to export data.

Confidential Consultant

Enhancements and maintenance on a system developed in Visual Basic 6 that is used by Investment Analysts to create business models based on a broad range of portfolio criteria. The system stores sixteen screens of financial information in Access 97, and passes that information to a series of spreadsheets in Excel which produces analytical results. Efforts involved adding fields, screens, combining models, new reports, upgrading components, etc.

Confidential Consultant

• Independently develop a Visual Basic 5.0/6.0 application to perform inventory auditing and generate a variety of inventory reports. The Inventory Audit Program IAP used at approximately 300 EMC locations worldwide. Users can enter inventory data on custom entry screens or via upload of bar code files. Administrative oversight with additional features and reports is provided for administrative staff for Domestic operations in Milford, Massachusetts and for International operations in Cork, Ireland.
• Also develop a VB 5.0 application using SQL Server to store and report on millions of dollars of Return Merchandise Authorizations RMA for sales on EMC products. Modify existing SQL scripts and develop new SQL routines on the server, and integrate these into a new front end VB application that also accepts daily data feeds from an AS400.