Richard Flaig

**** ******* ******, ********, ** *0003

504-***-****

ac7q3t@r.postjobfree.com

I have several years of hands on experience in IT management and as a IS Director, Program, Project Manager, Developer with all types of financial and budgetary systems development with full life cycle support SDLC.

My background includes design, development and implementation in many different business types including Business Analytics Dashboards using Tableau and Power BI. Over the past 15 years I have spent most of my development with databases Oracle PL/SQL and MSSQL T/SQL. I also trained the staff at Lockheed IMS during my time there in Object Orientated Development with PowerBuilder using several databases PL/SQL, Oracle 9i-12g, MSSQL 2000-2017, PeopleSoft, SAP R/3, SAP BW and JE Edwards. This included several platforms modeling and development, lifecycle management, SAP Archiving procedures and SAP Information lifecycle management with Retention Management process.

I also have several year experience with, implementations, conversations, ETL and experience with insurance, financial software and government accounting, and real time systems.

I am a highly experienced IT Professional with a record of developing and supporting successful high ROI IS / IT / ERP projects and solutions incorporating a wide range of applications development and technologies. Consistently recognized and tasked to improve organizational effectiveness and efficiency through leadership that aligns the business processes and IT infrastructure to realize cost savings, accelerate performance, and sustain strategic flexibility.

•Confident, highly energized, effective, and persuasive communicator with strong interpersonal and communication skills. Detail- and results-oriented with a proven ability to demonstrate flawless execution, and implementation of innovative strategies. An analytical and strategic thinker with the highest professional standards and personal integrity.

•My background includes hands on work with several databases Oracle 9i-12, MSSQL 2000-2017, SharePoint, PeopleSoft, SAP, JD Edwards on several platforms modeling, conversions and development.

•Extensive experience with ETL processes both MSSQL and Oracle with several companies and software applications like SAP R/3, Salesforce, JD Edwards and legacy government applications.

•I have over 5 years’ experience with SAP R/3, and SAPs BI product BW, asset management (EAM), enterprise resource planning (ERP), enterprise project management and supply chain management to demanding and global businesses. Manufacturing (ERP) software for multi-mode environments implementations and conversations EAI interfacing and other financial systems like PeopleSoft.

DBA experience both technical and functional with ANSI SQL, Transactional SQL, and DTS/SSIS, SSAS, SSRS and Oracle PL/SQL.

Expert in SDLC process life cycle and testing methodologies.

TECHNICAL SKILLS

Development: SQL Server 2000 – 2017, SSIS, SSRS, SSAS, Oracle v6.x–12g, Basic Transact/ANSI SQL, .NET and XML, Oracle Enterprise Manager 10g-12c Grid Control Oracle RDB, Oracle Forms & Reports 10g, Oracle Financials, PeopleSoft Financials, SAP R3, FI, CO, AA, PM, PS, JD Edwards Financial System, Visual Basic, PowerBuilder v3x–7.x, Crystal Reports, Microsoft Access 97-2012, COBOL, RPGII,BASIC, Linux, AIX, HP Unix, Laboratory Information Management System (LIMS), TABWARE, ASPEN TECH, XML, Crystal Reports, Excel, Power Pivot, Access, Power Bi, and SQL Server 12, Tableau 10.5.

REVERSE ENGINEERING: S-Designer v3.x – v5.0, Oracle Designer 10g Release 2

NETWORKING: VMWare

OPERATING SYSTEMS: Windows 10, Windows XP, Vista, 7, 8; Windows Server 2003, 2008, 2012; Linux, UNIX HP, Ubuntu, VMS Solaris, MCP MCP/AS, CMS, BTOS CTOS DOS XENIS MPM CPM CICS

PROFESSIONAL EXPERIENCE

CobaltRX

Baton Rouge, LA July 2018-present

BI/Data Analyst

At Cobalt Rx, we provide pharmacy benefit intelligence to plan sponsors, third party administrators, pharmacy consultants, and health care organizations so they can more efficiently and effectively manage pharmacy benefit plans for the benefit of their organization and members, or their clients. Responsible for collecting data from clients and preparing the uploading to Salesforce and Tableau reporting for each client. Due to the natural of the data collected ETL processes were developed to standardize all the clients for ease of use in Tableau.

Skill Used: Excel, Power Pivot, Power Bi, SQL Server 17, Tableau 2018.3, Salesforce, Oracle 12g

Schumacher Clinical Partners

Picayune, MS November 2016-May 2018

BI/Business Analytics Analyst

Business Analytics Analyst Responsible For Integration of 50 Hospitals across the Country. Salesforce data analysis, and Sales department spreadsheets. Prepared Raw Hospital Data And Developed Tableau Dashboards For Each Hospital.

Software Used During Project Crystal Reports, Excel, Power Pivot, Access, Power Bi, and SQL Server 12, Tableau 10.5.

Fresenius Medical / Centralized Account Payable Division (consultant)

Metairie, LA July 2016-Novemer 2016

Sr. Business Analysis

Responsible for daily consolidation of SAP and Kofax reports for management reports for Centralized Account Payable Division. Also responsible for all UAT testing of the applications tested in which I was responsible for.

Skills Used: SAP Admin, SharePoint Admin, Kofax Admin.

TEKSystems - Ochsner (consultant)

Metairie, LA May 2015-June 2016

PL/SQL Developer

During my short time at Ochsner I have had the opportunity to work with the Payroll, Accounts Payable, General and Investment modules in Lawson and the Kronos Timekeeping and Scheduling modules using PL/SQL and Crystal Reporting. I also developed several new reporting processes for the Physician’s in the organization.

Skills Used: PL/SQL, Crystal Reports 2008-2013, Oracle 10 &12, MS Visio, Toad

Shell Oil / ICON Consultants

New Orleans, LA 2014-2014

ETL Developer & Database Coordinator

Responsible for all ETL development for procurement data from several repositories SQL Server 2008r2, 2010 & 2012 using SSIS.

Skills Used: SQL Server 2012 SSIS, SSRS, PL/SQL, Oracle 10g, MS Visio, and Toad

Scientific Research Corporation (SRC)

New Orleans, 2012 – 2013

Senior Systems Engineer

While at Scientific Research Corporation (SRC) Integrated Systems and Solutions I have supported Oracle 11g-12c, and SQL Server 2008r2-2012 migrations on several of our customers. Also during that time I have taken both the PMP preparation and VMware vSphere: Install, Configure, Manage [V5.0] preparation classes and anticipate sitting for both certification before the end of the year. Responsible for all Windows VM Platforms, Virtualization task for the Atlantic Fleet data Centers during my first year. Providing support for both OLTP and OLAP systems with DB interfaces using Informatica and manual ETL processes. Work extensively on API connection with legacy system and Data Warehouse on Windows and Lynx platforms

Skills Used: Java, Java Scripting, SQL Server 2012 SSIS, SSRS, PL/SQL, Oracle 10g, 11g, 12c, Informatica, Oracle Forms and Reports, Toad, MS Project, MS Visio

Wellman- DAK Americas

Pearl River, MS 2011-2012

Senior Software Engineer / DBA

I was originally hired to rebuild the Oracle’s Microfiber BI databases in MS SQL SSAS due to my working knowledge of the BI products used during the JDE implementation. I also successfully completed the conversion analysis and requirements gathering for all systems in preparation for the migration and integration to the DAK Americas including JD Edwards and PeopleSoft into the new of record SAP R3 ERP system located in NC. Object Archiving was done in different objects of PP/MM/FI/CO/PM etc., along with full database backups periodically. Lifecycle management (ILM) software helped streamline your IT infrastructure by decommissioning legacy systems and automating data retention according to rules the company defined minimizing risk with control over the data.

Skills Used: SQL Server 2012 SSIS, SSRS, SSAS, SharePoint, PL/SQL, Oracle 10g, Crystal Reports 2008, Oracle Forms and Reports, MS Visio, Toad, JD Edwards E1/One World, SAP R3, MS Visio, PowerBuilder v7.0 used with TABWARE.

Computer Science Corporation

Stennis Space Center, MS 2007 – 2011

IT Project Manager / System Programmer Analyst Lead

Supervised 18 resources.

Worked as the Integrated Asset Management, Center Implementation Project Manager for Stennis in charge of Implementation, Change Management, and Risk Management for the project and awareness of several of NASA Shared Service Center Initiatives and how the Shared Service Center is managing integrated project priorities with the centers. Ensured that budgetary and financial management operations for the project and complied with NASA Guidance and that key issues and potential impacts were considered in decisions on a monthly basis. Accountable for providing on-going support for the IBOT, BRIO and Hyperion interfaced with SAP BW data. These products are used at all the centers for phasing and budget control outside of the SAP application. ETL work done to move legacy data into SAP BW database and other budgeting databases.

Skills Used: SQL Server 2012 SSIS, SSRS, SharePoint, SAP R3, SAP BW, Hyperion, MS Project, MS Visio

Wellman Inc.

Pearl River, MS & Fort Mill, SC 2006 – 2007

IT Project Manager / Senior Software Engineer / DBA

Supervised 5 resources.

I was the subject-matter expert accountable for administration & supporting the corporate PeopleSoft Payroll and, HR. I also severed as the lead Oracle 10g DBA on our JDE ERP corporate database and PeopleSoft Financials located in Charlotte, NC. During this conversion I converted the Wellman’s legacy data into the JD Edwards Oracle Database using ETL Processes that I developed in T-SQL scripting, refined and executed. Then used PL/SQL to transform and load the data into the JDE databases. I also supported Micro Strategy Data Warehouse & Analytics with JDE data interfacing and implementation. Supported environmental DEQ compliance software for the plant in Mississippi using VB, SQL Server 2000-2005 and Crystal Reports. As well as MS SQL DBA in charge of all maintenance and converting the Job Scheduler from 2000 to 2005 using SSIS as well as Plant SharePoint developer. These applications included ASPEN Tech, TABWARE, and Lab Systems. Each had API connections to the data warehouses. I also moved many of the management reports from Crystal Reports to SSRS for these applications and others. Also served as the lead Oracle 10g DBA on JDE ERP and PeopleSoft ERP Financials and other legacy systems corporate DBA.

Skills Used: SQL Server 2000-2010 SSIS, SSRS, TABWARE, LABSYS, ASPEN Tech, Visual Basic, Crystal Reports 2008, SharePoint, Oracle 10g, PL/SQL, MS Visio, Toad, JD Edwards E1/One World, PeopleSoft, Informatica, Oracle Forms and Reports, PowerBuilder v7.0 used with TABWARE

Perkins Technical Services

Stennis Space Center 2002 – 2006

IT Project Manager / Senior Software Engineer / DBA

Supervised 3 resources.

SME lead accountable for assisting the technical contractor with the design of the NASA Financial Legacy Systems conversion to SAP R3 FI ERP system. The conversion required the development of an interim database repository approach in SQL Server which designed and maintained. Accountable for collecting all of ADABAS tables for ETL data cleansing and conversion prior to loading to the Oracle 9i SAP database tables. PL/SQL and T-SQL were used to transform the data. I also lead the SAP BW team on all reporting needs from the BW data warehouse, Business Explorer (BEX) resource on application and ad-hoc reporting. The ETL phase of this project took 3 years. Once completed actively worked on the next phase of the project, converting the NASA Asset Management Systems into SAP R3, AA scheduled for early 2007.

Skills Used: SQL Server 2000-2008r, SAP R3, SAP BW, MS Project, MS Visio

Digital Consulting and Software Services DCSS

New Orleans, LA 2001 – 2002

IT Project Manager / Senior Software Engineer

Supervised 4 resources.

Regarded as key leader accountable as a project manager and software development. Supported several projects in both client server and thin client environments consisting mostly of clients in both the oil and gas and shipbuilding industries located in the New Orleans and Houston areas. Assisted the firm in achieving a CMMII Level status in software development and directed the development teams on all aspects of software Q&A.

Skills Used: PL/SQL, Oracle 9 Forms & Reports, Toad, MS Project, MS Visio

SAIC

New Orleans, LA . 2000 – 2001

Software Application Engineer

Lead administrator and developer for the B2B Commerce One eProcurement package “BuySite v6.5” for Entergy’s Supply Chain organization. I was responsible for all software releases, administration, and user support of BuySite for the 8 NT servers and 2 Solaris servers maintaining the Oracle databases along with the development of the Java code and adapters used in EAI. I developed all the project interfaces between PeopleSoft and the Supply Chain databases using the EAI adapters for Metadata and other data where needed to support the implementation

Skills Used: PL/SQL, Java, Oracle, PeopleSoft, EAI

Lockheed Martin IMS

Metairie, LA 1995 – 2000

IT Program & Project Manager / Senior Programming

Supervised 10 resources in Metairie, 40 resources in NY.

Lead on this 26 million dollar project for the Port Authority of New York and New Jersey (PANYNJ) projects included accountability for budgets, engineering, construction and software development for eight major toll facilities and two host system sites. The project consists of 100+ PC’s running independently on a dual Alpha 2100 sever running Oracle RDB host located in NY and a secondary host for disaster recovery / host standby. I also maintain the PowerBuilder and Visual Basic applications written for this project along with managing all daily operations under the system administration contract with two system administrators located in NY. Manager of Documentation and QA, Senior Programmer / Analyst for California Transit Project

Manager of Documentation and QA, Functioned as QA manager, accountable for the verification of proposal requirements to detailed software design and to complete documentation of engineering and software specifications. Ensured that each project was developed in a manner consistent with Lockheed commitments and that each component was tested prior to deployment. SQA Test Team software was used for all windows application testing.

Senior Programmer / Analyst for California Transit Project, Provided technical support for California Transit and other projects by monitoring PowerBuilder software releases and Hot Line support information. Worked closely with the vendor to keep development staff equipped with the latest software release updates and software patch documentation. Researched most technical issues encountered by the development staff during its first PowerBuilder Object Orientated Development project California Transit (CALTRANS) by simulating the problem encountered before turning the issue over to the vendor for investigation.

Skills Used: PL/SQL, MS Visio, Toad, Oracle, RDMS, UNIX, MS Project, MS Visio, Visual Basic

Lockheed Martin Engineering - Stennis Space Center, MS - 1994 to 1995

Computer Systems Analyst

Supervised 15 resources.

Lockheed was the Technical Contractor for NASA at Stennis Space Center. During my tenure as computer systems analyst, with the development projects previously handled under the Sverdrup contract working closely with the NASA Comptroller's Office and NASA's Information Systems Branch to direct software development and maintenance, implementation, planning, scheduling and maintenance of current and future systems. With a staff of eighteen programmer / analysts, we developed all business-related software for NASA and other Agencies at Stennis.

Sverdrup Technologies - Stennis Space Center, MS - 1992 to 1995

Senior Programming Analyst

Supervised 18 resources.

Successfully developed and deployed distributed systems to both file servers environment and true client Servers using Object Orientated Development with PowerBuilder 5-6, VB, Clarion, etc. along with Adabas Development tools. Directly accountable for all business-related software development and maintenance for all NASA financial/accounting and support systems. During the period I heard classed to develop a full line of developers with PowerBuilder with other NASA locations within the Agency. With a staff of 18 programmer/analysts we worked closely with the comptroller's office and financial management office to ensure that NASA's accounting systems provided Services for the entire financial community at Stennis.

White Enterprises, Inc. - Covington, LA - 1980 to 1991

IS Director, Vice President

Supervised 27 resources.

Effectively supplied our corporations with full product, life cycle support. Managed 11 programmers, 10 operations personnel, and six support personnel. Personally responsible for hardware and software purchase of 5 million dollar computer systems for 99 finance companies and 4 insurance companies made up of property and causality and life companies. Accountable for designing and implementing financial software for over 140 different corporations during my 12 years as well as establishing in-house hardware and software support staff for mainframe and microcomputer systems, telecommunications systems and phones.

Skills Used: RPG, COBOL, Pascal, Basic, LINC 4/GL, Object Orientated Development

EDUCATION

Bachelor of Science, Computer Science Tulane University New Orleans, LA

Associate in Science, Computer Science Delgado Junior College New Orleans, LA

Project Management Professional Study Group 2013

VMware vSphere: Install, Configure, Manager [v5.0] 2013

Contact this candidate