Erp And Cmms Database Specialist Resume
Santa Rosa, CA
SUMMARY:
- I have been a talented professional in a variety of manufacturing and distribution corporations since 1996. I have a background that spans a decade of International Shipping and Logistics and three years of Purchasing Management that has lead me directly into a decade of high profile corporate enterprise level databases as part of the most elite
- IT Teams including working for ERP Software as a Service (SaaS) providers. My hands on professional experience has lifted my career and my employers data integrity and reporting to the highest echelons while increasing accuracy and automating workloads and s saving my employers undisclosed costs and hassles. My 27 years of experience is the greatest human asset that can be held by your corporation and I make a great addition to any IT or Finance Team.
TECHNICAL SKILLS:
Database SKills: ERP Implementation Database Project Management and Configuration Specialist Hands - on Enterprise Resource Planning (ERP) software Project Manager with over 50 successful implementations at large to mid-sized clients for an ERP Software as a Service (Cloud SaaS) provider. Managing the process and schedules, business and technology stakeholders, performing configuration, development, reporting and customization of the applications. Business processes and certified Six Sigma Black Belt and Agile Scrum. Business Intelligence (BI), Reporting and Dashboard Creator Created customized reports and dashboards in Business Objects, Axxerion, Izenda, Qlikview, and other proprietary BI software applications. Expert Data Modeling and native SQL. Data Analyst, Data Transformation/Migration, Native SQL and Microsoft Excel Expert Certified Master Microsoft Excel user with the ability to analyze large data sets for reporting, import template creation/population, data reconciliation and validation, and to diagnose reporting accuracy for business operations, including financial reporting. Expert data modeling and data migration experience in ERP, CRM and HCM databases.
PROFESSIONAL EXPERIENCE:
ERP and CMMS Database Specialist
Confidential (Santa Rosa, CA)
Responsibilities:
- I worked with their ERP named Costpoint and their CMMS software Maximo to manage inventory, projects, purchasing requisitions, sales orders and manufacturing orders. My goal was to help achieve internal audit compliance which was successfully accomplished. I also helped with a major IT Server change that included all network files and two database migrations to the new server as well as the project documentation and user support.
IT Master Data Analystecialist
Confidential (Rohnert Park, CA)
Responsibilities:
- As part of the IT Master Data team I analyzed and cleansed the SAP ECC Purchasing Information Records, HTS Codes, Source Lists, Material Master, Distribution Channel and Sales Pricing Conditions tables. I maintained the Customer specific pricing in hierarchical matrix tables for all customers. I also assisted in creation of customer’s catalogs, revisions to the change management processes and implementation of a new Product Information Management database. I managed Vendor Master files, Customer Master files, Broker Master files and Broker Commission reporting conditions.
ERP Database Financial Application Support Analyst II
Confidential (San Rafael, CA)
Responsibilities:
- Member of a large team upgrading from ECC 6.0 to SAP S4 HANA/Fiori/FICO responsible for analyzing financial data, performing UAT, ensuring that newly created database fields are correct and developed Business Object reports. Performed heavy testing. Created over 100 issue logs for engineering to resolve and then retested the issues after further development was completed in SharePoint and TestRail. This was a short-term contract to aid a tight deadline.
Smartsheet Database Designer
Confidential (Sebastopol, CA)
Responsibilities:
- Created a Fleet Tracking database for their fleet of 350 vehicles in a Smartsheet database capable of tracking VIN, Registration, Insurance, Claims, Repairs, Recalls, and GPS Tracking Device Identification. Loaded this database with their scanned copies of related documents and created a contact list to associate all related personnel to the vehicle.
Senior ERP Database Software Implementation Specialist/Developer
Confidential (San Rafael, CA)
Responsibilities:
- Implemented Enterprise Resource Planning and Computerized Maintenance Management Software for this Software as a Service Provider. Responsible for 5 Fortune 500 implementations including custom field and page creation, adding widgets, creating Wizards, Dashboard, Reports, Imports, Custom form creation including setting parameters, custom Workflow creation. Applied JavaScript to add page/report interactivity and CSS for customized User Interfaces. Created user documentation, curriculum and performed for over 2,000 plus users. Documented bugs in the code for Engineers to resolve and tested bug fixes before releasing the patches to Production.
Head of ERP Database Software Implementation
Confidential (Novato, CA)
Responsibilities:
- Implemented an Enterprise Resource Planning application named Accolent for 25 Small to Medium sized businesses. ADS had an extensive customer base using an older ERP that they were transferring to their new solution Accolent. Managed the implementation process for these clients and was the main point of contact for the clients via the Atlassian Confluence ticketing database, email and phone. Resolved issues and also escalated code level issues to offshore developer in India using our developer-facing Jira ticketing database. Created user documentation for the new solution and designed reports using Izenda. This involved heavy testing and development and bug documentation/resolution.
Database Software Specialist - Business Technology Management
Confidential (Novato, CA)
Responsibilities:
- Performed User Acceptance Testing of their new Document Control Lifecycle application that was in development. I performed script testing and created user documentation for the new custom application. I also performed class room exercises to educate the staff of 1,600 on how to use the new application in a board room format twice a week or more.
- I also coordinated a project of scanning 20 years’ worth of scientific notebooks that were onsite and offsite in storage. Once these notebooks were gathered and scanned they were returned to the scientists and I created a digital library of the scientific notebooks in OpenText LiveLink essentially transforming their paper records into an online digital library of searchable PDF’s.
ERP, PLM and Ecommerce Database Software Specialist and Webmaster
Confidential (Santa Rosa, CA)
Responsibilities:
- Managed their Cost Sheets and updating of the ERP named IFS, along with their Wordpress website we referred to as the Data Download Site that contained all of the product information and digital assets for each product. I managed their SpeedCat electronic catalog, SEMA Data Co-op products catalog, Amazon.com web pages, three of their brand websites including the data, and delivered data to all of their clients. Represented Confidential at large national Data Summits and Conventions. I am certified in ACES and PIES which is a form of data programming for application/fitment data in the automotive industry and product information used in the database and cataloging process.
- Member of the National Catalog Managers Association while employed there. This company regularly introduced 20 new product releases per month to the public. I would manage updating all vendors, websites and catalogs, and managed their YouTube channel and video content. My responsibilities included management of all SEO, Product Taxonomy, Application data, Photos, Instructional documents, Warranty documents, Marketing Documents and more that were compiled into digital catalogs.