Resume

Sign in

Data Visual Basic

Location:
Los Angeles, California, United States
Posted:
January 27, 2017

Contact this candidate

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), web farms, N tier environments, parallel processing, DBA experience on MS-SQL Server, Oracle, Sybase, DB2, Mysql, Postgres. Database performance tuning and query optimization. Development tools/languages include Crystal Reports, SAP-Business Objects Webi, PHP, Python, Perl, Java, Ruby(ROR), Flash with action script, Flex, LAMP, Toad, ERWin, ERStudio, and office tools like Microsoft Office, Visio and a variety of others. Web Development with Http, FTP, CSS, JSON, XML, Restful API’s, Object Oriented Development(OOD), Business Intelligence 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.

EDUCATION AND CERTIFICATIONS

B.S., California State University at Long Beach School of: Business Administration, Major: Financial Management, Minor: MIS

Completed course work in a wide variety of computer languages and RDBMS including Sybase, MS-SQL, Oracle, Postgres, Hadoop, Visual Basic, JDBC, HTML, Python, Java, ASP, PHP, Flash with Action Script (AS2, AS3), CS6, Ruby on Rails(ROR), CSS, Java Script and Unix/Linux.

Certified by Health Insurance Association of America (HIAA) for Managed Health Care Part A and B.

Currently working on Certification in Python at Cal State Fullerton (CSUF)

WORK EXPERIENCE

Data Engineer Consultant 09/2009 – 11/2016

Roles include: Project Management, Data Warehouse Designer / Developer, DevOps DBA, Python App and Web Developer

Major clients and projects include :

LACCD/AECOM:

lead developer/designer on a Data Warehouse project for a $6.2 Billion Construction Project

Acorns:

Database optimization effort for a investment related mobile app

Disney:

Business Intelligence Architect enhancing existing data warehouse and BI application

Allergan Pharmaceuticals:

Enhanced existing data warehouse identified issues, augmented data available

Maersk shipping:

Data archive project, database upgrades, identified root cause for database failures

Kaiser Hospitals:

Data warehouse project relating to user access and LDAP, ETL routine automation

Creative Channel:

Online marketing and training web site. Did maintenance and development, ETL, stored procedures

Johnson & Johnson:

Medical device applications Server upgrades (OS and Database versions), system migrations, ETL

Yahoo:

Ftp process enhancement, Etl enhancement, Business Objects to Microstrategy migration

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

Medical Startup:

Health care capitation and claims managed application using Python/Pgsql/Apache

Corp to Corp Projects:

Multiple web development projects using varied web development languages and technologies

Research project to compare and contrast BI and Data warehouse tools with examples

Project Management Tasks:

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

Install, Configure and Upgrade Tasks:

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, Ubuntu

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, DNS, Registered and configured URL’s, web Farms, N-Tier servers, 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

Design and Development Tasks:

Designed a Data Warehouse for Los Angeles Community College District(LACCD) from scratch, defined and wrote ETL processes using Python, MsSql Rolap design using mostly Inman methods but some Data Marts used Kimbal methods. Data Wareouse BI created with Web Front end using 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 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 Tidal (Citrix enterprise job management system)

Enhanced 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: Cloud Services, Amazon Web Services(AWS), Linux, 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, PHP, Flex, Flash w/ action script/data grids, Adobe(CS5, CS6), Web Services, PERL, Tidal, Nagios, Subversion, batch and shell scripts

Paramount Pictures 08/2008 – 07/2009

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

Independent Consultant (multiple projects and roles) 04/2000 – 07/2008

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 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, 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 renderred 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

Alliance Imaging

American Mortgage

Toyota

Western Digital

AutoByTel

Disney funded startup

Screen Writers Guild

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.

Winfire.com (dot com startup) 09/1999 - 04/2000

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

ONYX Acceptance (Purchased by Citi Bank) 06/1998 - 09/1999

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

Digital Graphics Advantage (Phonebook division of Pac Bell) 02/1997 - 06/1998

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

Independent Consultant 07/1996 - 02/1997

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

Rothenberg Health Systems (Now Quadramed) 05/1994 - 07/1996

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

Multiple Hospitals 04/1988 - 05/1994

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



Contact this candidate