SUMMARY:

By using and combining my expertise in various data integration tools, I was able to provide a key role at IT organizations. Developed solutions where interpersonal communications skills, project design and a broad technical background helped implement various IT solutions.

TECHNICAL SKILLS:

• Informatica PowerCenter
• Informatica PowerExchange
• Informatica PowerConnect
• Informatica PowerPlug
• Informatica SuperGlue
• SSIS
• Oracle
• SQL Server
• Netezza
• Teradata
• Microsoft Access
• Quest: TOAD
• Unix
• Windows NT
• Data Integration
• Data warehousing
• Data Architecture
• Database Administration
• Erwin
• Star Schema

PROFESSIONAL EXPERIENCE:

Confidential

Senior Informatica Consultant

Responsibilities:

• Lead and Implemented to Confidential standards where the lifecycle of the project from analysis to go - live is being met with a good understanding of the Technical, Functional and Business needs.
• Lead and delivered ETL / Informatica Solutions where the data analytical spectrum has improved significantly for usability purposes by the end-user.
• Worked on the design, build and testing of various ETL sets to stream line the data integration needs for the overall Loan Accounting Initiative (LAI) goals and its scope for new reporting.
• Worked on combining a solution that includes Enterprise Data Integration (EDI), Enterprise Data Warehousing (EDW), a Loan Accounting Data Mart and a End User Reporting Layer against Loan Accounting systems.
• Worked and coordinated with various IBM Tech Arch teams to facilitate solutions to various ETL architectural issues.

Confidential

ETL Developer/Data Integration Consultant

Responsibilities:

• Designed and created the ETL specifications for Confidential Marketing Dashboard project.
• Performed extensive Data Analysis for future based marketing data quality and projections.
• Designed and built various data algorithms which were used in the built of various ETLs.
• Built various Informatica ETLs to extracts data from various legacy systems and integrated into an Oracle Enterprise Data warehouse.
• Performed Unit Testing, User End Testing and System Testing on all ETLs built for the Marketing Dashboard project.
• Worked and coordinated with the Cengage Tech Arch team to facilitate the Informatica code migration from DEV > SYSTEST > QA > PROD.
• Worked on and resolved various ETL defects for a number of Confidential ETL Projects.

Confidential

ETL/Data Integration Consultant

Responsibilities:

• Designed and created various Confidential Technical Specifications for the implementation of various Confidential Cubes.
• Built various ETL Microsoft SSIS packages used for the implementation of various Confidential Cubes.
• Built and implemented various Microsoft Data Cubes for Confidential Data Analytical Purposes.
• Performed extensive Data Analysis for future based Data Quality via the use of Confidential .
• Created Coding and Naming Standards Documentation to be used by the Confidential Development Staff.
• Created various Technical Architectural Templates to be used by the Implementation Team of Confidential to facilitate a Technical Architectural Standard.
• Worked and coordinated with the Confidential CRM team to facilitate various trouble shooting and resolutions standards to be used by the Technical Team of Confidential .

Confidential

ETL/Informatica Consultant

Responsibilities:

• Designed and created the ETL designs (DIDDs) for the Spend Cube Analytics project.
• Built Informatica ETLs and various IT processes to automate the data extract process for Spend Cube Analytics project.
• Built the EAM Release 3 Conversion Informatica extract mappings. Extracting legacy data and population various EAM Conversion staging databases.
• Trained various IT personal at Confidential on Informatica 8.1.1 and Informatica 8.6.1.
• Worked and coordinated with the Confidential Tech Arch team to facilitate various ETL architectural issues.
• Worked and coordinated with the Confidential Tech Arch team to facilitate the Informatica code migration from ECOM DEV > ECOM SYSTEST > ECOM QA > ECOM PROD.
• Executed the EAM Release 3 Conversion extract mappings for R3 - DR1, DR2, DR3 and DR4.
• Worked on and resolved EAM Release 3 Conversion extract defects which were assigned via Quality Center.

Confidential

ETL Lead

Responsibilities:

• Informatica ETL onshore and offshore lead.
• Coordinated ETL deliverables between the offshore ETL developers in India and onshore data analyst teams in the USA.
• Led onshore activities for the matrix technical delivery team.
• Owned solution designs (conceptual) for data integration.
• Produced AP 481 external interface agreements.
• Managed the day-to-day Informatica development activities.
• Responsible for defining and creating all stats and impact assessments.
• Led integration test execution.
• Led and supported user acceptance testing.

Confidential

Senior Consultant

Responsibilities:

• Managed the establishment of various Informatica server environments for various data migration processes between different IT Platforms, via the use of Informatica, UNIX, LINUX, and various IT tools.
• Planned, designed and developed an Enterprise Datamart.
• Managed and delivered detailed project tools, based on Velocity.
• Developed various ETL applications to transform data from VSAM files into an Oracle data warehouse via the use of PowerExchange and PowerCenter.
• Utilizing Informatica Velocity best practices, I evaluated over 100 mappings and sessions for optimal performance.
• Worked on a supervisory and mentorship role for Informatica Junior analysts.
• Performed and managed Informatica upgrades from Informatica 5.1.1 to Informatica 7.1.1.
• Performed and managed Informatica upgrades from Informatica 6.1.1 to Informatica 7.1.2.
• Performed and managed Informatica upgrades from Informatica 7.1.2 to Informatica 7.1.3.

Confidential

Technical Lead

Responsibilities:

• Performed data and server analysis on client sources via the use of Informatica Power Center mappings and various Oracle tools to help facilitate and determine the candidate consolidation list of Kalamazoo PGRD servers and applications.
• Worked with client on one-to-one and one-to-group meetings to gather further analysis and data to facilitate the generation of MRE’s (Migration Readiness Evaluations) on the candidate consolidation list of servers.
• Generated various MRE’s on the consolidation list of servers that were submitted to the Confidential Data Receive Team for various migrations and retirements.
• Developed and tested various Informatica mappings, Oracle SQL scripts, and LINUX shell scripts to migrate and transform data off servers bound for retirement.
• Managed and worked on the data migration and transformation of the Share01 and Share02 directories on the USPONAS58 server in Kalamazoo to NLVFS010 server in New London, which resulted in the retirement of USPONAS58 server.
• Managed and worked on the data migration and decommissioning of the Chemlink Client application at Confidential Kalamazoo.
• Managed and worked on the data migration and retirement of the Confidential Time Allocation System off USKZOFS25 server in Kalamazoo.

Confidential

Technical Lead

Responsibilities:

• Performed data analysis on various Confidential assays via the use of SQL*Plus to facilitate the conversion process of a Confidential assay into a Confidential Protocol.
• Worked with the client to analyze the detail experimental data of a Confidential assay verses the experimental data of a Confidential protocol, to implement the mapping of the experimental data from the GDD (Global Discovery Database) to the BDS (Biological Data Store).
• Helped with the data analysis of the BDS experimental parameters, to map the Confidential detail parameter data to Confidential parameters.
• Managed and produced data migration documentation for the assay / protocol transformations which are used to migrate data between the GDD, and the BDS.
• Managed and ran data analysis on all of the assays in the GDD, to facilitate the selection purposes of various assays, which are used for development, and testing purposes.
• Worked on the establishment of the Informatica server environment for the data migration processes between the GDD and BDS in the DMF (Data Migration Facility).
• Managed, developed and tested various oracle SQL scripts and Informatica mappings to migrate the registration data of a Confidential assay into registration data of a Confidential protocol.
• Developed and tested various oracle SQL scripts and Informatica mappings to migrate the experimental data of a Confidential assay into the experimental data of a Confidential protocol.
• Helped with the Informatica server connectivity between the DMF Informatica server and the Client’s Informatica server, to copy Informatica code into the client’s environment.
• Ran various Informatica mappings and SQL scripts to migrate GDD assays into BDS protocols against the client’s test environment.

Confidential

Consultant

Responsibilities:

• Worked on the Development of the BDS (biological data store) data mart, which allows the company to study various experimental results.
• Analyzed the source data used for the population of BDS, via the use of a data analysis scientific tool provided by Confidential, to determine which source data will be filtered out
• Worked on the Development of the SAR (structural activity request) data warehouse, which allows the company to summarize experimental data.
• Produced documentation to explain the source to target mappings for various Informatica applications.
• Developed various Oracle and Informatica applications to extract data for various Oracle 7.3 environments to load into a new Oracle 8i environment.
• Supported various ETL applications to support the implementation of the BDS and SAR.
• Trained the Confidential scientific IT personal on how to monitor and support various ETL applications.
• Designed a documentation application, which documents the database, schema, table, column, and mapping logic for each source going into the data warehouse.
• Tested and validated all data loaded into the new Oracle 8i data warehouse, via the use of data analysis scientific applications provided by Confidential .

Confidential

Independent Informatica Consultant,

Responsibilities:

• Developed a Net Economic Value database, which allows a company to track the historical profitability of a home loan, via the use of Informatica, PL/SQL, UNIX, and various IT tools.
• Implemented an application to document the client’s mainframe DB2 environment for ETL (Extract Transform Load) purposes.
• Designed various data models via the use of Erwin, to document the data warehouse environment.
• Documented and designed the data architecture of the Source to Target mappings via the use of Informatica.
• Produced documentation for the installation and configuration of Informatica.
• Installed and configured the Informatica client on a Windows NT environment.
• Installed and configured the Informatica server on a UNIX environment.
• Developed various ETL Informatica applications to extract data from various mainframe and GUI environments to load into a new oracle environment for Net Economic Value Purposes.
• Developed various ETL Informatica processes to perform mathematical calculations for Cash Flow purposes.
• Developed various ETL Informatica processes to perform checks for missing data.
• Produced documentation to explain the source to target mappings for various ETL Informatica applications.
• Trained the IT personal of Chase Manhattan Confidential to maintain various ETL Informatica applications.

Confidential

Informatica Consultant.

Responsibilities:

• Developed and implemented an Informatica ETL (Extract Transact Load) application to extract data from various sites around the world, to update the Global Phone Directory on a daily basis.
• Developed various Informatica ETL processes to load Oracle tables that replaced various DB2 tables.
• Re - developed and supported an Informatica ETL application that updates Confidential GANs (Global Article Numbers) on a daily basis.
• Programmed and implemented an Informatica ETL process for hierarchy and history purposes.
• Performed advanced data analysis on customer data, via the use of MicroStratgy.
• Trained the support and operations personal of Confidential to maintain various Informatica ETL applications.

Confidential

Oracle Consultant

Responsibilities:

• Managed the implementation of Oracle Applications/Departure Planning Automation release 10.7.
• Managed and trained the shipping personal on Oracle Applications/Departure Planning Automation release 10.7.
• Managed and trained the IT personal of Dana Confidential on Oracle Applications release 10.7.
• Trained the IT personal of Dana Confidential on Oracle 8.0 Database Administration.
• Created and implemented the User Guide for Departure Planning Automation shipping solution.
• Created and implemented the administrators’ documentation for Oracle Applications release 10.7.
• Created Bar Coding Reports through the use SQL*PLUS for the Departure Planning Automation shipping solution.

Oracle Consultant

Responsibilities:

• Worked on the installation of the Oracle 8.0 Database on HP-UNIX platforms.
• Installed Oracle Applications release 10.7 on HP-UNIX platforms.
• Tested Oracle patches against Oracle Apps 10.7 to eliminate software bugs.
• Trained members of the IT user community on Developer and Designer 2000.
• Worked on the implementation of the Oracle Automotive Vertical Solution.
• Loaded enterprise data into an IBM MQ series queue, through the use of SQL Loader for testing purposes.
• Implemented UNIX procedures, to maintain the companies trading partner system via the network.
• Configured UNIX triggers, to maintain the companies order alert system via the network.
• Implemented a technical management system for TAR resolution.

Oracle Consultant

Responsibilities:

• Worked on the installation of the Oracle 7.3 Database on Sun Solaris platforms, with the configuration of the Sonoma Arrays.
• Worked on the installation of Oracle Applications release 10.7 on Sun Solaris platforms.
• Created various PL/SQL scripts to facilitate the installation of the Oracle Database.
• Created bar coding reports through the use of SQL*Plus, for concurrent manager submission.
• Installed and configured Oracle Networking Tools on various UNIX and NT servers for network enhancement.
• Configured UNIX and NT servers for TCP/IP addresses, proxy settings, and TNS Names files.
• Configured a Domain Names Server (DNS).
• Implemented a support management system for the GLDI user community at Confidential with all software and hardware configuration to create a fully functional help desk.
• Supported the Oracle Financials and Manufacturing user community.
• Created an Oracle Patch Repository to maintain Oracle Instances.
• Registered various Oracle Reports into Application Object Library (AOL).
• Produced implementation documentation for all work done at Confidential, using AIM 2.1.
• Maintained the Network Drive for Confidential .
• Provided technical support for all Corporate UNIX servers, NT servers, databases and TCP/IP networks.
• Trouble shoot all database accounts, UNIX accounts, network connections and print servers via UNIX tools.
• Supported Operating System installations of Win 3.11, Win 95, and Win NT 4.0.
• Supported server side software installations of Oracle Forms.
• Configured enterprise and individual systems for TCP/IP addresses, proxy settings, and TNS Names files.
• Configured end users systems for remote dial up network access using PPP, Smart term 420, and Hyperterm.

Confidential

IT Technical Support

Responsibilities:

• Provided Networking Support for Novell, Mainframe 3270, and Netway 2000 users.
• Provided Technical Support to the information sector of Confidential .
• Provided Technical Support for 6000 Macintosh and PC users.

Quality Control/Production Line

Responsibilities:

• Supervised the Assembly and Burn-in line.
• Performed Quality Control / Assurance on Pentium Computers.
• Installation of operating systems on Sun, HP, and Sequent platforms.

IT Technical Support

Responsibilities:

• Supervised an IBM/MAC Lab for the students of Confidential .
• Upgraded hardware/software needs for all Databases and Networks.
• Upgraded 486’s to Pentium Computers.
• Configured UNIX Kernels with necessary kernel drivers.