We provide IT Staff Augmentation Services!

Contractor Resume

St Louis, MO

EMPLOYMENT EXPERIENCE:

Confidential, St. Louis, MO

Contractor

Responsibilities:

  • New ETL development, testing, production fixes and debugging. Maintenance of existing ETL processes. Identify performance issues and solutions.
  • Designed, developed, tested and implemented solution to extract data from MongoDb and load to Oracle Data Warehouse using shell scripting, the MongoDb shell facility and Oracle SQLLDR. Support and enhance MongoDb integration process.
  • Support data warehouse operations, including production issues and automate manual tasks using shell scripting, Informatica, SQLPlus, and PL/SQL.
  • Debugged SSIS package and C# code using Visual Studio and Visual C#. Powershell scripting.
  • Mentor others on Operations standardized processes, Informatica and Snaplogic development, and MongoDb shell queries.
  • Informatica 9.6.1, Oracle 12c, SQL Server, SSIS, Visual Studio, Linux shell scripting, C#, Oracle, Toad, MongoDB, NOSQL, JavaScript, SQL Server, Netezza, Aginity

ETL Developer

Confidential

Responsibilities:

  • ETL development and support - Informatica, Oracle.
  • Informatica development - Work with overseas clients to finalize and implement technical design specifications. Create, document and implement test plans. Duties include creating new processes, as well as adding enhancements to existing design templates. Implement Informatica web services consumer and http solutions to execute asp.net queries. Parse, transform and load the results of those queries. Perform data analysis as needed.
  • Data Warehouse daytime admin support - Informatica Powercenter administration. Cisco Tidal Enterprise Scheduler administration, including installation. Root cause analysis and resolution of data warehouse issues. Environment supported - Powercenter 9.1, Tidal 6.1, Oracle 11g, Linux, MSSQL, Samba, and windows servers.
  • Perform 24 hour on call duties on semi-monthly rotation. Determine root cause of production issues, propose and implement solutions.
  • Informatica 9.1, Oracle 11g, Tidal Scheduler.

ETL Developer

Confidential, St. Louis, MO

Responsibilities:

  • Automation of existing Standard Operating Procedures.
  • Functions performed include requirements gathering, data analysis, development, testing and implementation.
  • Create processes and user interfaces incorporating newly developed Web Services / Informatica Developer / Powercenter / Data Quality infrastructure. Configuration of testing framework utilizing Maven, IntelliJ.
  • Informatica 9.1, Unix/Linux, Oracle 11g, Web Services, SoapUI, WSDL, Maven, Subversion, IntelliJ.

ETL Developer/Programmer/Analyst

Confidential, St. Louis, MO

Responsibilities:

  • Technical lead for automated file delivery and registration process - Design and implement enhancements to data extraction and file delivery processes. DB2, Informatica, Unix (ksh) scripting, Confidential and Confidential environment.
  • Responsibilities include creating technical designs and production turnover documents, coordination data transmission between Confidential internal and external clients, maintenance and enhancements of system process, including Unix shell scripts, DB2 SQL, and Informatica mappings and workflows.
  • Debug production issues and identify process bottlenecks.

ETL Developer

Confidential, St. Louis, MO

Responsibilities:

  • Converting Informix/DB2 Data Warehouse to Informatica/Oracle - Re-engineering existing SQL to Informatica ETL processes, development, testing and implementation - Sun/Solaris environment.

ETL Developer/Programmer/Analyst

Confidential, St. Louis, MO

Responsibilities:

  • Create and document new Unix/Informatica/DB2 ETL processes and enhancements.
  • Tech lead for automated file delivery and registration process
  • Create utility script and test plan to compare performance and accuracy between existing version of Confidential for Unix to each an upgraded version of Confidential and DMExpress.
  • Create ksh process calling Confidential to pull directory listings from remote landing sites.
  • Serve as mentor for the onboarding of ETL Tech Leads.
  • Resolve production issues.
  • DB2, Informatica, Unix (ksh) scripting, Confidential and Confidential

Sr. Software Consultant

Confidential, St. Louis, MO

Responsibilities:

  • New development and enhancements, designing, coding and testing.
  • Assist in the engineering and design of new ETL processes.
  • Interface with source system subject matter experts, project managers, data architects, as well as business users.

Environment: /Skills utilized: AIX (ksh scripting), C, Perl, DB2, Informatica and Teradata. Personal: Ubuntu (debian) Linux, MySQL.

Data Warehouse Developer/Support

Confidential, Sunset Hills, MO

Responsibilities:

  • Data Warehouse EDW Support - Problem identification, resolution, and enhancements relating to support group functions. Work is derived from 24x7 on-call paging system and user requests.
  • Data Warehouse ETL Programmer - Designing, coding and testing data warehouse applications for Anheuser-Busch sales, inventory, production line and forecast data.
  • Programming skills utilized: UNIX Korn shell scripting, support for Teradata, Oracle DLL, DML including Teradata CLI, fastload, and multiload and bteq scripting. Development / support for IBM Datastage Server, Enterprise Edition version 8.1. Monitor, update and add schedules to Tivoli Work Scheduler via client and composer scripts.
  • Developed system using TWS, UNIX, Datastage and Teradata to capture and log to Teradata all Data Warehouse processes run via Tivoli Work Scheduler.

Data Warehouse Developer

Confidential, Clayton, MO

Responsibilities:

  • Data Warehouse ETL Programmer - Designing, coding and testing applications for valuation and daily processing of bundled mortgage backed securities.
  • Supporting production oriented development and testing environment including running and debugging real time UAT batch processes.

Programming skills utilized: UNIX Korn shell scripting, DB2 DLL, DML including loader scripting, and IBM Datastage Enterprise Edition version 7.5 for parallel processing on IBM AIX 5.2 platform.

Senior Programmer Analyst

Confidential, St. Louis, MO

Responsibilities:

  • Designing, coding testing new applications for Banker Performance Incentive Rewards program. Developing applications utilizing Ascential Datastage Server and Parallel Extender on UNIX platform. Providing technical assistance to team members.
  • Designing, coding, testing new and existing interfaces for Data Warehouse. Participated in conversion process for Firstar Bank acquisition of Mercantile Bank, then Confidential merger with Firstar.
  • Data interfaces include IBM UDB and Microsoft SQL Server. System interfaces include Performance Management, ATM, AFS/Commercial Revenue/Dealer Floor Plan, ALS, Credit /Debit Card, Direct Deposit, Fraud, and Trust .

Programming skills utilized: IBM/MVS/TSO COBOL, JCL, VSAM, Easytrieve, UNIX, DB2, ORACLE PL/SQL, Ascential Datastage ETL and C++.

Senior Programmer

Confidential, Florham Park, NJ

Responsibilities:

  • Responsible for all phases of project life cycle for Pershing's Individual Retirement Account tax reporting and notification system.
  • Includes working hand and hand with business users in the creation and evaluation of requirements, testing, production implementation and follow-up.
  • Primary job functions are coding and testing with MVS COBOL, JCL, Confidential and Easytrieve

Hire Now