SUMMARY:

• Database Business Intelligence Analyst/Developer with over 30 years of experience in information systems with a strong background in all phases of software and database design, analysis and systems development, both from a business to a technical perspective.

TECHNICAL SKILLS:

DATABASE: ORACLE, MSSQL, MySQL, OBDC, IBM DB2, IBM IMS

BIGDATA: AWS Redshift, Hadoop Datalake (Hive, Python)

DATABASE TOOLS: Oracle Developer, MS SQL Quest TOAD, HeidiSQL, ANSI SQL, IBM QMF, T - SQL, Oracle PL/SQL, MySQL ETL TOOLS / BUSINESS INTELLIGENCE (BI): DataStage, InformEnt, Informatica

SOFTWARE SUITES / OFFICE TOOLS: MS Visual Studios, SharpDevelop, dbForge Studio (MySQL), Java Enterprise Edition, COBOL, C#, FORTRAN, PASCAL, PL/1, Perl, REXX, Unix Shell scripting (Bash), PuTTY, JIRA, Visio, Microsoft Project, Microsoft Office, Visual Basic, VBA

REPORTING TOOLS: Oracle Hyperion Reports, SYBASE Power Builder, Crystal Reports

OPERATING SYSTEMS: Windows, LINUX, Netware, MS-DOS, Wang VS, IBM Mainframes (MVS XP/XA/ESA, z/OS, VM/SP)

VIRTUALIZATION: VMware, Citrix, Amazon Cloud

VERSION CONTROL: Git, TortoiseSVN, PANVALET

PROFESSIONAL EXPERIENCE:

Confidential

Application Development Manager/BI Technical Lead, BA, BI Data Analyst

Responsibilities:

• As part of a multi disciplinary team, conducted data analysis of over 100 applications and transactions to identify data requirements for the migration.
• As a JIRA administrator, created the Harmony project & workflow for the ETL team.
• Utilizing InformEnt's "Warehouse Architect" tool (WA), generated meta data that defined field to column mappings and transformation rules between LoanServ mainframe files and the InformEnt Oracle schema,
• Customized and executed WA release scripts (DML, DDL etc.) to load meta data into PROD and all non-PROD Linux environments, required by InformEnt's "Process Manager" (PM) for nightly loads.
• Customized tasks in the PM schedule and added new controls, including a task to trigger subsequent AutoSys jobs to initiate the AbInitio ETL downstream processing.
• Conceptualized and created specifications for two critical Linux tools
• EBCX - an EBCDIC to ASCII tool to support data analysis
• PMFAA - a daemon app capable of notification and recovery of PM failures.

Confidential

Agile Business Analyst

Responsibilities:

• Utilizing their personal iOS devices, with or without a DermScope attachment, they could submit pictures to a photo and video importer/manager (DCAMS).
• Subsequently, these images were sent into the imaging archives and made available to the Mayo viewer, an integrated imaging system, having access and auditing controls meeting HIPPA compliance requirements.Worked on an "Information Security Management System" that provided a systematic approach to managing risks and threats to information. It helped identify, prioritize, monitor and minimize the range of threats and assisted in the selection of controls and measures to protect information assets.

Confidential

Business Intelligence Analyst

Responsibilities:

• This encompassed identifying and researching both data elements and related requirements as specified by Yale management, business users and SMEs
• Conducted Joint Application Design (JAD) sessions to understand data needs for break/fix support and new enhancements.
• Accountable for conducting quality assurance processes to certify changes to the ETL processes and reports supporting these modifications.
• Provided internal subject matter expertise to the project team on an ongoing basis..
• Created and executed test cases to validate ETL and report code changes.
• Researched and determined level of effort involved for production service requests (SRs) and new enhancements.
• Designed and implemented a new Expense Management Report (FINEM2 Rejected and Preparer Reports) onto Yale's BI web Portal, utilizing Oracle’s Hyperion Interactive Reporting environment and an Informatica ETL data feed.
• For the analysis, consulted with Yale's Procurement department and produced a comprehensive Business Requirements Document identifying the functional, reporting and data requirements, used the TEKsystems team to develop and deliver this project.
• This system was also part of a strategic plan to streamline an existing monthly four (4) day effort to extract, prepare and distribute customized reports to all Yale departments, down to a task requiring only minutes of effort by each department and thus achieving significant cost savings.

Confidential

Business Intelligence Analyst

Responsibilities:

• The approach focused on fostering a high-level of communication, collaboration and feedback with Peabody business partners and technical associates to ensure that the all requirements were identified and perspectives were considered in the staging of the solutions.
• During the Delivery Phase, an iterative development approach was used, broken into Sprints to understand and prioritize the requirements, identify acceptance criteria and to finally migrate the data.

Confidential

Project Control Officer

Responsibilities:

• Designed and developed software (vTrac) to manage support tickets and to ensure that response and resolution performance metrics meet Service Level Agreements.
• Developed process to utilize metrics data (vTrac) to produce monthly Engagement Status Reports, which are presented to CIGNA management and utilized by a total of three CIGNA engagements.
• Designed and developed prototype software for TEK’s Engagement Management System.
• Provided an integrated Engagement Project Workbook, tracking milestones, issues, meeting actions, resources and task assignments.
• Created various time tracking interfaces to record metrics used for management reports.

Confidential

Project Coordinator

Responsibilities:

• In the role of Project Control Officer at Confidential, assigned on the CIGNA engagements, was responsible for the overall daily operations, including administration, client and management reporting, staffing, security and IT infrastructure.

Confidential

Team Lead - CIGNA Service Channel, Maintenance & Production Support

Responsibilities:

• Managed a team of 14 support analysts with primary responsibility to provide 7x24 production support for both distributed and mainframe applications.

Confidential

Team Lead - CIGNA Group Insurance, Maintenance & Production Support

Responsibilities:

• Managed a team of 7 support analysts with primary responsibility to provide 7x24 production support for both distributed and mainframe applications.

Confidential

Team Lead -

Responsibilities:

• Managed a team of 12 UniData Pick developers. The deliverables to CBH included software development, application maintenance, production support of existing applications and on-demand ad-hoc reports.
• The Pick operating system consists of a database, dictionary, query language, procedural language (PROC), peripheral management, multi-user management and a compiled BASIC Programming language.

Confidential

Application Developer and Database Architect

Responsibilities:

• Returning to this engineering company, established and supported a distribution network with dealers that installed the product in over 150 bar and restaurants.

Confidential

Positions: Senior Systems Engineer, Senior Testing Consultant

Responsibilities:

• Prototyping, evaluating and updating the testing procedures, creating estimation algorithms/templates, test tool evaluations and recommendations.
• Utilizing facilitation techniques to establish the clients testing requirements
• Identifying the technical requirements and plan the operational procedures to integrate a converted “Y2K ready” application, within the corporate production environment.
• Authored the Generic Testing Strategy document used with all clients.
• The fundamental architecture of EAW was to physically and logically tokenize all components of an application into a DBMS (Oracle) database, thus deriving the core logic process of each component of an application.
• Using PL/SQL, the Oracle database was then queried to extract business logic, data flow and data relationships, providing valuable insights into an application or program.
• Physical and logical representations of the programs were independently stored in the Oracle database, providing information for many types of queries and code conversions.

Confidential

Application Developer and Database Architect

Responsibilities:

• The core product was a client-server application that used a proprietary, data driven, object oriented sub system that generated all Windows elements from database definitions, allowing complete customization of the applications environment.
• Using serial communications protocols, an interface directly controlled the physical serving of bar liquor orders and authorized the appropriate recipe portions from electronic pouring devices.
• An integrated “eCommerce” interface provided real-time credit card payment authorization by connecting to a financial institution through a Datapac dedicated connection.

Confidential

Senior Software Analyst (MVS & DB2 Systems Programmer)

Responsibilities:

• Successfully scheduled, installed and customized a major system upgrade to MVS/XA and MVS/ESA into our production environment, including all co-requisite subsystems and related 3rd party program product upgrades.
• Successfully tested the Hot-Site Disaster Recovery Contingency System 3 times.
• Successfully scheduled and installed system upgrades to various PUT levels, JES2, VTAM, DF/DSS, DFP, DSF, Jes/Master, JM/ABR, JARS/DSB and many more IBM and 3rd party program products.
• Designed and implemented various systems and program product user exits, including the Logon Post Validation and Dataset Post Validation exits for ACF2.
• Participated both in the installation of VM/SP with an upgrade to Release 3.1 on a 4341, and on an OS/VS1 upgrade to support a 3275 controller.

Confidential

Senior Programmer

Responsibilities:

• As a team member of the Network Inventory System project (an IMS application), coded various COBOL programs, designing structured charts for the on-line programs, and coded BTS & MFS panels, for interaction with the batch and on-line IMS transactions.

Confidential

Programmer Analyst/Security Officer

Responsibilities:

• Total redesign of policies and procedures used in defining security requirements within the corporate environment, and their application.