SUMMARY:

20+ years experience in Information technology, improving the bottom line, reducing company risk, revitalizing projects, delivering them on time and within budget. Managed teams and collaborated with key stakeholders. Client Verticals include Marketing, Health Insurance, Manufacturing, Non Profit among others. Consulted for CRM, Database, Application and Cloud solutions.

AREAS OF EXPERTISE:

• Leadership Team Building Relationship Building Communications Consensus Building
• Strategic Planning & Analysis Regulation Compliance Process Development & Improvement
• Consulting Vendor Management Project Management
• Data Analysis & Integrity Database Management Application Design & Testing Queries & Reports
• Database Development Website Development

DATABASE INFORMATION:

Reporting tools: MS Business Intelligence Business Objects Oracle Reports Crystal Report Power BI SSRS Reports

Database tools: SQL Developer MS SQL server SQL Client ERWIN TOAD

Database Developer information: Large Database development (Tb) SQL Server 2008/12, Oracle, Netezza Data - warehouse, campaign / report mart T-SQL, SSIS packages, ETL processes 3 Normal Form, Star schema Conversion of PL/SQL to T-SQL Reverse engineer SQL to create business requirements

TECHNICAL SKILLS:

Databases: ORACLE MS SQL Server Netezza ACCESS Ingres

Programming Languages: SQL PL/SQL T-SQL SSIS JAVA C# UNIX Scripting HTML AVS Scripting DOS Scripts Excel Macros

Specialized Tools: SilverPop Business Objects Microsoft Business Intelligence Oracle Forms/Reports Confidential Endur Crystal Reports Xi Power BI Exceed Visual Studio Erwin TOAD

Operating Systems: DOS VAX VMS Windows UNIX

Methodologies: PRISM GATES Water Fall Iterative Enhancement Soft System Analysis ITIL Support AGILE

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Technical Consultant

Responsibilities:

• Company has several ERP’s but no consistent global view.
• Designed, developed and deployed a universal BI reporting solution, that merged data from multiple ERP’s, which included business flexibility needed for strategic direction

Confidential, Memphis, TN

BI Solution Architect

Responsibilities:

• Consolidation of resources created a situation where Multiple reporting solutions needed to be maintained by a minimally resourced team
• Designed, developed and deployed a common flexible solution that allowed the 12 independent company business requirement to be managed by the central reporting team.

Confidential, Houston, TX

IFS Report Consultant

Responsibilities:

• Upgrade old custom IFS reports to work in the upgraded version of IFS
• Upgraded each report by adjusted required code to work in the new version of IFS

Confidential, Memphis, TN

Data Consultant

Responsibilities:

• Convert old campaign system, dynamic PL/SQL source code into Confidential campaigns.
• Reverse engineer code into business specifications.
• Produced a visual business process flow to enable clarity and agree on future state.
• Slashed resource time from 96 to 30 hours and saved company $217K.

Confidential, Schaumburg, IL

Solutions Consultant

Responsibilities:

• Client needed to update business rules and add new data sources under extremely tight turnaround.
• Led discussions with leaders to understand new rules and objectives, trained team on the maintenance of the solution within the timeline.
• Saved potential $100K in fines due to delayed customer deliverables.

Confidential, Bloomingdale, IL

CRM Application Solutions Consultant

Responsibilities:

• Client wanted to change tool sets and organizational process with lack of internal expertise and misaligned vendors, and faced a complete "rip out" after two years of no major deliverables.
• Built trust with vendor and business.
• Communicated with clients to understand their needs.
• Designed solution for external vendor to correct audience target levels.
• Created sessions in various locations with key IT resources, created Confidential templates and user manual.
• Product went live and saved $2M.

Confidential, Bensenville, IL

CRM Application Solutions Consultant

Responsibilities:

• Client had aggressive timeline to upgrade and convert campaigns. the client was four months behind schedule.
• Brought conversion schedule back on track by converting Confidential 8.6 campaigns to 9.1 and rewriting backend Shell scripts.

Confidential, Schaumburg, IL

Solutions Consultant

Responsibilities:

• Need to extend functionality of Confidential to include pre-calculated values on over 30M combinations.
• Successfully implemented 30M values, saving company over 500 hours and $55K yearly.

Confidential, Naperville, IL

Senior Program Manager

Responsibilities:

• Support teams overwhelmed with customer dissatisfaction.
• Customer might terminate $3M contract.
• Identified common support process, boosting productivity where support staff member could effectively manage 4.5 customers, saving $440K yearly.
• Designed, developed and implemented flexible campaign mart solution.
• Customer not only kept but renewed contract with $4.5M increase

Confidential, Chicago, IL

Oracle Application Consultant

Responsibilities:

• Client needed injection of fresh approaches to improve staff morale and team effectiveness. Identified fear from veteran employees of job security, so they were reluctant to share information. Junior employees were frustrated with limited opportunities to learn anything new and left business, creating high turnover.
• Empowered veteran employees as key stakeholders with sense of ownership to guide changes, share knowledge and make tangible changes.
• Junior employees had greater opportunities and satisfaction.

Confidential, Aurora, IL

IFS ERP Application Consultant

Responsibilities:

• Client and sales reps had issues with knowing current prices and stock levels. Turnaround times for some stock could take 7 months.
• Salespeople had different product prices, and information took several days to become available.
• Implementing a new CRM solution that would interface with the IFS ERP created the opportunity to leverage information needed for sales.
• Architected a website solution for sales and distributers to leverage appropriate data, which resulted in an 18% reduced sales cycle (approximately 4 days on average)

Confidential, Plainfield, IL

Application Consultant

Responsibilities:

• Client needed to move operations from PC and fax to digital automation claims processing.
• Designed a business process flow and integrated 3rd party software within HIPPA compliance.
• This enabled the client to Recover eight hours per week, boosting billable time by 20 percent and saving $500 per week.

Confidential, Warrenville, IL

Application Consultant

Responsibilities:

• Client needed highly technical consultant who is able to resolve second-level support issues surrounding oil commodity trades.
• Client not able to fill role with consultants with Confidential experience.
• Created decision trees to enable 1st Line support and user self support to resolve more issues when they arose.
• Conducted for offshore 1st line support to fully manage particular supporting software.
• Enabled client to maintain appropriate service level agreements with a smaller pool of Confidential link experts.

Confidential, Norwalk, CT

Oracle Forecasting Database Consultant

Responsibilities:

• Client faced reputation risk based on insufficient coverage in short term, needed highly technical ORACLE database developer to help service engineers implement appropriate customer solutions. Ramp up speed needed to be in days rather than weeks.
• Leveraging my technical skill and willingness to “go the extra mile”, the short term reputation risks where alleviated. To reduce these risks on a future basis created several key documents. Reduced on boarding by 60% approximately 13 days saved per employee