SUMMARY

• 9 years of professional experience in all stages of software development life cycle with extensive exposure to data warehousing and business intelligence.
• Developed dashboards using Cognos Analytics 11 RAVE visualizations
• Created data module,dataset and uploaded files in Cognos Analytics 11.5
• Managed ETL jobs using Cognos Data Manager and informatica
• Have exposure working directly with clients and end user
• Over 8 years of experience in BI tools using Cognos 10 Framework Manager, Report studio, Query studio, Analysis studio, Powerplay Transformer, Event Studio and Metric Studio.
• Created Data modules by combining data from uploaded files and packages as sources
• Created data set from existing package and used as the source for a data module or a dashboard
• Have created Stories using Cognos Analytics dashboards
• Performance tuning by analyzing SQL and written complex SQL query for Cognos reports.
• Used SQL to Extracted, compiled and tracked data, and analyzed data to generate reports
• Created SQL query and validated data after archival process
• Experience in JIRA and Confluence
• QlikView Developer experience in all aspects of Business Intelligence applications.
• Real time exposure to Cognos 10.X BI Studios, installation and configuration and Upgradation Cognos 8.X reports and metrics.
• Created technical design specifications and develop analytic reports
• Self - starter who can work independently, establish priorities and be a strong team player
• Provided adhoc reports/ analyses to sales and management stakeholders
• Provided training and end-user support for customized reports
• Analyzed financial data to identify relationship between operations and payment trends
• Accounts receivable payment and trend analysis presentation to management committee to recommend strategic plans to increase revenue
• Implemented Web Technologies to customize the reporting environment in order to organize and visualize Business Metrics and KPIs into logical sets of dashboards and data visualizations.
• Implemented JAVA Scripts in Cognos reports to overcome challenging issues such as auto cascading of prompts, tabbed
• Created metadata models, used data extracted from multiple DBs, and created joins and cardinality and created DMR models, deployed packages and implemented security/access management.
• Having knowledge on Tableau and ETL tools like Informatica.
• Create packages to suit the business needs and to improve the performance of the reports by defining filters,adding calculations and performing SQL tuning on the model and report level using Oracle database
• Worked with Different Databases like Oracle8i/9i/10g, SQL Server 2016, DB2.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skill

TECHNICAL SKILLS

BI Technologies: Cognos Analytics 11.5, Cognos 10 BI tools (Report Studio, Analysis Studio, Query Event studio, Cognos Connection), Framework Manager, Powerplay Transformer, Cognos Analytics11, QlikView 11

Database Tools: Toad, SQL Server Studio, SQL Plus, Teradata SQL Assistant,Oracle

Testing Tool: Quality Center 9.0, ALM,JIRA

ETL: Informatica, Cognos Data Manager

Operating Systems: UNIX, Window 7/XP, Windows Server 2003/2008

Other Tools: MS Word, Excel, PowerPoint, Outlook,Confluence

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

Responsibilities:

• Analysed the users requirement and created detail level requirement for dashboard.
• Created data module, dataset and uploaded files
• Hands on experience in creating report and Dashboard in Cognos Analytics 11.5
• Involved in developing software for automating product pricing
• Validated enterprise data after the Archiving process and provided solution in fixing issues.
• Managed ETL jobs and created jobs for E1 tables
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Used SQL to Extracted, compiled and tracked data, and analyzed data to generate reports
• Created SQL query and validated data after archival process
• Improved report performance by using SQL query
• Reinforce and maintain compliance with corporate standards
• Created multiple Dashboard reports for multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.

Environment: CognosAnalytic11,CognosFrameworkManager,CognosDataManager,JIRA

Confidential

Cognos BI Analyst/Admin

Responsibilities:

• Created complex cross tab, Parent-Child reports to evaluate the business performance tasks.
• Developed Complex Reports using Report Studio including conditional blocks, conditional formatting.
• Developed reports for Exception Highlighting and Hiding sensitive data using Condition Variables.
• Developed Dash Board Reports based on the requirement.
• Bursting the Reports in Cognos Environment and sending by mail.
• Created multi page report based on multiple queries using Prompts and Parameters.
• Scheduled and distributed reports using Schedule Management in Cognos Connection.
• Tested and improved Report Performance.
• Interacting with the client on a regular basis.
• Created Active Reports using Data Button & Data Toggle Button Bar.
• Implemented standards in Report design and appearance by following set of predefined rules while applying colors and fonts.
• Preparation of checklist for handling Cognos related support tickets.
• Issue tracking document prepared for common Cognos data issue.
• Report / data issues found after testing has been fixed and tested.
• Setup report bursting and scheduled it to run on the end of every month.
• Involved in migration of reports from Cognos different environments (Dev, UAT, PROD).
• Optimized SQL in tune with the KPI's - dimensions and measures definitions given as per the business requirements.
• Developed dashboards using Cognos11 RAVE visualization
• Created Data modules by combining data from uploaded files and packages as sources
• Created data set from existing package and used as the source for a data module or a dashboard
• Managed team in handling reports and fixing the issues
• Interactive mode in dashboard allows users to explore the data to find trends
• Have created Stories using Cognos Analytics dashboards
• Performance tuning by analyzing and comparing SQL and Cognos query.
• Used heat map,Packed bubble,Marimekko,Radial and Map in the dashboard.
• Implemented JAVA Scripts in Cognos reports to overcome challenging issues such as auto cascading of prompts, tabbed and formatting.
• Supported business analysts by fixing issues related to OLAP cube/reports (cube refresh, static build, model file changes)
• Developed/Enhanced dashboards and reports using active reports 10.1 because of their advantage of offline reportingCreated guidelines to properly name project folders, their internal structure, package construction in FM, deployment archives.
• Performed routine maintenance of Production environment by inspecting and purging reporting elements not required anymore for operations, auditing report run and access patterns by business community, facilitating Single Sign On process, customizing application login URL.
• Creating schedules for reports with heavy access traffic and long run duration ahead of time and delivering PDF/Excel o/p straight to concerned user email boxes.

Environment: Cognos Framework Manager, Cognos10 Report studio,Cognos Workspace

Confidential

Cognos BI Developer/Admin

Responsibilities:

• Preparation of Project plan and test plan documents.
• To upgrade IBM Cognos 8 BI to IBM Cognos 10 BI and IBM Cognos 10 Planning.
• Tested the reports, packages, dashboards and scorecards already existing in Cognos 8.4 with upgraded cognos10.2 version.
• After migration Reports are modified to fix the data issue.
• Supported Installation and configuration of Cognos10 BI software/products in all environments (Test, Prod).
• Reports are modified to support the output data in Arabic.
• Aggregation properties of reports needs to be changed after migration.
• Charts and report objects alignment are affected after migration.
• Need to rework on reports to fix Excel formatting issues.
• Business Insight tested with few sample reports.
• Faced issues in scorecard metrics and fixed by reloading the metric store.
• Initially 600 reports were planned to be tested and later report count is increased to 1300.
• Manual testing method is followed in comparing report outputs.
• Test scenarios are tracked in test case document.
• Involved in improving the Cognos server environment by fine tuning the reports.
• IBM Cognos for Microsoft Office is tested and faced issue in loading report in PowerPoint and raised PMR in IBM.

Environment: Cognos Framework Manager, Cognos10 Report Studio, Cognos10 Metric Studio

Confidential

Cognos BI Developer

Responsibilities:

• Preparation report mapping and specification documents.
• Creation of Reports using Relational package using Report studio.
• Report layout has been achieved as per the requirement.
• English version reports are created, and output will be generated in Arabic.
• Modified existing reports to incorporate the changes in the Source System.
• Prepared Test cases for report validation.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Created multiple Dashboard reports for multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Initiated training for the users to do ad-hoc reporting using Query Studio.
• Designed and Prepared a Training Material for the Users.
• Closely Involved in Requirement gathering and Analysis with the customers.
• Created List Reports, Cross tab Reports and Control Charts.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
• Involved in Unit and Integration testing.
• Responsible for code migration across environments (DEV, UAT & Prod).
• Responsible for documenting the code changes as per the User change requests.
• Test scenarios are tracked in test case document.
• Report / data issues found after testing has been fixed and tested.

Environment: Cognos 10 Framework Manager, Cognos10 Report Studio.

Confidential

QlikView Developer

Responsibilities:

• Gathered customer requirements from Business Analyst and understand the data from different source systems.
• Extracted data from the database, stored into QVD files, and wrote Load scripts.
• Eliminated Synthetic keys and circular loops in the Data Model.
• Applied mapping function to look up and fetch the required field.
• Created User Interface of reports and designed the Dashboard according to the requirements.
• Created Dashboard style of layouts using various components of QlikView like List boxes, Charts, Text Objects, and Bookmarks.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping).
• Constructed various graphs such as Straight table, Bar graphs, Pie charts, Line charts Gauge charts.

Environment: QlikView 11.0, SQL Server, DB2, Windows 2008 Server.

Confidential

Cognos Developer

Responsibilities:

• Preparation of HLDs and DLDs.
• Preparation of estimation and timelines for the deliverable.
• Preparation of Technical and Functional design documents for Report Studio reports, Coding standards documents, Naming conventions documents, Defect logs, Review Logs.
• Preparation of Effort estimation for each reports and unit testing timeliness.
• Creation of packages using Framework Manager.
• All the calculation is incorporated in FM level to improve performance.
• Created CPF (Project files) and Published projects from the FM Models.
• Created Query subjects, query items, Filters, Namespaces.
• Handled Complex Queries as separate Query Subjects.
• Involved in preparation of unit test plans and unit testing.
• Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.
• Created Dashboards to present critical company data in a single report.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio.
• Experience in developing Framework Manager Models and analyzed those models in analysis studio.
• Gathered and analyzed business requirements from users and business community.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Dimensional modeled packages created using Cognos Framework Manager.
• Unit Testing of Reports, Cubes and Packages.
• Preparation of Load forms for the Migration of the deliverable from development server to QA and Production.
• Supporting QA and UAT testing process.
• Preparation of Technical and Functional specifications for Reports, Cubes and packages.
• Creation of Cubes in both UNIX server and from local (Power play Transformer 7.4).
• Creation of Dashboard Reports using Cube source as package from Cognos Report studio.
• Creation of Drill through Reports from the Dashboard Report.
• Preparation of Code Review documents for the deliverable.
• Migrating and deploying the Cognos code in QA and UAT environments.

Environment: Cognos 8.4,10.2 Report Studio, Powerplay Transformer, Analysis studio, Event studio Cognos Framework Manager and Teradata.