Developer Data
Resume:
CELESTE R. GRINAGE
*********@*****.***
linkedin.com/celeste-grinage-61043836
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