John Kimwele

• Met with customers to gather requirements for new reports and for existing report defects or enhancements.
• Generated ad-hoc reports as specified and developed specifications for other reports and metrics using Workday report writer including the use of calculated fields.
• Designed and implemented Prism Analytics to bring valuable non-Workday data into Workday.
• Designed Prism Analytics solutions to improve report performance and improve security role constraints.
• Provide support for unit testing and End-to-End testing of Workday HCM/Payroll reports, as well as migration of reports
• Created multiple dashboards on Workday Prism data sources (Time and absence, headcount data compared 5 years ago, data discovery, Core HR information)
• Respond to user and compliance requests with accurate and complete data reports.
• Feasibility analysis on PRISM use cases to replace MS Access database.
• Responsible for day-to-day escalations from Tier-1 level support while serving as a liaison with other IT & analytics team in resolving discrepancies with process & data.
• Using advanced ETL techniques, cleanse the data and create workflows and setup automated schedules for data refresh in the database and in PRISM.
• Maintain log of issues for existing reports & document new report needs.
• Analyzed complex sets of data to identify quality issues and proactively initiated steps for improvement.
• Scheduled reports on Daily, Weekly & Monthly basis and Configured Alerts.
• Heavy and daily reporting and data mining using Workday and reporting tools.
• Maintains standard reports inventory, updates and revises as necessary to ensure reports are relevant and provide value.
• Supports the HR management teams to identify the gaps and use data analytics to help improve the processes and operations.
• Work closely with HCM Functional leads for troubleshooting custom reporting issues, resolving the issues in a timely manner.
• Worked on Calculated fields like ESI, EMI, Evaluate expression, Lookup values, Substring, Formatting date, number and Arithmetic calculations.
• Involved in the meetings with business process owners, SME (subject matter experts), and Security Audit team for requirements gathering and actively assisted clients during the testing phase.
• Maintain log of issues for existing reports & document new report needs.
• Analyzed complex sets of data to identify quality issues and proactively initiated steps for improvement. other software tools ie. Hyperion, PeopleSoft
• Enhanced Workday system functionality by implementing customized configurations and integrations.
• Led training sessions to educate end-users on effectively utilizing Workday features, enhancing overall system proficiency.
• Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.

• Worked as a liaison between the United States Recruiting Command (USAREC) and United States Human Resource Center of Excellence (HRCE) on the USAREC project portfolios under development by HRCE.
• Worked with business analyst to guide them in gathering requirements from G2 , G3 and G6 USAREC leadership team and the project managers/users through meetings.
• Worked as technical advisor for USAREC G6 Hyperion reports conversion projects to OBIEE.
• Project was mainly to convert Hyperion reports / dashboard to OBIEE as well as new reports.
• Added required dashboard pages per senior management requirements.
• Peer code review, testing code after migration between environment.
• Worked on OBIEE Analytics to create the reports as per the client requirements (including compound views, table, charts, drill downs) for the Global Organization.
• Worked with the DatasStage ETL team to identify and build the necessary tables in the Data Warehouse for use in our projects
• Redesigned an existing model by examining and reconfiguring the joints on the star schema to improve report performance.
• Created Logical dimensions with Level Based Hierarchies in BMM layer using
• Worked extensively on OBIEE Answers to create the reports as per the client requirements (including compound views, table, charts).
• End user support, trouble tickets and training.
• Work directly with our business partners to understand system requirements
• Leverage product knowledge to identify ways to solve business problem using tool set, always striving to leverage inherent product capabilities, using custom code as a last resort
• Negotiate with the business to simplify complex requirements to leverage product capabilities, where possible
• Provide high-level estimates for different alternative designs to help guide functional design.
• Participate in detailed application design by providing feedback and guidance on available product capabilities
• Participate in proofs of concept to demonstrate design options
• Provide guidance and feedback to development staff
• Review detailed designs prepared by other members of the technical staff
• Provide technical assistance to less experienced staff
• Perform code reviews and verify test plans

• Gathered requirements from Senior Finance and HR Managers/users through meetings,
• Configured security permissions for various application roles to restrict access to specific subject areas and web catalog objects(Dashboards and reports)
• Used OBIEE Admin Tool to develop three layers in the Repository. The Physical, Business Model and Mapping layer and Presentation layer (RPD) analytics. Migrating reports /dashboards between different environments.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Added required dashboard pages per senior management requirements.
• Added relevant projects in the Company RPD for new subject areas, and developed the star schemas using the OBIEE Administration Tool
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Worked on OBIEE Analytics to create the reports as per the client requirements (including compound views, table, charts, drill downs) for the Global Organization.
• Worked with the Informatica ETL team to identify and build the necessary tables in the enterprise Data Warehouse for use in our projects
• Used the OBIEE Admin Tool to develop the three layers in the Repository.(RPD)
• Redesigned an existing model by examining and reconfiguring the joints on the star schema to improve report performance.
• Created Complex Joins, Alias Tables
• Created Logical dimensions with Level Based Hierarchies in BMM layer using
• Worked on OBIEE Answers to create the reports as per the client requirements different report views.
• Customized presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements (including compound views, table, charts)
• Created and configured Interactive dashboards to alert the employees as per the requirements.
• Worked extensively on performance tuning including creating aggregate tables, caching and usage tracking.
• Used the Catalog manager to manage Dashboards, Answers and Delivers.
• Trained user on how to create ad hoc reports.
• Data Sources: Oracle 11g, Enterprise Data Warehouse,Sybase, Microsoft SQL.2007/08/2015
• Involved in Query Tuning to maximize the performance of reports and Dashboards.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.

Involved in customizing out of the box reports to support the business OBIEE Consultant