Senior ETL Analyst/Developer Resume Burbank, Ca - Hire IT People

SUMMARY:

Solutions - focused, team oriented Senior Programmer/Systems Analyst/Data Warehouse Architect with broad-based experience and hands-on skill in the successful implementation of highly effective business solutions. Proven ability to successfully analyze an organization's critical requirements, identify the best possible solutions, and develop innovative solutions for increasing reliability and improving productivity.
A broad understanding systems analyst, programming in many different software tools, and adapting to changes within the industry. I welcome change and enjoy new challenges. Because of my broad experience in the entertainment, engineering, quality control, financial and aerospace industries, I bring unique experience that many others do not. The last year and a half at Confidential I have spent enhancing the current Financial data warehouse.
Confidential uses Confidential, which is built on the Informatica 9.1 platform, to extract the financial data from our EBS and SQL Server transactional systems. The enhancements to the performance of the nightly process have reduced the overall process by 30%. For the past 6 months I have been part of the team that is converting our data warehouse from Confidential to
BIAPPS and ODI 11.1.1.8. We are enhancing the Out of The Box BI APPS by bringing in additional data from both EBS and RAS (SQL Server financial data). We are all built aggregate tables to support additional custom reports.

PROFESSIONAL EXPERIENCE:

Confidential, Burbank, Ca

Senior ETL Analyst/Developer

Responsibilities:

Sr. Data Warehouse Developer and Architect
Enhance Performance of current Informatica processes through the use of Oracle Indexed Tables and Materialized view
SQL Development tools: Quest Toad Data Modeler 5.0 and SQL Developer 3.0
Develop PL SQL stored procedures in Oracle 12c11g in support of very complex business requirements

Confidential, Los Angeles, CA

Senior ETL Analyst/Developer for Financial Data Warehouse

Responsibilities:

Data Architect of Material Cost Management Data Warehouse.
Developed ETL solutions using Informatica 8.5.1 and Datastage 8.5. and 9.1
SQL Development tools: Quest Toad 11.5 and SQL Developer 3.0
Developed PL/SQL(Oracle) 10g and 11g in support of very complex business requirements.
Developed SQL in Teradata 13.0 and 14.0
Developed Stored Procedures and embedded SQL within ETL tools
Implemented data warehouse solutions in Long Beach, Puget Sound, St. Louis, Ft. Walton Beach and Mesa.
Work with all Boeing sites to develop requirements for integration into data warehouse.
Produced and maintained standards for all ETL development (Informatica and Datastage)

Confidential, Chatsworth, CA

Senior Applications Analyst/Developer

Responsibilities:

Developed web-based business applications to support Finance; using ASP, HTML.
Developed security frontend to support earned value reporting
I was part of the evaluation team that identified Business Objects and Datastage as the common tools for the data warehouse.
Wrote stored procedures in PL SQL and Oracle to support business requirements.
Architected the Name labor data ware house using Dr. Kimball’s methodologies.
Part of the team that implemented data warehousing at space division.
Taught and mentored the current data warehouse lead architect.
Because of my data warehouse skills and experience I was promoted to the Enterprise Boeing Data Warehousing project.

Confidential, Simi Valley, CA

Senior Applications Analyst/Developer

Responsibilities:

Analyze and Developed client server applications (Powerbuilder) in support of the bankruptcy system.
Analyze and Developed business applications, using Java and IBM’s Visual Interdev, to support the foreclosure business
Perform all phases of software development lifecycle
Developed Transact SQL Stored Procedures to interface between Java and Sybase database.

Confidential, Camarillo, CA

Senior Applications Analyst/Developer

Responsibilities:

Designed and Developed the companies Pick-a-Light software that increased order efficiency by 60%.
Designed and Developed order shipping software that increased efficiency by 30%
Perform all phases of software development lifecycle