Customer Service Management

Cindy Van Patten

El Segundo, CA *****

Cell: 310-***-****

E-mail: *********@***.***

OBJECTIVE

Seeking a Lead Business Intelligence Developer or Data Warehouse Developer Position

SUMMARY

I am a result-oriented IT professional with global experience and expertise in IBM Cognos BI 10.2.1. In addition to number of years hands on experience on MS SQL 2012 (SSIS and SSRS), MS SharePoint 2013, IBM I Series, Business Intelligence, process flow and diagram skills. 15 years of ERP development experience, seven or more years’ experiences implementing and supporting Financial and Forecasting applications with multi-organizations and multi-currency enabled. Solid understanding of data warehousing principles such as ETL and data modeling, and web based applications. Have strong customer service, teamwork, critical thinking and problem solving skills. Hard working, self-motivated, consistently pursuing new challenges to stretch abilities expand knowledge and bring greater returns to employers.

TECHNICAL SKILLS

Language: T-SQL, RPG400, HTML, ASP, JSP, MS Office Suite tools (including MS Project, Word, Excel, PowerPoint, Visio), Visual Basic for Application

Database: MS SQL 2012, IBM DB2400, Oracle, Access and Essbase

Specialties/Applications MS Project Management, Cognos BI tools (PowerPlay, Transformer, Framework Manager, Analysis Studio, Query Studio, Report Studio, Active Report, Business Insight, Go Dashboard, Cognos Administration), MS Share Point, Business Intelligence, Data Warehousing, Hyperion Planning and SDL (Idiom) World Server Language Translation Package

Industry (ERP) Expertise: Accounting and Finance, Manufacturing, Retail and Distribution, Purchase order and Requisition, Order Entry, Inventory Management, Cycle Count, Direct Import, Point of Sales, Royalty and Licensing Income reporting, Planning, Waste Package, Marketing and Finance Forecasting with multi-currency

PROFESSIONAL EXPERIENCE

Transamerican Auto Parts, LLC, CA Apr 2010 – Present

Cognos Administrator/MS SQL Database Administrator/BI Analyst

Enhances Cognos reporting capabilities to the point that it’s really giving the business what it needs to grow and make we-educated decisions

Successfully designed and developed the Profit and Loss reporting tool using IBM Cognos 10.2.1.

Work closely with various stakeholders (Retail Stores, Wholesales, and Direct Channel, Accounting and FP&A Finance) in requirement definition, create prototypes, and recommend solutions that meet the needs and implementation phases of reporting projects.

Assist in definition of logical and physical data models

Develop stored procedures in MS SQL 2005/2012 in preparing and cleaning transactional data where needed for Cognos reporting

Converting MS Access/Excel reports to Cognos 10 BI solutions, this includes researching data availability and format, designing reports, programming, and publishing Cognos reports or Power Cubes.

Support annual budget planning process for Finance and all business units

Assist business users with Cognos Ad-Hoc reporting and train management in use of Cognos Cubes

Support monthly Accounting and FPNA groups.

Perform Cognos upgrades, troubleshoot, resolving data and system issues.

Define and structure security layers and views.

Enesco LLC, Itasca, IL. Jun 2009 – Nov 2009

BI Cognos Consultant

Primary function in soliciting and documenting business requirements, prepared scope documents, functional and technical specifications for Cognos reporting.

Successfully designed, developed and implemented a Customer Management Cube for CEO and Senior Management in Trade Marketing Department

Performed data conversion from iSeries to MS SQL 2005

Completely document the existing Data Warehouse infrastructure and provided recommendations for improvement

Department of Water and power, CA Mar 2009 – May 2009

Business System Analyst

Primary function in soliciting and documenting business requirements, prepared scope documents, functional and technical specifications for an existing in-house system to IBM Maximum

Maintaining project Plans

Mattel, Inc. El Segundo, CA (Headquarters) Jan 2007 – Jan 2009

Lead Business/System Analyst

Responsible for gathering business requirements, providing scope documents, functional and technical specifications

Managing and interfacing between the application development teams and business end-users globally. Planned and conducted regression tests, user acceptance tests, and converted data validations for multinational Cognos cubes roll-outs.

Good knowledge of data modeling, and performed large volume of data analysis

Designed, built and delivery a number of Cognos cubes for International Sales, Marketing and Finance departments.

Provided Cognos and Hyperion Planning training to International Finance, Marketing and operational user groups

Assisted with selection of data analysis and problem solving using Cognos and other applications for better understanding of sales and forecasting data (US and International)

Provided support to business sponsors and work with various teams to resolve critical issues

Acted as an Administrator for MS Share Point, responsible for implementation and support for the MS Share Point Portal for international subsidiaries

Successfully designed, developed, implemented and supported the Program Management Office (PMO) SharePoint sites for all international projects.

Successfully designed, developed implemented and supported a number of Cognos cubes, PowerPlay and Impromptu reports for International Marketing and Finance departments

Mattel, Inc. Kuala Lumpur, Malaysia (Asia Regional office) Jan 2006 - Dec 2006

Senior Business/System Analyst

Successfully evaluated and optimized third-party warehouse inventory and distribution management systems used in Malaysia, Australia and other Southeast Asia countries.

Responsible for gathering business requirements, prepared scope documents, functional specifications, and technical specifications. Managing and interfacing between the application development teams and business sponsors in the region

Planned and conducted regression tests, user acceptance tests, and converted data validations for local in-house applications.

Customized local data management and analysis tools to generate management scorecard

Successfully designed and developed the roadmaps and framework for enterprise data, application and infrastructure architecture for the Data Warehouse project while in Malaysia.

Provided seven local in-country (Hong Kong, Japan, Taiwan, Korea, Shanghai, Malaysia and Singapore) Cognos developments, Cognos training, support and business consulting in the region

Mattel, Inc. El Segundo, CA (Headquarters) Jan 1998 - Dec 2005

Lead Application Specialist

Provided a high level of technical expertise in worldwide application systems development. Planned and assisted in the development of complex technology projects for worldwide deployment in a multiplatform environment.

Developed and integrated a number of cross-platform applications such as IBM I Series to Sybase and web enabled

Provided technical consultation on application systems projects to end-user organizations worldwide and to all levels of information technology personnel in support of business requirements

Provided a high level of technical expertise in worldwide applications such as ISIS (ERP), Hyperion Planning, Enterprise Data Warehouse, Worldwide Toy Line projection (WWTLP), Worldwide Licensing (WWL) and Language Translation (Idiom) Systems

Provided system supports to Asia Pacific Region, including the implementation of ISIS, which was an in-house developed application for distribution, inventory, warehouse, and demand planning for all international subsidiaries

Successfully designed, developed and implemented the Integrated Marketing Plan(IMP) system that extracts and consolidates TV and other advertising information from all subsidiaries and provides analytical data to all regions and headquarters managements

Provided maintenance and support of the Domestic Manufacturing (MRP) system comprised of purchasing, receiving, inventory, in-transit and locator modules.

TECHNICAL & OTHER CERTIFICATIONS

Project Management – Mattel Learning Center

Microsoft Share Point Development – Microsoft Training center

Cognos CRN 8.0 part 2 – Cognos Melbourne Training Center in Australia

Cognos CRN 8.0 part 1 – Cognos Kuala Lumpur Training Center in Malaysia

Cognos PowerPlay 7.4 – Cognos Training Centers

HTML/JSP/ASP Training – Mattel Learning Center

Visual Basic 6.0 – Microsoft Education Services

DB2/400 Database Design – The Helms Group

Project Management Skills – The Learning Tree

iSeries SQL - IBM

REFERENCES

Available upon request or via www.linkedin.com

Contact this candidate