We provide IT Staff Augmentation Services!

Sql Analyst Resume

4.00/5 (Submit Your Rating)

Irving, TX

High energy, creative and skilled individual interested in obtaining a management position within a dynamic company, utilizing 15 years experience as a Web/ERP Business Analyst and Project Manager.

COMPUTER SKILLS AND TRAINING

Business Systems

  • MS SQL Server
  • SharePoint Server
  • JD Edwards AS/400
  • Microsoft Dynamics AX 4.0/2009
  • DB Design/Management
  • SSRS
  • Atlas 4.0
  • ILS Manhattan Software
  • B&G M1

Server Administration

  • MS Windows Server/IIS
  • MS Exchange Server
  • MS Windows/Office

Web Development

  • ASP/VBScript/XML/CSS/Java Script/HTML/X++/.NET
  • Adobe Create Suite
  • Visual Studio

PROFESSIONAL EXPERIENCE

ERP SQL ANALYST Full Time
Confidential October 2011 to January 2012

EXPERIENCE AND ACHIEVEMENTS 
Provide technical support and development for ERP system.

  • Developed custom forms and applications for all departments.
  • Design Project documentation for all applications and system analysis.
  • Update and customize code for Crystal Reports and SSRS for Financial reporting.
    Integrate ERP data with all ecommerce and intranet applications.

ERP CONSULTANT
Confidential June 2008 to Current

EXPERIENCE AND ACHIEVEMENTS 
Provide ERP consultation and to new clients and current customers

  • Develop documentation and workflow processes for new EDD’s
  • Develop AX upgrade plans, incorporating existing custom code where necessary.
    Train and documents new integration plans for customers

AX PROGRAMMER CONSULTANT
Confidential IRVING, TX August 2010 to October 2010

EXPERIENCE AND ACHIEVEMENTS 
Provided solid, functional and Gap analysis of system-related issues within heavily modified AX 4.0 environment, including analysis of AX integrations to ecommerce, retail, and non-AX WMS systems.

  • Analyzed and implemented Dynamics AX modules developed within the Finance/Supply Chain Management
  • Developed AX upgrade plans, incorporating existing custom code where necessary.
    Developed thorough test scripts and parameters for regression and migration testing. 
    Provided end-user training, as needed.
    Strong X++ development background to address any coding deficiencies discovered during functional analysis.
    Proficient with multiple AX modules, including Financials, HR, and Sharepoint 2007 Enterprise Portal for web based applications.
    Familiar with and able to design and develop custom integrations using the AX Application Integration Framework or .Net Business Connectors.
    Implemented AX and AOS environments; performance tuning servers and code.
    Experience assisting users with business process changes and improvement initiatives.
    Able to observe, analyze, and document current business processes, as it relates to system usage. 
    Skilled in analysis, observation and interpretation of technical information.
    Strong project management skills with all ERP Development.
    Developing business processes in conjunction with vendors business partners

APPLICATION DEVELOPER/ PROJECT MANAGER CONSULTANT
Confidential FORT WORTH, TEXAS March 2010 to July 2010

Working with Frachtech as the Application Developer my responsibilities included develop, maintain, and configure Enterprise Resource Planning applications via a Microsoft Dynamics AX 2009 platform using best practice software development life cycle standards. Developing, maintain, and configure corporate SharePoint sites.

EXPERIENCE AND ACHIEVEMENTS

  • Configured and supported Microsoft Dynamics AX 2009 ERP all modules
  • Developed and maintained Microsoft Dynamics AX 2009 ERP custom functionality all modules
  • Microsoft Dynamics AX 2009 ERP administration and security maintenance
  • Configure and support corporate SharePoint sites
  • Provided end-user support and training for developed and maintained applications
  • Followed the software development lifecycle (SDLC) for all projects

ERP/E-COMMERCE & PROJECT MANAGER FULL TIME
Confidential DALLAS, TEXAS October 2002 to 2009

ASI Corporation (ASI) is a commercial distributor of computer hardware components, complete solutions and software. The company is privately held with sales of over $1.2B

EXPERIENCE AND ACHIEVEMENTS

  • Developed and enhanced website applications for company ecommerce portal with monthly revenue of $11M in online sales orders with Microsoft Dynamics AX
  • Saved ASI $500K per year by reducing outsourced projects
  • Developed multiple online content management modules for employees
  • Managed and guided 11 developers for all web projects
  • Designed department based income statement
  • Configuration of software to meet design specifications
  • Provided customer support for all internal server and application issues
  • Presented project tracking and scheduled modifications at meetings
  • Managed budget and timelines for ERP web solutions
  • Prepared and presented training material to Company’s customers as well as end users

Webmaster/Project Lead FULL TIME
Confidential Dallas, Texas January 2000 to July 2002

EXPERIENCE AND ACHIEVEMENTS

  • Maintained and developed various internal applications for content and relational database management
  • Key developer of internal website construction application, which involved the maintenance of complex data and navigation models
  • Provided communications regarding consulting projects, deadlines, and developments
  • Managed progress of Web Developers for quality assurance and delivery of projects
  • Revamped current clients websites to database driven administration controlled Extranets
  • Managed all access to FTP, EDI, and CSV downloads
  • Marketed to current and potential clients to maintain company brand standards
  • Attended daily meetings with managers and directors, regarding updates on all web applications for quality assurance
  • Delegated content management solutions to colleagues for backend administration modules

WEBMASTER/IT ASSISTANT FULL TIME
Confidential DALLAS, TEXAS 1999 - 2000

EXPERIENCE AND ACHIEVEMENTS

  • Developed, designed and supported corporate website
  • Maintained email, NT and file servers with MS BackOffice, IIS and Exchange
  • Networked over 50 employees; setting up new computers, troubleshooting, and configuring TCP/IP settings
  • Updated daily information on website with visually appealing content
  • Provided daily backups of log files, emails and databases using customized software
  • Developed fulfillment-tracking system for website with ASP, VBScript and SQL
  • Maintained SEO (Search Engine Optimization) for website
  • Planned strategic meetings and deadlines for proposals and projects

WEB MANAGER/SALES FULL TIME
Confidential DALLAS, TEXAS 1997 - 1999

EXPERIENCE AND ACHIEVEMENTS

  • Designed websites for customers
  • Set up new domains on NT Servers for customers using IIS and MS Back Office
  • Updated SQL Databases
  • Managed statistics and log files with WebTrends
  • Maintained correspondence with potential clients and contractors
  • Provided follow up communication prospective buyers
  • Cold called for sales

FORMAL TRAINING

  • CIW WebMaster Certification

Master CIW Designer/Programmer

  • CIW WebMaster Certification

Master CIW E-Commerce Designer

  • Microsoft Dynamics AX Application Developer Certification

AOP Developer/Designer

  • Microsoft Dynamics AX Portal Developer Certification

Sharepoint AOP Developer/Designer with ERP Integration

We'd love your feedback!