Data Project Manager

Miranda D. Cooper

**** *. ********** ***. ******* Number: 951-***-**** - Cell Los Angeles, Ca. 90008 Email: acr8dy@r.postjobfree.com

Summary: Miranda has over 15 years of hands-on experience in the IT and business

world. She is highly knowledgeable, professional, self motivated, and a

leader. Strong background in Project Management, Business Analysis,

Risk & Compliance, and Data Modeling. She is committed to learning new

technologies and enhancing her skills.

Education: DeVry Institute of Technology

Bachelor of Science in Computer Information Systems

Magna Cum Laude (June 1995)

Relevant Skills:

Languages SQL Server 2000/2008, PL SQL, MS Dos, MicroFocus, SAP, DDL

Software FileWatcher, MSPowerPoint, MS Word, MS Excel 2003/2007, LiveMeeting, Visual Basic,

Access, Visio, Canvis, MS Project, Prism, Brio, Informatica, Quality Center, & SnagIt-10.

Data Modeling Tools Erwin Logic Works, Embarcadero, Case Wise, Brief Case, and Sybase Power

Designer Hardware Windows XP, Windows 2000, 98 & 95, Windows NT, HPLaser Printer, HP DeskJet,

&Email Appl. HP Plotter, HP 3000, HP9000, Unix, CCMail, Lotus Notes, MS Outlook, Exchange, & IM.

Databases Microsoft SQL Server 2000/2008, Oracle, DB2, AS400CF/AS400LS, and Teradata

Professional Experience:

July 2015 to The Judge Group / SCE Southern California Edison

Oct. 2015 Title: Project Manager – Risk and Compliance Specialist

Responsible the creation of the project plan, setting milestones, schedule, tasks and deliverables

using Microsoft Project application.

Key liaison between the business and the IT technical teams to gather requirements.

Conducted working sessions with the business stakeholders to review BRD’s and FRD’s.

Created test scenarios, test conditions, and test scripts.

Tested the SCE digital wire frame demo (home web Page) application to ensure accuracy using

devices such as (web, tablet, and mobile).

Ensured new SCE digital wire frame demo (home web Page) application was in compliance with

Enterprised standards at SCE.

Compared the digital wires application documentation to the test scripts.

Meet with and interacted will all levels of SCE stakeholders.

Provided weekly 4-blocker status report to upper management using Microsoft PowerPoint application.

Mapped the test conditions/scenarios to the functional design specification.

Developed Process Flow diagrams to illustrate new and existing business processes.

Reviewed enterprise risk & compliance standards, resolved issues, created plans and

recommendations to bring risk into compliance.

Create and complete questionnaire checklist addressing risk and gaps in the various groups pertaining to enterprise compliance guidelines.

Perform audits to evaluate and survey each group to ensure compliance guidelines are adhered.

Ensured Third-Party vendors send data files via encryption according to compliance guidelines.

Miranda’s Professional Experience: Continued page 2

May 2014 to Calance / Toyota Financial Services

Jan. 2015 Title: Risk and Compliance Data Analyst/ Project Manager

Managed and trained new on-boarding data analyst and impacted systems SME’s on how to complete the data dictionary template based on compliance standards.

Serve as the subject matter expert for risk and compliance related policies, standards, and regulatory

requirements that were set in place.

Conduct risk and compliance assessments that analyzed both security controls and technical

vulnerabilities. Advise departments on security regulatory requirements, established best security policies, and best practices with SME.

Produced weekly reports, logged, and tracked issues utilizing the IBM (WIRID) tracking application.

Utilized IBM (Doors) application to store D3’s (Data Dictionary Documents).

Analyze and performed Data Profiling activities to view the abnormalities of the data. (Ex. duplicates, similarities of the data, etc.) and viewed in the Trillium profiling application.

Established and created end-to-end process flow diagrams for the Core Project data team.

Conducted and developed risk and business compliance rules and naming standards for project.

Reviewed enterprise risk & compliance standards, resolved issues, created plans and

recommendations to bring risk into compliance.

Create and complete questionnaire checklist addressing risk and gaps in the various groups pertaining to enterprise compliance guidelines.

Perform audits to evaluate and survey each group to ensure compliance guidelines are adhered.

Ensured Third-Party vendors send data files via encryption according to compliance guidelines.

Heavy involvement with scheduling and planning with various groups within the TFS organization such as downstream teams, business, tax, compliance, impacted systems, vice presidents, etc.

Used Toad application as an editor to perform queries in Oracle 11(i).(Create tables, updates, etc.).

Apr. 2013 to Genuent / Farmers Insurance Company

Dec. 2013 Title: Project Manager (BI) Business Consultant

Managed on-shore and off-shore BI (Business Intelligence) Business Objects teams and projects.

Produced database usage reports and Webi reports for top level executives showing the usage by users on different platforms with different lines of business.

Created and produced scorecards for the directors showing the SLA, number of tickets opened and resolved for different line of business.

Created BRD (Business Requirements Document) for Competitor Data in BI Project.

Created DRD (Data Requirements Document) for the Competitor Data in BI Project.

Executed and ran the monthly-end activity reports using Business Objects (3.1/4.0) for various lines of business.

Responsible for developing compliance guidelines to improve existing and new processes and procedures.

Heavy interaction with the business finance organization and other key stakeholders from other organizations.

Responsible for developing POC (Proof of Concept) on new designs and upgraded products.

Responsible for scheduling the development to production migrations new releases, researching, validating, and troubleshooting issues.

Ensured the BI organization was in compliance with the Enterprise guidelines, policies, procedures in regards to standards and new upgraded software.

Involved in the planning, budgeting, and managing resources for current and upcoming projects.

Miranda’s Professional Experience: Continued page 3

Bank of America / Countrywide Home Loans

Nov. 2004 to Title: VP. Sr. Cnslt. – Business Technology Integration

June 2012

Performed various audits with key business and technology teams, and ensured enterprise compliance policies and standards were upheld.

Provided clear solutions to the line of business and technology teams to become in compliance with the policy and procedures.

Documented the results of the audits and reviewed with the business or technology teams.

Managed and played major key lead role in the BAC transitioning project from analyzing and translating BAC data to the Countrywide systems data.

Trained and managed contractors and employees on the BAC Transition project.

Managed and conducted daily mapping JAD sessions with SME’sboth BAC & Countrywide to define KBE’s and KPI’s with line of business.

Managed, maintained, mapped, and translated BAC data elements to equivalent Countrywide data elements in LPS, ACAPS, and AS400CF systems.

Tested the SQL script and logged test results information into the Quality Center (QC) application

Created Test Scripts, Test Plans, and Data Provisioning Testing based on SQL code.

Performed major role and key point person between the (W) Data Warehouse team, and the Hub team on the BAC transition project.

Responsible for ensuring project deadlines and schedules were on course.

Created conceptual, logical, and physical data models using Erwin, Embarcadero & SQL Server Diagrams.

Performed forward and reverse engineering using Erwin & Embarcadero.

Responsible for creating the BRD, (Business Requirements Document), LLD and HLD.

Performed basic query SQL select statements in SQL Server 2008 editor.

Feb. 2001 to Washington Mutual

Jan. 200 Title: Database Architect / Sr. Technical Specialist Manager

Conducted and managed team’s reviews and meetings.

Responsible for project estimated budget cost.

Responsible for ensuring project deadlines and schedules were on course.

Trained other data architects using case tool Erwin.

Conducted employee performance reviews.

Directed data architects on resolving technical issues.

Interviewed and gathered business requirements.

Created conceptual, logical, and physical data models.

Analyzed system data in various departments.

Created custom reports using Erwin.

Translated DB2 domains to Oracle domains.

Reversed engineered using Erwin.

Forward engineered using Erwin.

Created DDL for the DBA to establish database tables.

Created data dictionary.

Defined entities and attributes in Erwin case tool.

Miranda’s Professional Experience: Continued page 4

May 2000 to PA Consulting – Universal Studios

Dec. 2000 Title: Data Architect

Created logical and physical data models using Casewise and Erwin.

Created and deleted tables using Oracle SQL Plus Worksheet.

Exported and imported data from the production environment to the UAT environment.

Executed the SQL script and deleted the data from the existing tables.

Responsible for the entity and attribute definitions.

Reverse and forward engineered using Erwin 3.5.2

Created data dictionary and defined entities and attributes.

Jan. 2000 to Darwin Partners - Sprint PCS Contractor

Apr. 2000 Title: Data Architect

Performed reverse engineering using Erwin and Sybase Power Designer.

Created logical and physical data models.

Created conceptual data models.

Responsible for mapping and analysis of the Oracle database naming structures.

Responsible for entity and attribute definitions.

Created project schedule using MS Project.

Created and coded the alter statement table scripts.

Jun. 1999 to Modis – NCR Contractor

Dec. 1999 Title: Data Model Engineer

Created 3NF logical and physical data models using Erwin.

Created conceptual data models.

Performed reverse and forward engineering using Platinum Erwin 3.5.2.

Responsible for data requirements and business rules.

Maintained and created reference guide and naming standards documentation.

Created subject area views in the data models.

Responsible for entity and attribute definitions.

Responsible for project schedule, deliverables, and deadlines.

Generated data dictionary and various reports using Erwin.

Oct. 1997 to Experian

Apr. 1999 Title: Database Architect

Performed as the acting manager, managed a team of 5 database architects: successfully maintained the project schedule and tasks.

Performed and led the development/maintenance of the logical and physical data models for the systems utilizing Erwin 3.5.2.

Created the data model to support the DRD documentation.

Created and published corporate data administration naming standards and reports.

Performed reverse engineering to existing systems to produce DDL or SQL script, analyzing data flow, normalizing to 3 NF, and forward engineering.

Installed, created, and maintained physical database tables.

Maintained and created data model entity relationship diagrams (ERDs) and data dictionaries.

(References Are Available Upon Request)

Contact this candidate