Manager Developer

SRINIVASULU Sr. Cognos Developer

SUMMARY

A Dynamic professional with 10+ years of experience in Cognos and Tableau Technology in Data Warehousing Environment in debugging, testing, maintenance, design, development and customer support.

A project planner with experience of working on projects and ensuring delivery of projects within the time & cost parameters.

Adept in end-to-end development of software products from requirement analysis to system study, designing, coding, testing, de- bugging, documentation and implementation.

Experience with analysis, design, development, customizations & implementation of software applications.

Proficient in production support, development, enhancement, debugging and testing.

Sound skills in Cognos 10 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio, Transformer).

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

Developed database schemas like star schema and snowflake schema used in relational modeling.

Work Experience in Transformer model design and Power play cube building.

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

Installation, upgradation and configuration of Tableau Server and Tableau Desktop.

Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8/cognos10 Environment.

Worked in Agile and SCRUM and Waterfall development models.

Having knowledge on ETL tools like Informatica.

Good experience in Oracle SQL and PL/SQL, Sql Server.

Experience in interacting with end users to gather requirements for reporting

Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.

Has great motivation to learn new skills/technologies, excellent analytical/problem solving skills, fast-leaner, resourceful, committed, hard-worker and self-initiative.

Knowledge on Cognos 11 analytics.

TECHNICAL SKILLS

Operating Systems

Win95/98/ XP/NT/2000

Languages

C#.NET, ASP.NET

DBMS/RDBMS

Oracle 10g\11g\DB2\SQL Server2005,2008R2,2012 R2\Teradata

Development Tool

Cognos8 and Cognos10 (Query Studio, Report Studio, Analysis Studio, Framework Manager), Tableau Desktop 9.x/8.x, Tableau Server 9.x/8.x

Productivity Tools

Erwin, MS Office tools such as MS Visio, MS Project, and MS Share Point.

EDUCATION DETAILS

Master’s in Information Technology from Manipal University, India.

CERTIFICATIONS

Certified from IBM as Cognos10 Designer Developer (2012).

Certified from IBM as Cognos8 BI Author (2008).

Certified from IBM as Cognos8 Metadata Developer (2010).

Certified from IBM as Cognos8 Administrator (2010).

PROFESSIONAL WORK EXPERIENCE

Teachers Insurance and Annuity Association, Charlotte, NC December 2015 - Till Date

Role: Sr. Cognos Developer

Description: Teachers Insurance and Annuity Association – College Retirement Equities Fund (TIAA–CREF) is a Fortune 100 financial services organization that is the leading retirement provider for people who work in the academic, research, medical and cultural fields. TIAA–CREF serves 3.9 million active and retired employees participating at more than 15,000 institutions and has $502 billion in combined assets under management.

Responsibilities:

Analyzed the business, designed and developed the Framework Manager models to meet the reporting requirements

Performed the analysis on the report requirements and suggested end users on the usage of dashboards to minimize the maximum report runs

Trained and supported users to understand the functionality of Query Studio and scheduling of the reports

Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail

Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validating the Prompts using Java Script

Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues

Performed Unit testing on Dev and supported the users on UAT and Production

Extensively worked on performance tuning both at Cognos and database level

Developed and Maintained technical documentation of the implementation

Trained end users in Business Insight/Workspace & Business Insight/Workspace Advanced

Created dashboards for senior management to have a single view on complete business

Created the canned reports for unit testing of the data loaded into the staging tables for E.T.L folks to perform the easy testing

Created documents for my team members on how to schedule the reports into external portal from Cognos and learn the component for their business needs

Created active reports for the management reports which gives a high level view of data with tabbed inter phase and decks

Worked on a POC (Proof of concept) to view the 10.2 dynamic cubes functionality and implemented the cubes and pushed till UAT (User acceptance testing) environment

Worked closely with business to make sure the development is in line with the requirements and interacted with ETL folks to make sure the tables are loaded as per the needs and in optimal performance retrieval way

Created presentations to expose the development work to end users and the stake holders

Interacted with the offshore teams to support work and helping them in resolving the issues

Provided support on the existing applications and acted as an SME for resolving the issues

Worked on a tight deadlines and delivered the reports in given time frame including the testing and documentation

Wrote complex SQL's for the report views which gives optimal performance

Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.

Environment : Windows 10/ Oracle 11g/Cognos10.2.2

Health Insurance Market Place, Blue Cross Blue Shield, Ivy Creek Blvd, NC

Role: Sr. Cognos Developer December 2014 – August 2015

Description: Blue Cross Blue Shield a nonprofit mutual insurance company, is an independent licensee of the Blue Cross and Blue Shield Association. BCBSM provides and administers health benefits to more than 4.4 million members residing in Michigan in addition to employees of Michigan-headquartered companies who reside outside the state. The Blue Cross and Blue Shield Association is a national federation of 36 independent, community-based and locally-operated Blue Cross and Blue Shield companies that collectively provide healthcare coverage for nearly 105 million members – one-in-three Americans.

Responsibilities:

Gathering the requirements and prepare report design documents.

Planned an approach for documenting, categorizing and packaging the requirements.

Involved in designing & creating various models, and publishing packages in framework manager

Developed advanced reports using Report Studio.

Created Complex, multipage reports involving prompts, Cascading prompts, Conditional rendering and Conditional formatting.

Created custom prompted reports in Report Studio, Bursting reports to different user groups and Created Scorecards and Metrics using Metric studio.

Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making.

Performance tuning on power-cubes to reduce Query time and partitioned Cubes.

Tested and validated report outputs against the database to measure performance of reports.

Involved in Installations of Go Office on User's Desktop machines with the help of Desktop Services, and configuring it to Dev and Prod environments.

Developed Complex dashboard reports for various reporting requirements.

Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source.

Identified various dimensions and measures required for the generation of a cube.

Implemented changes and thus improve performance for the existing cube using MDX functions.

Performed Troubleshoot on various existing reports that had issues and fixed Remedy tickets from production system.

Coordinated and managed offshore team located in India on a daily basis

Scheduling and monitoring the workflows.

Developed complex PL/SQL stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.

Created reports, Complex and Cross Tab reports using Cognos Report Studio.

Deployed packages, folders and Content store from a development environment to test and then to QC and Production environments.

Uses Aggregate Join Indexes and Teradata load tools to speed cube creation and updates.

Extensively worked on Teradata modeling and ODBC configuration.

Extracted data from different Sources like Oracle, DB2, Teradata and Flat Files.

Environment : windows2010/Cognos10.1.1/sql server2005.

Manpower Group, Chennai, India November 2013 - November 2014

Role: Sr. Cognos Developer

Description: Manpower Group is the world leader in innovative workforce solutions, connecting human potential to the power of business. Manpower Group serves both large and small organizations across all industry sectors through four main brands and offerings: ManpowerGroup Solutions, Experis, Manpower and Right Management.ManpowerGroup partners with clients to accelerate their business by providing the people and services that raise the quality, productivity and efficiency of their total workforce, including recruitment and assessment, training and development, workforce consulting, outsourcing and career management.

Responsibilities:

Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.

Involved in the design and implementation of the balanced scorecard and online analytical processing (OLAP) solutions

Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance.

Collaborated with business to develop high-level designs including logical models and functional specification documents.

Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.

Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.

Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements

Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.

Recommended and designed summary tables to be used in reports to optimize performance.

Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data.

Administered Cognos BI Server Environment

Managed Package Migrations and Deployments from one Environment to another.

Developed a metadata model in Framework Manager by following best practices.

Implemented Tables of Contents and hide and show functionality in Reports.

Supported existing reports in production environment.

Design and review Technical Design Documents and queries through onsite/offshore mail coordination.

Identify gaps in the database migration and discuss the impact with several business teams.

Participate in daily /weekly status calls and meetings to discuss the project issues and work with all the teams to close the issues.

Environment : Cognos Report Studio 10.1, Power play Transformer 7.4, Framework Manager and SQL Server 2005

Sonoco, Bangalore India May 2011 – September 2013

Role: Sr. Cognos Developer

Description: Sonoco is a $4.1 billion global manufacturer of industrial and consumer products and provider of packaging services, with more than 300 operations in 34 countries, serving customers in some 85 nations. Sonoco is a proud member of the Dow Jones Sustainability World Index.

Responsibilities:

Interaction with the client for requirements gathering and analysis

Developed List Reports which includes Complex formatting in report studio

Creation of Calculations, Filters at reports designing

Developed reports which include Grouping, and sorting

Developed reports which include Page breaks and Sectioning

Created text based prompts, date prompts and value prompts

Worked with reports, which include joins and unions in report studio

Involved in creating, re-ordering, modifying and deleting prompts in a report.

Developed reports which includes Page rendering and List rendering and Field rendering

Developed reports which include Conditional formatting.

Developed complex reports which includes charts, crosstab and drill through

Testing the reports for data accuracy and consistency

Run, view and analyses the reports in different formats

Worked on Cognos access manager to control access to repot users

Fixing of defects for the existing reports in report studio

Gap Analysis for the reports developed in Facets

Involved in performance tuning of Cognos reports.

Environment : Oracle 8i, 10G, Toad 8.0, Cognos 8.4 (Framework Manager, Report Studio, Power play Transformer and Query Studio).

Johnson & Johnson PRD, Bangalore, India January 2009 – April 2011

Role: Cognos Developer

Description: Archimedes is a data-warehousing project being built on behalf of Pharmaceutical Research and Development (PRD) and Benefit Risk Management (BRM). Adverse Events are captured in the transactional safety database (SCEPTRE) owned by the Benefit Risk Management (BRM) Group of Johnson & Johnson PRD. To be able to correctly handle authority requests and handle the huge load of ad hoc queries, the SCEPTRE system needs additional functionalities. These include advanced query tools with transparent, reproducible query results.

Responsibilities:

Gathered requirements from financial analysts, field managers and translated them into business requirements

Created high level and low level design and presented walkthrough for approval

Developed the model using Framework Manager, created dashboards and reports using Report studio

Implemented Framework Manager Security for Data access, Object level access and Package.

access based on the Organization Level

Developed Cube based solutions for multi-dimensional analysis

Involved in performance tuning activities

Identified subject’s areas for reporting and ad-hoc query purposes

Prepare a unit test plan and SQL scripts that will cover all the functionalities and logics and run those in Quality center

Assist in implementation of the Cognos objects to the production environment

Used Service Now (Ticket Management Tool) for Request tickets, incident tickets, Change management, etc.

Plan and scheduled the report to run at desired frequency in Cognos Scheduler and scheduled the cubes to run on ETL job completion dependency using Aautosys tool

Provided user training to basic and advanced users and supported any adhoc requests.

Environment : Oracle9i/Toad, Cognos 8, Cognos transformer 7.4

HR DATA MART, Myer, Melbourne, Australia October 2006 – December 2008

Role: Application Developer

Description: Myer is a market leader in Australian retailing. It is continually transforming to better serve the customers and their changing needs. Today Myer employs over 20,000 people with 60 stores nationally, and focuses on high personal development for each individual.

Cognos is a front-end application used to access and manipulate data stored on the Myer Human Resources Data Warehouse (HRDW). The existing HRDW solution was established in 2001 to link and analyses Human Resources (HR) data from all the payroll systems and Claims Management systems across the Myer Group HR departments. This was later extended to include Myer Group Health and Safety.

Responsibilities:

Creating\Modifying the catalogs and impromptu reports as per the client specifications.

Successfully creating user classes & users and setting up necessary access to them using Access manager.

Publishing the cubes to the upfront and maintaining the existing cubes, models & IQDS.

Resolving support issues and refreshing the power cubes as per the time interval given.

Analyzing, debugging and executing changes for reports with data issues.

Analyzing the business specifications and creating list & chart reports.

Creating the technical design documents for the reports.

Testing & publishing the reports to the cognos connection.

Performing conditional formatting to the reports as per the requirements.

Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.

Created Conditional formatting of the reports.

Created Prompts, calculations, Conditions & Filters

Developed Prompt pages and used Conditional formatting

Creating the reports and aggregating different level as per the given requirements.

Generating the reports like List, Cross Tab & Chart Reports and tested their functionality.

Environment : Windows 2000/ SQL Server2000/Cognos7/Cognos8 migration.

CMP-CORE, Pune, India February 2006 – September 2006

Role: Cognos Developer

Description: The CORE (CMP Online Registration Exploit) Program is a strategic initiative at CMP Media to leverage its unique assets in print publishing and on the web, to register profile and track all of its subscribers/users and subsequently use this information to enhance user experience, develop products and services around user behavior and drive database marketing opportunities. Individualized Cross-Property Reporting is a sub project of the phase one of the CORE project.

Responsibilities:

Analyzing the specifications provided by the client.

Creating the reports and aggregating different level as per the given requirements.

Generating the reports like List, Cross Tab & Chart Reports and tested their functionality.

Effectively creating: Drills through & Master Detail Reports.

Environment: Windows 2000/ Oracle 9i/Cognos8 (Report studio, Query studio).

Contact this candidate