Mandy Ashley Email & Phone Number

Fort Mill, South Carolina, Us

Rock Hill, Sc, Us

Rock Hill, Sc, Us

Chesapeake, Virginia, Us

Lead Technical Analyst on SAP/POS Return to Core project. Managed design and development efforts to re-implement SAP/POS back to the core product. This effort involved massive changes to the cash register configuration and backend transaction file sent to Sales Audit. The ETL conversion of the transaction files were written in PL/SQL or Informatica using an Oracle 10g database. Assisted with the rollout effort to stores.Successfully led technical team in implementing SAP Budget Planning and Consolidation System. Coordinated with the business on requirements and deadlines. Developed conception design of all interfaces and data flow. Designed interfaces from core systems using Informatica. Assisted development team with developing mapping and workflows. Designed and Developed SQL Server SSIS packages.

Chesapeake, Virginia, Us

Designed and Developed an Oracle Application using Oracle Application Express - APEX to keep track of all interfaces and touch points between systems at Family Dollar Stores, Inc. This application was mainly used by Technical Analyst and Developers to documents all the current interfaces between systems.Lead Technical Analyst on designing and implementing enhancements to support SAP GM Release for POS Gift Cards and Coupons. Sales data is sent to corporate from the store in the form of a .tlg file created at the register by SAP/ POS Triveristy software. This data has to be converted into a readable and useable form to report Sales. Responsible for designing and developing changes to custom ETL tool written in PL/SQL. Responsible for working with the business to convert and extract data needed for Sales Audit POS using a combination of PL/SQL, Informatica and Pro*C. Tuned Oracle complex queries to obtain optimal performance during the upgrade to Oracle 10g.

Rock Hill, South Carolina, Us

Work jointly with customer services representatives and management on end user request and upgrades to order management system on AS/400 developed in COBOL.

Us

Analyze legacy mainframe DB2 POS system and development requirements to convert the system to an Oracle database on a RS/6000. Developed and implemented a reporting application using Micro Strategy reporting and SQL Server 2000 scripts for an order management system on an AS/400. Analyzed and developed system requirements for a legacy mainframe POS application using DB2 and Mainframe COBOL. The reporting for the POS system was written in Power Builder. Design and implemented enhancements to reporting application using Power Builder.

Rock Hill, South Carolina, Us

Developed and implemented user enhancements and version upgrades for customer billing for Domestic and Canadian accounts on an AS/400. Analyzed current system requirements for utility company and developed customer specific database allowing the user the capability to maintain customer, and billing information on an AS/400

Us

Defined and implemented the requirements to convert data from a RS/6000 and AS/400 to an IEF/DB2 based order management system including product, inventory, aged inventory, and orders. Implemented standards and procedures database using Lotus Notes.

Processed millions of records utilizing SAS on a UNIX platform to develop a database used for marketing and statistical analysis. Served as steering committee member on the Charlotte SAS Users Group. Defined requirements for creating a WEB page using HTML

Albuquerque, Nm, Us

Designed, developed, and implemented GUI Client Server information systems utilizing SAS/AF and Screen Control Language. Facilitated SAS user groups and orientated new employees to TSO/ISPF, DB2, and SAS. Defined the requirements for a Data Warehouse development project utilizing Visible as the data modeling tool and DB2 as the database structure. Managed and maintained PC base systems requiring various customization and upgrades. Interfaced database request to other information systems using DB2, COBOL/2 and SAS.

Programmed on a Client Sever Life Insurance development/maintenance project utilizing data transfer methodology. Implemented design changes and evaluated system inquires that were produced by a quality assurance team. All applications were written in COBOL/2, IBM C, and Presentations Manager.