Manager Sales
Resume:
Kiran Kumar
Contact #
Email:
*****.******@*****.***
Summary:
. 9 years of IT experience in the Analysis, design, development, testing
and Implementation of Business Intelligence solutions using Data
Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
. 5+ years of experience with Business Intelligence tools like Cognos 8,
Report studio, Query Studio, Analysis Studio, Event Studio, Framework
Manager, Cognos ReportNet1.1 MR1/MR3, Impromptu Administrator,
Impromptu Web Reports (IWR), PowerPlay, Transformer, PowerPlay
Enterprise Server(OLAP), Upfront, Access Manager, ODBC and Directory
Server.
. Expertise in creating complex reports like Executive Dashboards, Cross
tab reports, Top ten reports, ad-hoc reports, Charts and Score card
reports.
. Strong working experience in Dimensional Data Modeling, Star Schema
Modeling, Snow Flake Modeling, Physical and Logical Data Modeling.
. Expertise in designing metadata Model packages using the Cognos
Framework Manager tool from multiple data sources and created reports
using Query Studio and Report Studio.
. Extensive experience in Designing and Development of OLAP Models using
Cognos Power Play Transformer 7.4.
. Good experience in Impromptu Administrator and Impromptu Web Report
(IWR).
. Hands on experience in Migrating the Impromptu Catalogs, Reports to
Report Net & Cognos 8
. Hands on experience in Cognos Report Net/Cognos 8 Administration and
maintaining Security for Users, User Groups.
. Effectively involved in Cognos 8.4 upgrade from Cognos 8.2.
. Having good knowledge in ETL (Informatica) process.
. Good experience in different Databases like Oracle, SQL Server, MS
Access and Teradata.
. Application Data warehousing experience in Retail, Telecom, Insurance,
Manufacturing and Customer Support Service Analysis
. Hands on experience in Software Development Life Cycle (SDLC) and
effectively involved in Requirement Gathering, preparing Functions
Specifications/High Level Design/Low Level Design Documents.
. Performed Business Analysis in various aspects while initiating and
developing the technical requirements.
. Performed different Test scenarios (Unit, System & Integration and
UAT).
. Good experience on Performance Tuning and Supporting Enterprise
Reporting Applications.
. Having good programming and debugging skills in PL/SQL (Stored
Procedures), SQL, and UNIX shell scripting.
. Hands on experience in Java 2.0, HTML, XML, Java Script and
Application Servers like Tomcat 4.x/5.x and Web Logic.
. Provided Technical and Functional Training of Cognos Products to
Corporate and Divisional users for both technical and non-technical
audiences.
. Strong work experience with Business users to analyze the business
process and made necessary changes to schema objects to cater their
reporting needs.
. Team and Independent player with excellent Organization and
Interpersonal Skills.
Technical Proficiency:
Business Intelligence Cognos 8.2/8.3/8.4, Report Net 1.1, Report
Tools Studio, Query Studio, Analysis Studio,
Metric Studio, Framework Manager, Cognos EP
7 Series Impromptu, Cognos Power Play,
Cognos Transformer, Upfront IWR, Report
Administration, Power Play Web, Access
Manager, Crystal Reports XI and
MicroStrategy
ETL Informatica Power Center 7.1
Data Warehousing Data marts, OLTP, OLAP, Normalization,
Dimensional Modeling, Facts, Dimensions,
Star schema, Snow Flake schema, slowly
changing dimensions.
Data Modeling Erwin 4.0/3.5
Databases Oracle 10g/9i/8i, MS SQL Server 7/2000,
Teradata, DB2, MS Access
Languages Java 2.0, J2EE, SQL, PL/SQL, Unix Shell
Script
Web Technologies HTML, JSP, XML
Tools Toad, SQL* Loader, Serena Dimensions, VSS,
Teradata SQL Assistant
Operating Systems Windows 95/98/2000 Server, Windows NT, Sun
Solaris and UNIX
IDE & Test Tools Eclipse 2.1/3.1,JUnit, Mercury Quality
Center 9.0
Education:
> Master of Computer Applications (M.C.A) From Sri Venkateswara
University, India.
PROJECT EXPERIENCE:
The GAP Inc., San Bruno CA
Oct' 07- Current
Sr. Business Intelligence Consultant
The GAP Inc. is one of the world's largest Retailers with more than 3000
stores. GAP uses pre-season and in-season planning to determine the
inventory of each product that needs to be sent to their stores. The
objective of GAP Business Intelligence project is to provide the accurate
forecast data and the actual sales data for different products so that
business users can plan the inventory. I have taken ownership of different
applications like Executive Dashboard/Store KPI Dashboard/Store
Productivity Reports/Sales & Inventory Reports/Franchise Delivery
Visibility/Daily Sales/Weekly Sales and Top 30 Reports.
Store KPI Dashboard/Executive Dashboard:
This is one of the major Projects in GAP which is extensively used in all
stores for all brands. The reports are based off the Location Hierarchy
spanning from Zone, Region, District and Store. Ability to navigate from
Zone Level down to Store is provided based on user level in the location
hierarchy. The Time Hierarchy will span from This Week (TW), Last Week
(LW), Month-to-Date (MTD), Quarter-to-Date (QTD), Season-to-Date (STD) and
Year-to-Date (YTD). Not all data is available at Day Level and some will
be at Week level or higher (MTD, QTD, STD, and YTD) depending on
availability in the EDW. IOC Stores need to be rolled-up to parent stores
whenever store-level details are shown. Access to Portal reports will be
provided through LDAP security (user level access). User Access should be
granted as per the LDAP security access model. Over 15000 users across all
brands are using this Dashboard Reports. User Access is granted a level up
and across down. For ex: A Store Manager can see Parent District Report as
well as the entire sister stores in the Parent District.
Responsibilities:
o Interacted with Business Users to prepare and update the Business
Process Requirements and Software System Requirements.
o Effective involved in Analysis and Design Phases.
o Effectively involved in Enterprise reporting design, estimation and
development.
o Designed and Implemented data cubes using Cognos Power Play Transformer
for end user reporting.
o Created and enhancing business model by using Cognos Framework Manager.
o Designed Framework Manager Projects, Model & Packages, Importing the
meta data from the Data Source tables, Views, Data Marts and Macros.
o Created different kind of reports like: Executive Dashboard, Store
Dashboard, Ranking reports, and Daily/Weekly Flash sales report using
List, crosstab and chart report.
o Applied security in Framework Manager at different levels like Object
Level, Package level and data level.
o Created Parameter Maps and Parameter variables for using the same
package with different brand (GAP, BR and ON).
o Maintained the reports in Serena Dimensions for version mechanism.
o Used Cognos Utility Tool to upload the components into Dimensions.
o Created the Dashboard reports with multiple tabs using cross tabs for
different time periods (TW, LW, MTD, QTD, STD and YTD).
o Created Cognos Views (Flattened) in Teradata database as per the
requirement to join multiple tables and to apply filters based on the
requirement.
o Implemented Tree Prompt in Store Dashboard to get the Location
Hierarchy and user can select different levels of location.
o Created report views for each level of location hierarchy and busted
them into folders.
o Implemented the security based on the Effective Job Location Code
(EJLC).
o Created URL's to navigate from one report to another report using Java
Script functionality.
o Involved in upgradation of Dashboard/Daily Sales/Weekly Sales reports
from Cognos 8.2 to Cognos 8.4.
o Tested all the reports with Cognos Generated SQL and manual SQL using
Teradata SQL Assistant.
o Tracking of defects and Quality Center and reassigning back to Quality
Analyst.
o Provided extensive training to end users, how to use the Dashboard
reports in Cognos 8.
Environment: Cognos 8.2/8.4 (Framework Manager, Report Studio, Query
Studio, Analysis Studio), Power Play Transformer 7.4, Serena Dimensions,
ORACLE 9i/10g, Teradata, Teradata SQL Assistant 7.2, IBM AIX, IBM
Websphere, IBM LDAP, IBM HTTP Server, Windows XP.
Gulfstream, Savannah, GA
Mar' 07- Sep' 07
Sr. Cognos BI Consultant
Gulf Stream Aerospace Corporation is a manufacturer of several models of
Jet Air Craft. It is a unit of General Dynamics. I was involved as a
Cognos Admin/Report developer and performed various key roles in different
projects. Developed various cubes and reports and Implemented Report Net
for the enterprise reporting of various business applications Time & Labor,
CMPNet, Corridor & Weights DB.
Responsibilities:
o Analyze business requirements and prepared functional specifications /
system technical design documentation's.
o Participated in Enterprise reporting Project Design, Estimation and
development.
o Installed, Configured and Deployed Report Net & Cognos 8 on NT and
Unix (AIX) environments.
o Migrated Report Net 1.1 Models and reports to Cognos 8 Environment.
o Imported metadata from different sources such as Relational Databases,
XML Sources and Impromptu Catalogs into the Framework Manager.
o Designed and Developed Projects, Packages, Reports using Framework
Manager, Query Studio and Report Studio.
o Created and Published Packages to Report Net using Framework Manager.
o Created Dashboards and Scorecards using Metric Studio.
o Created user requested reports in Report Net and Applied Security.
o Setting up of the Audit logs for monitoring the usage of reports.
o Created and Maintained Impromptu Catalogs and Created and Maintained
Impromptu Reports for Corridor Application.
o Designed and developed multi dimensional cubes and implemented
security in cubes.
o Published Power play cubes to PPES.
o Create Cognos Views in Oracle database as per the requirement to join
multi tables and to apply the filters based on the requirement.
o Applied the user class security to Impromptu Reports using Cognos
Catalog and Access manager.
o Maintaining system and server performance, including disk usage,
memory monitoring, available services, and statistic reporting
o Enhanced existing power cubes to add dimensions, measures as per the
user requirements.
o Enhanced existing security in cubes and reports to add new user
classes.
o Maintained Security at Query Subject as well as Query Item level for
labor cost views.
o Created several List, Crosstab, Chart, and Repeater Reports using
Report Studio.
o Developed Prompt Pages and used Conditional Formatting.
o Moved Report Net reports and models from Development to Production.
o Worked with Cognos Customer Support to address problems and resolve
problems.
o Provided training to End-users.
Environment: Cognos 8 (Framework Manager, Report Studio, Query Studio,
Analysis Studio, Metric Studio), Report Net 1.1 MR3, ORACLE 9i/10g, SQL
Server 2000, TOAD 7.2, Access Manager, IIS, Windows 2003 Server, Cognos
Power Play Transformer, Cognos Power Play, Power Play Enterprise Server.
Timberland, Stratham, NH
Oct '06 - Feb' 07
Sr. Cognos BI Consultant
Lost Demand & NAW Release 2 C Codes For Cognos / BI Reporting:
The Timberland Company is a leading footwear company in North America with
suppliers in Asia and Europe. The aim of this Cognos BI project which
supports reporting for Lost Demand Planning for North America, Europe and
Asia Pacific Business users. Lost Demand data will be captured in the
TBS/EBS/APBS transaction systems per the requirements of the Lost Demand
Project. The data will be extracted and loaded into the BI source system
(TBLUSA14) per fact table. Lost Demand data captured in the TBS/EBS/APBS
transaction systems will also be extracted and loaded into the Manugistics
system making it available for reporting and analysis in the Seven
Worldwide Demand Planning Cognos Power play cubes. The aim of NAW Release 2
project is to support NAW Release II C codes changes for Cognos Reporting.
It outlines each requirement and the suggested solution for each of the
Cognos Cube and report that entail the change. Changes are needed to Cognos
objects due to assigning of Sales Agency Code at Style/Color/Dimension
level instead of Style level. The changes to the Cognos queries involve
changing the source of the data from NSAPRDP (Style level) to NSASCDP
(Style/Color/Dimension). The set of changes to NSAPRDP and NSASCDP in TBS
will also be implemented on these files in Cognos Data mart server
TBLUSA14.
Responsibilities:
o Interacting with Business Users for Gathering Business Requirements to
develop Reports.
o Designed, Developed and Implemented an Enterprise Wide Reporting
system using Cognos BI.
o Installed and configured various components, such as the Impromptu
Administrator, Power Play Transformer, Access Manager, LDAP server,
Power Play Enterprise Server (PPEP), Upfront, Impromptu Web Reports,
Framework Manager and Content Manager (Database).
o Maintained projects using VSS as the version control mechanism.
o Migrated Impromptu Catalogs and Reports to Cognos 8.
o Imported metadata from different sources such as Relational Databases,
XML Sources and Impromptu Catalogs into the Framework Manager.
o Used Framework Manager to build models, packages and published to web.
o Built models containing query subjects, query items, and namespaces
from scratch as well as from imported metadata.
o Created Filters, Calculations, Conditions, Graphs, and Prompts.
o Created several List, Crosstab, Chart, Repeater reports using Report
Studio.
o Developed Prompt Pages and used Conditional Formatting.
o Developed Multidimensional Models in Power Play Transformer and
generated Power Cubes for OLAP comprising of dimensions, hierarchies,
levels, categories, and measures.
o Created Alternate Drill-Down Path, Special Categories & Currency
Conversion set up to better suit different user groups.
o Enhanced existing reports and created new reports as per the business
requirements.
o Moving reports from Development to Production Environment.
o Tested all the reports with Generated SQL and Manual SQL data.
o Trained users on creating reports based on the developed catalogs.
Environment: Cognos 8 MR1 (Framework Manager, Report Studio, Query Studio,
Analysis Studio), ORACLE 9i, TOAD 7.2, Impromptu Administrator, Access
Manager, LDAP Server, IIS, Windows 2000 Server, Unix, Power Play
Transformer, Cognos Power Play.
Nationwide Insurance, USA
Jun' 05 - Sep' 06
Sr. Cognos Developer
Nationwide Insurance one of the large insurance company in United States.
The company has implemented a claims processing system known as Customer
Restoration Network (CRN). Nationwide wants to build a decision support
system to monitor the effectiveness of the system to analyze claims
processing and call center performance. I have involved in the generation
of a range of analysis and reports using Cognos products like Impromptu and
Power play. These reports could be published on the web using Cognos
Upfront Tools.
Responsibilities:
o Installed and configured ReportNet including Report Studio, Query
Studio, Framework Manager and Cognos Connection Portal
o Implemented security for the BI environment. Setup security for Data,
Object level and Package access using Cognos Access Manager
o Interacted with the business analyst, gathered requirements; developed
portals for Business Intelligence Group.
o Designed and created ReportNet metadata; provided access to business
users.
o Built Models and Repositories in the ReportNet Framework Manager,
published packages to the ReportNet
o Developed BI reports linking various database. Developed List,
Crosstab, Drill through Reports, Master Detail Reports, Bursting
Reports and Ad hoc reports based on business requirement.
o Customized data by adding Filter, Calculations, Summaries and
Functions; used extensive conditional formats to highlight the
critical data.
o Developed catalog using ODBC connectivity, defined joins and folders;
assigned users by defining the user class using Cognos Impromptu
o Created and modified catalog; developed standard filters,
calculations, prompts and conditions in the catalog.
o Included data sources in multi-dimensional models as Impromptu Query
Definition. Developed alternate drill through categories and
calculated measures.
o Involved in migrating reports from Impromptu to ReportNet. Published
all Impromptu reports to IWR Upfront.
o Organized accessed data sources to Transformer models, Dimensional
maps; developed Power Cubes using slice and dice technique for further
multi dimensional analysis.
o Designed the cube hierarchy drill down for dimensions, resolved
hierarchy related issues in consultation with business analyst.
o Built caned and ad-hoc reports using PowerPlay explorer and PowerPlay
reporter with dimensional filtering; published them to Cognos Upfront
o Extensively used parentage subsets, advanced subsets; used features
like ranking and percentage of base in the PowerPlay Reports
o Interpreted complex business specifications developed by the business
analyst; generated cubes and reports to meet customer specifications.
o Created daily, weekly, monthly and quarterly reports for the
management team and field operation managers using PowerPlay reports.
o Built data warehousing services of the company; conducting requirement
analysis, the design and development of a dimensional data model, the
creation of a database in both Oracle8i and SQL Server 2000.
Environment: Cognos ReportNet 1.1, Powerplay Transformer 7.3, Cognos
PowerPlay, Access Manager, SQL, PL/SQL, Oracle 9i, SQL Server, Windows
2000, Windows 2003 Server.
Norwich Union, UK
Oct' 04 - May' 05
Cognos Developer
Norwich Union is the largest insurance services provider in UK. The project
was aimed at making a data-warehousing system out of insurance customers
having different health insurance policies. The data used to come in as
flat file database and loaded in database using Informatica. Cognos -
PowerPlay Transformer a powerful frame-based authoring deployment of cubes
for reports, cross-tab reports, where a sub report provides multiple views
of the same basic information. Impromptu used for catalog's creation to
view database for impromptu reports. There are three modules
(functionality) in this Common App's; existing inquiry transactions will be
executed for Local and Auto database, existing update Transactions will be
executed for the Local database and Cold Storage Transaction - A back up
transaction (A log file which maintains transaction history).
Responsibilities:
o Gathered report requirements with Business Users and converted them
into project documentation.
o Developed catalog using ODBC connectivity, defined joins and folders;
assigned users by defining the user class using Cognos Impromptu
o Created and modified catalog; developed standard filters,
calculations, prompts and conditions in the catalog.
o Included data sources in multi-dimensional models as Impromptu Query
Definition. Developed alternate drill through categories and
calculated measures.
o Developed various Impromptu reports and converted them into IQDs,
integrate them to PowerPlay transformer; built detailed list reports,
summary, trend analysis and drill through reports using Cognos
Impromptu
o Published all Impromptu reports to IWR Upfront
o Organized accessed data sources to Transformer models, Dimensional
maps; developed Power Cubes using slice and dice technique for further
multi dimensional analysis.
o Designed the cube hierarchy drill down for dimensions, resolved
hierarchy related issues in consultation with business analyst.
o Built caned and ad-hoc reports using PowerPlay explorer and PowerPlay
reporter with dimensional filtering; published them to Cognos Upfront
o Extensively used parentage subsets, advanced subsets; used features
like ranking and percentage of base in the PowerPlay Reports
o Interpreted complex business specifications developed by the business
analyst; generated cubes and reports to meet customer specifications.
o Created daily, weekly, monthly and quarterly reports for the
management team and field operation managers using PowerPlay reports.
o Integrated Cognos Upfront News boxes and News Items in Cognos
Connection.
o Created Folders, Prompts, and Calculated Columns, User classes and
User class filters in Catalogs, Administering the Impromptu Catalogs
by creating User classes and User class filters.
o Optimized the performance in power play cubes by reducing the query
time and partitioned cubes.
o Optimizing by assign Relative Weights to the Tables in the Catalog and
Query Performance
Environment: Report Net 1.1, Framework Manager, Report Studio, Cognos
Connection, Cognos Impromptu Administrator 7.1, Architect 7.1, Power play
Enterprise Server 7.1, Impromptu Web Reports 7.1, Power play Transformer
7.1, Cognos Scheduler, Cognos Upfront 7.1, Access Manager, Configuration
Manager, Windows 2000, Oracle, PL/SQL, Toad.
SEIKO EPSON, Japan
Dec' 03 - Sep' 04
Management Core System (MCS)
Sr. Java Developer
Management Core System is a Network Management System (NMS) application.
Network Management System is a computer that has been set up to monitor and
manage a computer network and the devices contained in the network. Here
Epson wants to monitor its own products like Printer, Scanner, Photocopier
and etc. In this application a device is first registered with the suitable
network. Then MCS will do monitoring on this system, if there will be any
warning or error occurs at the device side then Monitoring Handler will
recognize that error or warning and reports to the Administrator.
(2) Campus Printing System (CPS): This system has been named as Campus
Print System1.0. The system includes a printer, copier and scanner
available to a select group of users. The users will be charged for the
printing/copying operations. The proposed system has to be more generic so
that different authentication and charging devices like IC cards, Finger
print, Coin box, etc, can be used for accounting with minimum effort.
(3) Print Shuttle System (PSS): EPSON has proposed development of an easy
to use printing system. This printing system is expected to have two
features, one is It should be light weight printing system without use of
centralized server and another is it should enable users to print without
being concerned about the Printer Driver. EPSON named this system as Print
Shuttle System (PSS).
Responsibilities:
o Understanding the Functional Requirements given by the Client.
o Involved in reviewing the functional requirement with the team and
Client.
o Involved in the preparation of Functional Specifications.
o Involved in design and document HLD & LLD for the Functional
Specifications.
o Participated in Design (Class & Sequence Diagrams) and Analysis of the
application using Eclipse.
o Taken the complete responsibility of Trap Management (a module) in the
application.
o Involved in the creation of databases on Oracle, SQL Server and
Firebird.
o Involved in the preparation of the Unit and System Test Cases.
o Involved in Unit Testing and System Testing of the application.
o Updated weekly status reports to Manager in time.
Environment: Java, Servlets, JSP, Eclipse, Windows 2000 Server/Advanced
Server, Oracle 8i, MS-SQL Server, Firebird, Visual Source Safe.
Vartec Telecom, TX, USA
Sep' 02 - Oct' 03
Payment Mediator Application (PMA)
Payment Mediator Application (PMA) for VarTec Telecom USA to consolidate,
correct and route the payments coming from various sources. The PMA
application will be developed based on Java technology and uses Oracle DB
for storing the data. The Payment Mediator will take payment files from
various sources and direct the payment records to the appropriate billing
system based on the brand codes contained in the payment files. Currently
VarTec uses five different billing systems for its customers like Arbor, LM
Data, Unicorn, DirBill and Sentori.
Responsibilities:
o Involved in reviewing the requirements with clients.
o Participated in the High Level Design and Low Level Design.
o Developed Class & Sequence Diagram using Eclipse 2.1.
o Involved in writing JSP pages for the application.
o Completely involved in Data Base part by writing Triggers, Procedures
and other database programs like writing PL/SQL Server Pages (PSP) for
Login information.
o Involved in preparation of test cases, peer-to-peer review meetings
o Involved in different kinds of testing (Unit Testing, System Testing
and Integration testing).
o Updating weekly status report to Project Manager
Environment: Java, Servlets, JDBC, JUnit, JSP, Oracle, Web logic 6.0, PSP,
Windows 2000, Sun Solaris, VSS and UNIX.
Xpert International
Apr' 02 - Aug' 02
Java Developer
Xpert Personal Evaluation Recruitment Tool: Xpert is workflow enabled
automatic recruitment management system. The aim of this project is to
minimize the enormous amount of time, cost intensive tasks involved in the
recruitment process for an organization. In broader terms Xpert is an
Application Service Provider, which caters to the corporate manpower
requirement. The main features of this project are storage of the resumes
in the format the organization desires, automatic scheduling of the
activities involved in the selection process, monitoring the status of a
resume, request (Company's resource requirement specifications),
Configuration of the system, Intelligent analysis of the bottle necks in
the recruitment process. Automatic mail generation, online scheduling of
applicants by capturing the "change activity date" option through
interactive mails, automatic rescheduling of the qualified applicants for
the next activity, are the few other features.
Responsibilities:
o Involved in review meetings with clients while gathering the
requirements.
o Written Stateless session beans and Container managed entity beans.
o Written Servlets and JSP's.
o Involved in the design and development of Mailer Module.
o Written Unit test cases for Mailer Module.
o Involved in Unit Testing and System testing.
Environment: Java, JDBC, Servlets, Oracle 8i, Web Logic 6.0, XML and
Windows 2000
Electronic Corporation of India Limited
Aug' 01 - Mar' 02
Java Developer
Indent Management System: This system is to provide a single, web based
system to track key business metrics used to track ECIL business processes
throughout manufacturing. The main aim of this project is to raise an
Indent Form. In this system first we check the customer required materials
are available or not, if not, then we can raise an indent form. For this we
have to send a request quotation and then recommended with higher authority
people, then only it can be processed. The company maintains each material
records and their capacity in order to maintain the customer requirements.
Responsibilities:
o Understanding the Functional Requirements given by the Client.
o Involved in reviewing the functional requirement with the team and
Client.
o Involved in design and documenting the requirements.
o Participated in Design (Class & Sequence Diagrams) and Analysis of the
application using Eclipse.
o Taken the complete responsibility of Sales & Inventory (a module) in
the application.
o Involved in the creation of databases on SQL Server.
o Involved in the preparation of the Unit and System Test Cases.
o Involved in Unit Testing and System Testing of the application.
o Updated weekly status reports to Manager in time.
Environment: Java 1.1, Servlets, JDBC, JSP, Windows 2000 server, MS- SQL
Server.
Contact this candidate