SUMMARY:

• To leverage my extensive business intelligence, CRM, MDM, Data Governance analysis, design, architecture, and industries experience into one of the following roles:
• Data Governance Enterprise Architect/ Functional Lead
• Master Data Management Enterprise Architect/ Functional Lead
• Informatica MDM Architect
• Experience envisioning and proposing solutions to the executive sponsors, architects, and stakeholders.
• Extensive experience working with stakeholders to define the project scope, success factors, constraints, business process analysis, logical models, and flow diagrams.
• Fluent in drafting diagrams representing the complexity of the requirements and to define the boundaries for the system: the rationale, the activity flow, for the data flow, and interface analysis.
• Expertise in facilitating Workshops, Agile methodology, Creation of Test Cases, Test Plans, and leading User Acceptance Testing.
• Competent in defining the functional requirements to provide the details required to implement the solution in order to satisfy the business requirements and goals.
• Expertise in business process improvement and organizational transformation: Definition of the effects on the business system, the employees, the information technology systems supporting the process. Plus identifying the KPI's of the measurements to assess the effectiveness, efficiency, and alignment to the process; and reward and recognition programs.
• Fluent in using UML to satisfy the Rational Process as well as the Oracle Unified Method to iterate through inception, elaboration, and the construction phases of the implementation in order to identify the objectives, document and map the requirements, configure the software, integrate, test, and obtain the client sign - off.
• Functional lead experience, Onsite-offshore experience.
• Extensive experience in formulating and conducting training.
• Expertise in transforming data into actionable information: Proficiency in SQL queries, drafting dataflows diagrams, creation of entity-relationship diagrams, and writing statistical functions summarizing findings in Excel. The Implementation, management, and delivery of data governance program as a quality control discipline for accessing, managing, monitoring, maintaining, and protecting organizational information.
• Experience in analyzing and designing Master Data Management solutions: Analyzing disparate source systems, identifying and discarding redundant data, cleansing the data, and rationalizing and aggregating it together using hub-and-spokes architecture.
• The establishement of data governance policies for: Data usage, common definitions, data standards, data quality expectations, The identification of a governing body with roles and responsibilities, structure of committees, frequency of meetings, rules, The definition of Constraints or Risks, roadblocks, challenges, and boundaries.
• The Implementation, management, and delivery of data governance program as a quality control discipline for accessing, managing, monitoring, maintaining, and protecting organizational information.
• Experience in analyzing and designing Master Data Management solutions: Analyzing disparate source systems, identifying and discarding redundant data, cleansing the data, and rationalizing and aggregating it together using hub-and-spokes architecture.
• Programing experience in SQL, PL /SQL, MySQL, MS Access
• Expertise in data management: data governance, data stewardship, data analysis, data modeling, RDBMS, data access, data quality, data cleansing, and master data management (transactional, analytical).
• Best practice data modeling: Kimball Methodology.
• Data modelling tools: Erwin r8, Rational Rose, Visio.
• Creation of Data Dictionary, Data Model, Data Flow Diagram, Source-to-Target
• Oracle Business Intelligence - OBIEE: Answers, RPD, Administration Tool, WebLogic, Fusion Middleware, BI Publisher.
• Functional BI experience for PowerBI, SSRS, Cognos, Business Objects.
• HTML, CSS, XML, JavaScript, JQuery.

EMPLOYMENT:

MDM Data Governance Enterprise Architect

Confidential

Responsibilities:

• Worked as a functional lead implementing the Informatica metadata suite (Metadata Manager, Analyst, and Master Data Manager).
• Worked with business users in Montreal, Toronto and New Jersey to accommodate the compliance with the US and Canadian Regulators for controls and risks.
• Translated the business requirements into functional and technical specifications for deploying enterprise level Business Glossaries, controls, and lineage solutions.
• Lead offshore team to a successful deployment.
• Reported the project status to the upper management.
• Employed Agile methodology to gather the data modeling requirements. Built conceptual and logical MDM data model.
• Created enterprise glossary and lineage to ensure compliance with: SOX, GLBA, Basel, FFIEC, and the Patriot Act.
• Created Business process analysis, business process re-engineering, Incremental business process changes by release, Incremental benefits by business function and line of business, Systems Decommissioning Strategy, Data Security and Visibility Requirements
• Assessed the root cause analysis and data quality which brought about improved strategic decisions and the reductions of information waste and inefficiencies.
• Participated in a proof of concept to migrate the environment to the Ab Initio tools.

MDM, Data Governance Enterprise Architect

Confidential

Responsibilities:

• Presented several solution designs: Leveraging the use of the Oracle Master Data Management/ Siebel Oracle UCM: universal customer master, data governance, ETL, and data warehousing.
• Sold the vision to the executive sponsor and to the architecture team.
• Interfaced with business representatives and leaders to identify the new data requirements, analysis strategies and reporting mechanisms.
• Identified process improvement methodologies to achieve targeted future states.
• Worked with the program manager to help meet the project milestones for the Siebel CRM, Siebel UCM and reporting efforts to make tradeoffs on scope, time and cost and to balance the immediate delivery needs with the longer term strategic objective.
• Performed data analysis using SQL and Excel: collected data from disparate systems, assessed the data quality (conformed, valid, complete, accurate, consistent, unique, available, timely, current), prepared data-cleansing specifications, worked with data owners to improve the processes, and leveraged ETL as an intermediary step in the data cleansing plan.
• Drafted dataflows diagrams, enterprise information model, created entity-relationship diagrams.
• Ensured that the system improvements are successfully implemented. Monitored the KPIs increase in efficiency to bring about organizational transformation.
• Analyzed and designed Master Data Management solutions: Analyzed disparate source systems, identified and discarded redundant data, cleansed the data, rationalized and aggregated using hub-and-spokes architecture.
• Built conceptual and logical MDM data model.
• Ensured that the right information is available in the right place, in the right way, at the right time, for the right reason.
• Drove the value objectives of objectives of enhancing Analytics and Insights, Operational Excellence, Compliance & Reporting.
• Leveraged JIRA to create user stories and test process.

CRM & BI Functional Lead

Confidential

Responsibilities:

• Worked extensively with the business managers to identify the requirements and the solution blueprint for the SalesForce CRM application.
• Identified and baselined current state and target performance metrics for future state. Highlighted the business value associated with proposed process improvements.
• Defined the application’s functional requirements, user interface specifications, application process flow, use cases, and test cases.
• Performed gap analysis and translated the business requirements and high-level design into application functional requirements and detailed design documents.
• Coordinated and managed project activities.
• Created source to target mappings for the data from sources to MDM and onto the data warehouse.
• Established data governance policies to create a holistic view of the mastered entities that initially included multiple views approved by data owners.
• Worked on tuning the business processes to create and make available an accurate, timely, and integrated view of a customer across the various lines of business, channels, and business partners.
• Exposed the OBIEE data inside the various Google maps overlays: Markers for store level reporting, Polygons for the counties/ cities reporting, and heatmaps for a high level overview of the KPI performance. This provided a very intuitive and dynamic look for the stores performances at the various levels of geographic grains.
• Written extensive JavaScript and created customs HTML and CSS codes that displayed the KPI performances at the various geographic zooming levels for a very rich dashboard looks.
• Lead collaborative sessions with the sales and marketing executives. Built performance enhanced reports and dashboards.
• Leveraged the Oracle Unified Method (OUM) to ensure that the stakeholders developed a shared understanding of what is needed, while selecting an appropriate architecture, and transferring the ownership of the end-product to the stakeholders.

OBIEE Functional Lead

Confidential

Responsibilities:

• Built performance tuned reports and dashboards. Written extensive SQL to analyze and summarize the data.
• Gathered the requirements from subject matter expert in retail and finance.
• Conducted a data stewardship exercise to identify the conforming dimensions at the appropriate grains.
• Created a BI work breakdown structure for the purpose of selling the initiative.
• Encapsulated the business logic in Answers and in the RPD.
• Configured object level and row level security.
• Created comprehensive design documents and conduced knowledge transfer to legacy developers.

Functional Lead

Confidential, Chicago

Responsibilities:

• The project consisted of tracking the supply chain of the meters for the Freestyle family of products distribution and of upgrading the Oracle Siebel CRM and OBIEE applications.
• Lead requirements gathering sessions and drafted the business, functional, and technical design documents for the medical and biomedical samples delivered to the hospitals.
• Created use cases and business processes.
• Developed application screen mock-ups and screen flows; translating screen design and Workflows into Wireframes and prototype.
• Developed and documented process workflows diagram refinement and workflow narrations.
• Developed the Siebel business design documentation. Developed and documented use cases, identifying and documenting Business rules. Developed a traceability functional matrix.
• Coordinated the project activities.
• Initiated data quality discussions with the IT managers and the data owners. Obtained business users sign off.
• Lead a team of developers and QA to ensure that the validation and verification of the product built.
• Created the logical data model to accommodate the delivery for the new reports.
• Defined the security model. Created users and developers training.
• Create training documents for business users Conducted End User training.

Senior BI Consultant

Confidential

Responsibilities:

• Coordinated the build of highly customized reports and dashboards in finance, accounting, human resources, collections, planning, and operations in business analytics.
• Lead requirements gathering sessions and drafted the business, functional and technical design documents, employed agile analysis, deployment, and release methodology.
• Initiated data quality discussions with the IT managers and the data owners. Obtained business users sign off.
• Built financial reports and dashboards from the Oracle Financials AR, AP, GL and CE.
• Encapsulated the business logic as SQL/PL SQL in Answers, the RPD business layer, and as DB functions.
• Extended the data model to accommodate the delivery for the new reports.
• Drafted documents and conduced knowledge transfer for: performance tuning strategy and for best practice BI reports and dashboards designs.
• Defined the security model. Created users and developers training.
• Defined a detailed testing process and strategy.

OBIEE Functional Lead

Confidential

Responsibilities:

• The project consisted of analyzing, designing, and building the reporting requirement for the Desjardin insurance and credit union operations. Participated in the project from conception to build.
• Lead workshop events, and joint application design workshops. Collected, clarified and translated business requirements into documentation and conceptual designs. The main source systems were CRM and SAS. Employed Scrum agile method in analysis, design.
• Coordinated with project team to ensure final deliverables meet customer requirements.
• Participated as a member of the enterprise business architecture group. Conducted process modeling as predicated by the business process realignment.
• Built reports and dashboards, and proof of concepts. Leveraged Scrum agile methodology.
• Created a Siebel Analytics/ OBIEE development training for multiple legacy development teams and subject matter experts. Conducted the training in English and French.
• Worked extensively on Defining application functional requirements, use cases, test cases, application usability requirements, user interface specifications and application process flow re-design.
• Performed gap analysis and translated business requirements and high level design into application functional requirements and detailed design documents.
• Troubleshooted Oracle BI Publisher/ BIP reports.
• Created a guide to optimize the reports queries and suggested database optimization (indexing, aggregations). Configured the usage tracking and the iDeliver to obtain performance measures.

BI & Siebel CRM Functional Lead

Confidential, Chicago, IL

Responsibilities:

• Worked on two OBIEE proof-of-concept initiatives. The source systems included Oracle Siebel CRM and Oracle Financials.
• Conducted Siebel joint application design sessions and product demonstrations to the business users.
• Effectively maintained partnerships with all company IS teams and vendors to ensure constant compatibility between Siebel application and inter-related systems.
• Performed UAT testing of both existing and newly developed functionalities to ensure performance; informed vendors of progress or issues.
• Created ad hoc reports using multiple systems including SQL, Access and Oracle Business Intelligence/ Siebel Analytics
• Analyzed requirements, Process Flows, and field Mappings for assigned projects.
• Provided technical expertise in identifying, evaluating and developing conceptual designs that are cost effective and that met the users’ analytics needs.
• Translated the business requirements into a detailed design document. Designed the security model. Obtained the clients sign off.
• Conducted demonstrations. Lead joint application design workshops.
• Built reports and dashboards using the OBIEE Administration Tool and the Presentation Services, Conducted knowledge transfer.
• Established best practices for the design and development of the BI Application.

BI Functional Lead

Confidential

Responsibilities:

• The project consisted of identifying and migrating the insurance reporting needs for the Confidential executives’ team.
• Developed a complete solution and detailed BI requirements and designs for Business Objects.
• Gathered the program requirements through meeting with the business executives.
• Participated in PMO and in steering committee meetings. Recommended solutions and strategies.
• Conducted a business-focused data analysis, data governance, data quality assessment.
• Utilized Visio to model business processes. Developed use case scenarios and re-designs.
• Implemented a data stewardship program. Defined common business terms across the various business processes to ensure a coherent view of data. Defined the conforming dimensions.
• Determined how the data will be sourced to the data model; created a process flow diagram detailing the various sources, processes and targets that are involved in the ETL. Leveraged the ETL for data cleansing.
• Suggested extension to the Guidewire claim centre logical data model while adapting best practice from the IBM Insurance Application Architecture.
• Lead the end to end testing activities. Created a data warehouse test plan. Liaised with the onsite and off-shore developers, and managed the user acceptance testing.
• Reverse engineered Excel VBA to extract and modify the business logic.

Business Consultant

Confidential, Coulter Brea, CA

Responsibilities:

• Analyzed the customer's objectives, needs, and constraint. Recommended solutions for the client’s finance, risk management and supply chain management Analytics. The source systems included Oracle Siebel CRM On Demand, Oracle Policy Automation (OPA), and Oracle Financials.
• Lead workshop events, and joint application design workshops. Collected, clarified and translated business requirements into documentation and conceptual designs. Built prototypes and proof of concepts. Guided the subject matter experts in the optimised build of the solution.
• Created a process flow diagram detailing the various sources, processes and targets. Summarized the aggregation of detailed transaction data.
• Provided functional and technical expertise on migrating legacy reports. Created functional design documents.

Functional Lead

Confidential, Los Angeles, CA

Responsibilities:

• The project consisted of upgrading the Cognos P&C data warehouse in addition to building an Oracle Siebel Analytics/ OBIEE Claims compensation data warehouse.
• Lead the requirement gathering. Drafted the functional design document. Defined the security model.
• Performed gap analysis and translated business requirements and high level design into application functional requirements and detailed design documents.
• Created Use Case documents and UML diagrams using Microsoft Visio tool.
• Create training documents for business users Conducted End User training.
• Participated in the Oracle Siebel CRM P&C data mapping into OBIEE.
• Assisted in business risk assessment and mitigation activities
• Analyzed and combined customer data across business processes. Conducted business data domain and business data integrity rules conformity on the data sources. Initiated data quality discussions with the IT managers and the data owners. Conducted data stewardship.
• Analyzed the source data and designed a master suite of standardized dimensions with uniform interpretation across the enterprise. Created an enterprise data warehouse bus matrix representing the organization’s key business processes. This allowed the separate data modelers to work asynchronously.
• Determined how the data will be sourced to this data model; created a process flow diagram to detail the various sources, targets, and processes re-engineering. .
• Created Oracle Presentation Services training. Drafted a migration plan document. Conducted a sizing estimation.
• Created a report development work breakdown structure with deliverables matrix while employing agile method. Reported the team development status to management.

Senior Siebel CRM & Analytics Business Systems Analyst

Confidential, Seattle, WA

Responsibilities:

• Lead the discovery for Confidential ’s marketing and loyalty initiatives.
• Created a Loyalty Grid incentive structure through brain storming with executives and stakeholders.
• Lead JAD sessions, defined the business processes, and drafted the business requirements document.
• Created functional and technical designs. Resolved technical issues and harmonized the functionality of using a common object manager of Oracle Siebel CRM Loyalty and Oracle Siebel CRM Marketing.
• Leveraged the segmentation features of the Siebel Marketing Analytics (OBIEE) and analyzed the information collected throughout the life cycle of the marketing initiative to enhance the business key performance indicators.
• Designed integrated multi-channel and multi-stage marketing campaigns. And, used a closed loop to transfer service, and marketing data into sales growth.
• Authored process flow diagram, dimensional modeling, and created mapping to source the data from disparate legacy systems.
• Effectively maintained partnerships with all company IS teams and vendors to ensure constant compatibility between Siebel application and inter-related systems
• Performed UAT testing of both existing and newly developed functionalities to ensure performance; informed vendors of progress or issues
• Created ad hoc reports using multiple systems including SQL, Access and Oracle Business Intelligence/ Siebel Analytics

CRM & Analytics BA

Confidential, Hayward, CA

Responsibilities:

• Lead the discovery for the service operation’s data mart. The source systems included Oracle Siebel CRM.
• Analyzed the Siebel Quotes, Orders, Service, and other interfacing systems' process flows.
• Lead collaborative requirements sessions. Drafted a business requirements document (BRD), identifying the objectives and scope of the data mart initiative, the data requirements.
• Conducted data quality assessment (conformity to data domain and data integrity rules).
• Developed a Data Model at the appropriate granularity level. Designed new stars per the business key performance indicators with conforming dimensions allowing for future expansion to the data mart. Determined how the data will be sourced.
• Drafted a process flow diagram to detail the various sources, processes and targets for the ETL extraction. Summarized the transformation of keys, aggregations, and data transformations in the source to target mapping document.
• Authored test plan, test cases. Lead the user acceptance testing.

Business Systems Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Conducted the requirement gathering and analysis for the electronic measurement group’s marketing analytics requirements.
• Created the gap analysis for migrating the legacy marketing, reporting, and interaction management applications (Epiphany, ERP, and custom) into a Siebel OLTP/ OLAP solution.
• Lead workshop events, and user requirements sessions and created prototype presentations.
• Authored process flow diagram, Dimensional Modeling/ Fact-Qualifier Matrix, and a high level data warehouse design.
• Funneled the information to the development team overseas.