TECHNICAL SKILLS:

• Cognos Applications
• Cognos 10 all studios
• Cognos 8 Report Studio, Query Studio, Analysis Studio, Metrics studio, Framework Manager
• Cognos ReportNet
• CognosMetrics Manager
• Cognos ReportNet
• LDAP/Access Manager
• Cognos PowerPlay
• Cognos Transformer/Rsserver
• CognosUpfront
• Cognos Enterprise server
• Cognos PowerPlay Web
• Cognos Impromptu
• Cognos Impromptu Web Reports
• Cognos Visualizer/Viz web
• Cognos Decision Stream
• Adaptive Analytic Framework
• Go Mobile
• Operating Systems/Networks/Web Servers
• Unix, (Solaris, AIX, HPUX), Linux
• Windows (all)
• IIS 3, 4, 5
• Netscape Enterprise server
• Netscape Directory Server
• Netscape FastTrack server
• X - windows, Metaframe
• Netscape Proxy Server/SSL
• Iplanet Web server
• Apache Web server
• DominoWeb Server
• SQL
• Cognos Script
• Cognos MDL Script
• Visual Basic
• WinRunner
• SourceSafe
• Win CVS
• Teradata, Databases, Oracle, SQL server, Access, Sybase, DB2
• SQL Navigator
• DB Visualizer/Toad etc.
• MS office suite of tools

PROFESSIONAL EXPERIENCE:

Confidential

Senior Cognos Developer/Business Analyst

Responsibilities:

• Confidential worked with the business to develop reports for Food Sales and HR.
• Confidential was brought in to deliver a suite of reports that were months behind schedule.
• He was successful in delivering the reports meeting new delivery dates.
• Developed dashboards for Food department using Cognos workspace and provided user training using workspace and workspace advanced... Also responsible for clarifying requirements, modifying specs and defining actual needs of clients.

Confidential

Senior Cognos Developer/Architect/Administrator/Business Analyst

Responsibilities:

• Confidential was responsible for developing reports, Framework Manager Models and deploying packages to meet business needs.
• Confidential worked closely with the Data Modelling and ETL teams to define requirements for business needs.
• He was also instrumental in designing and implementing a new security model to enable the roll out of Cognos reporting to 2000 branches.
• He was also tasked with delivering time-sensitive solutions for high profile reporting needs.
• Worked on multiple projects concurrently (upgrade to 10.2.2, freight project, security implementation for example).
• Produced Planning and strategy documents as well as best practices documentation.

Environment: Windows, SQL Server, Cognos, PeopleSoft

Software Environment: Cognos 8.1, 10.1, 10.2, Transformer, Report Studio, Framework Manager, Metrics Studio, Workspace and Workspace advanced, Query Studio. SQL Server 2008, 2012,, Neteeza

Methodologies: Star Schema/Kimble, ODS, Transactional, SDLC (software development Lifecycle)

Confidential

Senior Cognos Developer/Administrator/Business Analyst

Responsibilities:

• Confidential uses Cognos as the primary corporate reporting system.
• Confidential was tasked with supporting a mixed version environment (7.x, 8.x and 10.x),
• He was also responsible with resolving old issues, development, Business Analysis and architectural advice for a new environment.
• The Tools used included all Cognos BI tools.
• Confidential was also responsible for the development of QA testing scripts and delivering Cognos training to various teams in the organization. Facilitated business workshops/Training/Fact gathering sessions for Finance team.

Environment: Windows, SQL Server, Cognos, JDE

Software Environment: Cognos 7.4, 8.1, 10.1, 10.2, Transformer, Report Studio, Framework Manager, Metrics Studio, Workspace and Workspace, Query Studio. SQL Server 2008, 2012,, JDE Transactional Database, Tableau

Methodologies: Star Schema/Kimble, SDLC (software development Lifecycle)

Confidential

Senior Cognos Developer/ Business Analyst

Responsibilities:

• Confidential was asked to return to Confidential to complete and deliver numerous outstanding items that were not being addressed by the Business Intelligence team.
• Confidential was responsible for creating cubes, reports, define processes, create stored procedures for use in Cognos reports create Framework Manager Models, and act as a mentor/provide training to other team members.
• Create Stored Procedures in SQL Server to facilitate reporting.
• Created dashboards using Workspace and Workspace advanced reports.

Environment: Windows, SQL Server 2008, 2000

Software Environment: Cognos 10.1, 10.2, Transformer, Report Studio, Framework Manager, Metrics Studio, workspace and workspace advanced, Query Studio. Event Studio, Go Mobile, MS Office, Excel, VB, VBA macro automation of excel. ODS, Transactional systems

Methodologies: Agile Methodology, Star Schema/Kimble

Confidential

Senior Cognos Developer/Support/ Business Analyst

Responsibilities:

• Confidential was hired for a short contract as a Cognos Developer/Architect.
• Implemented Cognos solution for Confidential . Confidential was responsible for development of IBM Cognos cubes, Framework Manager Models and report development as well as the implementation on the reporting system.
• Worked to test and validate reports and troubleshoot issues with existing reports.
• Test and maintain existing FM Models as well as develop new models.
• The primary dashboard used Cognos workspace. Worked on Multiple projects concurrently ( example, promotion sales analysis and dashboard) provided promotion Sales document for reporting strategy using Cognos.

Environment: Windows, Oracle Kalido

Software Environment: Cognos 10.1, 10.2, Transformer, Report Studio, Framework Manager, Metrics Studio, Business Insight( now workspace and workspace advanced), Query Studio. Oracle, Active Reports. Dynamic Cubes

Methodologies: Agile Methodology, Star Schema/Kimble

Confidential

Senior Cognos Developer/ Business Analyst

Responsibilities:

• Confidential was responsible for the development of a series of complex dashboard reports and Transformer cubes.
• Identifying reporting requirements of the business and implementing the business reporting system.
• He worked closely with the business to determine detailed specifications and identify areas where reporting improvements could be made. Confidential used SQL server 8.0 to develop custom queries for data validation and to explain anomalies in the data.
• He also developed and presented a Metrics Studio POC using the clients’ data to present one possible solution to meet mandated reporting requirements of the new fiscal year.
• He also developed and delivered training material for one on one and classroom training.
• As part of the Revenue Management team he worked with numerous volumetric reports as well as financial reporting.
• Confidential also worked to test and validate reports and troubleshoot issues with existing reports.
• Test and maintain existing FM Models as well as develop new models. In the SQL Server 2008 solutions Confidential also wrote complex SQL statements to support Cognos solutions in the form of Views, stored procedures etc.

Environment: Windows, SQL Server 2008, 2000

Software Environment: Cognos 10.1, 10.2, Transformer, Report Studio, Framework Manager, Metrics Studio, Business Insight (now workspace and workspace advanced), Query Studio. Event Studio, Go Mobile, MS Office, Excel, VB, VBA macro automation of excel.

Methodologies: Agile Methodology, Star Schema/Kimble

Confidential

Business Analyst Cognos Systems Analyst/ Business Analyst

Responsibilities:

• As an Employee of Confidential was tasked with working closely with all clients and carrying out the responsibilities of a Systems analyst and developer.
• The roll Confidential held was all encompassing including development, maintenance of over 1000 financial reports, cube development, architecture management, report spec definition and implementation of business systems.
• Confidential also worked to test and validate reports and troubleshoot issues with existing reports as well as test and maintain existing FM Models as well as develop new models.
• During his time at TransCanda Pipeline Confidential was engaged in a data mart development initiative to replace an existing home grown solution as well as the validation the Cognos environment to support the new solution.
• Confidential was a key part of the project scoping process including ETL tool selection (AAF, SSIS, Data Stage) Confidential developed the Conceptual and Logical data mart Star Schema design for the mart and identified the transformations and data mappings required for the ETL team.
• Confidential was also involved in interviewing candidates for employment.
• Developed BI Roadmap for the future implementation of Cognos at TCPL as well developed business case for the introduction of Query studio for user consumption and self-serve reporting. .

Environment: Windows, Oracle 11g

Software Environment: Cognos 10.1, Transformer, Report Studio, Framework Manager, Metrics Studio, Business Insight, Query Studio. Event Studio, MS Office, Excel Cognos 8.4, Oracle Discoverer, VB Automation, TM1

Architect, Developer, Business Analyst, Trainer/Course Developer, Project lead, Data Modeler

Methodologies: SDLC (software development Lifecycle),Star Schema/Kimble Relational, ODS

Confidential

Cognos Developer/Systems Analyst/Business Analyst

Responsibilities:

• Confidential was responsible for developing a series of key reports as well as working to migrate a variety of Cognos environments and platforms ( Series 7, Reportnet, Cognos 8.1, Cognos 8.2) to a consolidated Cognos 10 platform.
• This initial 6 month contract has been extended for an additional 6 months.
• Confidential also reviewed the possibility of implementing IBM Cognos Adaptive Analytic Framework at Confidential as a solution to streamline the current solution implementation cycle. Confidential assisted in the Conceptual and Logical data mart design for the repository used in this project.
• Developed Cognos 10 planning roadmap for the implementation of the latest version of Cognos 10 as well as validating the resulting environment and reports. Assisted in the transition of some Cognos reports to Jasper Reports.

Environment: Windows, Oracle 11g

Software Environment: Cognos 10.1, Transformer, Report Studio, Framework Manager, Metrics Studio, Business Insight, Query Studio. Event Studio Cognos 8.4, Go Mobile, MS Office, Excel, Jasoer Reports

Methodologies: Agile Methodology, Star Schema/Kimble, ODS, Relational

Confidential

Senior Systems Analyst/ Business Analyst

Responsibilities:

• Confidential was responsible for assisting in the sales cycle, managing projects, account management and delivering solutions He was also responsible for working with and mentoring other resources.
• He also developed and delivered training solutions and participated in strategic planning sessions for the organization and Implemented business systems, validated environments and content. Confidential also developed business cases as part of the sales cycle to clients and while at Alta gas developed a Cognos roadmap to plan out the next 5 years. As part of a Cognos upgrade to Version 10 at Alta Gas and FGL Confidential carried out the planning and validation of report validation and performance.
• Confidential also worked with various data sources including Oracle, SQL Server 2008, 2005. Confidential also worked briefly with Data manager while defining an ODS system at Alberta Financial as well as creating a TM1 solution for the budgeting process.
• Provided service to multiple clients concurrently and worked on pre-sales presentations. Used stored procedures to be used in reporting.

Confidential

Environment: Windows, SQL Server 2008, 2000 Oracle 10g, Oracle 11g

Software Environment: Cognos 10X, Transformer, Report Studio, Framework Manager, Metrics Studio, Business Insight, Query Studio. Event StudioCognos 8.4, Go Mobile, AIX, HPUX, MS Office, Excel, VB macros. Data Manager TM1. MySQL, Tomcat

Methodologies: Agile Methodology, SDLC (software development Lifecycle), Star Schema/Kimble, ODS, Relational, MOLAP

Confidential

Cognos Centre of Excellence Analyst/ Business Analyst

Responsibilities:

• As a member of the IBM Cognos Centre of Excellence Confidential is tasked with product evaluation, recommending architecture and solutions to over Confidential client groups and assisting in resolving issues, providing formal and mentor training. Produce business process documentation.

Environment: Windows, SQL Server 2008, 2000

Software Environment: Cognos 10.1, Transformer, Report Studio, Framework Manager, Metrics Studio, Business Insight, Query Studio. Event Studio Cognos 8.4, Go Mobile, MS Office, Excel

Methodologies: Agile Methodology, SDLC, Star Schema/Kimble, ODS, Relational, MOLAP

Confidential

Senior Solutions Architect/Developer/Business Analyst

Responsibilities:

• Confidential returned to PSC to assist in the development and migration of over 150 reports against the newly created reporting schema. Confidential completed the task successfully.

Environment: Windows, SQL Server 2005, 2008, Oracle 10g

Software Environment: Cognos 7.4, 8.4.1 Transformer, Report Studio, Framework Manager Studio, MS Office, Excel

Methodologies: SDLC (software development Lifecycle), Star Schema/Kimble, ODS, Relational, MOLAP

Confidential

Senior Solutions Architect /Business Analyst

Responsibilities:

• Confidential was hired to develop and deliver a series of Cognos Metrics Studio scorecards.
• He was responsible for working with the business and developing the approach, requirements and implementing the business systems/solution.
• While at Blood Services he also initiated the development of a repository to hold historical targets for key metrics and implemented the targets into existing Cognos Cubes to enhance reporting capabilities.
• The project is on track and should be completed ahead of schedule.
• Also Test and validate the Cognos environment for accuracy and functionality.
• Also test and maintain existing FM Models as needed to develop extract sources.

Environment: Windows, SQL Server 2005

Software Environment: Cognos 8.4 Transformer, Report Studio, Framework Manager, Metrics Studio, Business Insight, Query Studio. Event Studio MS Office, Excel, VB macros.

Methodologies: SDLC (software development Lifecycle), Star Schema/Kimble, Relational

Confidential

Senior Solutions Architect/Developer

Responsibilities:

• Designed Conceptual and Logical data model for PeopleSoft HR module reporting solution. Also created physical model with PLSQL.
• Confidential was hired for a short term engagement to develop and implements a Cognos Series 7 solution / business system to integrate with PeopleSoft in a shared environment.
• The effort and focus was shifted to developing a data mart using PLSQL as the data would not be available for several months due to security concerns with the shared environment.
• Wrote complex SQL statements to support Cognos Solutions

Environment: Windows, SQL Server 2005, Oracle 10g

Software Environment: Cognos 7.4, 8.4.1 Transformer, Report Studio, Framework Manager Studio, MS Office, Excel

Methodologies: Agile Methodology, SDLC, Star Schema/Kimble, ODS, Relational

Confidential

Senior Cognos Systems Analyst/Business Analyst

Responsibilities:

• Worked with project manager to define and develop and implement a business system consisting of a series of complex reports for tracking inventory for Paper Sales. Confidential was also responsible for developing a solution to replace a SAS reporting system to be archived by . The solution developed included powercubes, over 20 reports and a query studio model. Also the development, testing and maintenance of FM models All of the existing functionality had to be duplicated using Cognos with some additional enhancements.
• Confidential was also responsible for liaising with clients and providing training using the client data.
• Confidential also developed a scorecard solution using Metrics Studio to replace an existing system to be archived .
• Confidential was responsible for developing Framework Manager Models, resolving Data issue with the DBA, assisting in determining data requirements with the ETL developer and DBA. Worked briefly with Data manager to resolve ETL issues.
• Created stored procedures to be used in Cognos reporting

Environment: Windows, SQL Server 2005

Software Environment: Cognos 8.4.1 Transformer, Report Studio, Framework Manager Studio, UNIX, MS Office, Excel, VB macros. Data Manger

Methodologies: SDLC (software development Lifecycle), Star Schema/Kimble

Confidential

Senior Cognos Systems Analyst

Responsibilities:

• As the Cognos Architect for Dynamic Enterprise Dashboard project Confidential was responsible for evaluating the deliverable requirements and providing a tool selection recommendation, report implementation approach and defining the project architecture with respect to Cognos and implementing the business system.
• I was also responsible for providing technical assistance and research efforts to assist the development team in meeting their project objectives.
• I also assisted in development for the solution and mentored employees to ensure knowledge transfer.
• Test and validate the Cognos environment for accuracy and functionality as well as ensure custom modifications to the application were behaving as expected.

Environment: Windows, SQL Server 2005

Software Environment: Cognos 8.4 Transformer, Report Studio, Framework Manager, Metrics Studio, Query Studio. Event Studio, UNIX, MS Office, Excel

Methodologies: Agile Methodology, Star Schema/Kimble

Confidential, Emeryville, California

Senior Cognos Systems Analyst/Business Analyst

Responsibilities:

• As part of the functional team, Confidential worked to ensure sound design of functional criteria were adhered to. He was responsible for assisting in the creation of functional specification documents and created POC cubes, reports and portal designs that were used as proof of technology.
• Confidential presented the proof of concept solutions to senior Confidential management.
• Liaise with Senior Confidential Management/Partner
• Liaise with Senior Kaiser Management
• Assist in the development of functional specification documents
• Create solutions for cubes, reports, portal design and Metrics Studio design Dashboard reports and present solutions to senior Kaiser management and stakeholders.
• Implement business system
• Create BI roadmap and overall Cognos infrastructure and reporting planning for the PeopleSoft roll out of Cognos reporting.
• Test and validate the Cognos environment for accuracy and functionality
• Test and maintain existing FM Models as well as develop new models.

Environment: Windows, Oracle 10g, PeopleSoft, ( Financial modules), UNIX

Software Environment: Cognos 8.4 Transformer, Report Studio, Framework Manager, Metrics Studio, Query Studio. Event Studio, MS Office, Excel, VB macros.

Methodologies: SDLC (software development Lifecycle), Star Schema/Kimble, ODS, Relational

Confidential

Senior Cognos Systems Analyst/Business Analyst

Responsibilities:

• Designed Conceptual and Logical data model for Reporting mart.
• Migrated Series 7 Solution to Cognos Series 8.
• Developed Framework Manager models, Created Metrics studio scorecards, Created Report Studio reports, Query studio reports, event studio events, portal customization and analysis studio reports.
• Created dimensional data from a relational source in Framework manager, used parameter mapping to enable multi language support and migrated series 7 cubes to the new environment.
• Designed star schema reporting DataMarts for building cubes, running reports etc.
• Provided knowledge transfer to employees and provided learning sessions to peers.
• Provided development expertise at the Confidential for all Cognos product used by the organization.
• Identified data issues after each monthly data refresh.
• Created Documentation for Confidential with respect to powerplay cubes, impromptu reports and testing processes.
• Test and validate the Cognos environment for accuracy and functionality
• Validated data against data warehouse
• Created bilingual reports (English and French)
• Created and maintained Cognos Cubes, impromptu reports and powerplay reports
• Tested Reports using SQL in third party tool and wrote SQL to validate results against an Oracle database
• Implement business system
• Created a business case to move to Metrics Studio reporting. As well created a presentation that was delivered to directors.
• Test and validate reports and troubleshoot issues with existing reports
• Test and maintain existing FM Models as well as develop new models.

Environment: Windows, Oracle 10, 9

Software Environment: Cognos 7.4, 8.4 Transformer, Report Studio, Framework Manager, Metrics Studio, Query Studio. Event Studio, Impromptu 7.4, MS Office, Excel, VB macros.

Methodologies: SDLC (software development Lifecycle), Star Schema/Kimble, ODS, Relational

Confidential

Project lead Cognos Systems Analyst

Responsibilities:

• Upgraded the Cognos IWR production environment for a critical online application.
• This environment was upgraded in place and was a complex distributed UNIX install across 6 servers.
• The upgrade went as expected. Confidential was responsible for planning the upgrade, coordinating resources and carrying the upgrade. Installed and implemented Business system for the external vendor reporting system.

Environment: LPAR AIX, DB2, Sybase

Software Environment: Cognos 7.4, 8.4 Transformer, Report Studio, Framework Manager, Metrics Studio, Query Studio. Event Studio, Impromptu 7.4, IWR Access Manager Sun One directory Server, MS Office, Excel

Methodology: SDLC (software development Lifecycle)

Confidential

Senior Cognos Project leader/ Cognos Systems Analyst/ Business Analyst

Responsibilities:

• Confidential performed a product upgrade/migration for the existing 7.1 solution to 7.3. During his time at Confidential developed a proof of concept using Cognos series 8 solution for the operations helpdesk providing robust reporting and analysis.
• Developed a series 8 proof of concept solution for Confidential helpdesk including reports, cubes and scorecards, This solution integrated series 8 with their existing helpdesk technology.
• Developed Ad-Hock queries in Query Studio
• Developed Reports in Report studio
• Developed Metrics scorecards in Metrics designer and metrics studio
• Created events in event studio
• Implemented Security and business system
• Created Framework Manager Models using relation and dimensional sources
• Modeled Data dimensionally in framework manager
• Upgraded enterprise environment from 7.1 to 7.4 and provided assistance and training to key resources
• Implement business system
• Developed a Roadmap for all Cognos reporting and Cognos security as well as for software implementations.
• Worked to test and validate reports and troubleshoot issues with existing reports.
• Wrote complex SQL statements to support Cognos Solutions
• Helped design new data model for reporting at Confidential .
• Multiple projects concurrently, example security, training and reporting.
• Followed strict change management process.
• Trained users and administrator
• Used MySql as one data source for reporting.

Environment: LPAR AIX, DB2, Sybase, WebSphere

Software Environment: Cognos 7.4, ReportNet,Transformer, Report Studio, Framework Manager, Metrics Studio, Query Studio. Event Studio, Impromptu 7.4, IWR Access Manager Sun One directory Server, MS Office, Excel, MySQL

Methodologies: SDLC (software development Lifecycle), Star Schema/Kimble, ODS, Relational, MOLAP

Confidential

Senior Cognos Systems Analyst/ Business Analyst

Responsibilities:

• Confidential was responsible for getting a project in crisis back on track with respect to Cognos deliverables.
• During this time in his senior capacity Confidential developed and automated critical reporting processes including Impromptu automation and powerplay/transformer automation.
• As well Confidential advised and implemented back up processes and procedures, documentation standards, provided analysis to senior management for all Cognos related issues.
• Confidential also acted as a mentor for all Cognos products to junior developers.
• Developed Mission Critical Impromptu reports
• Developed Powerplay cubes and reports
• Advised on Cognos related issues
• Assisted and advised on Data mart planning and design
• Advised management on Cognos related matters
• Provided guidance and training to junior resources
• Resolved PC configuration and build performance issues
• Developed Metrics Studio Series 8 proof of concept and presented to senior management
• Created Documentation for Confidential with respect to powerplay cubes, impromptu reports
• Worked to define environment requirement for the Cognos implementation including product versions required, environment settings (cache settings etc.) and deployment recommendations.
• Produced cubes and reports against a data warehouse and against a reporting DataMart
• Created bilingual reports (English and French)
• Attended and participated in bilingual meetings
• Implement business system
• Tested Reports using SQL in third party tool and wrote SQL to validate results against an Oracle database
• Worked to test and validate reports and troubleshoot issues with existing reports

Environment: Windows, Oracle 10, 9

Software Environment: Cognos 7.4, 8.4 Transformer, Report Studio, Framework Manager, Metrics Studio, Query Studio. Event Studio, Impromptu 7.4, MS Office, Excel, VB macros.

Methodology: SDLC (software development Lifecycle), Star Schema/Kimble, ODS, Relational

Confidential

Senior Programmer/Systems Analyst/Business Analyst - Cognos BI Tools

Responsibilities:

• Confidential was asked to return to Confidential to work on the EMSDS Elections Readiness project to provide assistance with an existing Cognos solution to address election readiness. Confidential was responsible for the following.
• Upgraded/migrated from Version 7.1 to 7.3 of BI tools.
• Re-engineered Cognos Cubes developed by Vis group
• Re-engineered Cognos Impromptu reports
• Evaluated and tested ReportNet as a replacement for the current Impromptu solution.
• Worked with Metrics manager and evaluated metrics studio for Confidential .
• Created documentation for Confidential with respect to Processes, technical cube and model documentation.
• Created cubes and reports using reporting DataMart
• Created bilingual reports (English and French)
• Tested Reports using SQL in third party tool
• Used SQL in an Oracle environment to validate report results
• Created Proof of concept for Confidential using Cognos Series 8, including migrating exiting cubes for evaluation.
• Implement business system
• Developed/documented a business case for the implementation of Metrics studio
• Worked to test and validate reports and troubleshoot issues with existing reports

Environment: Windows, Oracle 10, 9

Software Environment: Cognos 7.4, 8.4 Transformer, Report Studio, Framework Manager, Metrics Studio, Query Studio. Event Studio, Impromptu 7.4, MS Office, Excel, VB macros.

Methodology: SDLC, Star Schema/Kimble, Relational

Confidential

Senior Programmer/Analyst - Cognos BI Tools

Responsibilities:

• Confidential was responsible for the installation and configuration of ReportNet on a Linux platform using an Oracle database for the Content Store.
• Confidential completed this task within the time constraints provided.

Environment: Red Hat Linux, Oracle 9

Software Environment: ReportNet 7.4 Transformer, Report Studio, Framework Manager, Metrics Studio, Query Studio. Event Studio, Impromptu 7.4, MS Office, Excel, Tomcat

Methodology: Agile Methodology

Confidential

Senior Programmer/Systems Analyst/Business Analyst - Cognos BI Tools

Responsibilities:

• Confidential was tasked with all aspect of development of three reporting cubes to enable end users to profile and assess disability claims.
• Defined User requirements through meetings with clients
• Designed catalogs, reports and Transformer Models
• Presented completed cubes to end users
• Provided formal training to end users
• Provided recommendation documentation on Data mart enhancements
• Development of BI design documentation, this included Cube design specifications, Query and catalog design specifications and report design specifications.
• Used SQL and SQL tools to verify data against the relations database (Oracle DataMart and DB2 database)
• Created impromptu reports against a financial data warehouse
• Created Documentation for CRA with respect to powerplay cubes, impromptu reports and testing processes, implementation processes. Also created a security documentation handbook that was adopted as the starting point for a Database/Cognos security review.
• Worked as a business analyst gathering and refining requirements with business managers and subject matter experts.
• Worked with database and architecture group defining database and environment requirements for Cognos Series 8 roll out and series 7.x environment.
• Tested Reports using SQL using SQL plus against the Oracle database
• Implement business system
• Created a go forward plan for the automation of a reporting process developed by Confidential

Environment: Windows, Oracle 10, 9

Software Environment: Cognos 7.4 Transformer, Impromptu 7.4 Lead Architect, Developer, Business Analyst, Mentor, MS Office, Excel, VB macros.

Methodology: SDLC, Star Schema/Kimble, ODS, Relational

Confidential

Senior Programmer/ Cognos Systems Analyst/ Business Analyst

Responsibilities:

• Worked with Architecture team to design Conceptual and Logical data models for reporting marts during re-engineering project.
• Confidential was initially responsible for overseeing the upgrade/migration to 7.1 of enterprise server, transformer and IWR. Confidential was called upon to trouble shoot several issues and provide advice on Cognos best practices and go forward recommendation.
• Confidential worked closely with several groups at Confidential to provide overall recommendations for performance and delivery.
• This is a UNIX ( AIX) environment with multiple databases ( DB2, Sybase, SQLserver)
• Confidential is currently engaged on this contract. Confidential was also responsible for improving build times of all cubes and access times for large complex cubes(Cube sizes exceeded 6G.)
• Resolved issues with respect to production systems Improved build times by 30% Assisted other groups in dev and best practices Produced best practices documentation for client
• Worked with Architecture group to asses current deployment making several recommendations as well as strategy/plan for their implementation
• Worked with Solutions delivery to resolve development issues
• Advised Management on Hiring decisions for Cognos resources
• Provided guidance for the entire company with respect to reporting tools and direction
• Produced Best Practices documentation
• Audited Analysis of Confidential Cognos reporting solution.
• Designed of functional specifications and procedures for the implementation of Cognos tool
• Designed and delivered customized training to Cognos Administrators and end users
• Used SQL to verify data integrity against DB2 DataMart/data warehouse
• Examined SQL and query design strategy to identify areas of potential improvement with respect to read times
• Worked as a business analyst for the Operations group providing reporting solutions, chairing presentations to VP and director level management.
• Upgraded/migrated environment/reports/cubes to version 7.1
• Worked with Upfront to apply security, set up new box logic and administer all aspects of Upfront .
• Implement business system processes
• Trained users and administrator
• Created Cubes, Impromptu and IWR reports against Enterprise Database (3rd Normal Form)
• Used MySql as one data source for reporting.

Environment: LPAR AIX, DB2, Sybase

Software Environment: Cognos 7.4, ReportNet, Transformer, Report Studio, Framework Manager, Metrics Studio, Query Studio. Event Studio, Impromptu 7.4, IWR Access Manager Sun One directory Server, WebSphere, MS Office, Excel, VB macros. MySQL

Methodology: SDLC, Star Schema/Kimble, ODS, Relational, MOLAP

Confidential

Senior Programmer/Systems Analyst /Business Analyst

Responsibilities:

• Confidential was responsible for the upgrade and migration of Enterprise server/upfront from version 6.6 to version 7.0.
• Confidential provided guidance and identified issues that were preventing Enterprise server series 7.0 from being implemented successfully.
• Confidential was taking over for a client that had not been successful in upgrading the system.
• Confidential was able to evaluate the issue, recommend an alternative version (build) of enterpriser server.
• Confidential subsequently upgraded the installation, migrated reports, news boxes in upfront and provided testing verification that the migration was successful.
• Audited system
• Installed version 7.0 and configure
• Used deployment manager to migrate the application
• Manually upgraded URL’s, Reports
• News Box cleanup
• Identified a bug related to custom report views being lost when migrating from 6.6 to 7.0. Recommended using a more current version.
• Identified a bug related to Administration tools not being able to launch for Cognos series 7. Resolved issue
• Validated Upfront security and publishing of IWR reports

Environment: Windows Server

Software Environment: Cognos 7.4, ReportNet Transformer, Impromptu 7.4, IWR Access Manager Sun One directory Server, Powerplay web, Powerplay, MS Office, Excel

Methodology: Agile Methodology

Confidential

Senior Programmer/Systems Analyst - Cognos BI Tools

Responsibilities:

• Confidential worked to identify and resolve ongoing IWR Series 7.0 issues. Confidential was successful in identifying the issues, resolving them and made recommendations for future changes to the installation/deployment. Confidential was called in after several Cognos consultants were not able to resolve ongoing issues with reports failing, IWR publishing issues and extended wait times for report processing. Confidential quickly identified the problems relating to both product issues and multiple report servers not properly configured. Confidential resolved the problems and made recommendations for future direction. All of Confidential ’s recommendations were adopted by Cognos and Confidential leading to a subsequent planned stabilization of the current environment, upgrade to a current build of IWR and an upgrade/assessment path for future product upgrades.
• Audited installation
• Identified multiple issues with the installation
• Resolved issues and test
• Made recommendations for future changes to the installation
• Produced Go forward documentation for Cognos and Confidential .
• Participated in Follow up Conference call with Senior Confidential representatives and Cognos Services Manager for North Eastern Region.
• Provided mentoring to client during investigation and resolution.
• Advised client on Upfront security issues

Environment: HPUX, Oracle

Software Environment: Cognos 7.4, Transformer, Impromptu 7.4, IWR Access Manager Sun One directory Server, MS Office, Excel

Methodology: Agile Methodology

Confidential

Senior Programmer/Systems Analyst - Cognos BI Tools

Responsibilities:

• Confidential worked with another consultant to upgrade/migrate a production IWR/Upfront deployment to Series 7 MR3.
• The environment was distributed across 6 Sun Unix servers with 4 firewalls and additional security software.
• The project had to be completed during the weekend to ensure production systems were functional by Monday morning.
• Audited Environment
• Installed software
• Packed and verified current production system using deployment manager
• Implemented and tested auditing for IWR
• Provided detailed documentation to client for upgrade and migration process
• Published reports to upfront and set up Portal for production

Environment: SUN UNIX

Software Environment: Cognos 7 Impromptu 7.4, IWR Access Manager Sun One directory Server, MS Office, Excel

Methodology: SDLC (software development Lifecycle)

Confidential

Senior Programmer/ Systems Analyst

Responsibilities:

• Confidential worked in to resolve Upfront and Enterprise server Series 7 issues while at Confidential and was successful in reducing access times form 8minutes to less than 30 seconds from the web.
• Audited of HPUX Unix environment
• Identified and tested performance issue
• Audited on transformer Model design
• Recommended partitioning strategy for model.
• Provided Go forward plan and alternative product implementations for Client considerations.
• Created Cubes, Reports and identified issues with Terradata database

Confidential

Senior Programmer/Systems Analyst - Cognos BI Tools

Responsibilities:

• As a Senior Cognos consultant, Confidential was responsible for evaluating the current Series 7.0 installation of Cognos suite of tools. Confidential was also tasked with integrating People soft COTS software security with Cognos security allowing seamless web access. The development teams for the global Cognos roll out exceeded 500 developers. Confidential ’s recommendations were implemented.
• Assessed security and provided recommendations on security implementation
• Responsible for advising the development team on the international roll out/development of a Business intelligence solution.
• Assessed server architecture, current resources and made recommendations with respect to load balancing/failover configurations.
• Provided technical guidance in the tuning of servers
• Development of automation scripts (VB/Cognos script) for security implementation to a directory server and to implement Impromptu User Class security.
• Development of technical documentation for security, server migration, testing.
• Created automated script to populate access manager
• Advised on Upfront security and report scheduling
• Implement business system
• Worked to test and validate reports and troubleshoot issues with existing reports

Confidential

Senior Programmer/Systems Analyst - Cognos BI Tools

Responsibilities:

• Confidential is a large title insurance firm with over 3 billion in annual revenue. Confidential worked with the Revenue IT and management group to develop cubes that will greatly simplify the production and analysis of quarterly government reporting requirements and monthly GL reconciliation.
• Assessed database/data mart environment and made recommendations for modifications to support BI development
• Met with clients to determine requirements and timelines
• Worked with clients as a business analyst to identify needs and define requirements.
• Designed and Created 4 cubes based on client needs
• Designed and created Schedule T form reported to government on a quarterly basis
• Provided guidance to development team with respect to cube and report development.
• Assisted development team in troubleshooting existing Cognos issues.
• Provided weekly status reports to client
• Provided Technical training to client
• Provided knowledge transfer through documentations and instructor led demonstration
• Used MS SQL 2000 Analyzer to verify data in the data base (wrote SQL against the Relational database)Created reports against data warehouse
• Implement business system

Confidential

Senior Programmer/Systems Analyst - Cognos BI Tools

Responsibilities:

• While at Kehin in Greenfield Indiana, Confidential acted as the senior Architect in the upgrade and deployment of Cognos tools and Oracle based data marts to a multi-server environment.
• This was a production environment migration for an over 600Million/yr. international company.
• Responsible for the Upgrade and Migration of single server install to distributed server
• Installed and configured server applications
• Installation and configuration of Oracle Client and repository
• Used deployment Manager migrated IWR reports from Version 7.0 to 7.1
• Migrated all Powerplay report and cubes, Upfront and book marks
• Provided quick start training for Vizualizer to Key developers/Managers
• Assessed Security structure and architecture and made recommendations
• Provided client training
• Assisted in the presentation, installation and configuration of Cognos ReportNet for Client assessment.

Confidential

CMM / Visualizer Developer/Systems Analyst

Responsibilities:

• Representing Cognos in a pre-sales environment, Confidential liaised with senior Management and worked closely with the Cognos sales and pre-sales team to implement 3 Cognos Metrics manager scorecards.
• While at J&J Confidential took on the role of Project lead in the absence of the engagement manager and attended key meetings representing Cognos.
• Confidential was requested to return to Confidential as part of a Governance program.
• Confidential provided both high level and technical analysis and recommendations for the roll out and implementation of Cognos Metrics Manger across the enterprise.
• Confidential had also been asked to participate in the initial roll out and organization.
• Met with Directors and managers to determine scorecard structure
• Worked as a business analyst to determine required reporting structure as well as to define report content.
• Mentored Employees with Metrics Manager and Visualizer.
• Developed and implemented scorecards on MS SQL and Oracle platforms.
• Created SQL scripts to validate table content and to populate staging tables
• Provided advice to Engagement manager with respect to sales and implementation strategy as well as technical approaches for other unrelated projects.
• Developed and implemented a unique control chart solution for J&J standard control chart format using Visualizer
• Installed and Configured CMM on SQLServer and Oracle
• Installed and Configured Visualizer
• Used SQL plus and SqlServer Enterprise manager to identify issues in CMM tables and backup / restore databases.
• Created test Oracle repository on Laptop to test migration of database from SQL Server to Oracle.
• Used SQL to create custom functionality outside of the product (custom excel data extraction process for use with MINItab analytical application)
• Prepared and documented project plan for implementation of new scorecard applications
• Liaised with and interview key managers, directors and Database administrators to gather requirements for the future projects.
• Analyzed existing business system/scorecard applications and BI solutions to determine ideal implementation of future solutions
• Provided Governance documentation for the existing project and for the development of future scorecard applications.
• Worked closely with client to ensure knowledge transfer.
• Provided training to technical and non-technical user groups.
• Provided weekly status reports to client and keep Cognos informed of issues with respect to the product or the project.
• Provided innovative, outside the box solutions to problem resolution.
• Liaised with Director of Performance Excellence to address and resolve 81 questions and concerns regarding Cognos product limitations.
• Provided ongoing support, product configuration and problem resolution as required by client while onsite.
• Implement business system
• Participated in teleconference calls with multiple department heads and technical leads to address governance issues.

Confidential

Senior Programmer/Systems Analyst - Cognos BI Tools

Responsibilities:

• Confidential was a key resource in the upgrade, and reengineering of an existing Cognos solution.
• The existing system had not been touched significantly since the 2000 Federal election and underlying data feeds had been modified as well as new ones created.
• During an event cubes and reports are refreshed daily during and are presented each morning to the Executive Committee including the Chief Electoral Officer The system is key in helping run an election effectively and identify potential issues.
• Confidential was asked to continue and expand his role within the Election Management System initiative to provide and implement identified performance indicators and to work with the senior project manager on the implementation of Metrics Manager for use in the Next Federal Event.
• Produced documentation for the EMS system including test scripts for reports and models.
• Migrate/Upgrade from version 6.5 to version 7.1 of Cognos tools reports and cubes
• Processed documentations for the implementation of new reports and cubes as well as end user documentation.
• Worked with Senior DBA and Project Manager to implement Cognos Metrics Manager at Confidential
• Analyzed the existing reporting system (EMSDS) used during the 2000 federal election.
• Modified and created new models, Catalogues, Impromptu and Powerplay reports. (This included the version upgrade to series 7) against existing DataMart’s
• Created new models/cubes based on client feedback and database modifications
• Created Impromptu reports for the use in cube builds and for consumption by end users
• Advised peers on model design and product implementation.
• Installed and configured of Cognos series 7 suite on development PCs and production machines.
• Used SQL Navigator to identify data issues with database views and for data verification of SQL produced by Impromptu.
• Advised DBA regarding data staging issues.
• Instrumental in providing guidance and recommendations for the implementation of Metrics manager.
• Attended and acted as technical resource at business planning meetings relating to IT.
• Represented Senior Project Manager at meetings in his absence.
• Automated the daily process of Updating Dev environment to Production and building of Cubes, reports, logging and notification.
• Documented the processed and modifications implemented.
• Documented system changes, reports for end users
• Implemented visualizations for daily presentations to Excom
• Assisted in the evaluation of Metrics Manager as a performance reporting system for Confidential .
• Developed installation documentation for Metrics manager when using an Oracle repository. (Note the current Metrics Manager product documentation is not complete with respect to installation and configuration)
• Completed test installation and initial assessment of Metrics Manager
• Assessed Cognos Visualizer as a presentation tool for the EXCOM meetings.
• Produced multiple map and chart visualizations.
• Managed existing cubes and reports.
• Created bilingual reports (English and French)
• Analyzed new, integrated Voter Information System (VIS) used to warehouse all reporting systems data tracked during an electoral event. This includes Web and telephony systems as well as existing applications.
• Advised on integration of PowerPoint presentations (COTS) integration with Cognos tools for automated updates.
• Created cubes and reports based on VIS system and modify existing cubes as per clients evolving requirements.
• Worked as a business analyst to identify reporting requirements.
• Met with senior management and directors to discuss the EMS project.
• Worked with DBA and Senior Project Manager to implement Cognos Metrics Manager. This included the scorecard structure design, product installation and configuration and security implementation (Access Manager, Directory Server, and analysis of the impact of integrating with an existing MS Active Directory Server vs. implementation of I planet.)
• Analyzed, verified and developed of Key Performance Indicators as Identified by the Management Analysis Group. Make recommendation as to the validity of indicators, the ability to track the indicators and the usefulness of the indicators.
• Assisted in the preparation of Statements of Work requirements for the hiring of consultants for the production implementation of Metrics Manager.
• Created reports based on Key Performance Indicators and verify data.
• Created report templates and standards for Powerplay and Impromptu reports.
• Developed scripts (VB/Cognos script) to load Access Manager data from an Oracle Security Table and to populate the Security table form flat files.
• Outlined environment requirements for the upgrade and installation of series 7.x products and Metrics manager.

Confidential

Senior Programmer/Systems Analyst - Cognos BI Tools

Responsibilities:

• Key Technical resource for implementation of Cognos reporting tools.
• Provided Technical advice regarding tool selection, functionality and implementation.
• Created Impromptu reports against Confidential Decision Support System Oracle data warehouse.
• Created Cubes against Excel Data sources and an Access database.
• Created PowerPlay reports against DSS production cubes and cubes
• Identified and created Performance indicators for use in reporting.
• Created Data transformation process to extract data from COTS systems (Excel) and import to Access database.
• Created data loading process to export data to Access Database.
• Advised on Access database Migration to Oracle.
• Advised and trained head developer on Cognos Tools and their implementation.
• Performed measure and data analysis for performance measurement for Learning and Literacy Directorate Performance report.
• Produced monthly and quarterly performance measurement reports as required by directorate.
• Data exploration and research to identify and capture correct data for key performance measures.
• Developed and delivered training and knowledge transfer to employees for future maintenance of the performance report.
• All Human Investment Program directorates adopted this reporting system as a standard for key performance measures.
• Tools used include PowerPlay, Impromptu, Cognos script, Excel, Access.
• The reporting system integrates several data sources including Excel data, Word documents, text files and PowerPlay and Impromptu reports.
• Identified and created Performance indicators for use in reporting
• Created Impromptu reports against Confidential Decision Support System Oracle data warehouse.

Confidential

• Worked with Mainframe Architecture to identify the best sources of data for the development of new online functionality.
• Identified and documented the new process requirements, testing procedures and plans as well as Impact analysis for all departments. The process replaced the current method of calculating performance indicators reported to the Treasury Board and allows a reduced turnaround time for new Performance measure implementation and reduced workload on the Oracle data warehouse and BI developers.
• Data extraction from an existing Oracle Data warehouse to a Data mart.
• Stored, manipulated and cleaned 12 months of data for each extraction.
• Loaded the clean data into an existing online mainframe system.
• Designed new cube functionality for proof of concept. Identify how the new online system will Impact query, model and report design.
• Created technical documentation and process documentation to detail the proposed solution.
• Dataflow analysis of the current system from data creation to end user
• Examined and documented PL/SQL scripts logic currently running against Oracle Data Warehouse for Mainframe development.
• Developed both Impromptu and PowerPlay reports for use in testing.
• Automated test extraction process using MS Access and Cognos Script
• Evaluated the possibility of using a Commercial off the Shelf system to provide a data feed directly to the Mainframe via CSV files. The existing COTS system (Excel) proved to be too slow to accomplish the load task within the designated window.
• As a business analyst met with Business stakeholders to identify data flow processes, critical business measures.

Confidential

Responsibilities:

• Managed a team of 4 testers
• Worked with management to determine business requirements.
• Developed test specifications, test strategies and test scripts
• Reviewed all issues and promote to development
• Created daily bug and progress reports for management
• Attended daily meetings with Business Management
• Attended development meetings
• Supervised testing of the application and data verification of PowerPlay reports and web reports.
• Provided back up for senior project lead in his absence.
• Created over 600 PowerPlay reports in both English and French and analyze data issues. Included creation of Impromptu reports as a data source
• Created technical report specifications for report verification and duplication.
• Attended development meetings, advise on development strategies and issues
• Designed and developed relevant reports based on client’s requirements.
• Assessed the implementation of automation using Cognos script and Winrunner for client and web report generation.
• Reports were rolled out nationally via Cognos KPI business PAK.
• Created Reporting system against an existing Bug tracking database.
• Created PowerPlay and Impromptu reports to identify areas of concern.
• Designed and Created Cognos Powercube against the existing Access Bug Database
• Developed Visualizations using Visualizer for reporting to project co-coordinator
• Automated cube development and report updating using Cognos script. Updates were performed daily.
• Created an Access data mart for reporting purposes linking to the Bug Database and to a series of Excel workbooks (COTS).
• Created Impromptu Reports and data extractions against DSS Oracle Data warehouse
• Created and analyzed over 600 business measures (reports) against technical specs and investigate data anomalies.
• Developed and designed new Performance measures.
• Worked to test and validat