Resume

Database Administrator Data Analyst

Location:

Tracy, CA

Salary:

Open

Posted:

February 06, 2023

Contact this candidate

Resume:

Raul Samson

*** ******* *******, ******** *****, CA 95391

adu6kv@r.postjobfree.com - 510-***-****

To expand and utilize my skills and abilities as Application Analyst, Business Intelligence Analyst, Database Administrator, Programmer and Data Analyst.

PROFESSIONAL SUMMARY

Successful Database Administrator with more than 20 years of experience in database development and production environments. Areas of expertise include maintenance and security. Proactive in establishing backup and recovery processes and protocols to protect and retain valuable company data.

Experienced in database design and administration, data modeling, data warehousing, Enterprise Systems Architecture and Business Intelligence (BI). Extensive technical skills and advanced understanding of Oracle, SQL Server. Strong collaborator and team

SKILLS

• Market analysis

• Quantitative methods mastery

• Data structures knowledge

• Metric report design

• Statistical computing methods

• Data visualization

• Project coordination

• Usability understanding

• Requirements gathering

• Recordkeeping

• Data backup and retrieval

• Website and portal monitoring

• Team leadership

• Enterprise applications

• Refined system debugging skills

WORK HISTORY

November 2019 – Current

IT Manager/Epicor ERP/Database Administrator

KNT Manufacturing - Newark CA

• Epicor ERP Systems and Database Administrator (Epicor 10.2.700 and MS SQL Server 2019).

• Implemented Epicor as Company’s new ERP Systems from old Shopkeeper ERP Systems. Leading the KNT Manufacturing team for the implementation of Epicor ERP Systems.

• Installed current version of Epicor Application into the Utility Server and Epicor Database into SQL Server. Troubleshoot Epicor installation problems.

• Provided training (functional and technical) to all ERP Epicor users from beginning (loading sales order) to end (shipping).

• Established an integration between the LAM’s portal Sales Order to load into Epicor ERP Systems.

• Form customization, BAQ, SSRS and Crystal Report design.

• Work out of a SQL Server Database utilizing advanced SQL queries and stored procedures to accomplish user’s request.

• Configuring database servers, monitor, maintain system and security. Performing database tuning, restore and recovery as needed. Managed database security including development and access of input systems.

• Designing backup processes for server and associated data. Establishing a disaster recovery protocol. Create accounts for all users and assign security levels.

• Scheduling and performing regular server maintenance.

• Provide end-to-end technical support and problem resolution.

• Application Server setup and maintenance.

• Systems Administrator, Microsoft Exchange 2013/Barracuda Administrator. Office 365 and Exchange Administrator. Manage network Hyper V host, servers and technology tools. Set up Active Directory accounts and workstation. Kloud Voice Administrator (Phone Systems). Configure DNS and DHCP Server. Domain Controller. Help migrate Exchange Server to Office 365. Migrating Acitve Directory/DNS, File Server (File Share) to cloud (Azure).

• Ensure security through access controls, backups and sonic wall firewall and Palo Alto firewall.

• Full backups, incremental backups and disaster recovery of data files server.

• Microsoft Office Supports. Microsoft Access VBA and Excel Macro Programmer.

May 2011 – November 2019

ERP/Database Administrator

Data Analyst

Bentek Enclosure - San Jose, CA

• Syteline 8.02.11(ERP) and Database Administrator (MS SQL Server 2008/2012)

• Performing database tuning, restore and recovery as needed. Managed database security including development and access of input systems.

• Work out of a SQL Server Database utilizing advanced SQL queries and stored procedures to accomplish user’s request.

• Application Server setup and maintenance.

• Implemented Syteline 8.02.11. Performed SL form customization. Debugging problems within our Syteline ERP Systems.

• Designed ERP Item Planning Detail, Indented BOM, Flat BOM, Job BOM, Quote Module, Serial Number generator, ECR Tracker, Calibration Application and other application.

• Created and implemented rules in Doc-Traq, Shop-Trak and CPQ.

• VB.Net programming and Extensive Crystal Report, SSRS Report writing and Access Report. Performing Power BI and Tableau Dashboard.

• Developed/Designed and implemented Intranet. Administering Intranet and SSRS reports

• Microsoft Access Programmer and extensive knowledge in Microsoft Excel macros and VBA, chart and pivot

• Data analysis and management reporting, including Dashboards, Ad-hoc Reports and Executive Reports.

• Programmed recurring reports for error checking and reconciliation.

• Performed ad-hoc analysis to answer internal and external requests for service and client counts and trends.

• Systematically identify and define problems, evaluate alternatives, and implement effective solutions.

• Troubleshoot reporting issues.

• Providing end user support as required.

Proactively create diverse set of reporting tools to support various client needs.

• Performing other support duties as required. Performing required reports for the purchasing department and upper management every Monday.

• Basic Responsibility in Active Directory/Domain Name Server.

• Basic Responsibility in Cyberoam Firewall configuration, Sherweb Email and Aerohive wireless router.

• Knowledge in VMware/Hyper V Technology

• Analyzes and elaborates on all in-house computer functional requirements needed to design new information systems or to set changes and corrections to the existing system.

Oct 2000 - Mar 2009

Programmer/Systems

Analyst/Desktop Support

Sanmina Enclosure - Fremont, CA

• Experienced in designing and maintaining SQL Server databases. Experience with SQL queries, stored procedures, database structures and database server's administration.

• Experienced in Oracle Applications supported by Agile and Oracle Discoverer.

• Extensive experienced in Microsoft Access including VBA and macros. Extensive experience in Microsoft Excel Macros and Pivot Table.

• Proficiency in data manipulation, reporting, and presentation tools (Crystal Report, Oracle Discoverer and Microsoft Access).

• Solid working knowledge of basic Web architecture. Maintaining intranet for both static and dynamic web.

• Solid working knowledge of web editors (Dreamweaver MX, Fireworks, Flash, IBM Websphere)

• Solid familiarity with the use and creation of database and application for website.

• Engineering Change Analyst. Maintaining all ECR, ECO, Deviations and BOMS using Oracle Application and Agile.

• Desktop Support giving initial setup and ongoing support of workstations and notebooks primarily running Windows XP and Office 2003. Basic responsibility in Administering Windows 2003 Server, Active Directory, Exchange 2000 Server, SQL Server and account management. Network troubleshooting.

• Provide break/fix support, open cases with Dell support as needed relocate systems and have new systems ready for new hires one their first day.

• Quickly diagnose and fix end user problems such as system slowdowns, lost data, access failures, and missing or halted applications.

Jun 1999 - Oct 2000

Computer Programmer /

Webmaster

E-M-Solutions - Fremont, CA