We provide IT Staff Augmentation Services!

Erp Database Administrator Resume Profile

3.00/5 (Submit Your Rating)

OBJECTIVES:

To find a challenging position in Information Technology with a focus on Business Intelligence or Database Administration that will reflect and enhance my past and present accomplishments and will allow me the opportunity to grow in an innovative environment.

QUALIFICATIONS:

Six years' experience as a Marketing Database Analyst for companies with client bases over 1.6 million customers. Five years' experience in Computer Administration with additional skills that include ETL software, Data Warehousing, Data Analysis, Sql Server 2010 and Sql programming,

PROFESSIONAL EXPERIENCES:

Confidential

ERP Database Administrator:

Sql Server 2010 Administration- through implementation best practices. This includes installing, configuring, patching, upgrading, and maintaining seven of Epicor's ERP servers. Also responsible for planning and coordinating the change management of processes required for the support of ERP systems necessary for business operations.

Data Warehouse Administrator: Sql Server 2008 R2 - Utilizing Sql databases, queries, stored procedures, and views to extract and validate the data used for the BI system. Responsible for ensuring the data transfers on a nightly bases without errors. Extracting data from multiple sources and importing and transferring data with Pentaho Data Integration ETL software.

Business Intelligence Administrator:

Logi XML Business Intelligence Applications Administrator- responsible for the creation of specialized developer info reports designed with XML elements, parameters, and tokens consisting of drill through charts graphs, dashboards, animated maps, Google maps, heat maps, and crosstabs and data tables. Responsible for user training, security configuration, report scheduling, personalization and internationalization.

Marketing Database Analyst:

In charge of all the monthly business reports for the VP of Marketing and including KPI reporting for Regional Managers across the United States. Managed Cognos business intelligence reporting applications and build and maintained Microsoft Access Databases. Responsible for Buying group incentive programs and finalizing reports for the CFO.

Confidential

Marketing Database Analyst:

Assisted the PHP developers with the development specifications for a custom CRM web application. Also developed and tested the reporting tools and identified data discrepancies and resolved data integrity issues. Responsible for monthly Access and Excel reports for the COO's manager meetings that forecast month over month and year over year trends in conjunction with monthly affiliate reporting used for incentive payouts. In addition, target marketing list pulls for email campaigns using BlueSky Factory Currently WhatCounts.com

Confidential

Marketing Database Analyst:

  • The Analysis of numerous satisfaction surveys, product penetration, market penetration, demographics, marketing practices and trends and summary preparation. Assemble data from multi-system data sources to establish and maintain marketing department reporting and return of investments. The generation of large direct mail drop files which are disbursed through various mail houses.
  • Database Programming: Creating multifunctional Access database programs that are customized for various business lines, used for front end data entry and administration with self extracting reporting and analysis capabilities. These databases are usually linked to Oracle ODBC drives and/or the Sybase call center phone data client. Fluent in data analysis using Smart Focus, an object oriented information warehouse.
  • MRM Responsibilities: Data audits, data dictionary development, aiding in project specifications and assignments using MS Project or Visio. Additional Responsibilities include validating all the business line data prior to monthly data warehouse migration.

COMPUTER SKILLS:

Epicor ERP systems, Sql Server 2008 R2-2012 , Navcat, PLSql, Logi Analytics, Pentaho Data Integration, Access, Excel, MS Word, PowerPoint, Visio, MapPoint, Smart Focus, Microsoft Project, SSRS Reporting, BI Dashboards,

We'd love your feedback!