SUMMARY

• Over 8 years of experience wif very good technical and team working skills in full life cycle development involving analysis, design, development, deployment, testing, documentation, implementation & maintenance of application software in Web - based environment, N-tier architecture and Client/Server architecture.
• Specialization in Various BI tools like Pentaho, Informatica 9.1, BIRT & Jasper
• Highly experienced in Data Warehousing, ETL and Business Intelligence experience using Pentaho Suite (Pentaho Data Integration/Kettle, Pentaho BI Server, Pentaho Meta Data and Pentaho Analysis & Mondrian OLAP, Pentaho Design Studio, Pentaho Report Designer, MDX Query).
• Excellent experience in writing Complex Stored Procedures, Dynamic SQL queries, Batch Scripts, Functions, Triggers, Views, Cursors and Query Optimization.
• Excellent in performance tuning of stored procedures, Database Tables using Table Partitioning, SQL Profiler and Database tuning wizard.
• Excellent experience in RDBMS concepts, Data warehouse Star Schema Modeling, Snow Flake Modeling, FACT& Dimension Tables, Physical and Logical Data Modeling.
• Good noledge on Requirements Gathering, System Analysis & Design, Developments, Testing & Maintenance phases of projects developments.
• Proficient in implementing the business logic to design/develop the Cubes,Aggregation, Measures using SQL Server Analysis Services (SSAS).
• Experience wif Version Control Systems like CVS, SubVersion and IBM Rational Clear Case
• Strong noledge of Oracle, DB2 & My Sql, SQL Server, Postgres
• Skilled in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, MySQL, PostgreSQL, flat file, Text Format Data).
• Proficient in Web-based applications developed in Java SE 1.4, Java SE 5, Java SE 6 and Java EE technologies.
• Very good experience in designing and developing applications using JSP, Servlets, JNDI, JDBC, Spring Framework, Struts.
• Worked wif various development methodologies like SDLC (Waterfall Model), Agile and Iterative Software development
• Experienced in working on Operating Systems like Unix, Red Hat 8 and Ubantu Linux
• Experience on development tools like Eclipse 3.2, MyEclipse Blue 6.5, NetBeans
• Worked on Notification services in setting up the Scheduled jobs and alerts.

TECHNICAL SKILLS

Pentaho Suite: Pentaho Data Integration (Kettle), Pentaho BI Server, Pentaho Analysis Tool, Pentaho Report Designer, Pentaho Mondrian, Pentaho Metadata Editor, Pentaho Design Studio, Mondrian OLAP Server

Other BI Tools: Informatica, Data Stage, BIRT, Jasper

RDBMS: Oracle 8i/9i/10g, MS-Access, MySQL, SQL Server 2005, IBM DB2 9.5

Operating Systems: DOS, Windows NT, Windows 95/98, Windows 2000 Professional, Windows XP, Linux

Languages: Java 1.5, C, C++

Web Technologies: JSP, Servlets, XML, HTML, JavaScript

Frame works: Jakarta Struts 1.2, J2EE, Spring

Web Servers: Apache Tomcat 5.0

Application Servers: JBOSS 4.0

IDE: Eclipse 3.1, myeclipse blue 6.5, Edit Plus 2

Build Tools: ANT, Maven

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

DWH Architect & Lead

Responsibilities:

• As DWH Architect / Lead Developer, was responsible for leading the DW team across 3 business modules namely Business to Revenue (B2R), Quarter Ending (QE) and EVEREST.
• Actively interacted wif business stakeholders, sponsors and client partners for Business Analysis & requirement collection
• Actively participated in designing Physical and Logical Data Warehouse.
• Designed Data warehouse including star schema design, DW capacity planning, Oracle SQL performance and tuning.
• Involved in building Data warehouse Star Schema Modeling, Snow Flake Modeling, FACT & Dimension Tables.
• Understanding business process source to target database (EDW).
• Analyzed Jobs in Data Stage and using Pentaho (Spoon) developed the transformations by using several Steps.
• Used Pentaho Data Integration Designer 4.2 to create all ETL transformations and jobs.
• Used different types of input and output steps for various data sources including Tables, Access, Text File, Excel and CSV files.
• Made use of different transformations in PDI designer to cleanse and manipulate source data e.g. Database Lookup & Join, Stream lookup, merge join, select values, UDJE, UDJC, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence, Get & Set Variables etc.
• Implemented Slowly Changing Dimension Type 1 and Type2 in ETL jobs for certain Dimensions.
• Saved Pentaho jobs in enterprise repository and scheduled them to run in production on daily basis.
• Performance tuning of slowly running transformations and jobs.
• Performance tuning of SQL Queries & Stored procedures using SQL Profiler.

Environment: Pentaho Data Integration 4.2.1, Oracle 10g, Data Stage 8.5

Confidential, Costa Mesa, CA

BI Architect & Lead

Responsibilities:

• Managing 20 team members in a team for IMS module.
• Actively participated in requirements gathering
• Involved in preparing detail Technical design by understanding BRD’s.
• Developed Technical Proof of Concept (POC) for critical functional areas.
• Responsible for Physical and Logical designing ofthe Data warehouse.
• Involved in building Data warehouse Star Schema Modeling, Snow Flake Modeling, FACT & Dimension Tables.
• Designed Data warehouse including star schema design, DW capacity planning, DB2 SQL performance and tuning.
• Used Pentaho Data Integration Designer 4.0 to create all ETL transformations and jobs.
• Used different types of input and output steps for various data sources including Tables, Text File, Excel and CSV files.
• Made use of different transformations in PDI designer to cleanse and manipulate source data e.g. Database Lookup & Join, Stream lookup, merge join, select values, UDJE, UDJC, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence, Get & Set Variables etc to create and maintain DWH.
• Actively involved in Pentaho transformation and job performance tuning for better performace.
• Involved in planning the tasks to be taken up sprint by sprint basis using Agile methodology.
• Involved in deploying the project to the different Environments like DEV to QA and PROD.
• Worked actively in Modularizing and Generalization of code to facilitate Customization wif only limited changes
• Worked closely wif the Testing Team to work towards Zero Defects.

Environment: Pentaho Data Integration, DB2, Mongo DB, i-Report, Java SE 5, Java EE, Spring, XML, Work Flow, J-unit, GWT, J-boss 5.1 Server, Maven, Web Services

Confidential

Lead Engineer

Responsibilities:

• Responsible for installation of Pentaho Data Integration (PDI) on Solaris OS
• Trained and guide the team to how to work on PDI and pentaho Reporting & Dashboard
• Implemented best practice of PDI as per client environment.
• Actively involved in designing the major transformation and jobs using Database Lookup & Join, Stream lookup, merge join, select values, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence, Get & Set Variables steps to create and maintain DWH.

Environment: PDI 3.2, Pentaho Reporting & Dashboard

Confidential

Lead Engineer

Responsibilities:

• Creating & Managing Reports using BIRT Report Designer.
• Developed different types of Reports, Charts, Graphs, Sub-Reports, Drill-down reports wif Cascading Parameter prompts using BIRT Designer & MYSQL DB.
• Tuned SQL queries for better performance.
• Integration of reports wif the system.
• Manage the reports related portlets.

Environment: BIRT 2.5.1, Liferay5.3, Alfresco, Struts, mysql-5, tomcat 5.5

Confidential

Lead Engineer

Responsibilities:

• Developed different types of Cross-Tab & Tabular Reports, Charts, Graphs, Sub-Reports, Drill-down reports wif Cascading Parameter prompts using BIRT Reporting Engine.
• Tuned SQL queries for better performance.
• Integration of reports wif the system.
• Manage the reports related portlets.

Environment: BIRT 2.5.1, Liferay5.3, Alfresco, Struts, mysql-5, tomcat 5.5

Confidential

Lead Engineer

Responsibilities:

• Developed different types of Cross-Tab & Tabular Reports, Charts, Graphs, Sub-Reports, Drill-down reports wif Cascading Parameter prompts using Pentaho Report Designer and Pentaho Design Studio .
• Created the Schema & MDX query to populate the data in OLAP view.
• Actively involved in Pentaho Security Using Acegi
• Actively involved in writing SQL Queries and performance tuning for better performance

Environment: Pentaho 3.0, Design Studio 3.0, Report Designer 3.0, Workbench 3.0.3, Mondrian 3.0.4, OLAP, mysql-5, tomcat 5.

Confidential

Software Engineer

Responsibilities:

• Developed different types of Cross-Tab & Tabular Reports, Charts, Graphs, Sub-Reports, Drill-down reports wif Cascading Parameter prompts using Pentaho Report Designer and Pentaho Design Studio.
• Developed Schema using Workbench.
• Developed MDX query to populate the data in OLAP view.
• Actively Involved in Pentaho Security Using Acegi

Environment: Pentaho 3.0, Design Studio 3.0, Report Designer 3.0, Workbench 3.0.3, Mondrian 3.0.4, OLAP, mysql-5, tomcat 5

Confidential

Software Engineer

Responsibilities:

• Developed different types of Cross-Tab & Tabular Reports, Charts, Graphs, Sub-Reports, Drill-down reports & Dashboard wif Cascading Parameter prompts using Pentaho Report Designer and Pentaho Design Studio .
• Involved in Pentaho Security Using SSL
• Developed Schema using Workbench.
• Actively involved in writing SQL Queries and performance tuning for better performance
• Developed MDX queries to populate the data in OLAP view.

Environment: Pentaho 1.7, Design Studio 2.0, Report Designer 2.0, ETL, Workbench 2.3.2, Mondrian 3.0.3, OLAP, mysql-5, JBOSS 4.2.1

Confidential

Software Engineer

Responsibilities:

• Developed different types of Cross-Tab & Tabular Reports, Charts, Graphs, Sub-Reports, Drill-down reports & Dashboard wif Cascading Parameter prompts using Pentaho Report Designer and Pentaho Design Studio.
• Created the Dashboards using CDF.
• Developed Schema using Workbench.
• Created the MDX query to populate the data in OLAP view.
• Involved in Pentaho Security Using SSL

Environment: Pentaho 1.7, Design Studio 1.7, Report Designer 1.7, PDI, Workbench, 2.3.2 Mondrian 3.0.3, OLAP, Postgres 8.2, JBoss 4.2.1

Confidential

Software Engineer

Responsibilities:

• Involved in development of different modules (Admin, Report)
• Involved in creating the Dashboards using JSP.
• Developed Cross-tab and Tabular Reports using Pentaho Design Studio

Environment: Pentaho 1.7, Design Studio 1.7, Report Designer 1.7, PDI, Workbench, 2.3.2, Mondrian 3.0.3, OLAP, Postgres 8.2, JBoss 4.2.1