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.