RESUME

Srinivas Pallerla,

**** ****** **** **** ***, Apt 344,

Smyrna GA,

Email: acwp8g@r.postjobfree.com,

Contact: 917-***-****

Professional Summary

Having around 10+ Years of experience in Cognos BI Framework Manager, Powerplay Transformer, Analysis Studio, Report Studio, Query Studio, Administration, Cognos TM1, Oracle v.9i –v.10g (PL/SQL, SQL), OBIEE and QlikView etc

Extensively worked on Cognos 10 BI Suite (Cognos Active Reports, Dashboards, Workspace and Workspace Advanced)

Experience in preparation of various dimensions with the help of TI as well as manually created Cubes and loaded data into the cube in Cognos TM1

Built Framework Manager Packages publish the packages as well as built IQD files

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

Built Lists, Crosstab & Chart Reports using Cognos BI tools like Query Studio, Report Studio

Achieved Certification in Cognos8 BI Authoring for version2

Achieved Oracle Certification in SQL, PL/SQL

Certified on Infor EAM product

Successfully Completed Entry Level Training Program from Satyam Computer Services Ltd July 2006.

Achieved Accenture internal certifications in DW/BI concepts (Level 1 and Level 2)

Received Accenture’s Excellence Outperform award in FY09 Q3

Involved in the preparation of cubes using Power Play Transformer

Involved in migrating Reports from impromptu, Power Play to Cognos8.4

Experience in Installation and Configuration of various Cognos Products

Experience in Cognos Administration like datasource creation, providing data level, object & Package level security in Framework Manager, Server Performance, User Management etc

Working knowledge on Cognos Dynamic Cubes for Cognos 10.2.2 Version

Experience

Organization

Designation

Duration

Satyam Computer Services Ltd.,

Software Developer

Mar 2006-Aug 2008

Accenture Services Pvt Ltd

Software Engineer

Aug 2008- Jan 2010

Sierra Atlantic Software Services (HCC)

Consultant

Jan 2010 – Oct 2011

Infor Global Solutions

Software Engineer Senior

Oct 2011 –Jan 2014

SunTrust Bank

Business Analyst (Contractor)

April 2014 – Jan 2015

UCB Pharma

Lead Developer/ Architect (Contractor)

Feb 2015 – Jul 2016

Technical Skills:

Operating Systems

Windows 98,2000,XP,7

Languages

SQL, PL/SQL

Databases

Oracle 9i, Ms-Office, Oracle 10g, MS-SQL Server-2005

GUI

HTML,FRONT PAGE, Java Script

Case Tools

Rational Rose

Web Related

HTML,DHTML, Java Script

Tools & Utilities

Power Play, Power Play Transformer

Domain Knowledge

Telecom, Health Care and Insurance, EAM

Certifications

Oracle Certified Associate 9i (OCA), Cognos8 BI Report Author, Infor EAM

DW-BI tools

Cognos10.x Cognos8.x, Cognos Upgrade/Life Cycle Manager, OBIEE 10.1.3.3,Qlikview

ETL

Informatica(Exposure),Data Manager(Exposure)

Reporting Tools

Cognos 10 – Active reports, Workspace, Workspace Advanced,Business Insight Advanced, Report Studio, Analysis Studio, Event Studio, and Query Studio, Cognos Impromptu

Projects Profile

Client

UCB Pharma

Environment & Software

Database : Oracle 11g, SQL Server, Netezza

Tools: Cognos10.2.1, Cognos 10.2.2, Cognos Go Mobile

O/s: Windows7

Others: SQL, TOAD Datapoint Pro

Location

Atlanta, Georgia

Role

Lead Developer/Architect

Duration

Feb 2015 – Jul 2016

Team Size

5

Responsibilities:

Project: Brazil Commercial Reporting

Understanding UCB business for creating Cognos Reporting Capabilities for Brazil Region

The Reports are designed for CNS, DERM, IMM business units which involves Nation, Divisional & Rep level users

All the Reports are designed to have single sign on Capabilities

Each Business Unit has Audit, DDD, MDTR (Pharmacy, Wholesaler) level Data

Active reports are designed for Ipads for Rep Level Data & Online Reports Developed are designed for DM, Nations level users & Cognos Framework Model developed with Relational and Dimensional Capabilities

Developed a Consolidated interactive Summary level Active Report for Audit & DDD, MDTR Data and created corresponding detail Reports with Application Drill through Capabilities from summary to detail based on Market Selection

Used interactive objects like Sliders, Chart Visualizations, drill through between tabs, Data Drop down lists & Radio buttons in Active Reports

Created Report Studio Reports for District Manager level Reports

Created Workspace Reports for Summarized View of DM’s & above level data and drill trough’s to detail reports

Implemented Data Security for Rep, DM, RM, HO level Reports

Burst the Active Reports and send to the mobile recipients

Performance tuning of Reports

Tested the reports against the database for data validation

Project: Multi Channel Marketing (MCM) Reporting

Performed Enhancements to existing DMR reports by adding Year, Month From and thru Prompts to the existing dashboard

Added Conditional formatting to the crosstabs as per the business requirements

Updated the existing charts to show numeric baselines, Total bars, cumulative lines, addition of extra measures & header changes

Created monthly cumulative opt-in Vs Activations line chart

Intimated to the ETL team regarding the data changes

Designed Equivalent Active reports for Existing Dashboard

Customized Visualizations to fit the objects in Active Reports for Cognos Mobile

Project: Transparency Analytics

This Project is based on CMS Open Payments Data made to Covered, Non Covered Physicians & Teaching Hospitals

Designed DMR Framework Model by analyzing the Netezza tables consists of Payments as Fact, Physicians, Specialty, Region, Payment Type, Company, Time as Dimensions

Reports contain Prompt filters like Company, Year, Specialty, Payment Type, Spend with single/multi select capabilities

Created Dashboard having high level summarized view like Top 10 Physicians, Top 10 Teaching hospitals,Top Specialties, Payment Types, Specialties, Product etc

Created Physician list consisting of Industry Ranks, Max, Avg, Min Payments made by Companies

Created histograms & distribution charts by scattered & bar charts respectively

Used Quartile functions to determine lower fence, upper fence and outliers

Created Bin Ranges, Bin size and Number of Payments falling under each bin

Prepared deployment documents for Acceptance and Production Environments

Client

SunTrust Bank

Environment & Software

Database : Oracle 11g, SQL Server, IBM DB2

Tools: Cognos10.1.1, QlikView

O/s: Windows7

Others: SQL, PL/SQL, TOAD Datapoint Pro

Location

Atlanta, Georgia

Role

BI Business Analyst

Duration

April 2014 – Jan 2015

Team Size

10

Responsibilities:

Successfully Completed QlikView Training that includes Designer and Developer Editions given by IPC Global

Prepared QVD’s for Deposit Analytics Dashboard

Tested Deposit Dashboards Values accordingly in QVW’s

Prepared a Technical Design Document on Deposit Analytics Dashboard in QlikView

Created Event’s Notification through mail in Event Studio based on the Weekly Failed jobs

Prepared a CSAS Products and Deposits DMR Package having Deposits Analytics Monthly, Deposits Analytics Weekly Facts in Framework Manager

Defined Determinants for Time Dimension in CSAS Products and Deposits Package

Analyzed the reporting functionality of Sales Legacy System (SLS) & FM Model having drill through between reports

Generated CLP Monthly Transaction files (CSV) from (Jan to May 2014) using QlikView Store command generated from UTAH (DB2 Appliance) and CMIC (Oracle) data sources

Consolidated BRM Dashboard in QlikView for Northeast and Southeast Regions of Suntrust & converted static dashboard to dynamic by designing Layer1, 2 & 3 QVD’s

Designed BRM Dashboard having comparisons of Actual and Projected measures against STI, Market, Division, Area and Branches for different Products/metric names

Done testing of BRM Dashboard by executing SQL scripts against the DB2 database

Designed RAMS Analytics FM Model having Relational & DMR Capabilities with Role Playing Dimensions

Prepared SQL for fetching MMA Accounts with measures like End of Period Balances at Account Opened Date & First 10 Days,30 Days,60 Days,90 Days of Account opened date

Development & Maintenance of existing QlikView Dashboard on Client Advisory Dashboard with metrics like New Business Revenue, Loan Production, Investment Production, Pricing Discipline etc

Client

Infor Global Solutions

Environment & Software

Database : Oracle 10g, SQL Server

Tools: Cognos10.2.1,Cognos 10.2,Cognos 10.1.1,Cognos 10.1, Cognos8.x

Product: Infor EAM 10,Infor EAM 10.x

O/s: Windows7

Others: SQL, PL/SQL, SVN, JIRA, Text System, Test Manager,

Report Studio, TOAD

Server : Apache

Location

Hyderabad, India

Role

Senior Software Engineer

Duration

Oct 2011 – Jan 2014

Team Size

5

Responsibilities:

Knowledge on back end functionality of the Product

Supported Global Customers of Infor EAM Product for Cognos Reports

Fixed bugs/issues raised by customers

Installed & Configured Cognos Server and Framework Manager for all versions(8.4.1,10.1,10.1.1,10.2,10.2.1) and integrated to the Product

Deployed the Infor EAM Product along with the Cognos under local environment based on the requests

Made Sure Cognos is up and running for both Oracle and SQL Server databases

Created the Content Store, new datasources and publish the packages based on the incremental changes made to the Model & databases.

Developed Cognos Reports for New Features like List of Kits, Expired Kits and Kit Template of the product in Cognos10.1.1 against Oracle and SQL Server databases

Developed line chart report on Temperature Analysis for Regions, which contains Min, Max, and Avg Temperatures & Heating & Cooling Degree Days

Upgraded existing Cognos8.4.1 to Cognos 10.1.1 Reports

Added New layer called Functional in existing FM model by creating Data Source Query Subjects relevant to product Screens

Designed new Report Template for the Product and used existing styles for headers, footers,

page body, lists header single row or multiple rows, table cells, summary Cells for Cognos Reports using Global Style Sheets Method

Developed Active Reports and implemented drill through within the report using bookmarks, Master-Detail features for existing Cognos Reports

Tested developed Reports by the peers against the Product

Worked on report neutralization, performance tuning of the existing reports

Converted Report studio Chart Reports to Active Reports included charts like Boxplot Chart, Gantt Chart etc and shared the .mht files to the users in Cognos 10.2

Upgraded Reports, Framework Model from Cognos 10.1.1 to Cognos 10.2

Changed the Reports as per the new template of Infor EAM 11 Version

Successfully Completed Image Attachment support for the Product to display in Report output pages

Upgraded Reports, Framework Model from Cognos 10.2 to Cognos 10.2.1

Developed Labor Productivity-HealthCare Report in Congos10.2.1

Client

Valassis

Environment & Software

Database : Oracle 10g, SQL Server

Tools: Cognos 10.1, Cognos TM1, OBIEE 10.1.3.4.1

O/s: Windows XP

Others: SQL, PL/SQL,SQL Developer

Location

Hyderabad, India

Role

Senior Consultant

Duration

April 2011 – Sept 2011

Team Size

10

Responsibilities:

Involved Evaluation, Design, Development and Deployment of end-user reports

Generated SQL and PL/SQL scripts to create/drop database objects including: tables, views, primary keys, indexes, constraints, sequences, grants and synonyms

Used Report Studio to develop various types of reports like list reports of customer and account information, cross-tab summary reports, charts/graphs to track the performance of geographical regions over various periods of time, and master-detail, drill-through reports

Created prompts, calculations, conditions, filters and other metadata objects using Framework Manager

Developed prompt pages and cascaded input prompts to filter reports on user specified criteria

Built dimensions and attributes using Turbo Integrator Process in Cognos TM1

Developed cubes and performed data loads from text files

Documented TM1 Process of building the cube and sent to the customer

Done Proof of Concept to the customer on Cognos TM1

Build dashboards using traditional and active reporting techniques

Responsible in creating reports using Active Reports in Cognos 10.1 using Report Studio.

Involved in creating self served dashboards using existing reports under Cognos Business Insight in Cognos 10.1

Documented the report design, Prepared the test scripts and end-user training on Query Studio for Ad hoc reporting

Build dashboards using traditional and active reporting techniques

Modification of Dashboards Reports, Answers, Charts, Bar graphs includes formatting color coding etc in OBIEE

Involved in designing RPD in Administration tool

Deployed Web Catalogs from dev Environment to the QA Server

Implemented the changes made in Repositories at Dashboard level

Resolved bugs raised by QA team with in the Project at UI level

Prepared Technical design documents for OBI Repositories

Tested the Reports by executing the OBI Server SQL in SQL developer

Client

Arthur J Gallagher

Environment & Software

Database : SQL Server 2005

Tools: Cognos8.4.1, Report Studio, Query Studio, Analysis Studio Cognos TM1 9.5, Cognos 10.1(Cognos Connection, Framework Manager, Report Studio)

O/s: Windows XP

Others: Share Point Server, Citrix

Location

Bangalore, India

Role

Senior Consultant

Duration

June 2010 – Jan 2011

Team Size

10

Responsibilities:

Got Insurance Domain Exposure

Performed Installation, Configuration and server administration, data management, security and content administration, activities management

Created the repository, Perform backup and recovery, developing the user administration tuning the servers and deployment

Added Users to the Group in Cognos Administration and assigned security at different level

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

Performed data backups and moved packages to Production.

Monitored data loads/process by verifying log files.

Worked on the packages like Claims, Payments, and Loss etc

Analyzed the Report specifications and Requirements to develop the Reports

Developed Complex List Reports under DMR and Relational Packages

Applied page break on data items, complex formatting like depicting the details of claimant per page and rendered the report in PDF

Used inner & Outer Joins to the Queries to get relevant data to display in the report

Developed Relative, from and thru prompts on Payment, Accident, Transactional, Reserve Change, Recovery dates in the Prompt page and filtered data accordingly.

Rendered Parameter values to display in the Report Page header

Used functions like cast_timestamp, Maximum on Dates, Days_between, Make_timestamp, Add_months, trim, substring etc.

Analyzed Framework Manager Model to verify the joins between Query Subjects

Tested the report output against the Sample data

Updated the issue logs and attended day-to-day conversations with the client.

Worked on Report Clean Ups like adding Relative dates, changing the report page headers by conditional formatting, make sure Java SDK fire on the Prompts, changing the format of Prompt page headers and making all the reports consistent.

Enhanced the performance of the reports by changing the properties of the Query such as Auto Group & Summarize, Processing, Execution Method and Use Parameter Info

Working with various teams to collect project requirements and documented requirements for Cognos TM1

Write requirement specification for application development.

Performed data loads, validation, build dimensions and attributes using Turbo Integrator Process.

Developed cubes and performed data loads from text files.

Performed Troubleshooting and debug logs to verify errors.

Develop and maintains models and reports

Mentored business users and financial analyst about TM1 implementation

Client

Ixia

Environment & Software

Database : SQL Server 2005, and Oracle 9i

Tools: Cognos8.2 Report Studio, Analysis Studio

O/s: Windows XP

Location

Hyderabad, India

Role

Senior Consultant

Duration

Jan 2010 – April 2010

Team Size

3

Responsibilities:

Conversion of Discoverer reports to Cognos Report Studio reports using Tabular SQL method

Developed the reports in RS using the SQL generated by the Discoverer reports

Involved in the Enhancement of the Reports

Validating the reports with the backend

Performed Cognos administrative functions such as creating user accounts, user classes and roles using Access Manager

Built and maintained Cognos reporting security

Prepared Technical Design Specifications for the Reports

Performance tuning of the reports

Client

Sterling Commerce

Environment & Software

Database : DB2

Tools: Cognos8.4, Framework Manager, PowerPlay Client, PowerPlay Transformer (8.5)

O/s: Windows XP

Location

Bangalore, India

Organization

Accenture Services Pvt Ltd

Role

Consultant

Duration

Dec 2009 –Jan 2010

Team Size

4

Responsibilities:

Acted as Module Lead in this project

Designed the Cube Model in PowerPlay Client for building the Cube

Built Dimensions using the CSV files

Created a Time Dimension and facts for building the Cube

Done Time based Partitioning on Year based on the requirement

Published the Cube Package for Reports in Analysis Studio

Upgraded the reports from Cognos8.1 to Cognos8.4, CRN to Cognos8.4 Environment

Prepared Test Scripts for the successful Upgrades

Prepared the Reports in Congos8.4 Environment for the unsuccessful upgrades manually

Tested the reports using Cognos Upgrade Manager tool

Client

Aliant Energy

Environment & Software

Database : DB2

Tools: Cognos8.4, Framework Manager, Cognos TM1 9.4

O/s: Windows XP

Location

Bangalore, India

Organization

Accenture Services Pvt Ltd

Role

Consultant

Duration

Sept 2009 –Nov 2009

Team Size

4

Responsibilities:

Analyzed the Report specifications and Requirements to develop the Reports

Developed two Complex Cross tab Reports as per the Requirements

Involved in the Formatting of Reports as per Client Requirement

Designed the Report Template

Analyzed the package and changed the data items accordingly as per the changes in the package

Used Java Script to navigate from one report to other including the param values for a particular date prompt selection

Created TM1 Remote Server for accessing clients(Perspective) in the local system

Involved in Creation of various Cognos TM1 dimensions using TI, Spreadsheet for Time dimension and build the Cubes based on the created dimensions

Created aliases for existing month dimension.

Loading the data into the Cubes using different data sources like Oracle and CSV files using Turbo Integrator

Created Cube Views

Added Calculations in rules editor

Client

Cognos Internal

Environment & Software

Database : SQL Server

Tools: Cognos8.4, Framework Manager

O/s: Windows XP

Location

Bangalore, India

Organization

Accenture Services Pvt Ltd

Role

Consultant

Duration

15 Days

Team Size

5

Project Description

This is an activity, which involves Modeling using Framework Manager, development of Employee details Reports with details of each Employee per page in Report Studio.

Contribution:

Analyzing Relationships between tables in the Schema and applied cardinality in the Database Layer.

Built Shortcuts and provided the business names to the query items.

Built Prompt Macro at the FM level for Country (Whenever data is pulled from country query subject it should prompt for the country)

Used parameter maps for implementing multilingual property based on the country.

Client

Cognos Internal

Environment & Software

Database : Oracle10g

Tools: Cognos8.4, PowerPlay Client, PowerPlay Transformer (8.4)

O/s: Windows XP

Location

Bangalore, India

Organization

Accenture Services Pvt Ltd

Role

Consultant

Duration

(03/2009) – (06/2009)

Team Size

10

Responsibilities:

Designed the Cube Model in Transformer for building the Cube

Built Dimensions using the IQD’s generated in FM model & CSV files

Created a Time Dimension having day has Granular level and facts for building the Cube

Done Cube Grouping, time based Partitioning based on the requirement

Published the Cube Package for Reports in Analysis Studio

Migrating around 10 reports from Powerplay reports to Cognos 8 BI Report Studio

Involved in analysis of report specifications, data mappings of assigned Cognos reports

Developed two reports as per the given specifications and package used for the reports developed is a DMR package.

Explored the dimensional functions (ex: FirstChild, RoleValue, Members etc) and used the relevant functions while building Cognos reports.

Developed reports in Report Studio include Complex list reports, cross tab reports, Charts (Bar, Column, Pie, Combination etc).

Applied Zero Suppression, Layering functionalities present in .PPX in Cognos 8 Reports

Applied different functionalities like filters, prompts for cognos reports to retrieve relevant data

Rendered the Reports to run in different formats like PDF, Excel etc through Conditional Formatting

Enhanced the performance of the reports by changing the properties of the Query such as Auto Group & Summarize, Processing, Execution Method and Use Parameter Info

Involved in Unit testing of reports and prepared Test Scripts, Technical Design Specification Documents for Cognos Reports

Client

Zimmer

Environment & Software

Database : Sybase

Tools: Cognos 8.3, Impromptu 7.4

O/s: Windows XP

Location

Bangalore, India

Organization

Accenture Services Pvt Ltd

Role

Junior Consultant

Duration

(09/2008) – (02/2009)

Team Size

8

Project Description

This migration project involves migration from Impromptu reports to Cognos 8. The reports are about the financial information of Zimmer’s products, their regional sales, delivering information through reports about their customers like top 100 customers, giving information about their new customers etc.

Responsibilities:

Migrating reports from Cognos Series 7 Impromptu reports to Cognos 8 BI Report Studio

Analyzed XML’s from Impromptu report to develop the same query in Report Studio

Developed reports in Report Studio include Complex list reports, cross tab reports with Report pick lists

Applied functionalities like detailed filter, Summary filter, prompts to retrieve relevant data.

Rendered the Reports to run in different formats like PDF, Excel etc through Conditional Formatting

Enhanced the performance of the reports by changing the properties of the Query such as Auto Group & Summarize, Processing, Execution Method and Use Parameter Info

Involved in Unit testing of reports and prepared Test Scripts, Technical Design Specification Documents for Cognos Reports.

Client

Dialog Telekom

Environment & Software

Database :Oracle10g Client

Tools :Cognos8, Framework manager, PowerPlay

O/s: Windows XP, Windows 2003, Cognos8, Solaris10, Oracle10g

Location

Bangalore, India

Organization

Satyam Computers Pvt Ltd

Role

Junior Consultant

Duration

(09/2007) – (08/2008)

Team Size

18

Project Description

The purpose of the Telecom Analytics Service Offering is to provide baseline and derived analytics that will help telecom operators to meet the demands of the changing telecom landscape. These analytics will be based on the data that normally exits in various data stores in any telecom operator’s network such as customer management data (product catalog and OE), network management data (from NMS and NEs) and enterprise management data (from HRM, SCM, etc.).

The purpose begins by gathering requirements from the customer about the areas of business transformation that are important to the customer and then identifying the relevant metrics.

Done POC for Dialog Telecom

Responsibilities:

Analysis of the Network Intelligence KPI specifications

Developing detailed KPI calculation logic

Implementing the KPI calculation using Cognos8 BI

Performance tuning for developed Reports.

Prepared design documents and test cases for developed reports.

Client

Electronic Arts

Environment & Software

Database : Oracle 9i

Tools : Cognos Reportnet, Putty, IIS 6.0, Remedy, Cognos Framework Manager

O/s :Windows XP (client), Linux AS 3.0 (server)

Location

Bangalore, India

Organization

Satyam Computers Pvt Ltd

Role

Junior Consultant

Duration

(09/2006) – (08/2008)

Team Size

10

Project Description

GBIS(Global Business Insight Solution) is globally deployed Service Line that is part of “Service Delivery Group” delivering application services to the business of EA. It is Business Performance Management Solution actively used by the financial community of EA to deal with their financial data effectively for instantaneous decision-making. Business users of three geographic regions NA, EU and APAC use this application.

Responsibilities:

Supported nightly process for Different regions i.e. North America, Asia, Europe

Created document of understanding for Global Financial Reporting through client KT

Enhancement of the Financial Reports

Monitored performance of the system

Solved tickets raised by business users of EA.

Education

B TECH in Computer Science & Information Technology affiliated to JNT University Hyderabad during Years from 2001 to 2005

Board of Intermediate Education during Years from 2000 to 2001

Completed Board of Secondary Education in March 1999

Contact this candidate