| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePROFILEIT Professional with over 20 years of experience developing and maintainingapplications for healthcare and financial services applications.Oracle Certified associate (OCA) - Database administration(10g).SOFTWARE:Oracle PL/SQL ? Oracle OCA ? Oracle OEM ? SQL*Plus ? RMAN ? SQL Loader ?Control M ? AIX ? Unix/Linux ? Oracle Application express (APEX) ?Oracle SQL Developer ? PL/SQL Developer ? Toad ? Autosys ? Rapid Sql ?Informatica ? FTP ? CICS ? VSAM ? OS/VS JCL ? TSO/ISPF ? SPF/PC ? MVS/ESA? DB2 ? SQL ? QMF ? SPUFI ? SMARTEDIT ? JOBSCAN ? FILEAID ? RMDS ? IOF ?SYNCSORT ? Micro Focus ? Workbench ? ABEND-AID ? IBM SCLM ? ENDEVOR ?LIBRARIAN ? MAPR - BMS Generator ? XPEDITER/CICS ? XPEDITER/TSO ? SMARTTEST? DB2 Command Editor ? Easytrieve PLUS ? Microsoft Office ? MS SQL QueryAnalyzer ? SmartFTP ? MS SQL Server Enterprise Manager ? MS SQL Server 2000? SDSF ? Highjump software Advantage Commander ? HighJump SoftwareAdvantage Architect ? PeopleSoft SQR ? Micro Focus Mainframe Express ?NDM/FTP ? MS Access ? Visio ? ITSM 6&7 ? DB Artisan ? .Net ? VB.Net ?Powershell ? Visual Studio ? SSIS ? Maestro Job scheduler? Tortoise GIT? MS Azure ? Python ? XML ? BMC Remedy ?Service Now ?DATABASES::Oracle 10g, 11g, 12g, 19c, DB2, SQL Server.OPERATING SYSTEMS:DOS , WINDOWS, Unix/Linux, Unix-AIX, OS/MVSWORK EXPERIENCE:MetLifeApril 2014 - June 2024Cary, NCOracle Database DeveloperActuarial, Risk, & Treasury (ART)Accomplishments:Analyzed coding specifications, created new Oracle tables and developedOracle PL/SQL Stored procedures for Korea Alm Project.Created Powershell Scripts to extract data from Oracle Databases and createExcel spreadsheets from the results for ALM Health and Institutional.Supported the .Net process for DBF Load, Transformation and Reportingprocess written in VB.Net & C# by making modifications to the existingprocessing for Japan as well as adding the DA EHE process so that it usesthe generic processes that already exist in the Transformation process.Currently involved in Mexico ALM project which will require the developmentof new Oracle tables as well as the coding of new Oracle PL/SQL Storedprocedures.Analyzing the changes that will be required to update our Control totalsprocesses for SIFI requirements.Owned USLMS Process consisting of multiple Oracle Stored procedures andpackages that create mpf files to be displayed in MIAME front end, addedinteractivity using JavaScript.Debugged procedure and packages using Debug features in TOAD and Oracle SQLDeveloper.Created sqlldr jobs to load CSV files and text files to the MIAME Databaseand also to load test data in Dev and QA for testing.Executed anonymous process in QA using sqlplus.Tuned poorly performing procedures for performance using EXPLAIN PLAN andvarious other tools.Own Japan Transformation process written in VB.net and C# that extractsdata from Oracle tables and provides the output to the Market RiskDatabase.Converted COBOL Programs to Oracle Stored Procedures as part of our LegacyModernization project.Stored .Net, Oracle and Powershell source in Azure repositories using GITand Created Pull requests for new projects.Developed/Supported and maintained Powershell and Python scripts.Created XML files that are parsed by several of our process to determinewhich process is to be run and where input and output files are to beplaced as well as determine which table and schema the process is toconnect to.Recieved daily/monthly ETL feeds using Informatica and SSIS.Oragnaized and facilitated our change meetings to insure all items to beinstalled and been thouroughly tested, signed off and staged for productiondeployment.Created Service Now tickets for bi-weekly installs, ran the Changemanagement meeting within our group.Created Remedy tickets for incidents that arose during monthly runs.Fidelity InvestmentsSeptember 2012 - February 2014Research Triangle Park, NCSenior Database Operations analystResponsible for running the weekly change meeting for High Income.Ensure that daily ETL/Informatica feeds are provided by outside venders andall jobs process within given SLA's.Responsible for production data corrections that we receive from thebusiness. These include updates/inserts/deletes in Oracle, Sybase and SqlServer.Responsible for problem resolution in a timely manner and recommendingfixes to PL/SQL jobs.Determine the cause of job failures by looking into the logs on the ETLserver (Unix/Linux and Windows based).Responsible for production installs including PL/SQL stored procedures /Perl Scripts and jil files.Schedule and monitor workflow in Autosys.Credit SuisseNovember 2010 - September, 2012Research Triangle Park, NCOracle & DWH Support Engineer - Private BankingResponsible for Supporting Private Banking Applications and Trading Systemsby working closely with the data management group to insert / update /delete records for the Private Banking US and Private Banking Mexicoapplications. Executing Unix scripts and providing support on an as neededbasis.Subject matter expert (SME) for Compensation and Pricing System (COMPAS)Responsible for monthly run of the Compensation and Pricing system for theAccountExecutives.Load Excel csv files into the database by executing batch .bat / Unixscripts.Verify data has been loaded in Raw through production tables.Proactively identify invalid data and communicate to the business forcorrection before the monthly batch processes are run.Administer user access for Broker web reports / Trading activity website.Generate monthly ADP file and deliver to ADP for processing.Run the banks nightly close of business (T24) and run backups before andafter processingWork with various applications and provide support as needed.Accept incidents created in Remedy to provide application support to clientside end users.Quintiles Transnational CorporationApr 2010 - Aug 2010Research Triangle Park, NCOracle Database DeveloperAccomplishments:Developed PL/SQL functions /procedures/ stored procedures/ Triggers for theQuintiles pricing tool in Oracle 11gR2.Created screens for the user interface using Oracle Application Express(APEX).Wrote JavaScript/jQuery scripts to add interactivity to the APEXapplication.Fidelity InvestmentsApril 2007 - February 2009Research Triangle Park, NCSenior Programmer Analyst / ConsultantDepartment's:Institutional Products Group and Retail Statements.Accomplishments:Researched and documented multiple statements for FRIAG redesign.Analyzed business requirements and created Technical SpecificationsDocument (TSD) for Retail Statements portion of Complex Corporate Actions.Used Visio to flow program changes and data flow for corporate actionschanges.Researched and made coding changes to multiple COBOL batch programs as wellas the JCL that run them for Complex Corporate Actions project. Followedthe project through complete Systems Development Life Cycle (SDLC).Unit tested Corporate Actions changes in the FSAT Shared testingenvironment and moved the items into production using the Endevor migrationprocess.Worked with QA to resolve issues related to Corporate Actions changes.Create Ad Hoc reports for Advisors and client correspondents usingprimarily Ez trieve, DB2, Excel, and MS Access.Pulled data from multiple groups to provide the users ad hoc reports,including Name and address file, Restriction file's, Bookkeeping,Statements files, Position detail files.Laboratory Corporation of America - Biomedical Laboratory.May 1999 - April 2007Burlington, NCSenior Programmer Analyst.Department:Perpetual and Physical Inventory, also support Accounts Payable (AP) andGeneral Ledger (GL).Accomplishments:Supported the existing mainframe environment and provided assistance asneeded in converting our application to PeopleSoft and wrote and modifiedbasic SQR's for the conversion effort.Support the HighJump application server which interfaces the hand heldbarcode scanners that update inventory transactions in PeopleSoft. This wasdone using MS SQL server and SQL Query analyzer.Developed COBOL/CICS/DB2 online and batch programs to allow user tocomplete requisitions and converted mainframe data to the PeopleSoftformat.Provide production support for Inventory systems during the day as well asafter business hours for Inventory, AP purchasing, and General Ledger.Mentor junior level programmers and provide guidance for adherence tocompany coding standards for COBOL, CICS, JCL, VSAM, and program and jobdocumentation.Analyzed business requirements to design and develop CICS programs forperpetual inventory to allow users to ship orders online accessing VSAMfiles and DB2 databases.Migrated programs, procs, JCL and copybooks from Endevor into IBM'sSoftware Configuration and Library Manager (SCLM).Followed projects through full life cycle and moved elements intoproduction using the Endevor migration process.CIGNA - Retirement and Investment Services.Mar. 1999 - May 1999Hartford, CT.Consultant.Project: Answerline.Accomplishments:Develop COBOL/CICS/DB2 applications to provide information to clientsregarding their retirement accounts. The programs interface with theanswerline product which makes account information available over thephone.ALLTEL Information Services, Inc.Peoples Heritage Data Center / Peoples Heritage BankOct. 1998 - Jan. 1999Lewiston, ME.Consultant.Project: CL 971 upgrade.Accomplishments:Modified CICS programs to bring them up to COBOL II standards in a DOS/VSEenvironment.Modified ALLTEL data aging programs for ST, CL, FM, AP and, KO, which areused to age files for Y2K testing.Upgraded an electronic E-Mail system (EMS), upgrading CICS to be COBOL IIcompatible as well as convert from ver. 3.0 to 3.1.AgFIRST - FARM CREDIT BANK.Oct. 1997 Oct. 1998Columbia, SC.Consultant.Project: COAL/REAL upgrade and conversion.Accomplishments:Maintained and modified COBOL II / CICS programs, and the associated BMSscreens.Debugged programs using the latest versions of XPEDITER/CICS andXPEDITER/TSO.Assisted many senior level programmers in the uses of File-aid andXpediter.Worked on Participation's project developing approximately 30 new COBOL IIprograms to produce reports that where previously produced on the P.C.Modified existing programs to process multiple parts sold.ALLTEL/SYSTEMATICS applications worked on include BE, CL, RE,CIF,GN, LOCKBOX, and CORPORATE TIES. Wrote multiple programsto modify VSAM files for the ALLTEL applications above to changecustomer information for a bank that had been newly acquired.BLUE CROSS BLUE SHIELDOct. 1996 - Sept. 1997Columbia, SC.Information Systems EngineerAccomplishments:Created EASYTREVE+ programs to write out reports concerning large groups.Created COBOL programs using APS.Maintained 5 large programs for the membership system by adding majormedical waivers for new groups which determine what sort of coverage agroup gets. All of which accessed coverage information from IMS and TOTALdata bases.Added new fields and products to existing CICS screens as well as enhancethe programs that retrieved the information to be displayed.UNITEDhealthcareSEPT. 1995 - SEPT. 1996Hartford, CT.Associate Software EngineerAccomplishments:Coded and unit tested batch and CICS programs working with members of ourperformance team and business analyst and the associated BMS screens.Converted numerous programs to COBOL II utilizing COBOL II codingconventions, and structured coding techniques, as well as coding standardsset by our performance team.Travelers InsuranceDEC. 1994 - SEPT. 1995Hartford, CT.Associate Software EngineerSupported the TOPS claims systems which handles claims payment processingand Employee benefits for more than 82 percent of the 250 million medicalclaims that are handled each year.Developed Batch programs utilizing VSAM files, and created the JCL to runthe programs.Identified and captured programs and proc's when our line of business wassold to UnitedHealthcare.EDUCATIONOracle Certified Associate in Data Base Administration (OCA)Comptia Linux+ (Sept,11,2009)TechSkillsCompleted Jan, 2010Raleigh, NCCertifications: Comptia Linux+, Oracle PL/SQL , Oracle OCA (DBA Level 1)Performed installation of Oracle 10g on Windows and Linux, loaded andunloaded database content using SQL*Loader and Oracle data pump, monitoredSQL performance using SQL Access Advisor and SQL Tuning Advisor, performeddatabase backup and recovery using RMAN and performed Oracle Grid Controland configuration using OEM.CAREER DEVELOPMENT INSTITUTECompleted 1993San Francisco, CA.Certificate - Computer Programming and Operations.Completed 900 hours hands on programming applications in a selfmanaged business environment, efficiently wrote and debugged code in MFCOBOL, QBASIC, Microsoft C, JCL, SQL and DB2.SANTA ROSA JUNIOR COLLEGECompleted 1988Santa Rosa, CA.Associate of Science.1 In House Training (LabCorp)Completed 2000 - 2003Micro Focus COBOL, DB2 for OS/390 and EasyTrieve Plus.HighJump SoftwareCompleted Feb,2006Eden Prarie, MNAdvantage Systems Administration, and Advantage ArchitectMS SQL server 2005 and SQL Query AnalyzerWeb Page Design (HTML) and Java Programming, Alamance Community College.References Available. |
