Senior Integration Architect/Senior Informatica Developer Resume

SUMMARY:

Confidential is an experienced Information Technology Professional with twelve years in development and support of government and large corporate strategic and business critical IT applications which includes database design, data modeling, Oracle DBA responsibility, PL/SQL development, Informatica Development/Administration, Business Objects development.
Applicable experience include a strong technical background with successful project development skills in UNIX, Web and client server environments, strong data modeling and design skills using normalization, denormalization and dimensional modeling approaches for relational database and data warehouse design.
His experience includes knowledge in Telecommunications, Confidential, DOL, EPA, E - Commerce and consulting.

AREAS OF EXPERTISE:

Hardware and Operating Systems: Sun Solaris, AIX, Linux, DOS, Windows

Software and Tools Programming: SQL, PL/SQL, Java, C, UNIX Shell Scripting, Perl, FORTRAN, Visual Basic, ASP, ASP.Net, Java Script

ETL Tools: Informatica 8.x/9.x (PowerCenter, DataAnalyzer)

Databases: Oracle 9i, 10g, 11g, DB2, SQL Server, MS Access and Sybase

BI and Reports: Business Objects/Crystal Reports, Oracle discoverer, OBIEE, Oracle Forms, Oracle Reports, Pentaho, Tableau, Birst

Others: Erwin, TOAD, FTP, SFTP, SCUM

PROFESSIONAL EXPERIENCE:

Confidential, Virginia

Senior Integration Architect/Senior Informatica Developer

Responsibilities:

Data Integration Architect for Confidential ERP System. Develop and architect the integration of legacy system to comply with Confidential standards.
Architect ETL for mapping, transformation and loading the data
Develop ETL application for Confidential Data Warehouse Catch Data Change ( Confidential ) using Informatica PowerExchange and PowerCenter, Oracle 11G, UNIX Scripting

Confidential, Maryland

Associate/Senior Informatica Developer

Responsibilities:

Lead developer the development of Confidential Data Warehouse (Batch Load).
It included architecture ETL design, configuration, design/mapping document development and revising.
Using Erwin8.0 to create and modify Confidential Data Warehouse model using dimensional model.
Led mapping/workflow design and coding for data warehouse batch loading as well as production deployment process.
Develop Approval of Concept and Pilot project using Informatica PowerExchange to catch data increment change for near-real time data warehouse population.

Confidential, Virginia

Principal Consultant

Responsibilities:

Lead developer of new mappings, workflows with large plain format sources for Confidential Health and HR project using PowerCenter, UNIX
Being an Oracle DBA to create and maintain table space, schema and tables, views, etc. as we as flashback data and backup using RMAN.
Developed a web based internal application using JSP
Configure and Administrate Informatica server for Oracle EBS based HR Data Warehouse project
Led Informatica Upgrade to version 9.5 and conduct security compliance for Informatica upgrade
Led Informatica deployment and technical design documentation

Confidential, Ashburn, Virginia

Engineer/System Consultant

Responsibilities:

Led and accomplished over 30 ETLs for BI Data Warehouse and telecom provisioning, financial systems and trouble tickets system
Developed hundreds of daily and Ad-hoc reports using Crystal Reports/Business Objects for Telecom business
Worked as an Oracle DBA to create database objects, flashbacking data and backup using RMAN.
Developed IP Network Distribution application using Google Web Toolkit (a Google version Java)
Developed and accomplished more than 50 BI dashboards using Informatica Data Analyzer for executives and internal business entities which included some virtually real-time reports (refreshing every 15 minutes).
Developed Oracle packages or various telecom related projects including packages to feed Confidential wireless applications; Oracle packages and functions as ETL tools to feed Confidential Business CIO dashboards; Oracle stored procedures for Confidential intranet/internet applications; Oracle stored procedures for daily business reporting

Confidential, Arlington, Virginia

Consultant

Responsibilities:

Developed various web applications to provide VZ users a single sign-on platform of business and administration purpose
Developed business reports using Crystal Reports and integrated them to ASP based web applications
24 X 7 support and administrator two Informatica environments to DEV and Prod as well as BI reporting and dashboard server.

Confidential, Mclean, Virginia

Consultant

Responsibilities:

Major developer of WeightWatchers.com using ASP, SQL SEVER 7.0, COM and XML/XSL.
This project increased exposure of their meeting events by 80%