P avan Kumar
ab2268@r.postjobfree.com
Summa ry:
Over 7+ years of total IT industry experience analysis, design, testing,
•
development and implementation of Business In telligence & data
warehousing environments.
Experience in Financial Services, Healthcare, Insurance and IT sector.
•
• Experience in Cognos Enterprise planning solutions
• Developed, managed and monitored testing and production environment
• Administered the quality of data generated and helped to make changes
w herever required
• Modeled metadata and applied in Cognos framework and reporting
• Successfully Migrated Reports from Cognos 7.1 to 8.4 to Cognos 10.1.1
environment
Excellent working knowledge of BI tools Cognos 10.1.1, 8BI (Query Studio,
•
Report Studio, Analysis Studio & Framework Manager, Cognos Connection),
Cognos Series 7 (Cognos Impromptu, Cognos Power play), Cognos
T ransformer and Cognos Planning 10.1 / 8.4.
Strong Experience in developing Business models using Framework Manager
•
and published packages to Cognos Connection in Cognos 8 and Report Net.
Experience in Cognos Data Manager
•
Expertise in OLTP/OLAP system study, analysis, E-R modeling and
•
developing Database schemas like Star Schema and Snowflake Schema.
Experience in Deployment (Export, Import) using Framework Manager in to
•
Cognos Connection.
Implemented Securi ty at different levels in Framework Manager and Cognos
•
Connection to restrict access.
Expertise in Ad-hoc Reports using Query Studio in Cognos 8 BI Suite and
•
Report Net.
Excellent communication and interpersonal skills.
•
Expertise in managing projects, clients and supporting projects.
•
Expertise in Providing Best Practices and Debugging Issues.
•
Expertise in in teraction with the Users and as per the user requirements,
•
analyzed, designed and generated the Business Reports.
Expertise in system study, analysis, design, development, testing,
•
i mplementation and documentation
Strong experience in coding using SQL, SQL*Plus, PL/SQL
•
P rocedures/Functions,
• Obtained Achievement Award of Excellence for outstanding performance.
Technical Skills:
IB M PC Compatibles and NT servers
H a rdwa re
Windows, UN IX, L inux
OS
Cognos 8/10 (Report Studio, Frame work manger, Analysis
OLAP tools
S tudio), Cognos Planning 8.4/10, Transformer 8.3, Impromptu
A dministrator, Powerplay Transformer, Powerplay,
ReportNet,Oracle, Hyperion & Hyperion Smartview
Informatica 6.0, 7.1,8.1,8.6, Data stage 7.5
E TL Tools
Oracle 7.x/8.x/9.x/10g, SqlServer 2003/2008,sql* loader,
Databases
Teradata
Stored Procedures, Database Triggers, and Packages.
R DB MS
C, C++, Java, Cobol, VB. net,php, Assembly language
Languages
Adobe Photoshop, Flash, Dreamweaver.
M ultimedia
Make, RCS, Autosys, Clear Case, Crontab,Toad, BTEQ
Tools
M iscellaneous TCP/IP Sockets, Sun RPC, XML
CVS
Version
Cont rol
P rofessional Experience:
Cardiology Pa r tners – Wellington, F L
F eb 2010 to P resent
Role: Lead Cognos Developer/ Administrator
D escription: Cardiology Partners is dedicated to offering a wide range of high
quality diagnostic services, medical care, t reatment and therapeutic in terventions
to patients with conditions affecting the heart and peripheral vascular system.
T hey specialize in patient evaluations and consultations, nuclear medicine
s tudies, stress tests, echocardiograms, CT angiography, holter monitors, doppler
exams and ult rasound studies. Our patients receive the full scope of cardiac
catheterization procedures and in terventional services including coronary
angioplasty, stents and pacemakers. Our medical offices are located throughout
Palm Beach County, and we also have cardiac catherization facili ties in Wellington
and Palm Beach Gardens
Responsibilities:
Extensively worked with Business Team and Functional Team to review
•
business requirements, and Functional clarifications.
Provide administrating support to data warehousing, database and server
•
technologies
Provide technical leadership to teammates through coaching and mentorship
•
Collaborate with other Cognos developers, business analysts and software
•
a rchitects to plan, design, develop, test, and maintain web- and desktop-
based business applications built on IBM Cognos.
Identify technical need of the organization and the project requirement
•
Ensure maintenance and control continuity of the Cognos environment
•
Administered migration project and completed them successfully through
•
'Cognos Administration' tool
Worked on the Active Reports to provide the in teractive behavior outputs to
•
t he users. Created tabbed reporting with complex calculations/formatting.
Installed and Configured on client network.
•
Fine Tuning the server
•
Created customized, Complex reports in Cognos Report Studio and Ad-hoc
•
reports in Query Studio.
Successfully Migrated Reports from Cognos 8.4 to Cognos 10.1.1 environment.
•
Updated the BI Environment and Planning Environment from 8.4 to 10.1.
•
Developed many Complex Reports as L ist, cross tab, drill through, master-
•
detail, chart using Report Studio. Using Cognos 10.1.1 Report studio, created
various complex List Reports, Grouped Reports, Cross tab Reports, Chart
Reports and Drill-Through Reports for Mobile and iPad Applications.
Developed Reports with Mul tiple Cognos Viewers and with multiple Cognos
•
Reports developed
Complex Reports, Dashboards for Mobile and iPad Report Applications.
•
Applied OLAP functionalities such as drill-down/drill-up in Analysis Studio
•
and Report Studio.
Developed complex reports using Cognos Version 10.1.1using Crosstab having
•
d ifferent calculations, data i tems and customized Page Formatting.
To improve functionality and performance created Cubes in Transformers
•
and defined data i tems in cubes before publishing.
Wrote test scripts and queries for reports and cubes to verify data against the
•
database.
Used PL/SQL scripts to load data from various external files.
•
Trained business users in the Ad-Hoc Components like Business Insight &
•
t he Business Insight Advanced.
Prepared the Presentations/User Guides to the End Users as part of the
•
t raining.
Performed Extracting, Transforming and Loading (ETL) data into data
•
warehouse database using Oracle scripts Environment: Cognos 10.1.1
( Framework manager, Report Studio, Query Studio), Cognos Vi rtual View
M anager 10.1, Cognos Power Play Transformers, Cognos Mash Up Services,
Cognos iPhone/iPad Reports, Access manager, Informatica 8.1, Oracle 11g,
TOAD 8.6,SQL Server 2008, Windows 7, UN IX.
Designed reports with Cascading Prompts, Fil ters, and Custom Calculations.
•
Environment: Cognos 8.4/8.3, Framework Manager, Report Studio, Query Studio,
E vent Studio, Analysis Studio, Metric Studio, Cognos Power Play Transformer, MS
SQL Server 2005, Windows 2003.
BASF - Du rham, NC April
2008 to Jan 2010
Role: Cognos Developer/Admin
Description: BASF is the world’s leading chemical company – The Chemical
Company.
With about 111,000 employees, six Verbund sites and close to 370 production
sites worldwide we serve customers and pa rtners in a lmost a l l
countr ies of the world.
Responsibilities:
Involved in meetings/sessions with users to gather report specifications.
•
Documented Business requirements, Technical Documents, Test plans, Use
•
cases and Test cases.
Created Cognos Cubes Using Oracle Ess Base.
•
Designed Cognos Framework Manager Model with different views (Database
•
V iew, Business View, Presentation View) using Oracle 10g.
Implemented Relational Modeling in Framework Manager
•
Created the Framework manager model using the Model Accelerator to bring
•
u p a perfect Star Schema.
Implemented securi ty for Data access, Object level access and Package access
•
i n Framework Manager.
Created custom templates and custom toolboxes for the use of reporting.
•
Created the list, cross tab, repeater and drill-th rough reports and created the
•
reports in different formats like PDF, XML, HTML and CSV.
Created reports ranging from ad-hoc to complex reports using drill th rough,
•
conditional formatting and cross tab reports
Created jobs and scheduled burst reports using schedule management tool to
•
r un daily/weekly
And monthly basis and sending reports and report links to users through
•
email.
Used Query Analyzer to test the queries.
•
Developed Power Play Transformer models using .iqd files externalized from
•
F ramework Manager.
Published Power Cubes to Cognos connection portal using Framework
•
M anager for reporting& analysis.
Provided sessions on the usage of the External Metadata functionality to the
•
Power Users which enables the customized data reporting.
Performed data validation and unit testing of cubes and reports.
•
Tested reports for validity of data against source databases using TOAD.
•
Environment: Cognos10.1/8.4 (Framework Manager, Report Studio and Query
S tudio), Cognos Power Play 8.4 (Cubes), Cognos Transformer 8.4, TOAD 8, Oracle
10g, Windows XP, Cognos Essbase.
Guthy Renker Las Angeles CA A ugust
2006 to Ma rch 2008
Role: Cognos Developer
Description: Guthy Renker is one of the largest and most respected direct
marketing companies in the world, with distribution in 68 count ries. Since 1988,
Guthy Renker has discovered and developed dozens of well-loved, high quality
consumer products in the beauty, skincare, entertainment and wellness categories.
Responsibilities:
Participated in discussions with the Business users and senior management
•
to create and gather the business requirements.
Used Cognos Framework Manager to create different views (Database View,
•
B usiness View,
Presentation View) using Oracle and MS SQL SERVER Databases.
•
Created Packages and DMR models in Framework Manager by importing
•
metadata from different data Sources with use of data modeling.
Implemented stored procedure query subject in Cognos Framework Manager.
•
Created users and user groups, assigned user privileges in Access Manager
•
In teracted with Business Users to identify key performance indicators (KPI).
•
Implemented securi ty in Cognos Framework Manager in each level according
•
to business users.
Created ad-hoc report using Cognos Query Studio and SQL reports using
•
Cognos Report Studio.
Created various complex L ist Reports, Grouped Reports, Cross tab Reports,
•
Chart Reports and Drill-through Reports for Mobile Applications.
Created multiple layer reports providing a comprehensive and detail report
•
w ith drill through facility.
Customized data by adding prompts, Filters, Calculations, Summaries and
•
F unctions.
Developed reports using System Development Ki t (SDK) by java scripts at the
•
back end.
Created multi-dimensional cubes in Cognos Transformer using Impromptu
•
Query Definition (IQD) generated from Cognos Framework Manager.
Trained users to make their own ad-hoc reports using Cognos Query Studio.
•
Experience in UN IX with Shell, Perl scripting and scheduling jobs.
•
Developed Informatics mappings by usage of Aggregator, SQL Overrides in
•
Lookups, Source fil ter in Source Qualifier and data f low management into
m ultiple targets using Router t ransformations.
Environment: Cognos 10.1 (Framework manager, Report Studio, Query Studio,
Met ric Studio), Cognos Power plays Transformers, Cognos Mobile Reports, Access
manager, Informatics Power center 8.0,Oracle 11g, TOAD 8.6, Windows7.
Tata Consultancy Services (TCS) – H yderabad, Andhra P radesh - April
2004 to June 2005
Role: Business Objects Developer
Description: T CS is a global IT services, business solutions and outsourcing
company headquartered in Mumbai, India and a subsidiary of the Tata Group
conglomerate. The main purpose of the Project is to develop reporting system to
generate several Ad-hoc reports and custom reports of varying complexity against a
data warehouse which contains financial and sales information for all the product
l ine.
Responsibilities:
Designed complex Web In telligence and Desktop In telligence Reports.
•
Created and tested classes and objects to organize the universe.
•
Created complicated reports including sub-reports, graphical reports and well
•
formatted reports according to user requirements.
L inked the universes to share the common objects between them.
•
Created Alerts in various reports according to user requirements.
•
Prepared many other reports by using master details, cross-tabs, slice and
•
d ice and drill mode as per the requirement of the end user.
Worked on Query Panel, Prompts, Report Layout and Re-formatting.
•
Involved in creating aggregate tables at different levels.
•
Defined H ierarchies in Universe to provide the users with Drill down option
•
i n reports and predefined conditions to use in Business Objects.
Involved in designing Business Objects Universes, Queries and Reports.
•
Used Broadcast Agent to schedule the reports depending on the user profile.
•
Environment: B usiness Objects XI R2, Designer, SDK, Web In telligence XI,
Desktop In telligence, Xcelsius, Crystal Reports, Info View, BO Live Office,
Dashboards, Performance Management, SQL Tuning, SQL Server2005, OLAP,
O racle 10g, RDBMS, SQL, PL/SQL, Windows 2003/XP, SQL plus, SAP Business
Objects suite.
Education:
Bachelors in Computer Science & Information Technology from Jawaharlal Nehru
Technological University (JNTU), Hyderabad, India.