Manager Data

Goutham Reddy D

678-***-**** / ****************@*****.***

https://www.linkedin.com/in/goutham-reddy-d-963974148

Experience Summary:

Business Intelligence Developer with 7 years of experience in Reporting and BI Solutions

4+ years of IT experience as Cognos developer specialized in OLTP/OLAP/Data Warehousing, BI tools and in analysis, design, testing, development and providing business intelligence solutions

3+ years of experience as SAP Business Objects Developer

5 years of experience as ETL Developer (SSIS and Informatica)

9 months of experience in Tableau Desktop

Extensive experience working with Cognos 11.x/10.x/8.x Business Intelligence Reporting Suite (Framework Manager, Analysis Studio, Report Studio, Event Studio, Query Studio, Cognos Access Manager)

Hands on Experience with Framework Manager (Physical Layer, Business Layer, Presentation Layer) and Importing Meta Data from Different Sources, Dimension Hierarchy and setting up Determinants

Created and published packages with Object and Data level security using Framework Manager and created complex Reports (List, Cross tab, Charts, Maps, Drill-through, Master-Detail and Cascading) and Dashboards building with Report Studio

Created Active Reports which made offline analytics easy to get truly portable business intelligence

Knowledge of data warehouse techniques and practices, including BI Reporting, Relational Modeling, Star schema & Snowflake schema

Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Scheduling and Bursting of Reports and various kind of prompts (Value prompt, Date prompt, Textbox prompt)

Good knowledge on troubleshooting and resolving complex Production and Performance issues

Worked on complete Life Cycle Development process, which includes analyzing business needs, documenting business requirements, technical design documents, development, integrating, Implementing and Production Support using Cognos as a BI tool

Experienced in using Java script and HTML to create prompts

Provided extensive End User Training and Support

Experienced in Migration of other reports into Cognos (BO to Cognos) and version up-gradation in Cognos

Proficiency in working with Relational Databases like Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, DB2

Developed SSIS packages using various tasks, containers, data transformations, for each loop and for loop sequence container

Comprehensive knowledge of enterprise Data Warehouse including OLTP/OLAP, Dimension/Fact tables

Expert in SQL, Query Optimization, Normalization, Creation of Views, Triggers, User-defined Functions, Stored Procedures, subqueries, and joins

Skilled in using ETL packages to apply control flow tasks (For Loop, For Each Loop, Execute SQL task), and data flow tasks using various transformations (Conditional Split, Data Conversion, Look up, Derived Column, Merge, Union all)

Used Informatica ETL to load data from flat files and other databases

Implemented SCD (Slowly Changing Dimensions) Type 1 and 2 for data load

Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections

Strong interpersonal and communicative skills. Strong analytical-problem solving and trouble shooting skills. Ability to balance flexibility and task priorities to meet internal customer demands and meet project deadlines

Experience in creating the Universe in the Information Design Tool (IDT) and Universe Design tool (UDT)

Good knowledge on SAP Business Intelligence 4.1(Universe Designer and Webi)

Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects

Good knowledge on Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Filters, Ranking, Sections, Graphs and Breaks

Worked on complex Business Objects Reports using Input Controls, Drill Filters and Hyperlinks

Skills/Tools Summary:

BI Tools

Cognos 11.x, Cognos10.x, Cognos Business Intelligence (8.1 to 8.4), Report Studio, Query Studio, Analysis Studio, Metrics Studio, Cognos workspace, Configuration Manager, Cognos workspace advanced, Cognos administration, Cognos Access Manager, Business Objects XI 3.1, Cognos Framework Manger & Business Objects Universe Designer and WebI, Tableau, MS Power BI, SSIS and Informatica

Querying Tools

Toad, SQL Management Studio

ETL Tools

SQL Server Integration Services and informatica

Languages

MSSQL, PL/SQL

RDBMS

Oracle 11g/10g/9i/8.x, MS Access/Excel, DB2, and SQL Server

Operating Systems

Windows 2003/2008/2012 R2

Academic Qualification:

Completed Bachelors in Electrical and Electronics Engineering (EEE) from SASTRA University, Tamil Nadu, India.

Certificates obtained:

Certified by

Certification Title

IBM

IBM Certified Cognos 10 BI Author

IBM

IBM Certified Cognos 10 Administrator

AINS

AINS – 21, Associate in General Insurance concepts

LOMA 281

Meeting Customer Needs with Insurance and Annuities

TCS Internal

ETL Concepts and Informatica Power Centre

Career Profile:

Project 4

Title Client: Prudential Insurance Company of America

Project: Security Reporting

Period: From August 2017 to Till Date at Newark, New Jersey, USA

Role: Lead Cognos Developer and SSIS Developer

Project Description:

Cognos 10.2 to Cognos 11 Migration: This project is migrating Cognos 10.2 Reports to Cognos 11.0.6 and from SQL Server 2008 to SQL Server 2016. Migrated over 300+ Reports and multiple packages into Cognos 11. Involved in migrating all the environment database Servers from SQL 2008 to SQL 2016.

Roles and Responsibilities:

Analysing the existing Cognos environment, Reports, Packages and backend Databases

Prepared design and test case documents for migration activities

Worked on migrating the Reports across all the environments

Testing Reports, Packages and other components in Cognos 11 environment

Analysing on JavaScript issues which were not compatible with Cognos 11 after migration

Working closely with IBM on migration issues

Finding the root cause for migration issues and fixing them

Moving the Reports and Security settings from Old environments to New environments

Attending regular calls with Business Users and updating them on migration status

Co-ordinating and communicating with Admin team on migration activities

Giving production support after the migration went live into Production

Developing SSIS packages. Experience in Migrating SSIS Packages from 2008 to 2015 version

Designed ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets/flat files using SQL Server Integration Services (SSIS)

Performance Tuning and Query Optimization. Applying stats on key tables to improve SQL performance

Created and updated Data Mapping Documents for ETL packages

Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column

Environment: Cognos 10.1 BI, Cognos 10.1 Framework Manager, Cognos 11.x, Report Studio, Query Studio

Project 3

Title Client: Prudential Insurance Company of America

Project: Security Reporting

Period: From November 2014 to August 2017 at Chennai, Tamil Nadu, India

Role: BI and ETL Developer (SSIS and Informatica)

Project Description:

Security Reporting: This project is to provide a comprehensive centralized reporting repository for security certifications. Also providing actionable reports that enable reviewers to focus on the review objective rather than formatting the data. Reports are developed for different businesses like Central Security Services, Individual Life Insurance, and Prudential Investment Management etc. that help the business to recertify security rights for the application users. Over a 100 Reports were developed under my supervision and we maintain over 300+ Reports.

Roles and Responsibilities:

Designed the ETL process; accessed, manipulated, analyzed, interpreted, and presented information from multiple sources

Normalization and De-Normalization of existing tables wherever needed, for faster query processing

Developed SSIS packages to validate, Extract, Transform and Load (ETL) data into Data Warehouse and Data Marts using Pivot Transformation, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Conversion

Performed the extraction, transformation and loading of data directly from different source system like Oracle database, XML, Excel, Flat Files, and SQL Server

Created Informatica workflows and sessions for each source file to load data into data warehouse

Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Sequence generator, Union and Update Strategy transformations

Using Mapping parameters created an incremental approach to take fresh data from sources daily

Used Inter process communication table logic to track status of each Informatica load for easy debugging of unforeseen issues

Worked closely with Users in creating Functional Requirement Specifications for report development, creating Prototypes before starting actual development

Designed the model based on the requirements for different subject areas and by analyzing the underlying data. Developed customized packages to be used by the query studio users, as per the business specifications

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

Responsible for the delivery of solution-oriented complex reports using Report Studio.

Created the documentation for all the developments along with the technical specifications

Good experience in creating canned and ad-hoc reports in Tableau Desktop

Worked on configuring reports from various Data sources using Data blending in Tableau

Capability of doing data visualization, Reporting, Analysis, Pie Charts, Bar Charts, Cross Map, Scatter Plots, Geographic Map in Tableau Desktop

Good knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, Transformations, filters, Sets, Groups, prompts, Parameters etc in Tableau

Environment: Cognos 10.1 BI, Cognos 10.1 Framework Manager, Informatica, Report Studio, Query Studio, Analysis Studio, SQL Management Studio, Tableau 10.2

Project 2

Title Client: The Hartford Insurance Group

Project: Information Delivery Services – Business Intelligence

Period: From September 2013 to October 2014

Role: BI and ETL(SSIS) developer

Project Location: Chennai, Tamil Nadu, India

Project Description:

Audit Central: This project is to audit the claims from every state by picking some random claims from every location. Auditor audits the claims and answers the predefined questions in the system on how the claim was handled by the claim handler. Over 100 Canned BO Report and a Universe for reporting was developed by me.

Roles and Responsibilities:

Gathering Business Process Requirements from business users, for the reports to be developed.

Developing technical specifications documents by analysing the business from the gathered BPR.

Developed various relational models using Framework Manager for Cognos upgrade.

Created SSIS packages to extract data from various sources and loaded data into target database

Set up parameters to make SSIS packages configurable in target environment

Tuned the performance of SSIS packages by examining execution tree, checking run-time environment variables and identifying and address the bottle-neck executable

Designed ETL (Extract, Transform, Load) strategy to transfer data from heterogeneous data sources (OLAP database) to staging and staging to target tables in the data warehouse by using SSIS package in Visual Studio

Implemented Error Handling by using SSIS packages and create notify to process results by using SSIS mail task to related users

Developed various reports, and they include, simple lists, cross tabs, charts, complex reports with tables in them, conditional block, static choices in prompt, bursting etc.

Expertise in handling Administration tasks like bursting and scheduling the reports.

Fine Tuning PL/SQL queries, views and stored procedures.

Designing and developing prompt pages and cascaded input prompts.

Extensive interaction with Business community and Team members.

Created / Modified Universes, Reports from the underlying Databases for different business modules

Resolved loops by either creating aliases or contexts or by defining shortcut Joins

Created Universes using @functions for specifying the query script for objects

Imported/ Exported the Universes from/to repository to make them accessible to end-users.

Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes and free-hand SQL

Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc

Environment: Congos 8.4 (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio), Oracle 9i, Toad, Business Objects XI 3.1

Project 1

Title Client: The Hartford Insurance Group

Project: Information Delivery Services – Business Intelligence

Period: From October 2011 to Sep 2013

Role: Business Objects Developer

Project Location: Chennai, Tamil Nadu, India

Project Description:

New Business Vision: This project is initiated by one of the Line of Businesses to drive more new business quotes and issues from engaged and unengaged agents by providing an improved user experience. A GUI was developed by corresponding team and quotes and issues flows more easily than in the old system.

Roles and Responsibilities:

Gathering Business Process Requirements from business users, for the ETL process and reports to be developed.

Developing technical specifications documents by analysing the business from the gathered BPR

Training users to use the Cognos connection to access their corresponding reports and cubes

Ability to work independently with minimal supervision and effectively meet project deliverables on time.

Developed various reports, and they include, simple lists, cross tabs, charts, complex reports with bursting etc.

Expertise in handling Administration tasks like bursting and scheduling the reports.

Fine Tuning PL/SQL queries, views and stored procedures.

Designing and developing prompt pages and cascaded input prompts.

Extensive interaction with Business community and Team members.

Follow quality standards and best practices for the development tasks.

Provided administration support and Development support for development and production

issues.

Created / Modified Universes, Reports from the underlying Databases for different business modules

Resolved loops by either creating aliases or contexts or by defining shortcut Joins

Created Universes using @functions for specifying the query script for objects

Imported/ Exported the Universes from/to repository to make them accessible to end-users.

Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes and free-hand SQL

Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc

Environment: Oracle 9i, Toad, Business Objects XI 3.1

Contact this candidate