Leonard Nicol

Los Angeles 310-***-**** acgsob@r.postjobfree.com

Senior IT Project Manager

Software/RDBMS & Data Warehouse Development Enterprise Implementations System Engineering

An experienced Project Manager with more than 10 years of experience effectively leading multiple technology

leading medium to large diverse technology projects concurrently. An excellent communicator with proven success

motivating multiple groups to achieve corporate and individual objectives. Excels in liaising between business and

technical areas to achieve on-time, on-budget and on-spec project completions. Able to merge customer and user

needs with business requirements, budgetary restrictions and logistical considerations to meet project deliverables.

• • •

Project Management Program Management Business Analysis

• • •

Change Management Migrations ERP Implementations

• • •

Governance Compliance Vendor Management

Professional Experience

TEKsystem (On Assignment at CashCall) Anaheim, CA February

2014- Present

Senior Project Manager

• Spearheaded auto loan origination and servicing process improvement and implementation projects.

• Managed cross-functional teams to analyze and understand the operational impacts and opportunities for technology

changes across the enterprise.

• Managed all phases of the software development lifecycle (SDLC) for custom auto loan servicing solution. Result: Delivered

software system that saved the client an estimated 1.2 million dollars, (according to the calculations by the finance and

accounting department) and shortened processes from a day to process and approve a loan to minutes. This helped capture a

significant share of the targeted market and generated up to $5.3M in revenues for the first two and half months after launch.

99cents Only Store Commerce, CA April 2013- November 2013

Senior Project Manager

• Managed a team of 10 through all phases of a corporate wide SharePoint implementation upgrade project. Team of included

Design architect, DBA, Network engineer, 2 Business Analyst, 4 developers and 3 QA analysts

• Managed team members responsible for gathering the business, system, and technical requirements for MS Dynamics CRM

(2011) proof of concept implementation.

• Assisted in creating the Functional Requirements Document, the Use Cases, the User Stories, the Data Matrix, the Data

Relationship Map, and the Technical Requirements Document.

• Led requirement sessions with the different business areas to define their business processes and document their system

requirements.

• Managed the configuration and development teams in configuring the system.

• Managed matrixed resources and related relationships for a $2.3 million Buyers Decision Support system Provided guidance for

requirements gathering, data models, and QA test plans and documentation throughout project lifecycle.

The Portal Group (On assignment at Toyota), Torrance, CA September 2012 – March 2013

Senior Technical Project Manager

• Directed the planning, design, production and rollout of new consumer facing internet portal services on an Open Source

System for 92+ web based applications for Toyota Motor services North America. We achieved a seamless, defect-free

migration at 10 percent below budget with no unscheduled downtime.

• Managed a national and international based team in the development of a new internet vehicle customization and purchasing

portal project. On being assigned the project I got it back on track by creating a well-defined project plan, removing obstacles

and tightly integrating the international teams into the project work stream.

• Ensured service level and customer satisfaction metrics were met and built collaborative customer relationships with the client.

• Created project plans that fit the scope; define and clearly articulated project goals and milestones;

• Built up, managed, coached and motivated teams as well as intervened to resolve technical and business issues.

• Produced stage plans, highlight reports, risk logs, requests for change.

• Provided strategic direction during the implementation stages.

BLOCKBUSTER/EchoStar LosAngeles, CA November 2011 – September 2012

Senior Technical Project Manager

• Directed enterprise rollouts of new software and systems Ensuring timely releases through diligent planning. Team

included 30-45 technical resources in various locations within the United States as well as internationally.

• Developed and delivered against comprehensive project work plans, drove execution and reported progress using enterprise project

management tools.

• Led a merger and integration project of three recently acquired company’s digital movie catalogue interface systems.

• Guided a team of twelve IT professionals in the development of relational database management systems (RDBMS)

for an enterprise digital media catalogue.

• Managed a team of six in the development of for cross platform movie mobile applications. EchoStar mobile

application launched on time and 5% under budget.

• Managing day-to-day project workflow and client interactions.

• Actively monitor project risks and scope creep to foresee and identify potential problems and solutions

• Mentored staff in methodology and consulting excellence and encouraged best practice in project management and project

planning.

• Maintained budgets and continuous alignment of program scope with strategic business objectives, and make recommendations to

modify projects to enhance effectiveness toward the ultimate business results or the organization’s ultimate strategic goal.

DIRECTV El Segundo, CA September 2005 –November 2011

Infrastructure Project Manager

• Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other

organizational objectives including the standing up of the corporations data center. Work involved moving and virtualization of

multiple key applications from El Segundo to Phoenix (AZ) and Denver (CO) data centers. Major activities involved

Architecture reviews, capacity planning, work scheduling, implementation planning and execution, post implementation

planning and execution (cut-over and normalization).

• Duties include the execution of one, or more, medium-sized, moderately complex infrastructure upgrade projects within a PMO

environment.

• Responsible for overall coordination, status, reporting (MS Project / Clarity), and stability of project oriented work efforts within

assigned project to insure that all assigned projects and milestones are delivered on time, on scope, and on budget.

• Dealt closely with vendors such as HP, Verizon, Qwest, and Terra Data in addition to many others.

• Delivered against approved project budgets and provided timely and accurate forecasting, invoicing and reconciliation.

Enterprise Project Manager

• Provided guidance to internal delivery teams on Risk Management, Governance & Audit.

• Worked with the solution teams in designing the audit, risk & compliance solution in line with FCC regulations and also

provided technical guidance on design optimization.

• Liaised with the regulatory compliance team in finalizing the workflow & design of Governance, Risk & Audit management

application for both FCC and Sarbanes Oxley regulations.

• Participated in and conducted research and development in best practices around core business processes, IT security.

• Assisted in GRC solution enhancement by customizing out-of-the-box functionality as well as development of new applications.

• Participated in steering committee meeting & provided reports on functions implemented & updates on solutions.

• Ensure that all incidents related to GRC solution were resolved within defined SLAs.

• Responsible and accountable for the coordinated management of multiple Web projects directed toward strategic business and other

organizational objectives.

• Managed DirecTV’s Media Asset Management (MAM) System including adding new assets, bug-tracking, vendor

communication, metadata control and vocabulary. Most projects were managed and controlled using agile scrum methodology.

• Responsible for overall coordination, status, reporting (MS Project / Clarity), and stability of project oriented work efforts within

assigned projects to ensure that all assigned projects and milestones are delivered on time, on scope, and on budget.

• Established and implemented project management functions for scope management, issue/risk management, work plan

management, quality management, deliverable management, and resource management.

• Validated technical designs created by IT developers against functional specifications.

• Worked with QA team to design test plan and test cases for User Acceptance

• Tracked software customization, defects and issues via the use of SDLC

• Ensured that all artifacts complied with corporate SDLC Policies and guidelines.

• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.

• Managed DirecTV enterprise television programming offers within the PMO environment.

• Responsible for overall coordination, status, reporting (MS Project / Clarity), and stability of project oriented work efforts within

assigned project to ensure that assigned project and milestones are delivered on time, on scope, and on budget.

Environment: Java, Oracle UCM, Akamai (Web Application Accelerator) and Asset Management (by Tivoli).

Project Manager/ Business Intelligence Group

• Managed and successfully implemented OMS Real-Time Goldengate replication solution within the Business Intelligence organization.

• Managed a team of DBAs, report analysts to coordinate and implement various data warehouse application rollouts that include

setting up new data subject areas and schemas, validate functionality of software applications, conducting user acceptance testing,

diagnosing and resolving performance issues.

• Managed deliverable review and approval process, making certain that all deliverables aligned with standards and receive

proper tracking and timely sign-off.

• Responsible for the implementation processes from requirements analysis, system design and implementation of new subject

areas in the Enterprise data warehouse.

• Built logical data model, physical database design, data sourcing and data transformation, data loading of the company’s

churn data model. Designed and developed the enterprise data warehouse data dictionary. Responsible for the implementation

of standards for data names and definitions as well as class names.

• Managed successfully the enterprise survey project in which was implemented using SDLC methodology. I had the

responsibility of managing five team members of various backgrounds and skills for this project whose tasks included

database design, programming and report development.

LIMITEDBRANDSColumbus, OH March 1998 – September 2005

Data Modeler/Project Manager

• Managed successfully the corporate data governance initiatives which lead to the adoption of enterprise wide

data standards and policies.

• Implemented and oversaw reusable Enterprise design patterns project for the Limited Brands Store-wide Metadata repository

and the SAP BW applications.

• Consulted on projects as a software architect/project manager, across multiple business areas including Finance, HR, and

Procurement. Responsibilities include the definition of high-level architecture, technology, configuration and capacity

requirements to support any proposed data warehouse/data mart activity.

• Managed the development of Limited Brands enterprise data warehouse which included subject area model development,

business analysis, architecture design, and staging area design for integrating disparate corporate data, data acquisition and

process design.

• Responsible for integrating master data requirements across multiple projects, and building an external data model using ERWin.

Analysis of data requirements and translation of these requirements into dimensional data models using Oracle. Developed

modeling and naming standards; wrote modeling guidelines; developed power-user training materials for our business

partners. Ability to conceptualize, sell and implement mission critical solutions to IT management.

• Developed packages, functions, procedures, stored procedures, triggers, tables, table spaces; indexes customized views using

Oracle PL/SQL.

COMPUWARE CORPORATION Columbus, OH June 1996 –

March 1998

Consultant

• Project management overseeing the development and installation of new mission-critical systems and enhancing existing ones to

increase efficiency for clients.

• Managed vendor engagement services and solution implementations.

• Developed enhancements to a client’s Human Resources system. Created customized tools to interface with the enterprise server

back-end systems.

• Designed and developed a dealership bonus receipt issuing and tracking system for a luxury carmaker.

• Designed, built and tested programs to transfer data from the mainframe to client machines.

COLUMBIAGAS Columbus, OH January 1995 - June 1996

Software Developer

• Designed and delivered technical modules to internal development groups.

• Performed layout development, database design, technical writing and testing for the Tennessee and Kentucky new customer

ordering system.

Technical Skills

Clarity, MS Project, Project Budgeting, Project Planning: Waterfall & Agile (Scrum) methodologies, Custom Systems

Development & Implementation SDLC, Enterprise-wide Implementations. System Migrations/Integrations, Teradata, Oracle 11g,

SQL Server, DB2, MySQL, Oracle Reports, Oracle Enterprise Manager, SQL*Plus, Oracle Warehouse Builder, UML, ERWin,

Micro Strategy, Essential Data-Stage, Cognos, SharePoint, Microsoft Dynamics CRM, SAP/BW, VB .NET, SQL, PL/SQL,HTML5 CSS,

JA A, JavaScript, Photoshop, Maya 2012 Python, Angular JS, JSON,XML, C#, JIRA, Python, Visual SourceSafe, Visual Studio, TOAD,

V

CVS, Eclipse, Simply Objects, MS Office Suite UNIX, Linux, Windows, Data Warehouse, Data Migration

Experience in leading large teams across broad technical, financial and business disciplines. Focused teams on business

objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.

Education

UNIVERSITY OF SALFORD

B.S.C Honours, Information Technology Information Technology Manchester, Greater Manchester United Kingdom

Contact this candidate