Manager Data
Resume:
RESUME
Srinivas Pallerla,
**** ****** **** **** ***, Apt 344,
Smyrna GA,
Email: *****.********@*****.***,
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