Pavithra Sreenathan

Sr. Cognos Consultant

Email id: adknlc@r.postjobfree.com

Ph No: 908-***-****

Professional Summary:

9+ Years of IT experience in the designing, developing and testing of Data Warehouse and Business Intelligence applications.

Over 7 years of working experience with Cognos 11.0.5/10.2.1/10.1/8.x BI Suite (Framework Manager, Cognos connection, Report Studio, Metric Studio, Analysis Studio and Query Studio).

Expertise in gathering business requirements and creating models & reports to meet the requirements. Handling complete range of BI capabilities: reporting, analysis, dashboards and business event management.

Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.

Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill-through, Master-Detail, and Cascading) and Dashboards using Report studio.

Proficient in design and development of various dashboards reports using tableau visualizations like bar graphs, scatter-plots, pie charts, geographic visualization (Integrated google maps in a dashboard) and making use of actions, local and global filters according to the end user requirement.

Extensive Experience in various Tableau Desktop objects like measures, Dimensions, folder, hierarchies, Extract, filters, table calculation, calculated fields, Parameters, blending and trend lines.

Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports. Hands on experience on data visualization, Tableau 9.1.

Experiment with new features and enhancements released by Tableau and bring them into the platform & organization. Create complex formulas and calculations within Tableau to meet the needs of complex business logic.

Developed Active Reports to meet the user requirement of high interactivity at offline reporting. Developed tabbed reporting/automatic highlighting of chart contents using Active Reports.

Experience in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, donut chart, geographic visualization (Integrated Google maps in a dashboard) and other making use of actions, other local and global filters according to the end user requirement.

Experience creating different views using Tableau Desktop that were published to the business stake holders for analysis and customization using filters and actions.

Extensive knowledge of Tableau server concepts like tabcmd, tabadmin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.

Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop.

Experience in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like star schema and snowflake schema.

Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications.

Extensive experience in Multiple Relational Databases including SQL Server, Oracle & DB2. Experience with writing SQL queries, Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers.

Provide best practices for day-to-day operations, performance analysis, tuning and capacity planning. Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Software Development Life Cycle (SDLC)

Involved in training end users and providing technical support and documentation. Ability to adapt and learn new technologies and to get proficient very quickly with them.

Education:

B.E (ECE), Anna University, India.

Masters in Electrical Engineering from Stevens Institute of Technology New Jersey, USA.

Technical Skills:

BI Tools

Cognos 11.0.5, Cognos10.2.1, 8.x (Report Studio, Framework Manger, Analysis Studio, Query Studio, Business Insight), Transformer 8.3, Microstrategy, Tableau

ETL Tools

Informatica 8.6, Data stage 7.5

Databases

Oracle 9i/10g/11g, SQL Server 2000, Teradata, DB2

Languages Scripting

C, C++, Java, Cobol, VB.net, VB Script, Java Script, HTML, CSS.

DB Tools

SQL *Plus, SQL *Loader, TOAD 8.3

Web Servers

IIS, Apache

Professional Experience:

Walgreen Co., Deerfield IL Nov 2019 – Till Date

Sr. Cognos TM1 Developer

FP & A Cognos TM1 Project to develop and deliver quality applications and reports. Analyze forecast sales increase over last year forecast sales on a day-to-day basis for day. Develop CEO Dashboard reports and Cash flow forecast reports for various profit centers.

Responsibilities:

Develop technical design specifications and analyze data to create data structures

Develop Turbo Integrator processes for both new and existing functionality

Administer all Planning Analytics/TM1 applications for FP&A and Controlling

Create and maintain technical administrative documentation

Facilitates key decisions regarding data standards

Interfaces with key business and project team members to facilitate seamless execution of requirements

Analyzed and resolves cross-functional data issues

Analyzed data to create data structures

Collected data, analyzed and reported for early detection and correction, continual improvement.

Developed reports in a consistent best practices format

Work with management to develop new budgeting tool (i.e. TM1) applications to satisfy ever increasing reporting requirements

Coordinate new reporting requests/changes across the department to ensure accuracy and consistency of reports

Monitor and troubleshoot escalated support tickets

Health Care Services Corporation, Blue Cross and Blue Shield of Illinois May 2019- Oct 2019

Sr. Cognos Developer

FSD 20/20 is a multi-year program that aims to modernize the business and technical capabilities of the Financial Services Division. This program focusses on streamlining operations, processes and systems to improve data quality and enhancing the ability to view financial information in faster and more automated manners by introducing new data analytics tools. This project involved in developing reports and packages for TAX and Financial Balance control LOB.

Responsibilities:

Gathered requirements from users and documented the Functional Specification Documents (FSDs) and Technical specification Documents (TSDs)

Developed Framework manager models for TAX and Financial Balance control using relational models.

Created rule of one report for detail level and summary level using lists, cascading prompts and conditional formatting. Drill through report was created for AAH subledger report through oracle.

Updated the SharePoint site for reporting and analysis by creating pages using HTML and uploaded FSD’s linking them to their respective pages when new reports release.

Created test cases for functional testing in qtest and guided users with UAT.

Deployed reports and packages from Development environment to UAT.

Developed balanced queries to verify report output against database queries and also to see the data variance between the source environments (DataLake) and target EDW.

Involved in creating the User Training manual to help the Business Users understand the reporting architecture and conducted training on cognos technology.

Resolved Incident tickets for production in a timely manner.

Environment: Cognos 11.1 (Framework Manager, Report Studio, Query Studio), Teradata 16.2.

BBVA Compass Bank, Alabama, AL Nov 2016 – May 2019

Cognos Developer/Administrator

BBVA Compass offers a full range of industry-leading and innovative financial products and services, through several major business units including commercial banking, retail banking and wealth management. BBVA Compass is among top 25 largest US Commercial banks based on deposit share market.

This project LOANIQ involves in developing Syndication Agency Platform that will support the growth in Syndications and Multi-Currency Loan client portfolios. Expanded Syndications and Multi-Currency Loan funding capabilities represent key components in growth plans for CIB and BBVA Compass Commercial Banking. The Role of BI is to create 100+ reports for commercial loans line of business to identify their new and renewed loans, check trial balance for each of the obligors, compare GL Balances between FCS and Level 3 application etc.

Responsibilities:

Installed and configured cognos 11.0.5 on single server environment (Dev/QA/Prod) over Red Hat Enterprise Linux 7 operating system and configured LDAP for secure authentication.

Upgraded Cognos software from 11.0.5 to 11.0.10.

Installed and Configured IHS webserver for gateway URI.

Downloaded and installed fix packs required for proper functioning of the environment.

Involved in mapping of fields which is necessary for creation of reports by creating a reporting Matrix.

Defined security structure for the complete user community, by adding roles and groups to the Cognos Connection directory and mapping all the users to one or more of these roles/groups.

Raised PMR’s with IBM involving environment issues and resolved the same.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, conditional formatting, Filters, multi - page, multi-query reports to meet the business user requirements while increasing the accuracy and amount of data presented.

Scheduled reports using Cognos scheduler and configured the server to place the reports onto the landing zone.

Deployed reports and packages from Development environment to UAT.

Created documentation to describe entire flow of the applications, program development, logic, coding, testing, changes and corrections.

Performed Unit testing for all developed reports

Environment: Cognos 11.0.5 (Framework Manager, Report Studio, Query Studio), Oracle SQL Developer, LOANIQ.

Alfa Mutual Insurance, Montgomery AL May 2016 – Oct 2016

Cognos Administrator

Alfa Mutual Insurance Company (Alfa) is a Property & Casualty Insurance (P&C) company serving the insurance needs of customers in Alabama, Georgia and Mississippi. The main objective of this project is to help BI play a pivot role in measuring customer expectations in operations across the enterprise, to set high customer service standards, establishing a unified view of Alfa Customer across different Line of business, providing rich data to facilitate the setting of the right price for Alfa products to match customer needs and deeper understanding of the severity and frequency of losses.

Responsibilities:

Installed Cognos 10.2 on a multi-server environment (Dev/QA/Prod).

Implemented complex row level security in FM and implemented Cognos security folders, users and groups.

Created maintenance tasks on content store and run them on demand at scheduled time or based on trigger.

Worked on performance tuning of servers by increasing the logging levels to run the reports faster.

Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.

Define the security structure for the complete user community, by adding roles and groups to the Cognos Connection directory and mapping all the users to one or more of these roles/groups.

Enhanced framework manager models out of FSLDM (Financial Services Logical Data Modeling)

Developed complex active reports and dashboards using HTML applications for different business subjects such as Enterprise, Marketing, Claims and P&C as per requirements.

Upgraded 30 legacy reports with the new ALFA reporting standards and prepared test cases for the same.

Worked on improving the performance of dashboards and tuned the stored procedures accordingly.

Created reports with the bursting functionality for different departments of insurance.

Developed balanced queries to verify report output against database queries and also to see the data variance between the source environments (Guidewire) and target EDW.

Engaged with testing activities within ALM during SIT and UAT phase.

Created Technical design documents and transferred technical knowledge specific to Cognos tools and existing data model to other team members.

Assisted QA team in documenting and analyzing their current process and then make recommendations for improvement in their functional areas.

Guided offshore team to develop and test reports.

Environment: Cognos 10.2.2 (Framework Manager, Report Studio, Query Studio), Teradata, TOAD

JP Morgan Chase & Co, Salem NH Mar 2015 – Apr 2016

Sr Tableau/Cognos Developer

JP Morgan Chase & Co is a global leader in credit card processing. In 2013, the Basel Committee on Banking Supervision (BCBS) issued Guidelines for all major financial institutions for “Effective Data Management and Risk Reporting.” These principles broadly require that information technology and data architecture to have capabilities to support the broad management of financial and operational risks with the line of business (LOB).

Responsibilities:

Participated in requirement sessions with project managers and assisted the user community with capturing and articulating their reporting needs.

Involved in ETL Mapping Team discussions to solve the issues in mapping document or design. Worked as a part of sprint team in agile methodology. Utilized various agile methodology tools such as MKS and JIRA.

Designed model based on the requirements for Risk functional and Loss Dashboard Reports by analyzing the underlying data. Created models using star schemas, packages using framework manager. Designed and developed reports using the capmat specifications.

Developed various crosstab, list and chart reports using report studio 10.2.1 for commerce solutions line of business.

Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.

Created line charts to display trends over a period of time and tied it with bar charts to show revenue growth based on users upgrading to additional features of the mobile app additionally adding filter to choose between business and personal users.

Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently. Developed various dashboards, used Context filters, sets while dealing with huge volume of data.

Created sophisticated dashboard reports for various reporting requirements like using legacy charts for the loss dashboard reports and also created multi page reports by using Cascading prompts, conditional formatting and page rendering.

Conducted page quality reviews and validation of the quantitative and qualitative content on the report pages prior to them distributed.

Worked within ALM for all testing activities and produced status updates. Tested and validated the report output against the database to measure the performance of the reports. Involved in writing SQL queries using TOAD.

Deployed packages, folders and content store from a development environment to test and then to production environments. Involved in writing test cases for user acceptance testing.

Worked on the BI anatomy tool for generating the flow diagrams and logic implemented in each report for documentation purposes. Scheduled reports to run on monthly basis using control-m.

Environment: Cognos 10.2.1 (Framework Manager, Report Studio), Oracle 11g, Teradata, Tableau (desktop/server) 9.x/8.x TOAD, PL/SQL, Netezza.

The Walt Disney Parks and Resorts, Orlando, FL Mar 2014 – Feb 2015

Sr Tableau/Cognos Developer

The workforce planning and analytics is a division in Human resource which aims in providing statistical and data analysis of the cast members movement, turnover impacts, diversity and compensation impacts. This project involved in developing reports and dashboards for the Human resources (Employee relations and Labor relations) for analyzing the increasing number of cases in parks and resorts.

Responsibilities:

Gathered and analyzed business requirements from the users and transformed them into business intelligence reporting specifications. Interacted with ETL team to gather the requirements for the reporting.

Designed DMR models in Framework Manager. Created and published packages for different functional areas and assigned security rules to them in Framework Manager.

Generated List, Crosstab, Drill through &Master Detail reports for HR Department in Report Studio.

Standardized prompt pages for consistent user experience and to let users choose between different filters. Extensively used Prompts, Filters, Cascading Prompts, Calculations, Conditional Variables, and Multiple Queries for data extraction in reports.

Involved in bursting and scheduling the reports to various Labor Relations managers using Cognos connection.

Defined best practices for Tableau report development and effectively used data blending feature in tableau.

Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.

Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

Creating users, groups, projects, Data connections, settings as a tableau administrator.

Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.

Created dashboards for Employee Relations and Operations (Internal Labor Market). E.g. the core cases received by case type for the various Fiscal Years were compared and also highlighted where there are increasing issues.

Created complex reports that had Multiple Pages, Multiple UI items like Lists, Charts & Charts etc.

Trained users in business Insight & Business Insight advanced for Ad-hoc reporting.

Worked on JavaScript for format customization of Dashboard i.e. created toggle and collapse buttons.

Involved in writing Queries in SQL Server.

Performed data validations, unit testing and preparation of unit test cases.

Involved with making changes in the reports generated as business requirements changed and carried out validation and verification of the reports.

Created models in Transformer built cubes and published cubes to Analysis Studio.

Worked extensively to achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.

Involved with the Solutions Architect and the QA team for validation and verification of the development.

Environment: Cognos 10.2.1 (Framework Manager, Report Studio, Query Studio), DB2, Oracle 11g, SQL Server 2008, TOAD, PL/SQL, SQL Navigator, Tableau (desktop/server) 9.x/8.x, Visual Source Code, Informatica v9.0, Java Script.

Blue Cross Blue Shield, Washington, DC Feb 2013 - Mar 2014

Sr. Cognos Developer

The FEP Director's Office initiated Business Intelligence Strategy (BI Strategy) that includes the need to enhance its Care Coordination Technical Infrastructure (CCTI) so that it provides key operational and analytical functionality to its user community. Developed BI analytics using Cognos suite of products for different business groups.

Responsibilities:

Understood the source system and interacted with users to acquire the elaborate technical and business requirements and required documentation for clear understanding and traceability of requirements.

Installation and configuration of the Cognos 10 in Development environment. Experience in building models using Framework Manager & creating simple to complex reports in Report Studio. Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.

Created Star schema dimensional model. Created Dashboard reports using the Cognos Report Studio.

Knowledge in developing Active reports. Developed ad-hoc reports using Query Studio. Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.

Created custom prompted reports in Report Studio, Bursting reports to different user groups. Deployed Cognos OLAP Cube from Testing Environment to Production Environment using Batch script.

Involved in writing Stored Procedures and imported into Framework Manager to create complex reports. Trained end users effectively to use reporting tool, to build and customize their ad-hoc reports. Implemented Cognos SDK code for extracting the report schedules defined by power users.

Worked on Java Script to perform Prompt page validations. Created the reports with data level security.

Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices. Involved in creating the User Training manual to help the Business Users understand the reporting architecture.

Documented the Lessons Learnt and Best Practices. Conducted training on Cognos technology to the Business users. Mentored the Project Team on latest trends in Reporting. Deployed the Cognos content from Development environment to UAT/Production environments.

Environment: Cognos 10.2.1 (Framework Manager, Transformer, Report Studio, Query Studio), DB2, Oracle 11g, Cognos SDK, WAS, SQL Server 2008, TOAD, PL/SQL, Java Script, Data Stage, Linux.

Biogen Idec Pharmaceuticals, Weston, MA Aug 2012 – Jan 2013

Cognos Administrator

The Cognos BI portal provides the Business Analytics group with a wide variety of pre-designed reports and also the capability to generate ad-hoc reports using any one of the various packages available for different user communities.

Responsibilities:

Installed and configured Cognos 10 BI Application with complete suite of tools on distributed environment over windows operating system. Installed and configured IIS Web server.

Configured the LDAP Namespace for the novel Directory server to be used for third party authentication tool. Created maintenance tasks and run them on demand at scheduled time or based on trigger.

Worked on performance tuning of servers by increasing the logging levels to run the reports faster and Evaluated the system performance by creating a score card. Secured Cognos Connection security by assigning users to the groups and roles defined in Cognos Namespace.

Deployed framework models and reports from Dev to test and then to production environments. Enhanced the Powerplay, Framework Models and Reports to meet the changing business requirements.

Created models (. cpf) in Framework Manager Modeling tool and publish packages in Cognos Connection. Created a Framework Manager Model with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.

Develop new reports on timely bases, by extracting new data from database by running the DTS packages and rebuilding the OLAP cubes. Created Powerplay cubes using multiple data sources, which are retrieved by Cognos Packages and Reports.

Created Complex Multi-Object Reports using Lists, Charts, Crosstabs and Images using Report Studio and Ad-hoc reports in Query Studio. Applied Security and User Authentication to the various User Groups.

Environment: Cognos 8.2 BI Series (Report Studio, Query Studio, Analysis Studio, Metric Studio), Framework Manager v8.2, Series7.3 (Transformer, PPES and all Server Administration), Python, Informatica Power Center v7.1, Toad v7.6, Java, JSP, Oracle 9i, DB2, Win2K, UNIX (AIX)

Prelude Systems, India Feb 2010 - June 2012

Cognos Developer

EMC provides technology, products, and services to consumers in more than 100 countries. Project involved participation in the development of decision-making support solutions, giving mainstream users the ability to access, analyze and share information in the company’s database by producing reports for billing, marketing and gross profit analyses.

Responsibilities:

Interviewed business community to identify business, data, and delivery requirements.

Designed models in Framework Manager.

Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and Prompts depending on user requirements.

Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio

Created reports containing multiple data containers like List, Cross-tab and Repeater tables

Created dashboards for a managerial overview with drill up and drill down capabilities.

Created models in Transformer, built cubes and published cubes to Power Play server.

Scheduled reports using Cognos scheduler and emailed to various recipients as required.

Worked on TOAD for Oracle database systems for creation of Adhoc queries and for improving various performance issues.

Experience with oracle as the target for the data marts.

Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.

Environment: Cognos 8, Transformer 8, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 SDK.

Contact this candidate