Cognos BI Administrator

AR

OBJECTIVE

To utilize my education and

professional experiences to

design, develop and

implement Cognos BI

strategies and administration.

EDUCATION

BACHELOR OF ENGINEERING

**** • CARLETON

UNIVERSITY

• Granted entrance

Scholarship

• Graduated with high

distinction

• Completed CO-OP with

IBM

• Teaching Assistant

position for C++ Problem

Solving and Computers

• Councilor, Faculty of

Engineering & Design

AHMED RASHID

BUSINESS INTELLIGENCE CONSULTANT ENGINEER

CANADIAN SECURITY CLEARANCE CERTIFICATE: SECRET

PROFESSIONAL WORK EXPERIENCE

IBM COGNOS BI PROFESSIONAL CONSULTANT - ALTERNA BANK MARCH 2019 – SEP 2021

• Managing 3 Cognos Environments (Production, Dev and Test)

• Managing 3 ETL Servers (Production, Dev and Test)

• Managing 3 SQL Servers (Production, Dev and Test)

• Handling critical escalations that cause damage to the business operations, causing Cognos BI production environment to go down

• Daily conferences with Directors and Managers to discuss business requirements and updates

• Analyzing and debugging critical BI production environment issues

• Implementing the solution and explaining the process to management

• Doing root cause analysis to find out what caused the issue at the first place

• Plans and documents the full range of actions needed to achieve desired end-results on complex problems

• Communicate status of production issues (describing issue, resolution, and status) with both the business and the Business Intelligence team in a timely manner

• Documented business workflows for stakeholder review

• Proactively develop, coordinate, and provide on-going training, functional, and technical direction to the super-users

• Create and develop business reports

• Developed various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

• Testing report output against the database to validate the report

• Analyzing failed reports and fixing them

• Train business users on the use of report studio and query studio

• Assist in migration reports from one environment to another

• Assists in necessary investigation, analysis, and evaluation to determine project scope and resource requirements

• ETL development

• Designed and published Cognos packages and created reports using report studio and query studio

• Designed data warehouse for different databases and automated the work with ETL and Schedules

• Worked with multiple teams to understand data sources and targets to design and integrate with BI and converting business rules and logic to functional specifications and ETL logic

• Analyzed ETL job's and data and tuned queries and jobs to get better performance

• SQL Development based on new business requirements

• Managing critical bank databases and ensure those databases are getting updated on daily basis.

IBM COGNOS BI PROFESSIONAL CONSULTANT • CHILDREN’S AID SOCIETY NORTH BAY & PARRY SOUND (CASNPS)• FEB 2019 – APRIL 2019

• Audit the production server and prepare it to move from C10.2.1 to Cognos analytics 11.

• Install and configure C11 (Configure Gateway, dispatcher and content manager, migrate namespaces, Configure IIS, Configure SSO and build DB connection).

• Migrate the database data from C10.2.1 to C11.

• Test the entire structure to ensure we have a secure production c11 environment.

• Provide recommendations and knowledge transfer to casnps staff on IBM Cognos software installation and configuration.

• Assist with preparation and editing of IBM Cognos training materials.

• Deliver onsite IBM Cognos training to casnps staff.

• Work with casnps team, building IBM Cognos reports to meet current requirements for cpin system

IBM COGNOS BI PROFESSIONAL CONSULTANT •CANADIAN

NUCLEAR LABORATORIES LTD. (CNL) • OCT 2018 – MARCH 2019

• Review and provide feedback on CNL Build Book for development and production environments

• Assist with the installation and configuration of CNL’s IBM Cognos software

• Answer any question or concerns that could raise from the staff team during the installation process

• Provide recommendations and knowledge transfer to CNL staff on IBM Cognos software installation and configuration

• Record the daily completed work in timesheet

SENIOR BUSINESS INTELLIGENCE CONSULTANT, COGNOS

SEVERITY 1 PRODUCTION ENVIRONMENTS • IBM • 2016 – 2018

• Handling critical escalations that cause damage to the business operations, causing Cognos BI production environment to go down

• Daily conferences with CEO, Managers, Database team and Cognos specialists at the client site

• Analyzing and debugging critical BI production environment problems logged by IBM Clients

• Implementing the solution and explaining the process to management

• Doing root cause analysis to find out what caused the issue at the first place

• Plans and documents the full range of actions needed to achieve desired end-results on complex problems

• Communicate status of production issues (describing issue, resolution, and status) with both the business and the Business Intelligence team in a timely manner

• Documented business workflows for stakeholder review

• Proactively develop, coordinate, and provide on-going training, functional, and technical direction to the super-users (content developers)

• Administrate the BI applications. Provide a stable production environment that meets performance needs and make adjustments as needed

• Consistent performance at IBM's highest possible performance grade which lead to earning the IBM • MANAGER’S CHOICE AWARD

SENIOR BUSINESS INTELLIGENCE CONSULTANT, COGNOS ESCALATION ADMINISTRATION & REPORTING • IBM • 2014 – 2016

• Leader and resource for providing assistance on on-going escalations

• Authored, edited, and published technical knowledge-based documents on both the internal and external IBM websites

• Resolving defects or issues logged by IBM Clients

• Involving in Cognos migration plan and analysis

• Deploying Cognos Codes from dev to QA/Production

• Working on bug fixing and enhancements to existing Cognos env

• Providing training on new Cognos features to the team and stakeholders

• Working with other internal and external resources, plan and manage BI system implementations and upgrades, license management, security, auditing, and future/additional product evaluations for the business intelligence applications as needed

• Communicate status of production issues (describing issue, resolution, and status) with both the business and the Business Intelligence team in a timely manner

• Proactively develop, coordinate, and provide on-going training, functional, and technical direction to the super-users (content developers)

• Assists in necessary investigation, analysis, and evaluation to determine project scope and resource requirements

• Develops and documents complete descriptions of all business requirements as specifications of work to be performed

• Plans and documents the full range of actions needed to achieve desired end-results on complex problems

• Maintained a high client satisfaction rate of over 95% which lead to earning the IBM • EMINENCE & EXCELLENCE AWARD

TECHNICAL ANALYST, COGNOS ADMINISTRATION AND CONFIGURATION • IBM • 2012 – 2014

• Installing Cognos BI application on single and multi-server environments

• Installing and configuring Framework Manager, Report Studio, Query Studio, Metric Studio, and analysis tools such Cognos Transformer

• Patching, Upgrading, Migration of Cognos Application servers

• Maintaining the integrity, security, performance and availability of Cognos environments

• High availability and Disaster recovery - installation and configuration at Application server layer

• Providing capabilities to Cognos users

• Security implementation, Configuration and maintenance

• Support, Maintenance and Monitoring of Cognos platform and performance

• Deploying Cognos content from one environment to another environment

• Configuring Audit database

• Upgraded/migrated reports from one env. to another

• Providing training on new Cognos features to the team and stakeholders

• Create documentation for project plans, project status reports, timelines, project issues and risks, change requests, requirements, design, testing plans and test cases as needed for assigned projects

• Communicate status of production issues (describing issue, resolution, and status) with both the business and the Business Intelligence team in a timely manner

• Cross-train with and serve in backup administrator role for other Business Intelligence Applications team members. Coordinate with backup team members and IT monitoring departments in order to provide occasional after-hours system support

• Define and document application best practices, required standards, processes, and guidelines regarding the use and administration of the BI tools. Standardize the development process for the content developers

• Research functionality and technical configuration within the BI systems supported by the BI Applications group and prepare recommendations for system improvements whenever possible

• Maintain and monitor all BI environments including development, test, production, and disaster recovery TECHNICAL ANALYST, COGNOS REPORTING • IBM • 2010 – 2012

• Create and develop reports

• Developed various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill- Through Reports.

• Testing report output against the database to validate the report

• Analyzing failed reports and fixing them

• Train business users on the use of report studio and query studio

• Assist in migration reports from one environment to another

• Assists in necessary investigation, analysis, and evaluation to determine project scope and resource requirements

• Develops and documents complete descriptions of all business requirements as specifications of work to be performed

• Plans and documents the full range of actions needed to achieve desired end-results on complex problems

• Develops and documents common operations, which can be reused

• Participates in certain aspects of user consulting, systems analysis, general systems and process design MANAGER • IBESTDESIGNS GROUP INC. • 2008 – 2010

• Provide website design services for professional businesses

• Provide custom software that meet the client needs

• Manage portals, invoicing system, business analysis tools, tracking systems and digital marketing

• Daily use of various design and development programming languages such as JAVA, C++, Javascript, PHP, iPhone IOS, HTML in an effort to increase and broaden customer base

• Manage domains, hostings and securities

• Debug databases, software errors and issues; and provide viable solutions/options

• In-depth search engine optimization analysis to improve ranking TECHNICAL EXPERTISE

• IBM Products: Cognos BI 8, Cognos BI 10, Cognos BI 11 (IBM Analytics 11), Gateways, Dispatchers, Content Manager, Framework Manager and everything related to Cognos BI.

• Security: Cognos Users Security, LDAP, NTLM, SSO, SSL

• Databases: SQL, MySQL, Oracle, DB2

• Operating Systems: Windows, UNIX, Linux

• Programming Languages: C/C++, Java, PHP, Python

• Experienced with web designs HTML, HTML 5, CSS, CSS 3, Javascript and Responsive Designs

• Experienced with Servers Setup, Servers Hosting, Servers Backup, DNS Setup, Domains Setup, FTP and accounts permissions

• Professional skills in testing and debugging the root cause of any technical issue AWARDS, DISTINCTIONS & PROFESSIONAL DEVELOPMENT

IBM • BUSINESS INTELLIGENCE CERTIFIED SPECIALIST

Professional Skills and Certification in IBM Cognos 8 Business Intelligence and IBM Cognos 10 Business Intelligence for Cognos Administration and Reporting.

IBM • MANAGER’S CHOICE AWARD

Earned Manager’s Choice Award for demonstrating the practice: “Shows Personal Interest”. IBM • EMINENCE & EXCELLENCE AWARD

Earned Eminence & Excellence Award for demonstrating the practice: “Put the Client First”

Contact this candidate