Manager Project

+

Ruth Clinton

Professional Summary

Senior Information Technology Program Manager with an emphasis on Data Visualization, Big Data and Advanced Analytics assisting organizations in building a roadmap for the next generation of BI capabilities. Strong experience in communicating statistical results and key findings (such as trends, outliers in data) through data visualization tools (such as dashboards, Qlikview, Tableau). Proven leadership abilities scoping, estimating and driving Business Intelligence projects to successful delivery in dynamic fast paced environments. Responsible for building and maintaining relationships with Sr. management providing strategic vision and management of customer’s Business Intelligence, Master Data Management, Data Visualization, Big Data, Reporting and Analytic initiatives. Extensive knowledge of Agile/Scrum, CMMI, Hyperion and Six Sigma Methodologies. Presented on Big Data and Hadoop at several technology meetings and conferences.

Dashboards and Data Visualization

Change and Release Management

Accenture Development Methodology (ADM)

Agile/Scrum Methodologies

Master Data Management

Enterprise Risk Management

Regulatory and Compliance Reporting (Dodd Frank, SOX, CCAR, Basel)

Offshore / Onshore Resource Mgmt

PMP Certification in progress

Education

Tuskegee University, Tuskegee, AL - Bachelor of Science in Computer Science (1981) GPA: 3.5

Honors and Activities: Served as Vice President of Delta Sigma Theta.

Technical & Business Skills

Applications

CA Clarity

SAP ECC/DEC/BW

PeopleSoft

Planview

JIRA

Microsoft Project 2010

HPQC

Qlikview/Tableau

Cransoft/BackOffice

Operating Systems & Networking Technologies

Oracle 9i, 10g 11i

Linux

Java J2EE/JDBC

SQL Server 2012

Sun Solaris

TeraData

IBM AIX 5.x

DB2/UDB v7/8

Windows .NET

Database, Data Warehouse, BI & OLAP Technologies

Business Objects

Crystal Enterprise XI

Hyperion System 9 BI+

Trillium Data Quality

Cognos ReportNet

Cognos Framework Mgr

Ascential DataStage

Dataflux

MicroStrategy

Hyperion Essbase

Netezza

Cognos 8 BI Suite

Informatica IDQ

SAP BW

Microsoft SQL Server 2012

Informatica PowerCenter 8 and PowerAnalyzer

Business Objects Data Integrator

MS SSIS, SSRS, Analysis Server

SAP Data Services (BODS)

Apache Hadoop

Pivotal

Professional Highlights

BNP Paribas – Jersey City, NJ Feb ’16 – Apr 2016

Independent Consultant - Sr. IT Project Manager – Technology Solutions (TS)

Managed the project team of client and third party resources using Agile that provided data governance processes and procedures for BNP’s IHC (International Holding Company) CCAR submission of their FRY-9C and FRY-14 reports.

Created test cases for the data quality metrics and dashboards gathered with workstream leads and SMEs.

Created product backlog and product roadmap with product owner in addition to release and sprint planning.

Applied empirical approach to reportomg project status and financials to project sponsors and management team on a weekly basis.

Ensured thorough, timely, and consistent communication within the project team.

Identified and reported risks throughout the life of the project and provided options to the business for mitigation strategies.

Ensured effective communication and collaboration between business functions.

Demonstrated a commitment to continued self-improvement in order to learn and stay current with data governance management methodologies, regulatory reporting processes, and related technologies.

Citizens Bank – Medford, MA May ’15 – Jan 2016

Independent Consultant - Sr. IT Program Manager – Technology Solutions (TS)

As a member of Citizen’s Enterprise PMO; responsible for the successful delivery of multiple work streams using Agile and SDLC methodologies delivering an Enterprise data warehouse for BI reporting and analytics fir Risk Data Platform.

Worked with internal IT partners and business to ensure that project requirements are identified including to-be process and gap analysis, specification and solution design documentation.

Lead risk initiatives to identify, measure, monitor, and close out risks in regards to technology services.

Managing communications, estimating/budgeting, resource management, status reporting, requirements management and issue and risk identification and resolution.

Directed all aspects of the project from initiation through application and support, including resource management and financial budget and forecasting

Acted as the project delivery manager, leading BAs and developers on Hyperion HFM implementation project

Ensure effective team identification of and act as escalation point for project risks, issues, assumptions and dependencies within the portfolio, working with the team to devise and implement effective mitigation strategies taking appropriate action to achieve resolution to the satisfaction of business sponsors.

Provide leadership and strategic direction to the project team (including matrixed project resources), providing coaching, training, development and feedback to other managers as needed

Manage initiatives to adapt the risk infrastructure and information map to market trends, regulatory changes, and strategic plans.

Platforms: Teradata, DataStage, HPQC, Tableau Planview, HP ALM, OBIEE, MS Project 2010, Agile. Project budget 2.5M+

American International Group (AIG) – New York, NY Sept ’14 – May ‘15

Independent Consultant - Sr. IT Program Manager – Data Solutions (DS)

As a member of AIG’s PMO; responsible for the successful delivery of multiple data visualization projects using Agile and SDLC methodologies delivering dashboards and analytics for C-level executives across the enterprise.

Worked cross-functionally with comptrollers, operations, financial management and across organizations with end-users and IT to balance product lines and business requirements.

Successfully managed the migration of over 300 Actuaries from PC SAS to the SAS Grid with a demonstrated cost savings to the company of over $600k+.

Dimensional analysis utilizing Hyperion Essbase, Hyperion Performance Scorecard.

Managing multiple projects from inception to deployment; estimation/budgeting, resource management, status reporting, requirements management and issue and risk identification and resolution.

Platforms: MS SQL Server 2012, Teradata, Informatica, HPQC, Qlikview, CA Clarity, JIRA, Business Objects 4.1, Netezza. MS Project 2010, Agile. Project budget 1M+

General Reinsurance (Gen Re) – Stamford, CT Nov ‘13 – July ‘14

Independent Consultant - Sr. IT Program Manager – Information Technology (RAS)

Solely responsible for the successful delivery of multiple projects including the Direct Reinsurance Warehouse (DRW) for the RAS program for Gen Re. This SQL Server based data warehouse will be the future Enterprise Data Warehouse for Gen Re.

Managed a team of 10 – 12 resources including client, third party vendor and offshore resources tracking multiple projects progress to ensure program milestones were completed on time, on budget and with the desired results.

Delivered multiple projects including Infrastructure build out and Master Data Management projects simultaneously.

Monitored stakeholder expectations and carefully monitored the project scope. Implemented change and release management as needed.

Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.

Platforms: SAP ECC. SAP BW, FS-RI, FS-CO, SAP Data Services, MS SQL Server 2012, Linux, Oracle 11i, HPQC, Qlikview, CA Clarity, Business Objects 4.1, MS Project 2010, ASAP. Agile. Project budget 1M+

GE Capital – Norwalk, CT Jan ‘13 – Nov ’13

Independent Consultant - Sr. IT Program Manager – BI - Enterprise Reporting and Analytics

Managed multiple project teams (both onshore and offshore) that delivered IT programs for the Enterprise Data Reporting and Analytics team.

Functions as point of contact for multiple regulatory reporting projects (CCAR, Dodd Frank and Basel) ; provided timeline, milestones and status updates to senior leaders and stakeholders on project financials and defined deliverables

Responsible for driving projects including a Comprehensive Capital Analysis & Review project (CCAR) to deployment managing program scope, work plans and schedules, budgets, communication plans.

Led the ETL development and strategy for all projects with ensuring solution aligned with overall IT strategy.

Identified and managed project interdependencies from other work streams (e.g., data flows, ETL, reporting solutions etc.,)

Platforms: Teradata, Informatica, Hadoop, Java, SQL, Business Objects 4.0, MS SQLServer 2008, SSIS, SSRS, UNIX, Oracle 10g, HPQC, Qlikview, JIRA, CA Clarity, MS Project 2010, Waterfall and Agile. Project budget: 1M+

Bristol Myers-Squibb – Princeton, NJ Aug ‘11 – Jun ‘12

Independent Consultant - Sr. IT Program Manager – BioPharma – Data Reporting / Analytics

Managed teams that delivered multiple projects and technical specifications for the Data Reporting and Analytics – Data Quality Services team focusing on their supply chain Customer and Vendor Master Data.

Responsible for project scope, schedule, budget, and communication plan. Issue and risk management and stakeholder communication.

Provide leadership in defining an enterprise information architecture using data quality tools, SaaS and SOA methodologies.

Collaborate across BioPharma IT to identify and prioritize opportunities to leverage data quality common solutions and extend the adoption of standards helping BMS to better analyze and use their master data.

Platforms: SAP ECC. SAP DEC, Dataflux, Informatica IDQ (Siperian), Cognos, SSIS, SSRS, MS SQLServer 2008, UNIX, Oracle 10g, HPQC, Teradata MS Project, Waterfall and Agile. Project budget: 300k+

Axis Technology, LLC – New York, NY Apr ‘10 – Aug ‘10

Sr. IT Project Manager – Sensitive Data Assessment and Solutions

Served as central point of contact for all project related activities in support of the client.

Managed team resources delegating tasks as necessary and directly reviewing deliverables.

Managed client expectations throughout entire engagement.

Coordinated all client requested changes through a formal change management process.

Platforms: Informatica, SSIS, SSRS, MS SQLServer, UNIX, Oracle 9i, Sybase, Project budget $500k

QBE Insurance – New York, NY Feb ‘10 – Apr ‘10

Sr. IT Program Manager

Managed multiple project teams that delivered the business requirements and technical specifications for the Specialty Data Program. Stakeholders included Claims, Reinsurance, Underwriting and Actuarial.

Determine the gaps in current Specialty Data Program to meet the needs of the business. Formulated a series of projects that led to the End State required by the business units.

Provide overall project communication to stakeholders and program management of stakeholder expectations.

Proactively identified risks, mitigated risks and solved project issues through negotiation and/or escalation processes.

Participated in infrastructure and architecture planning for future state roadmap.

Platforms: Oracle 9i, AIX 5.3, Informatica PowerCenter 8.x, Informatica Data Quality, Cognos 8 BI, MS Sql Server, Agile/Scrum, 300k

Ernst & Young – New York, NY Sep ‘09 – Feb ‘10

Manager – Information Technology & Risk Assurance (ITRA) – Data Analytics

Recognized for exceeding sales target of $500k in the first two months of employment.

Led multiple client engagement teams assisting clients in employing cutting edge Business Intelligence reporting applications. Managed projects, resources, and controls to maximize efficiencies and minimize risk at clients like PNC Bank.

Drove the delivery of several projects that assessed the business processes of a large managed care client’s (BMC Healthnet Plan) current BI/DW capabilities with specific focus on the governance model and management processes, the organizational structure and existing BI (Cognos, Informatica) technology capabilities leveraging the Ernst & Young Decision Support Framework as the basis to assess the current state and gaps within each of the company’s functional areas.

Provided data integration services to E&Y’s client base in support of financial auditors.

Use Analytics to gather and organize information to deliver business insight, improve business performance, and mitigate risks.

Platforms: Oracle 9i, AIX 5.3, Cognos 8 BI, Informatica PowerCenter 8.x, MS SSIS,SSRS, Agile/Scrum methodologies. Project budget: 1M+

Computer Associates – New York, NY Jun ‘09 – Aug ‘09

Independent Consultant - Sr. IT Project Manager

Successfully managed all aspects of Social Media projects from initiation through delivery.

Created and executed project work plans and revised plans as appropriate to meet the ever changing business needs and requirements. Used formal SDLC project methodology.

Provided data integration best practices and technologies understanding and resolving data integration issues.

Focused on the deliverables, milestones, and tasks for multiple projects managing the effective execution of tasks/processes on the project.

Platforms: Oracle 9i, Solaris, Informatica PowerCenter 8.x, .NET, Business Objects Enterprise 6, MS Sql Server, SSIS, SSRS, Web 2.0, InfoGator, SDLC. Project budget: 1M+

Accenture – New York, NY Aug ‘06 – Jan ‘09

Manager – Accenture Information Management Services – Business Intelligence (BI) Program Manager

Successfully delivered and deployed multiple projects as part of the End State of an Enterprise Data Warehouse Reporting Program for a large property and casualty insurance company reducing overtime costs by 10%.

Re-engineered processes reducing time spent performing manual the reconciliation and balancing of financial data

Designed, planned and implemented new infrastructure based on functional and technical requirements.

Implemented the migration of all financial/management and analytical reporting from existing platforms to upgraded BO XI r2, MS SSIS, SSRS, and Hyperion System 9 platforms.

Developed project scope, estimation, WBS. Provided project risk assessment and mitigation, issue management and resolution for multiple projects including development and infrastructure upgrades.

Managed a team that created the Data Quality and Master Data Management strategy that incorporated proven Information Quality and Risk management principles.

Effectively managed project teams for multiple, concurrent projects. Teams consisted of 20 – 25 onshore, offshore, client, Accenture and third party vendor resources.

Consistently recognized for delivering superior client service by reducing the quarterly and monthly close processes by 12% will still producing quality deliverables on time or ahead of schedule.

Mentored junior project team members establishing a highly motivated team that produced high quality deliverables to the client.

Platforms: Oracle 9i, AIX 5.3, Informatica Powercenter 8.x,Metadata Manager, BOXI v2, Cognos 8 BI, MS Sql Server, SSIS, SSRS, Hyperion System 9, PeopleSoft HRMS, Trillium, ADM plus Agile and Scrum. Project budget: 2M+

Business Objects – New York, NY Jan ‘05 – Aug ‘05

Engagement Manager – Professional Services Organization

Managed multiple projects concurrently for Business Objects client base. Teams consisted of 3-7 members successfully driving BO project to their conclusion as well as being the sole point of contact at the client site.

Successful in managing own and other's work efforts and driving projects to conclusion including time management, estimation, completion, issue identification & resolution and status reporting

Provided innovative Data Warehouse Business Intelligence thought leadership to key clients while coordinating project resources and large BO and MS Sql Server implementations.

Designed infrastructure and corresponding architecture for BI implementations. Reported on BO resource availability, utilization and status to project sponsors and stakeholders.

Platforms: Oracle 9i, Solaris, Informatica, Business Objects XI, Crystal Reports, SDLC, Project budget: 1M+

JP Morgan Chase – New York, NY Nov ‘03 – Nov ‘04

Independent Consultant – IT Project Manager – CRB IT

Project managed the building of the Business Intelligence and Reporting Track in support of the redesign of the Incentive Compensation Management System (ICM) more closely aligning program incentives to JPMC’s strategic vision.

Defined overall project management guidelines and procedures in conjunction with JPMC’s PMO using Capability Maturity Model (CMMI) significantly improving software development and PM processes/

Created and managed the project scope, estimation, resources, issues, risk and reporting for project team that used Cognos ReportNet to enable branch personnel to gain access to enhanced performance metrics as part of their incentive compensation.

Provided hands on project leadership of the team that developed a metadata strategy for sharing data across the ICM in accordance with JPMC’s Metadata Management Center of Excellence reducing data redundancy by 20%.

Platforms: Oracle 9i, Solaris, Informatica, Business Objects Enterprise 6, ERWIN, Callidus TruComp/TruResolution, Planview, PeopleSoft v6.0, SDLC, Project budget: 1M+

Kraft Foods – Parsippany, NJ Nov ‘02 – Nov ‘03

Independent Consultant – IT Project Manager – Data and Program Management

Successfully managed and deployed the development of an Enterprise Data Warehouse (EDW) pointing KRAFT toward integrating its independent brands under the umbrella of “One KRAFT” providing a more central, synergistic BI strategy.

Managed multiple projects and teams concurrently as we:

Established a Data Quality, Governance and Delivery strategy incorporating proven Enterprise Information Architecture management principles.

Facilitated the architecture planning and administration of their Cognos BI Suite for reporting and analytics.

Managed project scope, project schedules, budget, issues and risks according to Kraft’s PMO RUP based Project Management methodology, driving the project to a successful conclusion.

Platforms: DB2 UDB v8, AIX, ETI-Extract, Crystal Reports v9, ERWIN, Evoke Axio, Planview, Project budget: 1M+

Early Career History 1981 - 2002

Cendant (Hotels & Hospitality) – Parsippany, NJ Independent Consultant - IT Project Manager – Enterprise Data Warehouse

Managed Cendant project team in the reengineering of the current custom ETL processes for their Customer Loyalty program, which consolidated data from multiple sources, i.e., PeopleSoft, flat files, Excel into the existing Data Warehouse. .Platforms: Oracle 9i, Solaris 8, Informatics Power Mart/Power Center 5, Informatics IADP Customer Relations Analytics, Trillium, Group 1

AT&T – Basking Ridge, NJ - Independent Consultant - IT Project Manager – Human Resource Data Warehouse (2002)

As part of the Project Management Center of Excellence, performed scheduling, reporting, risk analysis, cost management, variance analysis, change management, of complex, data warehouse technical projects. Platforms: Oracle 9i, PeopleSoft HRMS, Solaris 2.7, Business Objects 5.0, Informatica Power Mart/Power Center 5,

Cross Country Bank – Wilmington, DE - Independent Consultant - IT Project Manager – Data Management (2001)

Implemented BI solutions as a part of the Data Management team for a financial institution that provides credit card instruments to its customers.

.Platforms: Oracle 9i, Solaris 2.7, Business Objects 5.0, Informatica Power Mart 5, PeopleSoft, SDLC

Oracle Corporation – Oracle DBA (2000 – 2001)

Participated in the business process re-engineering effort for MARFORRES. Created business process diagrams, logical and physical data models for Marine Corp. Platforms: Oracle 8.x, Solaris 2.6, Oracle Designer 6.0, Oracle Developer, Oracle Workflow, Oracle 9iAS Portal

G.E. Capital, Transport International Pool (1998 – 2000)

Perform common administration tasks in a multi-platform, multi-instance Oracle 7.x/8.x enterprise with over 500 concurrent production users, including performance tuning and troubleshooting. Platforms: Oracle 8.x, PeopleSoft HRMS, Solaris 2.5, Business Objects, Informatica

PEP BOYS Philadelphia, PA Senior Systems Analyst (1994 – 1997)

Created functional specifications, detailed design, SYBASE 4.x database design, logical and physical data modeling using ERWIN, and front-end and back-end code using POWERBUILDER 4.0 and TRANSACT-SQL. Platforms: Sybase 4.x, HPUX

G.E. SOFTWARE CONSULTING, INC. Oracle Developer (1984-1994)

Provided UNIX/C language programming support for a variety of corporate clients, including the AT & T, Merrill Lynch, Time, Inc., Citicorp, and Bell Labs.

TRW, INC. Programmer Analyst (1981 - 1984)

Designed and developed ‘C’ modules and shell scripts for various UNIX applications

Contact this candidate