Manager Developer
Resume:
Anil K
Cognos Report Developer/Admin
Email:congos.report.developer@gmail.c
om
SUMMARY
. Over8 years of IT experience in design, analysis,
development, documentation, coding and implementation on
client/server environment using Cognos BI.
. Experience in Business Intelligence Tools like Cognos,
Business objects, Crystal reports and SAS.
. Experience in Cognos 8 BI(8.4/8.3/8.2 /8.1),Cognos ReportNet
1.1, Report studio, Query Studio, Analysis studio and
Cognos connection.
. Involved in the installation and configuration of Cognos 8
series/ReportNet 1.1 and Framework manager.
. Hands on experience in migrating CRN to Cognos8 Environment.
. Experience in TOAD, for easy querying.
. Good understanding of SDLC.
. Good understanding of Automatic Data Processing (ADP) with
Oracle ODS.
. Experience in developing Dimensional data marts using
Informatica.
. Involved in building Data Models using Framework Manager.
. Experience on OLAP cubes, relational and multi-dimensional
Datamodels.
. Good understanding of data warehousing and ETL (Extraction,
Transformation and Loading) tools like Informatica 6.x,
including good knowledge of dimensional modeling.
. Expert in creating List Reports, Crosstab Reports, Drill
through Reports and Multidimensional Reports with cascading
prompts, Macros, filters, calculations using Cognos.
. Responsible for managing the Cognos security strategy for
users/groups and provide BI publishing and Monitoring
reports.
. Hands on experience on SQL plus.
. Involved in database development with Active Directory.
. Created models in framework manager from various data sources
such as Oracle10g/9i and published package to Cognos
Connection.
. Excellent understanding of RDBMS and OLAP, OLTP concepts.
. Hands-on experience in implementing Data warehousing
methodologies including STAR SCHEMAS and SNOW-FLAKE SCHEMAS
for huge data warehouses.
. Excellent analytical, logical, interpersonal, communication
and organizational skills.
. Interaction with the Users and Business Analysts for better
understanding of the reporting requirements.
Technical Skills:
Reporting Tools: Cognos 8BI, (Cognos ReportNet 1.0/1.1, Framework
Manager, Report Studio,
Query Studio, Analysis studio and
Event Studio).
ETL Tools: Informatica 6.x, Data Manager.
Databases: Oracle8i/9i/10g, Teradata, SQL Server
2005/2008, MS Access.
Languages: PL/SQL, Visual Basic, C++.
Operating Systems: Windows 98/XP, Windows 2000 and 200, UNIX.
Other Tools: MS Word, MS Excel, MS Outlook, MS FrontPage,
PowerPoint.
Education:
Bachelor in Engineering (Karnataka Regional Engineering
College, India)
PROFESSIONAL EXPERIENCE:
Comcast Center- Philadelphia, PA
09/01/2009- Till Date
Role: Cognos Developer/Admin
Description: Comcast is integrating its data to one central location
through its project NDW (National Data Warehouse). It is implementing
Business Intelligence software Cognos 8.4, Etl software Data Stage and
Teradata.
Responsibilities:
. Gathered requirements from business end users.
. Installed and Configured Cognos8.4, Oracle and Apache on a
Distributed Environment.
. Involved in the development of the MetaData Model using
Framework Manager and created query subjects, filters and
packages from the framework manger in Cognos 8.4.
. Involved in debugging, performance tune up and maintenances of
reporting environment.
. Involved in unit tests and codes generations and maintenance.
. Published packages with appropriate security settings to Cognos
connection.
. Administered the Reporting Environment.
. Administered tasks such as Scheduling, Deployment, Dispatchers
. Involved in SSIS for data migration and ETL activities.
. Scheduled & refresh the reports and bursted reports according to
user requirements in Cognos connection and sent the reports
through E-mail feature.
. Tested and validated the report output against the database to
measure performance of the Report.
. Involved in Apache Server configuration.
. Involved in training sessions and demonstrated Cognos BI tools
to end-users.
. Involved in installation, up gradation and migration.
. Involved in Production Support which involves solving user
problems.
Environment: Windows 2003, Oracle10g, Windows XP, Apache Server, Cognos
Report Net 1.1 Mr2 /Mr3, Cognos 8.4, Cognos BI Data Manager, Solaris, Http
Servers, Teradata, Load Runner, RHEL Linux 5.2.
The Hartford Life Insurance, Hartford, CT.
Sep'08 to Aug'09
Role: Sr. Cognos Report Developer.
The Loss Connect Claim Capture:
Description: The Loss Connect Claim Capture is a claim intake application
insured with more than 9000 SRS and CMS clients. The claim capture
application involved with four different lines of business like Workers
Compensation (WOR), Commercial Auto (CAU), Commercial Liability (CLI) and
General Liability. The application is bundled with lot of information from
various resources, where the information is retrieved via Microsoft Share
point located at different places around the world. The application
provides claim reports starting from 1990 to till date.
Responsibilities:
. Gathered requirements from business end users.
. Installed and Configured Cognos8 on a Distributed Environment.
. Involved in the development of the MetaData Model using
Framework Manager and created query subjects, filters and
packages from the framework manger in Cognos 8.2.
. Created and managed reports in Zero-footprint environment using
Cognos 8 BI.
. The Meta data was standardized for easy writing of the reports
by the users.
. Published packages with appropriate security settings to Cognos
connection.
. Created List Reports, Crosstab Reports, Drill through Reports
and Multidimensional Reports with cascading prompts using Cognos
8 Report Studio
. Administered the Reporting Environment.
. Developed Scorecard, Dashboard reports Using Cognos BI.
. Developed complex reports using Drill-through options and Master-
detail relationships.
. Created different Standard reports using prompts, filters, query
calculations, cascading prompts and Conditional Formatting of
Measures using variables.
. Created adhoc reports Using Querystudio.
. Administered tasks such as Scheduling, Deployment, Dispatchers.
. Monitored performance by using Metric Studio.
. Resolved performance tuning with SQL server database.
. Generated scorecards to use with the Metric Studio.
. Created optimized queries and performed database optimization
using SQL server 2005.
. Created complex cubes in the transformer.
. Scheduled & refresh the reports and bursted reports according to
user requirements in Cognos connection and sent the reports
through E-mail feature.
. Tested and validated the report output against the database to
measure performance of the Report.
. Involved in training sessions and demonstrated Cognos 8 tools to
end-users.
. Involved in installation, up gradation and migration.
. Migrated the reports from CRN 1.1 to Cognos 8.1.
. Involved in Production Support which involves solving user
problems.
Environment: Windows 2003, Oracle 9i/10g, SQL Server 2005/2008, Composite
Server 3.7.1, Windows XP, Apache, Cognos Report Net 1.1 Mr2 /Mr3, Cognos
8.1/8.2/8.3/8.4, Cognos Datamanager, Cognos Metric Studio, SQL Navigator,
.Net, Microsoft Visio, Http Servers, Load Runner, Html.
Bank of America, Raleigh, NC
Sep'07 - Aug'08
Role: Cognos Administrator/ Report Developer
Description: Bank Of America provides services to individuals, companies,
governmental entities, and institutions in every state of United States. It
offers variety of services like pay bills, Investments and Mutual Funds,
Transfer funds through SWIFT, Automatic Bill payment, Alerts, Monthly
Statements and lot many services in online banking. It also provides
Interest Calculator, Monthly Payment Calculator and many other tools
online. The Purpose of the project was to track the growth, performance and
online utilization of the company's website with its competitors in the
U.S. Market
Responsibilities:
. Gather the requirements from Business and End users.
. Understanding existing business model and customer requirements.
. Involved in Designing the Architecture of Cognos 8 BI.
. Installed and Configured Cognos 8 BI on a Distributed
Environment.
. Designed the Security Architecture and Implemented it.
. Administered the Reporting Environment.
. Administered tasks such as Scheduling, Deployment, and
Dispatchers.
. Created List Reports, Crosstab Reports, Drill through Reports
and Multidimensional Reports with cascading prompts using
Report Studio.
. Migrated ReportNet Reports to Cognos 8 BI.
. Deployed Data from one Environment to Another.
. Created different Standard reports using prompts, filters, query
calculations and conditional Formatting of measures using
variables.
. Scheduled & refresh the reports and bursted reports according to
user requirements in Cognos connection and sent the reports
through E-mail feature.
. Tested and validated the report output against the database to
measure performance of the Report.
. Involved in training sessions and demonstrated Cognos 8 tools to
end-users.
. Developed Projects and published packages using Framework
Manager.
. Prepared User documentation to train users and functionality of
each report.
. Production Support which involves solving user problems.
Environment: Oracle 9i, Windows XP, .Net, Apache,Cognos8, Cognos Report Net
1.1/Mr2, SQL Navigator, Microsoft Visio.
Pfizer, New London, CT
Jan'07 - Aug'07
Role: Cognos Report Developer.
Description: The Instrumenting the Business project establishes an
integrated analysis and reporting environment consisting of: business
performance management scorecards, dashboards, interactive reporting,
enterprise reporting and ad-hoc reporting. The solution will aggregate
information currently captured in disparate applications and tools and
retire the stand- alone reporting tools. This will incorporate best of
breed instrumentation and will derive underlying data from an enhanced
Development Information Factory data store as well as other warehouses as
appropriate.
Responsibilities:
. Gathering Requirements from the end user and checking the
structure of the schema and data with the Data Modular.
. Understanding existing business model and customer requirements.
. Involved in designing schema (star and snow flake) for the
business processes.
. Involved in writing SQL & PL/SQL Procedures.
. Installed and Configured Cognos ReportNet tools and Cognos 7.x
tools.
. Administered the Reporting Environment.
. Developed Projects and published packages using Framework
Manager.
. Administered tasks such as scheduling, deployment, Dispatchers
and security.
. Developed Several Reports including burst reports using Query
Studio, Report Studio and other Cognos 7.x tools.
. Was involved in data merging, transformation and aggregation
using Cognos Decision Stream.
. Was involved in developing slowly changing dimensions and data
marts using Cognos Decision Stream.
. Published Impromptu reports to upfront portal by using IWR
Report Administrator.
. Deployed Data from one Environment to another.
. Migrated Cognos 7.x series Catalogs and Reports to Report
Net1.1.
. Deployed PowerCubes on Upfront using PowerPlay Enterprise Server
and applied Performance tuning techniques and partitioned cubes
to reduce calculate time.
. Created and performed the Unit and Integrity test cases and
assisted the testing team in System Test and Production move
process.
Environment: Oracle 9i/8i, MS Access, WINDOWS 2000/XP, PL/SQL, SQL Loader,
Cognos 7.x.x.1/7.2 tools, Cognos Report Net 1.1, Cognos Visualizer.
Novartis Pharmaceuticals, Morristown, NJ
Aug'06 - Dec'06
Role: Cognos Report Developer
Description: Novartis Pharmaceuticals has products many of which are
leaders in their respective therapeutic areas. The development pipeline
involves about projects in various stages of clinical Safety Data -
including potential new products as well as potential new indications .As
the history of Novartis Pharmaceuticals data for existing products Data
analysis was made on the pharma data marts. Cognos can unlock the Clinical
business intelligence embedded in the metrics of the data mart. And build
data cubes to support ad hoc analysis of the Clinical metrics and show
correlations between performances for a given metric. We have Used Cognos
to deliver drug portfolio management to the desktops of decision-makers.
Responsibilities:
. Understanding existing business model and customer requirements.
. Involved in designing schema (star and snow flake) for the
business processes.
. Involved in design and creation of dimension tables, fact tables
and cubes.
. Involved in writing SQL & PL/SQL Procedures.
. Installed and Configured Cognos Impromptu and Cognos Power Play
along with upfront server.
. Administered the Reporting Environment.
. Tested the Impromptu, Power play User, Power play Transformer
and other Cognos utilities after installation.
. Designed, developed, maintained and tested Catalogs and Cubes
for supporting adhoc queries and reports in BI.
. Developed Macros for Cognos Impromptu.
. Used transformations to create the filters, lookups and
aggregations used to create target tables.
. Used shell scripting to schedule the jobs.
. Created and executed sessions and batches using server manager.
. Prepared User documentation to train users and functionality of
each report.
. Production Support which involves solving user problems.
Environment: Oracle 8i/9i, SQL Server, MS Access, WINDOWS 2000/XP,
Informatica, Cognos impromptu 6.0, Cognos Power Play 6.6, Cognos
Transformer 6.6, Cognos Visualizer.
Metamor Global Solutions Ltd., Delhi, India
Apr'02 - Jul '06
OLAP Report Developer
Description: This package handles all Purchase Department Activities right
from receiving M R P from stores Preparing Purchase Order for that using
Quotation received from suppliers and receiving Delivery data from Supplier
going for Quality check and accepting material giving back to stores.
Responsibilities:
. Involved in Design, Develop, Test and Maintenance of the system.
. Wrote Stored procedures using PL/SQL.
. Creating various Catalogs using Impromptu.
. Created Multidimensional Cubes using PowerPlay Transformer.
. Implemented Drill-Through with Report and query linking.
. Creating Business Ranking and Variance Reports.
Environment: Oracle 7.x/8.0, Cognos 5.0, SQL Loader, Windows NT 4.0.
Contact this candidate