Project Data

Fred Adjei seffah

** ********* *******, ************ ** 07840

acxy32@r.postjobfree.com/908-***-****

PROFESSIONAL SUMMARY:

A total of 10 years’ experience in Information Technology with expertise in gathering requirements, project planning, data analysis, and report development with 5 years of SAP BO

SAP implementation: 5 years hands on experience, 2 full life cycle implementation project in Business Object (BO) and 1 upgrade in BO project.

3 years experience in SAP BO Administration to check security( who can access what) and to ensure that user registration as well as monitor the DataBase server.Responsible for scheduling developed reports, published them on the web using Business Objects Enterprise and created test cases for user group training.

Involved in reports and implement Row and object level restrictions. Security Role provisioning for BO Applications by granting user access to create, view, publish

Extensively worked on Business Objects tool 4.0 and 4.1 components and installation in a virtualized and physical environment Universe, WEBI, Crystal Reports and Dashboards.

Experienced gathering business requirements and transforming business needs into efficient and effective solutions for delivering information.

Ability to use live office with data arding and have the ability to use context in live office from WEBI, Crystal report and XCelcius 2008 as well experience on SAP Business Objects Lumira

Complete understanding of BI/BW data flow: DSO, Info Cubes, source system, Info Package, transformation, DTP, Aggregate, MultiProviders and Info Set

Familiarity in Designing/Architecting BI solutions for BW,SD, MM, CO, FI, PP, CRM modules

Strong planning and organizing with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, productivity and profitability

SKILL SET:

SOFTWARE : MS Office, visio & project 2005, MS project server, BEx query designer and Analyzer

SERVERS : Apache Tomcat, MySQL, Oracle 8i,windows 2008 server,PL/SQL, SQL SERVER

OPERATING SYSTEM : Windows(2000 Pro, XP, Vista and servers), Unix

REPORTING TOOLS : MS Excel, Crystal report, BEx, WEBI, Web intelligence Rich Client 4.0,4.1, Dashboard,Tableau,Spotfire, design studio

PROFESSIONAL EXPERIENCE:

Thomas and Betts Corporation 3/14- date

SAP BO Developer/ADMIN

Thomas & Betts (T&B) company provides electrical connectors, HVAC equipment, and transmission towers to the commercial construction, industrial, and utility markets through thousands of distributor locations and wholesalers in North America.

Creating universes and ad hoc reports based on business needs.

Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution.

Involved in Installation, Configuration, and Deployment of whole BOXI R3.1

Created Full client, Web I and Crystal Reports based on Business requirements and Modified the existing Reports based on the specifications and requirements

Created, maintained and modified the business critical reports using the Web Intelligence.

Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.

Analyze the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.

Coordinated and resolved Data Quality issues for smooth migration to production/maintenance of Reports and Universes to different environment within the organization

Hackettstown medical center, NJ Jan 2012-Feb 2014

SAP BO DEVELOPER/ADMIN

The project included the development of SAP Business Objects universes and reports to allow the management team to provide board reports to the end client . Project also involved the gathering of user requirements for reporting .Migrated SAP Business Objects XI 3.1 content (users/user groups, Universes, reports) in to SAP Business Objects XI 4.0 environment using the Import Wizard.

• Resposibilities

Worked with end-users to gather and document requirements for a SAP Business Objects reporting solution

Design business objects enterprise products such as design studio, information design tool, web-intelligence, dashboards, Tableau, spotfire, explorer, and analysis for OLAP, SQL etc.

Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution in Business Process Analysis, Develop & Implement Data mart.

Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports

Set up Universe level conditions to restrict data based on report requirements and Interacted with Business Users and Managers in gathering business requirements.

Created Derived tables in the Designer to enhance the capabilities and performance of the universe and also customized Universe level Prompts as per Functional Requirements.

Environment: Reporting Tools: Web intelligence Rich Client, Crystal Report, Dashboard, Business Explorer (BEx), SQL

Hartford Insurance Nov 2008 to DEC 20012

SAP BO DEVELOPER/ADMIN

The project was to create summary reports about Management review details and region wide Sales reports using SAP Business Objects. Provided various management levels with reports, time series graphs and pie charts using SAP Business Objects.The application helps the field agents of the company to enter prospective customer’s data and also calculateed the amount of premium required, cash value and benefit amount for the years in consideration.

Designed a questionnaire that helps in requirements elicitation from end-users which helps in Universe and Reports Design.

Coordinating with end-users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications

Design business objects enterprise products such as design studio, information design tool, web-intelligence, dashboards, Tableau, spotfire, explorer, and analysis for OLAP, SQL etc.

Worked on Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.

Worked with installing, administration in both desktop and server products of B.O XIR2 on UNIX environment and created users, groups and access rights using Central Management Console.

Created classes and objects in universes using Sql Server 2005 database and also created complex new Universes, Linked with existing Universes from Data marts.

Worked with Crystal Xcelsius for creating simple dashboards and simple crystal reports and convert those in to user interfaces like excel files, PowerPoint representations for better understanding.

Environment: SAP Business Objects XI R2, Crystal Reports XI, Oracle 9i, MS Excel, Windows XP, Xcelsius 2000

EDUCATION :

Masters of Business Administration, Colorado University, 2013

Associate Degree, Computer Science, UCC, 2006

Bachelor of Arts, Economics, UCC, 2006

CERTIFICATIONS:

Software Testing Capstone(Certificate), University Alliance, 2014

Manual and Performance Testing training( SDLC, STLC, Load Runner/QTP tools, SQL), 2012

Contact this candidate