SUMMARY

• 14+ years of experience in the IT industry as Senior Cognos / Tableau developer and modeler in building framework models/packages, creating dashboards, reports for automotive, manufacturing, power & gas distribution, healthcare, insurance, and agriculture industries.
• Extensively worked Cognos dashboards/reports (v11.0.13, v10.2.2 ) Cognos Framework Manager creating from framework models from scratch, enhancing, maintaining, upgrading ad hoc and regular models and publishing FM packages for report authors and end users.
• Expert in modeling power cubes using transformer, dynamic cube incorporating
• IBM Cognos Cube Designer importing data both from data warehouse and from DMR models created by me in Cognos framework manager.
• IBM certified Cognos BI Metadata Model Developer, Cognos report author, and Cognos Administrator
• Possess expert level technical knowledge, business process and requirements analysis, data analysis skills, along with complex framework, dashboard /report designing and developing.
• Expert level knowledge in Oracle, Teradata, SQL Server, and MySQL Sql queries
• Demonstrated outstanding leadership, creative problem solving and analytical skills in the areas of developing business intelligence (BI) reports/dashboards, frameworks and worked with several groups across multiple platforms at the same time.
• Expert hand in creating Cognos Active reports to demonstrate interactive behavior in dashboards.
• Capable of handling multiple projects and roles simultaneously and on timely manner.
• Can adapt to any diverse environments, handle critical issues, and can accept challenging assignments with enthusiasm.
• Building Power cubes and dynamic cubes in PowerPlay Transformer and IBM Cognos Cube Designer.
• Extensively and directly worked with end users, stake holders, business analysts, DBAs, and technical leads on business requirements, data requirements for creating framework models and creating dashboards/Cognos reports.
• Have excellent oral and written communication skills along with outstanding interpersonal skills.
• Expert level knowledge in developing dashboards, worksheets, parameterized filters, creating users, granting/denying permissions, scheduling reports, publishing dashboards in Tableau

TECHNICAL SKILLS

BI Tools: IBM Cognos series 11 (11.0.13), 10 (10.2), 8 and 7 ( Impromptu), Framework Manager series 10 and 8., Report Studio, Query Studio, Analysis Studio, ReportNet 1.1/1.02, Cognos 7.4, Impromptu, IBM Cognos Cube Designer v11, IBM Cognos PowerPlay Studio Version 10.2.0, Access Manager, Tableau v 10.5/10.4/10.3 , Powerplay v7.5, IBM Dynamic Cubes Designer 10.2.2, IBM Cognos Transformer

Databases: Teradata 15.0/ 14.10 / Oracle 11G/10G /9i, MS SQL Server 2017, 2016, 2012, 2008, 2007. MySQL v6.0, MS Access), DB2 10.5

Query Tools: Teradata Express 15.10.01.01 / DbVisualizer 9.1.6 / TOAD v9.5, . DBeaver 6.0.2

Languages: SQL * Plus, PL/SQL, VB 6.0, TSL, HTML, XML

Test Automated Tool: Life Cycle Manager/ Upgrade Manager

Operating Systems: Windows 10, windows 7, (NT 4.0/ 95/ 98/ 2000 / XP Professional)

Application Software: MS Office 2000/2003/2007/2010

Internet Technology: Internet Explorer, Netscape Navigation and Mozilla Firefox.

Documentation Tool: Harvest Change Management, SharePoint

Defects Tracking Tool: Test Director 9.5, HP 9.3 /10.0

Others: MS Office suite, Erwin 7.0, MS Outlook, and Lotus Notes etc.

PROFESSIONAL EXPERIENCE

Confidential, Fremont, Michigan

Senior Cognos Developer and Framework Modeler

Responsibilities:

• Gathered requirements related to the data sources and the reporting matters directly from the end users/power users.
• Spited the ‘Policy’ framework model into pieces, department wise for data accuracy eliminating data duplication, avoiding loop joins, and for better performance.
• Created the DMR model to use in the ‘Dynamic Cube’ as data source.
• Enhanced the ‘Sales’ cube adding ‘Day label’ bellow the week label.
• Added ‘State Label, under country in the ‘Sales cube’.
• Applied row level security to ensure right person see the right data
• Applied determinant to eliminate data duplication.
• Avoided full outer joins creating separate star schema
• Published the package and created standard reports out of these packages
• Dealt with the QA teams to help them testing the reports and to get sign offs.
• Worked with the end users to get sign offs
• Worked with the migration team to get the report migrated to test and then production environment.
• Created standard documents for the requirements and uploaded them into ‘SharePoint’ site.
• Incorporated a database procedure into framework manager creating a query subject then fixed it and published it.
• Modifying the Sales cube to change the Time dimension to add ‘day’ as the lowest level.

Confidential, Naples, Florida

Senior BI Developer and Framework Modeler

Responsibilities:

• Worked closely with the stakeholders, end users, business analysts, DBAs, data architects, Etl teams, testing teams to gather and analyze business requirements, analyze data for accuracy to meet the reporting requirements, to create technical documents and so on.
• Created the Cognos Framework models from scratch for the ‘eSurgery’, ‘ Red Heart’, and ‘Back Order’ projects.
• Converted the ‘Sales’ cube modeled in Transformer to ‘Dynamic Cube’ creating a DMR model in framework manager to use as the data source. Added relative time into the time dimension to fulfill business needs.
• Created row level, object level, and package level security in framework manager to restrict users on objects, and on data for specific dimension, and facts.
• Performed unit test, and then worked with the testing teams to get the dashboards and reports passed to get them promoted to production environment from QA environments.
• Created data sources in ‘CQM’ and ‘DQM’ from the Cognos Analytics (v11.0.13) ‘configuration> data source connection page to connect data to the data sources in framework manager.
• Promoted packages and reports from development to test, and then from test to production environments.
• Added / removed users in Cognos Analytics (v11.0.13) using administration console (Cognos administration> security> Users, groups, and roles tab) to give access and deny access to specific objects by users, user groups, and roles.
• Improved performance of reports by removing the functions like ‘trunk’, taking advantage of indexing, and data base partitioning, avoiding full outer joins etc.
• Resolved the loops in framework manager creating alias queries, and short cuts.
• Followed the IBM best practices like creating 03 layers and so on in framework manager.
• Changed the defaults governor settings in framework manager to meet and fix issues.
• Fixed report errors and closed tickets created by end users in production environments.
• Performed robust conditional formatting per the requirement of the end users.
• Applied parameter map in framework manager for creating row level security.

Confidential, Detroit, Michigan

Senior Cognos Developer and Framework Modeler

Responsibilities:

• Gathered requirements from end users, stake holders, business analysts, analyzed the business process and logic for transforming them into report requirements for creating reports and dashboards.
• Performed data analysis from multiple data bases/schemas incorporating Teradata Express, TOAD, SQL Developer to ensure data accuracy on reports.
• Provided full time production support to fix the broken reports, to make sure scheduled reports are running on time, especially late - night scheduled reports,
• Created Ad hoc frameworks for the GMTOPs, Aries, Isuzu, FCR, and KPI projects from scratch applying framework best practices (IBM) and adding, determinants, resolving loops and circular joins wherever needed, created bridge table to retrieve data from multiple fact tables and also enhanced and maintained other FM models to support those applications.
• Created highly complex reports and dashboards resolving data issues, doing performance tuning from these frameworks,
• Gathered business requirements, analyzed business process to develop framework models and create dashboards and reports. Discussed with stakeholders, end users and Business Analysts to finalize them.
• Created requirements document and technical specs and uploaded the documents into the SharePoint site for future references by team mates.
• Created row level security, object level security and package level security to secure data from unauthorized access by users.
• Performed Cognos administration and security (Design, implement and administering securities)
• Involved in physical and logical data modeling, to ensure that the objects and views meet the requirements of frameworks and the reports.
• Worked with Data Warehouse team, DBAs, Business Analysts as needed to define new data warehouse tables, new fields & attributes, additional indexing and partitioning needed for reporting.
• Created Cognos Active reports for displaying interactive functionality in Cognos v11 and v10 series
• Developed Dynamic Cubes in IBM Dynamic Cube Designer.
• Performed in depth data analysis incorporating Teradata Express for Teradata and Toad for Oracle retrieving data from the Data Warehouse and data marts
• Migrated reports from Cognos 10.2 to Cognos 11.0 (Cognos Analytics)
• Worked with the QA team helping them to test the reports and getting QA sign offs.
• Worked in all phases of Software Development Life Cycle (SDLC) from start to end.
• Mentored new developers by debugging their codes, performance tuning their reports
• Performed heavy conditional formatting using style variables on reports to enable the end users to identify data of different ranges on different colors for analysis.
• Trained the end users of the GMTOPs project and taught them how to create, modify, and add logic and filters in Cognos v11.07 and v10.2 as they were in new in Cognos.
• Created user's manual and developer's manual for the end users for GMTOPs project as they used MicroStrategy as their reporting tool for more than 15 years.
• Created cascaded prompts in reports for filtering of data step by step.
• Created dashboards with key business information (KPI) for top management.
• Created Drill through/ Drill Down reports for navigating from report to report, drilling up and down.
• Did performance tuning of the complex reports/SQLs for better performance, and smooth running of reports.
• Developed complex SQL queries to create dashboard with tabular SQL.
• Developing and publishing packages using Framework Manager for report authors to develop Cognos reports and dash boards.
• Developed complex frameworks following the IBM best practices, and enhanced framework models by adding/deleting new objects, and resolving loop issues, removing ambiguous join paths.
• Created IQD files in Framework Manager to be used in Power Play Transformer for creating Multidimensional cubes.
• Created, Enhanced and maintained the ISUZU and ARIES cubes.
• Created data source connections and connected the to data source and then imported data to the database layer for creating the framework model.
• Created the business layer and added business logic, calculated columns to meet the business requirements.
• Defined appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Closed loops and circular joins between query subjects in framework manager
• Applied determinants in framework manager to control duplicate data in reports.
• Applied parameter map, session parameter, dynamic filters, and macro functions in FM.
• Supported production issues like attending helpdesk tickets created by end users on report issues such as missing of data, fixing broken links, etc.
• Created user groups and added / deleted users to and from reports and dashboards in Cognos connection.
• Created OLAP type DMR models in Cognos framework for drill up and drill through.
• Promoted reports from Cognos development environment to Test for QA testing and then to production for the use of the end users.
• Migrated and recreated reports and dashboards from Cognos 8.4 to Cognos 10.2 and then v10.2 to v11.0.7 environment.
• Created schedules of reports depending upon end user’s requirements.
• Extensively worked in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau v2018.1, v10.5, v10.4, v10.3, v10.2 v8, v7
• Created complex dashboards and sheets in Tableau Desktop that were published to the server.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within dashboards, sheets, schedules etc.
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Extensive experience on building Interactive dashboards using Tableau.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Implemented best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Created different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Confidential, Richmond, Virginia

Senior Reporting Specialist and Framework Designer

Responsibilities:

• Worked closely with business analysts and end users to analyze the business process and user requirements to cater their needs for reports, frameworks and multidimensional cubes.
• Involved in physical and logical data modeling, star schema design, design of dimension and fact tables for creating framework.
• Creates complex frameworks from scratch and developed critical reports resolving data issues from these FM models.
• Worked closely with database administrators, data architects, business managers to ensure database designs provides appropriate levels of accuracy, flexibility, and resolves performance issues.
• Performed Cognos administrative adding security measures to reports, cubes, and dashboards.
• Added row level, data level security to query subjects and query items, and framework packages.
• Created dashboards with key business information for top management.
• Performed data analysis between multiple data bases/schemas and verified data accuracy incorporating TOAD/SQL Developer to ensure correctness of data on reports.
• Prepared and modified the technical documents and upload them in the SharePoint site/ Shared drive for report requirements and also for future references by team mates.
• Added heavy conditional formatting into reports for analysis and to distinguish data of different nature.
• Mentored new developers, business users on creation of ad-hoc reports.
• Incorporated Life Cycle Manager for automated testing and comparing of reports, tested and validated over 300 reports and the 10 frameworks before migrating them from series 7.4 to 8.2 and then to 8.4.1 and ensured that reported data, report design and format were correct.
• Did performance tuning of the complex reports for better performance after migrating them to 8.2 and then to 8.4.1 series.
• Worked independently and also as a great team player.
• Created the DUF cube to determine the load on transformers and then created Scorecards using the DUF cube as data source
• Modified and updated TRS Circuit Outages and TRS Outages Detail Cubes from scratch for reporting the troubles in the distribution of electricity. Developed the IQD files, imported data from multiple data sources through the IQD files, and populated the reports.
• Performed yearly maintenance of the 05 cubes adding 2009/2010 years, quarters and months.
• Created Drill through/ Drill Down reports for navigating from report to report, drilling up and down.
• Created IQD files in Framework Manager to be used in Power Play Transformer for creating Multidimensional cubes.
• Supported production issues like attending helpdesk tickets created by end users on report issues such as data not found, report link broke, can not log into Cognos portal, data mismatch etc.
• Did Troubleshooting on administrative issues, reporting issues, and resolving user’s problems.
• Interviewed new incumbents, mentored new team members, provided training to the user class.

Environment: Cognos 8.4/8.3/8.2, Power Play, Cognos Power Play Transformer, Oracle 10G/11G, Office2003/2007, SQL Server 2005/2008, Windows XP, Harvest Change Management, HP QA Center 9.2, Test Director 9.4, QTP 9.3, MS Outlook, Lotus Notes, Data warehouse/ Data Marts, Life Cycle Manager