SUMMARY:

A highly trained and experienced professional - Background includes Leadership and Management of data solutions. Extensive experience on relational database design and engineering concepts. Industry Verticals include Marketing, Health Insurance, Manufacturing, Oil / Gas commodity trading, Telecommunication, Retail, Non Profit, Logistics, B2C, B2B

Interpersonal and organizational skills refined through experience. Demonstrated abilities in training and coordinating teams while utilizing planning and time management principles to achieve goals and complete projects accurately and on time.

Over the course of a 15+ year professional experience has managed to maintain a 65 to 35 split between development and management. While still maintaining targets, meeting deadlines and budgets.

Reporting tools:

Business Objects MS Business Intelligence Oracle Reports Cognos Reports

Database tools:

Toad SQL Developer MS SQL server SQL Client ERWIN

Database Developer information:

Large Database development (Tb) Oracle, Netezza, SQL Server

Dynamic PL/SQL packages / procedures T-SQL, SSIS packages

3 Normal Form, Star schema Data-warehouse, campaign / report mart

Reverse engineer SQL to create business requirements

EXPERIENCE:

St Jude,( Remote ) May 2015 – October 2015

UNICA Consultant

Conversion of oracle dynamic PL/SQL source code into Unica Campaigns

Reverse engineer code into Business Specification

Managed the entire campaign deliverable for each campaigned assigned

CDW, IL Jan 2015– June 2015

UNICA Solutions Consultant

Update TCS process

Created unica campaigns

Design and implementation of extended functionality to UNICA Marketing Operations for CDW

Co-ordination required between several Key stake holders across several departments and locations as well as Internal and External Vendors

Databases included SQL Server 2008, Oracle 10g.

Tuning SQL queries, ETL and Process Data Flow

Managed back end TCS project coordinated work with PMO

Bridgestone Firestone, IL Nov 2014– May 2015

CRM Application Solutions Consultant

Implementation of Unica 9.1

Developed and implemented Campaign Flow Chart

Test plans for Unica conversion

Designed business process flow for campaigning process

Designed business rules for specific components of the BSRO business process

Managed client integration with UNICA

Developed Oracle PL/SQL packages for the Campaign DataMart

Tuned Oracle PL/SQL code

US Cellular, IL Sep 2014– Dec 2014

CRM Application Solutions Consultant

Conversion of Unica 8.6 campaigns to 9.1

Update back end Schell scripts related to File ETL’s for the Campaign

Developed Oracle PL/SQL packages for the Campaign DataMart

Tuned Oracle PL/SQL code

CDW, Schaumburg, IL Aug 2014 – Dec 2014

UNICA Solutions Consultant

Design and implementation of extended functionality to UNICA Marketing Operations for CDW

Co-ordination required between several Key stake holders across several departments and locations as well as Internal and External Vendors

Databases included SQL Server 2008, Oracle 10g.

Tuning SQL queries, ETL and Process Data Flow

Managed TCS project coordinated work with PMO

Created unica campaigns

Allant, Naperville, IL, Aug 2012 – July 2014

Application Database Solutions Consultant

Designed and implemented Report Data Mart for AVIS

Migrated control systems to different platforms

Managed teams across multiple departments to Develop and Support key Client Mile stones

Migrated Database from ORACLE to Netezza

Designed and implemented ETL process for Unica Campaigns and “Ad-Hoc” reporting

Tuning SQL Queries and PL/SQL Packages

Managed customer projects

Created unica campaigns

Integrys, Chicago, IL, Dec 2011 – July 2012

Application Database Solutions Consultant

Designed and implemented WAM GAP tasks

Worked with team members both direct and indirect to share knowledge and to bring a fresh perspective to current design solutions

Identified potential areas to improve productivity for new team members.

Languages used, C# VS 2010, 2008. PL/SQL (PLSQL Developer)Oracle 10g, 11g, SQL Server, Crystal Reports Xi, Microsoft BI

Tuning Materialized Views

ETL Development

Managed client projects

Mitutoyo America Corporation, Aurora, IL, June 2010 - Nov 2011

Application Database Solutions Consultant

Designed and built the companies 1st B2B Website

Designed and Built company Business Intelligence Solution

Implemented and co-ordinate release of new CRM application

Languages used, C# VS 2010, 2008. PL/SQL (PLSQL Developer)Oracle 10g, 11g, SQL Server, Crystal Reports Xi, Microsoft BI

Performance Tuning, ETL Development

Managed client projects

Be Counseling LLC, Plainfield, IL, Dec 2009 – May 2010

Application Solutions Consultant

Full life cycle experience, duties included:

oEvaluated Software Vendors to host customer’s website

oResponsibilities included producing system requirements gathered through JAD sessions.

oDevised appropriate solutions with Business Stake holders.

oLead developer of Business Website (www.BeCounseling.com)

oDevised and conducted multiple tests on website to make sure the website met business specifications

oIdentified and resolved potential HIPPA violations in relation to patient data.

oDesigned and Implemented CPT codes database used to track patient services

oLanguages used Unix Shell Scripting, CSS, HTML, Java script, Microsoft SQL

BP, Warrenville IL. Sep 2007 – Nov 2009

Application Solutions Consultant,

Provide Technical and Business Support for a multitude of production Applications that support the management of trading oil products like Business Objects, Open Link Endur, risk assessments, tracking the physical oil movements, legal contracts, General Ledger, Profit and Loss, and receivables.

Develop production "work around" to current issue while a more permanent solution is being generated

Lead team to support with onshore / offshore and 3rd party vendors in order to resolve issues

Facilitate the release of software from between various environments including production

Developed Business Objects Reports in 5, 6 and Xi.

Worked on multiple n-tier applications such as Open Link Endur, Murex, Murex Limit Control, Documentum, Asset Control, Global Cargo Assurance System, and SAP PR4.

Languages used Java, Visual Basic 6, AVS Scripting, PL/SQL (TOAD), Unix Shell Scripting, DOS Batch Files and C#. Worked on Oracle 9i, 10g and 11i Databases.

Coordinated with teams to adhere to Data validation standards and rules used from incoming and outgoing data flows

Facilitated and conducted training of Offshore Production support team for the GCAS Project.

Consistently met the demands of working within the SOX mandate

Performed Quality control tasks on Meta Data produced from TIBCO middleware to a number of systems

ETL development with the Reference Data Warehouse

Terra Technologies, Norwalk, CT. Apr 2007 – Aug 2007

Application Database Solutions Consultant, (Real Time Forecasting System)

Evaluated Software products for use with Tracking issues

Developed new process flow to improve the quality of development based on the Analysis of Data.

Designed and implemented solutions for the enhancement of the Relational Transportation Forecasting system.

Analyzed logistics data to help modify the Physical Data Model met the demands of the Customer. Techniques used: data mining, business performance management, benchmarking, and predictive analytics.

Languages used Visual Basic 6, PL/SQL (TOAD), DOS Batch Files and worked on Oracle 9i, 10g and 11i Databases (TOAD / ERWIN), QlickView.

Coordinated with the sales team to understand the needs of the customer, while reviewing the actual logistical production data. This enabled for a more cohesive Logical and Physical design of the Database structures and PL/SQL code.

Managed client projects

First Health, 3200 South Highland Ave, Downers Grove, IL, Oct 1998 – Apr 2007

Application Database Solutions Consultant, (IRMS Internal Revenue Management System)

Full life cycle experience of various projects, duties included:

oEvaluated Software products for use with Oracle HR

oLead role in the design and implementation of PL/SQL packages for Reports.

oResponsibilities included producing system requirements gathered through JAD sessions.

oDevised appropriate solutions with Business Stake holders, Application development team and DBA’s to establish an appropriate logical Data model based on Business needs and Analysis of data while taking into consideration the demands of Application development.

oWorked with the DBA’s and Application Development team on the Physical Data Model of IRMS

oDevised and conducted multiple tests on OAT and Production data to ensure Data integrity between systems.

oIdentified and resolved potential HIPPA violations in relation to patient data.

oWorked with both Internal and External IT Auditors to reconcile any potential concerns that were presented.

oPerformed weekly inspections, design walk through, and reviews with the customer.

oCrafted testing strategies for tuxedo services used in the IRMS application.

oManaged a team for the development of ORACLE PL/SQL packages and Reports for IRMS

oCoordinated with multiple departments for the resolution of production support issues

oSuccessfully cross-trained the IRMS team on the development of new processes using PL/SQL

oCoordinated with new vendors to successfully implement outsourcing of printing and mailing of IRMS Invoices.

oAnalysis of Data in the MCPS / Patient Data Warehouse to identify and implement appropriate testing solutions in downstream IRMS system. This was to establish the Data integrity was maintained, ETL development

oLanguages used Visual Basic 6, C, PL/SQL (TOAD), Unix Shell Scripting, and PERL DOS Batch Files. Worked on Oracle 9i, 10g and 11i Databases (TOAD / ERWIN).

oDeveloped Tuxedo Services to produce Meta Data used by multiple Data warehouses from Patients records to claims processing.

oLead team in the Quality control of Data to and from IRMS.

oProduced a number of technical and user guides for using reports in the IRMS system

oManaged client projects

Publishing News Ltd., London, United Kingdom Jul 1996 - Sep 1998

TEAM LEADER / ASSISTANT DBA, (New Accounts Database)

Full life cycle experience of various projects, duties included:

oLead role in the architecture and development of a “New Accounts Database, (NAD)”.

oWorked with key Business stakeholders to establish the needs and focus the business on the reality of the Actual Business Data

oManaged a small team to develop a relational database in ORACLE.

oResponsibilities included producing system requirements gathered through JAD sessions.

oPerformed weekly status reports, inspections, design walk through, and reviews with the Accounts Department and the Database Team.

oDeployed a company wide initiative to represent Project Schedules using a “Bulls Eye” chart, reducing time spent in status meetings and increasing collaboration amongst teams.

oHelped the DBA with the installation of the ORACLE database.

oDeveloped Client / Server applications using Developer 2000.

oDesigned and implemented various FORMS and REPORTS templates for the team.

oTrained staff members from various departments on using the “NAD”.

oManaged customer projects

Intertech Plastics Ltd., Essex, United Kingdom Aug 1993 - Jun 1996

TEAM LEADER, (SAP to ORACLE Database, “SOD”) Apr 1996 - Jun 1996

Full life cycle experience of various projects, duties included:

oTeam lead responsible for the transition of “SAP to ORACLE Database”

oAssisted in the installation of the ORACLE Database.

oDesigned, implemented and tuned PL/SQL statements, which controlled various objects in the ORACLE database.

oDesigned the coding standards to be used on the ORACLE Database, for the team.

oDesigned and implemented various FORMS and REPORTS templates for use by the team.

oDeveloped Client / Server applications using Developer 2000.

oImplemented various UNIX Shell scripts.

oReceived SAP Programming at ESSO Petroleum Ltd.

oAssisted in the maintenance of the SAP database.

TEAM LEADER, (Automated Reports) Jun 1994 - Mar 1996

Assisted in the design of several reports for various departments.

Organized teams to generate “Automated Reports”, these reports are a combination of EXCEL spreadsheets, graphs and WORD documents. These reports are totally to be dependent on information that was stored on the SAP database.

Managed the team to emphasize cross training colleagues.

Designed and implemented various utilities written in C.

Responsible for maintaining and converting existing C programs to EXCEL macros.

PROGRAMMER, (Excel Macro’s) Aug 1993 - May 1994

Designing, testing and implementing of EXCEL macro’s, that import data from the SAP Database

Maintaining existing C++ programs.

Designing, testing and implementing UNIX shell scripts.

Relational Database

Oracle

MS SQL Server

Neteeza

ACCESS

Ingres

SAP

Programming Languages:

C#

PL SQL / SQL

VS2010

Ada

UNIX scripting

AVS Scripting

Java

Excel Macros

HTML

DOS Scripts

PASCAL

BASIC

GUI Tools:

Exceed

TOAD

Developer 2000

Visual Basic 6.0, 2008, 2010

Business Objects 5.0, 6, Xi

Telnet

Oracle Reports 2.5, 6.x, 10g

Crystal Reports Xi

QlickView

Erwin

Microsoft Business Intelligence

UNICA Campaigns

Methodologies: Life cycle models:

Jackson Structured Programming (JSP) Yourdon Water Fall

Jackson System Development (JSD) SASD Iterative Enhancement

Soft System Analysis SSA Spiral

ITIL Support PRISM GATES AGILE

EDUCATION:

Computer Systems Institute, Skokie,USA

Diploma – ORACLE

ESSO Petroleum Company, Ltd., London UK

SAP Database Programming

Thames Valley University, London UK

BSc Computer Science Degree modules’ - C++, C, Visual Basic, UNIX

University of North London, London UK

Higher National Diploma - Mathematics / Statistics / Computing

Contact this candidate