PRADNYA GAONKAR

Cognos/Tableau BI Developer

Professional Summary

IBM Cognos 10 certified professional with over 8 years of analytical reporting experience in Report studio, Business insight, Workspace advanced, Active Reports, metadata modeling in Cognos Framework Manager and building cubes in Cognos Transformer

2 years of experience in creating visualizations and interactive dashboards in Tableau desktop and server

Expert in Business Objects XIR3 tools: Universe Designer, Desktop Intelligence, web intelligence rich client (Webi), central management console (CMC) and translation manager

Skillful in working on databases like Microsoft SQL server, Oracle PL/SQL and Netezza

Extensive experience in design, development and deployment of data warehouse, business intelligence applications

Good understanding of business processes in Healthcare, Financial Investments, manufacturing and Insurance domains

Highlights

IBM Cognos 10 BI suite

Business Objects XIR3 Suite

Tableau 8/9 Desktop and Server

Microsoft sql, Oracle PL/SQL queries and Netezza

JavaScript

Microsoft Office Analytics and Visio

Problem-solver

Good interpersonal and communication skills

Excellent theoretical and analytical skills

Self-motivated

Creative, resourceful and flexible

Quick Learner

Certifications

IBM Certified Designer – Cognos 10 BI Reports

IBM Certified Designer – Cognos 10 BI Multidimensional Reports

IBM Certified Developer – Cognos 10 BI Metadata Models

Work Experience

Senior BI Developer Sept 2015 - Till date

Client: Premier Healthcare Inc. Charlotte NC

Developed complex reports and dashboards in Cognos Business Insight and Tableau desktop to help users get answers to questions about population health, readmissions, mortality and length of stay

Saved nearly $500K by providing training on Cognos and Tableau tools to 30-35 Business and technical users

Provided technical support to business users and resolved issues occurring in various Cognos studios and Tableau visualizations.

Built Cognos Active reports enabling ease of report distribution for mobile devises and offline usage

Reduced project cost by $70k by building Tableau and Cognos training manuals for healthcare clients

Created Visualizations in Tableau Desktop with below scenarios:

Interactive dashboards combining various individual worksheets, filters and using worksheet actions like filter, highlight and URL

Advanced charts like bubble chart, box plot, tree maps, dual axis charts, histograms, heat maps, bullet graphs and gantt plot

Statistical analysis using trend lines, Forecast, Reference line, Average line etc in various charts and graphs to highlight data trends

Worked on metadata in Tableau desktop to rename fields, modify data types, assign roles, joins, refresh data and change extract data options to prepare data sources to be used by Tableau users.

Used Netezza, MS SQL Server, Excel, Access, Text file and CSV file as data sources

Used Maps, context filters, parameters, calculated fields, table calculations and LODs

Created complex filters, sets, hierarchies, calculations and parameters for implementing effective dashboards

Optimized system performance by collaborating with infrastructure, ETL and database teams on a regular basis

Used Aginity Workbench to query Netezza for unit testing and for resolving data/performance related issues

Enhanced quality of the deliverables by encouraging best practices in reporting and modeling areas

Monitored occurrences of specific events in data using Cognos Event Studio and issued notifications and alerts as needed

Created audit model and reports for internal teams to analyze usage and monitor performance

Documented design specifications and database mappings and used them for Cognos FM model development

Simplified report delivery without affecting server performance by planning and scheduling reports during non-peak hours in Cognos connection

Tools: Tableau 8/Tableau 9 (Desktop, Server), Cognos 10.2.1/10.2.2 suite, Netezza, Aginity Workbench

BI metadata modeler and developer Jan 2013 - Aug 2015

Client: TIAA-CREF Charlotte, NC

Performed analysis in different business areas and developed interactive dashboards which demonstrates key performance indicators (KPIs) highlighting success in business units

Designed Cognos Framework Manager Packages on Oracle data source. Created Dimensionally Modeled Relational (DMR) packages for users to develop ad-hoc reports in Cognos insight advanced and other studios

Built OLAP cubes using Cognos Transformer to meet the dimensional analysis needs

Documented design specifications and database mappings and used them for Cognos FM model development

Streamlined FM modeling process using best practices to import metadata, preparing business logic, 3 tier design, data models involving cardinalities, joins, unions, resolving loops using contexts/aliases and variables, setting up object level security and publishing packages to cognos connection

Debugged/resolved issues while performance tuning due to the usage of multiple queries, improper query joins, complex master detail relationships and ambiguities in Framework model

Solved various data issues during unit and SIT testing by writing complex Oracle SQL queries using toad to ensure reports and models meet the acceptance criteria

Authored complex Report Studio reports using relational, DMR and cube data involving below scenarios:

Drill up/drill down/drill through/Master-detail reports

Used joins to create multi query reports

Conditional display of data containers based on user selections using Smart Prompts

Dynamic filters and sorts, cascading prompts

Complex calculations using various built-in Functions and Parameters

Improved report distribution and system performance by implementing report bursting

Eliminated the need for external training by gaining on-job knowledge of Tableau 8 desktop visualization tool, thereby reducing the cost to the project

Developed scorecards using Metric designer and Metric Studio

Mentored 3-5 new recruits in project methodologies and technical tools

Tools: Cognos 10.1 Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Tableau 8 desktop, Toad and Oracle 11g

Senior Business Intelligence Analyst Jul 2011 - Nov 2012

Client: MetLife Somerset, NJ

Automated the manual task of validating more than 100 reports and sending to the users on a daily/weekly basis by creating a program that reduced the daily effort from 3 hours to 15 minutes

Designed and created management reports based on Relational, Dimensional and DMR models which were distributed via Cognos connection to 300 clients on a frequent basis

Contributed to the upgrade of Cognos 8 to Cognos 10 by taking charge of migrating and testing the packages and reports

Implemented advanced prompting in report pages using JavaScript to enhance performance

Enhanced the user experience by designing reports with dynamic filters, dynamic sort, cascading prompts and customized prompt parameters, which allowed users to choose what data they want to see

Minimized design issues by building prototypes and report samples using Excel and Visio during the early stages of requirement gathering.

Established a streamlined process and documented the design, development, testing and deployment activities to onboard the new recruits into the project tasks seamlessly

Developed SQL stored procedures and scripts to load data from flat files and other external sources

Ensured data security by planning and implementing various security measures in framework manager packages

Ensured system stability by providing production support and resolving maintenance issues

Tools: Cognos 8.4 Report Studio, Query Studio, Analysis Studio, Framework Manager, JavaScript, HTML and MS SQL server

Senior Cognos Developer Aug 2010 - Jun 2011 Client: CITI Group Warren, NJ

Transitioned users from Business Objects to Cognos by performing regular trainings, presentations and building application specific knowledge and troubleshooting documents

Facilitated the requirement gathering by acting as a liaison between the business and database team

Built technical and functional specifications to establish the BI development process

Built relational and dimensional metadata models, modified, and published several packages using the data from the Enterprise data warehouse

Business Objects reports were re-created in Cognos report studio by analyzing and modeling the metadata in Cognos Framework Manager

Used JavaScript and HTML to customize and enhance cognos report interactivity

Tools: Business objects XIR3, Cognos 8.4 suite, JavaScript, HTML, MS SQL Server, and Oracle9i

Senior BI Developer Oct 2008 - May 2010

IBM Global Services - Saint Gobain Chennai, India

Worked in all the phases of Business Intelligence project lifecycle including planning, requirements gathering, data modeling, database design, data loading, FM models design, report development, performance tuning and data delivery

Imported the Reports developed in Report Studio into Microsoft Excel and PowerPoint using Cognos Go! Office for distribution and presentation purposes

Deployed packages and reports across Development, SIT and UAT environment and created required requests for Production release process

Tools: Cognos 8.4(Report Studio, Query Studio, Analysis Studio, Framework Manager, Go! Office), SQL Server

Cognos and Business Objects Developer May 2006 - Sept 2008

Cognizant Technology Solutions - BI COE for Healthcare Chennai, India

Produced competitive healthcare solutions in Claims, Member-Subscriber, Provider, Billing, Commission and Utilization Management areas

As a part of the COE team designed and worked on proof of concept (POC) and presented Business Intelligence solutions to Cognizant’s various healthcare customers.

Saved 30% of the project budget by acquiring on job knowledge in various Business Objects tool like Universe Designer, Webi and Desktop intelligence and training 10-15 team members

Added 4 new clients to the organization based on the solutions provided in Cognos and BO analytics

Tools: Cognos 8.1, Cognos 8.3(Framework manager, Report Studio, Query Studio), Cognos Connection, Business Objects XIR2/R3 Suite, Sybase DB, Oracle 8i

Cognos Developer Dec 2005 - Apr 2006

Cognizant Technology Solutions - MetLife (Insurance) Chennai, India

Translated the business requirements and analysis documents into data mapping and technical specifications document

Migrated Visual Basic reports to Cognos Reports using Reportnet and using JavaScript for alerts and validations

Tools: Cognos 7 series, Oracle 8i, Windows NT 4.0, T-SQL

Education

Bachelor of Engineering, Goa University, India

Technical Skills

IBM Cognos 10.x suite - Report Studio, Framework Manager, Workspace Advanced, Business Insight, Query Studio, Analysis Studio, Metric designer, Metric studio, Event Studio, Cognos Connection, Cognos Configuration and administration; Tableau 8/9 desktop and Tableau server; Business Objects XIR3 Suite – Desktop Intelligence, Web Intelligence(Webi), Universe Designer, Central Management Console(CMC) and infoview; Microsoft SQL server, Oracle PL/SQL, Netezza, Toad, AQT and Aginity Workbench; Informatica; Microsoft Office analytics, Microsoft Visio, JavaScript and HTML.

Contact this candidate