Manager Data
Resume:
Manjunath
Sr. Cognos Developer
*******@***********.***
Summary
• Certified Cognos Consultant with over 8 years of in-depth and comprehensive
experience in design, development, Testing, Security and Support for Data warehousing, and
Client/Server projects.
• Experienced application developer with expertise in designing and developing Business
Intelligence solutions in Data Warehousing/Decision Support Systems using
Cognos8.4/8.3/8.2/8.1.
• Expertise in Cognos 8 BI suite (Query Studio, Report Studio, Analysis Studio, Event
Studio, Metric Studio, Cognos Connection, Cognos Configuration ), Framework Manager,
PowerPlay Transformer, PowerPlay client.
• Expert level skills Handling Cognos BI capabilities: Reporting, Analysis, Score carding,
Dashboards and Business Event management.
• Designed and implemented data cubes using OLAP services, PowerPlay Transformer
to facilitate executive, management and end user reporting
• Expertise in OLTP/OLAP technologies, developing Cognos 8 Framework Manager
modelingusing Star Schema and Snowflake Schema in all modeling types.
• Sound skills on creating different types of reports such as List, Cross-tab, Chart/Graph,
Drill-Through, Master Detail in Report Studio using MDX functions.
• Experience in ReportNet securities and 3rd party tools such as Access Manager, LDAP,
and Active Directory.
• Thorough understanding of software development life cycles (SDLC) designing,
developing and implementing enterprise scale information management applications, reporting
and handling multiple projects.
• Expertise in creating ad-hoc reports using Cognos Query Studio.
• Sound skills in creating dashboard reports and complex reports using Cognos Report
Studio.
• Experience using ETL Tools Informatica PowerCenter, AbInitio in data mart life cycle.
• Experience in Integration of various data sources like Oracle, DB2, SQL Server, MS
Access, and Flat Files into a Staging Area.
• Proficient in Dimensional Data Modeling, Star Schema/Snowflake modeling, FACT &
Dimensions tables, physical & logical data modeling, ERWIN 3.5/3.x.
• Hands on Experience in Troubleshooting Cognos problems and tuning for performance.
• Experience in migration of Cognos series 7 & Crystal reports, Crystal Enterprise, Excel.
• Excellent skills in writing, developing database stored procedures, views, triggers,
alerts, packages, and functions.
• Possess ability for critical thinking, analysis, good interpersonal and communication
skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn
client's business requirements.
Certifications
IBM Certified Designer – Cognos 8 BI Reports
Technical Skills
OLAP: Cognos 8.4/8.3/8.2/8.1 (Report Studio, Query Studio, Cognos Connection, Analysis
Studio and Framework Manager),Cognos Reportnet 1.1 MR2Cognos EP
Series 7 (Powerplay Transformer,Powerplay Windows,PPES,Cognos
Impromptu, Upfront), Business Objects5.1, and MS-Excel
ETL: Informatica,Data Manager,AbInitio2.14.
Data Modeling: Erwin 4.x/3.5.2/3.x, Dimensional Data Modeling, Data Modeling, Star
Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables,
Physical and Logical Data Modeling, Oracle Designer
RDBMS: Oracle 8i / 9i/10g, MS SQL Server 7.0, 2005,2000, Netezza, MS Access,
DB2, My SQL
Operating Systems: Windows 2000, UNIX, LINUX, DOS andWin NT 4.0
Languages: C, C++, SQL, PL/SQL
Web Servers: IIS, Tomcat, Apache
Version control: VSS, CVS, MKS
Tools/packages: TOAD, MS-Office, WinSQL, UML
Work Experience
TD Bank, NJ Jul 2009 -Dec 2010
• Sr Cognos Developer
•
Responsibilities:
• Involved in Full Life Cycle from Analysis to Implementation through Planning.
• Extensively worked on understanding the business requirements.
• Installed and configured Cognos 8BI Software.
• Extracting the data from different Data Sources and loading to data mart using Cognos
Decision Stream as ETL.
• Imported data into Cognos Framework Manager from Different Data Sources.
• Converted data into .XML format by using IMP2XML.EXE to import data into
Framework Manager.
• Created and developed different projects and Packages in Framework Manager.
• Implemented different layers (Name Spaces, Folders, Data Base Query Subjects, Model
Query Subjects and Stored procedure Query Subjects etc.) for different teams like Testing,
Reporting in Framework Manager.
• Created and developed different relationships, Star Schemas and Snowflake Schemas
between different Query Subjects and Query Items.
• Developed Static and Dynamic Parameter Maps and Macros for Multilingual
Reporting.
• Assigned different Properties to different Query Subjects and Query Items in Framework
Manager.
• Thorough understanding of the data and making some recommendations to change the
data structure to suit the business requirements of reports. Transformed several Business
Requirements into Report Specifications from business analysts.
• Analyzing the available Data Sources and mapping the architecture need of Models.
• Create packages to suit the business needs and to improve the performance of the reports
by defining filters, adding calculations and performing SQL tuning on the model and report level
using Oracle database.
• Created standard Calculations, Filters, and Prompts for Ad-hoc queries.
• Interacted with team lead on the process of work flow and design of ER Diagram, with
various considerations and limitations.
• Worked on Microsoft Access queries to understand data flow to migrate from access
reports to Cognos environment.
• Developed List Reports, Charts, Drill-Through Reports, Master-Detail Reports and
Multilingual using Report Studio in Cognos 8.4 having source as Cube as well as FM Package.
• Migrated from 8.2 to 8.4 using migrate to C8 utility tool.
• Developed Models and Power Cubes in PowerPlay Transformer using multiple IQDs
as data sources.
• Created several multi pages reports based on multiple queries using Prompts and
Parameters as per the requirements and ad-hoc-requests.
• Developed effective SQL queries and performed Unit and User Testing to ensure the
accuracy of data displayed in the report using TOAD.
• Design & development of the reports using Cognos 8 Report Studio, Analysis Studio
reports.
• Provided technical assistance by responding to inquiries regarding errors, problems, or
questions with programs/interfaces.
• Trained the end users in creating Ad-hoc reports using Query Studio and acted as
Productionsupport.
• Involved in creating power point slides and documentation material for training user
community on report studio and query studio.
• Actively participated in creating design documents, project charters and migrating the
objects from Development to Testing and to Production environments.
Environment: Cognos 8.4 BI series - Framework Manager, Powerplay, Cognos Connection,
Report and Query Studio, Report Net 1.1, Oracle 10g, SQL Server 2008, Toad, XML, HTML,
Clear Case, Clear Quest, Excel, AbInitio 2.14, Windows, UNIX.
•
Celgene Pharma, NJ Aug 2008 – Jun 2009
Sr. Cognos Consultant
Responsibilities:
• Responsible for gathering requirements from the customer for providing timely, accurate
and consistent reporting.
• Involved in Business Analytics strategy and Analyses, and Analyzed current business
processes, assess opportunities for redesigning these processes.
• Created Cognos multidimensional cubes for users to be able to get business information
from Cognos Power Play.
• Involved in data analysis to get the data around 400 tables.
• Built models, packages and published them using Framework Manager.
• Used Cognos 8 Analysis studio for analyzing large volumes of data using ‘ slice and dice'
techniques.
• Restructured/repaired existing Framework Manager Model to eliminate problematic
cardinality for performance enhancements.
• Developed Complex Reports using Report Studio including conditional blocks,
conditionalformatting.
• Used Query Studio for creating Ad-Hoc Reports using simple queries.
• Extensively worked on Transformations including lookups, joiner and other
transformations using Informatica.
• Developed Subject Area Based Reporting Portals.
• Created complex Dashboard reports using multiple queries in Report Studio targeting
different Business units, for strategic reporting
• Implementing the HTML items in the Reports to make use of Java script to get
Dynamic Reports.
• Involved in the System Development and Administration Process.
• Worked on Report Documentation Followed by SDLC.
• Used the MKS Integrity for Version Control.
• Designed and developed numerous reports including Portal Landing Page, which
includes key performance indicators (KPI).
• Involved in the deployment process.
• Worked closely with requirements team and QA team in order to deliver the Reports
• Involved in testing and validation of reports.
• Implemented user security in the Models.
• Adding users via third-party security tools (Access Manager, LDAP, and Active
Directory) Creating user groups and roles to facilitate security to data and Cognos content store.
Environment: Cognos 8.3, Cognos1.1 MR3(Framework Manager, Report Studio, Analysis
Studio and Query Studio), HTML, Upfront, Transformer, Power play, MKS, Oracle 9,
DB2,UNIX, Informatica 7.1, Analysis Studio.
Citizen Bank, RI, Providence Jul 2007 – Jun 2008
Sr. Cognos Developer
Responsibilities:
• Developed List, Charts, Drill-Through, Master-Detail reports using Report Studio
and QueryStudio.
• Created standard filters, calculations, and conditions in FM Models.
• Created standard Calculations, Filters, and Prompts for Ad-hoc queries.
• Created complex reports with Cross tab and conditions to fulfill the business
requirements.
• Designing, developing and publishing packages using Framework Manager.
• Created multi page report based on multiple queries using Prompts and Parameters.
• Implemented security for Reports using Cognos Connection
• Scheduled (Daily, weekly, Monthly and Quarterly) and distributed reports using
Schedule Management in Cognos Connection.
• Defined roles that will have access to two types of reports: reports published and
scheduled in Cognos 8 portal (Canned reports) and provided security levels for reports.
• Have good Understanding of Cognos BI security models and was able to identify best
practices for configuring applications and work with the development teams to implement the
standards.
Environment: Cognos 8.1 BI (Framework Manager, Report Studio, Analysis Studio, Query
Studio), Oracle 10g.
Caterpillar Inc., Peoria, IL Apr 2006 – Jun 2007
Cognos Developer
RESPONSIBILITIES:
• Developed Framework Manager Models with Physical layer and Presentation Layer to
cater the various business needs (Folders, Filters, and Macros).
• Implemented Third Party Security with LDAP and use those in creating Data Level,
Object Securities in Framework Manager Models.
• Developed Complex Report Studio Reports using Bursting, Tabular Objects.
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Prepared User documentation to train users and functionality of each report.
• Production Support which involves solving user problems.
• Securing Cognos Connection and setup ReportNet security by assigning users to the
groups and roles defined in Cognos Namespace.
• Creating IQD files from Reportnet and designed Power play models in Transformer.
• Involved in building the Cubes and optimizing the cube creation.
• Publishing cubes and created Power Play Reports for the web users.
• Developed Stored Procedures and Database Triggers in PL/SQL.
• Designed extensive sample business Reports to cater the needs, which can meet their
future demands on behavioral, trend analysis.
• Created Drill-Down Hierarchies and used slicing and dicing technologies to provide
optimized Reports.
• Responsible for overseeing the Quality procedures and Software configuration
management related to the project.
• Production Support, which involves solving user problems.
•
• Environment: Cognos ReportNet1.1 MR2 (Framework Manager, Query Studio, Report Studio)
Power Play Enterprise Server 7.3, Transformer 7.3, Oracle 9i,DB2, Windows 2000.
DSLSoftwareLimited,Bangalore,India Jul 2004– Jan 2006
Cognos and ETL Developer
Responsibilities:
• Maintained ETL processes and architecture.
• Created reusable transformations and Mapplets in Informatica
• Worked on Informatica-Source Analyzer, Data warehousing designer, Mapping Designer,
Mapplets, and Transformations
• Created Informatica mappings using active and passive transformations
• Transformed the data based on the dimensional data model using Informatica features
like Aggregator, Lookup, Filter, Joiner, Expression Transformations
• Created and Monitored Batches and Sessions using Informatica Server Manager
• Developing Ad-hoc and standard reports in Impromptu 7.0, using drill through, charts,
adding calculations and summaries.
• Publishing Impromptu, PowerPlay reports to Cognos Portal environment using IWR and
PPES
• Generated reports using cognos impromptu based on the end user requirements
• Analyzing existing Impromptu Reports for Migration
• Used SQL tools like TOAD to run SQL queries
Environment: Cognos Impromptu, Cognos PowerPlay, PowerPlay Transformer (Windows),
Upfront 7.0, Access Manager, Oracle 8.1, Informatica, Windows NT 4.0, Broadcast Agent
Publisher.
DSL Software Limited, Bangalore, India Sept 2003 – Jun 2004
Cognos and ETL Developer
Responsibilities:
• Maintained ETL processes and architecture.
• Created reusable transformations and Mapplets in Informatica.
• Created Informatica mappings to build business rules to load data.
• Worked on Informatica-Source Analyzer, Data warehousing designer, Mapping Designer,
Mapplets, and Transformations.
• Created the dimensions & cubes.
• Created and Monitored Batches and Sessions using Informatica Server Manager.
• Creating Drill-Thru, Sub-reports and Chart reports using Impromptu Administrator.
• Scheduling Patient record reports on a weekly and monthly basis and published to
Upfront.
• Creating special categories and secured PowerPlay cubes using PowerPlay Transformer.
• Working with Administrator to provide security for Cognos applications.
• Generated List Reports, Cross Tab Reports and Drill Through reports using Cognos
Impromptu tools querying database.
• Created Multi-dimension cubes using Power Play Transformer to create reports in Power
Play.
• Extensively used Impromptu in accessing the source data to build reports and to feed the
transformer models.
Environment: Cognos Impromptu, Cognos PowerPlay, PowerPlay Transformer (Windows),
Upfront 7.0, Oracle 8i, Informatica (Power Mart/PowerCenter), Win 2000/NT 4.0.
DSL Software Limited, Bangalore, India Jan 2002 – Aug 2003
Cognos Developer
Responsibilities:
• Created OLTPreports in Cognos impromptu by Developing Catalogs.
• Generated OLAPCubes in Cognos Transformer and analyzed the data using Cognos
Power Play.
• Implementation of Impromptu reports and Power play reports using multiple queries.
• Developed Reports and published in to the web for end users in IWR (Impromptu Web
Reports) and Upfront.
• Created all Kinds of Reports like List, Grouped List, Cross tab, Nested Cross tab, Mailing
Labels, Form Letters & Freestyle etc.
• Generated Catalogs by connecting to different Databases in a distributed environment.
• Created Time Based Reports like daily, weekly, monthly and quarterly using Cognos
Power play, Cognos Impromptu.
• Created standard Impromptu reports to feed Transformer models.
• Developed Various Reports based on the Projected Budget to Actual Budget.
• Developed customized power cubes according to user needs.
• Developed Cognos Drill-Through Reports and to display user specified reports,
developed filters, conditional formats and prompts using prompt manager.
• Used Cognos Scheduler to update a report for specific or recurring times and dates.
• Used Prompts of all Kinds like Type-in, File, Catalog and Report for filtering data.
• Created and Stored Prompts in Catalogs.
• Generated Top Ten Reports by Ranking and Sorting data, Variable Reports and Ad-hoc
Reports.
Environment: Cognos Impromptu 6.3, Cognos PowerPlay, PowerPlay Transformer (Windows),
Upfront.
Contact this candidate