| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address Shoreline ParkwayTega Cay SC Street Address
Phone: PHONE NUMBER AVAILABLEEMAIL AVAILABLEProfile19 years DB2 SQL query and Utility Tools experience (z/OS mainframe, iSeries mid- range)7 years Oracle SQL query5 years CICS command level experience14 years OS/JCL experience in z/OS (formerly MVS) environment 14 years z/OS (formerly MVS) experience including 24/7 productions and systems support coverage4.5 years Excel Macro/Visual Basic for Applications (include use of the Power Query feature of Excel 2016 allowing defining and data manipulation of multiple platform and datasource connections)10 years project life cycle experience predominance being with MS Project Experience 5 years Excel (desktop) macro development and maintenance (Visual Basic for Applications VBA)3 years PowerBI dashboard development and maintenance (Desktop and intranet publish)8 years AS400/iSeries CL experience8 years AS400/iSeries DB2 experience (SQL)6 years AS400/iSeries COBOL experience1 year AS400/iSeries RPG experience10 years SQL query development, maintenance, ad hoc 7 years high volume Gas customer Billing Data3 years Finance Cloud Project Data3 years Power Plan support table maintenance2 Years Change and Implementation ExperienceManaged scope changes, impact assessment, change implementation and closure, change log, and documentation activities. Collaborated with key stakeholders on deliverables feedback, status updates, issues, and risk mitigation 10 Years Data Modeling Experience10 Years Requirements Gathering Experience10 Years Insurance Systems Experience; Property and Casualty (P&C), Workers Compensation, HealthExperienceOct 2020 Aug 2023 Business and Technical Consultant / Change Management Finance Department, Central Project Accounting (Asset Accounting), Duke Energy Corp.Responsibilities: Create/Maintain PowerBI Dashboards to provide information for project unitization processes hand in hand with PowerPlan project entry. Primary skills include Office 365 and MS PowerPlatform Tools: Teams, Outlook, SharePoint, Excel, Excel Script; PowerAutomate SQL Server Management Studio query development, Toad for Oracle query development; Support for Duke Application AsBuilt Estimate Builder(ABEB (APPs and stored procedures))Managed large-scale change implementation projects, created process flows, developed comprehensive databases, and updated members of management of project status.Aug 2013 - Oct 2020 FPO Business Analyst II (formally GMS Technical Analyst), Duke Energy Corp./Piedmont Natural Gas, Charlotte NC Responsibilities: Support Piedmonts large volume billing system, GMS. GMS billed large volume customers that could not be billed in Piedmonts mainframe customer information system, S2K. Create new rate procedures and maintain and change existing rate procedures. For the custom rating necessary for these customers, the billing rate procedures were written in Excel macros/Visual Basic for Applications. More recently during late 2018 through to 2020 implementation, worked with the GTIS transition team to test and assign charge type codes and other configuration in customer contracts to correctly bill customers in the GTIS system. Also converted several base queries that required mapping GMS to GTIS data sources that populate SOX required and other monthly Excel check and validation workbooks to insure correct customer billing.Served as the escalation and contact point between IT Support teams and Client stakeholders.Drafted Post Implementation Verification steps to ensure successful change implementation.Prepared and communicated client notifications to provide clients with advanced notice regarding scheduled changes.In addition to supporting GMS and rate procedures, creating queries in Hyperion, MS Access, Z/OS (mainframe) interactive SQL, and Easytrieve to provide monthly close reporting data to the gas accounting department for monthly closing and billing reports and data to the GMS billing analysts, I have also created pages, lists, document libraries, workflows, and forms to fill such needs as checklists, calendars, reference and business document repositories, etc. in SharePoint 2010 and SharePoint 2013 using in combination native SharePoint 2010, 2013, SharePoint Designer 2010, InfoPath 2013, and Nintex forms and workflows in both environments. Skills/Tools at a glance: Excel Macros/Visual Basic for Applications, Hyperion, MS Access ODBC mainframe interface, Interactive SQL (Z/OS, mainframe), OS/JCL (Z/OS mainframe), Easytrieve (Z/OS mainframe), SharePoint 2010 and 2013 (lists, forms, document libraries, pages, and workflows); native SharePoint, SharePoint Designer 2010(desktop), InfoPath 2013 (desktop), Nintex forms and workflows MS Office - Word Excel Powerpoint Access Outlook, Regulated Utilities. May 2013 - Aug 2013 Sr. Programmer/Analyst Blue Cross/Blue Shield, Durham NC (Matrix Consulting)Responsibilities: Support existing Blue Cross/Blue Shield Account system and develop interfaces and create data extractions when needed to assist new account system replacement inituitives within an agile development strategy. In addition to developing changes, interfaces, etc. designed development specifications and test plans. Maintained the change management process including change preparation, strategic planning, change implementation, embedchanges within company culture/practices, and reviewing progress & analyze results. Skills/Tools at a glance: iSeries/AS400, COBOL CL Implementer iSeries Query SQL(STRSQL) PDM (WRKMBRPDM)MS Office - Word Excel Powerpoint Access Outlook, Health Insurance. Jul 2008 Oct 2012 Sr. Programmer/Analyst Seibels Insurance Technologies and Services (formally Seibels Bruce Insurance Group) Responsibilities: Support and implement enhancements to Seibels Policy writing system (SIPS) - on call support, currently telecommuting. Design development specifications, test plans, etc with business analysts for new processes and changes to existing processes to assist throughout the development life cycle. Provided documentation and presentations for end user support and new/change implementation using MS Word and Powerpoint. Full lifecycle experience testing in unit, model, and quality assurance environments.Skills/Tools at a glance: iSeries/AS400, COBOL CL Implementer iSeries Query SQL(STRSQL) PDM (WRKMBRPDM), Property & Casualty (P&C) Insurance RPG DBU iSeries Navigator MS Office - Word Excel Powerpoint Access Microsoft Project Sep 2007-Mar 2008 Sr. Programmer/Analyst AAA Carolinas Responsibilities: Supported and implemented enhancements to CSC's product, POINT(base COBOL system) executing in an iSeries environment. Also lead initial development phases of CSC's Point software companion Underwriting. Design development specifications, test plans, etc with business analysts for new processes and changes to existing processes to assist throughout the development life cycle. Provided documentation and presentations for end user support and new/change implementation using MS Word and Powerpoint. Full lifecycle experience testing in unit, model, and quality assurance environments.Skills/Tools at a glance: iSeries/AS400, COBOL CL Implementer iSeries Query SQL(STRSQL) PDM (WRKMBRPDM)RPG MS Office - Word Excel Powerpoint Access Microsoft Project Jul 2004-Jan 2007 Sr. Programmer/Analyst Computer Sciences Corporation Responsibilities: Supported and implemented enhancements to the Financial Services Division P & C insurance product, POINT (base COBOL system) executing in an AS400 environment. Projects were defined for and by external customers Alea, GE Cybercomp, MEMIC, and Meadowbrook. Design development specifications, test plans, etc with business analysts for new processes and changes to existing processes to assist throughout the development life cycle. Provided documentation and presentations for end user support and new/change implementation using MS Word and Powerpoint. Full lifecycle experience testing in unit, model, and quality assurance environments. Skills/Tools at a glance: iSeries/AS400, COBOL CL Implementer AS400 Query SQL(STRSQL) PDM (WRKMBRPDM)XML SYNON MS Office - Word Excel Powerpoint Access Microsoft Project, Workers CompensationJan 1999-Mar 2004 Sr. Systems Developer Royal & SunAlliance Responsibilities:Data Warehouse Project functions and responsibilities: Developed/Automated extract data and transfer layer in used to feed Personal Insurance Divisions data warehouse, Performance and Analysis System (PAC). Researched, analyzed, and mapped data available for extract in RSAs policy writing, premium registration, and claims systems. Required extensive SAS knowledge, as well as knowledge of mainframe skills such as COBOL, DB2, VSAM, OS/JCL and other z/OS (formerly MVS) skills to accomplish the design and implementation of the extract layer. Also provided off hours production support and problem resolution occasionally utilizing problem resolution tools such as INTERTEST. Created processes for automated data transfer using Outbound to port data to UNIX platform for the load files to be loaded into the Oracle databases. Assisted database administrators with the creation and maintenance of universes within Mariners Business Objects reporting tool. This data was to be used by RSAs actuary staff to report and analyze key personal insurance measures on an ad-hoc basis such as agent performance, profitability, and insured retention. Created and maintained standard or Corporate reports that were deemed vital as to not change over time. These reports were to be available to users to run as is by specifying a date, agent, or other pre-defined condition(s). These reports could also be used as templates and manipulated by the actuary analysts to create their own adhoc reports. Performed Business Objects supervisory and administrative functions such as maintaining the user groups in Business Objects. When a user subscribed to use Business Objects, the determination would be made as to what security group to place the user. Attributes were defined for each group specifying security and web page and client applet options. These functions required working closing with the network administrator of the Business Objects web and database servers.Supported Personal Insurance data store in SAS; used for ad-hoc reporting. These data stores are the feeds for the warehouse listed above. Prior to the creation of PAC, supported and implemented future releases of Book Mgmt, data mart created in CAs CleverPath (formally Forest & Trees). This data was comprised of home and auto policy writing, premium, and claim data. Implemented and supported an electronic mailbox system that interpreted, processed, and created DMV X12 data for state DMV reporting. Largely a batch system, required extensive knowledge of COBOL, VSAM, and OS/JCL in an z/OS (formerly MVS) environment. Development/Implementation timeframe for PAC was very aggressive and required close project lifecycle observation. I was required to supply weekly status reports and make task updates in MS Project during the initial and subsequent phases of the project. Supported and enhanced certain features of the Personal Insurance Divisions auto policy writing system both batch and online. Online processing in COBOL/CICS and nightly batch processing in COBOL/JCL. Master data stored in VSAM. Support DB2 claims extract database, Ratemaking Claims/Loss, (Pers. Ins. Data only extracted from RSA Claims System). Included in after hours support rotation.Skills/Tools at a glance: OS/JCL (IBM mainframe) COBOL APPS/COBOL Mariners Business Objects TSO/ISPF DB2 SQL CICS VSAM SPUFI IDCAMS Intertest Visual Basic 6, HTML, Java Script SourceSafe Lotus Notes MS Office - Word Excel Powerpoint Access Microsoft Project, Flow Chart design in VISIO, Property and Casualty (P&C) Insurance May 1998-Dec 1999 Programmer/Analyst Oxford & Associates Responsibilities: Contracted at First Union as a DB2 consultant. Project was a conversion from SQL Server to DB2. I created batch load scripts for the loads to the newly created DB2 tables. Worked closelywith project leads for project direction and coding specs/requirements. Created monthly load and backup scripts and OS/JCL for batch processing that would be used when the system would be implemented. Worked with contingency planners for disaster recovery procedures of the system. Performed Y2K testing.Skills/Tools at a glance: OS/JCL (IBM Mainframe) COBOL APPS/COBOL SPUFI TSO/ISPF DB2 Platinum Tools DB2 SQL SourceSafe Lotus Notes MS Office - Word Excel Powerpoint AccessMay 1996-May 1998 Programmer/Analyst Presbyterian Hospital, Charlotte NC Responsibilities: Supported Presbyterians DB2 based case database,Casemix. Maintained COBOL and OS/JCL extracts and loads for the system. Required Supported SAS adhoc users reporting case quality assurance group. Supported and enhanced several SAS reporting databases that contained specific case data. Created, supported, and enhanced several MS Access databases. Supported and implemented periodic updates to several 3rd party hospital applications such as the hospital registration system, SMS. Completed several Y2K conversion projects. Supported several small 3rd party vendor hardware and software systems Included in after hours support rotation. Also provided off hours production support and problem resolution occasionally utilizing problem resolution tools such as EXPEDITOR and the DB2 query environment tool, QMF. Skills/Tools at a glance: OS/JCL (IBM Mainframe) DB2 SQL TSO/ISPF DB2 Platinum Tools COBOL SPUFI QMF Expediter Lotus Notes MS Office - Word Excel Powerpoint Access Microsoft Project, Automated problem solving using CA-11. January 1990-May 1996 Programmer Belk Stores Services, Charlotte, NC Responsibilities: Assisted in design, implementation, and support of several DB2, VSAM, and sequential extracts that were used to build data loads for the merchandising data warehouse. Supported and enhanced an information center DB2 ad-hoc reporting data mart and merchandising group that accessed and reported data through QMF. Supported legacy systems, previously supported in the 93-94 timeframe (below). Completed several Y2K conversion projects. Also provided off hours production support and problem resolution occasionally utilizing problem resolution tools such as EXPEDITOR and the DB2 query environment tool, QMF.Skills/Tools at a glance: COBOL Microfocus COBOL APPS/COBOL OS/JCL (IBM Mainframe) DB2 Platinum Tools DYL-280/DB2 TSO/ISPF SPUFI DB2 SQL QMF Lotus NotesEducationInformation Systems, Associate of Applied Science Lexington Community College, Lexington KY |
