Sandra Martinez Email & Phone Number

Houston, Texas, United States

Independent contractor/consultant specializing in custom database application and computer system design, development, maintenance, technical support, documentation, and training.Recent Projects:• JobManager™: Comprehensive construction management software package for industry professionals to create and manage all required project documentation, and to provide global tracking and reporting capability to more efficiently and effectively manage multiple on-going construction projects.• TrendTracker™: Excel application for pulling selected lab analysis result data from SQL server and displaying in various graphs, with automatic updating and customizable filters for desired data.• ReleaseReporter™: Access/SQL database application for managing pipeline chemical component information and reporting data according to state and federal guidelines if there is a release or spill. Includes process flow diagrams with click-to-choose release areas with automated calculation of quantity of each chemical released.• SupplyMaster™: Access/SQL database application for managing supply chain orders and deliveries, multiple suppliers and their pricing, with easy transfer of ordered items to SAP for creating purchase requisitions. System includes price comparison tools and average delivery times for making better supply source ordering decisions.• ChangeManager™: Helpdesk application for managing user trouble tickets and change requests, allowing for direct email communication between assigned tech personnel and requestor.• TimeTracker™: Access/SQL database application for managing company employees' information, timesheets, PTO accrual/usage/rollover, hire and termination dates, shift assignments, and reportable chain of command. Application allows alternative methods for managing contract employees and includes separate user interfaces for HR management vs Timesheet entry.

Seabrook, Texas, Us

Holistic natural wellness services including Energy Healing, Salt Therapy, Immersive Relaxation & Meditation, RegenerEating™ Nutrition Therapy, and wellness supplements.

Franchise store owner of Bay Area CBD American Shaman, offering the most powerful organic, non-GMO hemp oil CBD wellness and beauty products available for people and pets.

Charlotte, Nc, Us

• Oracle and SQL Server administrator: Managed data connections from myriad source applications, server upgrades and maintenance for optimal performance between Amsterdam and Pasadena plants.• LIMS administrator and SQL Server data warehouse architect: Enhanced SampleManager LIMS system functionality per user needs, designed and managed near real-time updates to data warehouses.• Power BI dashboards and Report Server administrator: Created Power BI dashboards for lab and plant production monitoring and reporting, managed PBI Report Server upgrades, user access, and security to host dashboards from various business units, R&D and production plants in America and Europe.• Alteryx workflows and Gallery/Server administrator: Designed workflows to manage ETL processes, maintained web gallery licensing and server upgrades affecting users in Pasadena and Amsterdam.• Northwest Analytics Quality Analyst / Focus EMI dashboards and Licensing/Server administrator: Automated dashboard displays for various units, maintained licensing and server/client upgrades for Pasadena plant.• Microsoft Excel and Access applications developer: Enhanced existing and created new spreadsheet and database applications per user needs for Pasadena plant operations monitoring and reporting.

Milwaukee, Wi, Us

Recent assignments:• Excel Dashboard Admin for BP America Production, HR-Upstream Talent & Learning department: Excel applications to import raw report data, add columns with automated formulas to enhance data, and apply filters with automated graphing of report data for statistical analysis.

• Provided technical support and customization of a Laboratory Information Management System (LIMS) in Access 2007-2010 and SQL Server 2008 R2. Managed synchronization of research and development site analyses and related data with production plant records in another state, including reassignment of primary keys in critical tables to merge and synchronize records while maintaining data integrity. Created new data tables, user forms, and all related items to incorporate new ideas for desired functionality.• Redesigned user interface for Access 2010 database tracking lab personnel timesheets and paid time off, with new/additional functionality for pro-rating PTO for new hires, managing rollover and accrual, and including paid holidays according to company policy. Migrated back-end tables to SQL Server for improved data security.• Redesigned the Access 2010 user interface for a Shipment Release Reports and Certificates of Analysis SQL database, with new features including Customer Product Trend graphing in Excel 2010. • Helped organize and improve developer efficiency and productivity via creation of a custom help desk application in Access 2010 to manage development and technical support requests for users in two states.• Created new custom Access/SQL and Excel applications as needed to fulfill company-wide and individual user requirements, including automation of complex data processing and graphing tasks for displaying historical lab results and modeling computational fluid dynamics data critical to research and development decisions.• Provided clearly written and illustrated instructions for all new applications and procedures, with user training and ongoing technical support as needed. • Handled all aspects of supply chain management including lab consumables and chemical procurement, inventory management and usage tracking, new supplier evaluation, and entering SAP purchase requisitions.

Jersey Village, Texas, Us

• Customized MS Access front-end database with linked SQL data tables for data entry forms, status logs, and reports regarding critical construction project documentation from job startup to close-out. System handles all Daily Reports, Requests for Information, Submittals, Progress Meeting Agenda/Minutes, Work Change Documentation, Change Proposals, Budgeting and Job Cost Projection with data linked from the accounting system, state-required CHRI background check logs, Subcontracts, Purchase Orders, Vendor Insurance and Certifications, Construction Issues, Safety Observation and Incident reporting, As-built Records, Warranty Orders, Lien Releases, Employee Timesheets, email and mobile phone contact list management, Bid Calendar distribution, Faxes, Transmittals, Holiday Mailing and Accounting file labels, and automated creation, filing, and emailing of PDF documents where applicable. System includes links to external documentation such as Contracts, Plans, Permits, Field Observation Reports, Substantial Completion Certificates, etc. to keep all project-critical information available from within the application. • Designed and maintained an Estimating database for managing subcontractor bids with links to faxed documents. • Designed and managed the company website and FTP sites, fax services, email contact lists, project file structure and archive servers.

Gained working knowledge of WordPerfect, QuattroPro, and QuickBooks, starting as receptionist and moving on to office manager and bookkeeper. Streamlined many cumbersome, repetitive processes by computerizing tasks, creating templates, and utilizing software programs and tools as designed to improve efficiency and productivity.