Profile Summary

    • 8 years of IT experience in designing, development, testing and support as ODI, PL/SQL and Data warehouse consultant. 
    • Experience working in different sectors event management, telecom and financials.
    • Conducted multiple trainings to upscale resources in ODI.
    • Gained training experience in Big Data and Essbase.
    • Have hands on experience on HDFS, Map Reduce, Hive, Spark
    • Set up my own single node cluster to learn and do hands-on on Big data.
    • Build multiple automated tools and scripts as accelerators. 

Experience

Technical Lead, HCL Technologies Ltd.

Event Management, UK
Multiple Locations- Nov, 2016- Present

BIAPPS project for customization of finance module and have created new module for Sales and Marketing based on requirement from business. ODI along with OBIEE is being used for reporting event figures for calculation of various numbers related to events.

Responsibilities
    • Handling legacy and global programs of the client.
    • Customization of Knowledge modules.
    • Interfaces, packages, load plans, invoking web services and related ODI tools.
    • Built a reliable and secure code to process payment files from different banks following GDPR & bank protocols.
    • Performance tuning of interfaces loading data in bulk.
    • Leading a team of ETL developers.

Consultant, Deloitte Consulting India Pvt. Ltd.

Engineering Client, US
Gurgaon –Oct, 2015-Aug, 2016

Used ODI for integration between the source systems and populate the data warehouse. The reporting tool OBIEE is used to prepare the reports and dashboards for decision making. Client has customized the product as per the business requirements. Apart from the EBS as source, external applications like EPM (Enterprise Performance Management) were there for which the code has been built.

Responsibilities 
    • Involved as Data warehouse developer in Procurement and Spend module of BIAPPS to customize the product as per business requirement.
    • Understand the enhancement requests of the business.
    • Discuss the design of the new development and enhanced requests.
    • New Objects development.
    • Data & Report Validations.

Energy Client, US
Gurgaon – March, 2015- October 2015

Worked with leading energy client to design the budgeting and forecasting Application. The project requires ODI to provide a well-integrated budgeting and corporate reporting system. ODI was used to get the actual and forecast data from diverse source systems. Worked on Essbase and Hyperion planning to consolidate and build an application using rule files, Maxl scripts.

Responsibilities

    • Creation of Rule Files, Maxl scripts and call it using ODI.
    • Designing and implementing integration using ODI from diverse source systems.
    • Implemented data flow from diverse source systems to Hyperion using interfaces.
    • Designed password protection strategy as ODI Solution.

Financial Services, UK
Pune, Maharashtra – October, 2014 –March, 2015

Worked with leading financial services client for migrating the code from IBM Cognos Data Manager to ODI 11g with additional usage of SQL and PL/SQL. Data manager builds, job streams are converted into ODI interfaces, packages and load plans.

Responsibilities

    • Installation of ODI 11g, set up ODI connections and creation of master and work repositories.
    • Team mentoring, leading a team of 5 freshers.
    • Trained freshers in ODI 11g and scale up them in coping up faster.
    • Helping team in understanding or navigating through data manager.

Senior Systems Engineer, Infosys Ltd.

Telecom Client, UK
Pune, Maharashtra — January, 2013- September, 2014

Worked with leading telecom company as a client for developing a data integration application to keep an account for sales and stock for various countries on Oracle Data Integrator (ODI) with extensive use of SQL, PL/SQL and basics of Unix and Jython. ODI code was built on the extraction of local market data and transform the data into the needed format by Oracle RPAS.

Responsibilities

    • Installation of ODI, set up ODI connections and creation of master and work repositories.
    • Automation of exporting and importing ODI scenarios through Unix script. 
    • Developed ODI packages, scenarios, variables and interfaces to load data from flat files, xml, and database to stage and stage to database, flat files.
    • Developed Complex database objects like Stored Procedures, Functions, Packages and Exceptions using SQL and PL/SQL.
    • Debugging and solving the issues of Unix scripts and Jython procedures.
    • Customized knowledge modules to improve functionalities of application.

Systems Engineer, Infosys Ltd.

Information Solutions Client, UK
Mangalore, Karnataka — February, 2012- December, 2012

Worked for leading provider of information solutions as a client for developing a translation engine application to convert the 11i segments to R12 segments on Oracle Data Integrator (ODI). Built the mapping  

Responsibilities

    • Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, SQL Developer and SQL* plus.
    • Built the complete functionality on ODI 11g with use of SQL, PLSQL and basics of Jython.
    • Developed various Procedures for conversion of segments to R12, developed functions, cursors, in PLSQL to support the functionalities of application. 
    • Have proactively participated in complete SDLC process of the project. Done the unit testing, Integration testing of the application developed.

Professional Accomplishments
    • Live wire award from delivery head during client visit.
    • Received various appreciations from client.
    • Received “Every Track Man” award working and helping all the team for functional issues
    • Worked closely with deployment, Infra and Config team.
    • Have delivered sessions and trainings on ODI.

Systems Engineer Trainee, Infosys Ltd.
Mysore, Karnataka— November, 2011- Feburary, 2012

Have undergone training with Hands on experience in Core Java, Oracle RDBMS, SQL, PLSQL and Oracle Data Integrator 11g.
 
Accomplishments
    • Have completed training with 4.7 CGPA on scale of 5.    
    • Have developed project of Sports club using PL/SQL.

Education

Guru Premsukh Memorial College of Engineering
B. Tech. (ECE) — 2007-2011

Completed 4 years of Bachelors of Technology in ECE domain from GGSIP University, New Delhi 

D.A.V Public School
CBSE — Have completed my 10th and 12th with first division.
                                                                              
Technical Skills
    • Primary Skills: Oracle Data Integrator (ODI), PL/SQL, SQL queries
    • Secondary Skills: Jython, Unix, Core Java, RDBMS
    • Trained on: Big Data, Hadoop, Spark
    • IDE: Toad, Eclipse, JDeveloper, TFS, MS-Visio 

REFERENCES
Available upon request.