Sales Manager
Resume:
***********@*****.***
ABHINAV KACHHWAHA
Contact:
60202
Qualification Year University
Master of Science (Information 2012- 2013 Northwestern University, U.S.
Technology)
Bachelor of Engineering (Electrical & 2002-2006 R.G.P.V. India
Electronics)
Professional Experience
. Cognizant Technology Solutions Ltd. ( Jan 2007 - till Sep 2012
Professional Summary
. An Oracle Certified Associate has 68 months of experience in IT industry
with Cognizant Technology Solutions.
. Served as Onsite coordinator for around 8 months in Netherland and
Singapore.
. Have worked for Data warehouse, Business Intelligence, Data Modeling,
Data Mining, Business plan development, Report Development, ETL, Business
Applications.
. Strong experience in Object Oriented Analysis / Design / Methodologies.
. Extensive SDLC experience including Requirement gathering, Analysis,
Preparations of Technical Specifications Document, Design and Coding,
Application Implementation, Unit testing and System Testing,
Documentation, Production Support, Functional and Regression Testing.
. Gave Corporate Training on Actuate 7.0 in Cognizant Academy.
. Working knowledge in different domains including banking and finance,
pharmaceutical and telecommunication.
. Excellent knowledge of Analysis, Design and Development of business
applications in developing Client/ Server environment using OBIEE
10.1.3.x,/Siebel Analytics,PL/SQL, Informatica 8.x/7.x/6.x /DAC,Siebel
and Actuate eReporting designer professional 6/7.
. Extensive knowledge of supervised learning and unsupervised learning data
mining models.
. Experience in developing OBIEE Repository (.rpd) at three layers
(Physical Layer, Business Model & Presentation Layer), Time Series
Objects, Interactive Dashboards with drill-down capabilities using
global & local Filters, Security Setup (groups, access / query/report
privileges), configured Analytics Metadata objects (Subject Area, Table,
Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports).
. Involved in the configuration of Siebel Analytics/OBIEE Delivers, iBots,
Jobs Manager, Cache Manager, Variable and Security Manager (Object level
security and Data level security).
. Involved in Administration activities like migration of Siebel
Analytics/OBIEE RPD, INFA rep and DAC rep from Dev-Test-Stage to
Production.
. Strong understanding of PL/SQL Procedures, Packages, Functions, Triggers
and other objects
. Experience in Security Setup at both Object and Data levels, which
involved creation of users/groups, LDAP authentication setup and
configuration of Multiuser Development Environment (MUDE).
. Extensive experience in Unit, Regression, Performance, Integration and
User Acceptance testing methodologies.
. Oracle Certified Professional fundamental exam with 100% marks.
. Oracle Certified Associate exam with 97% marks.
. Sun Certified Java Professional for Java 1.4 with 88% marks.
. Worked on Defect management tool (HP-QC) for resolving the development
issues raised by the QA.
Coursework
Business Intelligence, Data warehouse implementation, Data mining, Data
Modeling, Software project management, Reporting, Data management and
information processing, Marketing Strategy, Web development, financial
management for IT professional.
Tools and Technologies
Reporting Tools OBIEE 10.1.3.3,10.1.3.4, Actuate eReporitng Designer
Professional, RPD design 7.0,8.0, R, SAS
Languages PL/SQL, PHP, Perl, core JAVA,C
Database Oracle 10g/9i/8i,Oracle 11g,Teradata 13, MS Access,
SQL server
ETL Tools Informatica 8.0
Business Tools Callidus True Comp 3.x,5.x
Other tools and utilities SQL Developer, SQL*Plus, TOAD
Operating Systems MVS, Windows NT/2000/2003/XP/vista/7/8, UNIX
Project 6
NGCRM - T system (Germany, Slovakia, Mancelona, Check Republic, Hungry)
January 2012 - September 2012
T-Systems is a German global IT services and consulting company
headquartered in Frankfurt. Founded in October 2000, it is a subsidiary of
Deutsche Telekom AG. Aim of the NGCRM project was to implement the new
generation CRM. I was serving as lead of business intelligence module and
was responsible to handle the offshore activities. We had fifteen
environments (development, testing and production) for different countries
including Hungry, Germany, Slovakia, Check Republic and Macedonia.
Roles and Responsibilities
. Gathered and analyzed the Business requirements, Functional requirements
and Design Specifications in order to design and write detail
requirement, design and technical Specifications.
. Involved in developing Test Plans, Test Cases based on Business
Requirement Documents to test the functionality of the Application for
Quality Assurance.
. Interacting with client for appropriate requirement specifications.
. Interact with Business Owners/End-user to create Subject Areas,
Folders/Sub-folders, and Presentation/Business columns.
. Worked on implementation of Data Warehouse, BI solutions and a strong
understanding of Data Warehouse concepts, ETL, OLAP, LDAP, Star Schema,
Data Modeling using Normalization, Business Process Analysis,
Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical
Data Modeling
. Creation/customization of star schemas and Business Metrics in RPD as per
customer requirements.
. Extensively involved in Business Model and Mapping Layer to create
Dimensional hierarchies, level based measures. Identify Fact tables &
Measures. Identify Aggregate tables & their definitions.
. Implemented Object level security to hide Tables and columns according to
the user responsibilities.
. Created and granted privileges for the users using OBIEE Admin/
Presentation Catalog
. Extensively worked on OBIEE Components, BI Publisher, Webcat Manager,
Scorecards, OBI Presentation services (Answers and Dashboards) to create
reports and dashboards.
. Implemented Caching and purging of Cache to increase performance.
. Worked with Order Management Pre-built dashboards like Backlog, Customer
Report and Sales cycle, OBIEE Metadata and Customer dashboards.
. Implemented performance tuning logic on Targets, Sources, mappings,
sessions to provide maximum efficiency and performance.
. Optimization and Troubleshooting of the Reports, Dashboards for better
performance.
. Validation of Data Loaded by ETL Process.
. Worked with DBA's to resolve issues like extending table space or any
other issues with OLAP database which causes ETLs to fail and
troubleshoot them accordingly.
. Involved in Unit testing and System testing of the metrics created in BMM
Layer.
. Worked on Multi User Environment (MUDE) model for check in and checkout
of the repository/project.
. Involved in Administration for OBIEE Server, Cluster Server, Scheduler
Server, Presentation Server and IIS Web Server.
. Installation and configuration of OBIEE Product Suite.
Environment: OBIEE Platform 10.1.3.4 Siebel Analytics 7.8, Ms-SQL Server
2005,R,SSAS, UNIX, Putty, Windows XP Professional, HP Quality Center 9.2,
SQL developer, Cygwin.
Project 5
Actuate OBIEE Reporting - UOB (Singapore)
October 2011 - December 2011
United Overseas Bank (UOB) provides a wide range of financial
services including personal financial services, private banking, commercial
and corporate banking, investment banking, corporate finance, capital
market activities, treasury services, futures broking, asset management,
venture capital management, insurance and stockbroking services. Actuate
OBIEE reporting was a credit card report development project. The aim was
to cater the summary and detail report of the credit card performance in
different region and segment. Those were used by the higher management in
deciding their strategy, policy and management plans including discounts,
offers and target customers. I have been extensively involved in Reporting
Data mart and front end report design and development.
Roles and Responsibilities
. Implementing OBIEE based Dashboards for Sales Agents which gives up-to-
date view of their sales credits, commission, targets at District/
Region/Manager/VP/Corporate levels.
. Implemented complicated sales commission calculation logic which
frequently changes in OBIEE using many OBIEE repository features like
oracle subtotaling
. Implemented Sales agents Hierarchy and login based personalized Dashboard
views which can restrict sales data applicable to only their appropriate
regions
. Migrate existing reporting infrastructure to OBI based executive
dashboard and answers requests
. Assisting in implementing Oracle HR metrics through OBIEE based HR
executive dashboards with special emphasis on data security
. Review the overall OBIEE platform and evaluate/correct the variations
between Prod, Test, Dev, & MUD environments.
. Implementing automatic startup, shutdown, restart & recoverability
scripts for OBIEE prod, dev & test platforms
. Involved in performance tuning of dashboard refresh and end-user report
queries
. Managing efficient cache management for frequently used Dashboards
. Review of Consolidated RPD; we needed to "clean up" redundant connection
pools, obsolete projects, and other undesirable objects.
. Providing assistance for Informatica based ETL for OBIEE Financials
Analytics modules
Environment: OBIEE Platform 10.1.3.4, Informatica Power Center 8,
Teradata, UNIX, Perl Scripting, putty, murphy.
Project 4
KPN BI Innovation - KPN Telecom (Netherlands)
December 2010 - September 2011
KPN is the leading telecommunications and ICT service provider in The
Netherlands, offering wireline and wireless telephony, internet and TV to
consumers, and end-to-end telecommunications and ICT services to business
customers. KPN BI Innovation was a Teradata - CLDM data warehouse
application has been created to facilitate users to have details info of
customers, offerings, billings and revenue. I have developed the 260 degree
customer care application on top of this data warehouse for KPN consumer
channel customers. It was basically a search engine on OBIEE platform to
find detail information of product used by the customer, technical
information and product details. KPN was monitoring the usage tracing
reports of this application lead them to decide the business strategy on
products, area and cost.
Roles and Responsibilities
. Interacted heavily with the users and maintained proper documentation to
ensure the required reports are properly developed.
. Involved in meetings with the Business Partners, Business Users and
gathered the Business Requirements and documented them in a systematic
manner (BRD), also discussed the technical feasibility and the system
requirements for the new developments such as the creation of any new
database tables or about using the existing tables and Schemas etc.
. Developed the new metadata definitions, new Subject areas in the OBIEE
Repository which involved working with the Physical, Business Model and
Mapping and Presentation Layers of the Repository.
. Developed a search engine on OBIEE platform to ease the job of customer
care associate in finding the customer and related info based on search
criteria.
. Configured dimensional hierarchy and implemented them in the appropriate
reports.
. Configured Aggregate tables in order to use them in the applicable
reports.
. Created reports in the OBIEE Answers and configured the results in
different views such as Table view, Pivot table view, Chart view, Funnel
view, Narrative view etc based on the requirement.
. Developed OBIEE Dashboard Prompts, Intelligence Dashboards to accommodate
the reports that are built in Answers.
. Dealt with the performance issues by Tuning the queries for the reports
which are running at significantly higher time periods.
. Participated in weekly scheduled support calls with Business Users
concerning the Production Tickets.
. Tested the reports and worked closely with the UAT testers to figure out
the modifications if any are required and worked out on them to get the
final sign-off from the Business partners.
. Migrated the approved developments (Webcat, .rpd) from the Test
environment to the Production environment using the catalog manager.
Environment: OBIEE Platform 10.1.3.4, Informatica Power Center 7.1,
Teradata, SQL,PL/SQL,TOAD, UNIX, Perl Scripting, perforce, putty,
Project 3
NBIM Reports and Segmentation - Norges Bank Investment Management (Norway)
Duration: July 2010 - November 2010
Customer Trial & Repeat Behavior Analysis:
Designed and deployed real time OBIEE dashboards that identified items
which are most/least liked by the Customers using key performance metrics
that aided retailer towards better customer centric assortments.
Customer Segmentation:
I have developed 11 customer segments using K-means, Gaussian mixture
techniques. The clusters helped retailer understanding life time values &
in designing strategies to boost per household values.
Roles and Responsibilities
. Setup of Dash Boards, Business Areas, Dimensions and Hierarchies,
Generating Input Templates, Creating Actuals Business process and Budget
Business process and Generating Variance Reports.
. Worked on configuration of Dashboards for DBI (Daily Business
Intelligence) Finance, Supply Chain, Procurement and Human Resources
modules. Implemented, Setup of Dimensions, Hierarchies.
. Setup of Business Areas, Setup of Dimensions and Hierarchies.
. Setup of Business Processes, Generating Input Templates.
. Creating Actuals Business process and Budget Business process.
. Pre-Populating Budget worksheet with Actuals Data, Generating Variance
Reports.
. Involved in Gap Analysis Study to recommend a powerful and robust BI
Reporting solution.
. Responsible for gap analysis to determine Business views usage against
Third party Views to suit companies reporting requirements.
Environment: OBIEE Platform 10.1.3.3, 7 Informatica Power Center 7.1,
Oracle 9g, SQL,PL/SQL,TOAD, UNIX, Perl Scripting, perforce, Quality Center.
Project 2
GHH Callidus Incentive Comp - Merck Pharmaceuticals (United States)
Duration: October 2009 - June 2010
Merck & Co., Inc. is a global research-driven pharmaceutical company
dedicated to its patients and giving them their first priority. It is one
of the oldest pharmaceutical and chemical companies in the world. Merck
requires a way to provide Incentive compensation to its Sales forces based
on their performance through the Sales teams. The Sales team data is
integrated into the system from various upstream data sources and is
categorized into Performance data, Sales data, transaction data etc. The
GHH Callidus Incentive Comp was to calculate Sales Incentives of Merck
participants under Sales performance Management and to develop the reports
on actuate/OBIEE platform. The aim was to enable company to reward sales
performers, manage channel partner promotions, maintain the quality staff,
increasing the top line revenue and reduce the bottom line costs. I have
developed the plans and rules for Sales Incentives calculation using True
Comp incentive measurement tool and displayed the results in reports in
Actuate/OBIEE platform. We applied the K means model to find the customer
segment and trends.
Roles and Responsibilities
. Involved in the analysis and functional requirements gathering
process by meeting up with the business users, business analyst.
. Designed, implemented the Metadata, Reports and Dashboards for the
Views and Disclosures, Summary, Details, Ranking and Sales force
subject areas using the OBIEE tool.
. Created the technical design documents and functional documents.
. Developed the repository model for the different work streams with
the necessary logic that involved creating the Physical, BMM and the
Presentation layer. Also created hierarchies, variables, time
comparison analysis and event poll strategies in the repository.
. Maintained the various subject areas by providing technical support
as a part of the global implementation.
. Used fragmentation content and also set the total and detail levels
for use of different tables.
. Used Repository and Session variables.
. Developed on demand, canned Reports and Dashboards for the various
subject areas.
. Used union reports, drilldown, presentation variables and prompts in
the creation of answers and dashboard reports.
. Used BI publisher for the integrated OBIEE analysis by creating the
data models and RTF/eText Templates to build the reports and publish
them in the Dashboard Answers.
. Used different views in OBIEE like view selector, column selector,
table, pivot, chart.
. Involved in creation of various Oracle tables, views, Materialized
views and functions.
. Performed Unit Testing and Functional Testing for the various reports
and dashboards.
. Created training manuals for the users, conducted training and
presentations to the users to help drive user satisfaction.
Environment:
Oracle 10g, SQL* Plus, PL/SQL,OBIEE 10.1.3.3, Actuate erdPro 7. and MS
Office.
Project 1
True Comp Incentive Management - Washington Mutual (United States)
Duration: January 2007 - September 2009
The project was to calculate incentive of participants in Home Loan and
Retail Banking divisions based on their performance. The aim was to help
the company higher management to decide and overview the company and
employee performance based on reports. I was involved in the development of
plan based on the business strategy using True Comp and reports development
on Actuate/OBIEE platform.
Roles and Responsibilities
. Served as a Module lead and handled client site and offshore activities
of reporting module.
. Involved in creation/modification of views, sub partition, creation of
new tables and columns etc.,
. Involved in working on the OBI HR Apps subject areas like Workforce,
Compensations, Learning, Performance and Talent Management.
. RPD design/data modeling, Developing and deploying Dashboard,
Analytics/OLAP Reports.
. Developed packages, procedures using PL/SQL.
. Involvement in analysis for the OBI HR Apps Dashboards and the reports
for the Workforce profile subject area.
. Created dimensional hierarchies levels and new logical columns as per the
business requirements.
. Organized the Presentation layer in a format that is easy for end user to
use as basis for reporting.
. Implemented Security at the data and object levels.
. Utilized Variables and Initialization blocks in the repository.
. Implemented Caching to increase performance.
. Troubleshooting and Performance optimization of the ETL Jobs,Dashboards
and Reports.
o Meeting with the business users and prepared the FRD/BRD documents based
on the user requirements.
Environment: OBIEE Platform 10.1.3.3, Actuate ErdPro 6, 7 Informatica Power
Center 7.1, Oracle 9g, SQL,PL/SQL,TOAD, UNIX, Shell Scripting, perforce,
Quality Center.
Contact this candidate