Manager Project
Resume:
Sarabha Kumar Kankipati [pic]
Cognos Architect
SUMMARY
. Having more than 8 Years of experience involving Project Management,
Business Analysis, System Analysis, Designing, Development and
Implementation. Strong Technical Background in Data warehouse,
Business Intelligence Applications and Decision support Systems.
. Experience as a Administrator and Report writer with Cognos Suites
comprising Cognos8(Report Studio, Query Studio, Analysis Studio,
Framework Manager), ReportNet, Power play, Impromptu, Decision
Stream, Impromptu Web Reports (IWR), Unix Transformer, PPES,
Visualizer, Power Prompts, Metrics Manager.
. Strong Experience in ETL tool Informatica comprising Repository
Manager, Designer and Server Manager.
. Experience in Configuring Cognos8 on Linux/Unix Operating Systems.
. Strong Experience in PL/SQL and T-SQL and Complex SQL Queries.
. Experience on Dimensional Modeling, Star Schema approach and creation
of Data models using Erwin.
. Experience of Mainframe Applications using DB2/COBOL.
. Has worked on a variety of Tools like Test Director, MS Project, Toad
and Appworx.
. Experience in coding JavaScript, JSP, and HTML.
. Involved in complete cycle of Development from Design phase to
Production Phase (Which involves Unit testing, Integration Testing,
Regression Test, and User Acceptance Test).
. Involved in all phases of SDLC.
TECHNICAL EXPERTISE
BI Tools: Cognos8 (Report Studio, Query Studio, Analysis Studio,
FrameWork Manager), Report Net 1.1 MR2, Impromptu, Power
Play (7.4 and 8.4), Visualizer, IWR, Upfront, Unix
Transformer, PPES, Access Manager, Power Prompts.
ETL Tools: Informatica Designer, Server Manager and Repository Manager,
Informatica Meta data Reporter
Databases: Oracle9i, SQL Server-2000 MS-Access, DB2, IDMS, VSAM and Focus
Languages: SQL, PL/SQL, Java, XML, JavaScript, HTML, C, UNIX Shell
Scripts, FORTRAN, Visual Basic 6.0
Mainframe Tools: COBOL, JCL, FOCUS, TSO, ISPF, CA-7, CICS, FTP, Endeavor,
File-Aid, REXX, CLIST, and ISPF PANELS
Operating Systems: MVS/ESA, OS-390, UNIX, Windows 2000/98/NT, Ms-DOS
Tools/Utilities: SQL * Loader, Erwin, Toad, Appworx, Ms-Project, Test
Director, Microsoft office Tools.
CERTIFICATION
Cognos8 BI Administrator Certification (8.4)
Cognos Report Net Authoring Product Professional Certification
Cognos Report Net Product User Certification
Cognos Impromptu Product Professional Certification (Administrator and
User)
Sun Certification in Java 2
Six sigma Green Belt Certification from GE-AE.
WORK EXPERIENCE
Alliance Bernstein Cognos Architect
2007Jan - Current
Alliance Bernstein is one of the leading asset management firms
in the market with strong global presence. AB specializes in providing
analysis and high quality research of various investment tools. The
primary Reporting on Corporate Accounting Reporting, Integrated
Profitability Reporting, Commisson Reporting and Cost Allocation Reporting
is accomplished through Cognos8 Reports and Power play Reports.
Responsibilities:
. Architect the Cognos Environment.
. Design Scalable, Highly available Environment and easy failover
solution.
. Installation and Configuration of Cogno8.4.1 Version on Linux
Environment.
. Implement the Upgrade from existing Cognos8.3 Version and Migration
from Series7.4 Versions.
. Resolve complex upgrade issues on Linux with various Interfaces
. Implement Capacity Planning by performing Load Testing on existing
Cognos Environment.
. Assist Developers in various Complex Reporting Issues and Provide
Solutions.
. Develop Complex Report Studio Reports using Relational and DMR Data.
. Implement Active Directory LDAP Security Architecture
. Design Security Schema to address various aspects like Licensing,
Data, Environment, Objects etc.
. Implement the Auditing Solution for all the Cognos Tools.
. Implement SDK solution for automating various tasks
. Document and Study the Functionality of each Cognos Studio.
. Implement the Licensing Solution to track the usage at any point of
time.
. Create the Standards and Best Practices for usage by Developers
. Interaction with Cognos to provide bug fixes and service packs
. Implement the Cognos Portal Integration with SharePoint Portal
. Portal Customization with Corporate Branding
. Integration with Cognos Go! Office and CAFE
Technical Environment:
. Cognos8 (Report Studio, Query Studio, Analysis Studio, Framework
Manager, CAF , Go! Office), Series7, Transformer 7.4, IWR,
Impromptu7.4, SDK, XML, JavaScript, JSP, T-SQL, WINDOWS 2003, Solaris
UNIX.
Alliance Bernstein Cognos Senior Reporting Developer
2006Jan - 2007Jan
Cost Allocation Reporting
Cost Allocation Reporting is a complete Dataware house solution for
reporting the Firms overall Costs that include Actuals, Plan and Forecast.
The Data warehousing solution extracts data from 12 different Databases
using complex ETL process. The Database is designed using Star Schema
approach. Various complex Reports were developed from this Database for
usage by user community.
Responsibilities:
. Design of Model using Erwin.
. Design of ETL Process.
. Creation of complex PL/SQL stored procedures for ETL Process.
. Design the Model using Frame work manager.
. Implement various Layers in Framework based on Cognos Recommendations.
. Creation of Complex Report Studio Reports using Conditional Blocks,
Conditional Layout, Sections, Mater/Detail Relationships, Tabular Sql
and Tabular Set.
. Create various Reports using Analysis Studio for Multi Dimensional
Analysis.
. Implement Data Security using Parameter Maps in FM and Cognos Macros
in Report Studio.
. Creation of various Java scripts to accomplish specific functionality
like default prompts etc.
. Implement solutions using SDK
Technical Environment:
. COGNOS8, Cognos8SDK, XML, JavaScript, JSP, ERWIN, T-SQL, Oracle, SQL
Server2000, WINDOWS 2003.
The A Consulting Team Cognos Technical
Lead
2005 Feb - 2006 Jan
ATLAS Reporting
The A Consulting Team specializes in executing projects for various
clients like Pfizer, Melon etc.
Atlas Reporting is a report net enterprise wide solution for Pfizer Human
Resource department. The objective of this project is to create various
complex Report Studio/Query Studio reports for performing day to day HR
activities across the organization.
Responsibilities:
. Preparation of Project Plan including Risk Analysis, Technical
feasibility, Operational feasibility and High level Technical
Requirements.
. Installation and Configuration of Report Net suite.
. Interaction with users for Meta Data Collection.
. Design and Creation of Model for publishing various packages using
Frame work manager.
. Access control by applying Data Security, Package Security and Object
Security.
. Creation of Complex Cross Tab and List Report Studio Reports
. Creation of Query studio reports with custom groups, sections and
calculations etc.
. Customization of entire Report net portal by adding/removing some
toolbar buttons and changing the fonts/colors on various panels.
. Performing changes to the Model and Reports using XML.
. Usage of Report Net SDK for customization of report net functions.
. Creation of a Standard Report template for report development.
. Constant interaction with Cognos support to resolve various issues
with Report Net.
Technical Environment:
. COGNOS Report Net 1.1 MR2, Report Net SDK, XML, Java, JSP, Access
Manager, ERWIN, SQL, WINDOWS 2000,Oracle, SQL* Loader, TOAD, VB.
HIP -Health Insurance Plan of New York, New York Cognos
Report Writer
2004 Feb - 2005 Jan
HIP Data warehouse and Dashboard Support
. HIP Monthly dashboard is a source of summary information for executives
on various components like
Claims, Membership, Customer Service, Provider Network, Financials etc.
Currently the information to this Dashboard is fed by various departments
using Excel, Access and text files. The goal of this project is to
automate the entire claims component by making changes to Data warehouse
and then extract, build the Dashboard.
. Major tasks include Developing Dashboard Metrics for Claims component and
Administration.
Responsibilities:
. Design and Preparation of Project Plan.
. Installation and Configuration of Report Net suite.
. Provide enterprise wide solution using Report Net.
. Creation of Model, Project and publishing the packages using Frame
work manager of Report Net.
. Creation of query subjects, Query Items, Namespaces and Folders.
. Control access by applying Data Security, Package Security and Object
Security.
. Creation of Calculations, Prompts and Filters for usage in various
Reports.
. Creation of Complex Multi-Object Report Studio Reports using Lists,
Crosstabs, charts, Images and HTML applications using Report studio
and ad hoc reports using Query studio.
. Invoking PL/SQL Procedures as Query subjects from Report Studio.
. Creation of various prompts including cascading effect using prompt
pages.
. Conversion of existing Impromptu reports to Report studio reports.
. Creation of complex Power Play Models using Power Play Transformer.
. Creation of Power play cubes with Incremental update and Dimensional
Partitioning.
. Performance tuning of Power play cube creation process.
. Creation of various macros in Power play for various tasks.
. Develop OLAP Reports using Cognos Power play.
. Coordinate and Maintain user access manager security.
. Created, Maintained and fine tuned the Catalogs.
. Monitoring and tuning the Impromptu reports created by users for
better performance.
. Creation of Batch scripts for automation of refreshing Data warehouse,
Power play Cube.
. Clear and Concise documentation on all the work performed.
. Preparation of quality procedures, guidelines and test plans.
Technical Environment:
. COGNOS Report Net 1.1MR1/MR2, Impromptu, Power Play, Visualizer, IWR,
Upfront, Transformer, PPES, Access Manager, ERWIN, SQL, PL/SQL,MVS,
WINDOWS 2000,Oracle, SQL* Loader, TOAD, Java.
GE -Aircraft Engines, Cincinnati, OH Data Warehouse
Consultant/Report Writer
2002 Feb - 2004 Feb
Commercial Spares Digital Cockpit
. Commercial Spares Digital cockpit is a business application that
Business Owners use to monitor the Performance of Spares Organization.
. The project goal is to digitize the Commercial spares Metrics as a
room in the Business Data Warehouse (BDW) and to provide the
Maintenance support. This is a Multi Generation Project. Each
Generation will follow e-NPI (Six sigma) approach.
. Major Tasks Include Extracting the Data from the Operational Database,
Design of the Data model, Loading the Data in to Warehouse, Developing
the Metrics/Drill Through and Providing the Maintenance Support.
Responsibilities:
. Interact with users from different functional units to understand
business requirements and develop specifications to meet these
requirements, output specifications, and usage profiles.
. Preparation of Project Plan including Risk Analysis, Technical
feasibility, Operational feasibility and High level Technical
Requirements.
. Develop OLAP Reports using Cognos Power Play.
. Creation of complex Impromptu Catalogs.
. Creation of Standard, Ad-hoc, and Freestyle Impromptu Reports.
. The reporting was quite complex to implement and required to use all
the features offered by Impromptu like Prompts, Query Filters, Chart
Frames, List Frames, Form Frames, etc. were used.
. Work involved writing complex SQL Queries for data filtration and
extraction.
. Creation of power play models based on the dimensions, levels and
measures required for the analysis-using Transformer.
. Extensively used various features in Power play model like Category
Creation, Alternate Drill down, Drill through, and Calculated Columns
etc for power play cube creation.
. Usage of user classes through access manager for security of
particular data in Power play cube.
. Design of Web interfaces using Java, JSP.
. ETL implementation using Decision Stream and PL/SQL.
. Creation of Catalog, Connections, Dimensional Frame work, Fact Builds,
Derivations, Dimension Builds and Job streams.
. Performance tuning of the PL/SQL Procedures, ETL Procedures and
processes.
. Setup Standards for naming conventions for ETL and BI Reports.
. Schedule all the Cognos Cube Refresh using Appworx Scheduler.
. HTML/Java script usage for the front-end design of the web page for
accessing Cognos Reports.
. The Tasks will be moved in to Production on Generation wise. Each
Generation will follow e-NPI (Six-sigma) approach.
Technical Environment:
COGNOS Impromptu, Power Play (6.0 and 7.1), Visualizer, IWR, Upfront,
Unix Transformer, PPES, Access Manager, Decision Stream, ERWIN, SQL,
PL/SQL, JavaScript& HTML, Oracle, DB2, SQL* Loader, TOAD,Appworx
Scheduler, MS-Project, Test Director, Microsoft office Tools, LDAP.
Contact this candidate