*** ******* **.

Fort Worth, Tx *****

aco7ab@r.postjobfree.com

682-***-****

Shari Emery

Objective

Utilize my skills to provide ease of use and proficient analysis of data within BI tools for the Business Groups of an Organization through Information Technology solutions.

Professional Overview

Strong functional business analysis abilities combined with effective technical applications development skills. Over 25+ years of technology-related experience, specializing in improving business processes through the development and application of information technology solutions. Including research, analysis, design, development, testing, troubleshooting, documentation, and implementation of a wide scope of software projects geared to improve a company’s efficiency and bottom line. Proven subject matter expert (SME) providing on-going system support and training. A common sense project oriented leader focused on favorable results over the long term.

Possesses extensive ability in research, documentation and insight to overall end to end processing in a vast area of technologies.

Pride in overall efficiency and dedication to completion.

Excellent communication skills both verbal and written.

Proven implementation of standards across multiple platforms.

Proficient in trouble shooting with complete results in a timely manner.

Certified SCRUM Master – Agile Project Management

Areas of Practice

• Program Design, Development and Deployment

• ETL (Data Transfer) Design and Implementation (Datastage, SSIS, DTS)

• SQL Server Development (2005, 2008R2, 2012, 2014)

• Reporting Design / Production (SSRS, Crystal Reports)

• Hyperion Essbase / Web Analysis

• Teradata

• MDX(basic)

• Rally (PM tool)

• .Net(basic)

• C# scripting in SSIS

• Data Warehouse Architecture (OLAP, OLTP)

• Software Development Life-Cycle (SDLC)

• Test Scripts (QA, Case Analysis)

• Project Management (Agile, Kanban, Water fall)

• Business Intelligence (Research and Analysis)

• Business Requirements and Documentation

• System Conversion Initiatives

• Hyperion Essbase / Web Analysis

• Development and Maintenance of Legacy systems

• Data Analysis (Quantitative / Qualitative)

• Continuous Process Improvement

• Training Design / Presentation

• Oral / Written Communications

• 25+ years in Information Technology

Software

T-SQL, SSIS, SSRS, SSAS, XML, HTML, .Net, DTS, Ascential Datastage ETL, Crystal Reports, Microsoft Office, JDA – Arthur Planning, Cobol, CICS, Easytrieve, JCL, TSO, Teradata, Hyperion EssBase, Visual Studio, VB, Oracle, VBA, Infopac, Mobius, Execuview, Performance tracking

Pier 1 Imports, Inc. Jan 2007-Present

Applications Programming Specialist

• Worked extensively with Business Groups to develop business requirements for Data Warehousing, with data processes and business logic loaded through Ascential Datastage for Hyperion Essbase Cube with Web Analysis and Reporting.

• Project Manager for reporting initiative to replace ADHOC reporting from MS Access and Excel in Ascential Datastage and SSRS (SQL Server Reporting Services). Documenting requirements and deliverables and overseeing upgrade of Reporting Environment and historical storage via Mobius.

• Creation and usage of testing scripts and processes.

• Quality Assurance testing and validation end to end.

• Extensive trouble shooting, with the ability to research and implement in a timely manner.

• Provided Business and Programming insight into Development and maintenance of OLAP and OLTP Merchandising Systems.

• Developed training materials and provided training for 150+ Business associates on the usage of Merchandising Web Analysis tool (Hyperion essbase).

• Developed data dictionary for 600+ financial measures of Meta data stored in data warehouse. Constructed to provide ease of use by Business Associates of all levels in the organization.

• Data Architect for design and implementation of Data Warehouse using SQL Server Analysis Services (SSAS).

• Migrated data from legacy systems to SQL data warehouse using ETL tools (Datastage, SSIS and DTS).

• Developed Datastage/DTS/SSIS packages to extract, transform and load Transactional data into Data Warehouse.

• Perform tuning and optimization of stored procedures and SQL processes.

• Principle responsibility is to implement support, maintain, monitor and tune high visibility and clustered database systems.

• Worked with Business groups and development teams in design of physical Database Dimensions and Meta data.

• Development and implementation of computational queries in stored procedures.

• Responsible for Change control management documentation.

• Developed and maintained a Financial Planning Application. JDA – Arthur Planning

Pier 1 Imports, Inc. Mar 1998 to Dec 2007

Senior Developer

• Responsible for the developing and maintenance of a Legacy (Mainframe) Data Warehouse System with on-line Web Analysis Tool Execuview.

• Develop and maintain Legacy systems utilizing Cobol, Easytrieve, CICS and JCL (Job Control Language).

• Provided extensive documentation and flow charts of system processes.

• Overseeing of Merchandising Team Legacy system changes and documentation processes.

• Heavily involved in Y2K research and best practices documentation for overall Y2K roll over success across many legacy applications.

• Involved in many data conversion processes to provide cutting edge BI tools for more efficient and better usage of data.

• Participated in Microsoft proof of concept for Data Warehouse initiative.

National Life Insurance Company Sept 1987 to Feb 1998

Applications Programmer/

Business System Support Analyst

• Responsible for development and maintenance of Legacy (Mainframe) Insurance application processes.

• Handled all security set-up and maintenance across company of 300+ employees.

• Provide system support for Legacy applications and network.

• Maintained application software library (Panvela) for the purpose of securing source code.

• Responsible for writing and digitizing Insurance policy forms and applications via XICS (Xerox Integrated Composition Services).

• Developed and controlled an application of change request documents and information for all applicable systems for the company.

• Report development and maintenance.

Contact this candidate