SUMMARY:

• Software Manager/Engineer with 20+ years system development experience on a wide range of applications using Informatica Power Center (8.5, 9.5) with Oracle (10,11) and PL/SQL, and PROGRESS 4GL RDBMS.
• Adept at Data Warehouse Architecture including Star,Snowflake, Dimensional and RDMS Database Design in a multi - platform network.
• Experienced Technical Writer in multiple lifecycle phases of business and technical specifications in an Agile/Waterfall process environment.
• Able to manage projects from design concept to final deployment while meeting project timelines.
• Self-motivated innovational thinker, focused on project completion through effective planning, problem solving and team collaboration.
• When conventional methods are not enough, I will think out of box to resolve issues.
• I am a quick learner and can pick up any newer applications in a short time given the resources to do so.

TECHNICAL SKILLS:

Programming Languages: Informatica Power Center (v8,9), Oracle(v10,11), PL/SQL, PROGRESS RDBMS (Versions 10,9), UNIX(AIX,HPUX, and other Various Platforms), MS DOS

Methodologies: Scrum, Agile, Waterfall, Service Oriented Architecture (SOA), SDLC

Tools: Erwin, MicroStrategy, MS Word, Excel, Powerpoint and Visio, Various Job and Source Control software.

PROFESSIONAL EXPERIENCE:

Confidential, King of Prussia, PA

Technical Lead Developer Consultant

Responsibilities:

• My role was Technical Lead to develop Informatica Applications for a project related to import SQL Server data containing Manufacturing and Financial Data.
• Imported tables to an Oracle Data Warehouse based on business specification from the system analyst.
• Assisted in designing the process workflow and table creation using Erwin. Created workflow processes that were executed through TWS, which is the client’s main Job control application.
• Data stream required cycled feeds at 15 minute intervals going from SQL Server to ODS/DW. This process was a key enhancement for reporting services such as MicroStrategy and other reporting applications.
• It contained 86 separate workflows that were timed to work in a cohesive unit to maintain data integrity of imported data.
• This also required some unix scripting to create timer scripts to control the process in TWS. SQL scripts were written by me for both Oracle and SQL Server DB extractions in Informatica.
• Performance tuning was a collaboration between I and the Business Analyst to arrive at best possible solution.
• Collaborated with other developers for best solutions to obtain Projects goals in specified timelines.
• Performed work after hours and on weekends when needed.

Technical Lead Developer Consultant

Responsibilities:

• My role was Technical Lead for Informatica Applications development on varied projects related to SAP data imports.
• Imported files from SAP to Oracle Data Warehouse was based on business specification related to Manufacturing and Retail.
• Created Workflows that were executed through TWS, which is client’s main Job control application.
• Data stream required daily feeds going from SAP to ODS/DW. Much of the ETL process was driven by Informatica, with some specialized data cleaning processes.
• Performance tuning was a collaboration between I the Business Analyst, other Developers and Oracle DB management team.
• Oversaw the entire migration process to Production and resolved any maintenance issues during UAT.
• Collaborated with other developers for best solutions to obtain Projects goals in specified timelines.
• Performed work after hours and on weekends when needed.

Senior Data Warehouse Developer

Responsibilities:

• Created project solutions using Ab Initio software in a Teradata Environment.
• Scrum based methodology on a 2 week cycle period.
• Beginning to implement the use of Hadoop.
• I was training with other Ab Initio developers when project was ended do to department resource downsizing and redistribution.

Senior Data Engineer

Responsibilities:

• Informatica application development (v9.1) with Data Warehouse.
• Performed specification analysis, design and implementation with Informatica Workflows.
• Required XML development and multiple flat file formats in Informatica.
• Most projects were related to Astute Data Warehouse and extraction of data in our own data warehouse.
• We also validated incoming data, analyzed customer data and ftp’d results back to the requesting customer.
• Duties also included maintaining current system design for Oracle Packages (v11) and eventual conversion to Informatica.
• Some contact with customers to address issues and coordinate design specification for any modifications that were needed.
• Operational platform was in Windows based servers with Oracle and Informatica as the primary ETL applications using Autosys.

Senior ETL Application Developer

Responsibilities:

• Focused on client orientated operations using Dataflux ETL Application Software.
• Trained on the operation of the system software prior to moving to maintenance development.
• Contract ended before I could make the full transition to maintenance development.
• Acted in an Operational/Development role for the Dataflux Application that was currently in place and was being developed for a Pharmaceutical client.
• Duties included the operation of the application on a per object basis in the development, QA and Pre-Production area.
• Executed the objects and verified the input and output data related to the execution objects.
• Documented any discrepancies and modified ETL and Autosys as needed.

ETL Application Engineer

Responsibilities:

• Designed new business processes and ETL objects to fulfill business goals.
• Wrote SQL in both Oracle and SQL Server for utilization in Informatica.
• Exhibited excellent working knowledge of Workflows, Worklets, Sessions, Tasks, Mappings and importing data maps into Informatica. Completed over 500 different mappings in finance and banking areas.
• Maintained month end data warehouse reload process.
• Worked on MIODS and Lender Live projects that used ODS methodology for daily updates.
• Worked with 3rd party data interfaces such as Attunity with Informatica importing Cobol Data.
• Completed migration and rollback of Informatica objects, created repositories, and created user accounts.
• Created or modified UNIX scripts as needed for the ETL process and data import/export between systems.

Independent Consultant

Responsibilities:

• Worked on data warehouse project for Corporate Business Intelligence for electrical material distribution company.
• Defined data models from branch locations and designed data feeds to corporate database using Informatica Power Center 8.1, MicroSoft SQL, and PROGRESS RDBMS.
• Designed FTP process for retrieval of branch information to Informatica Data Warehouse.
• Wrote detailed specifications on data work flow and database modeling.
• Wrote business analysis and end user documentation for data transfer process.

Independent Consultant

Responsibilities:

• Worked hands on with live manufacturing production software system for major steel manufacturer.
• Developed, tested and consulted on best resolutions to current software needs until new ERP system was implemented.
• Functioned as Business Analyst, Lead Developer and QA tester for mid-sized development projects.

Systems Architect /Software Architect

Responsibilities:

• Led systems design efforts to ensure major design issues such as system integration (SOA), security, performance, data integrity and scalability were addressed.
• Collaborated with other organizational leaders to ensure cross-project integration and to avoid duplication of effort. Worked with the quality assurance team to ensure the test strategy covers all aspects of the project.
• Evaluated new technologies, software products and vendors to determine feasibility and desirability of incorporating their capabilities within the company's products.
• Prepared application Design and Technical documentation including flowcharts, diagrams and test plans that were needed for conceptualization of the project. Prepared and demonstrated projects for support handoff operations.
• Followed SDLC company guidelines.
• Mentored all project team members on software lifecycle.
• Performed complex application code development that ensured system performance, quality and security.
• Re-engineered client interface for custom order processing and delivery system from legacy application.
• Implemented new requirements for Secure Shredding Division, Archive Retention project, Account Management module . Developed key components of the shredding business objects. After implementation of Secure Shredding Division the new module accounted for 9% of order volume. Incorporated a new process design in archive retention and destruction.
• Developed new financial feeds for commission processing and revenue generation allowing for independent processing of commissions with return data interface to billing module under Oracle financials.
• Collaborated on new Bar Code Scanner process for warehouse inventory storage. Required utilization of new scan gun technology and its related language of MCL. This project streamlined the order processing and inventory control business goals, thus providing increased level of accuracy of stored archives.
• Modified Arrears Contract processing to the Customer Accounts Contract processing module. This included modifications to data entry, contract billing and inventory billing. This modification contributed to the inclusion of Governmental contracts, thereby increasing company revenue.
• Designed, developed and implemented re-engineered Payroll module to meet with SOA guidelines. This included employee time entry/update, payroll time calculation feed to ADP, and all reports. The result of which decreased data entry time and increase batch-processing efficiency.
• Ensured third level support concerns are considered throughout the product development (error logging, auditing and critical paging are examples).

Supervisor

Responsibilities:

• Managed Customer Support Department on interim basis, winning employee of the quarter during that time period.
• Re-engineered Billing engine by redesigning multi-threaded billing process. After completion, customer reported 0% error rate in billing and reduced support calls by 95%.
• Reviewed technical specifications for business accuracy.
• Major customer contact for support issues.
• Trained new employees on software lifecycle and business applications.
• Maintained source code control and application version control for three different versions of applications distributed worldwide.
• Traveled to customer locations in the U.S. and abroad.
• Trained outsourced development staff on all areas of application for transitioning development.