BHAVANI J

Singapore

Mail id: ac8ugk@r.postjobfree.com

Phone:+65 83022978

Objective

To explore the world of information technology with my knowledge gained in and to enrich my ETL and Reporting skills further in a challenging environment and also to provide positive contribution to my personal growth and the organization.

Professional Summary

●Qualified Software Developer with 3.7 years of experience in Data Warehousing and Business Intelligence

●Experience in extraction, transformation and loading of data using Informatica Power Center 9.1.0 from oracle data base

●Hands on Training on daily Loads monitoring using DAC for Informatica Admin

●Provided Support for maintenance of Prod and non Prod application

●Coordination with UNIX DBA and other infrastructure team for patching and various activities.

●Development of job, joblets using Talend 6.3

●Experience on Load scheduling and Managing using TAC for Talend related jobs

●Leveraged skills in cementing good communications and leading the workforce towards accomplishing Business and Corporate goals

●Possess strong positive thoughts and motivating attitude

Education

Bachelor of Engineering (B.E.) in Biomedical Engineering

SSN College of Engineering,

Anna University, 2010-2014,

CGPA- 7.75 (on a scale of 10)

Higher Secondary School Certificate (12th Grade)

Sri Krishanaswamy Matriculation Higher Secondary School, Chennai,

TamilNadu State Board, 2010,

Percentage of marks: 93.25

Secondary School Certificate (10th Grade)

Sri Krishanaswamy Matriculation Higher Secondary School, Chennai,

TamilNadu Matriculation Board, 2008,

Percentage of marks: 91.6

Technical Knowledge

Business Intelligence Tools : Informatica 9.1, Talend 6.3, DAC, TAC, OBIEE 11g

Languages : SQL

Database : Oracle 11g, MS SQL

Operating Systems : Windows, LINUX

Professional Experience

Infosys Limited, Chennai, July 2014-Feb 2018

Position: Senior System Engineer

ROLE: Support and Enhancement Resource ( Informatica and Talend )

Client: Reed Elsevier Limited, United Kingdom, Oxford.

Description :

Elsevier is global information analytics business that provides various health care related information to various professionals to improve performance and improvement of humanity.

Project: #1Sales Data Warehouse/Business Analytics Warehouse/Evise

ETL Tool :Informatica 9.1.0 / Informatica Admin and OBIEE 11g

Reporting Tool :OBIEE 11g

Role :Enhancement and Support Resource

Responsibilities:

Develop or update the mapping, workflows in Informatica power center based on client requirement

Perform unit, Regression and Performance testing at every possible level

Monitoring of daily loads and weekend loads

Perform Performance Tuning of loads wherever required as part of load management activities

Create change request and perform PROD environment migration for both informatica and RPD chnages

Automation and scheduling of loads wherever required

Restart the application and Informatica services if required.

Coordinate with other source and infrastructure teams for admin level activities

Enhancement of Application using OBIEE 11g reporting tool based on requirement.

Creation of new reports or dashboards .

Performance tuning of Dashboards

Project: #2 JRBI

ETL Tool :Talend 6.3

Reporting Tool :OBIEE 11g

Role : Enhancement and Support Resource

Responsibilities:

Creation of new jobs and joblets for various Dimensions and Fact tables

Experience of handling Slowly Changing Dimensions to maintain the complete History.(Type SCD 1 and SCD 2 )

Automation of daily loads.

Scheduling of daily and weekly loads and provides the report of the same on time.

Performance tuning of loads

Worked on Migration of Talend 6.0 to Talend 6.3

Handling Production migration

Other Responsibilities:

●Participate in Requirement gathering sessions with client for implementing the enhancements.

●Work in Agile Methodology for implementing the requirements.

●Attending Daily scrum call with Users for showcasing the progress of the enhancements.

●Efforts Estimation of the enhancements which are in scope for each release.

●Building Design Documents proposing optimal design for the given requirement.

●Implementation of the proposed Design at Database, ETL, RPD and OBIEE Report level.

●Performing Unit Testing, Integration, Regression and Performance Testing at every level.

●Making sure all processes are followed from requirement gathering to Production move for each release.

●Published internal Knowledge documents which enabled the readers to get insight of OBIEE 11g features.

●Resolve Tickets which are raised by the Users on various application issues.

●Weekend Support for handing critical tickets and data load monitoring and ensured business was not affected during weekends.

●Building Test cases for the enhancement entities in waterfall model.

●Involved in KT sessions of fresher’s entering Team as well as to the sibling team under the same application.

Project Profile

# B.E. Final Project:

Title :‘Brain Computer Interface’

Description:

A control application based on imaginary hand movements by proving the hypothesis that our brain signals ( called as EEG ) are the same when we move our hands and imagine our hands to be in motion.

Role:

Played a major role in acquisition of EEG signal from 8subjects and processing of those signals. A significant part in design phase of gaming application.

Academic Achievements

●Scored a centum in Science in High School(2008)

Project Achievements

●Working as a single point of Contact for EVISE data warehousing

●Projects delivered on time with high Report/ETL performance that has exceeded client expectations.

●Handled as single resource in initial set up of GIT and Talend.

●Made several improvements in the ETL level and Database level to ensure that data in Sales Data Warehouse is stable.

Workshops and Internships

●Underwent hospital training program at SankaraNethralaya- Chennai at the Bio medical department

●Completed hospital training in Department of Biomedical Engineering for one week at Apollo Hospitals-Chennai

●Learnt the fundamentals of image processing in a workshop at Madras Institute of Technology-Chennai.

●Attended OBIEE training in Infosys Limited

●Attended Talend training in Infosys Limited

●Attended Informatica training in Infosys Limited

Contact Details

Name :Bhavani J

E-mail:ac8ugk@r.postjobfree.com

Phone: +65 83022978

Present Address : #13-144,block 75

Bedok North Road

Singapore - 460075

Languages Known: English, Tamil

Contact this candidate