Applications System Engineer Resume ,Charlotte, NC - Hire IT People

SUMMARY:

Proven experience in all phases of the software development life cycle (SDLC).
17 years+ design/development experience working with Informatica PowerCenter (ETL).
Strong relational database skills (Oracle, PL/SQL, SQL Server, T - SQL, Sybase).
Experienced in Data Warehousing (concepts, design, development, revisions)
Mentoring and leadership responsibilities.

TECHNICAL SKILLS:

Languages: Informatica PowerCenter 9.6.1, PL/SQL, T-SQL

Utilities: TOAD, SQL Server Management Studio, Autosys, Sybase Central v6.0.

Databases: Oracle 11g, SQL Server 2014, Sybase

Platforms: UNIX, Linux, Windows NT, IBM (Mainframe development)

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte, NC

Applications System Engineer

Responsibilities:

Worked with business analysts regarding new development and revisions.
Feeds were from delimited flat files (FTP) and relational databases (SQL Server, Sybase, Oracle).
Revised and developed new T-SQL processes.
Developed multiple Autosys (jil) scripts to schedule processes based on dependencies.
Loaded data to the Operational Data Store followed by loads to the Data Warehouse via Informatica and T-SQL processes. These were also processed based on Autosys dependencies.
Created delimited flat files to feed data to external systems via FTP.
Worked with offshore team members providing documentation regarding new processes.

Environment: Informatica PowerCenter 9.6.1, SQL Server 2014, T-SQL, SQL Server Management Studio, Sybase Central v6.0, UNIX, Autosys, PuTTY, FTP

Confidential,Orlando,FL

Senior ETL (Informatica) Developer

Responsibilities:

Environment: Informatica PowerCenter 9.1, Oracle 11g, LINUX

Confidential,Charlotte,NC

Senior ETL (Informatica) Developer - Contract Position

Responsibilities:

Efforts centered upon developing a new Oracle Type 2-dimensional Data Warehouse (CARD). Sources included delimited flat files and relational tables from various financial systems.
Design/ Development efforts: 80% Informatica, 20% PL/SQL.
PL/SQL development including dynamic SQL and pivoting of tables.
Involved in all phases of the Software Development Life Cycle ( SDLC ).
Worked with team members on the data model. Type 2-dimensional Data Warehouse (Oracle).
Worked with business analysts regarding new development and revisions.
Involved in all processes related to the new Data Warehouse (data modeling/ analysis / design / development / tuning / testing).
Developed Autosys (jil).
Data warehouse loads were performed using only Informatica.
Revised and developed new PL/SQL processes (including dynamic SQL).

Environment: Informatica PowerCenter 9.1, Oracle 11g, TOAD, UNIX, Autosys

Confidential,Owings Mills,MD

Lead ETL (Informatica) Developer

Responsibilities:

Revamped an Informatica application sourcing/ targeting an Oracle database (Financial Data). Previously, this monthly application would process for excessive periods of time. Based on enhancements made to the Informatica code and database tuning, the application processed far within the SLA.
Designed/ developed an archiving process which dramatically reduced processing times and increased OLAP response time.
Mentored two Informatica developers involved in two separate projects.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, UNIX, TOAD

Confidential,Washington,DC

Senior ETL (Informatica) Developer

Responsibilities:

Development efforts involved sourcing XML (via Informatica PowerCenter).
Designed/ developed a strategy where XML was loaded directly into an Oracle data acquisition layer.

Environment: Informatica PowerCenter 8.1.1, XML, Oracle 10g, UNIX, TOAD, Turbo XML