Manager Sales
Resume:
Kumar Shan
*******@*****.***
Objective
Seeking a challenging position as a Developer/Business Analyst in Cognos 8 series, ReportNet
1.x, Impromptu to further add value with my skills while making a positive contribution to the
organization.
Professional Summary
• 5 + years of working experience in Business Intelligence, Performance Management,
and Data Analysis.
• Proficiency in designing and creating metadata models in Framework Manager as per
the business requirements and specifications.
• Strong knowledge and liaison experience of gathering and transforming requirements
into deliverables.
• Experience in developing Dashboards in Cognos 8.
• Experienced in de-normalizing a Transactional model and creating a Dimensional model
that reflects the essential components of the business.
• Well versed in importing SAP BW sources in Framework Manager.
• Experienced in Cognos 7 & Cognos 8 tools such as Report Studio, Query Studio,
Framework Manager, Transformer, PowerPlay, Impromptu, Impromptu Web Reports
(IWR), PowerPlay Enterprise Server, Access Manager, Data Manager 8.1.
• Installed, configured and administrated Cognos applications.
• Proven experience in advanced professional Report authoring, dash boarding and
metadata modeling.
• Created metrics dashboards and scorecards to compare operational performance to
strategic plans.
• Implemented security for Data access, Object level access and Package access.
• Experienced in improving the performance & response time of prompts, queries, and
reports.
• Experienced in building OLAP models & optimized Cubes in Transformer and DMR
models in Framework Manger in C8.
• Proficient with HTML items and Javascript items in Report Studio.
• Created Business Intelligence Reports using Cognos Impromptu and Cognos Powerplay.
• Identify key data integrity issues in source systems, propose and implement solutions
(i.e. Product hierarchy validation system (JDE) to ensure a true sales reporting
hierarchy that would then be displayed in Cognos 8).
Kumar Shan
*******@*****.***
• Design Product Quality Reporting system to maintain medical product complaint
reports with analysis and audit requirements that comply with Client’s internal
reporting standards.
• Participant in the Leadership Development Program.
• Demonstrated user interface to stakeholders via mock-ups / storyboards.
• Worked on Cognos 8.4.
• Created Data dictionary, gap analysis, and technical specification documentation.
• Excellent communication and interpersonal skills and ability to work effectively in a
team as well as individually
Technical Skills
Kumar Shan
*******@*****.***
Work Experience
Aetna, Phoenix, AZ Dec 2007 – Present
Sr. Cognos Architect
Aetna is one of the nation’s leading diversified health care benefits companies, serving
members with information and resources to help them make better informed decisions about
their health care. The project involved creating complex reports and dashboards to allow
executive and mid management to know where they stand in terms of enrollment and
spending. The project also involved designing OLAP cubes for statistical analysis and future
projections.
Summary of Tasks
• Gathered and analyzed user requirements.
• Upgraded all Cognos 8.2 models and reports to Cognos 8.3 using Upgrade Manager.
• Resolved any errors or issues resulting from upgrades.
• Created & maintained data sources in Cognos connection and used Framework
manager’s best practices to create models, publish packages.
• Created Data Marts by converting snowflake schemas into Start Schema groupings in
Framework Manager.
• Ugraded 8.3 reports and packages to Cognos 8.4 in Test environment.
• Successfully integrated Cognos with the Active Directory for single signon capability.
• Secured the Cognos environment so that each business group can have access to their
respective folders and their desired capabilities.
• Parameterized models in Framework Manager using Parameter Maps so that the
datasource can be dynamically allocated at run time. That is, one framework model
points to multiple datasources.
• Built Cubes based on user requirements for OLAP Analysis.
• Created drill-through dashboards and multi-page portals for ease of navigation.
• Used report output variables to change the report format in HTML and PDF formats.
• Created conditional format reports to give the real-performance of the organization and
highlight the weak and strong indicators.
• Used Javascript to prepopilate predefined values in prompts.
• Developed reports with HTML items to add complex functionality to dashboards and
reports.
Kumar Shan
*******@*****.***
• Dynamically sorted columns in Report Studio using Javascript.
• Built cubes to be used in Analysis studio for the business users to drill-up and drill
down.
• Setup drill-through from cubes to reports to provide more insights for users.
• Create business reports for XML data with Report Studio and DB2 pureXML.
• Developed a Scorecarding application in Metrics Studio that compared strategic plans
to actual operational measures.
• Used Metrics Designer to update extracts in the Metric Store.
• Created Dashboards on multi-page portal pages and setup communication among the
different portal pages.
• Linked various related reports to dashboards to provide more insight on the business.
• Developed Master-Detail relationship reports to combine two reports into one using a
common query item as the link between the queries.
• Created Conditional Block reports to dynamically hide or show report objects and
provide the end user the option to view the data in different formats.
• Developed Cascading prompts to filter data dynamically and conveniently locate the
data the users are trying to use.
• Developed complex reports, multi-query reports and sub selects queries to meet the
client requirements.
• Created reports based on multiple models dynamically without having to link the
models together.
• Designed a random sample report that returns a random sample number of rows out of
the whole report. For example, return 10 sample rows out of 100 rows.
• Created Cognos presentations and mentored the client on the capabilities of Cognos.
• In charge of all the Content Administration of the portal and deployed different
packages and reports to the environment from different teams.
• In charge of all the Content Administration of the portal and deployed different
packages and reports to the environment from different teams.
Environment: Cognos 8.4/8.3/8.2 (Framework Manager, Report Studio, Analysis Studio, Query
Studio, Metrics Studio, Metrics Designer, Cognos Connection), Transformer, Power Play,
Oracle 10g, Windows XP, Toad, LDAP.
Kumar Shan
*******@*****.***
CIGNA, Philadelphia, PA Nov 2006 – Oct
2007
N
Sr. Cognos Developer
CIGNA is a global health service company that provides Healthcare and Insurance services
throughout North America. Cigna Healthcare provides managed medical, pharmacy and
dental care services, including integrated indemnity and group life and health insurance for
employees that are primarily offered through their employer. The project involved developing
a complete BI architectural solution for the Sales and Finance Departments.
Summary of Tasks
• Responsible for gathering, reviewing and analyzing business requirements. Work with ETL
team to develop data marts for healthcare sector, Law Department, Sales, and Finance.
• Conducted presentation on Cognos 8.1 to management and different business groups for
training and new capabilities of Cognos 8.1.
• Established joins in database layer, created calculations, filters and Star Schema
groupings in business layer.
• Created complex Dashboards with Drill through Reports which were critical for users from
multiple departments.
• Created Relational (Sales, Fixed Assets, Accounts Payable, Accounts Receivable, General
ledger) models for BMR and JDE reporting; DMR (Pharmacy) models using Framework
Manager.
• Created and maintained 7.4 Transformer models, build cubes using framework manager
IQD’s and packages.
• Publish cube packages on Cognos connection. Refresh & swap cubes in Cognos 8.1 using
macros, tidal and windows scheduler.
• Created drill through from Analysis Studio to detailed report studio reports for all levels
and dimensions in analysis studio. Created drill through definitions, permissions etc.
• Created simple and complex reports in Report Studio, and Analysis Studio.
• Implemented data level security in Cubes and Framework Manager.
Kumar Shan
*******@*****.***
• Developed complex Report Studio reports using Table of contents, Multiple queries, Page
sets, Advanced grouping, Conditional blocks, Master-detail relationships, Complex
summaries calculations and enhanced multiple prompts, Joins, Union, and Except
operators, charts etc.
• Developed simple and complex dashboards for different business groups with different
portal pages for the different user groups.
• Deployed reports from Test server to Production Server. Created and Scheduled jobs in
Cognos connection.
• Successfully migrated Cognos Series 7 Impromptu reports to Cognos 8.
• Achieved Single Signon functionality (SSO) by binding Active Directory with Cognos 8.
• Modified Cognos 8 SQL generation rules to enhance query performance by modifying the
Cogdmor.ini file.
• Responsible for bursting reports on the windows server and in the content store so that
different user groups receive their designated reports.
• Participated in management review meeting to discuss & resolve Cognos related issues.
Reviewed & verified reports with management before deploying it to production. Analyzed
the performance of prompts, and reports by reviewing cognos generated SQL & report run
time.
• Created Dashboards (Executive Dashboards, OD Dashboards, VP Dashboards, Sales
Dashboard), complex reports using Cognos Report Studio and performed ad-hoc queries
using Query Studio.
• Created Drill through and Master Detail reports using Report Studio for Weekly Sales
Analysis reports and Monthly Summary reports.
Environment: Cognos 8.1 (Report Studio/Query Studio/Analysis Studio), Cognos 7.3
(Impromptu, Transformer, PowerPlay ), PL/SQL Developer, Oracle 10g, Oracle9i, MS
Access/Excel, Access Manager, SQL Server 2000/2005.
Merck, WhiteHouse Station, NJ June 2005 – Oct
2006
BI Developer/Business Analyst
Kumar Shan
*******@*****.***
Merck & Co., Inc. is a global research-driven pharmaceutical company dedicated to putting
patients first. Established in 1891, Merck discovers, develops, manufactures and markets
vaccines and medicines to address unmet medical needs. The project also involved creating
reports for Executive and Mid-managers to track the performance of their Sales Force team.
Summary of Tasks
• Involved in the entire project life cycle from evaluation, installation and development of
end user reports.
• Was a part of the team responsible for the Installation and configuration of Cognos 8.1.
• Created reports in Report Studio, Query Studio and Analysis Studio Created drill through,
dashboard, burst, master-detail, and financial reports Created and troubleshot reports
containing conditional formatting, filters, prompts, maps, charts, crosstabs and lists.
• Used Cognos MDX functions to create reports connecting to a cube or dimensionally
modeled relational datasource.
• Created reports using Cognos Functions and parameters Applied JavaScript code to
reports for added functionality.
• Integrated reports into Portal Pages as links and worked on reports that pass parameters to
other Portal Pages.
• Created packages using Framework Manager Dimensionally Modeled Relational
datasources for increased functionality in Report Studio Knowledge of star schema
modeling.
• Created packages containing package security, data security, and object security in
Framework Manager.
• Setup groups and roles in Cognos Connection Setup security on namespaces, folders, and
reports Setup capabilities for users to access specific applications.
• Converted MS Access Reports into Cognos 8 reports.
• Created list reports/Crosstab and used master detail relationships.
• Created Dashboards for (Open tickets, Delinquencies) as per business requirements.
• Used Cascading prompts, Conditional Blocks, Filters, Bookmarks to create efficient
reports in Report Studio.
• Created Business mix reports, Trend over time reports, Forecast reports and Charts using
PowerPlay.
• Created customized reports in MS Excel using VBA, PowerPlay (PPEX) Add-ins.
Kumar Shan
*******@*****.***
• Created a Dimensionally Modeled Relational package that covered the entire business
with hierarchies and measures. Hence business users can view summary data at a glance
and drill into detail level data within the same report.
• Migrated data packages into different environments.
• Performed Data Validations using Toad and provided User Training.
• Optimized cube performance by auto-partitioning and caching.
• Participated in discussions with the senior management to better understand the business
requirements.
• Used Framework Manager to create data packages combining data from a number of data
sources.
• Involved in building the Multidimensional Cubes from various data sources.
• Created appropriate dimensions and manual levels in the Transformer model.
• Optimized the cube performance to improve report response time.
• Creating appropriate User classes, users, and database signons in Access Manager to
provide different levels of authentications and provided the security for the users.
• Performed End User Training and Support for Cognos 8.1.
Environment: Cognos 8.1 (Report Studio, Event Studio, Query Studio,
Analysis Studio, PowerPlay, Transformer, Access Manager), LogiXML,
Oracle 8, Toad, DB2, SqlServer, PL-SQL, MS Project.
J.C. Penny, Plano, TX August 2004 – April
2005
Cognos Developer/Business Analyst
JCPenney is one of America's leading retailers, operating throughout the United States. The
main task was to design and develop a Cognos Reporting environment to be integrated with
the client’s Data Warehouse. The main goal of the project was to provide the decision makers
insight on to how they are performing.
Summary of Tasks
• Gathered and analyzed user requirements.
• Used Framework Manager in ReportNet to model metadata.
Kumar Shan
*******@*****.***
• Created ad hoc reports and queries using Query studio and complex reports using Report
Studio in ReportNet.
• Created Dashboards for Sales Bookings, Activity and Pipeline with multiple Cross Tabs,
List and Charts.
• Used Cascading prompts, Filters, Bookmarks, Conditional Formatting, Drill Through,
HTML Items, Custom Style Sheets to create efficient reports in Report Studio.
• Created Jobs for the Scheduling of reports.
• Created appropriate User classes, users, database sign-on in Access Manager to provide
different levels of authentications and used them in Cognos Connection for
implementation of Cognos Series 7 security.
• Defined data sources and their associated connections, managed report schedules and
their run history, Configured the environment, performed load balancing, and monitored
dispatchers and services, deployed data from one environment to other using Cognos
Connection.
• Automated routines that extracted and loaded data using DTS (Data Transformation
Services).
• Created and Managed Indexes in Database Tables for faster retrieval of data.
• Built ASP Script to convert text to binary to open a different application from Cognos
Reports.
• Coordinated and wrote technical specifications for the offshore team.
• Provided End User training for ReportNet.
Environment: Cognos ReportNet 1.1 (Query Studio, Report Studio, Framework Manager,
Cognos Connection), Cognos EP Series 7.3 (Access Manager), SQL Server 2000, Oracle 9i,
Windows Server 2003
U.S. Bancorp, Minneapolis, MN July 2003 – June
2004
Cognos Developer/Consultant
Kumar Shan
*******@*****.***
U.S. Bancorp is the parent company of U.S. Bank, the 6th largest commercial bank in the
United States. The main objective of project was evaluation, installation and development of
end user reports for the finance department.
Summary of Tasks
• Worked directly with end users gathering reporting requirements.
• Participated in discussions with the senior management to better understand the business
requirements.
• Created Impromptu catalog and HotFiles in order to generate various group reports.
• Developed data specific Impromptu reports with various filter conditions.
• Extensively used cascading prompts, drill-through, sub-reports, summaries, conditional
formats, grouping and association features of Impromptu to generate efficient and user-
friendly reports.
• Created joins in Impromptu for metadata information in the catalogs.
• Developed Impromptu query definition files (IQDs) and imported them into Transformer
for creation of cubes.
• Created Sub cubes for user groups using PowerPlay Transformer.
• Implemented drill-through from PowerPlay cubes to Impromptu reports.
• Published Impromptu, PowerPlay reports and cubes to Upfront using IWR and PPES.
• Time scheduled the report publishing using the Scheduler.
• Optimized the cube performance by auto-partitioning and caching.
• Scheduled reports to use off peak hours effectively.
• Setup and maintained user ids, passwords and user classes using Access Manager.
• Provided End User training and Support for Impromptu and PowerPlay.
Environment: Cognos EP Series 7.1 (Impromptu, PowerPlay, Impromptu Web Reports,
PowerPlay Enterprise Server, Transformer, Upfront, Access Manager), Oracle 8i, Windows 2000
Education
Bachelor of Engineering Carleton University, Ottawa
Major in Electrical and Minor in Computer Science
Contact this candidate