SENIOR TECH LEAD
INFINITE COMPUTER
Skills
Siebel Analytic7.8.4, OBIEE, Power BI, Informatica 9.1/8.1, ODI 12c, Siebel Analytics, ODI Administration, ODI 12c Tools (OBIEE) 12c/11.1.1.6 g/10.1, RDBMS Oracle 10g/12c/11gR2/10g/9i, SQL, PL/SQL, Microsoft SQL Server, Data warehouse, EDW, DW, Data Modeling, dimensional modeling, VERITAS, ODI, BI Publisher, Oracle, OSC, ERP, 12c, ETL, Oracle Data Integrator, Interfaces, integrator, Oracle Database, DevOps, visualization, Crystal, Informatica, data model, Metadata, database, fact table, presentation layer, OBIA, system-on-chip, Smart TV, Video encoding, Video processing, Analytics, Oracle BI, lineage, Single Sign On, SSO, Informatica 9, Oracle 11g, Informatica 8.1, Oracle 10g, Informatica 8, system design, JDE, Oracle XML, XML, Siebel Analytics 7.8.4/10.1.3.2, Informatica 6.1\\7.1, Siebel, CRM, OLTP, Siebel Analytics 7.8.4, Informatica 7.1, Oracle 9i
Project history
12/2015
-
07/2016
12/2015
-
06/2016
Lead
XEROX
Customer name: Xerox(US)
Tools: ODI, OBIEE ,BI Publisher, Oracle, Tableau
Responsibility: Lead
Project Description:
Xerox helps businesses and governments improve the flow of work to enable greater performance,
agility and transformation. A diversified business services company, we are also leaders in document
management and managed print services. They innovate across a range of sectors such as customer
care, graphic communications, healthcare, transaction processing and transportation
Role Description:
* Interact direct with Client to understand the requirement.
* Currently undertaking the responsibilities as Architect and Lead.
* Design the dimension model for the Xerox
* Converted Crystal reports to OBIEE and BIP.
* We had designed and developed more the 100 reports from OBIEE/BIP as per business requirement
* Handle the Deployment tasks and helped to team.
* Understood the functional requirements (Transportation).
* Data validation for Reports
* Consulting assignments on EDW/BI roadmap, DW/BI Architecture, Data Modeling & Implementation.
* Gathering requirements from users/business to develop interfaces, packages, Load plans.
* Used Yellow Interfaces Reusable mappings in ODI for developing most complex interfaces.
* Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
* Created new reports and dashboards as per the business need.
* Analysis, Design, Implementation, documentations and BI specifications that incorporate OBIEE
development standards best practices as well as ongoing support for Data Warehouse.
* Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE
Administration tool.
* Study business applications to understand the requirements implemented based on the inputs
given by the client and also through self-analysis
* Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary
Tools: ODI, OBIEE ,BI Publisher, Oracle, Tableau
Responsibility: Lead
Project Description:
Xerox helps businesses and governments improve the flow of work to enable greater performance,
agility and transformation. A diversified business services company, we are also leaders in document
management and managed print services. They innovate across a range of sectors such as customer
care, graphic communications, healthcare, transaction processing and transportation
Role Description:
* Interact direct with Client to understand the requirement.
* Currently undertaking the responsibilities as Architect and Lead.
* Design the dimension model for the Xerox
* Converted Crystal reports to OBIEE and BIP.
* We had designed and developed more the 100 reports from OBIEE/BIP as per business requirement
* Handle the Deployment tasks and helped to team.
* Understood the functional requirements (Transportation).
* Data validation for Reports
* Consulting assignments on EDW/BI roadmap, DW/BI Architecture, Data Modeling & Implementation.
* Gathering requirements from users/business to develop interfaces, packages, Load plans.
* Used Yellow Interfaces Reusable mappings in ODI for developing most complex interfaces.
* Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
* Created new reports and dashboards as per the business need.
* Analysis, Design, Implementation, documentations and BI specifications that incorporate OBIEE
development standards best practices as well as ongoing support for Data Warehouse.
* Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE
Administration tool.
* Study business applications to understand the requirements implemented based on the inputs
given by the client and also through self-analysis
* Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary
05/2014
-
10/2015
Lead
BI WHOLESALE
Customer name: BT WHOLESALE(UK)
Tools: Informatica , ODI , OBIEE ,BI Publisher, Oracle , Tableau
Responsibility: Lead
Project Description:
BT is one of the world's leading providers of communications and technology services and one of the
largest private sector companies in Europe. BT Wholesale is at the heart of the BT Group, providing
network services and solutions to communication companies
Role Description:
* Interact direct with Client to understand the requirement.
* Currently undertaking the responsibilities as Architect and Lead.
* Design the data model for the Wholesale
* Responsible for Business meetings, conversion of business rules into technical design document
* Handle the Deployment tasks
* Designed and developed several OBIEE Metadata Repository (.rpd) by importing database tables
into physical layers, forming dimensional and fact table schemas in BMM layer and customizing
table and column definitions in presentation layer
* .Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
* Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming,
integrating, and loading data into data warehouse database
* Understand the functional requirements (Telecom).
* Data validation
* Consulting assignments on EDW/BI roadmap, DW/BI Architecture, Data Modeling & Implementation.
Tools: Informatica , ODI , OBIEE ,BI Publisher, Oracle , Tableau
Responsibility: Lead
Project Description:
BT is one of the world's leading providers of communications and technology services and one of the
largest private sector companies in Europe. BT Wholesale is at the heart of the BT Group, providing
network services and solutions to communication companies
Role Description:
* Interact direct with Client to understand the requirement.
* Currently undertaking the responsibilities as Architect and Lead.
* Design the data model for the Wholesale
* Responsible for Business meetings, conversion of business rules into technical design document
* Handle the Deployment tasks
* Designed and developed several OBIEE Metadata Repository (.rpd) by importing database tables
into physical layers, forming dimensional and fact table schemas in BMM layer and customizing
table and column definitions in presentation layer
* .Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
* Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming,
integrating, and loading data into data warehouse database
* Understand the functional requirements (Telecom).
* Data validation
* Consulting assignments on EDW/BI roadmap, DW/BI Architecture, Data Modeling & Implementation.
12/2013
-
10/2015
TECH SPECIALIST
TECH MAHINDRA
06/2012
-
12/2013
SENIOR PRINCIPAL CONSULTANT
IT CONVERGENCE
09/2010
-
06/2012
OBIEE ARCHITECT/LEAD
FUJITSU
03/2011
-
05/2012
OBIA Architect/ Lead
Customer name: IFFCO (UAE)
Project Description:
IFFCO is a United Arab Emirates based business house, which manufactures and markets a well
integrated range of mass-market consumer products. Business segments are: Food and Beverage,
Personal Care and Cleaning, Packaging & Industrial Products and Logistics.
Tools: Informatica 9.01, OBIA/OBIEE 11.1.1 g, DAC,BI Publisher, Oracle 11g
Responsibility: OBIA Architect/ Lead
Role Description:
* Understand the functional requirements ( HRMS, SCM, Procurement and FINANCE).
* Data validation
* Currently undertaking the responsibilities as Architect and Lead.
* Setup Multi User Development Environment (MUDE) in OBIEE.
* Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot
Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation
Services.
* Study business applications to understand the requirements implemented based on the inputs
given by the client and also through self analysis
* Design and deliver end-user training and training materials; provide technical support as
necessary
* Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary
Project Description:
IFFCO is a United Arab Emirates based business house, which manufactures and markets a well
integrated range of mass-market consumer products. Business segments are: Food and Beverage,
Personal Care and Cleaning, Packaging & Industrial Products and Logistics.
Tools: Informatica 9.01, OBIA/OBIEE 11.1.1 g, DAC,BI Publisher, Oracle 11g
Responsibility: OBIA Architect/ Lead
Role Description:
* Understand the functional requirements ( HRMS, SCM, Procurement and FINANCE).
* Data validation
* Currently undertaking the responsibilities as Architect and Lead.
* Setup Multi User Development Environment (MUDE) in OBIEE.
* Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot
Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation
Services.
* Study business applications to understand the requirements implemented based on the inputs
given by the client and also through self analysis
* Design and deliver end-user training and training materials; provide technical support as
necessary
* Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary
08/2008
-
06/2010
TEAM LEAD
SYSTIME
01/2010
-
05/2010
OBIEE Lead
Dulsco (UAE)
Customer name: Dulsco (UAE)
Project Description:
* Dulsco strategy is to concentrate on its core business of providing HR Solutions and Waste
Management
* Dulsco wanted to take its success further by arming itself with the best technology available,
and chose data warehousing
Tools: Informatica 8.1, OBIEE 10.1.3.4 g, Oracle 10g
Responsibility: OBIEE Lead
Role Description:
* Developing new capabilities which help deliver better and improve companies market potential
and built competencies so that the organization can market them to get more business and
increase presence across the global
* Involved in pre sale activity. Demo and POC
* Conduct Telecom with Client to understand the requirement, Study business applications to
understand
* The requirements implemented based on the inputs given by the client and also through self
analysis
* Design and data modeling (Logical and Physical), Installation/configuration of OBIEE and
Informatica
* Providing training of OBIEE and Informatica
Project Description:
* Dulsco strategy is to concentrate on its core business of providing HR Solutions and Waste
Management
* Dulsco wanted to take its success further by arming itself with the best technology available,
and chose data warehousing
Tools: Informatica 8.1, OBIEE 10.1.3.4 g, Oracle 10g
Responsibility: OBIEE Lead
Role Description:
* Developing new capabilities which help deliver better and improve companies market potential
and built competencies so that the organization can market them to get more business and
increase presence across the global
* Involved in pre sale activity. Demo and POC
* Conduct Telecom with Client to understand the requirement, Study business applications to
understand
* The requirements implemented based on the inputs given by the client and also through self
analysis
* Design and data modeling (Logical and Physical), Installation/configuration of OBIEE and
Informatica
* Providing training of OBIEE and Informatica
05/2006
-
06/2008
TECHNICAL ASSOIATE
TECH MAHINDRA
05/2006
-
06/2007
Siebel Analytics Developer
British Telecom (BT)
Customer name: British Telecom (BT) U.K.
Project Description:
The BT is using Siebel CRM data warehouse our primary roll is to extract and load the data from
Siebel E-business OLTP system to Siebel CRM Data Warehouse. The main achievement of this project is
to determine if the business is on track, identify where the things are going wrong, take and
monitor corrective action and Spot trends.
Tools: Siebel Analytics 7.8.4, Informatica 7.1, Oracle 9i.
Responsibility: Siebel Analytics Developer
Role Description:
* Developing Reusable Transformations, Aggregations and created Target Mappings that contain
business rules.
* Optimizing/Tuning mappings for better performance and efficiency.
* Developed mappings using Informatica for data loading. Developed mapping to load the data in
staging area tables.
* Worked in various types of transformation like Lookup, Update Strategy, Stored Procedure,
Joiner, Filter, Aggregation, Rank, Router and etc of Informatica.
* Participated in system design and data modeling( Logical and Physical)
* Generated Siebel Analytics reports using Siebel Answers, dashboards, filters and Prompts.
Project Description:
The BT is using Siebel CRM data warehouse our primary roll is to extract and load the data from
Siebel E-business OLTP system to Siebel CRM Data Warehouse. The main achievement of this project is
to determine if the business is on track, identify where the things are going wrong, take and
monitor corrective action and Spot trends.
Tools: Siebel Analytics 7.8.4, Informatica 7.1, Oracle 9i.
Responsibility: Siebel Analytics Developer
Role Description:
* Developing Reusable Transformations, Aggregations and created Target Mappings that contain
business rules.
* Optimizing/Tuning mappings for better performance and efficiency.
* Developed mappings using Informatica for data loading. Developed mapping to load the data in
staging area tables.
* Worked in various types of transformation like Lookup, Update Strategy, Stored Procedure,
Joiner, Filter, Aggregation, Rank, Router and etc of Informatica.
* Participated in system design and data modeling( Logical and Physical)
* Generated Siebel Analytics reports using Siebel Answers, dashboards, filters and Prompts.
Local Availability
Only available in these countries:
India
