Candidates About

Jacob Agyemang

SUMMARY

I am a highly motivated technology professional with several years of experience in almost every stage of a Software Development using various technologies. My strengths include excellent communication skills, strong programming skills, Microstrategy, IBM Cognos framework Manager, Cognos Report Studio, Data Modeling, Reports and Dashboard Development, Administration and Configuration, Mobile, Customization, Data Warehouses and the ability to learn or overcome any challenge presented. I recently completed training in Big Data and Hadoop; Big Data and NOSQL from DePaul University. I am also enrolled in MBA and Data Analytics program at Lindner College of Business, University of Cincinnati, where I have taken course work in SAS, R and Business Analytics:

·         Hand on experience with Microstrategy suites of products including SDK and administrations

·         Experience in dimensional and relational modeling, creating data warehouse, star and snowflakes schema, ETL

·         Extensive experience in developing report, documents, dashboard and mobile applications

·         Extensive experience with IBM Cognos framework manager modeling, cubes, package creation, product support

·         Extensive experience with IBM Cognos Reports, active report and Dashboard creation, workspace advanced

·         Experience in all aspects of Software Development Life Cycle (SDLC) including requirements analysis, design specification, development, integration, testing and deployment using Object Oriented Analysis and Design

• Extensive experience in multiple domain, including banking/financial, healthcare, manufacturing, aviation, military
• Experience in Agile Software methodologies, including agile, waterfall, scrum, leadership and project management
• Hand on experience in designing and developing business application using Tibco, Java, and J2EE
• Experience working with various databases, including Oracle, MySQL, SQL Server, DB2, Teradata
• Hand on experience in creating stored procedures, functions, packages, Triggers, Cursors using SQL, PLSQL.
• Consistent team player with excellent communication and problem solving skills with a can-do attitude

EDUCATION

University of Cincinnati, Lindner College of Business, Cincinnati OH

MBA Candidate - Data Analytics                                                                                                     Expected - December 2016

New Jersey Institute of Technology, Newark NJ

Master of Science - Management                                                                                                                              May 2010

Bachelor of Science - Information Technology                                                                                                        May 2009

University of Cape Coast, Cape Coast, Ghana

Bachelor of Science - Agriculture Science                                                                                                                June 2003

EXPERIENCE

Rumpke Waste and Recycling, Cincinnati OH                                                                                 August, 2015- Present

Data Analyst and BI Developer

• Used IBM Cognos, SQL Server and other Applications to develop business Intelligence applications to monitor trucks performance and maintenance, landfill equipment, revenue and customer behavior.
• Utilized IBM Framework Manager to model data and create query subjects and publish packages from various data sources to be used for creating report, dashboard, events schedule and other BI objects
• Created report schedules, generated different kinds of reports in Cognos 10.22, created templates and multi user reports, and workspace advanced dashboard
• Created code and Report /Dashboards migration across environments (DEV, SIT, UAT, Prod)
• Used Cognos TM1 to create cubes, dimensions, view, processes, chores and other related objects to create budgets and other financial calculations
• Worked closely with different business teams to gather requirements, prepare functional and technical documents
• Developed and maintain Business Intelligence solutions utilizing the Enterprise Data-model Architecture
• Managed projects from end to end and work with team to development standards for data definitions, manipulation and mapping and business processes and developed Technical Specifications and Mapping Documents
• Worked on troubleshooting and resolving Business Intelligence data-related issues and supporting new and existing applications and source systems.
• Created and maintained stored procedures, views, tables and BI objects to monitor business performance and processes.
• Administer IBM Cognos, assigning roles and groups to users. Created schedules to distribute reports and other objects to users based on their roles and access levels.

Sogeti USA, Cincinnati, OH                       

Senior Consultant, General Electric Aviation, Evendale OH                                                          May 2013 – Aug 2015                                                   

• Used IBM Cognos, Oracle, Informatica, Spotfire and other Applications to develop business Intelligence applications to monitor Aircraft engine performance
• Worked closely with different business teams to gather requirements, prepare functional and technical documents
• Conducted research on the best BI tools for developing specific applications and installed software application

• Utilized IBM Framework Manager to model data and create query subjects and publish packages from various data sources
• Generated different kinds of reports in Cognos 10.21, created templates and multi user reports, and workspace advanced dashboard
• Designed database tables, resolved issues in data warehouse; designed data warehouse model for reporting
• Resolved issues in Data Warehouse and Cognos Framework Manager Models and provided product support
• Managed scripts, cubes refreshes, report runs and notifications using Cognos Event Studio 
• Developed reports and dashboard for upper managers and power users with Tibco Spotfire
• Used Tibco Spotfire to create dashboards to measure aircraft engine performance and maintenance history
• Created code and Report /Dashboards migration across environments (DEV, SIT, UAT, Prod)
• Modified Java application to automate data migration process
• Used informatica to create mapping and data migration from multiple sources to military data warehouse
• Create highly interactive Microstrategy dashboards by using Visual Insights that replaced legacy reports
• Created several Custom tables, Views, Aggregations and Macros for developing reports used in Microstrategy environment. Modified Data Warehousing tables and other objects to facilitate report development
• Generated Microstrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Used Administrator tools like Project Merge and object Manager to move the objects between environments
•  

Microstrategy Inc., Tyson Corner VA                                                                                               January 2012 – April 2013

Consultant

• Attended Microstrategy Boot Camp to get trained and certified on Microstrategy BI platform and worked as a consultant for their clients, including; National Government Services, Huntington Bank, Sprint Network, Novation, Axtria, Gordon Food Services, Fruit of the Loom, Limited Brands
• Prepared development and production environment for Microstrategy product installations, upgrade, configurations, administration
• Performed testing of sample reports to get baseline for verification against reports in new upgraded environment; Upgraded Microstrategy from 9.0.1 to 9.3.0 HF3; I-server on Window Server 2008 and Web server on UNIX; Performed post upgrade testing and documentations
• Created DNS connections from Microstrategy to data sources; Created Metadata Repository and Statistical tables, Intelligence Server and Project on Microstrategy Desktop using the Configuration Wizard
• Created several Custom tables, Views, Aggregations and Macros for developing reports used in Microstrategy environment. Modified Data Warehousing tables and other objects to facilitate report development
• Generated Microstrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Used Administrator tools like Project Merge and object Manager to move the objects between environments
• Worked with Microstrategy Intelligence Server, Microstrategy Web and Microstrategy Administrator reporting basic using Microstrategy Desktop and Microstrategy Web
• Involved in troubleshooting Microstrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment
• Created complex custom groups using hierarchy to overcome the restriction of Microstrategy where total on columns and average on rows cannot be calculated at the same time
• Created Intelligence Cubes to be used as data source for report services documents, dashboard and mobile applications; Used SDK to customize web portal to reflect Company's logos and color palette
• Designed various prototypes of dashboards using Microstrategy, which would give ability to the users to drill up and down to enhance business analysis and decision making
• Created Dynamic Dashboards showing company's yearly performance using various graphs and widgets

Cerner Corporation, Kansas City MO                                                                                        October 2011 – January 2012

Software Engineer

• Served as member of the IP Factory team, which developed various applications to support Cerner processes

·         Used JavaScript to develop gadget to display packaging platform dynamically

·         Modified Hibernate Objects, Mappings, Groovy and Grails Controllers and JavaScript frontend to make the packaging gadget work with the new rest API

Tata Consultancy Services, Cincinnati OH                                                                                      June 2010 – October 2011

Software Engineer – Freddie Mac Midas Reengineering Program, Mortgage Loan Servicing

• Helped convert Freddie Mac’s Mortgage Loan Servicing Application from mainframe to web base application

• Worked with business and subject matter experts to identify business requirement and changes in process
• Documented business requirement and translated those requirements to high level and low level system design
• Prepared design documentation and submitted to SME for approval
• Installed and configured Tibco ActiveMatrix BusinessWorks
• Installed and configured eclipse, Oracle database, Apache Tomcat, and JDeveloper. Created XML Schemas in terms of request and response object for each web services application and shared resources
• Used Tibco BusinessWorks to develop WSDL for each operation
• Used eclipse to create schemas for testing the process developed with Tibco BusinessWorks
• Prepared test cases and used Soap UI to test all services from end to end to make sure that they work to plan
• Worked with Java and User Interface team to integrate all the process into a single unit
• Integrated multiple modules to a single unit and performed integration testing to ensure that the application works correctly

• Identified test scenario from Requirement and other business documents
• Developed test plans and scope of testing. Prepared test data based on business rule and system design documents
• Loaded the test cases into HP Quality Center and Executed test cases to make sure of correct performance
• Met with Business, SME, and development team to discuss defect identified, clarify all issues and make sure that defects are fixed and solution deployed for retest. Performed regression testing of the whole application to make sure that no new defects are introduced as a result of the recent fixes
• Document results and presented test results to business to ensure that all requirements were captured and also that application works as expected

     Sunghai Technology and Technology Services, Cincinnati Oh                                                  June 2007 – Present

      BI Consultant                                                                            

·         Installed and configured Microstrategy. Create user group, User command manager to manager users and objects.

·         Responsible for efficient design and usage of various attribute dimensions like Customer, Product, Payment, Geographic and Time dimensions, and integrating them into reports displaying forecasting metrics

·         Responsible for designing and executing Application objects and Schema objects using Microstrategy Desktop.

·         Produce Ad-Hoc queries and reports as needed along with providing on-going analytical support for these requests with metrics, attributes, relationship filters, and prompts to support reporting

·         Create highly interactive Microstrategy dashboards by using Visual Insights that replaced legacy reports

·         Worked closely with different business teams to gather requirements, prepare functional and technical documentation, development and deployment of software applications.

·         Create, maintain and modify Attributes, Metrics, Filters, Facts, and Hierarchies.

·         Used applications such as oracle, MySQL, SQL Server, MS Access, Excel, Microstrategy, Cognos, PHP, Java and others to develop software applications to support small business operations in the United States and Ghana

·         Installed and configured software application, created user account and load data for multiple businesses

·         Used Erwin, Visio and other tools to create Database and Data Warehouse models and ER diagrams

·         Created tables and imported data, created mappings based on requirements, and developed reports and dashboard

·         Created SQL procedure and functions to automate business process

• Document results and presented test results to business to ensure that all requirements were captured and also that application works as expected
• Installed, troubleshoot, and repaired technical problems for computer systems, including laptops, desktops, printers, modems
• Wrote PHP program to connect database to the web and performed web application testing
• Create reports and Microstrategy, Tableau and Spotfire to create visualizations to measure and analyses business performance

TECHNICAL SKILLS

CERTIFICATIONS

Microstrategy University, Tyson Corner, VA                                                                                                 February 2012

• Microstrategy Report Designer
•  Microstrategy Document Developer
• Microstrategy Report Developer
• Microstrategy Certified Developer

International Business Machine (IBM)                                                                                                          September 2013

• IBM Certified Designer - Cognos 10 BI Reports
• IBM Certified Developer - Cognos 10 BI Metadata Models

Certificate Programs, DePaul University, Chicago IL                                                                               November 2014

·         Eleven (11) week training in Big Data and Hadoop

·         Eleven (11) week training in Big Data using NOSQL