WILLIAM LeCONTE

**** ********** **

Ellicott City, MD 21042

410-***-****

acugdr@r.postjobfree.com

CAREER PROFILE

Experienced project manager and business development professional with a proven track record developing and maintaining financial planning and analysis systems and data warehouses. Demonstrated success developing and mentoring financial analysts and other personnel. Experienced with complex full lifecycle projects including coordinating and communicating with multiple stakeholders and developing highly customized deliverables. Recognized as a hands-on, savvy problem solver able to efficiently resolve business process issues, formulate strategic plans, and implement effective change.

AREAS OF STRENGTH AND EXPERTISE

SAP BPC 7.5 Administration & Reporting

Life Cycle Development

Team Management

Relational Database Modeling using MS Visio

SQL Server Administration 2012

SAP BPC 10.0 Administration & Reporting

Process Implementation

Financial Planning & Analysis

Dimensional Database Modeling using MS Visio

SQL Server T-SQL scripting

Data Modeling using ERwin

Project Management

OutlookSoft Everest

ERP Solutions

SQL Server / Analysis Services 2012

SQL Server Integration Services 2012

PROFESSIONAL EXPERIENCE

College Avenue Student Loans, Wilmington, DE 9/2015 to 2/2016

Contractor Database Developer

Perform all aspects of architecture, design, and implementation of a data warehouse. Skilled at using SQL Server 2012 SSIS and implementing C# scripts, T-SQL scripts, SSIS expressions, and many other tools.

Key Accomplishments:

Built complicated ETL processes with many transformations using SQL Server Integration Services (SSIS) 2012 to load data from multiple data sources and populate multiple destinations. Designed relational databases and modeled data in 3rd normal form using a data modeling tool (Microsoft Visio) for storing data from partner organizations.

Amtrak, Washington, DC 8/2006 to 6/2015

Senior Manager Financial Systems

Oversee five financial analysts who support Business Objects Planning and Consolidations (SAP BPC) for all financial analyses, financial planning, and internal/external financial reporting. Administer BPC Application Sets including dimension maintenance and fact table loading with actuals, budgets, and forecasts. Manage BPC production, staging, and development environments. Administer the change management process during software version upgrades and implementation of new functionality.

Key Accomplishments:

Coordinated implementation of SAP BPC with up to five consultants who assisted in the development of new functionality for Amtrak’s allocation models.

Designed and managed the development of a rule-based cost allocation system built with SQL Server 2008; built many SSIS packages to populate SSAS cubes with general ledger data and statistical data from other systems; supervised the transfer of the system from the legacy Walker Systems data model to the SAP ECC (FI/CO) data model. Designed and implemented input templates for allocation rule entry as well as reports from the allocated data. The design of the databases involved modeling data for a destination/staging environment.

Developed BPC Excel based report templates utilizing EVDRE functionality and EPM 10; created BPC input schedules, developed advanced logic files, and created data manager packages to extract data from BI/BW (FI/CO) data and load into BPC cubes.

Build AppSets and Environments for planning and analysis including BPC logic files to calculate standard labor rates for forecasting, Rate cube creation and population, dimension design including multiple hierarchies for cost centers and accounts, and calculated member creating in dimensions to facilitate easier end user report creation.

Develop and deliver end-user training for creating reports in SAP BPC.

Managed the migrations from OutlookSoft Everest 4.2 to OutlookSoft 5.0 to SAP BPC 7.5 and finally to SAP BPC 10.0.

Constellation Energy, Inc., Baltimore, MD 2/2005 to 8/2006

Contractor Application Developer

Developed parts of a financial planning and reporting package using SAP BPC. Administered OutlookSoft solution including providing daily support and maintenance. Managed dimensions, reconciled General Ledger, scrubbed and adjusted imported data, and performed other support-oriented tasks necessary for production support and data integrity. Built various Data Manager Packages to create flat file exports from dimensional data for import to other external systems.

Key Accomplishments:

Gathered requirements to develop appropriate customized BPC input templates for uploading budget and forecast data with advanced logic for calculating benefit, inflation, and overhead rates.

Developed Data Manager Packages in SQL Server DTS (SSIS) to perform Extraction Transformation and Loading (ETL) tasks that imported and transformed flat files from a PeopleConnect database containing employee work time and vacation time for an employee cost buildup model.

Utilized ActiveX scripts and T-SQL tasks in Data Manager Packages (extended SSIS) for loading information into a dimensional database (SSAS) designed for data warehousing of financial and project-related data.

Visicu, Baltimore, MD 8/2004 to 2/2005

Contractor Data Warehouse

Consulted on data warehouse project for a company specializing in remote management of intensive care units in hospitals.

Key Accomplishments:

Tracked defects and developed a test plan and designed a testing process for the ETL (SSIS) and OLAP (SSAS) systems in development and all reports using the data warehouse.

Assisted in the development of a comprehensive project plan (Microsoft Project) for the data warehouse project by adding detail to the plan’s testing and design phases.

Installed and configured a complete Quality Assurance environment for testing the data warehouse including installing an application and a database server; developed processes for reliably moving objects from the development to the quality assurance environment while preserving the integrity of the environments.

General Data Systems, Bethesda, MD 7/2003 to 8/2004

Manager Database Administration Group

As functional manager, provided technical lead for group of database administrators completing various passport creation contracts for the US State Department. Project manager for an extraction, transformation, and loading project. Developed the plan and coordinated meetings and design sessions for the development and implementation of a complex DTS package that extracts data from 16 external sites and imports that data to a central location for querying and reporting.

Key Accomplishments:

Managed activity of five database administrators, developed project plans and allocated project tasks; generated reports to track task status and overall project progress.

Implemented and configured SQL Server 2000 replication, both transactional and merge, for a development environment.

Utilized version control and DDL scripts to develop a robust and repeatable process for migrating software development projects from a development to a testing environment and finally a production environment.

Peregrin Services Corporation, Owings Mills, MD 1/2003 to 7/2003

Contractor Database Developer

Project lead for an upgrade to SQL Server 2000 environment; wrote the project plan and managed configuration changes. Designed, developed, and implemented a replacement for a production transactional database. Modeled data utilizing a data modeling tool (MS Visio) and wrote all data migration routines using SQL Server 7 DTS.

Amerix Corporation, Columbia, MD 6/1999 to 12/2002

Director Enterprise Information Resource Team

Managed and oversaw seven developers and report builders tasked with creating a data warehouse, Intranet, and Extranet reporting. Designed and developed a reporting infrastructure including relational database design and dimensional modeling.

Key Accomplishments:

Collaborated with a cross-functional process team to redesign and streamline a complicated call flow for a 300-seat call center.

Created reporting that utilized both Active Server Pages and OLAP Server cubes (SSAS).

RESI/ Towson University, Towson, MD 1/1998 to 6/1999

Manager Systems Analysis and Design Group

Project leader for database applications for the MD Department of the Environment to track requests for information compliant with the Public Information Act; designed and implemented a normalized enterprise data model. Wrote proposals for technical projects. Software development projects for large manufacturing firm.

Key Accomplishments:

Collaborated on system analysis project for MD Criminal Justice Information System to provide comprehensive documentation to analyze the current system and propose recommendations on system improvements. Developed data flow diagrams and process analysis documents. Developed relational OLTP database models using ERwin and generated DDL scripts with ERwin from the designs.

Interviewed users, compiled and analyzed data, and created a deliverable providing documentation of business processes and written recommendations for a business process-modeling project for the MD Department of the Environment.

Additional professional experience includes Developer and Network Administrator for Lockheed Martin IMS; Coordinator of Information Systems/ UC at University of Maryland Baltimore County; Developer for InfoSys Services, Inc.; and Compliance Analyst for Legg Mason.

ADDITIONAL TECHNICAL SKILLS

BPC Logic Files

BPC Dimension Maintenance

Oracle PL/SQL

SSIS Expressions

C#

MDX

VB Script

EDUCATION AND TRAINING

Bachelor of Science, Information Systems Management, University of Maryland Baltimore County,

Baltimore, MD graduated 12/1995

Completed Column5 training for BPC version 10 report building

Completed Column5 training for BPC version 10 administration

Contact this candidate