Technical Experience:

Mainframe

• HP UNIX
• IBM MVS
• Tandem
• AS/400
• VSE
• Solaris
• Honeywell/ Bull
• Open VMS
• AIX

Mainframe Applications

• CA - 7
• NDM
• CICS
• VTAM
• Legato
• Pathway
• BASE24
• AutoSys
• FUP
• Spoolcom
• CA-11
• Netbatch
• Batchcom
• JES2
• RUMBA
• TSO
• GLINK
• Shadowbase
• TMON
• NCP
• Out View
• SNA
• TEDIT

Networking Applications

• RAS
• WS Ping
• Netview
• Prognosis
• Hummingbird
• Terminal Services
• IPv4
• WS FTP Pro
• Big Brother
• Citrix
• Remote Admin

PC Operating Systems

• Windows 3.X
• Windows NT
• Windows 95
• Windows 98
• Windows XP
• X Windows
• Macintosh
• UNIX
• Linux
• OS/2

PC Software

• MS Word
• MS Excel
• MS Access
• OLAP
• COGNOS 7 Suite
• Business Objects
• MS Outlook
• MS Project
• MS Exchange
• MS Schedule
• Solomon
• Actuate
• Remedy
• Clarify
• JD Edwards
• Lotus Notes
• Crystal Analysis
• Oracle Reports
• SABA
• Impromptu
• Autosys
• Eudora
• Backup Exec
• Visual FoxPro
• Crystal Reports
• Seagate Info
• Tivoli
• Decision Stream
• Crystal Enterprise
• MS Visio
• Quintus
• CCMS
• CentreVu
• Exceed
• ERwin
• PageMaker
• Siebel
• Daleen
• ReCrystallize
• PhotoShop
• GASPER
• PowerPlay
• Sqribe/ Brio
• MS FrontPage

Telecommunications

• Frame Relay
• ISDN
• T-1
• T-3
• Siemnes 9000
• DSL
• DMS 250
• DEX 500
• POTS
• TFN
• Lucent CMS

Programming Languages

• Java
• SQL (Various)
• SQR
• Visual Basic
• JCL
• XML
• SAS
• RPG

Database Applications

• Informix
• MS Access
• Oracle
• SQL Server
• Sybase
• Btrieve
• DB2

Experience

Confidential

Chicago, IL

Business Intelligence Architect

Confidential

• Developed an As-Is perspective of the business intelligence environments within Pan-IST and Global Oil. From those As-Is perspectives, developed roadmaps on future development of the business intelligence architecture through adherence of standards and processes.
• Created a Center of Information (COI) for the Informatica shared service environment (ISE), where I gathered all BP ETL data integration and development standards for Informatica and created a forum so that those resources could be shared.
• I also routinely do PoC projects where I demonstrate the use of certain technologies. One such successful PoC was help building a prototype of Metadata Manager where we imported metadata from separate sources (PowerCenter, BusinessObjects, Oracle, SAP and IL3) for the TCT project.
• I am currently leading the BusinessObjects best practices BP wide. Duties for this position include maintaining the BusinessObjects Sharepoint collaboration site, schedule and moderate monthly meetings within the entire BP organization.
• A large portion of my duties include developing business intelligence strategies for a number of projects. Business intelligence strategies include data modeling, data management plans for ETL processes and query/ analysis reporting off of the business data.

Successfully implemented and designed business intelligence solutions for several clients, including Confidential

While at Confidential, I setup several best practices on utilizing both Cognos and Ab Initio. The work included creating process models and developing examples through a proof of concept. The process models that I created consisted of the full life cycle of the data, from the atomic application data to the front of the Cognos Reports.

At Confidential, I successfully reviewed and implemented an as-is layout of their SAP BusinessObjects environment and made recommendations on improvement of processes. Recommendations included server configuration, .Net integration and standards of BusinessObjects development.

Confidential

Chicago, IL

Senior Solutions Architect

Worked with the Global Major Accounts (GMA) for the Life Sciences industry. Architect and managed Confidential installations for several large healthcare and pharmaceutical companies. Ensured that proper exposure of Confidential BI tools were properly deployed and managed and that data management was properly optimized and that reporting requirements followed HISPC, AHRQ and ONC standards.

Confidential

Chicago, IL

Managing Consultant

Worked as a business intelligence architect, primary clients were with large healthcare organizations (Confidential). My duties included architecting and designing business intelligence platforms (COGNOS & BusinessObjects) and data transformations (Informatica) into large ERP applications such as SAP, PeopleSoft, JD Edwards and Lawson and ensured that they maintained HISPC standards.

Confidential

Chicago, IL

Architect/ Engagement Manager

As an Engagement Manager I acted as a liaison between the client and BusinessObjects. I managed several projects and resources at any given time, including working as a resource manager. As an architect, I spent most of the time delivering complex business intelligence and data management projects. Projects included large billing and claims programs within the Healthcare industry. Specialized in business intelligence within the regulatory standards of HIPAA.

Independent Contractor

Confidential

Chicago, IL

Database Administrator

Short Term Contract- Creating a Crystal Enterprise network with several servers clustered. Also creating their entire OLAP & relational Oracle reporting data model using Informatica. Duties include being a senior Crystal Report writer, OLAP architect and Crystal Enterprise architect. Reporting data sources were specifically PeopleSoft Financials and custom Oracle applications.

Confidential

Chicago, IL

Database Administrator

Short Term Contract- Created 20 Crystal Reports for a J2EE environment. All reports were written Arabic and using metric style paper.

Confidential

St. Louis, MO

Senior Consultant

Worked with several clients with their reporting systems. Brought in over $500K of new business in through seminars and other marketing campaigns. Established and maintained several partnerships with Crystal Decisions, Consulting, Training and Enterprise (Product Sales) partnerships. Created SQL Server & Oracle data warehouses & OLAP cubes, utilized ETL tools such as COGNOS DecisionStream, Oracle Data Warehouse Builder, Informatica, DTS and Hummingbird. Created triggers and stored procedures in order to maintain data warehouses. Trouble shot issues through SQL server commands. Administered several ERP & CRM (BAAN, Great Plains, Lawson, Microsoft CRM & Siebel) solution installs. Mentored and trained 12 consultants in getting their Crystal Report certification. Created reporting for companies through Crystal Reports & Analysis, Actuate 7 or COGNOS Impromptu & PowerPlay. Created best practices to report off of ERP databases, PeopleSoft 8 & SAP. Clients included Monsanto, Anheiser Busch and Purina.

Independent Contractor

Confidential

St. Louis, MO

Database Administrator

Short Term Contract- Create entire intranet reporting structure, using Crystal Reports 8.5, SQL, Crystal Enterprise and PHP scripting off of Access and SQL Server databases for Solomon accounting software and proprietary software. Created data store between Great Plains, Lawson, HMS (AR Software program) and Product deliver tool. Created DTS, Transact-SQL, stored procedures and triggers to extract and validate data in the data warehouse through SQL Server 2000 and 7.0. Also administrated an Oracle database that housed the ADP database. Created several extracts through Oracle stored procedures to feed into the SQL Server data store.

Confidential

St. Louis, MO

Midrange Specialist

Short Term Contract- Subcontractor that monitored & administered 3500 midrange servers on WAN (servers are NT, Exchange, VAX, UNIX, SAP). Reported troubles with backups (Backup Exec) or events in Event Manager in MacAfee Problem Management. Monitored Informatica processes and ensure that they completed successfully. Created Crystal Reports to monitor Backup Exec devices, SAP logs and event viewers on NT servers on 2000+ servers worldwide.

Confidential

Chesterfield, MO

Database Analyst

Short Term Contract- Create several Crystal and Actuate reports on several application databases (Clarify, PeopleSoft Financials, Daleen, Siebel, OMS (Order Management System), Netcool and TBS). Complete reports in certain deadline period and also on an ad hoc basis. Created \\\"Crystal Reports Best Practices\\\" technical writing for entire company to serve as guidelines to using Crystal Reports. Administrator to SQL Server and Windows NT 4.0 Server. Created several Oracle stored procedures to create reports from Daleen billing system. Server primarily use is as a reporting server, with Actuate, Seagate Info and Crystal Web Server services installed. Also working with MS IIS server system. Created a reporting intranet for company where reports are available via Seagate Info or by ASP scripts calling various reports.

Confidential

St. Louis, MO

Computing Services Analyst

Programmer/ Analyst for many departments. Work with batch jobs in AS/400 and UNIX network. Utilized Seagate Crystal Reports and COGNOS to report off of various databases and tables on PeopleSoft 7.5. Query AS/400 network, using RPG. Created and administered Informix, Oracle, Access and Tivoli databases on UNIX and Windows NT platforms. Administered Seagate Info and helped tie interaction with Exchange Server. Scheduled jobs for data warehouse in Autosys and COGNOS DecisionStream. Technical owner for Knowledge Base products. Helped create several proof of concept applications, including SABA, Tivoli & Novo. Integrated Knowledge Base software into Crystal Reports and Holos data cubes. Utilized networking software such as Exceed to connect to UNIX platforms, and Hummingbird to transfer files from UNIX to Windows NT environment. Work heavily with Lucent ACD switch Informix database, and creating reports with Crystal Reports and CentreVu. Created several Informix views on massaged data, for business loyalty programs and insurance replacement programs.

Independent Contractor

Confidential

St. Louis, MO

Computer Operator

Short Term Contract- Subcontractor that worked on several MVS platforms. Ensured that batch jobs in CA-7 ran successfully and in a timely manner. Also corrected any JCL errors in batch files. Ran If could not resolve issue, escalated to higher tier of programmer.

Confidential

St. Louis, MO

Production Control Technician

Short Term Contract- Worked on a Honeywell/ Bull and Tandem mainframe environment. Was in charge of making sure that batch and production jobs were successfully sent to clients, vendors and other platforms, via SNA, NDM, BFX or FTP. Created Crystal Reports and SQL queries against Remedy CRM. Corrected troubles myself, or if needed escalated, I would call on-call support in various departments.

03/99

Confidential

St. Louis, MO

Tape Operator

Short Term Contract- Supported production control with Y2K testing, and coordinated tape mounts by request. Reported any troubles to on-site supervisor or on-call programmer.

Confidential

St. Louis, MO

Network Support Analyst

Short Term Contract- Remedied troubles in a trouble ticket tracking system called Quintus. Troubles included network troubles with network software applications, shared modems, network connectivity, hardware troubles and/ or user customer service.

Confidential

St. Louis, MO

Tandem Production Control

Short Term Contract- Was in charge of making sure that Tandem production and batch jobs were successfully processed. Created reports of previous 24 hours troubles. Entered trouble in Tivoli database.

Confidential

Maitland, FL

Lead Operations Coordinator

Operated, monitored, and maintained mainframe software and hardware. Monitoring functions included network management through Netview 6000. Processed banking transactions from a network of ATM’s from several financial institutions. Also checked batch job’s JCL in Tandem or IBM MVS network. Was part of the movement group, in where we chose network providers based on cost, reliability and network. Proficient in mainframe software packages for Tandem and IBM mainframe systems, such as OpenVMS, Spoolcom, Netbatch, PUP, FUP, TMON, TCOM, BASE24, CICS, TSO, CA7, NDM. Worked with numerous networking applications, OpenView, NetView, Worked with SNA Classic, which monitored frame relay lines through VTAM. Entered and reported (Crystal Reports) trouble tickets in a GASPER and Remedy database. Also worked with IP addresses in IPv4. Performed WAN maintenance on Windows NT and Novell network. Maintenance included tape backup, user administration and connectivity issues.

Independent Contractor

Confidential

Orlando, FL

Technical Consultant

Short Term Contract- Automated price control sheets, resolved production troubles, and overall software consulting with Crystal Reports (reporting off JD Edwards Home Builder Management Solution), MS Access, JD Edwards, MS Excel, MS Word and MS Outlook.

Confidential

Orlando, FL

Inventory Support Coordinator

Short Term Contract- In charge of claims support and damage warehouses for entire state of Florida, updated history reports to forecast purchasing of HVAC equipment. Worked on migration plan (cost analysis) to consolidate several distribution warehouses in one central location. Worked with complete MS Office Suite extensively. Set up masters and prices for equipment. Created Crystal Reports on status of damage claims, which ended up getting $1.5 million on ROI per year.

Confidential

Orlando, FL

Senior Repair Customer Service

Provided technical support for customers dealing with ISDN (PRI & BRI), T1, T3, data communications, Travel Cards, Frame Relay, toll-free service and switched services (DEX 500 & DMS 250). Entered trouble tickets in RUMBA system on AS/400, and in Clarify system, reported call center statistics from Lucent ACD and Clarify CRM in Crystal Reports and COGNOS Impromptu. Completed JD Edwards proof of concept and implementation. Updated AS/400 database, user files. Operated UNIX based DEX 500 and DMS 250 telecommunications switches. Made sure Windows NT ethernet WAN & LAN was in working order, and reported any trouble to on-call manager through paging system.

Confidential

Columbia, SC

Military Police

911 Team Leader, in charge of 15 + soldiers in a 911 call center. Duties included scheduling, technical training, management cost analysis and physical training. Also was in charge of NCIC, Motorola Dispatch and post security system. Queried against criminal statistics database (MS Access) using SQL and Crystal Reports 4.5.