Amanda Smith

** ******* ***

Townsend, DE *****

cell phone: 267-***-****

Email: ad28av@r.postjobfree.com

I am an information technology professional with more than 20 years experience in the areas of

Business Analysis, Business Object Development, Project Management, Data Warehousing,

Business Process Modeling, Data Integrity/ Governance, Business Process Improvement, Business Process Reengineering,

Design, Development, Test, and support of Business Intelligence environments.

Technical Proficiencies

Reporting Development Tools: Brio, Crystal Reports, Xcelsius, Webi, Cognos, SAP BEX

Databases: MS Access, SQL Server, Oracle 9i

Languages: C, C++, SQL, VB, PL/SQL

Key Project Achievements

Experience

CCHS

November 2017-Present

Systems Analyst

Work with CareVio customers and support Aerial Application.

Maintain Data Integrity of Patient Databases.

Configure Aerial Application and add new functionality.

Work with CLCN leaders to devise the best methods to support new initiatives.

Act as SME of Medecison Business Objects data

Develop SQL queries to meet data needs.

Triage and Assign production support issues.

Edgecraft Corporation

Duration August 2017 – November 2017

Report Developer

Develop / Maintain Crystal Reports

Work with Business to Integrate data from acquired corporations.

Set Guidelines for new reporting / Data requests.

Children's Hospital of Philadelphia

Sr. Programmer/ Analyst

Duration February 2016 – June 2017

Work with internal customers to determine the proper solution to meet their business needs.

Develop methods for displaying data to the customers.

Research data issues.

Gather requirements for IT solutions.

Develop Webi.

Develop SQL queries.

Manage data uploads in grants management software.

Lead a new process implementation within grants management software.

Create and maintain technical documents for grants management software.

Chesapeake Utilities

Report Writer

Duration: July 2013 - March 2015

Work with internal customers to determine the proper solution to meet their business needs.

Develop methods for displaying data to the customers.

Convert existing reports to utilize newly installed technologies.

Research data issues.

Gather requirements for IT solutions.

Develop SAP Business Objects Dashboards using Versions 3.5 through 4.1

Develop Crystal Reports using Versions 2011 and 2013

Develop Webi, Business Explorer solutions.

Develop Business Objects Universes.

Develop SQL queries

Johnson & Johnson / DePuy Synthes

Project Manager Business Systems

Duration: June 2010 - July 2013

Develop Backorder Report to facilitate Internal customer support to manage external client

accounts and purchasing and procurement.

Enhance backorder report to allow for the corporate implementation of this report throughout

Johnson and Johnson.

Develop the Plant Capacity Report to allow the Supply Chain department to efficiently schedule

the plant shifts and build schedules to meet the forecast on time.

Develop Functional and Technical specification documentation templates to adhere to FDA

documentation requirements of the BI system.

Liaison with the business and BI Team to facilitate project prioritization.

Work with the project team to identify potential critical path elements and propose expeditious

solutions that the project team should implement.

Perform software validation for corporate, manufacturing, purchasing, quality and/or inventory in

compliance within FDA regulations

Design, develop and maintain SAP BI/ BO reporting solutions to meet business needs.

Troubleshoot user problems and assist in resolution

Responsible for accuracy and timeliness of project plan and milestones

Manage the execution and logistics of the project plan

Accenture Technology Solutions

Systems Analyst

Duration: April 2003 - February 2009

Project: BW COE Business Objects

Work with peers to create a sandbox environment of Business Objects reports

Project: BW Unicode Upgrade

Coordinate testing of BW 7.0 objects with client team and Accenture India team.

Create Test Scripts for BW 7.0 objects to test for Unicode failure.

Track BW 7.0 Unicode test execution for client team employees and Accenture India team.

Assign duties to Accenture India team.

Coordinate defect resolution with client teams.

Maintain Project plan.

Create client deliverables such as testing plan, contingency plan and scope documentation.

Interview and select Offshore resources to perform testing duties.

Project: BI 7.0 build

Review functional design of reports for continuity within modules

Provide guidance on reporting layout and use of BI 7.0 functionality.

Provide and implement report naming conventions.

Build reports from functional specifications.

Design and Develop GL and Financial BI reporting solution.

Create Technical specifications from report and functional specifications.

Test reports.

Provide support to report testers.

Maintain all report documentation in Solution Manager.

Resolve reporting defects.

Implement naming conventions to ensure coding continuity.

Project: Standard Cost (BW 7.0)

Analyze and design new methods to support business processes.

Assist in translating requirements into test conditions and expected results for product,

performance, and user acceptance testing.

Create test scripts for report and cube validation following BSC documentation standards.

Create reports in Business Explorer following naming conventions and transport standards

Perform informal and formal testing using test scripts

Identify and troubleshoot system or business process issues found during testing.

Participate in quality reviews as outlined in the Project Documentation Plan

Project: CEDW (DuPont) - SAP BW (3.5) Upgrade

Worked with 10 Service Line Leads to manage requirements gathering for BI reporting

environment.

Worked within CMMI5 version controlled environment.

Utilized knowledge of client and environment to guide Service Line Leads to a uniform solution

that fit within corporate goals.

Consolidated 300 existing queries in preparation for build of new system.

Created query specifications using the guidelines for the new system and those set forth by

client.

Reviewed specifications written by other team members.

Represented team in meetings with clients.

Maintained team documentation for new variables.

Assisted in build/specification and review of specs and queries as needed.

Created workbooks for queries according to client specifications.

Worked within an on/off-shore model.

Project: BW Reporting

Build Financial and supply chain reports according to functional specifications.

Create technical specifications for reports.

Documenting new development and updates to existing development for BW reports

Debugging basic problems to address development issues and ensure requirements are met.

Following appropriate work processes and applying BW standards in their work

Ensuring compliance with quality control processes required for development

Project: B2B Migration

Accept support calls from EDI managers at Infineon and Infineon trading partners.

Active monitoring of the B2B email address (both for calls and for automatic emails from the

B2B system)

Investigation of calls to identify the source of the problem

Resolution of standard problems based on documented procedures

Dispatching of calls which cannot be resolved to other entities (e.g. 3rd level support, SAP

helpdesk, IT IFR)

Tracking of open calls (including the ones which have been delegated to internal IFX

departments like IT IFR or B2B 3rd level)

Take primary direction from European offices.

Contact this candidate