Andrew Helms, ahelms10 at gmail dot com
Databases/Languages: Oracle, Microsoft SQL Server, MySQL, SQL
Software/Tools: Business Objects, Crystal Reports, Excel, Access, TOAD
05/2010 – present, The Carlyle Group, Data Modeler
- Database change management
- Automated database deployment
- Agile database development methodology
06/2007 – 05/2010, American Cancer Society, Data Architect & Analysis Manager
Manage team of four reporting analysts.
Design and develop Oracle data marts for the Best Practices Initiative. Manage and design the Initiative’s technical architecture.
Own system structure integrity and data integrity of integrated Strategy & Alignment data marts. Serve as technical team lead in the development of business intelligence reports and analysis; provide mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems.
Automate ETL processes that populate two Mission Strategy & Alignment data marts that are the source for nationwide scorecards and dashboards
Conduct complex analyses of strategic issues based on analysis of trends and interrelationships of key performance drivers documented in the data marts; especially the identification of test and control groups and comparison and evaluation of their relative performance; synthesize research results and develop actionable strategic recommendations; communicate research results and strategic recommendations to nationwide and division strategy managers.
Seek and exploit opportunities to integrate Best Practices data marts with other business units’ data marts (Finance, HR, CRM)
Manage the migration of the Best Practices Initiative’s reporting environment from Business Objects 6.1b to Business Objects XI
02/2005 – 06/2007, American Cancer Society, Enterprise Reporting Analyst/System Administrator
Architected reporting solutions for CRM, Human Resources, and Warehouse business units. Source systems: Siebel, PeopleSoft, Lawson, Red Prairie, Lotus Notes
Designed and developed Oracle data marts, managed project implementation schedules, developed Business Objects universes, developed .NET web application interfaces.
Administered – deployed, configured, patched/maintained – the Business Objects Environment: Accomplishments include implementing:
- Clustered production, development and QA environments: Improved system performance and allowed 75% more users to access the system concurrently.
- A SQL Server repository on a Windows 2003 server: Stabilized the environment; decreased the number of unplanned outages from averaging 2/week to having just one in two months.
- Row-level security: Adding security on the Finance data mart enabled nationwide reports to be published. Prior to adding row-level security, Finance users had to build separate reports for each division.
- Broadcast Agent functionality: Enhanced user efficiency greatly by scheduling 100+ Finance reports to refresh daily. Prior to adding the functionality, Finance users had to manually run, save and deliver reports individually.
- Auditing functionality: configuring Auditor provided visibility into which reports were being run, by whom and when. Enabled Management to consider more cost-effective alternatives to licensed software and led to the development of CRM operational reporting applications.
- Enhanced CRM data mart by continually evaluating and adjusting the Siebel universe based on user feedback and auditing reports. The universe includes: 106 classes, 1,324 objects, 51 conditions, 55 tables, 101 aliases, 157 joins and 2 contexts.
Developed and maintained Business Objects universes for three business units: CRM, HR, and National Distribution Center. PeopleSoft is the source of HR data; Lawson, Red Prairie, and Lotus Notes are sources for NDC data; Siebel is the source of CRM data.
Created ad-hoc SQL queries to extract data from Oracle 8i, Oracle 9i and SQL Server databases. Advised DBAs by suggesting improvements to performance through the addition of indexes, views and tables. Delivered 7-10 high-volume SQL extracts/counts each week to business users.
Deployed Business Intelligence software applications: Business Objects 6.1b and home-grown .NET web application.
Used Visual Studio .NET, C#, XML, Crystal Reports and Oracle 9i to deliver reports with increased flexibility to the CRM user community.
Created SQL queries to extract information from Oracle 9i databases and provide functionality via a .NET web application to download the information in multiple formats.
Interacted with business users to gather requirements and to set deployment, training, and user testing schedules.
10/2003 – 02/2005, American Cancer Society, Support Analyst
Provided hardware and software support for ACS employees including extensive support for Business Objects and Siebel
Monitored the Business Objects application server to identify performance trends and user activity; assisted Business Objects report writers with developing and editing new and existing reports; assisted Business Objects consumer users with finding and running published reports; assisted CRM trainers with identifying common problems; reviewed, assigned, and monitored all Business Objects trouble tickets
Managed the Support Desk’s ticket tracking system, GWI, including http://supportdesk.cancer.org, http://helpme.cancer.org, and associated Lotus Notes databases: trained technical support staff on use of GWI; trained end users on use of http://helpme.cancer.org/
The Data Warehousing Institute, Atlanta Informatica User Group, Atlanta Business Objects User Group
2008: Master of Business Administration, Computer Information Systems
Georgia State University – Robinson College of Business, Atlanta
2002: Bachelor of Business Administration, Decision Science & Information Systems
University of Kentucky, Lexington