SUMMARY:

• Seek a challenging position that will utilize my 20+ years of IT experience in roles as Project Manager, DBA, Data Architect, ETL Architect, and Reporting

TECHNICAL SKILLS:

Databases: ORACLE 7.3 - 11gR2, TERADATA, NETEZZA, SQL SERVER, MS ACCESS, SYBASE, REDBRICK

Database Languages: SQL, PL/SQL, BTEQ, Transact SQL (TSQL), Embedded SQL

ETL: INFORMATICA Power Center and Power Exchange (Change Data Capture), SQL Server Integration Services (SSIS), SQL Server DTS (Data Transformation Services)

Reporting Tools: OBIEE, SQL Server Reporting Services (SSRS), Excel, Hyperion Designer (Brio Query), SAS

Data Modeling: Conceptual, Logical and Physical designs of Dimensional and Normalized Models

Data Modeling Tools: Erwin, Power Designer, Oracle Designer, Visio, Enterprise Architect

Programming Languages: C, C++, C#, JAVA, Visual Basic, VBA, SAS, CORBA, ADO, ASP, .NET, PASCAL, FORTRAN, COBOL,XML

Scripting Languages: Korn shell, Bourne, C shell, VBScript, Tcl/Tk, Perl, CGI, HTML, Sed, Awk, Nant, JavaScript

Operating Systems: UNIX ( SunOS, Solaris, Hp-Ux, DEC Alpha ), Linux (Red Hat, Suse)

Application Frameworks: XView, Motif, X11, XVT, PV-Wave

IDE’s: Microsoft Visual Studio, Microsoft Visual Basic 4/5/6.3/2005/2008 , Borland C++, Borland JBuilder 2, Symantec Visual Café 4 expert ed., Toad, Sylvain Faust SQL Programmer, Forest and Trees

Configuration Mgmt: CVS, SCCS, PVCS, Remedy, Visual Source Safe

Digital Electronics Design Tool: Mentor Graphics

Billing Systems Data: CSG, Cable Data, CCS, CICS-MVS, HIPAA X12 XML

Security Classification: SSBI (debriefed Feb 2002)

PROFESSIONAL EXPERIENCE:

Confidential, Aurora, CO

System Engineer - Data Architect

• Collaborate with team members to update documents that give direction to all technical teams throughout the program
• Collaborate with dba, sys admin and engineering teams to collect storage needs of the program for all environments
• Collaborate with engineers to collect and document message sizing

Confidential, Englewood, CO

Data Warehouse - ETL

• Collaborate with team members to design solutions for data issues and enhancements
• Modified and deployed Sql Server 2014 SSIS mappings to Test
• Collaborated with QA to ensure quality of product
• Utilize Jira to maintain status of tasks

Confidential, Denver, CO

Data Warehouse

• Create the processes for the migration of the Client’s Oracle Data Warehouse environments to the Cloud
• Created the Oracle Databases on top of ASM for the GDW on AIX servers
• Created Oracle Databases for Informatica change data capture (CDC)
• Installed Redhat linux on VM servers for the creation of the Business Intelligence Competency Center (BICC)
• Created the Oracle data warehouse, application, CDC and repository databases for the dev, qa, uat and prod environments of the BICC
• Performed and created the processes for the cloning of the Database, ETL, CDC and OBIEE servers for each environment
• Provided Redhat Linux System Administration support for the Database, ETL, CDC and OBIEE servers
• Provided Oracle DBA development and 24/7 on call production support (physical and virtual) for the Global Data Warehouse Project (GDW)
• Worked within VmWares’s Vsphere Client to configure servers and for troubleshooting performance issues
• Provided Informatica PowerCenter, Power Exchange, Admin Console development and production support for the GDW project
• Provided Oracle OBIEE and DAC development and 24/7 on call production support for the GDW project
• Monitored and Maintained nightly Casino ETL Applications utilizing SSIS and SSAS on Sql Server 2008R2
• Performed Sql Server DBA tasks to migrate Data Warehouse and applications to a new Server
• Mentor Juniors and provide strategy for tasks at hand

Confidential, Greenwood Village, CO

Data Warehouse - Oracle Analysis

• Performed an Analysis and Recommendations on their in-house Oracle, Informatica, and Reporting architecture and processes
• Interviewed Sr. Managers, Data and ETL Architects, System Architect, DBA’s, Business Analysts
• Prepare presentation with key findings and suggestions for Higher management

Confidential, Richmond, VA

Data Warehouse - Teradata Analysis

• Performed an Analysis with recommendations on their in-house Teradata system and future Big Data needs to extend the life of their system and reduce costs.
• Interview System personnel including Sr. Managers, Teradata DBAs, BAR managers, Business analysts
• Review & Analyze system Architecture
• Review & evaluate existing hardware
• Review & analyze current Backup & recovery
• Review & Analyze current Hadoop architecture
• Trending analysis to evaluate future growth
• Recommend alternative methods to off load users and resources from existing Teradata to extend their investment and reduce costs
• Prepare presentation with key findings and suggestions for Higher management (Vice president & Director)

Confidential, Richmond, VA

Data Warehouse - New Data Warehouse

• Team Leader of the Data Architecture team
• Interview System personnel including Managers, DBAs, Subject Matter Experts, Business analysts
• Review & Analyze system Architecture
• Review & Analyze Architecture of multiple individual subject areas
• Physical and Logical Modeling guidance and mentoring to Architects.
• Provide and review DDL,DML and Erwin Architecture documentation
• Performed a corporate wide Oracle Database Licensing Analysis Study

Confidential, Englewood, CO

Data Warehouse - New Data Warehouse

• Install and configure Informatica Power Center on Dev, Test and Prod UNIX Servers.
• Install and configure Informatica Power Exchange on Dev and Test Servers.
• Install and configure Oracle DAC to work with Informatica Dev, Test and Prod UNIX Servers.
• Created Unix Korn Shell scripts to perform various Netezza Database DDL and DML tasks.
• Install and configure Informatica Power Exchange Navigator Client to create capture registrations on Oracle 10g/11g Databases.
• Modify existing Informatica mappings to utilize Power Exchange sources and Oracle and Netezza targets.
• Created Oracle PL/SQL Stored procedures to manipulate the creation and configuration of Informatica objects.
• Modified existing ASP.net corporate employee website.

Confidential, Englewood, CO

Data Warehouse Triage Reporting Group

• Write Teradata BTEQ scripts and Oracle PL/SQL scripts to extract customer and equipment data based on input files.
• Performance tune Oracle 9.x SQL queries for team members to run against CSG Vantage database
• Write numerous Oracle and Teradata SQL queries to satisfy reporting requests.
• Write numerous Brio queries using Oracle and Teradata.
• Create user-defined functions for Teradata to emulate Oracle sql functions.

Confidential, Englewood, CO

Database Administration Group (Denver Market Call Center)

• Wrote VBScript to extract customer and equipment data from Oracle tables based on input files.
• Performance tune Oracle 9.x SQL queries to run against CSG Vantage database
• Assess/make suggestions for  performance improvements on ‘SalesByChannel’ SQL Server/Access database and reporting project
• Modified and Wrote numerous VBA Macros to automate the manipulation of real-time CSG customer, billing and equipment data via the CICS-MVS 3270 terminal entry application (CCS - Cable Control System) by utilizing CCS Transactions for multiple Projects.
• Create SQL Server Stored Procedures to update the Rachis and Net Mgr databases
• Modify and Enhance the MS Access 2000 database project Net Mgr using VB 6.3.
• Modify the zport VBA Macro and XSLT style sheet that generates an XML web page to display ADS Headend port problems to the NOC.
• Modify and Enhance the Sales Channel Reporting web pages to include the new digital voice product using Visual Studio, ASP, C#, and SQL Server Stored Procedures
• Train team members on using SQL Server 2005 Reporting Services.

Confidential, Englewood, CO

Decision Support Systems Group a.k.a. “the Data Warehouse” (West Division Headquarters)

• Create an Automated daily Excel Report using ORACLE PL/SQL, PERL, Korn Shell, and CRON that gathers database metrics to show data quality issues in multiple databases.
• Create an Automated daily Excel Report using ORACLE PL/SQL, PERL, Korn Shell, and CRON that gathers database user statistics and SQL execution statistics using the STATSPACK module to look for performance issues.
• Performance tuned team member’s SQL queries using oracle hints, partition selection, parallel processing and proper join methods.
• Created numerous adhoc oracle SQL Reports using CSG and DTS (cable data) billing and telephony data for Data Analysis purposes.
• Wrote VBScripts to extract customer and equipment data from Oracle tables based on regional market’s input excel files.
• Wrote a Korn Shell with embedded Perl application that monitors and gathers pertinent metrics on hundreds of incoming data feed flat files.
• Created an IP lease DHCP server monitor that emails out when a server is inactive over a specified amount of time.
• Maintain multiple Access Database Application and Excel VBA macros.

Confidential, Littleton, CO

Senior Database Developer/Analyst - Contractor 

• Created complex Finance and Billing invoice web reports using SQL/TSQL, C#,MS Visual Studio and MS Reporting Services
• Establish processes, policies and procedures for the creation of a new company-wide reporting group
• Created audit reports using ASP, ADO, VB, VBScript and MS Web Matrix
• Created and schedule DTS jobs to perform a variety of tasks
• Created a VB, ADO and ASP web application to transfer DTS packages between servers
• Designed and create a daily DTS job that automatically creates the target database schema and extracts, transfers and loads (ETL) over 300 tables from an Oracle 8i/9i database into a SQL Server 2000 database
• Work with and extract HIPAA X12 XML based billing data and XML based Reporting Services .rdl files
• SQL Server installation and administration tasks
• Created an automated process that notifies users of any database schema changes
• Create adhoc SQL/TSQL queries and stored procedures in both Oracle 8i/9i and SQL Server 2000
• Create NANT scripts to automate report and project production pushes from source control
• Create application design and documentation using UML process with Enterprise Architect

Confidential, Englewood, Co

Sr. Database Developer/Sr Data Analyst - Contractor

• Designed, Developed, and Automated the Duplicate Mac Address Report, using ORACLE PL/SQL, PERL, Korn Shell, and CRON; to identify HSD equipment system registration discrepancies in CSG within and across markets.
• Gathered Requirements and Designed the Project data flows for the High Speed Tiering Report Project.
• Designed and Developed ORACLE Tables and their Indexes for use as a Staging area for the NEW High Speed Tiering Project, which is offering subscribers High Speed modem data speed choices (UltraLink, ChoiceLink, SelectLink) in selected Markets across the country.
• Create an Automated daily Excel Report using ORACLE PL/SQL, PERL, Korn Shell, and CRON for upper Management, and affected Customer Care Offices, that is based on CSG Billing service codes, and ATT SAS Provisioning database IP service level data, to find inconsistencies in both databases, during and after the launch for each affected market.
• Optimized SQL Queries for other developers using Explain Plan and Toad, and suggest new Indexes for Data Warehouse tables.
• Created hundreds of Adhoc Excel Reports using Oracle and Access.
• Gathered Requirements and Designed the Project Data flows for the Proprietary Modem Swap project.
• Designed and Developed ORACLE Tables and their Indexes for use as a Staging area for the Proprietary Modem Swap project, which will replace all active subscriber Non-DOCSIS modems with New Motorola DOCSIS modems.
• Collaborated with the Hardware Engineering group to obtain requirements and proprietary modem information, and help identify node-mapping problems.
• Extracted Modem and Customer data for the proprietary modem project from the Data Warehouse’s ‘CDB’ ORACLE database and from Billing Operation’s ‘Cable Tools’ ORACLE Database and SQL LOADER the data into the staging area for further Analysis and Reporting.
• Created EXCEL Reports and lists for upper management and for those affected markets by laser group of those subscribers that have proprietary modems.
• Designed the Project Data Flow in VISIO 2000 for the High Speed Modem Reconciliation project.
• Designed the Test Flow, and conducted the testing for the High Speed Modem Reconciliation project.
• Gathered Requirements and Designed and Developed over 30 ORACLE Tables plus their Indexes to use as a Cleanup and Migration staging area for an over 600,000-subscriber High-Speed Modem Reconciliation project.
• Extracted Pertinent Modem and Customer Data based on CSG billing service codes using FOREST AND TREES, from various ORACLE sources and loaded it into a MS ACCESS Database for pre-Analysis and requirements gathering.
• Gathered Requirements, Analyzed and Extracted Pertinent Modem and Customer Data using TOAD and SQL Scripts from an ETE Provisioning (ORACLE 8 REMEDY) Database, ORACLE 7.3 CSG Vantage Billing System and SQL LOADER them into the ORACLE 8i staging area.
• Collaborated with Engineering teams to gather Requirements and SNMP, CMTS, and JOIN Data (jdbreg, jdbdump, dhcp), which I then Analyzed and Scrubbed Clean with VBScripts, ADO, and SQL LOADER them into the ORACLE 8i staging area for the modem reconciliation project.
• Modified and Wrote numerous VBA Macros to automate the manipulation of real-time CSG customer, billing and equipment data via the CICS-MVS 3270 terminal entry application (CCS – Cable Control System) by utilizing CCS Transactions for multiple Projects.
• Worked 139 hours in 9-day period to meet critical deadline for Modem Reconciliation Project.
• Created numerous Excel Reports on Modem Reconciliation for Upper Management and Customer Care Offices across the country.
• Developed SAS code to extract customer information into Excel Reports for marketing purposes.
• Developed code using SAS, SQL, PL/SQL using ORACLE and REDBRICK Databases and UNIX Shell scripting including CRON Automation, to extract information for the analysis of the highly visible ‘Rewards’ Marketing campaign.
• Gathered Requirements, Analyzed and Developed a process to instigate the Automation of Marketing’s ‘Rewards’ campaign into the Data Warehouse.
• Analyzed, Developed and maintained Marketing applications that insert and extract pertinent information for 3 lines of business (Cable, HSD - Internet, and Telephony), that Corporate and field offices use to analyze customer behavior for over 11 million customers and 22+ million homes passed.
• Wrote UNIX Korn shell scripts, using CRON, to Automate the processing of SAS Reports.
• Wrote UNIX KORN Shell scripts, using CRON, to Automate the distributed and parallel processing and Migration of CSG billing data for the 3 lines of business (Cable, HSD - Internet, and Telephony), onto two DEC Alpha servers, to be loaded into the Data Warehouse.
• Analyzed data with SQL, PL/SQL, and BRIO QUERY to help create business rules and for Data Integrity purposes.
• 24/7 Production Support for the Snapshot data process that incorporates Cleanup, Manipulation, Agregation, and Loading into the Data Warehouse.
• Used Data Modeling tools and techniques to Design and Develop Tables and Indexes in the Data Warehouse for Marketing Reporting purposes.
• Used Data Modeling tools and techniques to Design and Develop Tables and Indexes for multiple Data Marts for Marketing purposes.
• Migrated data from the Data Warehouse into the Data Marts to support Marketing Campaigns and Reporting.
• Developed C, and C++ applications using SYBASE DB-Library, ORACLE OCI, and ODBC to process Cable Data, Cable Max, and CSG data, based on location, services, and customer behaviors.
• Created a ‘C’ program to remove duplicate transaction records in the billing system master files.
• Created a Data Conversion utility program in ‘C’ to read numerous record types of raw CSG data
• Created a Data Conversion utility program in ‘C’ to read numerous record types of raw Prism Pay-Per-View data.
• Created a ‘C’ file and data manipulation library used by many programs.
• Created the ‘C’ and REDBRICK ODBC application tool, “odbc query” which is a command line tool that can be used in KORN Shell Scripts to extract data from the Data Warehouse and format it into delimited files that can be used by other applications and scripts.
• Created a KORN Shell and ‘C’ application to rollup Video, High Speed, and Telephony customer level data into SPA (system principal agent) level data to be loaded into the Snapshot tables of the Data Warehouse.
• Created a universal Data Conversion Utility in ‘C’ to read raw data in delimited or fixed record types, and convert packed decimal, zoned decimal, and IBM EBCDIC data formats into Numeric and Character data on the fly.
• Created the product mask system used in the Data Warehouse to quickly query and retrieve customer information.
• Migrated data from the SYBASE database into the Data Warehouse.
• Created tables, indexes, and SQL Stored Procedures in a SYBASE database to support Marketing Campaigns and Reporting.
• Analyzed, Designed and Developed a job tracking database using MS ACCESS, VISUAL BASIC, and VISIO.
• Created an HTML and PERL/CGI web application to query the REDBRICK Data Warehouse.
• Created a web page using Tcl/Tk and JAVA SCRIPT.
• Wrote a SAS application to build a 3 line of business (Video, Internet, Telephony) customer info cross-reference SAS dataset and UNIX file to be used in Database applications.
• Created a JAVA GUI app for Telephony marketing purposes.
• Maintained and updated the high volume, highly visible, Enterprise wide, 3-tiered Monthly Subscriber Recap Reporting application, which consisted of a VISUAL BASIC client-side GUI, the server-side SYBASE database, and the DCE compliant OEC Tools middle-ware.

Confidential, Aurora, CO

Senior Software Engineer II

• Maintained multi-tiered XView C++ with CORBA satellite ground system applications on a Sun Solaris UNIX system.
• Created PERL Scripts to fix incorrectly formatted configuration files.
• Used CVS Configuration Management tools for testing and development control.
• Support for CORBA server and handled CORBA code related issues.
• Wrote Java JDBC test cases for CORBA SERVER and ORACLE DATABASE.

Confidential, Littleton, CO

Senior Database Developer/Analyst – contractor

• Analyzed data from three ORACLE Databases using TOAD, a SQL SERVER database, and two Cgpro email servers and introduced and put into place Solutions to Migrate data and maintain Data Integrity.
• Used the REMEDY job/problem tracking system and CVS Configuration Management tools for testing and development control.
• Designed, Developed, Tested and put into production, code using PERL DBI, KORN shell, PL/SQL, SQL LOADER, and JAVA (with JDBC-ODBC bridge) for Data Migration, Data Cleanup and Data Integrity of customer information, email accounts, and modem information.
• Analyzed and Migrated data from ORACLE and SQL SERVER databases into the ORACLE based PORTAL Infranet Provisioning/Billing system.
• Wrote KORN Shell scripts using ‘CRON’ to Automate all UNIX based Data Migration and Cleanup procedures.
• Designed and Created ORACLE Tables and Indexes for Data Integrity purposes.

Confidential, Aurora, CO

MTS Associate

• Developed and/or Maintained multi-tiered C, C++, XView/Motif weather imaging/satellite ground system applications using OOA/OOD principles with various application framework packages on a SUN OS/Solaris UNIX system.
• Wrote SYBASE SQL Stored Procedures.
• Developed C applications with SYBASE Open Client.
• Used SCCS configuration management for testing and development control.
• Inspected, tested, troubleshot, configured, and repaired Serial Input Processor (SIP) boards, and the Signal Processing Interface Unit (SPIU).
• Designed digital schematics to implement firmware for a SIP board test generator using Mentor Graphics.
• Performed SUN System Administration.
• Occasionally worked as help desk technical support for C, C++, UNIX, SYBASE, SUN System Administration, and application framework problems.

Confidential

Software Development Manager

• Developed, implemented and maintained database software programs in C and DBASE to track equipment and mobility personnel.
• Assisted customers with hardware/software queries.
• Maintained and repaired personal computers.
• Controlled hardware/software resources and managed in-house software development for five maintenance organizations.
• Maintained, troubleshot, and repaired airborne camera systems, video tape recorders, laser detectors, and side-looking radar antenna systems on A10, F15, F16, F111, and SR-71 aircraft.
• Served as maintenance team leader, and night-shift supervisor.