We provide IT Staff Augmentation Services!

Sr Informatica Technical Lead Resume

Hartford, CT

KEYSTRENGTHS:

ETL: Informatica PowerCenter, DataStage, Webfocus, Autosys, Unix Shell Scripts

BUSINESS I NTELLIGENCE: Oracle Hyperion Interactive Reporting versions 8.5, 9.3, EPM 11.1, Webfocus, Oracle Hyperion Financial Data Quality Management (FDM), Oracle Essbase, Oracle Hyperion Profitability and Cost Management (HPCM), Smartview, SQR, JavaScript, HP Quality Center

MAINFRAME: Cobol, DB2, SQL, Confidential, VSAM, IMS DB/DC, ADABAS, Natural, OS/ Confidential, EASYTRIEVE, FileAid, Endevor, Panvalet, Changeman, Documerge, TCP/IP, FTP, EDI, TSO, CA - 7, Control-M, QA Testing, Confidential, Xpediter, Intertest, Confidential . Financial, Banking, and Insurance Applications, Commercial and Personal Lines Microsoft Access, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, Ct

Sr Informatica Technical Lead

Responsibilities:

  • Created new reports and made changes to existing reports using Webfocus Developer Studio and DataStage.
  • Modified existing SQL and wrote complex SQL queries using TOAD to resolve production issues and generate new code for Informatica workflows.
  • Monitored all production jobs on a daily basis using Autosys/Unix.
  • Generated Cobol/DB2 extract files on mainframe and XML files that were imported to Informatica Source Analyzer.
  • Tracked and assigned incidents to other team members including offshore team using Remedy and PPM (Project and Portfolio Management Center).
  • Used Citrix to access following apps: WS FTP PRO, TOAD 12.10 G, Webfocus Developer Studio 7, Ascential Datastage 75, 10g SQL Plus, Ultra Edit32

Confidential, Bloomfield, CT

Sr Business Intelligence Technical lead

Responsibilities:

  • Created new reports using Hyperion Interactive Reporting 9.3, EPM 11.1, SQR, and JavaScript.
  • Responsible for converting five different applications from Hyperion 9.3 to Hyperion EPM 11.1 in test, staging, and production environments using Oracle Essbase and Oracle Hyperion Profitability and Cost Management (HPCM).
  • Created Informatica PowerCenter (version 9.1) extracts including COBOL/DB2 files generated on mainframe to load to Oracle Hyperion Financial Data Quality Management (FDM) and Oracle Essbase cubes.
  • Compared Informatica extracts back to source files and modified Informatica code where necessary.
  • Verified data on Essbase using Smartview and compared results to initial source files and Informatica extracts.
  • Used HP Quality Center 10.0 to input test cases and record all defects.
  • Unix shell scripts and XML used to trigger batch SQR jobs set up on Confidential (TWS) and converted to ESP on mainframe.
  • Set up jobs in Hyperion EPM 11.1 Test Environment for user testing and coordinated production release.

Confidential, Windsor, CT

Sr Mainframe Developer

Responsibilities:

  • Assigned to work on Confidential (Comprehensive Analysis and Profitability System) Confidential Project.
  • Added new banks for two new states to support fully analyzed accounts for the Commercial, Small Business, Real Estate, and Premier/Private Banking business client segments.
  • Responsibilities include analysis, coding changes, unit testing, batch cycle Confidential and proc modifications to Fidelity Deposit Impacs application.
  • Cobol, Confidential, VSAM, DB2, Easytrieve, ChangeMan, CA-7, OS/ Confidential .

Confidential, St Louis, MO

Oracle Hyperion Business Intelligence Developer/Technical lead

Responsibilities:

  • Created new reports for Rural Development applications including Confidential .
  • Worked on conversion upgrades to Hyperion Version 9.3 and Hyperion EPM 11.1.
  • Supported mainframe applications and set up Informatica PowerCenter (version 8.6) Cobol/DB2 extracts as part of conversion to EPM 11.1.
  • JavaScript used for object-based scripting language.
  • Set up jobs and schedules to create reports in two Hyperion instances for test, and one for production environment.
  • Trained other users and developers the new features of each Hyperion version.
  • Monitored over 150 production jobs on a daily basis and reran jobs to create reports when necessary.

Confidential, Boston, MA

Senior Mainframe Technical Lead

Responsibilities:

  • Worked wih QA to create test plan and modify hundreds of existing QA scripts using Confidential
  • Created test plan and Confidential to automate running test scripts for modifications to online Confidential screens for all of Fidelity applications to add fields related to multi-company.
  • Added multi-company field to a number of Cobol, Confidential, Intertest), DB2 (including stored procedures) programs and copybooks.
  • Modified SQL statements and code for hundreds of programs for various applications within Brokerage including Order Entry, Mutual Funds, and Fundserv.
  • Set up and executed jobs to load branch specific data to new FSAT region set up for multi-company.
  • Used ClearQuest to monitor all issues and assign to developers.
  • Testing included all phases of Software Development Life Cycle.

Confidential, Cranston, RI

Senior Mainframe Programmer Analyst and Developer

Responsibilities:

  • Used Confidential extensively in order to resolve all batch issues related to data conversion.
  • Intertest and Confidential used to monitor online screen display.
  • Created Confidential and procs for new production jobstreams using Endevor.
  • Completed analysis and testing for all performance issues related to large data conversion files.
  • Provided on-call support for numerous batch cycles in various test regions prior to production release, and provided on-call production support as each phase of project was implemented.

Confidential, Boston, MA

Senior Mainframe Programmer Analyst and Developer

Responsibilities:

  • Developed and supported jobs to provide the WebPlaid Contact and Potfolio Management system with daily downloads of data from the mainframe.
  • As a member of the Conversions team, converted data for multiple correspondents onto the Fidelity platform, both batch and online.
  • Conversion modules written in Cobol, DB2 (with complex SQL and stored procedures), and Confidential .
  • Easytrieve and QMF used to generate various adhoc reports as requested by user.
  • Created Account Link Files and Reports, Created ID’s and Confidential for investors and brokers using Microsoft Access.
  • Created New User Setup Files and Reports using Microsoft Access.
  • Created file extract and Electronic Data Interchange (EDI) transmission jobs for many different correspondents, including File Transfer Protocol (FTP), Network Data Mover (NDM), and Remote Job Entry (RJE) transmissions.
  • Set up jobs on scheduler using Control-M. Provided on-call production support for hundreds of different file extract and EDI transmission jobs.

Confidential, Foxboro, MA

Mainframe - Documerge Analyst and Developer

Responsibilities:

  • Programming Consultant assigned to work on Confidential and Confidential ’s Compensation enhancement and development projects.
  • Completed analysis and programming for Confidential Quick Quoting system using Microfocus Cobol.
  • Responsibilities included network rate distribution, network distribution to support system upgrades, and technical assistance to branch offices and agents.
  • Completed major enhancements for Year 2000 compatibility.
  • Assisted in setting up network servers for new branches as a result of merger between General Accident and Confidential .

Confidential, Boston, MA

Mainframe Programmer Analyst and Developer

Responsibilities:

  • Programming Consultant assigned to work on mainframe project development.
  • Completed analysis of and enhancements to exisiting IMS DB/DC, DB2 Confidential system in order to produce daytime policy output instead of generating policies during the nightly batch cycle only.
  • Modified existing Documerge Variable Data Reformatter (VDR) module and Confidential to run DocuMerge job stream.
  • Responsibilities included analysis, programming development, and testing of all Documerge forms generated for Confidential policies.
  • Developed Confidential and procs to run new system.
  • Determined where new jobs should be set up on the scheduler using CA-7. Worked closely with users to verify output.

Confidential, Webster, MA

Mainframe, Client Server Programmer Analyst and Developer

Responsibilities:

  • Programming consultant assigned to work on Conversion and Interface of existing AS400 system to DB2 Client Server.
  • Created system design and detail design documents for various functions capturing data from new Policy Management Systems Corporation.
  • Coordinated efforts with PMSC representatives and users to map existing AS400 data to new DB2 tables containing PMSC data. Set up jobs to create and load new DB2 tables.
  • Performed analysis, programming and testing of new Cobol/DB2 programs to collect PMSC data for Claims 1099, Profit Sharing, and Budget Reporting systems.

Confidential, Boston, MA

Mainframe Programmer Analyst and Developer

Responsibilities:

  • Programming consultant assigned to various projects on the PC and mainframe for LifeInsurance applications.
  • Completed the analysis, programming and testing for enhancements to existing IMS/DC system to call DB2 common access routine to obtain Agent Licensing Information.
  • Documented procedures and modifications needed to existing File Transfer Utility in order to send forms created on the PC using DocuMerge PrintCommander to the mainframe.
  • Developed Confidential and created panels with various options to submit jobs to load large volumes of Documerge forms that were uploaded from the PC and stored in Confidential libraries to the Electronic Document Library.
  • Set up jobs on scheduler using CA-7.

Confidential, Worcester, MA

Mainframe Programmer Analyst and Developer

Responsibilities:

  • Programming consultant assigned to work on DB2 development projects for Activity Based Costing System for Accounts Payable.
  • Completed analysis, programming, and testing of DB2/COBOL programs for new History/Volume Adjustment process.
  • Set up queries, procs, and forms using QMF. Created Confidential to run DB2 programs and QMF procs. Created Confidential to submit procs and jobs in batch mode.
  • Completed analysis, programming, and testing of new DB2/COBOL2 programs to automate process to create records to be added to General Ledger for Peoplesoft.
  • Created reports using Syncsort summarizing dollar amounts multiple ways by product code, activity code, book type, etc. Set up monthly jobs to create production files and reports for the users.

Hire Now