Manager Power
Resume:
Prasith Gaddam 267-***-**** - Cell) ********@*****.***
Cognos Certified Professional
Over eight years of progressively responsible IT experience. Certified
Cognos Professional with in-depth knowledge of system management,
analysis, design, development, testing, production implementation and
maintenance of the project. Extensive experience on integration,
migration, dimensional models, data marts and cubes to achieve optimum
reporting capabilities for the management. Good team player with high
work energy ethics and committed to total customer satisfaction.
Cognos Certifications: (can provide certificates on request)
. Cognos Report Net Product Professional - Reference Number 18891
. Cognos Report Net Product User - Reference Number 13790
. Cognos Impromptu Series 7 Product Professional - Reference Number
13768
. Cognos Impromptu Series 7 Product User - Reference Number 13681
. Cognos Power Play Series 7 Product User - Reference Number 17276
. Trained on Clear Case (Version Control Software)
. Trained on Clear Quest (Change Request Software)
SUMMARY:
. Installed and configured Cognos 8.4/8.3 and Report Net 1.0/1.1.
. Migrated Impromptu Reports (7.4/7.3/7.0) to Cognos 8.4/8.3
. Created Projects, Models and Published Packages using Frame Work
Manager.
. Used Query Studio to build ad hoc Business reports and Report
Studio to build advanced reports (multi-page, multi-query reports)
against multiple databases.
. Administered Security to the Packages and given User privileges.
(Implemented LDAP security to Cognos 8 .4/8.3/ Report Net).
. Monitored system performance using metrics within the metrics
grouping to monitor report service processes and within the request
metrics grouping to monitor volume requests, operational status of
services, response times and process times.
. Monitored system metrics within the queue metrics grouping to
determine if the system is keeping up with demand of report run
requests etc.
. Setting of threshold values i.e. high, medium and low values for a
metrics to monitor value crossings to record the metric score
changes.
. Created and updated Multi-dimensional Power Play Cubes Using
Transformer.
. Published IWR reports and Cubes to Upfront portal and managed the
upfront security.
. Developed and fine-tuned IWR reports and Power Play Cubes.
. Wrote macro programs to automate cube build process and scheduled
using Cognos/Windows scheduler.
. Installed and Configured Cognos products (IWR, Power Play
Enterprise Server, gateway, LDAP)
. Involved in designing Power Play Models and developing of various
kinds of Impromptu Catalogs.
. Managed user security using Access Manager.
. Involved and designed models from Relational and multi dimensional
databases (star schema and snow flake schema).
. Expertise in Client/Server application development using Oracle,
PL/SQL and SQL Server.
. Interacted with Customers for requirement gathering, effective
analysis and also to provide end-user training.
. Worked on CQ/ trouble shooting and bug fixing.
TECHNICAL SKILLS:
[pic]
COGNOS Suites: Cognos 8.4.1/8.3 Suite, ReportNet1.0/1.1, Impromptu
Administrator 7.4/7.3/7.1/7.0 /6.0, Access Manager 7.3/7.0/6.0,
Impromptu Web Reports 7.3/7.1/7.0/6.0, Transformer
8.4/7.4/7.3/7.1/7.0/6.6, Power Play 8.4/7.4/7.3/7.1/7.0/6.6,
Power Play Enterprise 8.4/7.4/7.3/7.1/7.0/6.6 and Upfront
7.3/7.1/6.0.
Languages: PL/SQL, SQL, C, Java, Java Script and Visual
Basic.
ERP Honeywell POMS 5.0 / 5.1, JD Edwards One - World
and People Soft CRM
Operating Systems: Windows 2000/XP, Windows NT/98, UNIX and Linux
Databases: Oracle 10/9/8i, MS Access, DB2 and SQL Server
2005.
GUI: Developer 2000.
QA Tools: Win Runner, Silk and Test Director.
Web Applications: HTML, XML and Java Scripts.
Web Servers: IIS 4.0 and 5.1.
ETL Tool: Informatica, Data Manager
[pic]
Department of Elementary and Secondary Education Jan
2010 to till date
Malden - Massachusetts
ESE's DWH project is conceived to track the Students, Teacher and Student
MCAS information. The Project integrates with different data marts (MCAS,
EPIMS, SIMS and SCS) and consolidates all the information to produce
reports that helps the Districts, Teachers and Students to track and
enhancing the performance and growth.
Responsibilities:
. Involved in analysis, design and gathering of requirement for designing
the new data marts.
. Migration of models and reports from 8.1 to 8.4.1
. Validated the report after migration.
. Designed, Updated / modified the existing Framework Manager Models.
. Created Metadata Modeling by using multiple databases.
. Queried from different database tables as per the requirement.
. Applied and Updated the Security for existing and new packages and
streamlined information.
. Spoke to end user to gather, understand and implement the requirements.
. Documenting the new functional changes and updated the Requirement
Specification Document as requested by the users.
. Gathered requirements by studying the system business process and
interacting with the business users and developers.
. Designed, Developed, Incremental updates and fine tuning of the cubes.
. Inserted the cubes into Power Play Enterprise Server and published the
cubes to upfront portal.
. Writing SQL Queries to test the functionality of the new and migrated
reports.
. Created and established Joins / cardinality between the tables in the
application layer.
. Preparation of summary tables.
. Bursting of the reports.
. Creating and granting roles to users.
. Loading of flat files to the DWH.
. Revisited the requirements to understand and upgrade the existing reports
for changes in functionality.
. Fine tuned Cubes by writing SQL queries.
. Drafted and finalized documents after developing, testing and updating
the Cubes.
. Assisted Users in trouble shooting the reports. And with their special
requests.
. Tested reports for different set of data.
. Creation of conditional variable to hide, highlight of the column
information on the reports.
Environment: Cognos Data Manager 8.4.1, Cognos 8.4.1 Suite of tools i.e.
Report Studio, Analysis Studio, Query Studio, Cognos Connection and
Framework Manager, Transformer 8.4 and Power play 8.4, Oracle SQL/PLSQL,
SQL Server, Windows XP and Toad
Car fax June 09 to
Dec 09
Centreville - Virginia
Car fax is a service oriented industry which provides all sorts of vehicle
information on registering with the company.
The customers could vary from auctioneers, dealer, traders, individual
customers etc. Carfax receives information from around 20,000 sources
including U.S and Canadian provincial motor vehicle agency plus many police
and fire departments, collision repair facilities, auto auctions and more.
Responsibilities:
. Interacted with the users for understanding and gathering business
requirements.
. Provided critical information for business decision making by designing
and developing various reports at the executive and analytical levels.
. Worked closely with clients to understand, gather and document business
requirements.
. Queried from different database tables as per the requirement.
. Worked in CQs to trouble shoot and error/ bug fixing.
. Customized data by adding calculations, summaries and functions.
. Created OLAP cubes by using Power Play Transformer.
. Used flat files to upgrade the models for monthly financial
transactions by creating data sources.
. Revisited the requirements to upgrade and finalize by involving and
interacting with the business user.
. Designed and developed metadata models based on the existing
Transformer 7.4 IQD's models.
. Migrated and validated the Cognos 7.4 / 7.3 series reports.
. Designed and developed DMR models for analysis.
. Designed and developed multiple models for different modules and
published packages.
. Created and established Joins / cardinality between the tables in the
application layer.
. Fine tuned Power Play cubes using SQL Queries.
. Inserted the cubes into Power Play Enterprise Server and published the
cubes to upfront portal so that users could analyze them in the Power
Play Web Client.
. Developed and fine-tuned IWR reports.
. Involved in writing extensive SQL PLSQL query statements to capture the
functionality of the business.
. Assisted users in troubleshooting their reports.
. Provided end user training.
Environment: Cognos 8.4 Suite of tools i.e. Report Studio, Analysis Studio,
Query Studio, Cognos Connection and Framework Manager, Transformer 8.4 and
Power play 8.4, Oracle SQL/PLSQL, SQL Server, Windows XP and Golden
(Benthic Software 5.7).
Dow Jones (Wall Street Journal / Barons)
Jan 09 to May09
South Brunswick - New Jersey
The Dow Jones Enterprise Data warehouse system gives the business users one
view of the print and online Wall Street Journal and Barons subscribers.
EDW for Commerce system extracts translates and loads data associated with
the end-user login, registration and authentication activities associated
with accessing wsj.com content. It supports the licensing, amortization,
billing, general ledger (GL), and marketing interface and customer service
systems. In addition, the Commerce system interfaces with OLF (print
billing system).
Cognos reporting tool is used to create campaigning information needed by
marketing users. The tool is also used to generate financial reports on all
commerce-related activities.
Responsibilities:
. Designed and developed DMR models for analysis.
. Designed and developed multiple models for different modules and
published packages.
. Created and established Joins / cardinality between the tables in the
application layer.
. Designed and applied conditions and created functions based on the
requirements.
. Drafted and finalized documents such as Unit Test Plans, Design and
Requirements Specification,
. Used DB2 MQTs for designing the models.
. Used Report Studio (Cognos 8.3) to create multi query, multi-page reports
from DB2 databases.
. Implemented Security in Framework Manager Models.
. Gathered requirements by studying the system business process and
interacting with the business users and developers.
. Customizing the data by adding functions, calculation and summarizing.
. Designed and developed dashboard reports and applied drill up / down
functionality.
. Provided critical information to business managers in decision making by
designing and developing various reports at the executive and analytical
levels.
Environment: Cognos 8.3 Suite of tools i.e. Report Studio, Analysis Studio,
Query Studio, Cognos Connection and Framework Manager, DB2, SQL/PLSQL,
Windows XP and Toad 3.1 / 4.0.
ETS (Educational Testing Services)
Sept 08 to 31st Dec 08 ... Ewing -
New Jersey
The ERP CRM Project is a migration and enhancement project. The CRM
application is designed and developed to track the number of business
cases originating from around the globe and the issues associated with
it. The project tracks the different scenarios like number of enquires to
a particular program (i.e. SAT, TOEFL, PRAXIS etc) through a particular
provider group via different contact methods (email, phone, fax etc). It
also keeps track of the complaints and grievances of the candidates and
helps in solving their issues. It is designed to provide exceptional
services to students, parents and teachers who are interested in
evaluating the student's intellectual progress. This in turn helps the
management to understand and study the patterns and to provide a better
service to community.
Responsibilities:
. Planned, gathered, analyzed, designed and upgraded the CRM
Project DMR models.
. Revisited the requirements to upgrade and finalize by
involving and interacting with the business user.
. Migrated and validated the Cognos 7.4 / 7.3 series reports.
. Designed and developed metadata models based on the existing
Transformer 7.4 IQD's models.
. Created and established cardinality /relationships between
tables in application layer.
. Used functions and calculation extensively at the model level
to duplicate the IQD's results.
. Helped in resolving the issue by bug tracking and issue
resolving in the production.
. Helped and trained the user to get familiar with Power Play,
Analysis Studio and Report Studio.
. Created and published nested packages.
. Applied data level security to steam line information to the
users.
. Created Users / User groups and maintained profiles.
. Used flat files to upgrade the models for monthly financial
transactions by creating data sources.
. Helped different project by simultaneously working on different
issues in order of priority.
. Did data entry in CRM application to created business scenarios
test the report for functionality?
. Helped the business user in created test cases to test the
report by creating real time CRM test cases.
Environment: Cognos 8.4 Report Studio, Analysis Studio, Query Studio,
Cognos Connection, Framework Manager, COGNOS 7.4, Transformer 8.4/7.4,
Power Play 8.4/7.4, Power Play Enterprise Server 7.4, Oracle 9, SQL/PLSQL,
Windows XP, Linux, People Soft CRM Application 8.44 and Toad.
Merck & Co., Inc.
Nov 2004 to Aug 2008
West Point - PA
The ERP Project (Pre-Clinical) - Supply Chain Management (SDLC) is divided
into the multiple functional modules (1) Inventory Management (2)
Manufacturing Execution System (MES); (3) Packaging Execution System (PES);
(4) Order Fulfillment and Shipping; and (5) Planning, and so on . From the
user's perspective, some modules are exclusively POMS and the Planning
module is exclusively JD Edwards One World, however all modules share data
between POMS and JD Edwards and with other Merck applications. Each Module
is described in a General Design Specification (GDS). Impromptu 7.1/7.3 and
Cognos 8.3 (Migration) was used to build reports by integrating POMS and JD
Edwards ERP Systems on the Oracle database.
Responsibilities:
. Involved in analysis, design and gathering of requirement for an ERP
Project.
. Interacted with business users and other developers for requirements
finalizing.
. Migrated Impromptu reports (7.0/7.3) to Cognos 8.3.
. Created Projects, Models and Published Packages using Frame Work
Manager.
. Created Metadata Modeling by using multiple databases.
. Created Complex Reports in Cognos 8 BI Report Studio.
. Created Metadata modeling by using Framework Manager.
. Imported metadata from various sources such as Relational Databases,
Report Net models, Impromptu Catalogs into the Framework Manager.
. Created OLAP cubes by using Power Play Transformer.
. Personalized Cognos Connection, Specified display options, regional
options and personal information.
. Used Report Studio (Cognos 8.3) to create multi query, multi-page
reports using multiple databases.
. Assisted users in creating adhoc reports using Query Studio.
. Drafted and finalized documents such as Requirements Specification,
Design Specification, Unit Test Plans, Integration Test Plans and
IQOQ (Installation/ Operation Qualification) document.
. Implemented security in Framework Manager Packages.
. Executed IQOQ's for User Acceptance Test (UAT) and for Production.
. Developed and fine-tuned IWR reports.
. Involved in Developing and Maintenance of the Catalogs Using COGNOS
Impromptu.
. Extensively used Impromptu in accessing the source data to build
reports.
. Formulation of joins and query optimization.
. Upgraded reports system from COGNOS 7.0 to COGNOS 7.3.
. Implemented Drill-Through with Report and query linking.
. Customized data by adding calculations, summaries and functions.
. Created Materials in POMS application and dispatched to containers for
product development use in different locations and tested and
verified the same on the report.
. Studied existing system and analyzed requirements and Interacted with
end user to gather information.
. Wrote test scripts and formed unit testing for the developed reports.
. Worked in CQs to trouble shoot and error/ bug fixing.
. Worked on Clear Case in tracking changes to the Code (View), Model,
Catalog, Reports and Cubes.
. Created News Boxes in Upfront.
. Provided Production support.
. Provided end user training.
Environment: Oracle 9/8i, SQL/PLSQL, Cognos 8.3 Report Studio, Query
Studio, Cognos Connection, Framework Manager, COGNOS 7.3, Transformer 7.3,
Power Play 7.3, Power Play Enterprise Server 7.3, Upfront 7.3, Power
Prompts, Windows 2000, Honeywell POMS, JD Edwards One-world, People Soft
EPM, UNIX, Clear Case (Version Control), Clear Quest (Change Management),
First Citizens Bank.
Herndon, Virginia
Feb 2003 to Oct 2004
This application is built to allow customers online with the best
competitive pricing. The information pertaining to the modules are stored
on RDBMS at the Server Side (Store). The Server processes the customers'
requests and the information is shipped to the address submitted by them.
The application consists of two main modules; "Personal" and "Business".
The "Personal" module was the basic interface to query the database and
generate reports for rates, payment terms, view funding, protection
options and investment considerations. The "Business" module consists of
various business units for Personal, Business and Estate Insurance.
Responsibilities:
. Installed and configured Report Net 1.0/1.1.
. Worked closely with clients to understand, gather and document
business requirements.
. Developed technical specifications and deployed efficient Business
Intelligence solutions
. Created complex reports by using Report Studio.
. Created and enhanced existing power cubes as per user requirement.
. Created and Published Packages using Frame Work Manager.
. Helped users in creating adhoc reports using Query Studio.
. Used Report Studio to build multi-page, multi-query reports against
multiple databases.
. Created / Updated Power Play cubes and set user profiles to grant
user permissions for querying.
. Fine tuned Power Play cubes using SQL Queries.
. Queried from different database tables as per the requirement.
. Created filters, prompts, sub reports, burst reports and provided
drill through Capabilities.
. Created Transformer models and added security.
. Created and Maintained different User Classes in Access Manager.
. Created User Classes for granting Access to Users in Access Manager
and configured Ticket Server.
. Configuration and Integration of Access manger with other Cognos
products for Security.
. Created News boxes in Upfront.
. Set up of the Alternate Drill down paths and convergence levels.
. Created Calculations, Conditions and Prompts in catalogs.
. Used Cognos Transformer to build multidimensional cubes and used it in
Cognos Power Play to build graphs and charts of sales data.
. Used Slice & Dice and Drill through techniques for use in creating Ad-
hoc and Standard Reports.
. Restructured and reorganized several tables, and created indexes for
better performance.
. Modified existing cubes by slicing and dicing, adding alternate drill-
down paths, special categories.
. Expertise in Client/Server application development using Oracle,
PL/SQL and SQL Server.
. Inserted the cubes into Power Play Enterprise Server and published the
cubes to upfront portal so that users could analyze them in the
Power Play Web Client.
. Installed and configured the COGNOS servers.
. Resolved production issues and extensively worked with production
support team.
. Involved in the documentation preparation for User Training.
Environment: Oracle 8i, SQL/PLSQL, Report Net 1.1, COGNOS 7.0, Transformer
7.0, Power Play 7.0, Power Play Enterprise Server 7.0, Upfront 7.0 and
Windows 2000.
GE Health Care.
New Jersey
Aug 2002 to Jan
2003.
Participated in the development of a system with decision making support
solutions, giving mainstream users the ability to access, analyze and
share information in the company's database. The system generated
reports to analyze referral trends, waiting list for patients, activity
for Doctors and patients, payroll, gross profit analysis, head count and
financial reports on personnel. Worked on measuring critical data
pertaining to different departments and consolidating the same into one
database.
Responsibilities:
. Studied existing system and analyzed requirements.
. Interacted with the users for understanding and gathering business
requirements.
. Involved in all aspects of impromptu, from connecting to the
corporate database to setting up effective catalogs, joins,
folders, and filters, to ensure that adequate security procedures
are in place.
. Created and Modified of catalog.
. Creation of standard filters, calculations, prompts and conditions in
catalog.
. Implemented Drill-Through with Report and query linking.
. Created Business Mixed Reports, Ranking and Variance Reports.
. Created Models based on the Dimensions, Levels and Measures required
for the analysis.
. Automation of reports using scheduler for different intervals.
. Testing and improving Report Performance
. Reduced the Cube build times drastically and increased runtime
performance.
. Created Multidimensional Cubes using Power Play Transformer.
. Developed and fine-tuned IWR reports and Power Play Cubes.
. Modified existing cubes by slicing and dicing, adding alternate drill-
down paths, special categories.
. Created drill through and layers in reports to customize the
presentation of data.
. Used Upfront Server to publish data on to the web.
. Generated Top Ten Reports Rank & Sort Data on Percentage Growth.
. Wrote scripts and batch files to refresh the cubes in a staging area.
. Implemented security and granted privileges according to user classes
using Access Manager
. Provided critical information for business decision making for that
designed and developed various reports at the executive and analytical
levels.
. Refreshed reports using Scheduler.
. Installed and Configured COGNOS, Power play and IWR web reports.
. Providing support and maintenance for Test and Production
environments.
. Provided end user training.
Environment: Oracle 8i, SQL/PLSQL, Linux, COGNOS 6.0, Access manager 6.0,
Impromptu Web Reports 6.0, Transformer 6.6, Power Play 6.6, Power Play
Enterprise 6.6, Upfront 6.0 and Windows 2000.
Big Y Foods.
Connecticut.
Jan 2002 to July
2002.
This project was on COGNOS & Oracle Database. This tool will help the human
resource in tracking the movement of resources from Onsite to Offshore and
vice-versa. The tool will also help to track the number of hours & effort
put in by the resources. COGNOS Suite was used for reporting.
Responsibilities:
. Interacted with the end users for gathering and understanding of
business requirements.
. Created and Modified of catalog.
. Creation of standard filters, calculations, prompts and conditions in
catalog.
. Created various report types like simple report, cross tab, sub report
and drill through that cover the entire range of enterprise reporting
requirements and distributed to end users.
. Wrote SQL statements to generated reports.
. Creating and Maintaining of the Catalog.
. Developed Impromptu reports and Customized Templates.
. Used impromptu to create .iqd files and used as source of data in
Cognos Transformer to create multi-dimensional cubes to generate Power
Play reports.
. Designed, Developed & Tested Power Cubes and deployed them in to
production.
. Customized data by adding calculations, summaries and functions.
. Developed Power Play cubes which involved model definition in
Transformer.
. Inserted the cubes into Power Play Enterprise Server and published
the cubes to upfront portal so that users could analyze them in the
Power Play Web Client.
. Used multiple queries, calculated measures, customized cube content
and optimized cube creation time.
. Developed and fine-tuned IWR reports and Power Play Cubes.
. Administration of Access Manager to implement Security among
COGNOS.
. Coordinated in training sessions and demonstration of Cognos tools to
End-users.
. Assisted users in troubleshooting their reports.
. Provided end user training.
Environment: Oracle, Windows NT, SQL/PL SQL, Impromptu Administrator 6.0,
Access Manager 6.0, Transformer 6.6, Power Play 6.6, Impromptu Web
Reports 6.0 and Upfront 6.0.
Prudential Financial.
Newark, NJ.
Dec
2000 to Dec 2001.
Contributed to this project by developing Catalogs and Reports using
COGNOS Suite Tools and against the available data in Oracle database.
COGNOS Tools provides a high degree of reporting, analysis and
integration among the key business information processes - planning,
budgeting, and financial consolidation for data queries and the answers
are uniform and accessible throughout the enterprise. FAS were developed
to handle all types of deposits, deposited in various schemes. The
system's primary responsibilities were to give current information of
details of customers, details of deposits, cash status, and credit
information to the administrative division and also to give details of
deposits to the customers.
Responsibilities:
. Involved in Developing and Maintenance of catalog.
. Creation of standard filters, calculations, prompts and conditions in
catalog.
. Testing and improving Report Performance
. Reduced the Cube build times drastically and increased runtime
performance.
. Deployed Cubes and Reports in Power Play Enterprise Server and also
published to Upfront.
. Implemented security and granted privileges according to user classes
using Access Manager
. Provided critical information for business decision making for that
designed and developed various reports at the executive and analytical
levels.
. Extensively used Impromptu in accessing the source data to build
reports and to feed the transformer models.
. Formulation of joins and query optimization.
. Upgraded reports system from COGNOS 6.0 to COGNOS 7.0.
. Implemented Drill-Through with Report and query linking.
. Using Upfront Server to publish data on to the web.
. Created Multidimensional Cubes using Power play Transformer.
. Developed and fine-tuned IWR reports and Power Play Cubes.
. Administration of Access Manager to implement Security among COGNOS.
. Installed and configured COGNOS servers.
. Provided end user training.
Environment: Oracle, Windows NT, SQL/PLSQL and COGNOS Impromptu
Administrator 6.0, Access Manager 6.0, Transformer 6.6., Power Play 6.6,
Impromptu Web Reports 6.0 and Upfront 6.0.
Educational Qualifications:
Bachelor of Science (MPC -1989)
Osmania University
Contact this candidate