SUMMARY:

• Proven experience in ETL administration and development and analysis, understanding of business requirements and follow - up, project management, and maintaining a team for ETL and Oracle database development. More than 25 years of experience with database management and data warehousing applications and 20 years working with ETL programming.
• Informatica PowerCenter Design, coding and testing skills (version 6.x - 11.x) - 10 years
• Ab Initio Administration, Design, coding, and testing skills (v. ) - 10 years
• Installing, maintaining Ab Initio environments and EME Administration - 7 years
• SQL and PL/SQL development in an Oracle environment - 20 years
• SQL development in a DB2 environment - 4 years
• SQL development in a SQL Server environment - 4 years
• Data modeling with experience in dimensional modeling - 5 years
• Unix and Kornshell scripting - 10 years
• Analysis, troubleshooting, resolution skills in UNIX/Oracle production environment - 10 years

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c, DB2, Microsoft Access 97/2007, IDMS, Informix, MySQL 5.1, SQL Server 12

Operating Systems: UNIX on Sun Solaris, HP-UX, All versions of Microsoft Windows

ETL tools: Informatica, Ab Initio, PL/SQL

OLAP Reporting tools: Crystal Reports IX, Cognos Impromptu, Cognos Powerplay, MicroStrategy DSS Agent, Business Objects, Tableau

Oracle PL/SQL tools: TOAD, Oracle Developer, Oracle SQL Plus

Other software tools: Hummingbird, All versions of Microsoft Office (Word, Excel, PowerPoint, Visio)

Testing tools: HP ALM

Microsoft tools: Word, Excel, PowerPoint, Outlook, Teams

UNIX tools: AWK, Perl, VI Editor

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

• Started as contract to hire and converted to full time employee in first 6 months.
• On-call at night twice a month as a preventative measure to resolve errors using Workflow monitor and watching for server crashes using Informatica Administrator.
• Consistent experience using Repository Manager, Designer, Workflow Manager, and Workflow Monitor to create mappings and workflows in Informatica PowerCenter.
• Design, development, test, maintain, and support of ETL and integration solutions using the Informatica platform to load the data warehouse on an ongoing basis.
• Provide technical support using Microsoft SQL Server tools (SSRS, SSIS), Tableau, and other workflow data
• Create and manage databases structures in SQL Server for Collections, Accounting and other lines of business.
• Automated and rewrote a legacy COBOL process used to report on the profitability of all members in Informatica, analyzing all products including checking and savings deposits, credit card purchases, and Line of credit and loan payment and account balances.
• Build Historical repositories/ databases to keep track of multiple field changes over time. Keep track of Bill Pay, Collections, and Loan Performance data.

Confidential, Richmond, VA

Sr. Ab Initio Developer

Responsibilities:

• Invited to rejoin the same team left in 2006 to conduct development and testing in a new Data warehouse environment.
• Successfully Converted/Migrated 19 legacy projects to the new data warehouse structure in less than nine months.
• Responding to growing requests for new data from the new architecture.
• Strategized with DBAs to reorganize tablespaces for greater efficiency.
• Developed as a part of several federal compliance-related releases from Development, through QA, to Production.
• Worked with internal clients (Student Lending, Direct and Indirect Loans) to coordinate the finished product.
• On-call for Production Support (24 hours, 7 days a week) for the Legacy Data Warehouse.
• Stream-lined and enhanced key Ab Initio processes to minimize Production Support problems.
• Gather specifications to create formal functional requirements documents and to conduct gap analyses on input feeds from outside HMC (client site).
• Finish functional requirements documents; Include input feed from WGS and NASCO source systems; Continue to collect requirements; Creating design specifications documents.
• Design source-to-target Informatica mappings using Microsoft Visio to pass on to in-house developers.

Confidential, Richmond, VA

Sr. Database Developer

Responsibilities:

• Setup MySQL 5.1 database management system.
• Analyze business requirements to create a database structure for hospital billing data.
• Create stored procedures to automate loading of staging area and star schema.
• Create reports in MS Access linked to the MySQL database according to specifications.
• Design and create front-end menu to ease access to multiple reports.
• Construct database structure, automated reports, and interactive menus in Microsoft Access to monitor performance of physicians and proper care of patients at Henrico Doctor’s Hospital.
• Establish client-server connections with remote databases in Oracle to Crystal Reports in order to report on key metrics to increase efficiency in serving patients.
• Transfer data from Excel spreadsheets into fully interactive reporting tools created in Microsoft Access to ease access to provider/patient interaction summarized data.
• Maintain security according to HIPAA standards.
• Maintain database according to changes in business rules or reporting needs.

Confidential, Richmond, VA

Project Manager

Responsibilities:

• Acted as a liaison between the data warehousing team at the client site (First Horizon Bank) and the SSS development team in Richmond to oversee project creation, estimates for completion, progress over time, and movement into production after testing was completed.
• Managed more than 40 projects (20 active/20 pending validation or activation) at a time.
• Met for weekly meetings with client’s management team for updates and progress reporting.
• Aligned client’s project priorities/scope with timelines, technical resources, and cost to bring to completion.
• Researched project specifications and associated database systems that need modification in pursuit of most efficient solutions including for source systems ALS, TSYS, TCL and CPI.
• Stay in constant contact with client Manager to ensure satisfaction and to notify of production data/design issues.
• Assign projects to database programmer/analysts and manage agreed upon timelines.
• Integrated new programming flows into a resident production process using Informatica and PL/SQL to include agent and policy information.
• Incorporated several new dimension and fact tables into the existing star-schema data warehouse structure in Oracle to effectively report on new metrics.
• Designed and implemented production process to update Oracle tables for over 400,000 agents and 3.6 million policies in less than ½ hour; Required to have processing and reports completed by 9am daily.
• Coordinate with subject matter experts to construct efficient solutions that meet the needs of the business.

Confidential, Glen Allen, VA

Sr. ETL Developer/Analyst

Responsibilities:

• Cost Analysis/ International Spend Effort: Acquire corporate spending data of overseas locations into central ODS system (SAP Business Warehouse) to find out how much is being spent across the Confidential domestic and international footprint.
• Construct Informatica mappings to automate daily/monthly extracts and loads from domestic and international sources to accomplish yearly objectives.
• Assist/Instruct coworkers in mapping, workflow creation or SQL formatting.
• Administrate over the Supply Chain’s procurement Intranet web site and make modifications as needed.

Confidential, Richmond, VA

ETL Team Lead

Responsibilities:

• Managed as Ab Initio administrator and project manager for 6 consultants; Responsible for production support and lead development for a 600 GB Oracle 9i database as well as EME management.
• Served to oversee projects to integrate source systems from ACAPS ( Confidential ) and ALS and Installment Loan (acquired Crestar Bank) and Huntington Bank accounts.
• Nicknamed “Scotty” by coworkers from Star Trek for ability to respond to production or development problems efficiently and comprehensively
• Extract, manipulate and loaded to Oracle using appropriate tool depending upon situation (Ab Initio, PL/SQL, etc.)
• Respond to end user requests for loan information or metadata.
• On-call for production issues and responsible for optimizing database usage and job performance
• Served as Lead Developer Analyst in converting all production processes from Informatica to Ab Initio for the following LOBs: ((Direct/ Indirect Loans, Collections, and Student Lending).
• Redesigned processes in PL/SQL to execute more time-consuming tasks on the database rather in Cognos to make the cubes and reports more efficient.
• Revised all Cognos Cubes and reports downstream from the presentation layer in Oracle.
• Learned Informatica ETL programming on the job to assist in development.
• Designated as Lead Developer for the Collections Line of business in April 2000.
• Redesigned a Collections department ETL application and resulting Cognos Cube/ Excel reporting to rank collections agents level of productivity to discern employee productivity.
• Met with SVP and other managers to discuss issues and timelines to resolve.
• Now, used by managers in SunTrust Collections centers to rank employees domestically and internationally (outsourcing).

Confidential, Richmond, VA

Programmer/Analyst

Responsibilities:

• Executed early morning processing jobs to bring in sales information from the night before (entry level position)
• Analyzed production COBOL coding to confirm if Y2K compliant or not.
• Corrected non-compliant COBOL programs.

Confidential

MS Access Programmer/Analyst

Responsibilities:

• Created new, analyzed and modified old SQL queries to load environmental data into Data Warehouse using Access 97.
• Learned to effectively troubleshoot errors with client data to maintain referential integrity
• Created and maintained databases to support client historical data.

Confidential

MS Access Programmer/ Analyst

Responsibilities:

• Analyzed Excel flat files and reports to find and correct non-Y2K compliant dates.
• Designed and created Visual Basic software to ease the use of Access 97 by inexperienced users.
• Created Access 97 SQL modules and reports to replace reporting architecture used on non-Y2K compliant systems.
• Analyzed existing PDN (Public Data Network) Billing process in order to design a similar process to only accept calls from Global One, also known as Sprint International
• Created new process for PDN Billing to accumulate the usage data for domestic and international Global One calls.
• Tested the new PDN Billing process, migrated the JCL, COBOL procedures and programs to production to execute in parallel with the existing system.

Confidential

Programmer

Responsibilities:

• Designed, created, implemented and tested COBOL programs using JCL and IDMS to produce reports supporting operations in financial, forecasting, and grocery departments
• With a mainframe IDMS database as a source, created an automated process to load a Unix based database weekly using COBOL in conjunction with C programming and Kornshell scripting.
• Maintained user support and continued interface with DSS Agent (Data Warehousing application w/ SQL Server on the back end).
• Created COBOL programs to produce reports for Executive management to compare Giant’s retail and sale prices with other chains in the Mid-Atlantic Region.