Manager Reports
Pavithra Sreenathan
Senior Cognos Developer
acw6fy@r.postjobfree.com
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 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
Hands on 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
Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.
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 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
Technical Skills:
BI tools:
Cognos10.2.1, 8.x (Report Studio, Framework Manger, Analysis Studio, Query Studio, Business Insight), Transformer 8.3,
ETL Tools:
Informatica 8.6, Data stage 7.5
Databases:
Oracle 9i/10g/11g, SQLServer 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:
Alfa Mutual Insurance, Montgomery AL Mar 2016 – Till Date
Sr. Cognos Developer
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:
Gathered and documented requirements from end users in JAD sessions to develop active reports and Dashboards
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 using Cognos 10.2.2.
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), JavaScript, Teradata, TOAD, PL/SQL, DB2
JP Morgan Chase & Co, Salem NH Mar 2015 – Feb 2016
Sr 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.
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, TOAD, PL/SQL, Netezza.
The Walt Disney Parks and Resorts, Orlando, FL Mar 2014 – Feb 2015
Sr. 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.
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, Visual Source Code, Informatica v9.0, Java Script.
Blue Cross Blue Shield, Washington, DC Jan 2012 - Feb 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, zLinux.
Farmers Insurance, Los Angeles, CA Jul 2010 – Dec 2011
Sr Cognos Developer/Administrator
Farmers Insurance Group is a provider of insurance management services. This project was developed for Financial, Sales, Marketing and Support user groups to analyze data for their requirements.
Responsibilities:
Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
Installation, Configuration and Maintenance of Cognos Application on Development and UAT Environments.
Customized Cognos Connection with appropriate reports and security measures.
Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
Created multi-page reports based on multiple master queries to show the data on different pages when the master record changes in a report using Report Studio.
Conceptualize and formalize several list, crosstab, master-detail, drill-down and bursting reports to be developed, using Report Studio, and made available to the users.
Bursted the reports in Cognos Connection based on the RDT number.
Developed a renaming utility using SDK to rename the bursted reports for better distribution of the reports to various user groups.
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.
Deployment of reports, packages, users and sometimes the complete content store from one environment to the other.
Created various IQD packages in Framework Manager and used this IQD’s in PowerPlay transformer to create various models and build cubes
Migrated reports from Micro Strategy to Cognos 8 environment.
Developing multi-dimensional analysis and business metrics reports using Cognos PowerPlay and Power Cubes using Cognos Transformation Server.
Prepared detailed user manual(s), for different package(s), explaining the business rules behind all the fields in the package.
Trained business users on how to create ad-hoc reports using Query Studio.
Environment: Cognos 10.1.1/8.4, Framework Manager, Transformer, Report Studio, Query Studio, Oracle 11g, SQL Server 2008, TOAD, SQL Navigator, PL/SQL, Java Script, Informatica 9, AIX.
Bank of America, Wilmington, DE Oct 2009 – Jun 2010
Sr. Cognos Consultant
Bank of America Card Services is one of the major revenue generator and the customer serving business. Involved in implementing Cognos BI analytics for Bank of America Card Services business groups.
Responsibilities:
Discussed with clients about their present reporting system and understand their current reporting issues to meet their needs
Built POC reports to showcase how to achieve client needs using real time scenarios.
Demonstrate the flexibility of Cognos using Cognos Report Studio, Analysis Studio and how Cognos could help them to meet their reporting needs.
Performed the distributed installation and configuration of Cognos 8.3 on new servers in Production, Testing and Development environments.
Fact and Dimension tables were used in the Cognos FM model for Package building.
Built new packages using Cognos Framework Manager and converted the existing reports from Excel to Cognos reports using Cognos Report Studio.
Used ROLAP and OLAP models as source to create reports using Report Studio.
Built complex reports using SQL scripts.
Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly.
Deployed the Cognos Content from Development environment to UAT/Production environments
Closely worked with Cognos Support team for troubleshooting complex issues.
Responsible for creating the Cubes and Reports and scheduling them accordingly
Extensively used PowerPlay Transformer to move relative data mart data into Power Cubes.
Maintained users, groups, and roles and assign them respective privileges as per business needs.
Environment: Cognos 8.4, Transformer 8.4, Report Studio, Query Studio, Metric Studio, Oracle 10g, Sybase IQ 12, Erwin 4.0, TOAD, PL/SQL, SDK,Informatica 8, UNIX (Sun Solaris).
Biogen Idec Pharmaceuticals, Weston, MA Sep 2008 – Sep 2009
Sr. Cognos Developer
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.
Enhancing 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.
Defining the Users, Group and Roles in LDAP using Cognos Access Manager.
Developed Complex Report Studio Reports using Bursting, Tabular Objects.
Securing Cognos Connection and setup ReportNet security by assigning users to the groups and roles defined in Cognos Namespace.
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.
Build a dashboard report in PowerPlay which indicates the Key Performance Indicators (KPI)
Created Drill- through reports and Customized Reports with Prompts (List. Cross tab)
Developed Standard templates in Report Studio for developing reports.
Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
Created several different types of Professional Reports (Mailing Labels, Cascading, Linked /Drill Through, Production, Business, Ranking, etc…) with complex formatting utilizing Report Studio
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 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)
State farm Insurance Group Feb 2008 - Aug 2008
Cognos Developer
Installed and configured Cognos ReportNet and development work was been done in Windows-based Cognos 8.
Developed 45 Report Studio reports
Gathered business requirements by conducting user interviews and documented their query, business analysis and reporting needs.
While creating Framework Manager Model, worked on different possibilities like segmentation, links and shortcuts etc., to get the best model for the business.
Created stored procedures and views and imported into Framework Manager to create some complex reports.
Extensively used conditional block sections for creating multiple queries in a single Cognos ReportNet Reports for reuse and layout.
Responsible for creating the Cubes and Reports and Scheduling them accordingly
Integrated Cognos PowerPlay Cubes and Reports with Cognos Connection.
Environment: Cognos 8, Series7 (PowerPlay Transformer, PPES, Access Manager, Upfront and all Server Administration), Informatica Power Center v6.2, Tomcat 5.1 application Server, Java, DB2, PeopleSoft HR/Financials, UNIX (AIX)
Prelude Systems, Chennai, India Sep 2006 – Dec 2007
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