SUMMARY:

• Have worked on Interim Secret Clearance.
• 35+ years of progressive IT experience in all aspects of software development, including programming, analysis, design, testing, project management, and supervision.
• 20 years mainframe experience - IBM MVS, COBOL, JCL, IBM Utilities, Syncsort, TSO.
• 25 years PC experience - Windows, MS Office, ABC Flow, Visio, Erwin, Lotus Notes, TextPad.
• 17 years SQL experience - (Ordered most to least) DB2/UDB, Oracle, DB2, Teradata, Sybase, MSSQL.
• 17 years SQL Tools - Rapid SQL, SQL Tools, SQL Developer, SQL Assistant, Aqua Data Studio.
• 16 years Informatica PowerCenter (5.1 thru 10.2) experience in data warehousing, data archiving, and production development roles. Considered an Informatica power user and go-to guy.
• 4 years Data Warehousing
• 6 years Business Intelligence - Custom reporting, Brio, Crystal Reports, Business Objects, RDP.
• 4 years UNIX - AIX, FTP, WinSCP.
• 3 year AGILE - Developer and scrum team lead.
• Scheduling - CA7, Control-M, Informatica
• Highly analytical wif demonstrated talent for innovative problem solving.
• Team player wif excellent communication skills. Enjoy halping others.
• Strong work ethic, and ability to work independently wif minimal supervision.
• Recognition from Raytheon IDS for creative process improvements.
• s from Confidential for individual contributions. Cash value $1500.
• s from Confidential for individual and group contributions. Cash value $12,600.
• Leadership: Team supervisor, Project Manager, Lead Analyst, Treasurer and President of Confidential Halo Club, softball team captain, ski trip captain.
• Diverse work history prior to IT.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Joined a maintenance and support team providing customer and production support for a variety of ETL and reporting applications. At the time me joined, the team was getting slammed wif problem tickets due to the recent implementation of major database changes. During my time there me was given 2 projects. The first was to analyze and correct an ETL process dat was generating duplicate records on 3 outgoing vendor files. me completed dis project. The second was to analyze and correct an ETL process dat was sending 14 different transaction records to an outside vendor.
• The majority of the transactions over the last year had been failing, so the vendor database dat was being maintained by these transactions was sorely out of sync wif BCBS in-house data. A major restructuring of the ETL process was required, along wif new processes to provide ongoing validation, and account for manual transaction being made to the vendor database.
• These changes were near completion, and were being prepared for production implementation when me was told dat my contract was not being renewed due to shortage of funds. me spent the remaining week and a half documenting the process, the status and location of all components, and a few remaining issues. On my last day me presented a two-hour knowledge transfer session to 3 ETL developers and the product owner.

Confidential

Informatica Developer

Responsibilities:

• Hired as an Informatica Developer wif the understanding dat thel desired to convert many existing processes from complex PL/SQL to Informatica.
• As me familiarized myself wif the processes, me had ongoing discussions wif myvendor manager regarding the feasibility of conversion to Informatica. due to shortage of fundsbeing analyzed; the complexity of the existing SQL; the lack of available knowledge about why the SQL was doing what it was; and a very basic version of Informatica wif no add-ons, no administrator, no support contract and an uncertain future.
• My manager reluctantly agreed dat the intended conversion was probably not worth the cost and risk, so the idea was scrapped. At dat point my job became one of production support on complex SQL and a variety of other technologies for which me was not well suited. After discussing wif my manager me submitted my resignation and we parted amicably.

Confidential

Informatica Developer

Responsibilities:

• Joined an ETL team which provides production support and small project enhancements to a wide variety of applications dat utilize substantial Teradata scripting wif Informatica PowerCenter as an execution platform.
• Successfully constructed numerous Teradata BTEQs, SQL scripts, Informatica mappings, and workflows. dis position provided a valuable boost to my Teradata SQL skills.

Confidential

Informatica Developer

Responsibilities:

• Individually developed and tested ETL solutions for 3 of the 23 companies, including 2 of the largest .
• Assisted wif ETL tuning, providing key recommendations for efficiency enhancements.
• Lead a 3 member scrum team to propagate minor enhancements across multiple ETL solutions.
• Provided SQL queries and preliminary process design to identify members of one subsidiary company dat are a likely match to members of one of the other 22 subsidiary companies. dis process was based on a diverse strategy for comparing client demographics across 80 million accounts.
• Successfully communicated and coordinated wif H1B and off-shore team members, forming lasting friendships in the process.

Confidential

Informatica Developer

Responsibilities:

• Individually designed, developed, and tested 5 complex ETL solutions for conversion of legacy aircraft maintenance records and parts inventory data from Oracle tables into a new Teradata based data warehouse. Requirements documents were provided by the Technical Lead, but me worked closely wif her during the construction and testing to vet table definition and index discrepancies. ETL solutions were developed and successfully executed on a Test platform, and tan submitted to the deployment team for installation into pre-prod and prod.

Confidential

Sr. Engineer

Responsibilities:

• Confidential, a commodities trading firm, was in the process of converting trading history from 12 different sources into a common data warehouse. They had already constructed a set of Informatica mappings and workflows dat were to be used as the ETL template for all 12 source conversions. My assignment was to complete the in-process ETL for one source, and tan to construct the complete
• ETL for a second source. me completed these tasks successfully, but wif great reservation. me found the template ETL to be unnecessarily complex, and wifout logical flow. me took no satisfaction in replicating complex code dat would be very difficult to maintain, so at the end of the first 4 month contract term me opted out.

Confidential

Lead Informatica Developer

Responsibilities:

• Is highly parameterized, facilitating process replication wif limited modifications per new source.
• Uses custom built User Defined Functions for editing input data and reformatting it for the target.
• Generates detailed errors messages at column level to an error table for user review and correction.
• Programmatically reconciles record counts from control file, input file, bad record file, staging table, error table, and target table.
• Loads valid data to the data archive, and identifies rows dat cannot be loaded due to invalid primary keys, duplicate keys, and orphaned rows.
• Individually designed and constructed dis process.
• Development time was reduced from the estimated 8 hours per table to 4 hours per table, allowing for significant scope expansion. We were consistently ahead of schedule and under budget.
• Completed construction and testing of 2354 Informatica mappings, 656 workflows, 608 parameter files, and 2923 SQL scripts.
• On 7/1/2012, 22 systems wif 136 databases, 763 tables and 385 million rows of data were successfully archived. 4 Systems were pre-loaded wif static historical data. The remaining 18 were loaded via submission of one Master Workflow which executed in about 15 hours.

Confidential

Sr. Apps. Developer/Analyst

Responsibilities:

• Assumed sole responsibility for maintenance and warehousing of drug claim data.
• Continuing support of Predictive Modeling software as technical Administrator.
• Sole support of numerous production data extraction processes dat use Informatica Power Center.
• Independently conceived, designed, developed and implemented the “Data Inventory” process (a home grown data profiler) using Informatica and UDB, which could be quickly adapted to summarize the content of the data elements in any input file or table. Could report on 100 columns of a 50 million row table in one pass.
• Developed numerous processes for extraction of historical data from Mutual DB2 and UDB sources, for conversion to the Coventry system.

Confidential

Medical Claims Systems Analyst

Responsibilities:

• Continuing support of Predictive Modeling software as technical Administrator.
• Conversion of an existing reporting system from VB6 to VB .NET.

Data Warehousing Systems Analyst

Confidential

Responsibilities:

• Independently developed a complex data extraction process to feed vendor supplied Predictive Modeling software. Required extraction of one years worth of medical and drug claims data from 30 historical tables on DB2UDB. Data was extracted, joined, analyzed and translated using Informatica. The resulting 12 million rows of data were loaded to 3 staging tables for input to Predictive Modeling analytical engine.
• Ongoing support of Predictive Modeling software as technical Administrator.
• Independently analyzed, designed, modeled, coded, tested, implemented and documented the Bonus Data Mart and the load processes required to extract data from 10 Oracle, DB2 and flat file sources; perform the necessary editing and error reporting; and load validated data to a 9 table star schema.
• Several small scale projects involving ETL of data into DB2UDB tables of the data warehouse.

Production Systems Analyst

Confidential

Responsibilities:

• Performed problem analysis, design, coding and testing. Significant use of DB2 SQL.
• Independently conceived, designed, coded, and tested the “JCLSUMM” program dat parsed through the JCL library; collecting dataset details including Job, STEP, DCB and GDG attributes; and tan consolidated and formatted those details and attributes into a report, ordered by dataset name. dis process was also capable of performing wildcard searches, and summarizing results. Useful for tracking datasets and keywords when dataset specific or global modifications were to be performed on the library.

Confidential

Senior Software Engineer

Responsibilities:

• Volunteered to develop a process to build Rewards detail records from converted monetary transactions, in response to an in-trouble project. Excellent results.
• Subsequently was recruited to customize above Rewards procedure for another project dat realized their processing gap just 48 hours prior to conversion. Much rework. Excellent results.
• Developed an in depth presentation on all aspects of converting account numbers.
• Identified need for additional process to allow balancing of monetary transactions during pre-conversion testing. Successfully implemented dis, relieving customers concerns.
• Team Quantum in 9/99 for analyst role on 3.5 million account GE conversion.
• Individual Quantum in 8/98 for constructing reusable routine dat converts variable records wif packed unsigned data (from Assembler program) to a COBOL friendly format.

Software Development Manager

Confidential

Responsibilities:

• Supervised a total of 38 employees over dis period, up to 15 at once. Exempt, non-exempt, entry level to seasoned veterans, contractors, full time, part time and interns. Strong contributors were advanced to large file conversion teams, thus high turnover and constant re. Very challenging.
• Developed Excel spreadsheet of employee overtime for comp time consideration.
• Developed Excel spreadsheet of employee salaries for comparative salary management.
• Served as project analyst for several Ticket Database conversions (see bullet below).
• Developed course and materials: What Is The Ticket Database? How Do We Convert Into It?
• Team Quantum in 3/96 for my team's successes in small file conversions and data installs.
• Team Quantum in 1/95 for project manager/analyst role in 500,000 credit card Comermex Conversion.

Senior Project Manager

Confidential

Responsibilities:

• me was the Conversions department's first venture into formal project management. me was charged wif defining formal project management procedures for large conversions. dis involved defining and estimating component tasks, identifying critical path, and constructing a logical base project plan dat could be successfully completed by the pre-determined conversion date. s include:
• Attended an intense Project Management course taught by Duncan-Nevison consultants.
• Developed a new project template, identifying all possible conversion tasks and standard estimates for each. dis facilitated more precise project definition and more accurate project estimating.
• Applied newly defined project management tools to the conversion of credit card accounts from an Association of 23 banks.
• Independently researched, developed and implemented a Ticket Database conversion subsystem for capturing monetary transaction data from VISA and MasterCard interchange records which were received as complex variable length records, each containing from 4 to 10 of 21 possible data segments. Wrote re-useable base conversion specifications and code. Successfully completed the first conversion into the Ticket Database.

Software Engineer, Senior Software Engineer

Confidential

Responsibilities:

• Project manager/analyst for multiple credit card conversions, and one merchant conversion.
• Individual Quantum in 5/93, for project manager/analyst role on Brooks Brothers retail conversion.
• Individual Quantum and FAT CAT in 9/92 for analyst role in 10 million credit card, 4 billion pound sterling, conversion of the Signet processing system in Basildon, England.
• Individual Quantum and FAT CAT in 9/90 for project manager/analyst role in 1 million credit card conversion for First Confidential Bank. Independently designed a complex process for assigning 1 of several thousand account pricing codes based on a variable number of key values.