SUMMARY

Over twenty five years progressive experience in the Information Technology industry in positions of progressive responsibility. First starting with Xbase development, then progressing to client server programming, web development, project management and data warehouse development. Excellent verbal written communication skills, both technical and non-technical environments.

Clustered Enterprise servers, Storage Array Network SAN , Unix/Linux, DBA experience on MS-SQL Server, Oracle, Sybase, DB2, Mysql, Postgres. Development tools/languages include Crystal Reports, PHP, Flash with action script, Flex, LAMP, Toad, ERWin, ERStudio, and office tools like Microsoft Office, Visio and a variety of others. Data Warehouse experience on Business Objects, Microstrategy, Cognos, MOLAP/ROLAP database designs, extensive and varied design/development experience. Database designs include dimensional modeling, data marts, snowflake and star schema structures. ETL experience with Informatica, Oracle Warehouse Builder, flat files, DTS/SSIS, and PERL based processes with stored procedures. Web development targeting enterprise level business needs with agile software development methods. Project Management methodologies primarily used include Scrum/Agile and Waterfall but sometimes Extreme Programming XP and Rational Unified Process RUP were used.

Industry experience in Health Care including Medical device makers , Finance automating accounting functions and loan origination systems, and highly varied projects in the entertainment industry.

WORK EXPERIENCE

Confidential

Project roles include: Project Management / Data Warehouse Designer Developer / DBA / Web Developer / Data Stewart

Major clients and projects include :

Minor Projects done between major projects and sometimes concurrently with them but off and weekends hours

Project Management Tasks:

• Managed the Development Change Advisory Board DCAB while at Disney with over 20 participants
• Lead a data archive project on the MsSql
• Maintained project timelines, updated schedules, managed project resources, updated Management
• Project Management with Waterfall and Agile Scrum methodologies
• Multiple BI projects including requirements gathering, design, development and deployment
• Install, Configure and Upgrade Tasks:
• Participant of the upgrade project to migrate Microstrategy to 9.4.1 hot fix 4
• Installed and configured Data Warehouse and Bi tools Business Objects, Cognos, Microstrategies, Pentaho and Ms Bi tools SSRS, SSIS, MsSql
• Installed and configured Operating Systems OS including Mac Osx, Windows 2000, 2003, 2008, 2012 32 and 64 bit, Linux distributions including Fedora, Centos, Red Hat, Debian
• Installed and configured MsSql 2000, 2005, 2008, 2012 , Oracle 10,11,12 , Db2 10 , My Sql, Postgre Sql Pgsql , and multiple other RDBMS solutions on Mac, Win and Linux platforms.
• Upgraded and migrated Windows Servers from 2000 and 2003 to 2008 and 2012
• Upgraded and migrated Sql Servers databases on 2000, and 2005 to 2008, 2012, and Oracle 9 to 10, and 10 to 11
• Configured software and hardware including Juniper firewalls with Junos, Apache, Tcp/Ip networks, Squirrel Mail, Postfix, Osx Server with Email services
• Database driven web development projects using Php using MVC methods, Flash CS6, Perl, and some CF, HTML, Java Script JS , AJAX and Cascading Style Sheets CSS used in conjunction with the web scripting languages

Design and Development Tasks:

• Automated data new data archiving process to run off-hours in order to not interfere with production.
• Assisted other developers with Business Objects Crystal Reports needs, fixed and created reports with Crystal Reports
• Re-Organized a problematically structured data warehouse that exceeded a terabyte. Shrunk the total size to of what it was by removing redundant and not needed data
• Assisted in getting a failing ETL process running again on a data warehouse project relating to user access and LDAP information
• Meta-data management, Master data management MDM , Data Repository MDM data synchronization
• Report and analytic tool development Data Warehouse with Cognos, Business Objects Crystal Reports , and SSRS
• Database design and development on MsSql, Oracle, DB2, Postgre Sql, and Mysql
• Wrote perl and SSIS code to query LDAP to verify and correct data in the data warehouse
• Wrote database and web code for an award winning internet company, the creators of CyberScholar.com
• Wrote, corrected, and enhanced stored procedures and packages using T-SQL, Pl-Sql, and other languages
• Restructured processes to streamline, automate, correct, added validation processes and code
• Migrated nightly jobs to Citrix Tidal
• Fixed perl ftp and Etl scripts
• Wrote, enhanced and fixed ETL processes with Informatica, SSIS, Perl and other tools
• Entity Relationship ER diagram database design, development, and documenting with ErStudio, ErWin, and other tools
• Reporting / Data Warehouse tools research to compare and contrast the features and short comings of major data warehouse tools including Business Objects, Cognos, Microstrategy, Pentaho, Microsoft BI Suite

Environments: Linux, Windows 2003,2008,2012 , OSX 10.6,10.7,10.8 , OSX Server, Juniper JunOS , Oracle 10,11,12 , Db2 10 , MySql, MsSql 2005,2008,2012 , Microstrategy 8,9 , Crystal Reports/Business Objects XI r1l,r2,r3 , Cognos 6,8,10 , Apache, Postfix, Squirrel Mail, PHP, Flex, Flash w/ action script/data grids, Adobe CS5, CS6 , Web Services, PERL, Citrix Tidal, Nagios, Subversion, batch and shell scripts

Confidential

Senior Application Architect for the PARIS system Participation Administration and Residuals Information System

Worked on a project to take a system internally developed by another movie studio to port it to the needs of Paramount Pictures. Wrote some PERL based ETL processes that loaded initial data and assisted in the Informatica based ETL process that were to be run repetitively. Identified data irregularities from varied source system. Created and modified stored procedures, cursors, views, functions, database structure, and web code. Identified numerous issues of incompatibility between the code of the different studios. Wrote PERL routines to identify problems with source data being loaded. Created new reporting solutions for SOX compliance. Wrote a data integration application with Flash, Flex and PHP to allow the users to see issues with the data. Modified sql code to upgrade from sql 2000 to 2005 and 2008. Created ER diagrams to document the database and the changes.

Environments: Windows Vista / 2003 / 2000 / XP, Citrix, VM-Ware, MS-SQL 2000,2005,2008 Enterprise versions, Oracle 10g , MySql, Db2, Sybase, Er-Studio, SAP, People Soft, Cognos, Microstrategy, Crystal Reports, Informatica, Apache, IIS, PHP, Flex, Flash w/ action script/data grids/flash remoting, ASP, Web Services, XML, HTML, CSS , PERL, MsOffice, MsProject, Visio, Nagios, Subversion, and batch scripts

Confidential

Project Manager / DBA / Data Warehouse Analyst / Database Developer / Data Architect / Web Developer / ETL Developer

• Primary responsibilities revolve around the Database and Project Management, performing the responsibilities of application architect, database architect, DBA and project manager depending on the needs of the particular client. Insuring the project is on track and the destination is clearly defined and understood. Most projects were either data warehousing, or web projects with a few data conversion projects in the mix. On most projects I am the primary liaison between project stake holders and the development team. RDBMS used on the projects primarily include MS-SQL, Oracle, My-Sql, Postgres. But sometimes DB2, Sybase and Teradata were used. I primarily function as the DBA designing databases, capacity planning, hardware architecture planning, setup of automated backup and verification methods, perform 3rd level database support, setup system monitoring processes, optimize queries or processes, create stored procedures, indexes, constraints, cursors, triggers, views, backup scripts, configure database for replication, setup enterprise fail over functionality, document database design and schemas, organized meta-data, database designs include both OLTP and OLAP, assisted clienst in identifying Key Preformance Indicators KPI , created dynamic digital dashboards using Flash components and other commercial tools.
• Created customizations to Ez-Cap a health care application that processes claims payments, authorizations, capitation payment calculations and patient eligibility. Wrote EDI routines for modifying incoming eligibility data to Ez-Cap needs. Created automated reconciliation processes between Ez-Cap data and external systems.
• Web development experience started out with ASP, evolved to Java, PHP and now currently PHP with Flash and Flex using web services. Flash and Flex provide a very rich user interface that other tools can't. Information is usually rendered by passing XML data to Flash components for web based digital dashboards for data warehouse projects.
• Worked on loan origination and financial systems creating data validation systems, financial reports and interfaces. Extracted info to create combined views of information from different databases displaying the resulting reports from a browser independent web interface.
• Documented work by writing proposals, technical specifications, UML diagrams, ER-Diagrams using ErWin, ErStudio and Visio when that was all that was available. Frequently train more junior staff along with explaining the documents. Most projects were conducted using the Agile/Scrum development model but some used Waterfall.

Projects include:

• Health Care web applications and file conversions, Ez-Cap customizations
• Auto industry development and data conversions
• Four data warehouse projects using various tool sets Cognos/Business Objects/Oracle/Microstrategies/Open Source
• CRM systems internally developed systems, SalesForce.com, Epicor, Sage
• Created varied ETL processes using Informatica, DTS/SSIS, and sometimes PERL with stored procedures
• Created customized digital dashboard to report KPI Key Performance Indicators with a web interface
• Created multiple Operational Data Stores ODS for advanced reporting, combining data from multiple storage systems
• Loan origination systems for housing and auto markets
• Worked on an Web Based Application Service Provider ASP modeled Physician Practice Management System
• Database updates, and upgrades, most recently three MS-SQL 2000 to 2005 and an Ora 10 to 11 upgrade

Clients Include:

• Kaiser Permanente
• Toyota
• Western Digital
• AutoByTel
• Disney funded startup
• Screen Writers Guild SWG

Environments: HPUX, linux Red Hat AS, Fedora Core, Centos, LFS, Ubuntu, Slackware , Windows Vista / 2003 / 2000 / NT / XP / 9x, Dos, Mac OSX, Citrix, VM-Ware, MS-SQL 6.5,7.0,2000,2005 w/Enterprise version fail over Active/Active , Oracle 8i,9i,10g,11g some had RAC configuration, MySql 3-5 , Postgresql 6-8.2 w/slony, Db2, Sybase, Toad, SAP, People Soft, JD Edwards systems, Kronos, Hyperion Essbase, MAS500, Fidelity Mortgage Servicing Package MSP , Broad Sign, Cognos, Microstrategy, Crystal Reports and Business Objects 3.5-XI , Informatica, Apache, IIS, PHP, Flex, Flash w/ action script/data grids/flash remoting, Java, DTS, Dot Net, ASP, Web Services, XML, HTML, CSS, squirrel mail, Postfix, PERL, shell scripts Korn and advanced batch files.

Confidential

Reporting DBA

Programmed in MS-SQL 7.0-2000, Oracle, Crystal Reports, VB, and ASP. Designed and managed all reporting needs. Integral part of most of the web and MS-SQL development. Improved reliability and speed of the Internet applications. Worked with the web team to enhance performance of the MS-SQL server and reduce the load being placed on the MS-SQL server. Created an ODS to meet the web based reporting needs of the company. DBA functions included data modeling/design, capacity planning, backup/recovery, security, performance tuning, and creating indexes.

Environment: MS-SQL 7.0 tsql , Oracle plsql , Visual Basic, Crystal Reports, Seagate Info, IIS, ASP, DHTML/HTML, ADO, MSMQ, MTS, MSAS

Confidential

DBA / Project Manager

Wrote programs in Visual Basic 5.0 and 6.0, using SQL/Server, Oracle in an object-oriented development environment. The application designed divided the parts of the project into modular business objects. Learned and began developing Active Server Pages ASP , worked on the middle-tear rules engine. Responsible for analysis, database design and development. Performed work in the systems architecture area. Normalized the database while porting an application from Fox Pro to MS-SQL to increase efficiency scalability and consistency. Wrote SQL stored procedures, triggers, constraint and various scripts as needed. Set up and maintained Oracle on NT, MS-SQL 7 and 2000 beta clustered servers active-active , NT Enterprise servers. Trained other programmers on how to properly access a SQL database. Developed an encryption routine for passwords in VB. Maintained the Epicor's ERP and Platinum accounting systems SQL server database and assisted its users.

Environment: Clustered Enterprise MS-SQL7.0-2000 tsql , Oracle plsql , Visual Basic, MTS, IIS, ASP, ADO, FoxPro, ErStudio

Confidential

VB Programmer / Report Developer

Coded in Visual Basic 5.0 with SQL-Server 6.0, 6.5, 7.0 and MS-Access databases. Developed reports using Crystal Reports and SQL. Created complex SQL statements, performed database programming on Oracle, Sybase, MS-SQL/Server and MS-Access. Managed source code and handled software revisions for the entire development department. Trouble-shooting of bugs on a variety of development projects.

Environment: Visual Basic, Crystal Reports, PVCS, MS-SQL 6.0 6.5 tsql , Oracle plsql , Sybase tsql , Access, ErWin

Confidential

Director of Consulting

Wrote programs for various clients when software didn't meet needs. Responsible for Ez-Cap data conversions, creating custom reports, cleaning up corrupted data, training users on Ez-Cap, Crystal Reports, R R Report Writer. Programming in Fox Pro, Delphi and Visual Basic with MS-SQL/Server and MS-Access databases.

Environment: Crystal Reports, Fox Pro, Visual Basic, MS-SQL, Access, HTML

Confidential

Senior Consultant

Fred Rothenberg and Associates produced EZ-CAP a leading managed care software package. Responsible for installing software, training users, teaching classes in R R Report Writer, answering technical questions on the support line. Set records for highest volume of support calls, greatest accuracy in responses, shortest time between starting with the company and training clients. Received highest client satisfaction reviews in the department. When eligible, won the department excellence award for every month eligible except one. Promoted to sales where product technical knowledge could be better utilized. While in the sales department completed RFP's, did product demonstrations, and sent out marketing letters to prospective clients. Completed data conversions and reports that were thought impossible by co-workers and management. Wrote custom integration and data conversion programs as needed by clients.

Environment: Clipper, Fox Pro, R R Report Writer, Crystal Reports, MS-SQL, Oracle, Gupta, Novell

Confidential

Financial Analyst/Database Programmer

Worked for Los Angeles and Orange area Hospitals creating custom reporting systems for financial analysis. Developed charts and various 3D graphics for executive presentations. Worked on a multi dimensional accounting database early from of star schema in a data warehouse , implemented managed health care database systems.

Environment: Lotus 123, Excel, Dbase III, Fox Pro, Harvard Graphics, IBM Mainframe, DB2, Novell