SUMMARY:

• 20+ years of experience in Application and Data infrastructure development.
• 12+ years of experience in Data Analysis, Business Intelligence, Confidential, Portfolio Analysis.
• 9+ years of experience as Lead/Manager.
• 6+ years of experience in UNIX/AIX/Windows. 20+ years of experience in MVS/TSO.
• 20+ years of experience in SQL(DB2/UDB, Oracle, Teradata, Sybase, SQL Server)
• Good communication and interpersonal skills.
• Results - oriented executive providing more than 20 years of innovative solutions and oversight to teams and technology in several industry sectors (manufacturing- auto and airline, financial, healthcare and academics). Implemented different management styles to drive results in a rapid changing industry.
• Managed Information Systems group supporting production and business operations for Confidential.
• Directed the Administrative Computing Services group supporting administrative and academic business areas for the Confidential.
• Advance Confidential, Confidential applications, resource management, MIS reporting (backend and front-end), project management, system analysis, project planning/budgeting, business analysis, project lifecycle, data analysis, building teams/team motivation, technology trends assessment, presentations/facilitation, technology integration, application development, vendor relationship management, Six Sigma Certified.

TECHNICAL SKILLS:

Mainframe: IBM/AMDAHL V-8 MVS/370 ISPF/TSO

Macro/Mini/PC: Compaq Alpha VMS, Sun Solaris UNIX, AIX, HP-UX, PC DOS, Windows 2000/XP/NT, Windows 7 & 8

Case Tools/Databases: IEF/Composer (BAA/BSD/Construction), Sybase, MS SQL Server 2014, Oracle 10i/11i, Teradata

Applications: Easytrieve Plus, COBOL II and 370, PL/I, Fortran, Assembler, Programmable Controllers, IMS/DB/DC/MFS, Office 2010/2013, Project Access, Hyperion/Brio, Lotus Notes, SharePoint, Visio 2010, SQL PLUS, PL/SQL, SQL, SAS 8.x/9.4 PC/UNIX/AIX\VMS\MVS, SAS Enterprise Guide 6.1

Utilities: NDM, CLIST, REXX, TSO, Panvalet, Librarian, JCL, SDSF, JHS, BTS, Xpeditor, QMF, File-Aid, Abend-AidAXIOM, VSAM, Dialog Manager, Micro Focus Workbench (DB2/IMS/DB/DC), MVS Utilities, HASMCA-1(TMS), Syncsort, SAR, ZEKE, CA-JCLChecker/Jobscan, Changeman, Infoman, CA-7, JobTrac and FTP, HTML, CSS, JavaScript, Java

PROFESSIONAL EXPERIENCE:

Confidential, Tallahassee, FL

Lead Consulting Analyst

Responsibilities:

• Led the research, design, and development for migrating both databases and reporting infrastructures from the mainframe to windows server and SQL Server environment to support various Florida State and Federal education initiatives.
• Create and maintain programs used for data management-ETL, data validation, data transfers, analysis datasets, reports, program validation, development strategy, and archiving
• ETL development
• Data and Database mapping
• Creating SQL Server Tables/Stored Procedures
• SQL Server 2014 Management Studio
• Report development and automation using SAS EG 6.1 and SAS 9.4
• Programs reviews and providing guidance to other programmers and areas
• Providing system development leadership strategies to senior management

Confidential, Scottsdale, AZ

Principal

Responsibilities:

• Working with small business and organizations preforming analytics, developing business rule, processes, KPI(s), Score cards, dashboards and data infrastructures.
• Home computer network and applications solutions, consulting, training, and setup.
• Northeast Africa Regional Hospital Project - startup project from proposal and planning to building and operations
• Performed research studies (Impact analysis, competitive analysis, startup cost, forecasting/projection over several years - operating expense, human capital, cash flow analysis, profit and loss analysis, sales analysis, break-even analysis, balance sheet, etc.)
• Developed proposals
• Co-developed business plan
• Prepared presentations and presented to perspective investors.
• Working with International Business laws, customs, and political impacts for the local government.

Confidential, Columbia, SC

Lead Consultant

Responsibilities:

• Providing standard reporting and ad hoc reporting(SAS base/SAS IntrNet/Business Objects )
• Process improvement. Agile methodology (Stories card, Standups, Sprints, etc.). Traceability matrixes.
• Prepares charts, illustrations, and other graphics and narrative reports to identify and explain data findings.
• Develop, validate, and maintain the collection of data into efficient data infrastructures using a custom build ETL process enabling Contract Bidding Information reporting and analysis support from various sources in DB2/UDB/SAS AIX/KSH scripting environment.
• Document data structures and maintain metadata repository using Business Objects.
• Multi-task and flexible to changes in work and priorities.

Confidential, Pasadena, CA

Senior Data Consultant

Responsibilities:

• Provide project guidance to Kaisers’ executives as consultant role and a high-level SAS programmer analyst.
• Interface regularly with senior management to produce timely and valuable results.
• Lead and make significant contributions and/or provides technical leadership to high visibility projects to identify and resolve issues of strategic importance to the organization.
• Involve in designing, enhancing, testing and maintaining data integrity across multiple databases (internal SAS, DB2, IMS, Oracle, VSAM, external: Adobe, Excel, SAS parsing routines, COBOL).
• Involve in building and maintaining complex statistical SAS routines using macros, vendor software and software written by self and others.
• Coordinate team/project activities and schedules.
• Work closely with IT and outside partners (and physicians departments).
• Design research plans for data gathering and analysis, participate significantly in interpreting analyses and develop action plans as needed.

Confidential, Scottsdale, AZ

Lead Clinical Analyst

Responsibilities:

• Provided project consultation to account executives, program directors, clinical researchers and analysts, enabling - MIS reporting and analytics, QA and campaign list generation (targeting patients and prescription drug claims including Medicare D).
• Involved in developing and maintaining SOP(s).
• Compliance - HIPAA, Medicare D Fraud and Abuse.
• Worked with multiple Blue Cross Blue Shield affiliates (Rhode Island, Tennessee, Horizon, Federal Employee Blue Cross Blue Shield, and South Carolina) claims data to support adherence to care initiatives and to supplement case studies (i.e. Asthma and other chronic illness) for healthcare insurance providers profiling the patients and physicians.
• Worked with Medispan and FirstDatabank repository data.
• Familiar with coding standards (NDC, GPI, CPT4, ICD-9, DRG).
• Administrator of campaign management (track, monitor, deliver, measure) vendor product.
• Used SAS 9.2 (UNIX/AIX/SAS Server/PC), COBOL/DB2,MVS/TSO, SAS, AMO,SAS Enterprise 4.0, MS SQL Server databases, base schemas, Oracle 10i/9i, UDB, Teradata, Toad, Excel and Access. Developed and maintained an ETL process to support the data reporting infrastructures.

Confidential, Boston, MA

Market Information Manager

Responsibilities:

• Provided technical leadership to programmers, researchers and business analysts, enabling business analytics and MIS reporting to support the GWIM (Global Wealth Investment and Marketing) group and business partners.
• Reports were developed using SAS 8.2/9.1 PC/UNIX/MVS SAS/ODS, Teradata, Oracle 8i/9i/SQL*PLUS formatted in EXCEL (macros, pivot tables). (Hands-on programming 70%).
• Used data mining techniques to assist with market targeting and segmentation, produce marketing leads, modeling (BAC Investments attrition, segmentation (cluster analysis method) across all lines of business), customer relationship management, call center metrics support.

Confidential, Brandon, FL

Manager Business Information MIS

Responsibilities:

• Provided technical leadership to programmers and business analysts, enabling MIS reporting support for the entire mortgage division.
• Reports were developed and delivered to a web server using COBOL/DB2, SAS 8.2 PC/UNIX/MVS SAS/ODS and Brio query/Oracle 8i/9i/SQL*PLUS formatted in EXCEL (macros, pivot tables). (Hands-on programming 60%).
• Managed projects that cross business units, manage and help develop business requirements, frequent application and vendor software release-validations. Developed, maintained, tested, and supporting ETL to support data infrastructures
• Developed software upgrades (i.e. Mortgageserv) and data conversion/migration test to implementation plans.
• Participated on Six Sigma Kaziens and Score Card teams.
• Maintained and developed Service Level Agreements (SLAs).
• Business Continuity Procedure Group Leader.

Confidential, Grambling, Louisiana

Director of Administrative Computing

Responsibilities:

• Managed administrative and IT infrastructure projects across administrative and academic units’ boundaries.
• Managed software and consulting vendors’ relationships.
• Proposal and grant writing (Title IV).
• Provided effective leadership for staff, programming, database administration, systems development, training, client services, consultants, production operation.
• Oversaw ongoing frequent software updates and system conversion efforts from POISE to SCT Banner 2000 in a Compaq Alpha VMS/Oracle system.
• Provided users with technical support, customize reporting, data/process research.
• Involved in business continuity development and planning.

Confidential, Newark, Delaware

Manager Business Information services/MIS standard Reporting

Responsibilities:

• Promoted the development and deployment of common business processes and information systems for Portfolio Performance and Tracking reports supporting finance, Confidential, CEO office and marketing partners.
• Reported and ETLs software developed used COBOL, SAS/Mainframe, EXCEL 7.0/2000, Brio and MS SQL 7.0/2000.
• Developed data marts to enable BI (Business Intelligence) reporting using OLAP structure (hands-on programming 70%).

Confidential, Phoenix, AZ

Project Lead Programmer Analyst/Technical Project advisor

Responsibilities:

• Provided system/software analysis, design and developing rule-based and economic logic model driven systems software for Global Fraud Prevention.
• Software developed using COBOL, DB2, IMS, SAS/Mainframe/Unix, Dialog Manager, REXX, CLIST, UNIX Shell Scripts, Perl Scripts, Sybase and JCL.

Confidential, Phoenix, AZ

Senior Programmer/Analyst

Responsibilities:

• Developed software tools for the application developers and testers within Triumph Systems Enablement.
• Provided second-level helpdesk support to programmers and system user to meet SLAs.
• Developed COBOL DB2/IMS/DC/CICS IEF/Composer applications to support end-users and other applications development areas requiring financial type of information world/corporate-wide.
• Performed data modeling and project (analysis, sizing and work plans), supported FIRS (Financial Instrument Reconciliation System).
• Developed IEF/Composer batch (handcrafted) and on-line code to support foreign markets (Australia, Europe, Asia) and US markets.
• Performed problem resolution/maintenance, analysis, design and software development for the Global Rewards
• Technology group utilizing Method/I building blocks.
• The software environment consists of a legacy
• IMS/DC/DB2/COBOL 370 IBM mainframe system that processes in various international markets.

Confidential, Phoenix, AZ

Senior Systems Analyst/Project Leader

Responsibilities:

• Managed multiple concurrent projects in a matrix environment.
• Technical Leadership - provided analysis, design, development and implementation of major projects within the marketing sales and service systems.
• Followed the process improvement modeling (SEI-CMM) lifecycle.
• Project management - directing workflow, specification writing, project (estimates, tracking, impact analysis), involved in developing and executing project test plans, coordinating projects with users and other systems and/or projects.
• Supported MRP and Automated Warehouse Storage and Retrieval Systems.
• Used COBOL IMS/DB2/DB/DC/CICS MQ Series in an IBM mainframe/client server environment supporting mainframe, ETLs, UNIX and data warehouse applications.