inicio mail me! sindicaci;ón

resume

Andrew Helms, ahelms10 at gmail dot com

SKILLS SUMMARY
Databases/Languages: Oracle, Microsoft SQL Server, MySQL, SQL
Software/Tools: Business Objects, Crystal Reports, Excel, Access, TOAD

EMPLOYMENT

05/2010 – present, The Carlyle Group, Data Modeler

Develop data models based on core data concepts for the back office.
Design and develop transactional database models for custom application development.
Design and develop database models for the operational data store, data warehouse, and federated databases to support Carlyle’s Enterprise Information Management Strategy.
Define XML schema definitions.
Provide database implementation and database administrative support for custom application development efforts.
Perform operational data management of existing applications, data reconciliation between integrated systems, data analysis to troubleshoot systems and/or process issues.
Define and implement data migration process for custom software implementation.
Assist in the definition of Enterprise Data Standards, and the oversight of compliance to those standards.
Ensure database design best practices for custom applications development, COTS implementation, and data integration, including:
  • 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/

PROFESSIONAL MEMBERSHIPS

The Data Warehousing Institute, Atlanta Informatica User Group, Atlanta Business Objects User Group

EDUCATION
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
Departmental Honors

Phil Shay said,

June 30, 2007 @ 9:38 pm

Dude… you”re just awesome.

peoplesoft crm said,

February 1, 2008 @ 11:00 pm

peoplesoft crm…

We have very much promoted this type of business practice ourselves and am glad I came across your blog again. I have added you to our digg bookmarking account. Thanks!…

ahelms.com » Recruiters Who Can’t Write Good said,

January 12, 2009 @ 12:35 pm

[…] I launched ahelms.com I did not realize that posting my résumé would result in the receipt of copious emails from recruiters looking to fill “very […]

RSS feed for comments on this post · TrackBack URI

Leave a Comment

This blog is kept spam free by WP-SpamFree.