Customer Service Developer

OBJECTIVE: Seeking an opportunity as a programmer, developer, or similar position which where I can make positive contributions to the organization, and where I can make use of my experience and abilities which I have developed over several years through my diverse IT work in varied industries.

Linked-in Profile: https://www.linkedin.com/in/joedemaio/

Technology Expertise:

Database

T-SQL, PL/SQL, Stored Procedures, Database Objects, Scripts, Queries, Functions, Access, SQL Server, SunGard’s Aligne, Oracle, DB2/SQL, Relational Databases, Database Normalization, Data Analysis, Database Schemas, ODBC

Application Development

Visual Basic for Applications (VBA Macros) for Excel and Access, VB6, VB.net, MS Visual Studio, Data Modeling, R

Microsoft Office

Excel, Word, Access, Power Point, and Visio

Core Competencies:

Excelled in varied analysis responsibilities requiring systematic analytical techniques and strong written and verbal skills.

Able to manage multiple projects and meet critical deadlines.

Key professional for meeting with senior company management and other business partners for requirement gathering and documentation.

Ability to author and revise standard operating procedures to comply with government, industry, and company standards.

PROFESSIONAL EXPERIENCE AND ACHIEVEMENT

FedChem, Bethlehem, PA November 2017 – Present

Database Developer (Contractor – part time)

Developing a Microsoft Access database to track and report operations for chemical manufacturer including multiple aspects of raw material receipts, product manufacture, testing and approval.

Producing automated reports that include receipts of raw materials, batch records, certificates of analysis, government regulatory, and other reports through a user-friendly GUI front end making use of SQL queries, stored procedures, and functions.

Conferring regularly with senior management to gather requirements, develop testing procedures, and database documentation, including user manual and data-flow diagrams (Visio).

Univest Bank and Trust Company, Souderton, PA March 2018 – May 2018

Senior Programmer Analyst

Met with business partners to discuss, document, and develop software solutions, including request forms, application development plan, application development, software testing, prototypes, sample outputs, and business partners’ approval.

Prolific in writing complex SQL statements that are used in stored procedures and functions and in the production of reports using SSRS.

Develop new and revise current user instructional documentation.

Chubb Insurance, Whitehouse Station, NJ February 2017–July 2017

Data Analyst/Business Analyst (Contractor)

Worked with key stakeholders, business partners, and IT counterparts to define requirements, identify source data, assist with high-level data designs, analyze and certify data, troubleshoot data issues, and promote data quality.

Supported data integration efforts by providing services that ensure company is aligning IT efforts with business information needs.

Merck, Upper Gwynedd, PA October 2014 – February 2017

Application Developer – Data Modeler (Contractor)

Collaborated with high-level management for gathering project requirements, design specification, implementation, user testing, and user acceptance for cost evaluation data modeling project.

Developed an application to model and evaluate risk reduction, life expectancy and cost using high-level mathematics and statistics in Excel with VBA to evaluate relative efficacy, and cost effectiveness for multiple drugs for use by various regulatory agencies in multiple countries.

Dun and Bradstreet, Center Valley, PA May 2014 – July 2014

Database Developer (Contractor)

Planned, created, and executed a system to monitor and report T&E expenses across more than 20 international markets for thousands of employees utilizing ETL uploads from COGNOS.

Designed, developed, and implemented cost center database to track T&E reporting by management team for Multinational Corporation for all management levels.

Johnson and Johnson, Raritan, NJ October 2013 – April 2014

Database Analyst –for compliance with Physician Payments Sunshine Act (Contractor)

Collaborated with corporate stake holders for gathering project requirements, design specification, implementation, user testing, and user acceptance for database developments and enhancements for projects.

Designed, developed and implemented an MS Access data quality application using VBA that identifies and quarantines data errors and downloads them to Excel spread sheets allowing users to upload corrected data.

Designed and developed an MS Access application that writes DDL to customize the migration of MS Access back-end database to SQL Server.

Migrated Health Care Compliance application from Access back end to MS SQL Server back end customized with VBA front-end code, rewriting functions to work with MS SQL back end, and rewriting VBA code to SQL stored procedures.

PPL Energy Plus, Allentown, PA June 2013 – August 2013

Data Analyst/Database Developer (Contractor) June 2011 – September 2012

Regularly interacted with back-end accounting department for project planning, requirements gathering, design, implementation, user testing, and user acceptance.

Designed, created and modified MS Access databases with Visio Diagrams, pulling data from multiple back-end Oracle databases utilizing ETL to create tables, forms, and reports for internal customers in energy trading.

Improved processes that utilized Access and Excel VBA apps and supported back office for monthly and quarterly close being on call as necessary.

Participated in a team effort to upgrade and deliver Access databases that tied in to SunGard’s Aligne system with ODBC connections to an Oracle back end for the accounting department using MS Access as a front end.

Documented low-level and mid-level data and logic flow for back-office accounting databases with both written details and Visio graphical diagrams. Developed MS PowerPoint presentations for the documentation.

The Guardian Life Insurance Company, Bethlehem, PA September 2012 – June 2013

Database Developer (Contractor)

Worked closely with corporate stake holders and management team for gathering project requirements, design specification, implementation, user testing, and user acceptance to upgrade document tracking application and other projects.

Developed an Oracle back end using ETL PL/SQL packages (procedures and functions) utilizing Embarcadero’s Rapid SQL editor in collaboration with .Net front-end team to replace obsolete application.

Migrated customer service application from Access back end to MS SQL Server back end customized with VBA front-end code, rewriting functions to work with MS SQL back end.

Designed, developed and implemented MS Access database including tables, queries, forms and reports, using VBA and SQL solutions for Crisis Command Center.

MANPOWER AT SYNCHRONOSS, Bethlehem, PA October 2010 – February 2011

Business Analyst/ Report Analyst (Contractor)

Maintained MS Access corporate database used to track over 600 call agents including hiring, attendance, performance, and attrition.

Developed and modified Access tables, queries, reports and forms used to report data to management using SQL scripts, Sharepoint and Access Database reports.

Produced ad hoc reports making use of ODBC data linking between Access Databases and Excel Pivot Tables.

HINDLEPOWER, INC., Easton, PA

Programmer/Developer (Contractor) October 2008 – February 2009

Designed and developed automated configuration system for electronic console with unique customization for each client to enable company to realize cumulative sales of approximately five million dollars.

Consulted with sales force, engineering team, and CEO to gather requirements, project specifications, design, and implementation, to assure accuracy and timely delivery of project with weekly progress reports.

Extensive use of Visual Basic for Applications (VBA Macros) for Excel.

SDI Health, Plymouth Meeting, PA August 2006 –May 2008

Quality Assurance Analyst/Production Analyst

Produced and quality tested Dashboard Market Analysis Reports for delivery to major pharmaceutical corporations.

Developed and performed quality tests on reports that contained both diagnostic and prescription data using SQL Server 2005 scripts, DTS, Visual Basic for Applications (VBA Macros) scripts and Microsoft Access Databases for testing data for accuracy and trending using ODBC External Data linking to connect to SQL Server 2000 and 2005.

Created monthly/weekly pharmaceutical market analysis reports to customers achieving a 100% on-time delivery record making extensive use of Pivot Tables.

Managed small team efforts and delegated responsibilities for major multi-report projects.

CHUBB INSURANCE, Warren, NJ January 2001 – December 2005

Programmer/Developer

Regularly interacted with Actuarial Reporting/Bureau for project planning, requirements gathering, design, implementation user testing, and user acceptance.

Produced, tested and implemented multi-program applications for the financial department according to Sarbanes-Oxley requirements.

Created and delivered a mainframe Workers' Compensation System including software development using COBOL 390 and FOCUS 7.2 on the IBM 3090 Mainframe involving numerous robust modules that included imbedded DB2/SQL.

Consulted daily with business customers in development ensuring requirements were met.

Followed progress through implementation while maintaining existing parallel system.

Maintained and updated Windstorm System improving data accuracy, lowering regulatory assessments by tens of thousands of dollars annually.

EDUCATION AND TECHNICAL TRAINING

Johns Hopkins Bloomberg School of Public Health

(On-line training)

November 2016 - 2017

Certification in Data Science

Chubb Institute

April – November 2000

Vocational Diploma - Computer Programming Honors Program

Moravian College

Bachelor of Science, Chemistry with a Mathematics Minor

Contact this candidate