CELESTE R. GRINAGE

ac5s1t@r.postjobfree.com

linkedin.com/celeste-grinage-61043836

510-***-****

SUMMARY:

Results-driven IT Professional with nearly 10+ years of progressive experience in the Information Technology such as Application-Database System Development (ETL, Enterprise Data Management Processes) /Support, Testing Support, Quality Assurance, and Data Analysis. Proven ability to achieve organizational objectives in a collaborative work environment, while supporting established business initiatives.

EDUCATION & CERTIFICATIONS:

MOUS Certificate in Access 2000

Community College Online Teaching Certificate -- UCLA

M.B.A., with an emphasis in CIS from California State University at Hayward

TECHNICAL SKILLS DETAILS

Software/Databases: Windows, MS Office 2003-2016, Office 356, Excel (PowerPivot), MS Access, Crystal Reports, MS Project, Pro Visio, Tableau, Cognos, SharePoint, BI Tools, Asset Management Tool, PeoplePulse, Teradata SQL Assistant, SQL Server, Hive, Looker, SQL Workbench, Marketo

Programming: VBA, XML, SQL, Hadoop, SQL Plus, Business Objects Webi, DB2, VWS (Web based reporting system), HTML, CMS, Joomla, SSRS, ETL

Communication: Skype, WebEx Meeting, WebEx Connect, GotoMeeting, Slack, Zoom

WORK EXPERIENCE:

AutoDesk San Rafael, CA

Business Systems Analyst January 2016 – April 2018

Created automated system (Access) for routine process that utilized Excel files which increased productivity and accuracy by 90%

Created integrated product evaluation system using Access, Excel, and Hadoop to handle validation of product pricing and language translations based on the country

Automate creating new, change and cancel to product line

Automate and format data for use in Marketo

Developed data flow, process flow, user cases, and ER Diagrams

Participated in user acceptance testing

Programming Environment: VBA, SQL, Hadoop, MS Access, Excel, PowerPoint, SharePoint 365, Excel, Professional Visio, Hive, Cloud base server (Pelican), Slack, Looker, SQL Workbench, HUE

Wells Fargo Oakland, CA

Database Analyst August 2015 – December 2015

Working with the Wells Fargo Home Mortgage Capital Markets Finance on a mortgage integration and conversion from an old system to a new system.

Translating VBA code in MS Access database to new code which was imported into a new SQL system.

Working closely with analysts in translating SQL code used in the development of major upper level reports

Involved in the testing, pre-production, and deployment of the new system

Created VBA code and complex formulas in developing Excel applications and financial data models

Programming Environment: VBA, MS Access, SQL, Excel, PowerPoint, SharePoint, DW, Teradata SQL Assistant, SQL Server Management Studio, SSRS, SSIS

Safeway Pleasanton, CA

Business Consultant/Developer April 2015 – May 2015

Work with the Supply Chain department on the decentralization of system databases in three departments (Floral, Meat, and Produce)

Assessed and developed project plan which identify key issues and problems, along with timeline and network deployment to district centers

Upgraded all the systems from 2003 to 2013

Programming Environment: VBA, Excel, Access, PowerPoint, DB2, QFM, DW, Teradata SQL Assistant, SSRS

Deloitte San Francisco, CA

Developer October 2014 – January 2015

Project was the development of an interim Access database system for processing company wide performance review survey to be used in yearly employee evaluations and promotions. Designed and developed data validation and control processes which decrease user error by 90%

Worked closely with team members offshore and coastal on making modification and updates to the system, travel coastal 30% and remote 70%

Programming Environment: Access, Excel, PowerPivot, VBA, SharePoint, Tableau

Kaiser Permanente Pleasanton, CA

Sr. Client Server Developer February 2013 – July 2014

Worked with the Project Management Office/Business Management Office (PMO/BMO) division as lead Developer, also responsible for two other developers

Work on major modification to normalize department Access system and increase system performance by 40% using SQL and VBA

Created department databases which consist of translating business requirements to technical requirements, ERD, data mapping, and work flow diagrams, and prototype to a Go Live database

Designed and developed monthly dashboards (KPIs), and report cards for deliver to upper management and

other divisions using Access, Crystal Reports, and Excel

Programming Environment: Access, Excel, PowerPivot, IB Tools, VBA, SQL, Crystal Reports, SharePoint, AIMS, SAP, SAS, SSRS, Remedy, Clarity PPM, Professional Visio, Tableau

AT&T San Ramon, CA

Reporting Analyst September 2011 – April 2012

Identified and evaluating key redesign issues needed to be addressed

Designed and created the reporting system using Access

Created Excel/VBA automation tools for a variety of User Directed Tasks

Programming Environment: Access 2007, Excel, VBA, Crystal Reports, Enterprise Guide 4, SharePoint, PowerPoint Presentation, Oracle, SAS

Kaiser Permanente Pleasanton, CA

Systems Analyst March 2011 – September 2011

Developed an Excel application to streamline electronic data discovery (EDD) printing. Standard EDD procedures generate a PDF document to capture workbook content

Reduced in cost related to paying by page count by 40%

Provided monthly matrixes on unassigned assets to upper management

Maintained and updated server applications through Asset Management tool (AIMS)

Automated weekly and monthly dashboards reporting procedures

Programming Environment: Access, Excel (Pivot tables, macros), VBA, SQL, Crystal Reports, SharePoint, Asset Management Tools, Business Objects, Remedy, Cognos, SAP

Pacific Gas and Electric San Francisco, CA

Systems Analyst December 2010 – March 2011

As the System Analyst using analysis to create the detailed specifications necessary to develop, upgrade or modify existing small to medium-sized department’s Access database system

Automated the daily, weekly, and monthly reporting database systems making it more efficient and accessible for Project Managers

Provided high level reports to the electric team using Crystal Reports

Developed complex Excel macros for large data pull from SAP and SAS

Programming Environment: Excel, VBA, SQL, Access, Crystal Reports, SAP, SAS, SharePoint

Cisco Systems Inc. San Jose, CA

Systems Analyst May 2007 – August 2010

Responsible for the modification of the Access database used as the main analysis tool for daily processing.

Performed retrieval and analysis on data from CNCs (Cisco Network Collector) to research discovered and undiscovered network devices using available data analysis tools in a data warehouse environment

Worked closely with IT and Global Theatres (US, Asia Pac, Australia, Emerging Markets, European Market) in resolving network discrepancies effecting new and renewal Smart Care contracts.

Data scrubbing of data to providing increase efficiency and decreasing redundancy.

Worked on integrating the Web based tool (VWS)l into the SmartCare (Access) validation system through programming modifications to increase accuracy and streamline the process. ‘

Programming Environment: Access, Excel, VBA, Crystal Reports, SQL, Oracle, Toad, Remedy 7, RMA Tool, Visio, Sonar, and CSCC, Data Modeling, Smart Care Batch Tool, Wiki, WebEx Meeting, Connect, Sametime

Contact this candidate