Summary
Overview
Work History
Education
Skills
Timeline
Generic

Alok Singh

Pune

Summary

• 11years of Full Stack BI Developer experience in Oracle Data Integrator,,TERADATA, OBIEE,PL-SQL,DevOps.
• Good knowledge of telecom Airline banking domain.
• Highly Skilled in ETL Processes (Oracle Data Integrator 11G /12C).
• Experience in Analysis, Design, and Development including Implementation of Business Intelligence BI solutions using OBIEE and Tableau.
• Good Knowledge of UNIX, SQL,OBIA,Azure devops.
• Good knowledge about Topology, Designer, Operator, Load Plans in Oracle Data Integrator.
• Worked with knowledge modules like LKM, IKM and CKM .
• Knowledge on Teradata architecture and components.
• Good knowledge on Fast Export, FASTLOAD, BTEQ, Multi load.
• Knowledge on data ware housing concepts like schemas and approaches.
• Excellent team leading qualities and working as a team Lead.
• Ability to work individually as well as in a team with excellent problem solving skills.

Overview

11
11
years of professional experience

Work History

ODI_LEAD Developer

Capgemini
11.2022 - Current
  • Continuous discussion with onshore counterparts to understand local business requirements and design technical document (IDD).
  • Understanding design and implementation of it in ODI.
  • Technical implementation of design/change using ODI and UAC(Scheduling ODI jobs).
  • Create/Review of Code, Design/Mapping sheet, Test Cases and Results.
  • Participation in QBR meetings and Planning.
  • Handle issues in production.
  • Manage weekly Scrums with senior leadership.

ODI_LEAD Developer

Cognizant Technologies
03.2021 - 11.2022
  • ·Continuous discussion with onshore counterparts to understand local business requirements and design technical document (IDD).
  • Understanding design and implementation of it in ODI.
  • Technical implementation of design/change using ODI and UAC(Scheduling ODI jobs).
  • Create/Review of Code, Design/Mapping sheet, Test Cases and Results.
  • Participation in QBR meetings and Planning.
  • Handle issues in production.

ODI_Teradata Developer

Vodafone Shared Services
01.2018 - 03.2021
  • Continuous discussion with onshore counterparts to understand local business requirements and design technical document (IDD).
  • Review SDD developed by colleagues and freeze business requirements, and transform them into technical specifications.
  • Create/Review of Code, Design/Mapping sheet, Test Cases and Results.
  • Develop and modify mapping, package and procedure.
  • Handle issues in production.
  • Induction and training of team members

OBIA_ODI Developer

Capgemini
02.2017 - 12.2017
  • • Worked during whole life cycle of project from requirements gathering to deployment.
  • • Created load plan for all OBIA processes.
  • • Developed packages scenarios using interfaces and variables.
  • • Extensive experience in developing he load plans, packages and job scheduling. Good knowledge in installing ODI11g and to create Master and work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.

Teradata_ODI Developer

Wipro Technologies
09.2013 - 02.2017
  • Working knowledge of Knowledge Modules (LKM, IKM, JKM and CKM).
  • Developed packages scenarios using interfaces and variables.
  • Extensive experience in developing load plans, packages and job scheduling. Good knowledge in installing ODI11g and to create Master and work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.
  • Create prompts Ad Hoc reports and customized reports.
  • Resolved ODI related issues faced by team members.
  • Developed packages scenarios using interfaces and variables.
  • Worked during whole life cycle of project from requirements gathering to deployment.
  • Correct customizations of Data Warehouse, RPD, and in Dashboards.
  • Create prompts Ad Hoc reports and customized reports.

Education

BE - Computer Science

Oriental Institute of Science And Technology
05.2012

12th -

ARMY SCHOOL
03.2007

10th -

ARMY SCHOOL
03.2005

Skills

  • ETL Tool : Oracle Data Integrator(ODI11g,ODI12c)
  • Databases : Teradata, Oracle, Postgresql
  • Operating System : Unix, XP
  • Tool : SQL Assistant,Putty,Jira,Azure devops,UAC
  • Language : SQL, PL SQL,JAVA
  • Reporting Tool : OBIEE,TABLEAU

Timeline

ODI_LEAD Developer

Capgemini
11.2022 - Current

ODI_LEAD Developer

Cognizant Technologies
03.2021 - 11.2022

ODI_Teradata Developer

Vodafone Shared Services
01.2018 - 03.2021

OBIA_ODI Developer

Capgemini
02.2017 - 12.2017

Teradata_ODI Developer

Wipro Technologies
09.2013 - 02.2017

BE - Computer Science

Oriental Institute of Science And Technology

12th -

ARMY SCHOOL

10th -

ARMY SCHOOL

Similar Profiles

CREATE PROFILE
Alok Singh