SUMMARY

• Confidential has been working as a professional in the IT industry for over 24 years. He has strong technical expertise and is a dedicated worker who excels at providing clients viable solutions when needed most.
• Confidential is a Consultant with several years of experience in the design and implementation of enterprise wide information systems and BI solutions.
• He has been involved in all areas of the system development life cycle including project management, business analysis, technical business analysis requirements definition, system design, implementation, training and post - production support.
• He specializes in the development of large-scale systems utilizing a Windows based and World Wide Web user interface. He has a strong background in Active Directory and Cognos BI applications, integrated with relational databases. He also possesses a broad knowledge of the system development tools currently available in the market and industry trends in this area.
• Confidential ’s technical skills are complemented by his strong ability to develop excellent working relationships with client personnel. With over 10 years of BI experience, Confidential has played a lead role in implementing Cognos BI applications example: Cognos 11 & 10, Cognos 8, Reportnet, Impromptu, Upfront, IWR, Power Play, Transformer and PPES for several clients.
• The main objective of these implementations was to design Cognos Framework models, OLAP cubes and reports plus configure and implement stable Cognos BI environments while providing key knowledge transfer to client personnel and assisting users in familiarizing themselves with Cognos BI solutions.
• In addition to his Cognos BI experience, Confidential has ETL knowledge working within Microsoft DTS as well as Data Stage.

PROFESSIONAL EXPERIENCE

Confidential

Programmer/Analyst

Responsibilities:

• Participated in requirements gathering sessions with project stakeholders and relevant end - users to gather and analyze business and technical data and requirements for the amalgamated CIDA and DFAIT BI/DW environments. Performed a detailed feasibility study of the technology and cost of the proposed architecture from the context of the Logical Data Model to validate and document functional and system design requirements and specifications to baseline the development plans and support required for this multi - year project.
• Used Cognos versions 8/10.2/11 to design and develop the IBM Framework Manager Model, OLAP Cubes, Report Studio reports and Cognos Metrics to design Framework Manager Model Packages, including Dimensionally Modeled Relational (DMR) and Relational Model packages, as well as canned reports for end users.
• Used IBM Cognos Framework Manager versions 8/10.2/11, including star schema grouping and bilingual functions as well as custom SQL within Framework Manager, to develop the Framework Manager Model to generate dimensionally modeled data within the data warehouse environment.
• Used IBM Cognos Report Studio 8/10.2/11, including bursting reports, to create, edit and distribute canned reports for end users.
• Developed Transformer Cubes for the Cognos 8/10.2/11 BI platform, using IBM Cognos Transformer to build secure and fast data organized into customized dimensions and measures.
• Established and documented design procedures and standards in accordance with IBM best practices and methods for the amalgamated BI/DW solution.
• Developed Relational Model packages using Framework Manager to design star schema data structure to provide a foundation for developing Dimensionally Modeled Relational (DMR) packages for the amalgamated Cognos version 8/10.2/11 BI platform. Developed the DMR packages to enable an OLAP presentation of the metadata, provide drilling up and down capability and a variety of OLAP functions.
• Used built - in Framework Manager tools to create query subjects and determinants to enable multiple - fact, multiple - grain querying capabilities. Created model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.
• Generated and modified code, screens and reports from approved design documentation using SQL, Cognos Framework Manager and Cognos Report Studio.
• Developed visualization of Proof of Concept (POC) data using Cognos Analytics 10.2 and later 11 including Dashboard, Story and Data Modules to provide end users with a POC high - level view of their business data. Level of effort developing visualization in Cognos Analytics 11 was 20 months.
• Used Dashboard module to review, edit and develop POC business dashboards.
• Reviewed, edited and developed POCs for the Grant & Contribution (G&C) business stories, using Story module.
• Used Data modules to import new data fields within Cognos Framework Manager and to design data pre - filters within Framework Manager.
• Performed unit testing and de - bugging for problems identified in system or user acceptance testing.

Confidential

Programmer/Analyst

Responsibilities:

• Collected and analyzed requirements and preliminary analysis materials from project stakeholders to assess feasibility of recommended technologies and architecture design. Used approved business and technical requirements to develop and document functional and detail design specifications in accordance with RUP Modeling methodology.
• Conducted requirements gathering sessions with relevant end - users and then analyzed their proposed changes to the OSFI databases from the context of the Logical Data Model.
• Prepared and implemented coding procedures, application design methods and standards, version control and migration/configuration processes for the design and development of the in - house financial systems using iterative agile development framework and SQL/MDX, SSAS, Cognos report studio and JavaScript.
• Used Microsoft Office, Cognos 10 BI suite as well as MSAS 2014 tool sets to prepare various project documentation for the RRS system integrating with enterprise applications including CEM, P&C, LIFE and RASP including; forms, manuals, technical specifications, design documentation, code libraries, programs, data files, procedures and installation/implementation instructions.
• Developed data models related to the design and development of a 3rd normal form (3NF) normalized data model and report design for the following enterprise applications (CEM, P&C, LIFE and RASP) within a MS SQL server environment to provide canned reports to end users. These data marts were then used to determine the data warehouse changes required to support corporate fact and dimensional data from source to target applications
• Developed a conceptual data model consisting of facts and dimensions for the CEM enterprise applications within a MS SQL server environment. This conceptual data mart included design and development of Relational Data Model packages and Dimensionally Modeled Relational (DMR) packages using a star schema data model.
• Designed and developed Relational Model packages for the Cognos 8 and 10 BI platform as part of developing the star schema data model to meet requirements for list - style reports and to provide a foundation for Dimensionally Modeled Relational (DMR) packages.
• Utilized the star schema data model to develop Dimensionally Modeled Relational (DMR) packages for the Cognos 8 and 10 BI platform to enable an OLAP presentation of the metadata, provide drilling up and down capability and a variety of OLAP functions.
• Used functional design documentation to develop, code, test and implement OSFI’s CEM application code, screens and reports using SQL/MDX, SSAS, Cognos Report Studio and JavaScript within an Agile environment, in response to issues through incremental, iterative work processes.
• Designed and developed models using IBM Cognos Metrics Designer (v.8 and v.10).
• Reviewed existing and developed new ETL (Extract, transform, load) development jobs in order to pin - point problem areas within the proof of concept Data Marts.
• Designed and developed the CEM IBM Framework Manager Model, OLAP Cubes, Report Studio reports and Cognos Metrics within the Cognos 8 and 10 BI platform, working with and in a Business Intelligence Enterprise Data Warehouse, On - line Analytical Processing (OLAP) data and application environment.
• Developed Transformer Cubes for the Cognos 8 and 10 BI platform, using IBM Cognos Transformer functions, to define OLAP cubes structure and data to provide multidimensional analysis capabilities. Performed tasks including defining the dimension map to manage dimensions and levels hierarchy in the data model.
• Developed and coded within the Cognos application using IBM Cognos version 8 and version 10, including IBM Cognos Report Studio 8 and 10, Analysis Studio, Event studio and Cognos Framework Manager to design and develop solution components for loading regulatory returns information received from the Financial and Pension Plan into OSFI’s Master Data Hub (MDH).
• Used IBM Cognos Report Studio 8 and 10 to create, edit and update multi - page and multi - query reports for field employees and the finance department. Created union queries, join relationships and pre - filters.
• Helped in the creation of data marts, which required designing, developing and maintaining the logical data models and data dictionaries for the implementation and creation of database designs.
• Acted as a Tier II and Tier III support go to person for production down issues through phone and email for the CEM, P&C, LIFE and RASP BI report applications.
• Developed a set of application and database development standards as well as instruction on the use and optimization of data modeling techniques for all team members. Provided technical expertise to junior staff. All data models were created using entity relationship diagrams.
• Involved in conducting formal data model reviews against a set of well - defined data architecture standards
• Designed the enterprise Data Architecture so it increases and facilitates the sharing of data across the enterprise.
• Created and maintained roles and responsibilities within the distributed enterprise Data Architecture to facilitate the management of data. This required a working relationship between the business user organizations and information services (IS).
• When designing or modifying a database, reviewed the Metadata Repository for existing standard and proposed data elements before implementing a new database to ensure data elements are defined according to Metadata Repository standards.
• Took the Entity - Relation (ER) model to the third normal form, and then de - normalized where necessary for performance.
• Designed the data access infrastructure to support the transparency of the location and access of data by each application). In return these standards are being used as the benchmark for conducting further data model reviews.
• Provided technical assistance, guidance, direction and advice to end users, executives and director level employees with varying degrees of data knowledge regarding data analysis and modeling.
• Modified and developed MS SQL Server database views, constraints, triggers, stored procedures and user defined functions in order to retrieve data from source to target databases.
• Consulted with business users and the project team on data quality, issues and analysis concepts to ensure that everyone was performing at peak performance. Provided assistance to those who were lacking knowledge in certain areas.
• Involved in the development and troubleshooting fixes for Microsoft SQL Server Analysis Services multi - dimensional cube to address problems found in Cognos Analysis Studio Reports.
• Implemented Cognos 11 POC environment to validate security upgrade process guide lines which included the design and implementation of access security on their Cognos 11 BI platform using Active Directory and IIS via single - sign–on.
• Used CA Erwin 8x data modeling tool to review and help design POC data models to be tested and used as a baseline mart within the development environment.
• Led the development of business models, data models, metadata policies /standards / procedures, common tool sets and approaches.
• As a result of new and updated requirements and specifications, worked with stakeholders to analyze new data and validate all gathered requirements to ensure all updates meshed well with the current database.

Environment: AllFusion ERWin Data Modeller 8.1; Microsoft SQL Server ; Microsoft Visual Studio ; Microsoft Team Foundation Server; Microsoft SQL Server Integration and Analysis Services

Confidential

Programmer/Analyst

Responsibilities:

• Analyzed client documentation and data and performed a detailed feasibility study (technology and cost) of the proposed system architecture to validate and document functional and system design requirements and specifications to baseline the development plans and support.
• Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 10 BI solution
• Analyze and evaluate alternative technology solutions to meet business problems.
• Developed technical architectures, frameworks and strategies, for ADMS group for their systems appeal application area, to meet the business and application requirements.
• Generated and modified code, screens and reports from approved design documentation of the ADMS-SST using IBM Cognos 8 and 10, Oracle 11, Toad 10.6 and SQL 2005 SQL Server 2010 Enterprise. Performed unit testing and de-bugging for problems identified in system or user acceptance testing.
• Designed and developed the dashboards and BI reports within Cognos 8 and 10 Query Studio, Report Studio, Analysis Studio.
• Designed the ADMS Framework Manager Model and OLAP Cubes and drill–through reports within Cognos 10.
• Produced functional specifications, developed, tested and implemented this phase of the ADMS BI Project. Developed Cognos Framework Manager Models and complex reports using Cognos Transformer and Cognos Report Studio within the DEV\UAT and PROD environments.
• Reviewed and recoded PL–SQL scripts, views and logic used within the DEV/TST/UAT and PROD environments.
• Designed and developed models using IBM Cognos Metrics Designer (v.8 and v.10) for Confidential Business Intelligence Project.
• Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8 and 10.
• Identified the policies and requirements to help determine a BI scorecarding solution via metric studio for the ADMS–SST application.
• Formulated and analyzed SQL queries against large databases with over 900 gigabytes
• Created the business information view, analyzed data and published customized reports
• Designed and developed dimensional and advanced analytics/analytical frameworks consisting of facts and dimensional data for sourcing the OLAP data models in a data warehouse environment for the Cognos version 8 and 10 BI platform.
• Utilized a star schema data structure approach to develop the Relational Model packages for the Cognos version 8 and 10 BI platform, providing a foundation for the DMR packages in order to provide OLAP data models in the data warehouse environment.
• Developed Dimensionally Modeled Relational (DMR) packages to enable OLAP presentation of the metadata, including drilling up and down, for the Cognos version 8 and 10 BI platform.
• Worked closely with the client, preparing and conducting JAD sessions to further detail the client’s requirements and also demo POC designs.
• Deploy migration packages to the environments as well as documenting BI build books that details the environments as well as the reports and packages being used within their Cognos 10 environment.
• Provided technical analysis and advice to client management and technical team on the design and development of performance scorecard solutions
• Review ETL jobs in order to pinpoint problem areas found within the ADMS–SST data mart.
• Review application and program design or technical infrastructure design to ensure adherence to standards and to recommend performance improvements.
• Deploy FM packages within ADMS DEV\UAT and PROD environments.

Environment: MS Windows XP; Cognos 10 Suite (Framework Manager / Transformer/ Report Studio/Analysis Studio and Query Studio) Oracle 11, Toad 10.6, SQL 2005 SQL Server 2010 Enterprise, MS Office Suite, Microsoft Visio

Confidential

Programmer/Analyst

Responsibilities:

• Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 10 BI solution;
• Identified the policies and requirements to help determine a particular solution for the LMS application
• Designed and developed BI report specifications, developed and designed dashboards and BI reports within Cognos 8 and 10 Query Studio, Report Studio, Analysis Studio.
• Prepared and conducted JAD sessions with the client and their IT/DBA team
• Produced functional specifications, designed and developed LMS and DQ Framework Manager Model and OLAP Cubes that included trend analysis and forecasting within the OLAP cubes for Cognos 10.
• Tested all elements of the LMS BI Project within Framework Manager, Transformer and Report Studio within the Dev\UAT and PROD environments
• Formulated and analyzed SQL queries against large databases.
• Designed and developed dimensional and analytical framework and dimensional OLAP data models, including Relational Model and Dimensionally Modeled Relational (DMR) packages, for the Cognos 10 BI platform using Framework Manager, Report Studio and Analysis Studio.
• Created a star schema data structure, developing Relational Model packages for the Cognos 10 BI platform to provide a sound foundation for the DMR packages and enable OLAP data presentation.
• Developed Dimensionally Modeled Relational (DMR) packages for the Cognos 10 BI platform to enable an OLAP presentation of the metadata, provide drilling up and down capability and a variety of OLAP functions such as SQL queries to enable more powerful set–based analysis.
• Used built–in Cognos Framework Manager functions as well as star schema grouping and pre–filters to create query subjects and determinants to enable multiple–fact, multiple–grain querying capabilities. Created model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.
• Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8 and 10.
• Designed the LMS portal integrating Cognos Metrics Designer Studio within CFIA’s Cognos 8 & 10 environments.
• Deploying migration packages to the environments as well as documenting BI build books that details the environments as well as the reports and packages being used within the Cognos 8 & 10 environment.
• Created the business information view, analyzed data and published customized reports
• Reviewed and designed ETL jobs in order to extract/transform and load source data into CFIA’s data warehouse consisting of facts and dimensional data elements.
• Implemented new project requirements within their MS Server POC environment working with Microsoft (T–SQL), SSIS and SSAS
• Provided technical analysis and advice to client management and technical team on the design and development of performance scorecard solutions
• Reviewed and designed ETL jobs within Data Manager in order to ETL data within the LMS Data Mart.
• Designed and developed the LMS Framework manager model’s within Cognos 8 & 10 Framework Manager.
• Developed & deployed Framework Manager Packages (v.8 & v.10) within CFIA’s Dev\UAT and PROD environments.
• Documented all design code with regards to the ETL jobs and Cognos Framework manager.

Environment: MS Windows XP; Cognos 8 &10 Suite (Data Manager / Framework Manager / Transformer/ Report Studio/Analysis Studio and Query Studio) Oracle 10, Toad 10.4, MS Office Suite, Microsoft Visio

Confidential

Programmer/Analyst

Responsibilities:

• Identified system and non–system requirements through business analysis of BI requirements and information models, leading to the development of detailed functional specifications and BI project design, including development, test, maintenance and performance usability with the components being used for the client’s BI solution;
• Reviewed OAS canned report specifications, developed and re–designed Canned and OLAP reports within the Cognos 8 BI platform via Query Studio, Report Studio and Analysis Studio.
• Unit tested the OAS reports within the Dev environment in order to setup deployment migration packages.
• Helped in the configuration and usage of their MS Server POC environment working with Microsoft (T–SQL), SSIS and SSAS
• Participated in JAD sessions with the client
• Developed Cognos Framework Manager Models for the IBM Cognos version 8 BI platform, including Relational Model and Dimensionally Modeled Relational (DMR) packages, and validated data accuracy within a star schema data structure comprised of facts and dimensions in a data warehouse environment to enable an OLAP presentation of ADMS-SST metadata, provide drilling up and down capability and a variety of OLAP functions.
• Utilized the star schema data model to develop the Relational Model and DMR packages, creating query subjects and determinants to enable multiple–fact, multiple–grain querying capabilities. Developed model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.
• Upgrade and developed Cognos Framework Manager Package and their Query Studio, Report Studio report and OLAP cube reports from 7.0 to 8.4 to be then upgraded to 10.2.

Confidential

Programmer/Analyst

Responsibilities:

• Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 10 BI solution;
• Developed, designed, collected, translated, and documented business requirements as detailed functional requirements for project design and programming specifications based on clients DBRs to produce high–level project design as well as source to target requirements through the development of dashboards and BI reports using IBM Cognos versions 8 and 10 including Query Studio, Report Studio, Metrics Designer Studio and Analysis Studio.
• Developed technical architectures, frameworks and strategies for the RASD–Reporting group within CRA to meet the business and application requirements.
• Used IBM Cognos versions 8 and 10, working closely with team of Cognos developers to produce detailed functional specifications and participate in the design, re–design and development of Data Marts, Cognos Framework Manager Models, Transformer Cubes and IBM Cognos Report Studio reports.
• Developed operational and ad–hoc reports, using IBM Report Studio version 8 and version 10 to design and develop union queries, join relationships and pre–filters.
• Used Cognos Transformer to develop the Transformer Cubes for the Cognos 8 and 10 BI platform, designating columns in the source files as measures, dimensions and levels. Identified connected data sources and created a dimension map to manage dimensions and levels hierarchy.
• Was part of the BI Architect in–house team to investigate and test new technologies
• Identify the policies and requirements that drive out a particular solution.
• Developed Cognos 8.4 and 10 dashboards using ASP.NET to meet the Confidential Project specifications and technical requirements.
• Conducted analysis and designed applications through solutions delivery methodologies that required a peer review from lead technical Analyst for existing applications;
• Formulated and analyzed SQL queries against large databases with over 900 gigabytes
• Provided technical analysis and advice to client management and technical team on the design and development of performance scorecard solutions
• Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8 and 10.
• Designed and implemented RASD’s Proof of Concept (POC) Cognos 10 staging data mart that offered shared business dimensions consisting of facts and dimensional data elements for CRA’s (22) application data marts via data stage ETL jobs in a data warehouse environment. Developed Relational Models and Dimensional Models using Cognos Framework Manager for this Cognos 10 BI platform.
• Designed and used star schema to create Relational Model packages for the Cognos 10 BI platform, enabling drilling down and up within reports and providing a strong foundation for the Dimensional Model.
• Developed Dimensionally Modeled Relational (DMR) packages for the Cognos 10 BI platform, creating query subjects and determinants to enable multiple–fact, multiple–grain querying capabilities.
• Performed Business analysis and work flow development to help identify the collection, integration and transformation process as well as data quality of larger volumes of data, with data structures ranging from simple to highly complex through IBM InfoSphere, DataStage and QualityStage.
• Analyzed and evaluated alternative technology solutions to meet business problems.
• Prepared and conducted JAD sessions with the client
• Designing and reviewing both Operational and Strategic data marts consisting of facts and dimensions in order to determine re–usability on different platforms, including Windows Server and OS390/OS400.
• Analyzes, reviews, and clarifies high level and detailed business requirement documents, within a large government organization (CRA) which provide details of the system needed to address process enhancements and optimization for business functionality within a project team, in order to deliver a new revised Release Management Process/Version Control Process and there End–To–End overall re–organization process within their BI solutions development lifecycle with key deliverables and R&R tasks;
• Created the business information view, analyzed data and published customized reports
• Develops, analyzes and implements project ideas and elements via project management methodology to solve issues, while working within in all phases of the BI systems development lifecycle (initiation, planning, construction, and implementation);
• Ensured that the integration of all aspects of the BI technology solutions were followed and best practices applied.
• Provided support to applications and/or technical support teams in the proper application of existing infrastructure.
• Formulated statements of problems uncovered within Accounting, taxation related systems Example: (assessment, auditing, appeals, case management, and reporting to discuss with challenges in status meetings;
• Used the Traditional Phased Approach formal management methodology throughout this project. Performed BI related tasks, including analysis, design, development, enhancement and support of operational and Strategic BI reporting solutions through the use of Cognos 8 and 10 reporting application within the BRCDS department;
• Reviewed application and program design and technical infrastructure design to ensure adherence to standards and to recommend performance improvements.
• Reviews operational reporting requirements as (CRs) within CRA’s PSL application to be implemented within BI solution delivery projects where the solution delivery lifecycle is segregated across three (3) sections (Planning, Development, Production Support;
• Costs client change requests (CRs) based on internal BI costing calculator for personal and corporate tax reporting systems example: (T1, T2, T3 and GST).

Environment: MS Windows XP; Cognos 8.4 & 10 Suite (Framework Manager / Transformer/ Report Studio/Analysis Studio and Query Studio) DB2,Data Stage InfoSphere–DataStage, IBM InfoSphere–QualityStage, PS–SQL, CICS, INFOMAN, SMART, PSL, MS Office Suite, MICROSOFT VISIO, IBM DB2 Universal database

Confidential

Programmer/Analyst

Responsibilities:

• Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 8.4 BI solution;
• Integrated bilingual functionality within Framework Manager;
• Analyzed, reviewed, and clarified high level and detailed business requirement documents, which provide descriptions of the system needed to address business functionality within a large government organization;
• Formulated and analyzed SQL queries against large databases with over 900 gigabytes
• Provided recommendations to accommodate business requirements as well as recommendations on database updates in order to implement INFC’s BI solution within a case management, and reporting system;
• Provided technical analysis and advice to client management and technical team on the design and development of performance scorecard solutions
• Created the business information view, analyzed data and published customized reports
• Designed and participated in the development of detailed functional specifications, INFC’s ETL modules (work flows), via Informatica, performed advanced analytics and developed dimensional and analytical Framework and dimensional OLAP data models, including Relational Model and Dimensionally Modeled Relational (DMR) packages for the Cognos 8.4 BI platform within a three tier environment sourcing from multi Relational Database Management Systems, for example: Oracle and UDB/SQL data sourced from Windows Server platforms.
• Developed Relational Model packages, using star schema methodology, for the Cognos 8.4 BI platform to enable drilling down and up in reports and provide a sound foundation for the DMR packages.
• Used built–in Cognos tools to create query subjects and determinants to enable multiple–fact, multiple–grain querying capabilities. Developed Dimensionally Modeled Relational (DMR) packages for the Cognos 8.4 BI platform to provide drilling up and down capability and a variety of OLAP functions
• Created model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.
• Developed, analyzed and implemented project ideas and elements via project management methodology to solve issues, while working within all phases of the BI systems development lifecycle (initiation, planning, construction, and implementation); used the Traditional Phased Approach formal management methodology throughout this project.
• Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8.4.
• Gathered, analyzed and created BI dashboards and reports from Cognos Framework 8.4 and Cognos 8.4 report studio and query studio data requirements in order to help with the designing phase of their both operational and strategic data marts using Cognos as their suite of BI solutions of their project;
• Developed and implemented project ideas and elements within a project team where a formal project management methodology was in use to solve issues, and formulated statements of problems to discuss with challenges in status meetings;
• Reviewed application and program design or technical infrastructure design to ensure adherence to standards and to recommend performance improvements.
• Collected, translated, and documented project business requirements as detailed functional requirements, within all phases of the BI systems development lifecycle (initiation, planning, construction, and implementation);
• Performed BI Designer tasks in, designing, developing, enhancing, and supporting INFC’s operational and Strategic BI reporting solutions, which sourced data from front end applications with 5000+ attributes;
• Design, and programming specifications for INFC’s BI solution delivery project based on clients requirements where a solution delivery lifecycle was segregated across planning, development, and production support sections;
• Prepared and conducted joint analysis discussion (JAD) sessions with the client
• Conducted analysis and design of existing applications in order to implement process enhancements at the application level within the BI development lifecycle;
• Wrote software code and programmed applications within informatica ETL application, developed Cognos Framework Manager Models and Cognos Report Studio that we then reviewed within peer reviews prior to production release.

Environment: MS Windows XP; Informatica, Cognos 8.4 Suite Framework Manager / Transformer/ Report Studio/Analysis Studio and Query Studio) Oracle 10g, SQL 2005/2008 and Oracle.

Confidential

Senior Programmer Analyst

Responsibilities:

• Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 8 BI solution;
• Performed FDM design review and documented the clients requirements for their Data Mart solution through peer reviews and solution delivery methodologies which lead to the planning and development of the functional requirements specifications for the software BI solution project;
• Worked in a large government organization and gathered, collected, clarified, analyzed and reviewed high level and detailed requirement documents, which provide descriptions of the systems needed to address business functionality; Developed and produced BI dashboards and reports from gathered information through the use of IBM Cognos Query Studio and Report Studio;
• Developed detailed functional specifications and developed the Framework Manager Model and its design through a formal project management methodology and based on the Business Unit (BU) requirements;
• Helped resolve BI issues through peer reviews that the client felt could hold–up the release to production of their strategic reports to their accounting, assessment, auditing, and case management source systems;
• Formulated and analyzed SQL queries against large databases with over 900 gigabytes
• Provided technical analysis and advice to client management and technical team on the design and development of performance scorecard solutions
• Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8.
• Designed FM Review document through peer reviews that outlined the client’s requirements for the FM model compared to what was delivered from IT. This was implemented in order to identify key areas of concern that would cause confusion to the client’s end users;
• Prepared and conducted joint analysis discussion (JAD) sessions with the client
• Designed and developed the dimensional and analytical framework and dimensional OLAP data models, including Relational Models and Dimensionally Modeled Relational (DMR) packages, within a three tier environment based on Cognos 8 BI platform sourcing data from multi Relational Databases as well as the EDW for BI solution with advanced analytics.
• Utilized star schema methodology to design and develop Relational Model packages to meet requirements for list–style reports and to provide a foundation for the DMR packages.
• Developed DMR packages for the Cognos 8 BI platform to enable an OLAP presentation of the database metadata to enable dynamic and interactive reporting capability.
• Used built–in Cognos 10 tools to create query subjects and determinants to enable multiple–fact, multiple–grain querying capabilities. Created model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.
• Analyzed, designed, optimized and implemented the Business Unit’s portal application structure and enhanced their security process model with their BI development lifecycle;
• Analyzed, design and documented of the portal structure and security and well as presented a live demo of the design within the UT environment working on different platforms, including Windows Server and OS390/OS400;
• Created the business information view, analyzed data and published customized reports
• Reviewed solution designs within the BI development lifecycle within the initiation, planning, development/construction, and implementation phases and advised developers on best practices and alternative solutions to meet the client’s needs for this data warehousing project;
• Wrote software code and programmed applications designing, developing, enhancing, both Operational and Strategic reports and data marts using Cognos Framework Manager, Transformer and Reportnet as well as Datastage for the BI solution, sourcing from RDBMS DB2, UDB/SQL Server systems containing (2500 +) attributes.

Environment: MS Windows XP; Datastage, Cognos 8.4 Suite (Framework Manager / Transformer/ Report Studio/Analysis Studio and Query Studio) DB2, SQL, CICS, INFOMAN, SMART, PSL, MS Office Suite, MICROSOFT VISIO, IBM DB2 Universal database.

Confidential

Programmer/Analyst

Responsibilities:

• Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 8.4 BI solution;
• Collected, translated, clarified, and analyzed high level and detailed requirement documents, which provide descriptions of the system needed to address business functionality;
• Provided recommendations and clarifications to accommodate business requirements as well as database updates in order to implement LA County’s BI OLAP solution;
• Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8.4.
• Designed and developed seven dimensional and analytical Framework and dimensional OLAP data models, including Dimensionally Modeled Relational (DMR) packages for the Cognos 8 BI platform.
• Developed DMR packages using Cognos 8.4 built–in tools to create query subjects and determinants to enable multiple–fact, multiple–grain querying capabilities. Created model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.
• Prepared and conducted joint analysis discussion (JAD) sessions with the client
• Designed the CognosMetric studio reports integrated with their portal dashboard as well as implemented trend analysis and forecasting within their OLAP cubes.
• Designed and developed BI Reports (Ad–hoc and Canned) as well as dashboards within the Cognos Portal using Cognos report studio version 8 and 10.
• Developed the detailed functional specifications and designed, analyzed and developed LA County’s OLAP Framework model application within their development environment in Cognos 8 Framework Manager and Datastage by applying a Physical/Logical and Presentational design within the internal HR system (eCAPS). Designed and developed Relational Model packages for the Cognos 8 BI platform, designing and implementing star schema to provide list–style reports and create a foundation for the DMR packages.
• Helped in the ETL process by performing code reviews on their current ETL process within Microsoft (T–SQL)
• Formulated and analyzed SQL queries against large databases with over 900 gigabytes
• Provided technical analysis and advice to client management and technical team on the design and development of performance scorecard solutions
• Created the business information view, analyzed data and published customized reports
• Installed and configured Cognos Transformer application integrated within LA County’s Cognos 8 development Environment;
• Reviewed BI object designs and advise developers on migration to production methods;
• Delivered development life cycle builds for break/fix resolution within the development environment for deployment to SYSTEST for testing.

Environment: MS Windows XP; Cognos 8.4 Suite; SQL Server 2008 and 2010.

Confidential

Programmer/Analyst

Responsibilities:

• Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 8 BI solution;
• Helped identify, analyze and review system and non–system application requirements, including the design and performance, usability with the components being used for the client’s data warehouse solution;
• Designed and developed BI Reports (Ad–hoc and Canned) as well as dashboards within the Cognos Portal using Cognos report studio version 8.
• Gathered, collected, translated, clarified, analyzed high level and detailed requirement documents and developed detailed functional specifications, which provide descriptions of the system needed to address business functionality; Cognos Framework Manager Models were developed, documented and designed with program specifications such as security model and portal integration with their on–line web application;
• Implemented their POC scorecarding demo to allow the client to view their data at a management level.
• Formulated and analyzed SQL queries against large databases with over 900 gigabytes
• Designed and assisted in the dimensional and analytical Framework and dimensional OLAP data models, including Relational Models and Dimensionally Modeled Relational (DMR) packages, for the Cognos 8 BI platform within a three tier environment sourcing data from multi Relational Databases as well as the EDW for BI solution with advanced analytics.
• Created Relational Models, using star schema method, to provide list–style reports and provide a foundation for the DMR packages for the Cognos 8 BI platform.
• Created query subjects and determinants using built–in Cognos tools to enable multiple–fact, multiple–grain querying capabilities. Developed Dimensionally Modeled Relational (DMR) packages for the Cognos 8 BI platform to provide drilling up and down capability and a variety of OLAP functions for dynamic reporting.
• Created model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.
• Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8.
• Participated in joint analysis discussion (JAD) sessions with the client
• Provided recommendations to accommodate business requirements as well as database updates in order to implement INFC’s BI solution;
• Installed and configured INFC’s POC environment within CGI’s Sand Box.

Environment: MS Windows XP; Cognos 8.4 Suite (Framework Manager / Transformer/ Report Studio/Analysis Studio and Query Studio) DB2, CICS, SQL 2005/2008 and Oracle.

Confidential

Business/Data Architect

Responsibilities:

• Played the lead role as the business unit’s Senior Programmer/Software Developer and Technical BI Designer; responsible in designing, developing, and enhancing BI dashboards and their operational and strategic BI reports that were sourced from data marts with over 3000 thousand attributes using Cognos 8 Query Studio reports and well as Report Studio report;
• Identify system and non–system requirements through business analysis of BI requirements and information models, which lead to development of detailed functional specifications and BI project design, including development, test, maintenance and production support process documentation;
• Helped resolve BI issues through peer reviews that the client felt could hold–up the release to production of their strategic reports sourced from their accounting, assessment, auditing, appeals, case management systems;
• Delivered to the client an AH–Hoc Report Template document that served as a guild line in capturing Operational and Strategic data marts source elements using Cognos and Datastage within each ad–hoc report test case;
• Reviewed Framework Manager Model designs based on the Business Unit (BU) requirements and resolve BI issues through peer reviews that the client felt could hold–up production release of their strategic reports from the accounting, assessment, auditing, appeals, case management source systems;
• Helped test and logged bugs;
• Participated in joint analysis discussion (JAD) sessions with the client
• Designed, analyzed, and implemented the Business Unit’s portal structure application and security through project management methodologies based on the security model requirements within a large government organizational project;
• Formulated and analyzed SQL queries against large databases with over 900 gigabytes
• Designed and assisted in the dimensional and analytical Framework and dimensional OLAP data models (within a three tier environment sourcing from multi Relational Databases as well as the EDW for BI solution with advanced analytics.
• Delivered design documentation of the portal structure and security and well as presented a live demo of the design within the UT environment with regards to their CORS project;
• Delivered to the client a canned report status documents that served as a status reports detailing the percentage of completion for each canned report requirement sourced from DB2, UDB/SQL Server systems within the planning, development/construction, and implementation phases within CRA’s operational BI reporting environment; Used the Traditional Phased Approach formal management methodology throughout this project.
• Developed Framework Manager Model with steps including calculations, and custom filters that were sourced on different platforms, including Windows Server and OS400 systems;
• Collected, clarified, analyzed, translated, and documented IT FDM Model design. This included the design of an FDM Review document that outlined ways in which the business could enhance and optimize their Data Mart within their BI solution.

Environment: MS Windows XP; Cognos 8.3, COBOL, DB2 SQL, SQL Server, CICS.

Confidential

Programmer/Analyst

Responsibilities:

• Analyzed and elaborated BI business, system, non–system requirements and information models leading to the BI project design, including development, test, maintenance and performance usability with the components being used within the Cognos 8 BI solution;
• Integrated bilingual functionality within Framework Manager;
• Designed and developed BI dashboard and BI report specifications, developed the designed reports within Cognos ReportNet and Cognos 8 report studio, testing these reports within the environments, deploying migration packages to the environments as well as documenting BI build books that details the environments, reports and packages being used for the Report Net Reports.
• Provided recommendations to accommodate and translate business and functional requirements as well as database updates in order to implement INFC’s BI solution within their ETL design and Framework model and BI reports;
• Provided technical analysis and advice to client management and technical team on the design and development of performance scorecard solutions
• Integrated metadata load(s) within Framework Manager via OWB cab files and XML data sources;
• Designed and developed BI OLAP cubes and OLAP reports using Cognos Transformer, Powerplay Client and Analysis studio within Cognos version 8.
• Prepared and conducted joint analysis discussion (JAD) sessions with the client
• Designed, analyzed, supported and developed detailed functional specifications, Strategic and operational data marts using Informatica for ETL modules, developed Cognos Framework Manager Models, Relational Models and dimensional OLAP data models, including Dimensionally Modeled Relational (DMR) packages, for the Cognos version 8 BI platform within a three tier environment by applying a Physical/Logical and Presentational design.
• Developed Relational Model packages, using Framework Manager to create star schema for DMR packages, defining hierarchies and levels and setting scope to relate dimensions to measures.
• Utilized star schema to develop DMR packages for the Cognos version 8 BI platform to enable an OLAP presentation of the metadata including drilling up and down. Created model regular dimensions to represent descriptive data with hierarchical levels, and model measure dimensions to represent quantitative data.
• Gathered, collected and analyzed Framework and report studio data and business requirements in order to help with the design phase of the project;
• Integrated row level security filtering within Framework Manager via Active Directory accompanied by user variable authentication;
• Formulated and analyzed SQL queries against large databases with over 900 gigabytes
• Created the business information view, analyzed data and published customized reports
• Designed and updated Framework Manager Models and OLAP Cubes that included trend analysis and forecasting within the OLAP cubes.
• Developed and implemented project ideas and elements to solve issues, and formulated statements of problems to discuss with challenges in status meetings and obtained approval from the BI manager on the project;
• Installed and configured development and system test environments within INFC’s large government organization;
• Provided migration strategies to new versions of the BI suite of tools within a project team where a formal project management methodology was being used, with peer reviews implemented through solution delivery methodology practices; Used the Traditional Phased Approach formal management methodology throughout this project.
• Documented and supported requirements in ‘use case’ format in order to capture the high level and detailed requirements as well as performed application code design within Cognos Framework Manager, and Cognos Report Studio.
• Integrated and enhanced Cognos auditing within all environments to allow for report monitoring;
• Delivered development life cycle builds for break/fix resolution within INFC’s operational reporting environment for deployment across three (3) tier structure that covered (Planning, Development, Production Support);
• Performed ETL design review and documented the clients requirements for their Data Mart solution through peer reviews and solution delivery methodologies which lead to the planning and development of the functional requirements specifications for the software BI solution project;
• Assisted in the migration of new BI requirements from development to production systems on Window based Server platforms;
• Conducted analysis and design of existing applications in order to implement process enhancements and optimizations at the application level within the BI development lifecycle;
• Investigated and resolved database issues uncovered from the implementation of the BI environment; within the initiation, planning, construction, and implementation phases of the project;
• Performed BI performance tuning, validated BI data source connectivity and provided on–call support;
• Wrote software code and programmed applications designing, developing, enhancing, both Operational and Strategic reports and data marts using Cognos Framework Manager and Reportnet as a BI solution, sourcing from RDBMS DB2, UDB/SQL Server systems containing (2500 +) attributes;
• Implemented new project POC testing within their MS Server POC environment working with Microsoft (T–SQL), SSIS and SSAS.
• Developed, designed, implemented and maintained applications and developed stored procedures, views, triggers, and user defined functions within RDBMS (Relational Database Management System) using UDB/SQL Server 7.0 / 2008 ;
• Applied Security Best Practices (LDAP and row–level Database access) to secure and publicly accessible web–application designs and code.

Environment: MS Windows 2003 platform; Cognos 8.3; MS Internet Information Server ; DB2, Oracle 10g; Microsoft SQL Server.