PROFESSIONAL SUMMARY:

• Senior Data Consultant/Database Modeler/Database Developer/Data Analyst originating in DB2 ( ), SQL Server (2005), Teradata ( ), Oracle ( ), and MS Access ). Business Insurance Analyst ( ).
• Experienced in virtually every Information Technology Role; Project Lead, Technical Lead, Business Analyst, Database Developer/Modeler, Application Developer, Data Analyst, Quality Assurance Relational Database Environment Manager, Liaison to DBA and Data Architecture, Supervisor of 3 - 8 Resources, Mentoring Colleagues, Partnering with Offshore talent.
• Responsibilities include; Collaborate with Business Clients during Requirement Gathering, Data Definition, Defining Business Rules, and Use Case Specification. Design and Development of Resilient Solutions, Logical Data Modeling and Physical Database Design, Data Analytics, Designing and Developing Relational Databases objects (Tables, Views, Triggers, Packages, Procedures and Functions), Performance Tuning, Data Migration/Transformation, and Population (ETL), Quality Assurance Environments Management, Data Scripting, Unit Testing, Integration Testing, System Testing, and Implementation.

TECHNICAL SKILLS:

SKILLS:: Teradata Database(Version 14) Developer/Modeler utilizing TDA and BTEQ Designed and Developed Tables, Views, and Stored Procedures. Oracle Database (versions 7.3 - 11g) Developer/Modeler Designed and Developed Tables, Partitioning, Views, Materialized Views, Packages, Stored Procedures, Functions and Triggers utilizing Toad, SQLDeveloper, and SQL*Plus, Oracle PL/SQL Tuning, External Tables, Export/Import, SQL*Loader, ETL, Unix/Linux, KSH Scripting. Microsoft .Net C#, XCOMNT DB2 ( versions) QMF, SPUFI, CICS, COBOL II/COBOL, XPEDITER, MFCOBOL, XCOM, SAS, Easytrieve Plus and IDMS, Microfiche.

PROFESSIONAL EXPERIENCE:

Confidential, Codes Elgin, IL

Microsoft Access Database Modeler/Developer

Responsibilities:

• Sole IT Resource Fulfilling EVERY Role; Business Analyst partnering with Business Owner, Master of Inspection Codes, Lead Field Electrical Inspector, and Business Client; ComEd. Database Modeler/ Developer Designing Inspection Quality Assurance Schema in MS Access 2013.
• ComEd installing 4.2 million Residential Smart Meters, requiring accredited Quality Assurance Inspections.
• Inspection metrics documented in Pivot Reports. Inspection Violations captured in photographs stored in BLOB column. Inspection failures and successes traced through meter address reports.

Confidential, Chicago, IL

Oracle 11g Senior Database Developer

Responsibilities:

• Oracle 11g PL/SQL Developer of custom modular stored procedures packages to communicate Licensing Application Status to the City of Chicago Small Business Consultants, Zoning and Licensing Inspectors, and Respective Small Business Licensing Applicants. Automation of Business Applicant’s pertinent data with various HTML Email Templates (CLOB) in order to expedite communications required in the workflow process for Small Business Licensing in the City of Chicago.

Confidential, Chicago, IL

Oracle 11g Senior Database Developer

Responsibilities:

• Oracle 11g PL/SQL Developer of custom highly tuned real-time, complex and modular stored procedures/packages to populate and maintain a new in-house developed SNAP™ Auction Trading Database and On-line Application for Regulatory Monitoring and Enforcement as mandated by the Securities and Exchange Commission.
• Develop processes to regulate specific business rules used to identify illegal trading by firms and brokers. These procedures were used to maintain the database, gather statistics, and pass data to a Java based Web Application (PL/SQL Stored Procedures, XML, and VAX). Toad, SQL*Plus.

Confidential, Chicago, IL

Teradata Database Developer/Modeler - Data Warehouse

Responsibilities:

• Developed Teradata Tables, Views, and Stored Procedures for ETL Processing within Global Commercial Card Data Management. Merchant Card Acquiring Bank Transactions, and related Data Stores housed in a Teradata Data Warehouse Environment (CCDW) viewed through a Business Objects Universe.
• User Defined Business Application conversion project to transform Business Analyst Desktop Applications to a Production Level Environment. Business Applications: Master Card Fraud Events and respective transactions, HR Employee and Department Hierarchy.

The Confidential, Chicago, IL

Oracle-DB2(COBOL) Senior Database Developer

Responsibilities:

• Responsible for Enhancements/Modifications to Unix-Linux (KSH) Oracle, Mainframe Cobol/DB2 and JCL of Internal and External Data Feeds Populating Oracle Databases (ETL: SQL*Loader/External Tables) for Client Portfolio Portal Applications: Wealth Passport and Private Passport.
• Data Integrity Project resolved Data Discrepancies on disparate Relational Database Systems and latency issues observed between Monthly Reports and their Portal Applications employing Composite Virtual/Federated Database.
• Linux and Oracle 11g Upgrades.

Confidential, Schaumburg, IL

Application Developer

Responsibilities:

• Short term contract modifying Unix KSH with embedded Oracle SQL statements for US Payroll application, required to align with their General Leger upgrade project.

Confidential, Northbrook, IL

Oracle-DB2(COBOL)-SQL Server Application DBA/Senior Developer/Modeler

Responsibilities:

• Agent’s Interactive Web Application was originally developed in Microsoft.Net and replatformed on IBM Portal J2EE. Redesigned and created new Oracle Objects for a Service Oriented Architecture (Web Services) in less than 3 months.
• Collaborate with Business Clients during Requirement Gathering, Data Definition, Defining Business Rules, and Use Case Specification (UML Diagramming).
• Modeled and Developed Oracle Transactional, Analytical, Authorization, and Look-Up Tables.
• Designed and Developed Agency Distribution Oracle Backend Processing for Web Applications.
• Bonus and Incentive Publication Application releasing Agents Monthly YTD Actuals as Authorized by Business Clients.
• Designed Agent Incentive Interpolation Tables. Proposed Quality Assurance Backend Interpolation Testing, avoiding clicking through Interactive Web Application to test formulas for all possible values, as a repeatable cost saving testing methodology.
• Leveraged Oracle’s Analytical Ranking Function to Validate Proper Range Values in Agency Distribution Incentive Metric Tables.
• Export/Import, SQL*Loader, and Scripting were utilized for Data Migration and population efforts.
• Designed and Developed Quality Assurance Test Data Environments Currency Process (ETL). I mentored the newly created Agency Environments Team to accept this responsibility. Mentored Agency Environments Team on Oracle Production Installation Scripting.
• Engaged Enterprise Level Data and Domain Architecture Groups to address performance issues experienced in Service Oriented Architecture based on Project Schema Boundaries.
• Oracle Gateway leveraged to Materialize View of DB2 Region, Territory, and Market Agent Structure.
• Oracle Stored Procedures and Functions Tested utilizing Toad, SQL Developer, and SQL*Plus Scripting.
• Visual Explain utilized to tune Queries.
• Erwin leveraged to explore existing schemas.
• SQL Server Data Modeling and T-SQL Code Reviews.
• Extensive DB2 Utilities Experience including Image Copy, DSN1COPY, Recovery, Reorg, Repair, Runstats, Check Data/LOB, and FASTLOAD.
• Designed and authored .Net Services to Publish and Subscribe Messages from See Confidential /TIBCO and XCOMNT for Windows Server Solutions.
• Proprietary Knowledge transitioned to Onshore and Offshore Resources in an effort to reduce Payroll Expense.

Confidential, Chicago, IL

Project lead / SQL Server Developer

Responsibilities:

• BrioQueries, written by the business community, and Stored Procedures, written by Information systems, are retained in the Data Warehouse (SQL Server).
• The implementation of this concept allows the client to significantly reduce their storage requirements. Also, this solution provided indefinite reusability of work, instead of a Dated Results Set.

Confidential, Estates, IL

Oracle-DB2(COBOL) Developer/Modeler - Data Warehouse

Responsibilities:

• DB2 Operational system analysis was performed writing SQL (QMF) to identify data source attributes.
• DB2 Extraction-Transfer-Load (ETL) was accomplished via Legacy Data Mover (LDM) and SQL*Loader to populate Oracle atomic tables via XCOM.
• Oracle Packages, Stored Procedures, and Functions (SQL*Plus Scripting) were created and invoked by Korn Shells using XCOM on the HOST in the Production Environment.
• Actuaries utilized BrioQuery to establish the Earned Premium formula. Actuaries performed analysis writing BrioQueies, utilizing the Pricing Marts and Claim Marts.
• Developed the relationship between the Pricing Data Mart and Claim Data Mart for current rate level analysis, establishing loss ratios.
• Business Analyst performing HUON Data Analysis in the creation of the Pricing, Finance, and Marketing Data Marts.

Confidential, Lake Forest, IL

DB2(COBOL) Database Developer

Responsibilities:

• Analysis along with programming, JCL, and utility modifications concluded with implementation. Installation of package upgrade required enhancements/modifications to the client’s customized General Ledger software.
• Software languages/utilities: CICS, DB2, QMF, SPUFI, COBOL II, Easytrieve Plus and IDMS.

Confidential, Riverwoods, IL

Oracle Database Developer (MicroFocus COBOL)

Responsibilities:

• Confidential, Inc. (Credit): Employing MFCOBOL/Oracle under UNIX, enhancements were made to the Private Issue brand of the “Card Member Posting and Billing System”.
• New contract terms level activated provisional rate for delinquent accounts. Cash Back Bonus option was capped by restructuring incentive tiers.
• Analysis, design, detail specifications, programming, testing, and implementation were performed for those enhancements.
• Production problem analysis and resolution was also performed.

Confidential, Hoffman Estates, IL

DB2 (COBOL) Database Developer and CICS

Responsibilities:

• Confidential (Credit Card): Utilizing APS in an Real-time environment (CICS), developed, maintained, tested, and implemented a major enhancement to the Customer Credit Information System (“FOCIS”). This promotional program known as "REWARDS" allows Confidential marketing department to analyze a customer incentive program based on various point tiers in five different U.S. markets.
• Software languages/utilities: CICS, DB2, QMF, SPUFI, COBOL II.

Confidential, Abbott Park, IL

Oracle-DB2(COBOL) Database Developer/Modeler and CICS

Responsibilities:

• Authored SQLWindows/Oracle Promotional Budget Tracking Application of Pharmaceuticals to Physicians. Designed and created Oracle Data Stores. Oracle PL/SQL Tuning.
• Authored an application ("GVR") employing APS/DB2, both Real-time and batch, establishing pharmaceutical prices and government reporting.
• Authored CICS/DB2 applications and DB2 stored procedures (COBOL) for (“IPA”) rebates to managed health care groups. DB2 Utilities developed for various Application Systems.
• Created database structures (DB2) for multiple application systems.

Confidential, Long Grove, IL

DB2(COBOL) Database Developer/Modeler and CICS

Responsibilities:

• Designed and created production database structures for “Consumer Complaint System”. Supervised 3 programmers as technical lead, providing clients with personal lines insurance exposure information in report and record format.
• Designed systems and authored applications involving auditing and accounting functions. DB2 Ad hoc Reporting on Massachusetts Personal Lines Business for divestiture purposes to Company Officers.
• Automated Reinsurance and Ocean Marine accounts receivable loss information systems for the financial accounting department.
• RACF Coordinator, authorizing and auditing MIS Application Access.
• Microfiche Report Programming of MIS Master Kind Controls for Underwriting Exposure and Actuarial Analysis.

Confidential, Palatine, IL

Application Designer/Developer/Modeler

Responsibilities:

• Designed and authored an Independent Insurance Agency Information System written in Basic 1.0 on an IBM PC XT: Accounts receivable and payable, Escrow Account management, invoicing, premium trust credit reporting, account current discrepancies, comparing earned premium against premium paid, renewals and suspense items.
• Illinois Insurance Producer Licensed in 1980 (Property/Casualty, Life/Health), lapsing in 1991.