Consultant
E&Y LLP
Total years of experience :5 years, 8 Months
Project: Data Migration and OBIEE Security
Customer: Rogers Communication, Canada
Period: Since May ‘16
Description: Working on ODI and OBIEE part of integrate data from Oracle EBS side to Oracle Data Warehouse End Here both source and target involved are Oracle Database tables. The primary task here is to pull incremental data from EBS end and integrate it on the Warehouse side. This data is then pulled up on OBIEE front for reporting purpose and with active directory single sign in security
Role:
• Formulating the technical design based on understanding of client requirements
• Understanding the business logic for transformation
• Developing variables, procedures, interfaces, packages and scenarios as per the requirement
• Performing some small-scale customization of knowledge modules
• Working extensively with PLSQL and active directory single sign in security implementation
• Conducting unit testing of the developed components
• Moving code from one environment to the other
• Conducting knowledge sharing sessions for the team
• Implementing nearly 400 hierarchical group user security and 100 single user security
Solution Environment: Windows 7, Linux
Tools & Software: ODI 12c (12.1.2.0), OBIEE 12c, SQL Developer, VDI, Microsoft Active Directory
Project: TRA DWH
Customer: Tanzania Revenue Authority
Period: Aug 2015 - Apr 2016
Description: Worked on ODI Tool to extract data from various systems like Flat File system, Excels file and EBS on the source side and load the data into similar structural Oracle RDBMS table. Source data is received in the form of delimited files or xml files or EBS table. From there data is loaded into staging schema. After that the data are loaded into new build TRA Dimensional Data model. Here implemented nearest real time ETL by using Oracle GG.
Role:
• Created Dimensional Logical Data Model by using OSDM
• Generated Physical Data Model from LDM
• Formulated the technical design based on understanding of client requirements
• Interacted with the clients
• Understood the business logic for transformation
• Developed variables, procedures, interfaces, packages and scenarios as per the requirement
• Performed some small-scale customization of knowledge modules
• Worked extensively with PLSQL
• Conducted unit testing of the developed components
• Moved code from one environment to the other
• Prepared test case documents and run books
• Organised knowledge sharing sessions for the team
Solution Environment: PL/SQL, Oracle 11g, XML, Windows 7, UNIX
Tools & Software: ODI 12Cg, Microsoft Word, Microsoft Excel, WinSCP, Oracle Golden Gate
Project: ORDM (Oracle Retail Data Model) - NBTY (USA)
Customer: NBTY (USA)
Period: Jan 2015 - Jul 2015
Technical Environment:
Database - Oracle (11g), ODI 11.1.17.0, Oracle Business Inelegancy (11.1.1.7), Windows XP Linux, Oracle Exadata Box
Project: OCDM (Oracle Communication Data Model) - CWP Panama
Customer: CWP Panama
Period: Jan 2015 - Jul 2015
Database - Oracle (11g), ODI 11.1.17.0, Oracle Business Inelegancy (11.1.1.7), Windows XP Linux, Oracle Exadata Box
Project: ZAIN-OCDM Implementation (ZAIN-Riyadh)
Customer: ZAIN Riyadh
Period: Dec 2013 - Dec 2014
Description:
Oracle Communications Data Model is to load the data from ZAIN (ZAIN-RIYADH) system into OCDM in both initial and incremental manner. The data from ZAIN will then be further driven to feed OCDM derived, aggregates reports and mining models. So it will a perform real time data transfer from client Database to OCDM (Oracle Communication Data Model).In this process we are Using Shell script (source to stage) and ODI (ELT tool), PL/SQL to transfer real time data to the Data Warehouse tables So, that client can see ETL process flow, Real time Reports on OBIEE, OLAP and take their decisions accurately and quickly.
Technical Environment:
Database - Oracle (11g) SQL Developer, Toad 10.6. Oracle Data Integrator (ODI 11.1.1.7), Oracle Business Inelegancy (11.1.1.7) Windows XP and Linux
Project: ROBI -OCDM Implementation (Bangladesh Axiata Group)
Customer: ROBI-Bangladesh
Period: Jan 2013 - Nov 2013
Description
Oracle Communications Data Model is to load the data from ROBI system into OCDM in both initial and incremental manner. The data from ROBI will then be further driven to feed OCDM derived, aggregates reports and mining models. So it will a perform real time data transfer from client Database to OCDM (Oracle Communication Data Model).In this process we are Using Shell script (source to stage) and ODI (ELT tool), PL/SQL to transfer real time data to the Data Warehouse tables So, that Client can see ETL process flow, Real time Reports on OBIEE, OLAP and take their decisions accurately and quickly. Data Mining can also be done on Real time using the data warehouse tables.
Technical Environment:
Database - Oracle (11g) SQL Developer, Toad 10.6. Oracle Data Integrator (ODI 11.1.1.7), Oracle Business Inelegancy (11.1.1.7) Windows XP and Linux
Project: Grameen Phone (Bangladesh Telenor Group)
Customer: GP-Bangladesh
Period: Mar 2012 - Dec 2012
Technical Environment:
Database - Oracle (11g) SQL Developer, Toad 10.6. Oracle Data Integrator (ODI 11.1.1.7), Oracle Business Inelegancy (11.1.1.7) Windows XP and Linux
Project: Comcast (Report)
Customer: Comcast (USA)
Period: Jul 2011 - Dec 2012
Description:
Comcast Corporation (NASDAQ: CMCSA, CMCSK) (www.comcast.com) is one of the world’s leading media, entertainment and communications companies. Comcast is principally involved in the operation of cable systems through Comcast Cable and in the development, production and distribution of entertainment, news, sports and other content for Global audiences through NBCUniversal. Comcast Cable is one of the nation’s largest video, high-speed Internet and phone providers to residential and business customers. Comcast is the majority owner and manager of NBCUniversal, which owns and operates entertainment and news cable networks, the NBC and Tele undo broadcast networks, local television station groups, television production operations, a major motion picture company and theme parks. Also managed measure, calculation measure under cube, Cube refreshed by using AWM.
Technical Environment:
OBIEE (10G, 11G), Windows XP
successfully completed Oracle SQL training from CMC Kolkata. Also achieved Infosys Campus connect certification from college undertaking by Infosys.