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, AWS(EC2,S3), DBA experience on MS-SQL Server, Oracle, Sybase, DB2, Mysql, Postgres. Development tools/languages include Crystal Reports, SAP-Business Objects Webi, 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, Statistical and charting tool R, MOLAP/ROLAP database designs with Inman and Kimbal methods, extensive and varied design/development experience.
• Database designs include dimensional modeling, data marts, snowflake and star schema structures.
• ETL experience with Informatica, flat files, DTS/SSIS, and Python/Perl based processes with stored procedures.
• Web development targeting enterprise level business needs with agile software development methods.
• Project Management methodologies primarily used includes Scrum/Agile and Waterfall but sometimes other methods.
• Industry experience in health care, finance, accounting systems, loan origination systems, Construction, and highly varied projects in the entertainment industry.

WORK EXPERIENCE:

Confidential

Business Intelligence and Data Warehouse Consultant

Responsibilities:

• Wrote ETL (ELT) processes for extracting data from SalesForce, and Intacct using NodeJs and Python.
• Enhanced existing reports created from Perl scripts.
• Designed DataWarehouse and DataMarts for Postgresql back end.
• AWS processes including serverless solutions.

Environment: Osx, Postgresql, Docker, Ansible, AWS, Tableau, Intacct, NodeJs, Python(Pandas, SqlAlchemy, Flask and more)

Confidential, Irvine

Manager Operational Systems

Responsibilities:

• Managed operational needs of Confidential in a mixed Linux/Windows environment.
• Revised documentation enhanced processes, streamlined operations.
• Documented database schema.
• Trained employees on Sql to perform operational tasks.
• Researched and documented the existing processes.

Environment: s: Debian, Redhat, Win7, Win10, Win2008, Sun, VmWare, MsSql, Mysql, Postgres, Slony, Bugzilla, Puppet, Ansible, Nagios, Icinga, Request Tracker (RT), Splunk and SharePoint

Data Engineer Consultant

Confidential, Los Angeles

Responsibilities:

• Lead developer/designer on a Data Warehouse project for a $6.2 Billion Construction Project
• Database optimization effort for a investment related mobile app
• Business Intelligence Architect enhancing existing data warehouse and BI application
• Enhanced existing data warehouse identified issues, augmented data available
• Data archive project, database upgrades, identified root cause for database failures
• Data warehouse project relating to user access and LDAP, ETL routine automation
• Online marketing and training web site. Did maintenance and development, ETL, stored procedures
• Medical device applications Server upgrades (OS and Database versions), system migrations, ETL
• Ftp process enhancement, Etl enhancement, Business Objects to Microstrategy migration
• Health care capitation and claims managed application using Python/Pgsql/Apache
• Built a data warehouse from scratch for large manufacturing company to manage construction using open source tools
• Identified root cause of application failures at Acorns
• Complete a data archive project on MsSql for Maersk shipping
• 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
• Revised Bi Developer Guide for Disney
• Managed the Developers Change Advisory Board meetings and process for the BI team at Disney
• Installed and configured Data Warehouse and Bi tools Business Objects, Cognos, Microstrategies, Tableau, 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, Ubuntu, Sun
• 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, Python, Perl, and some CF, HTML, Java Script (JS), AJAX and Cascading Style Sheets (CSS) used in conjunction with the web scripting languages
• Designed a Data Warehouse for Los Angeles Community College District ( Confidential ) from scratch, defined and wrote ETL processes using Php, Perl, Python, MsSql. Used Rolap design using mostly Inman methods but some Data Marts used Kimbal methods. Data Warehouse BI created with Web Front end using Apache, Python, Php, Crystal Reports 2008. Operational system reports used Cognos.
• Postgres database optimization effort and pgsql stored procedure/function development
• 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 SSIS 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 Python, 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 Tidal (Citrix enterprise job management system)
• Enhanced SSIS, Python 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, Tableau, Pentaho, Microsoft BI Suite

Environment: s: Cloud environment, Amazon Web Services(AWS), Linux, Sun, Windows(2003,2008,2012), OSX (10.6,10.7,10.8), OSX Server, Juniper(JunOS), Oracle(10,11,12), Db2(10), MySql, MsSql(2000,2005,2008,2012), Microstrategy(8,9), Crystal Reports/Business Objects(XI r1l,r2,r3,2008), Cognos(6,8,10), Apache, Postfix, Squirrel Mail, Chef, Puppet, Ansible, Flash w/ action script, Adobe(CS5, CS6), Web Services, Python, Perl, PHP, Flex,C#, SSIS, Tidal, Nagios, Subversion, batch and shell scripts

Confidential, Hollywood

Senior Application Architect

Responsibilities:

• Worked on a project to take a system internally developed by another movie studio to port it to the needs of Confidential .
• Wrote Python and 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 to 2012.
• Created ER diagrams to document the database and the changes.

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

Confidential

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

Responsibilities:

• 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 clients in identifying Key Performance 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 payments, 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, PHP with Flash and Flex. 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.
• 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

Environment: s: 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,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, SSIS, 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, Python, Perl, Flex, Flash w/ action script, flash, Java, DTS, Dot Net, ASP, Web Services, XML, HTML, CSS, squirrel mail, Postfix, shell scripts(Korn, Bourne) and batch files.

Confidential

Reporting DBA

Responsibilities:

• 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: MSSQL 7(tsql), Pgsql, Oracle(plsql), Python, Visual Basic, Crystal Reports, IIS, ASP, DHTML/HTML, ADO, MTS

Confidential

DBA / Project Manager

Responsibilities:

• 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-2000(tsql), Oracle(plsql), VB6, MTS, IIS, ASP, ADO, FoxPro, ErStudio, Python

Confidential

VB Programmer / Report Developer

Responsibilities:

• 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

Responsibilities:

• 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