More about the
candidate:
www.SQRIntegrator.com
Dave Ballesty
P.O. Box 1965
Blowing Rock, NC 28650
(704) 577-9883
WORK EXPERIENCE:
Hill International May 2009- Current
Administration, Configuration and Training for System 9.3.2 Hyperion
Marlton, NJ
Main resource for Hill International HR data warehouse
Duties included:
Configuration of Hyperion System 9
Addition of users by provisioning
Train users on Hyperion System 9 workspace
Application of patches
Import jobs, apply security, create database connectivity, apply adaptive states
Bank of America Jan 2008- April 2009
Remediation Lead for the W
Charlotte, NC
Lead for Remediation of ADIM human resources, part of 800+ TB Teradata data warehouse.
Duties included:
Upgrade of Hyperion system 8.3.1 to Hyperion System 9.3.1
Expert in user of workspace in regards to Essbase, Analyzer, Interactive Reports and Production Reports
Use of SmartCuts to create transparent access to all of the technologies in the System 9 technology stack (BQY calling SQR, etc) and improve user experience.
Performance and tuning of queries, pre-aggregation, removal of table scans and inefficient code and increase database performance by up to 95%.
Use of the Hyperion Java System Development Kit to automate migrations, user activities, cleanup, notification, etc.
Create and execute proofs of concept to remove excess Topics in BQYs, Locked data models, locked SQL calls, inefficient SQR usage, pre-generation of SQL result sets to pre-load user dropdowns in dashboards, and reduce cube load times through the use of pre-aggregation and massively parallel processing schemes.
Create Javascript UDFs to increase usability and decrease the hit to the Hyperion server.
SQRIntegrator December 2003 Jan 2008
Product Development Architect SQR Integrator
Blowing Rock, NC
Developed SQR Integrator. Data Warehouse product that uses visual commerce objects to create ETL scripts in SQR.
Duties included:
Creation of high, medium and low level design using MicroSoft Visio
Created interfaces to Netezza server and use of NZSQL to create a Human Capital Management System
Creation of logical and physical model for both repository and application using ERWIN
Creation of application database and repository database in Oracle
Setup and maintenance of Java Swing development environment.
Development and testing of application in Java Swing
Development of model that integrates application into Hyperion System 8x and 9x
Wachovia Bank May 2001 December 2003
ATM Solutions Hyperion/DW Architect
Raleigh, NC
System Support for Brio business intelligence (version 6-8) and data warehouse implementation for First Union/Wachovia merger (ATM/Branch Global Data Warehouse)
Duties included:
Installation/Upgrade of software used in implementation.
Meeting with Executive end-users and translating business requirements into Business Intelligence design documents
Performance and Tuning of queries.
Developing EIS (Executive Information System) front ends for data warehouse.
Developing Profitability and Forecasting models for current and future development.
Interviewing business owners and completing system design documents and changing the data architect to conform to those requirements.
United States Postal Service May 2001 December 2001
Data Warehouse Architect
Raleigh, NC
Architect for Informatica data warehouse implementation for US Postal Service
Duties included:
Installation/Upgrade of software used in implementation.
Staffing and technical interview duties.
Creation of best practices documents, along with functional and technical specification standards
Meeting with Executive end-users and translating business requirements into ETL (Extract, Translate, Load) and Business Intelligence design documents
Informatica Administrator duties (Server Manager administration)
Informatica Developer duties (Designer)
State of NJ December 2001 May 2001
Data Warehouse Architect
Atlanta, GA
Informatica Architect for Informatica/Oracle 8 data warehouse implementation for New Jersey State Decision Support System (Recipient, Physician, Encounter Claims, Medicare and Medicaid modules, approx 2 Terabytes).
Duties included:
Installing and configuring Informatica PowerCenter and Powermart 5.1 and Striva (EBCDIC file converter)
Translating end-user business requirements into ETL design documents
Informatica Administrator duties (Server Manager administration)
Informatica DBA duties (Repository Manager administration)
Informatica Developer duties (Designer)
Developing 800+ map ETL system
Use Flat File and Mainframe inputs, develop expressions, filters, joiners, mapplets to arrive at the end-user business requirements for inserting data into data warehouse.
Training users and developers on Informatica development and administration tools.
North Carolina Community College System April 2000- December 2001
Data Warehouse Architect
Raleigh NC
Informatica 4.7 /Sybase ASE/ASIQ data warehouse implementation for North Carolina Community College System Data Warehouse (approx .5 Terabyte)
Duties included:
Completing impact analysis of significant added functionality
Reconfiguring and rebuilding server environment (added memory and disk space)
Reconfigured database and disk allocations to reduce disk contention
Executed performance and tuning on existing mappings
Created functional and technical specifications in conjunction with subject matter experts for HR, Curriculum and Staff modules.
Data Modeling using PowerDesigner.
Created the new mappings, tested the new mappings, created new sessions and batches for the mappings
Performed cycle testing and user acceptance test duties, provided DBA support, production support and error handling for 58 colleges with apx. 12,000 teachers and 700,000 students.
Bank of America June 99 Jan 2000
Implementation Science Corp ETL Developer v7.5
Charlotte, NC
· Solicitation of new business and management of developer assignments for business sent to Implementation Science for 250+ hours per week of fixed bid BRIO SQR interfaces, reports and ETL programs hosted by the ADP Corporation (55 hosted midsize companies)
· Troubleshooting, performance & tuning of 100,000 pay production PeopleSoft system in an Oracle environment
· Functional and Technical Specification, PeopleTools and BRIO SQR development of 401(k) and executive deferred compensation plan interfaces and reports
Piedmont Natural Gas April 1999- June 1999
Implementation Science Corp PeopleSoft Developer v7.5
Charlotte, NC
· Analysis of current materials management system
· Analysis of PeopleSoft Projects Costing system in an Oracle environment
· Analysis of interfaces of all systems feeding PeopleSoft Projects Costing system
· Create interfaces and reports using Hyperion SQR and Intelligence
· Performance and tuning of PeopleSoft batch code
· Make recommendations for interface enhancement to implement a Projects Estimator system.
Piedmont Natural Gas May 1998 - April 1999
Implementation Science Corp PeopleSoft Developer
Charlotte, NC
· Development of BRIO SQR reports, interfaces and data conversion (ETL) for PeopleSoft AP, AR and GL Implementation in an Oracle environment.
· Development of BRIO SQR reports , interfaces and data conversion (ETL) for PeopleSoft HR/BEN/PAYROLL Implementation.
· Performance and tuning of PeopleSoft batch code
· Development of functional and technical specifications methodology for current project.
· General support for the user community (HR, FINANCE, PAYROLL).
Insignia Corporation January 1998 - May 1998
Maxim Group - PeopleSoft Developer
Greenville, SC
· Development of BRIO SQR reports , interfaces and data conversion (ETL) for PeopleSoft AP, AR and GL Implementation in an Oracle environment.
· Development of Functional and Technical specification methodology for the Insignia Corp.
· Workflow specification and development using Business Process Designer, and implementation of Workflow using message agent, database agent, advanced route controls, workflow PeopleCode, and other workflow tools.
· In process of creating PeopleSoft Toolset for impact analysis, BRIO SQR code auto generation, Automated Interface Tool, etc. I hold intellectual property to this toolset
First National Bank of Maryland September 1997 - December 1997
Maxim Group PeopleSoft Developer
Baltimore, MD
· Write battery of BRIO SQR programs to convert (ETL) voice response benefits information for 15,000 employees for a PeopleSoft 6.0 HRIS project in an Oracle environment. Insertion of historical and current core benefits and employee information for open enrollment.
· Interface and reporting development in BRIO SQR, PeopleCode and Reportsmith to meet end-user business requirements.
Database Applications Consulting June 1997 - September 1997
PeopleSoft Developer
Senior Technical Consultant for ADP/CSS and PeopleSoft implementations for multiple clients in an Oracle environment. Duties include:
· Reports , interfaces and data conversion (ETL) in BRIO SQR and Reportsmith to meet end-user business requirements.
· Implemented Base Benefits with general deduction codes.
· Development of functional and technical specifications methodology for current project.
· General support for the user community (HR, FINANCE, PAYROLL).
· General training of end users in the use of the CSS system.
· Development of test cycle methodology.
· This project is running concurrently with the below product.
Maxim Group February 1997 - June 1997
CSS Developer - SQR
Senior Technical Consultant for ADP/CSS implementation for PRIMUS Corp., A subsidiary of
Ford Motor Credit. Duties include:
· Provide mission critical support, DBA support and new development for installed PeopleSoft system.
· Implemented Base Benefits with earnings and deduction codes.
· Planning, pricing, and documentation for conversion of system to ORACLE database engine.
· Impact analysis and modification to non-ansi compliant embedded source.
· Interface and reporting development in BRIO SQR and Reportsmith to meet end-user business requirements. Development of functional and technical specifications methodology for current project to support outsourcing of future development work for critical path tasks that will occur during PeopleSoft Financials implementation.
· General support for the user community (HR, FINANCE, PAYROLL)
The Application Group November 1995-February 1997
PeopleSoft Developer
Technical Consultant for ADP/CSS (PeopleSoft 4.x) implementation for LabCorp of America.
Duties include:
· Mapping from INTEGRAL to CSS (ETL). Involves working with both subject matter experts and functional consultants.
· Implemented Base Benefits with earnings and deduction codes.
· Conversion of data using BRIO SQR to validate and populate core and benefits tables. ORACLE SQLPLUS ver 7.2
· HTML/JAVA development for local Internet Service Provider.
Technical Consultant for TESSERACT to PEOPLESOFT ver 5.11 conversion for the Allied Signal
Corp.
Duties include:
· Impact Analysis of changes to delivered PEOPLESOFT system to meet end-user business
· requirements.
· Modification of PEOPLESOFT system tables using ORACLE SQLPLUS ver 7.2
· Modification of the 260,000 lines of batch processing code (Cobol) for Ben Admin and Payroll.
First Union Bank May 1995 - November 1995
PeopleSoft Developer
Technical Analyst for MSA to PEOPLESOFT 4.x conversion. Duties include :
· Modification to current PEOPLESOFT system using Peopletools and Peoplecode.
· Writing SQR's to migrate information (ETL) from MSA system (flatfile) to a fully normalized database. ORACLE ver 7.1
· Designing and writing programs and a database to automate the modifications to the Peoplesoft benefits and payroll batch processing software.
· Complete dataflow diagram for the benefits processing software down to the primitives level and a complete system/screen/database interface flowchart.
· Project management responsibilities.
Shaw-Tye Software December 1994 - May 1995
BRIO SQR Developer
· Lead programmer on development team engaged in writing a nationwide RF/Bar-coding warehouse management system for the Curtice Burns Corporation. Primary responsibilities included screen and database design, coding and testing throughout system. System used SYBASE system 10, C, JAM6 JPL(4GL) and BRIO SQR and TRANSACT SQL.
Shaw-Tye Software September 1994 - December 1994
SQR Developer
· Contracted to Curtice Burns Corporate MIS. Primary responsibilities included LAN/WAN support for NOVELL 3.11, 3.12 to the 8 subsidiaries, and the development and migration of applications from the mainframe to the server.
· Contracted to The Comstock Michigan Fruit Corporation. Primary responsibilities were development of company-wide parts tracking system in Foxpro V2.5. 9/1/94 - 12/1/94
· This project ran concurrently with the previous project for Curtice Burns.
Shaw-Tye Software March 1993 -September 1994
SQR Developer
· Programmer on development team engaged in writing a nationwide RF/Bar-coding warehouse management system for the Curtice Burns Corporation. Primary responsibilities included screen and database design, coding and testing throughout system. System used SYBASE, C, JPL(4GL) and TRANSACT SQL, BRIO SQR.
· Programmer on development team involved in writing human resources program for the Curtice Burns Corporation. This was on a fixed price contract basis using FOXPRO V2.5.
· 1/94 - 4/94.
· This project ran concurrently with the above project for Curtice Burns.
Financial Services Industry April 1983 March 1993
· Started as All lines agent for the Metropolitan Companies.
· Became Independent under The Travelers and Travelers Equities and Securities Inc.
· Represented Travelers for medium sized companies (SEP, Section 125 plans, 401(k), Group Life and Universal Life, Health and Dental insurance). Worked in the 50-5000 employee market.
· Represented the New York State Business Council for employer benefits.
· Troubleshooting for Travelers Regional office computer systems.
· Went back to Rochester Institute of Technology for Information Systems part time.
U. S. Navy Bomb Squad 78 - 82
· Navy Frogman serving in Mediterranean, Near East, and Continental US.
EDUCATION
ORACLE MASTERS PROGRAM. DBA I and II, backup and recovery,
performance and tuning, Oracle distributed processing, Oracle Tools, etc.
Rochester Institute of Technology, 1991 - 1995. Senior status with full time studies in
Information systems. Heavy concentration in both programming and systems analysis and
design.
University of Rochester, 1989 - 90. Part time studies while working.
Operating systems
UNIX (SCO V3.2, BERKELEY, HPUX, AIX) SUN OS with XWINDOW
DEC VAX/VMS MS DOS (2.11 - 6.2)
OS/2 Windows (NT and 95)
NT
Programming Environments
C++, JAVA : UNIX, VAX, MICROSOFT C ver 7.0, Borland Turbo C++, Sun JAVA
4GL : PeopleSoft, ADP/CSS, JAM ver 7, Foxpro ver 2.5, SP2
COBOL : VAX, REALIA, COBOLII, MicroFocus
SQL/SQR : TRANSACT-SQL (SYBASE), SQLPLUS (ORACLE), GUPTA (SQLBASE)
DBMS : SYBASE SYSTEM 10, ORACLE ver 7.x,8, XBASE for LANs, Microsoft SQL
OP SYS : UNIX, WINDOWS, OS/2, MS-DOS, VAX
Organizations:
National Association of Underwriters. 1984 - 86
Marion Rotary Club, 1983 - 88
President, VP, Master at Arms, et al.
RIT Roaches Rugby Football Club 1992 - 94
|
