Sales Customer Service
Resume:
[pic][pic]
ABHIJIT CHAKRABORTY
Email: ********************@**********.***
Phone: +1-408-***-****
Experience Summary
V Around 8 years of experience in Complete Software Development Life
Cycle (SDLC) implementation of various Business Intelligence and Data
Warehouse / Data Marts that covers gathering Business Requirements,
GAP Analysis, Design / Modeling (Star and Snow flake), Development,
Testing, Implementations and Documentation.
V Proficient at interviewing stakeholders from CXO level executives to
end users, and in translating users' statements of needed system
behavior and functionality into Business and Functional Requirements.
V Business Analysis experience with excellent communication &
interpersonal skills, broad understanding of business operations and
requirements.
V Organized meetings with Business users and Management to analyze the
KPI's, reporting data levels and gaps. Created a project plan with
task categorization high, medium and low gaps with timelines
V Extensive Business Intelligence experience using OBIEE 10g, OBIEE 11g,
Siebel Analytics 7.x and Informatica 8.x/7.x/6.x.
V Very strong experience in developing OBIEE / Siebel Analytics
Repository (.rpd) at three layers (Physical Layer, Business Model &
Presentation Layer), Interactive Dashboards with drill-down
capabilities using page and dashboard prompts, Security Setup (groups,
object and data level), configured Analytics Metadata objects
(Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages,
Folders, Reports) and scheduling iBots.
V Expertise in debugging, optimizing the Performance Tuning of Oracle BI
/ Siebel Analytics Repository & Dashboards / Reports and Informatica
/ Mappings / Workflows.
V Experience in setting up a Multi-User Development Environment (MUDE).
V Implemented Usage tracking to analyze and tune the query performance.
V Expertise in creating Calculation Measures and Dimensions, using
Initialization Blocks and Variables (Session and Repository), creating
aggregate tables, adding multiple sources, executing direct Database
requests, Implementing Siebel Security Setup (groups, object and data
level), LDAP, External Tables, Single sign on (SSO) etc.
V Good in validating the BI reports/dashboards by preparing the Test
Plans & Cases.
V Multi-platform experience on UNIX / Linux and Windows Server family.
V Excellent communication skills and experience working with business
users and leads/managers.
V Strong analytical & problem solving skills and a quick learner of new
technologies and concepts.
V Well experience in onshore-offhsore model of working along with Agile
and Scrum.
OBIEE experience summary
. OBIEE Data modelling - Designed& Build DW tables on Star & snowflake
schemas.
. OBIEE Data Extraction/Transformation/Load-Designed ETL(Informatica)
process & SQL's to populate data from different source to data warehouse
and Informatica Administration.
. OBIEE Reporting - Designed & developed reports in OBIEE, Developed joins
on RPD to facilitate star/snowflake functionalities.
. OBIEE Security - Designed & developed Active Directory for OBIEE11g.
. OBIEE Administration - Administration of Managed server, WebLogic & BI
Servers.
. BI Publisher Reporting - Designed & developed reports in BI Publisher.
PROFESSIONAL EXPERIENCE:
Cisco Systems Inc, San Jose, CA
Dec '11 - Till date
IT Analyst
Cisco Systems, Inc. is an American multinational corporation headquartered
in San Jose, California, that designs, manufactures, and sells networking
equipment. The stock was added to the Dow Jones Industrial Average on June
8, 2009, and is also included in the S&P 500 Index, the Russell
1000 Index, NASDAQ-100 Index and the Russell 1000 Growth Stock Index.
To architect and develop BIDs, it is a complete one touch BI solution for
CISCO internal management decision making system. Based on this management
decides employee promotions to business outsourcing requirement and also
fiscal year profits margins and new business initiatives for betterment of
company and its people
Responsibilities:
V Actively involved in requirement gathering& analysis, documentation,
preparing mockups.
V Attend timely meetings with Business & ETL team to understand the
functionality and design of the BI model accordingly.
V Designed and developed the OBIEE Metadata Repository (.RPD) using
OBIEE Admin tool by importing the required objects (Dimensions and
Facts) with integrity constraints into Physical Layer using connection
pool, developing multiple Dimensions (Drill-Down, Hierarchies) and
Logical Facts / Measures objects in Business Model Layer, and creating
the Presentation catalogs in Presentation Layer.
V Created Security settings to setup groups, access privileges, query
privileges and Implemented Object level as well as Date level security
for the end users using OBIEE Admin tool.
V Worked extensively on OBIEE Answers to create the Financial Statement
reports and Intelligence Dashboards (Financials) as per the detailed
design requirements for projects ITMetrics,EConsulting, CDAS
Systems,NOSTG.
V Worked in developing projects which are based on Customer Satisfaction
Survey to improve the Customer Service to improve the quality of
business like GROMIT,EODB(Ease of doing business)
V Worked on Multi-User Environment (MUDE) by merging and importing
multiple projects throughout the development phase in BICAFE related
projects.
V Extensively used page prompts and dashboard prompts for filtering data
values in financial reports.
V Created drill down charts and drill down reports to gather more
information on Financial service values using navigation.
V Developed ad-hoc reports for performance and Measurement analysis.
V Have been part of the support team post production to fix issues,
analyse the cases raised and resolved at the earliest time.
V Have performed detailed analyses of the cases raised related to slow
reports, download related issues or adhoc reports support etc and
assigned tasks accordingly to the offshore when required.
V Have a strong understanding of the data functionality and business
process to understand the needs of the client better.
V Worked on both 10g & 11g projects depending on the projects. Certain
projects continue to work on 10g based on the budget limitations.
V Worked on various pictorial views introduced in the upgraded version
of 11g for EODB project.
V Used Kintana Package for Deployment in Unix box.
Environment: OBIEE 11.3,11.5 & 11.7,Teradata, Windows Server & UNIX
Cisco Systems Inc, San Jose, CA
Mar '11 - Dec '11
Business Analyst &Developer
Cisco Systems, Inc. is an American multinational corporation headquartered
in San Jose, California, that designs, manufactures, and sells networking
equipment. The stock was added to the Dow Jones Industrial Average on June
8, 2009, and is also included in the S&P 500 Index, the Russell
1000 Index, NASDAQ-100 Index and the Russell 1000 Growth Stock Index.
To architect and develop BIDs, it is a complete one touch BI solution for
CISCO internal management decision making system. Based on this management
decides employee promotions to business outsourcing requirement and also
fiscal year profits margins and new business initiatives for betterment of
company and its people
Responsibilities:
. Involved in requirements gathering, analysis, and functional
specification documents.
. Performed Business System Requirement Analysis, Conduct sessions with
Stake holders to identify and analyze technology needs and problems.
. Analyzed the Business Requirements for Business Strategic Management,
Cisco-Product management, Metadata Project, Cisco manager
Innovation(CMI), Piple Line Dashboards, TPB project.
. Designed and developed OBIEE/Metadata Repository (.rpd) using OBIEE
Admin tool by importing the required objects (Dimensions and Facts)
with integrity constraints into Physical Layer using connection pool,
developed Calculated Measures, dimension hierarchies, Aggregate
Tables & Logical & Facts/Measures objects in Business Model Layer, and
creating the presentation catalogs in Presentation Layer.
. Developed Star & SnowFlake Models in RPD.
. Developed Opaque Views in RPD based on the requirement.
. Customized the existing Analytics Metadata Repository (.rpd) using
OBIEE Admin tool by adding new measures into BMM layer.
. Worked on various Projects like AUM, METADATA, SBS, IMI, Client
Experience at Client Site.
. Worked on both OBIEE 10 G & 11g. Was allowed to be part of the
upgrading process.
. Designed and developed Web catalog, Reports/Dashboards with different
Analytics using Oracle Business Intelligence Presentation Services.
. Extensively worked in Dashboard Prompts, Page Prompts, Narratives,
Pivot Views,Charts,KPI Filters, Grids, Presentation variables and
Server Variables in the RPD and Dashboards.
. Extensively worked on reports using Guided Navigation.
. Have extensively worked on Drill- Down reports.
. Developed dashboards and reports that were used by the business to
identify most profitable customers and analyze Revenue trends to
identify opportunity / risk.
. Have done Regression Testing along with the Testing team to inhibit
Post Production Issues.
. Was part of the team involved in Migration from DEV-SIT-UAT-PROD.
Environment: OBIEE 11.1.1.5, 11.1.1.6, Neotix, Teradata, Windows XP, Unix
British Telecom Plc, London, England, United Kingdom Apr '10 - Mar
'11
Sr.BI Analyst
BT Group plc, trading as BT, is a British multinational telecommunications
services company with head offices in London, England, United Kingdom. It
has operations in around 170 countries. Through its BT Global Services
division it is a supplier of telecoms services to corporate and government
customers worldwide. Its BT Retail division is a supplier of telephony,
broadband and subscription television services in GB, with circa 18 million
customers.
BT's origins date back to the founding of the Electric Telegraph Company in
1846 which developed a nationwide communications network. In 1912, the
General Post Office, a government department, became the monopoly telecoms
supplier in GB. The Post Office Act of 1969 led to the GPO becoming a
public corporation. British Telecom was formed in 1980, and became
independent of the Post Office in 1981. British Telecom was privatised in
1984, with some 50 per cent of its shares sold to investors. The Government
sold its remaining stake in further share sales in 1991 and 1993.
BT has a primary listing on the London Stock Exchange and is a constituent
of the FTSE 100 Index
To develop and enhance IVIEW, it is a MIS application that is used for
revenue calculation for BT shared LOBs and lead LOBs like Global services,
Retail, Wholesale and PAN. This had a customer base of 1 lac 55 thousands
across every corner of the world. This portal is particularly important for
BT as it provided the output for the BT performance in every quarter and
year end.
Responsibilities:
V Involved in the whole life cycle of the project which includes
requirement gathering, design, development, testing and release and
production support.
V Performed Business System Requirement Analysis, Conduct sessions with
Stake holders to identify and analyze technology needs and problems.
V Gathered and documented User requirements, Data Dictionary Gap
Analysis.
V Participated in the walkthroughs of the data models, ETL
specifications, identification of dimensional attributes, Facts and
Star Schema to fulfil requirements.
V Provide feasible solution to overcome the issues.
V Prepared Functional Design and Technical Design Documents for BI
reports and Interactive Dashboard in BI platform
V As part of the Remote Access Consolidation work stream, identifying
project level benefits, scope and risks and developing Project Charter
by working with the Project Manager and subject matter experts,
including End user computing, Server and Hosting Architecture team.
V Leading the requirement management effort. Working with the subject
matter experts to analyze and document 'as is' and 'to be'
environments. Working with the subject matter experts to develop
detailed requirements (business, functional and non-functional).
V Worked for the Business Intelligence Data Warehouse (BIDW), and also
and worked with the technical lead and subject matter experts to
identify and analyze data structures needing modifications. Worked
with subject matter experts (ex: actuaries) to identify and analyze
problem areas and adjusted or developed new calculations for various
premium and coverage related data.
V Identified changes needed in BIDW and its interfaces to accommodate
modifications
V Designed and Built Oracle BIEE Repository at 3 layers i.e., Physical
Layer (connecting Data sources & import schema), Business Model / data
mapping (create Logical tables & data source mapping) and Presentation
Layer level (create presentation catalogs), create presentation
folders, test and validate the model.
V Created an Order Entry (OE, for Oracle Business Intelligence) OLTP
model to be used by the Direct Sales Team during proof of concept
demos
V Created connection pools, physical tables, defined joins in the
physical layer of the repository.
V Worked on Answers to build Interactive Dashboards with drill-down
capabilities.
V Developed different kinds of Reports (pivots, charts, tabular views)
using global and local Filters.
V Extensively used presentation variables and guided navigation.
V Customized Dashboards, administered permissions and privileges for
Dashboard visibility and modifications to users.
V Worked closely with the team in upgrading to new version OBIEE11g on
all the environmental servers.
V Extensively worked in Dashboard Prompts, Page Prompts, Narratives,
presentation variables and Server Variables in the RPD and Dashboards.
V Developed dashboards and reports that were used by the business to
identify most profitable customers and analyze Revenue trends to
identify opportunity / risk.
V Extensively worked in Dashboard Prompts, Page Prompts, Narratives,
presentation variables and Server Variables in the RPD and Dashboards.
V Configured iBots to deliver Analytics content based on schedule,
automated iBot queries to obtain daily and weekly reports.
V Enhance Performance Tuning of Dashboards / Reports by aggregate
Navigation, Cache management, Oracle materialized views and making
changes to reports.
V Performed Upgrade Assistant on repository and web catalog from OBIEE
10g to OBIEE 11g.
V Resolved the LDAP Authentication Issue.
V Created user and groups using Web logic Administration Console.
V Created Roles and policies using Web logic Enterprise Manager.
Environment: Oracle 9i, OBIEE 10.1.3.X, 11.1.3.X, Windows Server 2008
Informatica, MS Excel, MS Visio, ASP, IIS, MS Share, Windows 2000 Server,
Oracle Application Server 10g,J2SE 1.5, Toad, Clarify CRM, Star Team.
British Telecom Plc, London, England, United Kingdom May '09 - Apr
'10
Sr.OBIEE Developer / Business Analyst
BT Group plc, trading as BT, is a British multinational telecommunications
services company with head offices in London, England, United Kingdom. It
has operations in around 170 countries. Through its BT Global Services
division it is a supplier of telecoms services to corporate and government
customers worldwide. Its BT Retail division is a supplier of telephony,
broadband and subscription television services in GB, with circa 18 million
customers.
BT's origins date back to the founding of the Electric Telegraph Company in
1846 which developed a nationwide communications network. In 1912, the
General Post Office, a government department, became the monopoly telecoms
supplier in GB. The Post Office Act of 1969 led to the GPO becoming a
public corporation. British Telecom was formed in 1980, and became
independent of the Post Office in 1981. British Telecom was privatised in
1984, with some 50 per cent of its shares sold to investors. The Government
sold its remaining stake in further share sales in 1991 and 1993.
BT has a primary listing on the London Stock Exchange and is a constituent
of the FTSE 100 Index
To enhance BTOP SPA, which is a platform for BT Operate line of business
where a portal is maintained to provide statistical analysis of the cost
incurred in maintenance of the BT Line of business through Europe in terms
of customer services provided by BT. This portal was used particularly by
the BT managers for budgeting purpose and providing strategic solutions to
the line of business.
Responsibilities:
V Worked closely with Business Users in understanding the requirements
and created the business model for generating reports as per the user
requirements.
V Modeling activities which included building star schema as per the
business requirements and configuration of Logical Layer, Logical
tables, dimensions and columns.
V Developed an semantic layer (Physical layer, Business model and
mapping layer, Presentation layer): Repository (rpd) for building
sample reports using OBIEE
V Created proof of concept sample reports with drill down/up, request
navigation, column selector, global filter... capabilities using OBIEE
V Created a proof of concept dashboard using OBIEE
V Used the Catalog manager and maintained the web catalog to manage
Dashboards, Answers.
V Created Repository Groups and Web Groups and assigned users to
configure security in the OBIEE.
V Analyzed and validated the business model in Administration Tool by
performing consistency check, validating logical source tables,
logical columns, and also validating repository level calculations
done in the business model layer.
V Used Calculation Wizard and Expression Builder to perform logical
operations in BMM layer.
V Interacted with Business Users for gathering the Reports / Dashboards
requirements and to define business and functional specifications.
V Developed many Reports / Dashboards with different Analytics Views
(Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular
with global and local Filters) using OBIEE Presentation server.
V Managed security privileges for each subject area and dashboards
according to user requirements.
V Configured OBIEE Repository like implementation of physical data model
as per requirements, importing the tables and having the physical
joins/keys required and changed the physical joins/key on the existing
tables.
V Worked on Multi-User Environment (MUDE) by merging and importing
multiple projects throughout the development phase.
V Created initialization blocks and variables for usage in reports.
V Created iBots to schedule Cache Seeding
V Developed many reports using different views (Pivot table, chart, view
and column selector).
V Worked on setting up column level security for the OBIEE Reports and
also handled the security and privileges from the Database to the
Oracle repository.
V Performed migrations (rpd and webcat) from Development to QA and QA to
Production environments.
V Worked closely with the Business Users, corresponding track developers
and Administrators to resolve on going production issues.
Environment: Oracle 9i,OBIEE 10.1.3.3.1,Ab Initio, MS Excel, MS Visio, ASP,
IIS, MS Share, Windows 2000 Server, Oracle Application Server 10g,J2SE 1.5,
Toad, Clarify CRM, Star Team.
British Telecom Plc, London, England, United Kingdom Mar '07 - May
'09
Database Analyst/BI Consultant
BT Group plc, trading as BT, is a British multinational telecommunications
services company with head offices in London, England, United Kingdom. It
has operations in around 170 countries. Through its BT Global Services
division it is a supplier of telecoms services to corporate and government
customers worldwide. Its BT Retail division is a supplier of telephony,
broadband and subscription television services in GB, with circa 18 million
customers.
BT's origins date back to the founding of the Electric Telegraph Company in
1846 which developed a nationwide communications network. In 1912, the
General Post Office, a government department, became the monopoly telecoms
supplier in GB. The Post Office Act of 1969 led to the GPO becoming a
public corporation. British Telecom was formed in 1980, and became
independent of the Post Office in 1981. British Telecom was privatised in
1984, with some 50 per cent of its shares sold to investors. The Government
sold its remaining stake in further share sales in 1991 and 1993.
BT has a primary listing on the London Stock Exchange and is a constituent
of the FTSE 100 Index
To create a BIP portal, it is a platform for BT wholesale line of business
where a portal is maintained to provide information about the planned
engineering work, order cancellation, customer billing related information,
exchange migration to the BT customers and employees.
Responsibilities:
. Worked closely with the business users to identify various KPI's and
designed solutions to enhance business decision-making.
. Participated in documenting Business Requirements Documents and
Functional Specifications.
. Performed the detailed design of Reports / Dashboards using OBIEE
Answers and Webcat, Analytical Data Model (Metadata / .rpd) and
performed Fit / Gap Analysis between existing OTB Sales, OTB Call
center reports, OTB Medical Events and OTB Syndicated data.
. Analyzed the Business Requirements for Time of Territory, Call contact
Activity, Syndicated data, Insurance Formulary, Decision Issues,
Medical Event and Medical Education.
. Identified data sources and worked on corresponding mappings and
logical joins.
. Configured tables, columns between business and presentation layers.
. Automated iBot queries, obtained weekly reports and sent alerts to
related managers and secured team members
. Implemented Security by creating roles and web groups, checks with
External tables and LDAP.
. Involved in creating the highly formatted parameterized BI Publisher
Reports that use LOV's and various data sources such as BI Answers,
Subject Areas and Web Services.
. Worked with Disconnected Analytics used by mobile web clients, ran the
Synchronization process in Disconnected and SQL Anywhere.
. Performed upgrades from Siebel Analytics to OBIEE 10g.
. Modified / Customized OTB mappings for Activity contact, Call Contact
and Syndicated Data.
. Created new mapping for Extension and Bridge tables for OTB Call
contact and syndicated data.
. Involved in gathering Marketing and Sales Team business requirements.
. Designed and developed the CIA Siebel Analytics Metadata Repository
(.rpd) using Siebel Analytics Admin tool by importing the required
objects (Dimensions and Facts) with integrity constraints using
connection pool into Physical Layer, developed multiple Dimensions
(Drill-Down Hierarchies) & Logical Facts / Measures in Business Model
Layer, and created the Presentation catalogs in Presentation Layer.
. Developed Reports / Dashboards with different Analytics Views (Drill-
Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with
global and local Filters) for performing the customer insights /
trends using Siebel Analytics Web.
. Implemented security by creating roles & web groups, checks with
External tables.
. Performed query optimizations / tuning in physical layer as well on
database.
. Developed Informatica Mappings using various transformations for ETL
enhancements of Items, Components Cost and Vendors information.
. Implemented the session partitions (Database and Informatica) for
performance issues.
Environment: Oracle 9i,OBIEE 10.1.3.3.1,Ab Initio, MS Excel, MS Visio,
ASP, IIS, MS Share, Windows 2000 Server, Oracle Application Server
10g,J2SE 1.5, Toad, Clarify CRM, Star Team
Ac Nielson, City of New York
Jul '07 - Mar '08
Data warehouse Consultant
The Nielsen Corporation, also known as ACNielsen or AC Nielsen is a
global marketing research firm, with worldwide headquarters in New York
City. It gives marketers reliable and objective information on the impact
of marketing and sales programs. I was involved in creation CSAT
dashboard.
Responsibilities:
. Involved in Full project life cycle implementation for MA System.
. Developed the Siebel Analytical Repository using the MA physical
dimensions & facts in physical layer, Logical Facts, Dimensions & Time
Series objects in BMM Layer and preparation of catalogs in
Presentation layers.
. Implemented the Data Access Security using external tables.
. Developed many Reports / Dashboards with different Analytics Views
(Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular
with global and local Filters) for performing the Marketing Trends
analysis using Siebel Analytics Web.
. Developed Informatica mappings with re-usable transformations and
mapplets using various Transformations (Update Strategy, Filter,
Router, Expression, Lookup, and Aggregator) for implementing MA
System.
. Extensively involved in performance tuning of the Informatica Mappings
/ Sessions by increasing the caching size, overriding the existing
SQL.
. Developed PL / SQL scripts for pre & post session processes to
automate daily loads.
Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.x, Oracle 9i,
PL/SQL, Toad.
Education:
. Bachelors in Engineering in Electrical Engineering from West Bengal
University of Technology, India.
[pic]
Contact this candidate