SUMMARY

Summary of Qualifications

• Extensive experience with database design, SQL query optimization, stored procedures, triggers, performance tuning, using MS SQL Server 2008 R2 Enterprise, and Oracle
• Coordinated project to successfully design and create a company's data warehouse, determined user requirements, used MS SQL Server, BI, SSIS, SSAS, SSRS, C .NET and the Agile methodology enabling use of historical data in strategic business decisions
• Designed, developed, and maintained complex data security applications, enabling company to become PCI Payment Card Industry compliant, using AES256 encryption/decryption, OO methodology, MS Visual Studio 2010 and VB.NET
• Developed applications that processed Medicare Part D pharmaceutical data to enable company to meet government reporting requirements, using MS SQL Server, SSIS, SSAS, SSRS, C .NET, ASP.NET and Workflow Process Software
• Developed e-commerce application enabling on-line ordering/tracking of pharmaceuticals, and database access, using Java Enterprise platform servlets, JSPs, JDBC, RMI, etc. and html and JavaScript
• Extensive experience in automating processes, resulting in greater efficiencies and time savings in various enterprises
• Outstanding ability to troubleshoot and solve complex problems, resulting in resolution of issues and detection/fixing of problems in existing software

Technical Expertise

Sun Certified Programmer Java Platform

Professional Experience

Confidential

SSIS Developer Application/database design, programming and maintenance

Used SSIS, SSAS, SSRS, MS SQL Server 2008 R2 Enterprise, C .NET, ASP.NET and business process workflow application software to develop applications that processed Medicare Part D pharmaceutical data which helped meet government reporting requirements

Investigated SSIS and MS SQL Server 2008 components to help resolve various issues that prevented compliance to HIPPA Medicare Part D requirements

Confidential

Senior Software Engineer Application software development Database design, programming and maintenance Data warehouse design/data integration

• Using SSIS, SSAS, SSRS, MS SQL Server 2008 R2 Enterprise, the principles of Business Intelligence BI and the Agile methodology, designed and created source databases for a central data warehouse that held billions of rows of historical data
• Optimized complex SQL queries accessing massive amounts of data
• Interfaced with the user managers to determine what information they needed from the data warehouse
• The success of this project enabled the user managers to rapidly obtain results from business queries, based on many years of historical data, emanating from a variety of disparate data sources this greatly assisted business managers in making strategic business decisions
• Loaded data into the data warehouse by extracting data from a multitude of diverse data sources residing on various platforms located throughout the company
• Researched various BI technologies for the company, making recommendations
• Designed and developed applications, using Visual Studio 2008, VB.NET and XML, for the encryption/decryption of sensitive data transmitted from over 400 hundred stores across the country
• These applications enabled Dots to become compliant with Federal PCI Payment Card Industry data security standards and contributed to Dots receiving the highest possible security rating
• Automated the loading of key stores with encryption keys that were utilized for the encryption of store register data
• Developed data processing/data transmission scripts, which resulted in significantly faster and more efficient polling of register data from hundreds of stores across the country
• Supported applications and software upgrade/migration for over 400 Dots POS retail sites across the country and maintained the Sybase SQL Anywhere and Microsoft SQL Server databases
• Created automated batch processes on store registers which resulted in the reduction of resource hours needed to support store POS software.
• Installed and tested RemoteWare software that interfaced between the POS stores and the home office.

Confidential

Software Application Rep Software development, Distribution Management and Application Support

• Created an automated process using stored procedures to change all sensitive data in training and test databases to ensure compliance with the Sarbanes-Oxley Act, which greatly reduced the amount of time needed to ensure compliance
• Automated various processes using SQL Server stored procedures and excel macros which resulted in significant reduction of resource hours needed to support client applications
• Managed the movement and testing of various development components to the production environment in order to maintain compliance with accounting auditing standards
• Created and designed SQL Server databases for client applications and managed client projects
• Utilized complex SQL queries to troubleshoot various problems and to facilitate the movement, correction and retention of data
• Extensive utilization of the Application Toolkit utilities to create reports, views, database tables, triggers and stored procedures
• Provided application development, management and support for Prudential/IRES Intuit Real Estate Solutions Application

Confidential

Software Engineer: Programming, System/Database support

• Supported the PROS Pharmaceutical Requisition and Order System web system. The PROS system is an enterprise Internet electronic commerce application that provides regional offices, throughout the country, with the ability to purchase, requisition, reorder, or track pharmaceutical products from a central warehouse. Provided support for existing client base.
• Supported the MRS Management Reporting System system. The MRS system is an enterprise Internet application that allows managers to create/save specific database queries that are used to generate various Oracle database management reports.
• Provided support and database services for the Pressco Intellispec Inspection System. Located software problems/issues, continually interfaced with application developers to describe software problems, suggested solutions, and obtained subsequent feedback, resulting in a more robust system. To keep track of software problems/issues, designed and programmed a tracking application that was utilized to track software problems, which provided management with reports/graphs related to problem tracking, which greatly facilitated the tracking of software problems.
• Provided programming and consulting services through Sullivan and Cogliano on the First Energy CREWS project as a Senior Consultant. This project leveraged the full power of the object-oriented paradigm and utilized enterprise development concepts. As a result, the client was provided with the ability to schedule and track various resources such as personnel and equipment. Various accounts were updated with this information.
• Engaged in extensive troubleshooting and problem resolution of the CREWS system, by resolving software problems/issues submitted by users. Resolution of issues required analysis and problem solving skills, along with in-depth knowledge of OO and PowerBuilder. Problem resolutions resulted in a more robust software system.