Resource Manager: Evelyn Moreira Page * of * Date: 24-Feb-2017

Afraz A Shaik

Professional experience

Profile Afraz Ahamed Shaik is a Cognos BI Professional part of Business Analytics and Optimization (BAO) practice under IBM Global Business Services. Experienced in all stages of software development life cycle (SDLC) of a project, which includes requirements gathering, design, development, testing and implementation. Good experience on dimensional and star schema data modeling and excellent knowledge on facts and dimensional tables. Experienced in creating various kinds of complex reports like crosstabs, drill throughs, ad-hoc reports, charts, score cards, creating interactive dashboards and also migration of reports from one environment to other. Extensively worked on performance tuning of reports and user acceptance testing

(UAT). Ability to meet task deadlines, perform multi-tasking, flexible in work schedules, leading an offshore team and also possess good communication skills. Training:

Completed training in Cognos v11.05

Self-Training on Tableau Desktop

Certification:

IBM Certified Cognos Designer

Employer History 11/2016 - 01/2017

GolfNow, United States of America

Sr, Cognos Consultant

GolfNow is an online booking service for tee times at golf courses. The project’s objective is to retrieve information for GolfNow forecast playable centers all over USA depending on forecasted weather data. Build dashboards for forecast playable reports using Cognos Analytics, so that, GolfNow can make decisions in planning discounts and other offers for playable centers which has poor bookings.

• Analyzed requirements for Cognos reports and dashboards.

• Designed complex dashboard and reports innovatively to meet client requirements.

• Developed interactive dashboard in Cognos 11.0.5 using MapBox to drill down from Country to Sector (North-East etc..) to State, and show Playable Index data at the desired level.

• Worked on creating Framework manager package to support the above reporting requirements.

• Involved in unit testing and user acceptance testing (UAT) for reports.

• Deployed reports into production environment.

06/2016 - 09/2016

IBM - RWE Watson

Sr. Cognos Consultant

Internal project for IBM Watson technology to automate data source connections by using SDK and Java scripts for Cognos, located on third party applications. Also build Cognos dashboards in version 11.05.

• Created dashboards by using data modules functionality.

• Created Framework Manager packages and published them.

• Created various kind of joins and securities like data level, package level security.

• Applied global filters and calculations on packages. Resource Manager: Evelyn Moreira Page 2 of 5 Date: 24-Feb-2017

• Created Alias tables in Frame Work Manager packages to remove ambiguous issues.

• Tested reports and did performance tuning on reports.

• Migrated reports from one environment to other environment.

• Documented the best practices for designing Cognos reports. 04/2016 - 05/2016

Manufacturing of Pharmautical Tools

Sr. Cognos Developer

Integra Life Sciences is a manufacturer of specialty medical devices which include fiber optic headlights, light sources etc. The project required Cognos reports to pull items which are delayed to return after trial period.

• Participated in requirement gathering.

• Designed reports which included charts Like (bubble, Line and Bar charts).

• Created Complex Cross tab and List reports.

• Applied conditional formatting, conditional blocks, render variables to hide and show the contents in reports.

• Created text, date and value prompts and applied cascading functionality.

• Scheduled and monitored the Cognos reports.

• Unit testing on reports.

• Worked on database views for Cognos reports.

02/2015 - 03/2016

American Broadcast Satellite Service Provider

Sr, Cognos Consultant

DirectTV has partnered with IBM on several projects. This was a Production support project for implementing and maintaining the revenue for Internal purpose.

• Analyzed the requirements and provided time and resource effort analysis.

• Hosted daily status meeting among team for task updates.

• Worked on various tasks which are assigned to Cognos administration, Production support and Development projects.

• Worked on various functions like Macros in report studio and Framework Manager.

• Implemented security levels on package and reports.

• Created user accounts and added them into associated Groups.

• Resolved high priority tickets with in SLA on production support project.

• Monitored servers and obtained 100% Uptime on servers. 04/2014 - 09/2014

Real estate and Call Center Divisions

Sr. Cognos Consultant

Jones Lang LaSalle Incorporated or JLL is an American professional services and investment management company specializing in real estate. Jones Lang LaSalle has several call centers. Purpose of the project was to build reports for call center statistics.

• Worked on ESRI maps for designing dashboards.

• Involved in User meetings to analyze requirements.

• Created various kinds of Dashboards (Drill through, Drill down, Render Variable also used Java scripts).

• Performance Tuning on packages and reports.

• Received Best Performance Award in this project. 03/2014 - 04/2014

Insurance Based company

Resource Manager: Evelyn Moreira Page 3 of 5 Date: 24-Feb-2017 Cognos Developer

Northwestern Mutual Life Insurance Company is an American financial services mutual organization. Project required to build reports to pull the accounts who delayed to pay on time through different sources of payments like Credit card, Money order, etc.

• Involved in requirement gathering.

• Used Rave Chart visualizations for Cognos reports.

• Worked on Cognos reports to schedule Daily and Monthly basis.

• Worked on technical specification documents, performance tuning, Unit testing.

• Migration of reports from Development to Production environment. 02/2014 - 02/2014

Mining Company

Cognos Developer

Joy Global is Data Mining business. It requires reports to evaluate the statistics of company. This is a P.O.C project, We build Cognos reports to pull yearly based revenue on location basis.

• Development of reports like visualizations, dashboard and active reports.

• Proposed report layout in various formats.

• Suggested best approach to design reports.

• Applied page breaks settings on Cognos reports.

• Developed reports by applying conditional formatting.

• Show and hide functionality on reports by using variables like render variables, conditional blocks.

• Good Knowledge on Toad and Oracle data base.

11/2013 - 01/2014

Consulting and Services

Cognos Consultant

Affinion Group, uses BRIO tool for business analysis purpose. Objective was to migrate all reports from BRIO to Cognos.

• Pulled SQL from BRIO tool and used it for creating reports in Cognos with proper security levels

• Documented effort analysis, Time analysis and Cost analysis for migration of reports from BRIO tool to Cognos.

• Analyzed and consolidate list of reports which are used in BRIO tool.

• Designed Cognos reports without Intermediate layer like Framework Manager. 02/2013 - 08/2013

Health Insurance Services

Cognos Developer

HAP, is Insurance company. Purpose of the project was to analyze business on various plans of insurance so that they can do changes in forecast insurance plans. Build reports to pull data for all business requirements.

• Migration of reports from Hummingbird to Cognos.

• Consolidation of reports.

• Worked on Business Requirement Documents and Techincal Design Documents.

• Created Hierarchy in Framework Manager packages.

• Created drill down reports and applied conditional formatting on it.

• Unit tested and supported in UAT phase.

• Involved in performance tuning of reports.

• Worked on Toad for Oracle database.

Resource Manager: Evelyn Moreira Page 4 of 5 Date: 24-Feb-2017 02/2012 - 12/2012

Product/Auto Mobile Services

Cognos Developer/Admin

Eaton Corporation, is a real estate, automotive, Fuel conservation company. Objective of the project was to upgrade Cognos from version 8.3 to 8.4. Worked on production support as well as on Migration project. Build scorecards, metrics through Metric Studio.

• Worked as a shadow resource for migration of Cognos version from 8.3 to 8.4.

• Monitored threshold limit and outage of connections for content manager and application servers.

• Reverse migration of reports from production to development environments.

• Created user accounts using Access manager.

• Scheduled reports/cubes and monitored schedule jobs.

• Acquired good knowledge on Metric studio and Event studio. 10/2011 - 12/2011

Financial Bank

Cognos Developer

ING Direct is a Financial Company. Project had complex requirements to build reports with large amount of data.

• Requirement gathering from end users.

• Worked with offshore team to meet the dead line SLA’s of individual tasks.

• Coordinate with offshore team for designing and testing reports.

• Created active reports for best performance.

• Applied drill through functionality between reports

• Created Master and Detail relationship reports.

03/2011 - 05/2011

Educational sector

Testing

ITU is an Educational sector, which contains huge amount of students data for enrollments. Worked as an Intern in this project. Manual Tester for ITU Home website which displays various contents of ITU.

• Wrote test cases for the requirements.

• Tested use cases and user raised issues.

• Resolved tickets by distributing test cases and tickets among team

• Ensured, university application100% up-time.

issues in advance.

Key Skills Sector Division:

Sports,Pharmaceutical, Media and Entertainment, Real Estate, Call Center, Product Based Industry, Mining Industry, Transportation and Automotive sector, Consulting, Banking, Health Insurance, Educational.

Technical Skills :

ESRI Maps, Cognos Report studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Framework Manager, Cognos Administration, Security, Deployment, UAT, Access manager, Toad, Brio tool, Humming bird tool, data ware house concepts, Performance tuning, Requirement Gathering, Team Lead. Resource Manager: Evelyn Moreira Page 5 of 5 Date: 24-Feb-2017 Key Courses and

Training

Key Courses:

Cognos Report Studio, Dashboards, Visualizations, Metric Studio, Query studio, Administration, Frame Work Manager, SQL.

Education

Qualifications Masters in Masters in Computer Engineering International Technological University, United States of America, 2011 Languages

English Fluent

Hindi Fluent

Telugu Fluent

Urdu Fluent

Tamil Basic

Contact this candidate