Candidates About

Technical Experience

  Degrees:      Masters of Science Information Systems, Data Analytics Certificate

  Bachelors of Business Administration, Information Systems, Digital Business  

     Languages:   SQL, Shell Scripting, PL/SQL, R, SAS

 Database:   Oracle, MySql

     Design:  Conceptual, Logical, Physical, Normalization, DFD’s, Use Cases, System Analysis, BPMN

Methodologies:  Safe Agile, Waterfall

  Software:  IBM Cognos, Metamanager, Oracle ERP, Quality Center 10, SQL Developer, Toad, SAP, Service Desk, Visio, Jira, Rally   

Work Experience

Business Analyst                Great American Insurance, OH                  September 2014 – January 2018

·         Produced reports based on user requests and customer consultation using Cognos Report Studio

·         Analyzed and Edited existing reports for updates and error fixes

·         Developed and Modified Cognos Framework as basis for reporting needs

·         Utilized SQL and explored existing code to do investigation into data discrepancies to find root data causes for report differences and recommend adaptations

·         Transitioned to Safe Agile work processes, utilizing scrum and user stories from ticket and project based workflow

·         Completed various Cognos Administration tasks as needed in both Cognos 10 and 11 environments

·         Created and Maintained Datasource connections in Cognos

·         Deployed frameworks between various environments

·         Worked on Customization of new Cognos 11  installation

Quality Assurance              Fidelity Investments Covington, KY                                April 2013- September 2014

Contractor

·         Processed Files through Oracle ERP to create print request  in order to test document layout

·         Used HP Quality Center 10 to track test cases ran in Oracle ERP dealing with picking and receiving of goods

·         Tested ability of Image Capture System to accurately gather and transfer information scanned

Release Engineer               Fidelity Investments Covington, KY                                    February 2012- April 2013

Contractor

·         Deployed Code to Development and Production environments using internal tools and HP’s PPMC

·         Maintained Non- Production environments

·         Responsible for Weekly and Bi-Monthly updates to Address Database systems.

DBA/Jr IT Systems Tech Developer                        Hewlett Packard Cincinnati, OH            January 2008- February 2012

·         Utilized Kalido environment to create an environment for real time access to analyze information from various sources

·         Created Oracle and Unix Accounts on various servers and databases

·         Organized meetings of an internal Oracle user group, send out weekly newsletters/meeting minutes

·         Redesigned process for automating remote Function Calls in a Disaster Recovery environment

·         Maintained space according to monthly estimates for critical servers

·         Tested and validated migration list and data model for the redesign of a client application

·         Adapted development DDL into Data Model Specification Document

·         Assisted in creation of Materialized Views and client project’s base architecture

·         Expedited technical tickets  between multiple organizations

·         Migrated  building block and finance applications between various environments

·         Conducted table specific recovery of a production database

·         Completed data moves between databases using various methods including database links, export/import and imports via data pump

·         Confirmed partition compatibility, gathered statistics and updated/confirmed indexes on tables

·         Resolved various issues pertaining to Query re-write, privileges or environment

Co-Op/IT Coordinator           University of Cincinnati: UCit/IRC Cincinnati, OH       January 2003- January 2008

·         Hired, supervised, trained and scheduled  more than 70 concurrent employees

·         Utilized Symantec Ghost Solution Suite to assist in large-scale software deployment

·         Combined Perl, HTML and SQL to update and support dynamic pages for the labs intranet and external websites

·         Re-Structured Lab Assistant position to include evening supervisor and on campus point of contact

·         Facilitated upkeep of over 300 machines in 7 different locations around campus

·         Organized location transfer of 4 offices, server room, workshop and 40-seat lab in a span of two weeks

·         Built and deployed new modularized lab client for use in student labs

·         Created and managed a multi-talented team for various lab management tasks.

Education

Masters of Science Information Systems

University of Cincinnati, Cincinnati, Ohio                                                                                             2011-2014

• Relevant Projects:
  • Created a database backend as well as system design documents for a group task management software system.
• Relevant Coursework:  Systems Analysis and Design, XML, ERP, IT Project Management, Managing BI Projects, .NET, Networking, IT Management

Graduate Certificate: Data Analytics

University of Cincinnati, Cincinnati, Ohio                                                                                            2013-2014

• Relevant Coursework:  Data Analytics, Decision Modeling, Data Analysis Methods, Data Mining, Statistical Computing

Professional Classes                                                  

·Oracle Database 10g: Introduction to SQL                                                                                                    February 2008

·Oracle Database 10g: Administration Workshop 1 Ed 3                                                                                               February 2008

·Oracle Database 10g: Program with PL/SQL Ed 2                                                                                              June 2008

·Kalido Comprehensive Dynamic Information Warehouse                                                                             March 2010

Bachelors of Business Administration, Information Systems, Digital Business

University of Cincinnati, Cincinnati, Ohio                                                                                      December 2007

·         Relevant Projects:

o  Produced a relational Convention Database, from concept to implementation

o  Created a web application that connecting carriers, clients, suppliers and items for a shipping company

o  Developed Contextual, Data Flow, and Use Case diagrams for a Country Club billing system

·      Relevant Coursework:  Database Administration, Systems Analysis and Modeling, Web Development, Emerging Software, E-Commerce, Networking, Database Design and Integration, IS/IT Architecture, IS Strategy for Digital Business

·      Dean’s list for seven Quarters at UC undergrad

Freelance Experience

• Ikasucon                                         Sukyo Corp: Cincinnati, OH            
  • Director of Operations                                                                                                                                             2009 – 2012
    • Responsible for general administration of the convention and oversees scheduling, staffing, and other duties related to the general running of the convention
  • Assistant Director of Operations                                                                                                                           2008 - 2008
  • Head of Registration                                                                                                                                                 2005 -2007

§  Streamlined registration process and procedures