- 7+
years
of experience in IT industry especially as a Developer/Analyst performing
software development life cycle, design and implementation with major
focus on Data Warehousing, and Database Applications for Financial,
Insurance, Banking, Pharmaceutical and Government sectors.
- 6+ years of extensive experience in BI/OLAP & ETL tools like COGNOS 8.x, ReportNet
1.1 (Report Studio, Query Studio, Metric
Studio, Analysis Studio, Framework Manager, Cognos Connection), COGNOS
EP Series 7.3 (Impromptu Administrator, Impromptu Web Reports (IWR),
PowerPlay, Transformer, PowerPlay Enterprise Server, PowerPlay Web, Access
Manager, Server Administration,
Report Administration, Upfront,
Visualizer, Architect, Cognos Query, Scheduler, Notice Cast, Metrics Designer, Metrics Manager)
- Worked on Report Studio, Analysis
Studio, Query Studio and for Report design in Cognos BI 8
- Proficient in designing multidimensional
Model in Framework Manager in Cognos BI version 8.
- Involved in installation, configuration
and upgrade of COGNOS ReportNet 1.1
- Extensively used Framework Manager,
Query Studio and Report Studio for model design, ad-hoc reporting and
advanced report authoring.
- Used Cognos Connection
extensively to monitor and manage dispatchers and services, set and
maintain security, create and manage data sources, administer reports and
deploy data from one environment to another in ReportNet.
- Expert knowledge in COGNOS Impromptu, Impromptu Web Reports,
Upfront Portal, Access Manager and Power Prompts.
- Worked extensively with PowerPlay Transformer and client to
design models and analyze the Power Cubes.
- Involved with administration of IWR
Server, PowerPlay Enterprise Server and ReportNet Server.
- Worked with data modeling
using Erwin 4.0/3.x.
- Possess deep knowledge on various phases
of software development cycle including analysis, design, development,
testing and implementation.
- Exposure to client interaction and
user-requirement analysis.
- Mentored and trained users for the
successful execution of the project.
- Involved in designing of Relational and
Multidimensional databases.
- Expertise in Client/Server application
development using Oracle, SQL
Server, PL/SQL
- Strong
management experience along with teamwork building and excellent
communication skills.
- Excellent problem solving and analytical
skills.
- Involved
in Requirement gathering from Business Users.
- Analyzing
the specifications provided by the clients and Developing specification
documents for reports as per client requirements
- Developed Data Manager dimensional builds to
generate multi dimensional data
- Developed
Job streams using Data Manager to execute the sequence of jobs and
tracking the status of the jobs.
- Created
data marts using data manager and load data into the databases to build a
data warehouse environment.
- Design
and Developed the Framework Manager Metadata Models and DMR models and
Published into server.
- Created
and updated framework manager models by adding tables and creating new
joins.
- Provided
security in Frame work manager in data level, object level and package
level.
- Design
& development of the reports using Cognos 8 Report Studio, Analysis
Studio
- Design
& development of multiple dashboard reports using various templates
like list reports, cross-tab reports and chart reports from Oracle
database.
- Interacting
with the End users on a regular basis for resolving issues pertaining to
the reports
- Performance
tuning by analyzing and comparing the turnaround times between SQL and
Cognos.
- Developed
Report Studio and Analysis Studio Reports in Cognos 8 portal
- Migrated
catalogs and reports from Cognos 7.4 to Cognos 8.4
- Built
cubes using transformer and provided
security for the cubes.
- Developed
Dash Board reports in Report Studio and created portal tabs in Cognos
connection.
- Involved
in several knowledge transfer process & End user training.
- Created
Power point Slides using Cognos GO! Office and Published to Cognos
Connection.
- Involved
in unit testing to validate the reports.
Graybar Electric Co., Inc.
April’ 09
– March’ 10
Philadelphia , PA
Designation: Cognos Developer
Description:
Graybar is a leader in the distribution of high quality electrical,
telecommunications and networking products and
an expert provider of related supply chain management and logistics
services. Accurate and real time information
concerning daily revenue, total sales, target sales, employee information
is made available by the Business
Intelligence system they have developed, which is based on Cognos tools.
Responsibilities included working with
Cognos suite of products, creating models, cubes, catalogs, and reports.
Managed Cognos security using Access
Manager.
Description:
- Extensively involved
in requirements gathering with the end client.
- Designed Framework Models made up of
Namespaces, Query subjects, Query items, Shortcuts, Relationships,
Calculations, Folders, Data sources and Packages.
- Designed and
developed Framework model to better suit complex report development using
Oracle as backend.
- Involved in creating
an ad-hoc query model for query studio users. Created and published
various packages to meet different requirements.
- Created
different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail
Reports.
- Worked on
Dashboard reports.
- Implemented report level security in the
dashboard reports.
- Developed Prompt Pages, Cascaded input
Prompts to display only the selected entries in the report and also worked
on the customization of prompt parameters.
- Involved in extensive use of conditional
formatting while developing reports in Report Studio.
- Worked on Bursting of Sales Reports to
different sales level people in the Organizations Sales hierarchy.
- Resolved
complex problems by performing root cause analysis.
- Built reports
with focus on optimization: used indexes on tables and made
recommendations for summary tables where needed.
- Worked as a
team towards finishing the tasks and achieving project deadlines.
- Responsible
for writing various documentations like technical specifications document,
report specifications document and user manual.
- Responsible
for training the end-users in using Reportnet, Query Studio.
- Understanding the business requirements
and report specifications.
- Designed
models for reporting and created and published packages in Framework
Manager.
- Created standardized reports in Report Studio and ad hoc queries
in Query Studio.
- Designed and developed monthly and weekly reports for the
end users.
- Created dynamic dashboard reports
with cascading prompts and drill throughs to the detailed reports.
- Created list reports, crosstab
reports, chart reports and reports with conditional formatting using
Report Studio.
- Designed drill through reports, master detail
reports, and
bookmark reports.
- Implemented bursting of reports
based on the territories so that users can see only their reports, which
in a way handled security.
- Used Cognos Connection to create
and manage data sources, administer Reports as well as the ReportNet Server.
- Created jobs and
scheduled the jobs using Schedule Management in Cognos Connection.
- Deployed packages and
reports from development environment to test environment and to production
environment using deployment manager.
- Maintained the
packages and reports in development, test and production environment.
- Interacting with end users to understand
the business requirements and report specifications.
- Converted the
business requirements into project documentation.
- Involved in building models, packages using Framework Manger
and published the packages to ReportNet Server.
- Modified packages to suit the business
needs and to improve the performance of the reports by defining filters
and adding calculations.
- Used Cognos Connection to administer
Reports as well as the ReportNet
Server.
- Created professional reports in Report Studio and ad hoc reports
in Query Studio.
- Designed and developed Time Based Reports like YTD, MTD and WTD
financial reports for the end users.
- Created list reports, crosstab
reports and chart reports using Report Studio.
- Created prompts, calculations,
conditions & filters, prompt pages, variables etc. using Report Studio for several Reports.
- Created complex reports using tabular sets, child tabular models
(more than one tabular model), drill through reports, master
detail reports,
book mark reports, conditional prompts.
- Documented all the process
changes, requirement changes and code changes.
- Attended weekly
meetings to understand and recommend the business solutions.
- Scheduling and
Distributing Reports through Schedule Management in Cognos Connection.
- Scheduled ReportNet reports to run on a monthly,
weekly, and daily basis using Cognos Scheduler.
Download Resume Format

0 comments:
Post a Comment