Project Data
Resume:
Ken Buajitti
PROFILE
Mr. Buajitti is a Senior TM1 Architect with over 30 years of Information Technology experience including Oracle Service Oriented Architecture (SOA), Customer Relationship Management (CRM), Portals, Business Process Re-engineering, Data Modeling and Data Extraction, Business Intelligence (BI), Extract, Translate and Load (ETL), Data Analysis, Full Lifecycle Implementations and Methodologies, Enterprise Resource Planning (ERP), Business Process Engineering, Project Planning, Systems Architecture specializing in Enterprise Performance Monitoring (EPM)
As an IT specialist with a Master’s degree in Information Systems Science, Mr. Buajitti has an outstanding reputation for providing key insight into project direction and implementation.
Mr. Buajitti also has excellent leadership, communication, analysis, problem solving, and presentation skills.
SECURITY CLEARANCE
Level: Secret
File #: 93071733
LANGUAGE
English
EDUCATION
Carleton University
Master of Science (Information Systems Science)
University of Waterloo
Honours Bachelor of Mathematics in Computer Science
Co-operative education program
Cognos ReportNet
Product Professional:
Advanced Authoring; Metadata Modeling; Server Administration
RELEVANT COURSES
Systems Analysis, Databases, Operating Systems, Data Structures, Algorithm Analysis, Computing Theory, Numerical Analysis, Real Time Systems, Intelligent Databases, Artificial Intelligence, Metadata Modeling, SAP FI/CO.
PROFESSIONAL EXPERIENCE
Project 14
Client organization: Indian and Northern Affairs Canada
Role of resource: Systems Analyst
Start and end dates of the project: June 2017 – ongoing
Length of Assignment: March 2017 – ongoing (1 month)
Project Description:
The purpose of the project is to provide information about the effectiveness of funding used to support First Nations Education programs. The system integrates with a Grants and Contributions system that fund First nations Initiatives.
Tasks
Act as a Systems Analyst for the evolution of the Education Information System (IES)
Liaise with Enterprise Architects and subject matter experts in order to understand the business requirements
Deliver design, costing and software requirement documents necessary for each release of the software
These are done quarterly and require liaising with the senior management, the business team, developers and testers to ensure quality delivery
Project 13
Client organization: Canada Border Services Agency
Role of resource: Technical Architect
Start and end dates of the project: March 2017 – April 2017
Length of Assignment: March 2017 – ongoing (1 month)
Project Description:
The purpose of the project is to provide advice on the strategic direction for the IERS technology platforms; with a particular emphasis on case management systems taking into account technical advancements in the IERS case management systems required to manage activities such as risk assessment and intelligence, port of entry operations, criminal investigations, immigration enforcement and recourse. This advice will be used to support the evolution of the IERS technology portfolio, future undertakings and transitions.
Tasks:
Prepare a document comparing Microsoft Dynamics CRM with custom development as a strategic way forward for the Agency to integrate their Enforcement & Intelligence systems on a common platform taking into account the functional and technical requirements of the legacy systems. The focus of the document is on enterprise Information modeling and architecture, data quality management, metadata management, master data management, data integration, enterprise data warehouse integration, business intelligence, web service integration, middleware, disparate databases, operational reporting and ETL frameworks.
Review the “Lessons Learned” from other Government Agencies
Liaise with Enterprise Architects and subject matter experts in order to understand the business requirements
Review “vision documents” in order to understand the desired direction of the department
Review TBS requirements regarding the use of the Shared Case Management System being offered by PWGSC and how it impacts decisions made by CBSA
Review other planned architectural changes such as Master Data Management (MDM), Enterprise Service Bus (ESB)
Review the impact of a development shift to Microsoft and .net versus the legacy Java based architectures and the requirement to re-tool
Review the migration strategy for outmoded and specialized software pieces specifically the Smalltalk / Gemstone (Object Oriented Database)
Project 12
Client organization: Canada School of Public Service
Role of the resource: TM1 Architect
Start and end dates of the project: April 2016 – Feb 2017
Length of assignment: April 2016 – ongoing (11 months)
Project description
Project description:
In support of the Blueprint 2020 vision of “a world class Public Service equipped to serve Canada and Canadians now and into the future”, the Canada School of Public Service (CSPS) is now in the second year of its Strategic Directions Initiative, a comprehensive plan of work between now and 2017 to realign the School’s curriculum, business model and operations to support the entire governmental approach to learning.
Scope:
The Contractor provided the Solutions Team with a number of IT specialists to supplement the CSPS’s internal resources to assist with the operational business line, on an as and when requested basis. This included alignment, integration and addition of Cognos TM1 to the existing Business Intelligence (Cognos BI) infrastructure and Integration of BI components into a single BI Portal including the development and implementation of an Instructor led Planning Model to support the supply and demand of course offerings. Tasks also included development, consolidation and implementation of scorecards, dashboards and operational reporting configuration of middleware, recommendations of best practices
Objectives:
The CSPS IT Solution Team has a requirement for the provision of services from a small team of informatics professional resources to assist with implementation of the IBM Cognos TM1 application and it’s integration to Cognos BI.
Tasks:
Develop and design specifications to meet with client’s needs, requirements and changing objectives.
Design, develop, implement and integrate complex end-to-end business solutions using Cognos BI and TM1 v.10 technical architectures, frameworks and strategies at various stages from inception to support and production (e.g. installation, configuration, administration, performance monitoring as well as support).
Develop and maintain technical documentation including BI business requirements architecture for functional and technical designs, as part of the technology strategy that will ensure the department meets its long term business needs, building prototypes creating cubes, dimensions and rules responsible for creating BI reports and dashboards and User Training.
As the TM1 Developer lead the effort to produce an end-to-end business solution including design, install, making recommendation on configuration and performance tuning and from various sources to the Cognos BI and TM1 v.10 software and ensured the integration infrastructure of all aspects of technology solutions relating to the data warehouse in this distributed environment will are delivered into production.
Created TM1 models using Performance Modeler and Architect on the TM1 side
Created dimensional models using Framework Manager; Cognos tools, Workspace and Workspace Advanced on the Cognos BI side
Troubleshot ETL processes resolving issues such as data formatting, sizing, and dimensional conformity; monitored, tuned and optimized these ETL processes.
In collaboration with other team members, developed and delivered management presentations related to design and implementation. These presentations provided technical designs of various TM1 applications and Cognos BI reports and the participants also provided input as the business requirements were converted into technical specifications; also ddeveloped data warehouse architecture design specifications;
As a TM1 developer designed and integrated TM1 with various Cognos Software and toolsets.
Project 11
Client organization: N12 Consulting
Role of the resource: TM1 Architect
Start and end dates of the project: Dec.2014 – March 2016 (16 months)
Length of assignment: December 2014 – March 2016 (16 months)
Project Title: Sales Automation and Planning Installation
Project Value: $1M
Project description
Project description:
This BI project involved a two tier directive encompassing an installation and configuration of a Microsoft Dynamics CRM system to automate sales and the implementation of an IBM Cognos TM1 / Cognos BI Planning system to manage the budget. The CRM project would envision seeing the existing legacy systems converted to the Microsoft Dynamics CRM platform were the out of the box functionality would be used in conjunction with custom development. Current Controlled goods data is stored in an Oracle database.
Scope: This concept to working system was founded on the process of conducting the profiling, examination of data and the provision of recommendations to the client board in order to gain approval to migrate the data to a customized COTS Microsoft Dynamics CRM product along with the TM1 technology to develop planning models to forecast revenue, expenses and profits. The Oracle database architecture used for their OLTP was also reviewed to ensure that the system was scalable enough to meet future needs. This implementation required a sales automation process that would also integrate with their Microsoft SharePoint 2010 site.
Objectives: To streamline sales by managing contacts, accounts, appointments, processes and capture best practices along with providing the ability to create complex reports in a timely manner. This legacy system conversion would allow for better alignment with business and technology needs.
As a Technical Architect, led the architecting, design, enterprise information modeling and architecture, data quality management, master data management, development and migration, integration and production on this end-to-end business solution using version 10 for both the Cognos BI and TM1 on a distributed environment including providing recommendations areas for improved data warehousing capability, functionality and integration, also developed and maintained Planning Models and a technology strategy that would meet the long term business needs of the client ;
Reviewed their system comparing it to industry trends to ensure that their solution and “way forward” was aligned to these trends. Used excerpts from published white papers to support the thesis
Also provided information, direction and support for emerging technologies and how these technologies changes might affect the current and future solutions based on research
Designed and developed ETL integration architecture and processes and tested ETL data integration mappings/jobs/business logic to meet with client’s requirements.
Developed and delivered presentations to management related to the design and implementation of the Cognos TM1 and Cognos BI encompassing the development and identification of strategies, alternatives, solutions and requirements. The outcome of these presentations was documented and maintained as part of the technology strategy.
Utilized BI best practices in the design/recommending, installing, configuring, and integrating infrastructure to support the implementation to production of the databases, dimensional data models and data marts to support Cognos BI and TM1 v.10 in this distributed environment.
Conducted an on-going review of the system from a technical perspective and recommend ways to optimize and/or simplify it. In order to accomplish this the hardware and software pieces were reviewed and the results were tabled in a report
Utilized TM1 to analyze data and create models to meet with clients’ changing priorities and environment and supported it by implementing databases, data warehouse and data marts.
Developed, led and facilitated sessions/presentations to management and users to document the requirements definition for the sales and marketing process related to the implementation.
Designed, developed and led the configuration, implementation and integration of the Microsoft Dynamics CRM enterprise system including defining custom entities (Manufacturers, HVAC configuration, etc.), extending core entities (Accounts, Contacts, Opportunities, etc.) by the addition of new field, relationships and developing forms as part of the complete software product lifecycle
Proposed and evaluated alternative solutions to meet their business problems including a comparison of CRM to other products, some cloud based
Ensured that all the software pieces integrated with the Oracle database infrastructure from a interoperability standpoint. Test were conducted to validate this
Reviewed software choices and best practices which included standards relating to programming, documentation and testing, data dictionaries, naming conventions, etc. This was accomplished by conducting an overall review of development practices and preparing a paper
As the Technical Architect, interpreted and clarified the functional requirements during JAD sessions to develop multi-stakeholder IT solutions as the project involved data exchange and integration amongst multiple federal departments including PWGSC, Office of the Auditor General and Indian and Northern Affairs Canada.
As the result of JAD sessions, designed and developed technical and business specifications and requirements for several Visual Studio custom reports related to sales pipeline and sales person activity levels.
Provided knowledge transfer to departmental personnel during and at the conclusion of the engagement. This was accomplished through training sessions and through handover documentation
Project 10
Client organization: Environment Canada
Role of the resource: Technical Architect
Start and end dates of the project: November 2011 – November 2014 (37 months)
Length of assignment: November 2011 – November 2014 (37 months)
Project Title: Oracle Discoverer Warehouse
Project Value: $2M
Project description:
Mr. Buajitti was the Technical Architect on this Oracle Financials 11i BI project which involved data exchange and integration amongst multiple federal departments including PWGSC, Office of the Auditor General and Indian and Northern Affairs Canada.
Tasks:
As the Technical Architect, provided analysis of table structures for Oracle modules as part of problem investigation process using SQL and PL/SQL, and designed and developed Change Requests for Reports from the Oracle Discoverer Warehouse enterprise system as part of the complete software lifecycle.
Analyzed and evaluated the current databases existing capabilities and requirements and subsequently developed and documented detailed statements of requirements.
Led JAD sessions develop IT solutions that assisted other team members with data analysis and also made recommendations on course of action to resolve multiple data integrity issues.
Created Change Request Documents and Problem tickets for ongoing issues
Interpreted and clarified business requirements in order to develop test scripts and also conducted tests for business processes in Purchasing, Fixed Assets, Accounts Payables, Accounts Receivables, Enterprise Asset Management, Cash Management, Inventory, iProcurement (eRequisition), General Ledger, the Receiver General Interface (Cluster), DRCTC, and GAC
Reviewed best practices which included standards relating version control and test case preparation. Reviewed these procedures and made recommendations for changes.
Provided information, direction and support for emerging technologies and how these technologies changes might affect the current and future solutions. This included a review of automated online documentation
Led JAD sessions to prepare functional design specifications and requirements and to develop IT solutions.
As part of the part of the software product lifecycle, coordinated with functional leads and attended and contributed to team meetings in which input was received from end users such as production leads and input clerks; also present were other stakeholders such as representatives of the Cluster Group, PWGSC or Canada Post. Reporting requirements were also reviewed with the technical team. This team also consisted of DBAs and Report developers (BI Developers). Additionally, provided training and mentoring to bring resources up to speed with new product features.
As the Application SW Architect, provided advice and identified the business processes, internal controls, policies and requirements to provide possible solutions.
During the conversion process many failures were encountered. These were largely due to the preponderance of pre-existing data anomalies. In order to uncover the nature of these anomalies designed and developed specialized very complex queries utilizing stored procedures, functions and packages within the Oracle RDBMS.
Maintained and evaluated data models at the conceptual, physical and logical levels. Also evaluated existing procedures and methods, identified and documented database content, structure and as a result developed a data dictionary. These were associated with the Data Warehouse which was used for corporate reporting. Work revolved around creating new business areas when required and adding data elements to existing business areas
Ensured that all the software pieces integrated with the Oracle database infrastructure, in particular the structure of business areas in the Data Warehouse were reviewed
Provided knowledge transfer to departmental personnel during and at the conclusion of the engagement including handover and training sessions
Project 9
Client organization: Correctional Services Canada
Role of the resource: Database/IM Modeler, Senior Technical Architect
Length of assignment: February 2011 – October 2011 (9 months)
Project Title: Oracle Upgrade
Project Value: $3M
Project description:
Mr. Buajitti was a Senior Functional Analyst working on an upgrade from Oracle Financials 11.5.10 to Oracle 12.1.3 for CSC.
Tasks:
Reviewed business process requirements and impact of upgrade for PO and G/L modules and conducted business process re-engineering
As Database Modeller/IM Modeller, provided various strategic and tactical recommendations to improve use and implementation of data models, architecture and metadata repositories.
Constructed, monitored and reported on work plans and schedules for improved efficiency.
Ensured that all the software pieces integrated with the Oracle database infrastructure particularly the data warehouse
Reviewed their hardware choices and made recommendations for a sustainable way forward
Reviewed software choices and best practices which included standards relating to programming, documentation and testing, data dictionaries, naming conventions including online help
Reviewed their system comparing it to governments trends such as online documentation/help tools to ensure that their solution and “way forward” was aligned to these trends
Provided information, direction and support for emerging technologies and how these technologies changes might affect the current and future solutions. This was done with special regard to an eventual migration to SAP
Assisted other team members during data analysis, providing input and various technical and logical recommendation on course of action to resolve various data issues.
Identified and analyzed client centric data on this project and integrated related data.
Defined new descriptive flexfields. The change requirements, particularly for PO were very extensive. Some were mandated as part of the upgrade and some were "nice to have". Extensive changes to the definitions of descriptive flexfields had to be made. The final structures took into account competing needs and also had to be vetted through the technical team for feasibility
Kept the project manager apprised so that timelines were honored. The functional leads from the different modules met on a regular basis to ensure that timelines and expectations were being met. When required members from the technical team were also in attendance including DBAs and BI developers. Additional offline correspondence also took place over the course of the project. At times other infrastructure partners such as PWGSC had to be consulted particularly when data exchange was required. Also new resources had to be trained and mentored to enable them to operate the system once it went live
Vital to this project was the migration of legacy data to the new upgraded system. Due to functionality changes, some old structures were obsolete and the data had to be reformatted so that it would continue to function played a key role performing this conversion. Duties included profiling the data to better understand it, uncovering anomalies and fixing them (cleansing) and where possible removing redundancies and consolidating data; utilized the full power of the Oracle RDBMS back-end with complex queries, functions and store procedures to efficiently complete this vital work
Analyzed Oracle data tables for the required modules to determine required fields and design changes for supporting the ERS functionality.
Assisted in the development of Descriptive Flexfields for Purchasing and iProcurement needed for Oracle Financials Shared Services (OFSS) compliance.
The project involved data exchange and integration amongst multiple federal departments including PWGSC, Office of the Auditor General and Indian and Northern Affairs Canada
Reviewed current financial processes and future processes in upgraded environment to determine fit and gaps
Worked on data extraction and conversion scripts, conceptual, logical and physical data models, developed and ran test cases and verified converted data in new upgraded R12 environment to ensure Oracle business rules were being followed for all affected modules. Used Erwin as a modeling tool
Developed, reviewed and amended functional documentation for Financial modules
Developed test scripts and conducted tests for PO and G/L modules in upgraded environment
Worked as part of the Cluster Group team to test and resolve issues with Government Acquisition Card (GAC) and Designated Responsibility Centre Travel Cost (DRCTC)
Also tested the Purchasing, AP, CM, Inventory, EB Tax and iProcurement, OAG, and Central Financial Management Reporting System (CFMRS), SPS, SPS/IS, GAC and DRCTC components of the Cluster Group supplied modules
Provided post-upgrade support in problem resolution with production versions of GAC and DRCTC
Developed and used internal controls such as invoice holds in AP, the use of statistical sampling for invoice approval, data security, approval hierarchies, vendor and customer validation
Provided development and support for CSC in utilizing a control using 3-way matching and Evaluated Receipt Settlement (ERS) for the integration of Purchasing, Accounts Receivable and Accounts Payable.
Derived data from MS Excel and Oracle.
Conducted an on-going review of the system from a technical perspective and recommended ways to recommend ways to optimize and/or simplify it and embodied these finding in a report
Provided knowledge transfer to departmental personnel during and at the conclusion of the engagement including training sessions and handover documentation
Project 8
Client organization: The Ottawa Hospital
Role of the resource: Senior Cognos Architect
Start and end dates of the project: July 2008 – January 2011
Length of assignment: July 2008 – January 2011 (31 months)
Project Title: Planning Reporting and Management (PRAM)
Project Value: $3 Million
Project description:
Project description:
Part of a team that was to select and implement a Planning and Budgeting system for the Ottawa Hospital (TOH). There were two major initiatives within the tenure at TOH, one was to review planning tools and make recommendations and the other was to develop the necessary ETL to load the chosen system.
Scope:
This concept to working system involved multiple stages and the first step was to fully understand the planning process at the hospital and determine the scope of automation. This involved extensive interviews with business users and reported to the project manager. Consultations were also done with a variety of software vendors to determine if their offering was capable of satisfying the needs of the hospital. Once a vendor was chosen the focus shifted to providing ETL services and functional expertise in order to develop a Planning solution.
Objectives:
Develop and automated process utilizing a planning product to create the annual Hospital Budget.
Tasks:
Developed the Requirements Definition document based on gathering business process needs through client interviews in order to re-engineer the existing legacy system
As the Technical Architect, collaborated with various groups and led JAD sessions to gather, analyze and document new requirements and to analyze data in support of developing complex IT solutions for their Business Intelligence and Data Warehouse systems.
Participated in various meetings and JAD sessions to gather and document new requirements, discuss issues, analyzed, interpreted and clarified functional requirements and the outcome data to reflect the client’s changes and needs.
Reviewed software choices and best practices which included standards relating to programming, documentation and testing, Information modeling and architecture, data quality management, metadata management, master data, data dictionaries, naming conventions, etc. This applied in particular to custom software being developed
Reviewed their system comparing it to industry and governments trends to ensure that their solution and “way forward” was aligned to these trends. A substantial part of this project was to provide advice on which software product (COTS) to use.
Proposed and evaluated alternative solutions to meet their business problems which included a list of contending COTS products
Provided information, direction and support for emerging technologies and how these technologies changes might affect the current and future solutions
Reviewed their hardware choices and made recommendations for a sustainable way forward
Conducted an on-going review of the system from a technical perspective and recommended ways to recommend ways to optimize and/or simplify it. Was part of the team that recommended the hardware configuration to support the client’s needs
As part of this DW project, provided input in order to refine data architectures, following client’s needs, objectives and requirements.
Architected, designed, developed and documented working planning system prototypes into production in this distributed environment using v.10 of both Cognos BI, Planning, TM1 and Microsoft Performance Point to provide an end-to-end business solutions.
Architected, designed, installed, configured and implemented TM1 Application to production, ensuring an integrated infrastructure, allowing other Cognos BI v.10 tools to support TM1 v.10 access data, to build, plan and forecast models, providing business solutions, improving the performance and efficiency of the organisation.
As the Senior TM1 Developer used and implemented Cognos TM1 application, to build, plan and forecast models and to analyze data and create models to meet with changing priorities and environment and support it by implementing databases, data warehouse and data marts, following clients’ objectives.
As Application SW Architect, developed and delivered management presentations related to the design, implementation and use of an integrated Cognos BI Architecture, using Cognos BI TM1, following best practices and client’s needs and objectives. Utilized Reportnet (Cognos) to create reporting/data presentation applications and developed and maintained the related technical documentation including an architecture framework and technology migration and implementation strategy in order to meet the hospitals long term business needs.
During the implementation, built and re-modeled the data by using Cognos TM1 to match the forecast standards and scorecard or dashboard specifications.
The project involved designing and developing reports using Cognos ReportNet as part of the software product lifecycle.
Developed ETL needed to extract the personnel information from PeopleSoft and financial information from Oracle Financials which required the design and development of complex queries utilizing stored procedures, functions and packages within an Oracle RDBMS environment. The enterprise system database utilized indexing, query optimization, materialized views, parallelism and partitioning to increase performance as part of the software product lifecycle.
Scheduled and conducted requirements analysis, design, JAD sessions and status reporting meetings
Performed cost and benefit analysis of implementing new processes and solutions by analyzing the financial tracking and reporting requirements and developed business processes to support aims of the PRAM initiative
Acted as a subject matter expert for an Oracle 11i ERP and developed technical frameworks to meet application requirements
Designed and developed ETL to extract and load data from the HRIS (PeopleSoft) and the Oracle Financials ERP (11i) enterprise systems.
Ensured that all the software pieces integrated with the Oracle database infrastructure. Of particular importance was how the Legacy Oracle database
Contact this candidate