Sales Information Technology

DANIEL BALFOUR SIMPSON

***** ***** *****, **** **** Beach Fl. 33412 678-***-**** (Home) 561-***-**** (Cell)

E-mail: ***********@*****.***

SUMMARY

Over 17 years of IT experience, including 6 years as DBA in development and production

environments and 8 years in SAP BI/BW. Designed and implemented efficient and effective

solutions, providing value to clients.

Analytical and communicative team player and leader. Very successful in the integration of SAP

within a business, and in the integration of the SAP modules with each other. Combines an

excellent knowledge of the business with extensive and detailed Database and data warehouse

experience.

Ensure SQL and Oracle database systems operate efficiently and securely.

Skilled in designing and implementing complete life cycle client servers and database

applications with various development tools and languages.

In-depth understanding of security and backup procedures to ensure database integrity.

Superior communication, presentation, analytical and problem solving skill. Work well with all

levels of business.

TECHNICAL SKILLS AND CERTIFICATIONS

ERP: SAP R/3 (ECC 6.0), SAP BW 3.5, and BI 7.0 (NW 2004s)

SAP modules: BW NetWeaver, MM, PP, PAYROLL, FI-CO, and SD.

Programming PL/SQL, C++, Java

Languages:

Databases: SQL Server 2005, MySQL, MS Access and Oracle 10g

Operating Systems: Windows 95, 98, 7, 2000/NT, XP, Vista, Server 2003, Mac, Linux

Platforms: SAP GUI, IBM compatible PC

Applications: MS Office Suite, Adobe Premier, MS Visio, Active Directory

Computer

Networks: Installation and Configuration, Ethernet Protocols, TCP/IP, Router

& Switch Configuration, Routing Protocols, CLI Programming,

LAN/WAN Technologies, Wi-Fi

Certification(s): Oracle Certified Associate (OCA)

PROFESSIONAL/PROJECT EXPERIENCE

Employer: Integrity Computers, Marietta, GA

Industry: Computer

Role: Technology Analyst

Duration: May. 2007 Aug. 2012

Responsibilities/Deliverables:

• Worked on activating the standard Business content InfoProviders-DSO, InfoCubes, InfoObjects,

of Retail Sales Data, including Department Sales, Sales by Region, Campaign Preparation, Sales

by Customer and Customer Visits etc.

• Used extended star schema for data modeling. Creating new data targets i.e. InfoCubes and

DSOs

• Created DataSources, InfoCubes, DSOs and Master Data for incoming sales orders according to

sales organization, distribution channels, ship-to-party customers, material, vendor line items and

creating ledgers

• Data modeling using ERM and extended star schema models. Developed DSOs and InfoCubes for sales and

controlling areas like procurement, cost center and order status

• Designed and Created Process Chains to automate data loads

• Set up source systems to load both SAP/R3 and non-SAP transaction data to BW

• Also required to create MultiProvider on Sales, Deliveries and Billing Info cubes

• Created Generic DataSources for extracting Data through Function Modules-FICO, SD,

MM

• Used Bex Analyzer to define and model queries to satisfy business analysis

• Build and enhance BI Objects such as InfoObjects, InfoCubes, DataSources, Master-

Data, Transformations, DSOs, Extractors, Aggregates and Process Chains.

• Worked with other team members to ensure the delivery of an optimal SAP BW solution

• Implemented database refresh using full export for table level and full database defragmentation,

resulting in improved performance and effective space management

• Created new databases and users: set up backups, export, and other monitoring scripts

• Designed, developed, and implemented automated data backup and restoration procedures

• Provide technical support for database maintenance and disaster recovery

• Used database tool sets to support SQL Server Environment

• Implemented DBA utilities-PL/SQL, T-SQL

• Installed Local Area Networks for various clients-Ethernet standards

• Troubleshooted and supported networks

• Designed, planned, and implemented various communication networks

• TCP/IP Addressing

• Diagnosed and analyzed network systems

• Performed router/switch network hardware/software upgrades

• Network Operating Systems- Windows 2000/2003 Servers,

• Monitored various systems performances

• Installed new software for various business and educational institutions

Employer: AEB Technology, Alpharetta, Ga.

Industry: Software

Role: Database Analyst

Duration: Jan. 2003 June 2006 (Part Time)

Responsibilities/Deliverables:

• Load Master Data into InfoCubes and other InfoProviders from legacy systems and Excel Spread

sheets making them available in Data warehouse.

• Maintained and created Data Transfer Process to include transfer rules, update rules, &

communication structures

• Created aggregates which improve query processing time

• Transferred and activated standard business content

• Created InfoObjects, InfoPackages and process chains

• Identified and resolved issues related to data uploads and manually loaded data

• Ran diagnostics, backed up and recover databases using Oracle Recovery Manager

• Worked with other team members to support the database applications, database server

platforms, and utilized the appropriate tools to maintain a robust database environment

• Used database tool sets to support SQL Server Environment

• Implemented DBA utilities-PL/SQL, T-SQL

• Used Oracle Pl/SQL to develop and test complex queries

• Created new databases, involving importing and exporting: installing and configured database

software for Oracle Application development environment.

• Responsible for Oracle 9i logical and physical databases design, implementation, and

maintenance

• Handled database server tuning, application tuning, maintaining documentation, capacity

planning and database security

Employer: Atlanta Public Schools, Atlanta, Georgia

Role: Mathematic/Computer Teacher

Duration: August 2005-May 2010

Duties/Responsibilities:

Taught Information Technology and Mathematics to sixth (6th) Grade through eighth (8 th) Grade

Used Information Technology to integrate the teaching of Reading, Science, Mathematics, Language

Arts and Social Studies

Assisted in maintaining order and discipline in the school environment

Employer: Southern Polytechnic State University, Marietta, Ga.

Role: Graduate Teaching Assistant (IT/Software Engineering Dept.)

Duration: Jan. 2004–May 2004

Duties/Responsibilities:

• Assisted professor with students’ research presentations/assignments

• Lead a team of graduates in the development of a software project to simulate the management

of a clinic

Employer: Catholic Board of Education; Sts. Francis and Joseph Catholic School, Nassau,

Bahamas

Role: Information Technology Teacher

Duration: Jan. 2001-June 2001

Duties/Responsibilities:

Installed Local Area Network within the school, trouble-shooted and supported computer systems,

installed and configured software packages to suit the classroom environment

Used Information Technology to integrate the teaching of Reading, Science, Mathematics, Language

Arts and Social Studies

Instructed other members of staff in the use of the computer to teach various subjects in their

classrooms

Employer: Catholic Board of Education; Aquinas College, Nassau, Bahamas

Role: Mathematics & Science Teacher

Duration: Sept. 1987-June 1995 & Sept. 1997-June 1999

Duties/Responsibilities:

Developed my computing skills while teaching Mathematics and Science for ten (10) years at Aquinas

College

Used computer as a teaching tool specifically in the areas of Mathematics and Science

LEADERSHIP AND MANAGEMENT

Aquinas College in Nassau, Bahamas

o Head of the Mathematics Dept. Sept.1988 - Jun.1991

o Extra Curricular Activities Coordinator.

EDUCATION

Master of Science - Information Technology Dec. 2004

Southern Polytechnic State University, Marietta, Ga.

Bachelor of Science - Computer Science Dec. 2002

Southern Polytechnic State University, Marietta, Ga.

CISCO CCNA1 : Southern Polytechnic State University Fall 2004

ORACLE CERTIFIED ASSOCIATE (OCA)

Contact this candidate