EXPERIENCE

2+ years of experience in the area of Warehousing in analysis,design and development of software applications using Pentaho,Jasper,BIRT BI servers, Report designers and kettle(ETL) tool.
Main areas of expertise are analyzing,developing and testing the Data warehousing projects.
Experience in development of mappings using needed transformations using Pentaho Kettle tool.
Experience in Data warehousing using Data extraction, Data transformation and Data loading.
Good knowledge on Data warehousing concepts like Star schema, Dimension and Fact tables.
Extensively used Pentaho, Jasper, BIRT client tools - Pentaho report designer, Pentaho scheme workbench, Pentaho design studio, pentaho kettle, Penatho BI server, Jasper ireport, Jasper server,BIRT report designer.
Knowledge with UNIX Shell scripting, SQL, PL/SQL coding.
Excellent problem solving skills with strong technical background and good interpersonal skills
Possess excellent project management skills in managing, developing and implementing the project
Skillful in completing all assignments within the budgeted time parameter Experienced in knowledge transfer, preparing the required documentation Effective team player with good logical, communication & interpersonal skills Strong analytical abilities combined with flexible & detail oriented attitude

SKILL SETS

• Programming Languages: Java, J2EE , Linux Shell Scripting, HTML, CSS , JavaScript , XML
• Operating Systems: Linux/Unix, Windows
• Web/Application Servers: Tomcat, Apache
• Databases: MySQL, Oracle , PL/SQL
• ETL tools: Pentaho kettle
• Reporting Tools: Pentaho report designer, Jasper ireport, BIRT Report designer,Pentaho CDE(Community Dashboard Editor) and CGG (community graphics generator).
• BI servers: Pentaho BI server,Jasper server.
  

PROJECT DETAILS

Project 1:

Title: Confidential
Technologies: Pentaho BI server, Pentaho Report designer, CDE (community dashboard editor),CGG (community graphics generator), MySql 5.0 ,UNIX.
Role: Developer
Team Size: 3
Duration: Jan\' 2012 - Till Date

Project Overview:

This project is a resume building project that contains the data of number of candidates/employers/trainers registered, subscription plans and revenue of those users and number of login events made by candidates. Our main goal is to display this data in the form of charts using pentaho CDE (community dashboard editor) plugin.

Roles and Responsibilities:

Designing the Dashboards using pentaho CDE plugin and deploying them to the different servers like Dev, QA and PROD etc.,
Exporting those reports in to the PDF,XLS,XML,CSV formats. To export the CDE reports in to PDF format we used the pentaho CGG (community graphics generator) plugin.

Project 2:

Title: Confidential
Technologies: Pentaho Kettle 4.1.0, Pentaho BI server 3.7.0, Pentaho Report designer 3.7.0, CDE (community dashboard editor), MySql 5.0 ,UNIX.
Role: Developer
Team Size: 4
Duration: Feb\' 2011 - Dec\' 2011

Project Overview:

The immediate goal of the project is to provide an executive leadership with standardized and timely information to the business users, which will help them to make strategic decisions regarding to the business. All the metrics developed will be displayed in BI server trough analysis views and reports that will help to the business users to make the Ad-hoc reports.

Roles and Responsibilities:

Performance tunning of ETL scripts and DB stored procedures.
Data migration from one environment to another environment using kettle ETL tool.
Created ETL mappings using kettle 4.1.0 to move data from multiple sources like ISO links,URL\'s, csv files etc.
Query Optimization.

Project 3:

Title: Confidential
Technologies: Pentaho BI server, Report designer, Design studio, Oracle 10g, Toad for Oracle.
Team Size: 3
Duration: Oct' 2010 - Jan\' 2011

Project Overview:

This project is to provide different reports and supporting business queries for making intelligent invoice decision based on data available in various branches across the country collected over a period of time.Confidential wants to have a tool, which will help it to analyze the business trends and to make predictions for future business trends.

Roles and Responsibilities:

Dashboard Design using openflash charts with good look and feel.
Flash charts integration with the reports that display the data in the form of tables below the flash charts.
Parameters passing to the flash charts and reports.
Testing & Bug Fixing.

Project 4:

Title: Confidential - Axis2 Web Services & Jasper Reporting
Technologies: Axis2 v1.5.1, Jasper Reports ireport 4.1, Servlets & Jsp.
Team Size: 3
Duration: Jun' 2010 - Sep\' 2010

Project Overview:

The main aim of the project is to show the Jasper Reports to the end user in different file formats.

• The end user will be facilitated with an simple gui from where the users can give the input parameters & the format in which they want the report to be generated as.
• Depending upon the inputs provided the application will show the report in what ever format the user has selected.

EDUCATION

2006- 2010: B. Tech. (Electronics & communication Engg.).
2004- 2006: INTER.
2003- 2004