Summary

More than *.* years of IT experience in Business Intelligence and Data Warehousing.

Developed various mappings to load required data into data warehouse.

Worked on SQL, PL/SQL procedures, triggers, functions tables, cursors.

Have been constantly complimented by clients and manager for proactive identification and resolution of defects.

Excellent team player as well as an individual performer.

An efficient communicator with excellent leadership, organizational and motivational skills.

A result oriented person with an analytical mind capable of delivering timely and desired results even in most challenging situations.

Skills

ETL : Informatica power center 9.x/ 8.x

GUI tools : SQL Developer, JDeveloper 10g & 11g, Eclipse

Languages : C, C++,JAVA, HTML, CSS, JavaScript, J-Query, node.js, JSON, XML

MongoDB,

DBMS : Oracle SQL, PL/SQL, MySQL

education

Master’s Degree in Applied Information Technology, Towson University, 2016-2018

Current GPA 3.94/4.0, Specialization in DBMS.

Bachelor of Engineering, Electronics and Control Engineering, Sathyabama University, 2009 – 2013

Training

Underwent training for BI/DW, ETL tool Informatica in Larsen and Toubro Infotech (now LTI).

Underwent training for Salesforce within team in LTI.

Professional Experience

Company: Larsen and Toubro Infotech (now LTI)

Client: Citi Bank Oct 2013 – Feb 2015

Worked in Business Intelligence and Data Warehouse domain. Worked on Informatica power center tool and developed mapping using various transformations like filter, joiner, router, lookup aggregator, rank and more.

Role & Responsibilities

To create various mappings and mapplets using various features of informatica

Participated in requirement gathering meetings with Architect, client with team members.

Worked on documentation involving metadata about the warehouses.

Used data from different source such as excel file, oracle, SQL server.

Wrote complex queries and small procedures as required.

Worked with team members in debugging the errors mapping.

Testing: Performed End-to-End Testing

Team Size: 5

Environment: Informatica

Worked on designing of web portal for the company in research and development segment of company. I worked on front end of the portal as well as backend.

Role & Responsibilities

To create the look and feel of website. I used HTML, CSS, JavaScript, jQuery, JAVA.

I also used SQL to make that website functional by writing code to retrieve data and process data when user performs some action (submit/click)

I used java to represent output in charts and graph.

We used JDBC API to establish connection between java and database.

We had daily scrum meetings to discuss daily tasks and current status.

Web application server used was Apache Tomcat

Worked on documentation for developing test case for each screen that I developed.

Testing: Performed End-to-End Testing

Team Size: 7

Environment: JavaScript, HTML5, CSS3, jQuery, Apache, JAVA

Work Authorization

I have work authorization to work in USA via H4 EAD, valid till – Feb 2020.

Contact this candidate