Sr Business Data Analytics & Developer for MS Sql Server and Oracle

D’Oyle C. Clark

***** *********** **** - ******, ***** 75035 -

Cell: 214-***-****

**********@***.***

Education: Johnson & Wales University Providence, Rhode Island

Associates of Science:, Computer Business Applications (May, 1994)

Bachelors of Science:, Business Management of Information Science (November, 1995)

Professional Focus: Passionate about building practical Business Intelligence solutions for Oracle and MS SQL Server data platforms to businesses for all industries.

Professional Training/Skills/Tools:

Project Management Certification Training

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

Qlickview Dashboard Development

Microsoft SQL Server 2000/2005/2008/2012

Microsoft SSIS – SQL Server Integration Services

Microsoft SSRS – SQL Server Reporting Services

ORACLE Versions 7i, 8i, 9iAS, 10g, 11i, 12.8

ORACLE Developer Forms, & Reports 4.5/6i

Oracle Warehouse Builder ETL tool (OWB)

T-SQL/PL-SQL Programming/interface development

Cognos 10/8 BI Portal Development & Administration

Cognos 8 BI Server Maintenance & Application development

Cognos Series7 BI Server Maintenance & Application development

Cognos Certified Professional

Cognos Impromptu Administrator 4,5, 6 & 7 Series

Cognos Power Play Client/Web 7.0 OLAP

TOAD – Quest Software (12.8.0.49)

SQL Navigator – Quest Software

VB.Net 6.0 – (exposure & working knowledge)

UNIX (Sun for Solaris)

DB2 Version 5-7 UDB – (Query)

Citrix MetaFrame/ICA Client (working knowledge)

Embarcadero – ‘DB Artisan’s SQL Management tool

ERwin data modeling tool.

HTML – (exposure & working knowledge)

Professional Experience:

(6/2016 – 8/2016) Interstate Batteries – Dallas, Texas

** BI Data Architect/Data Liaison (Contractor)

Gather business requirements from end-user perspective

Gain a technical business and development understanding of existing data model

Data profiling of data per the end-user requirements

Develop complete BI solution to translate over into the MicroStrategy BI platform

Work with Oracle developers to implement coding solutions; creating scripts and stored procedures to migrate data from Source-to-Target database schemas.

Conceptualize and create data model of data elements needed for reporting analysis

Manage the development process of coding concepts from documentation status to end of project lifecycle

(1/2016 – 5/2016) AT&T (via CGI), Dallas, TX

** Senior Developer/Data Architect - Contractor

Develop and optimize tables manually as well as created stored procedures to help handle the load process of staging data to production environment.

Create and support Data Model for AT&T Security Product Dashboard project

Develop data model(s) using VISIO to illustrate data relationships proposed for model (test and development environments)

Help Project Manager manage projects and orchestrate the movement of the full SDLC

Data migration utilizing the TOAD (v 12.8.0.49) application from flat file to Oracle database platform

Create Oracle data warehouse Star Schema model for staging and production level analysis and reporting

Document manual and automated data migration processes

Create data dictionary and manage the process flow of populating the database environment

(2/2015 – 5/2015) BenefitMall, Inc., Dallas, TX

** Senior Business Intelligence Analyst/ Data Architect - Contractor

Profile data via SQL scripting of stored procedures and document test cases to insure data probability

Ensure data integrity through analysis, coding, writing clear technical documentation & problem resolution

Gather information and create Business Requirements Documentation (BRD)

Perform data mapping for proposed data models and initiate data-dictionary documentation

Create and document existing MS SSIS 2010 ETL process

Work closely with data architects, business users and systems engineers to drive the definition and implementation of proposed project initiatives

Review and document existing data models and profile object data for development prep and/or revision

Identify, handle and alleviate risks and project discrepancies via UAT procedures

(7/2013 – 10/2014) RealPage, Inc., Plano, TX

** Senior Developer/Business Data Analytics

Create PL/SQL procedures and scripts for load process to test, development and production areas

Create and manage the MS SSIS 2010 ETL process

Develop project plan for management team with LOE specifications before and during project initiatives

Quality Assurance Test validation and user-acceptance within continental United States and off-shore.

Manage off-shore QA validation initiatives with India resources

Requirements gathering and creation of Business Requirements Documentation (BRD)

Perform risk analysis as part of user-testing for project lifecycles and give methodical solution to probable issues.

Create data models and profile object data for development prep

Influence both agile and waterfall methodologies and allocate resources to complete the tasks.

Identify, handle and alleviate risks and project discrepancies

Ensure data integrity through analysis, coding, writing clear technical documentation & problem resolution

(3/2010-7/2013) Vertex Business Services, Richardson, TX

** Senior Developer/Business Data Analytics

Create PL/SQL procedures and scripts for load process to test, development and production areas

Create and manage SSIS/DTS Automation for all projects

Create data-mapping for ETL processing and data dictionary delivery.

Intercontinental/Continental consulting services to external client sites for development and support

Create a detailed work plan which identifies and sequences the activities during lifecycle of the project

Qlikview Dashboard Development for various external client-based projects (United States, Canada and United Kingdom)

Analyze & translate functional specifications & change requests into technical specifications/documentation

Provide user-testing case scenarios throughout the lifecycle of projects.

Perform pro/con risk analysis per user’s request to insure the integrity of projects.

Insure management team that the project is being executed according to the project plan

(7/2009-1/2010) XO Communications, Plano, TX

** Senior Enterprise Business Intelligence Business Analyst

Develop scope for production projects utilizing Neteeza and Oracle database platforms.

Served as Senior Business Analyst to help manage project lifecycle working with upper-management and mid-level management from other groups within the XO organization for a team of 12 individuals across the United States in other XO locations and onsite

Project Management – Keeping the tasks aligned with the responsible party and assuring the timeline of scope remains current for upper-management and field engineers.

Create and deploy Web/OLAP-based Cognos ReportNet 8.4 reports

Recommend system modifications and give development detail on the best way to achieve the goal of tasks in scope to Project Managers, Upper-Management and Technical Leads

Allocate solutions to the problems encountered during the “break” session.

Prepare recommendation for production roll-out/implementation

Quality Assurance Testing: Document and execute project unit test plans; orchestrated with other team Informatica developers to prove implementation scenarios and results of data migration.

Pre-user testing of data extracted from external source files as well as TBS database

Prepare technical support recommendation for post-project implementation and web-deployment.

(10/2008-5/2009) XO Communications, Plano, TX

** Senior Business Intelligence Developer & Business Analyst

Create and modify MS SQL Server 2005 procedures, user-defined functions/triggers, views and table structures

Develop SQL code for both MS SQL Server 2005 and Oracle 10g within all development, testing and production environments

Migrate system data from Oracle 10g data platform to MS SQL Server 2005 database via SSIS packages

Import and Export data via MS SQL Server 2005 developer interface

Project Management – create solutions to improve business processes, promote the strategic use of information technology, and enable the end-users access to newly created dashboards and reports

Served as Business Analyst to initiate scheduled projects and deliver product to end-user base working with other systems and server administrator groups within XO.

Document SSIS package process flows for all client-based projects in a dual platform environment

Quality Assurance testing: Document and execute project unit test plans; orchestrated with other team SQL developers to prove implementation scenarios and results of data migration.

Create web-based Microsoft Reporting Services and display results via web-enabled Report Manager to end-user

Orchestrate MS SQL Server data environment cleanup with SQL DBA’s between multiple database instances

Analyze information to determine, recommend and plan installation of a new development or modification of an existing systems/development

(9/2004-7/2008) Moroch Partners, Dallas, TX

** Senior Enterprise Business Intelligence Developer

Responsible for the planning stages for MS SQL Server 2000/2005 data warehouse projects logical layer and code development for the physical layer

Project lead for implementation of various projects depending on clients, spanning between multiple departments and user groups.

Mentor junior-level developer and hired consultants with both the Logical and Physical layers of both MS SQL Server 2000/2005 databases

Manage and maintain Cognos 7BI/8 Server Administration abroad two separate single-server environments company-wide; working with Network and Desktop Services Group within Moroch.

Predict project development lifecycle for new reporting initiatives and revise time management expenses for maintaining pre-existing reporting projects.

Responsible for implementing application budget for hardware and structuring budget for application support and renewals.

Set indexes on database tables for query sensibility and better development flow

Assisted in the hiring process of consultants and new talent being brought to the team

Create PL/SQL procedures and scripts for load process to test, development and production areas

Automate upload processes for various environments by creating and utilizing MS SQL Server 2000 DTS packages/SSIS for MS SQL Server 2008

Create Cognos ReportNet, Impromptu Web Reports and Power Play Web cubes for OLAP modeling drill-down reports and be responsible for deployment to all environments (test, development, and production)

Develop and maintain company reports utilizing Microsoft Reporting Services

Cognos 8 Framework Manager Modeling for multiple client data warehouse schemas

Customizing/re-facing Cognos Connection interface pages and specialty modules

Cognos server installation and configuration (Series 7 and Cognos 8)

Extensive experience developing dimensional models and data warehouse/marts

Hands on understanding of dimensional modeling and data analysis (data profiling).

Create mainstream documentation for all projects once the task was moved to production

(8/2001-8/2004) UNITRIN Property & Casualty Insurance (Trinity Universal Insurance), Dallas, TX

** Senior Oracle Database Engineer/Cognos Developer & Administrator

Project lead of 4-person development team for implementation of accounting portal containing sensitive company-income data

Managed the implementation, migration and maintenance of Cognos BI & Series 7 Web single-server environment working with

Quality Assurance testing: work with QA specialist to test the Accounting and Oracle Financials upload and migration of data to the Test, Development and Production databases.

Data migration utilizing the TOAD application from flat file to Oracle database platform

Create Oracle data warehouse structures utilizing tools such as Embarcadero’s-‘DB Artisan’s’ data management tool, Oracle Warehouse Builder ETL tool and (ERD) Entity Relationship Diagram diagrams using ERwin

Develop Oracle dimensional data warehouse with fact tables, aggregate tables for all lines of business

Plan for data warehouse development logical layer and code development for the physical layer

Create custom queries in Oracle 9/11i Financials environment, SQL Server as well as DB2 Version 5-7 UDB for external offices.

(Oracle, SQL Server & DB2) for upper-management reporting needs

Build OLAP Models for Cognos BI/Series 7 suite for Power Play Reports and Power Play Transformer Administrator of all Cognos web applications

Create Impromptu reports and Power Play Web cubes for drill-down reports and be responsible for roll-out to all environments (test, development, and production)

Teach courses for Cognos Upfront PowerPlay Web Application to all users, company-wide Build Oracle Reports and Forms for production use and implement connection address for Web deployment

PL/SQL procedures and scripts for load process to test, development and production areas

Analyze database performance and send recommendation for tuning

Coordinator of all web-related/interactive projects and system access permissions for web-based applications and applications to be implemented on Citrix Server environment

(8/98-8/2001) First American Corporation, Dallas TX

** Mid-Level ORACLE Developer/Cognos Developer & Administrator:

Network-driven Responsibility:

Managed project to for the implementation of ORACLE-based utilities onto LAN-driven, Citrix MetaFrame server, for accessibility to 30 remote clients working with team of 5 Oracle DBA’s as well as 2 Network Administrators across the United States

Daily Tasks/Responsibility:

Cognos Impromptu Administrator and Report Developer

Quality Assurance testing: work with QA specialist to test the payroll/HR upload and migration of data to the Test, Development and Production databases.

Work with the ORACLE Financials Group for creating conversion specifications and coding changes, in order to write the General Ledger (G/L) reports and custom objects for company clients.

Assisted in the migration of Human Resources data to Cyborg’s HR System as well as Cyborg’s Payroll system

ORACLE Developer-Programmer/Analyst for Human Resources, Benefits, and Payroll departments, company-wide

Create/Modify- ORACLE tables, views, and stored-procedures for Cyborg HR/Payroll users, both internal and external, utilizing SQL Navigator PL/SQL editor.

Provide on-going system support for ORACLE, Cyborg, and Impromptu applications for internal and external users

Create Payroll and Human Resource reports, menus, and screens using utilities such as ORACLE Forms, ORACLE Reports, ORACLE Discoverer, SQL Navigator (PL/SQL Editor) and Impromptu Administrator.

Data-modeling of Cyborg System non-relational objects for customized conversion to fully relational objects for easier and more sufficient reporting for both developer and end-user communities.

Assist in the procedures of ORACLE Data Migration to the Cyborg Human Resource and Payroll System using the SQL Loader program

Data-Warehouse design of Cyborg System objects for ORACLE versions 7 and 8i development, test, and production environments

Create/Modify- Unix scripts and run batch jobs for company pay run processes (month-end, quarter-end, & bi-weekly pay periods)

Work with ORACLE DBA’s to resolve database issues within the company’s testing, development, and production environments

Tool/Utility Implementation and Administration:

Administer the Payroll check printing procedures through WestCorp and deliver on-going system support for internal server and client sites.

Technical writer for internal and external users of processes and procedures

Technical training of Impromptu software to internal and external users.

Writing technical and function documentation for Payroll projects, along with executing the development and Quality Assurance Testing (QAT) work for custom reports, comparing them to the Cyborg HR/Payroll system.

(2/98 - 7/98) Computer Task Group (CTG)/IBM, Dallas TX

** Senior Helpdesk Lead

Helpdesk Team Lead of 7 helpdesk support specialist

Implementation of the McAfee helpdesk utility for internal users onto Windows NT network

Training for Individual technicians working on the helpdesk team

(3/97 - 2/98) RealPage, Incorporated, Carrollton, TX

** Junior Network Administrator

Junior Network Administrator for Windows NT Local Area Network (LAN), supporting approximately 250 employees

Windows ‘95, ’98 Beta, and NT(4.0) workstation system configurations

Install and configure peripherals for customer sites as needed

Administer accounts for internal users to receive access to specific network resources

Analyze and answer departmental/company personnel with internal network questions, with resolutions

(1/96 - 1/97) Mastery Support Group, Plano, TX

Telephone Technical Support for the IBM System/34,36,

AS/400, and Lattice RPG II & III

RPG II & III program development and modifications

Technical writing for IBM PC, System/36 and AS/400 software

ACTIVITIES:

Omega Psi Phi Fraternity, Incorporated

Alpha Iota Iota Graduate Chapter “Chaplain” (Present)

Mindset Migration

Tutor both boys and girls in the fields of Math and Science at the Plano Boys & Girls Club (Present)

National PanHellenic Council – North Dallas Suburbia Chapter

President (2016)

Vice President (2015)

Professional References

Reginald Sluch – 214-***-**** – ********.*****@********.***

Eric Dacon – 469-***-**** – ****.*****@***********.***

Erica Fleming – 469-***-**** – *****.*******@***********.***

Contact this candidate