SUMMARY:

• An Engineer with over 20 years of business experience, Confidential is especially skilled in designing high performance ETL and Data Warehousing solutions.
• Solid experience in Ab Initio. He is an organized problem solver, excellent communicator, a very effective team player, and an accomplished developer.
• Confidential ’s industry experience is extensive with roles ranging from analysis, business analysis, documentation, design and development.
• He has received extensive training in all facets of Ab Initio design and implementation techniques including Compact’s Best Practices for Design and Development. He continues to build upon this extensive skill set with experience in the following:

TECHNICAL SKILLS:

Hardware: RS6000, HP 9000/T500, HP Emulator, HP Protocol Analyzer, Iridium Network Simulator

Languages: C, C++, Expect, HTML, XHTML, PERL, SQL, UNIX Shell scripting

Methodologies: Client/Server structured design methodology, business process reengineering, data and process modeling, networking and computer architect

Operating Systems: Microsoft Windows 3.x/95/98/NT/2000, MS - DOS, IBM AIX, HP-UX, Linux, MAC OS X, Solaris

Warehousing Tools: Ab Initio, ADSM Storage Software, Business Objects I, Clearcase, Informatica, Visual Orchestrate (DataStage), Sterling EDI Translator

PROFESSIONAL EXPERIENCE:

Confidential, Oakbrook Terrace, Illinois

Senior Software Engineer

• Lead ETL Architect for Penguin/Business Analyst. Penguin is an IT Implementation providing extracting Penguin customer data from via the cloud and loading it into an Oracle database for reporting. Responsibilities included managing Offshore Resources, providing Business Analysis, providing quality assurance, providing both Hi/Low level design documents, providing oversight and developing Ab Initio graphs to process and transform data. Agile environment used.
• Lead ETL Architect for EPP/Business Analyst . EPP is an IT Implementation for eCommerce Product and Pricing. This project involved pulling and transforming eCommerce data both on a daily basis and on an aggregate weekly, monthly and quarterly level and loading it into an Oracle database for reporting. Responsibilities included managing Offshore Resources, providing Business Analysis, providing quality assurance, providing both Hi/Low level design documents, providing oversight and developing Ab Initio graphs to process and transform data. Agile environment used
• Lead ETL Architect and Developer for Kodak/Business Analyst . Kodak is an IT Implementation for extracting Kodak data and scoring the data per requisite business rules. This project involved extracting, transforming and loading data on a daily basis and loading it into an Oracle database for reporting. Responsibilities included designing, coding, providing quality assurance, providing Business Analysis, providing both Hi/Low level design documents, and developing Ab Initio graphs to process and transform data. Agile environment used
• Senior Onshore Lead and Developer for Data Warehouse Group and Business Analyst. The Data Warehouse group supported Shutterfly initiatives for their Photo books, Cards and Stationary, Calendars, Photo gifts and Share product lines. This project involved extracting, transforming and loading data into an Oracle database on a daily basis. Responsibilities included managing Offshore Resources, providing Business Analysis, providing quality assurance, providing oversight, providing both Hi/Low level design documents, obtaining requisite Business Requirements for Offshore Resources. Additional responsibilities included and developing both Ab Initio graphs/Informatica jobs to process, transform and test data. Agile environment used.

Senior Software Engineer

Confidential

• Program designed to reward customers with points for which they can use to purchase items in the future. Responsibilities included developing both DataStage jobs and Netezza SQL scripts to process and transform data from Teradata to Netezza.
• Lead ETL Architect for Toys Lost Sales/Business Analyst . Toys Lost Sales is an IT Implementation providing daily estimates of the “lost-sales” of out-of-stock occurrences for each item at each store, by comparing with the sale numbers of the item in “like-stores” that did not run out of stock for that item on that day. Responsibilities included managing Offshore Resources, providing Business Analysis, providing quality assurance, providing oversight, and developing both DataStage jobs and Netezza SQL scripts to process and transform data.
• Lead ETL Architect for Store EIS Dashboard/Business Analyst . The Store EIS dashboard highlights financially audited KPIs from the Store Format/Regional level detailed by Geography and by Store Format. The Heat Map allows an interactive experience where the user changes the metrics to be displayed. Responsibilities included managing Offshore Resources, providing Business Analysis, providing quality assurance, providing oversight, and developing both DataStage jobs to pull and process Mainframe Data and Netezza SQL scripts to process and transform data.

Confidential

Information Management

• Responsible for providing both operational leadership and management in the areas of business planning and business process and information management. Responsibilities included solving new operational problems, streamlining old operational processes, ensuring operational excellence, knowledge management for internal operations and chairing the bid review process.

Confidential

Manager / Senior Technical Lead/ETL Developer

• Responsible for developing Ab Initio graphs that extracted, validated, and transformed mainframe data from Confidential ’s LASER database for the SIRS conversion. After completing complex transformations, all required fields inserted into a single record for further processing downstream. Additional data from multiple streams underwent this same process. Managed/Mentored a Confidential employee for this project and provided Business Analysis.
• Created and administered a configuration management process to put the thousands of pieces of code created for this project into test and production environments. Duties included modifying existing PERL and Korn shell scripts to create the necessary multifile systems in the appropriate places, adding parameters to reduce build, configure, and deployment times; creating processes to label code; developing backup processes to manually transmit the code needed for testing; and writing scripts to automatically run the code during testing.
• Replicated the same successful methodology/model for the acquisition conversion. Primary responsibilities were for the Cash Committing and the EarlyFundingsystems. Provided both the overall architecture for this project and managed it.
• Responsible for rewriting code that was written in both Java and PL*SQL and rewriting it in Ab Initio to improve performance for the SIR Batch Processing Rewrite project. This involved analyzing the existing code in order to determine the business rules and then rewriting the code in Ab Initio using the ETL methodology.
• Worked on Restatement for the FAS65, GFAS and WLCBS projects as a Senior Lead/Manager. Tasks included Application Development, Production Support, and Unix Systems Support. As a Senior Lead in Production Support tasks included the basic debugging/fixing of Ab Initio graph failures in IP and Production in addition to creating basic Ab Initio graphs for smoke test purposes. Managed/mentored Confidential employees, Knightsbridge employees, Kensington employees and other consultants.
• Utilized: Ab Initio, BOXI, EME V2-12-2, Korn shell, PERL, Oracle, SQL, SQL*Loader, Sun Solaris, Teradata, and UNIX.

Confidential

Integration Tester / Analyst

• Worked on Integration Testing for the FCT Phase 1 Project. This involved reviewing Detailed Designs from DBL Premium, RS Loss, and Pool Reserves and creating the Informatica mappings from these Detailed Designs. While creating the Informatica mappings, analyzed the Detailed Design documents for flaws/errors. Upon finding flaws/errors, these were logged into ClearQuest. The Developer responsible for the Detailed Design would then address and fix the flaws/errors in the Detailed Design document in addition to fixing his/her Informatica mapping based upon this analysis
• During the actual Integration Testing, defects were logged based upon differences from the data that his mappings produced against those that the Developer produced. Differences would be investigated and a defect would be opened if deemed appropriate. In this way, the integrity of the Developers mapping was tested.
• Utilized: Informatica, IBM AIX, and DB2.

Confidential

ETL Developer / Database Administrator / UNIX Administrator

• Provided ETL analysis, design, testing, implementation, and database administration for a project that involved creating and administering an Oracle database. This was a proof-of-concept project where the customer was shown an efficient method for storing and querying data using the dimensional model. The process included creating volume groups and stripping them across multiple disks to increase performance and create the actual database. Used Ab Initio to land, clean, process, and load the data into the database and into the fact/dimension tables.
• Used PERL to generate scripts for table/tablespace creation, SQL*Loader, control file, FTP, and data cleansing.
• Utilized: Ab Initio, PERL, Oracle 8.7.1, SQL, SQL*Loader, and IBM AIX 4.3.3.

Confidential

ETL Developer / Analyst

• Worked on a Scoring Data Mart, designed to provide advanced statistical models that Confidential could use to drive its marketing campaigns. The existing customer-centric models had to be scored and made available to the campaign management tool on a regular basis. The primary component of the scoring environment was a data mart that contained both customer attributes and scores.
• Supported and maintained the Ab Initio graphs used to implement the mart’s major functionality. He also leveraged Ab Initio to implement the process that transmitted data through FTP to the research center for verification processing.
• Utilized: Sun Solaris, Ab Initio, and Oracle 8.x.

Confidential

ETL Developer / Database Administrator / UNIX Administrator

• Provided ETL analysis, design, testing, implementation, and database administration for a project that involved creating and administering an Oracle database. Used PERL to generate scripts for table/table space creation, SQL*Loader, control file, and data cleansing. Confidential used Ab Initio to load both the dimension and fact tables.
• Utilized: Ab Initio, PERL, Oracle (8.7.1), SQL, SQL*Loader, and AIX 4.3.3.