SUMMARY:

• Over 7+ years of experience in the field of Information Technology with emphasis on open source Business Intelligence Tools specifically Pentaho, Database management systems, development and complete Project Life Cycle in Data Warehousing and Client/Server technologies.
• Experience in Data Warehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using Pentaho Data Integration (Pentaho Kettle) with Oracle, SQL Server and Mongo DB.
• Working experience on transforming data from various data sources to a Data warehouse using PDI 4.1/4.0 and Kettle 3.2 and interacting with the Business Analysts in identifying the needs and the requirements of the system.
• Highly experienced in creating PDI Jobs and Transformations in enterprise repositories according to requirement to integrate source data in to Target data ware house.
• Knowledge in designing and developing Data marts, Data warehouse using multi - dimensional Models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems.
• Experience in identification of FACTS & Dimensions tables and hierarchies in Physical & logical data modeling.
• Full Life Cycle Experience including requirement analysis, design, development, testing, implementation and documentation.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS:

Primary Skills: Business Problem Analysis Database Architectural Design Data Modeling ETL & Reporting

ETL Tools: Pentaho Data Integration 4.0/4.1 Pentaho Kettle 3.2 SSIS

Reporting Tools: Pentaho Report Designer 3.x Pentaho Analyzer Pentaho Schema Workbench Pentaho Analyzer Business Objects Crystal Reports

Database Platforms: SQL Server 2008/2005 Oracle 10g/9i/8i/8/7.x MySQL and Mongo DB Experience in using Data modeling tools like ERWINAnalysis/Design Tools MS Visio ER/Win E/R Studio Sound knowledge in Pentaho Enterprise BI Suite (Data Integration, Report Designer, Schema Workbench, Analyzer, Mondrian, Design Studio, Dashboard Designer, User Console and Enterprise Console).

Languages: SQL & PL/SQL Unix Shell C/C++ Java / JavaScript Strong database experience in using Oracle 11g/10g/9i/8i/, MS SQL Server 2005/2000, MS Access, SQL, PL/SQL, SQL*Plus, SQL*Loader, NoSQL and Developer 2000. Hands on Working knowledge in Writing the Stored Procedures, Packages, Functions and Triggers.

Operating Systems: Unix Linux Windows Server Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment and change data capture.

PROFESSIONAL EXPERIENCE

Confidential, Raritan, NJ

Sr. Pentaho Developer

Responsibilities:

• Responsible for gathering information from clients regarding business requirements and collaborated with business technicians to research existing business and system processes.
• Interacted with business analysts and End client to understand technical and functional requirements for creating new Job.
• Developed complex custom reports using Pentaho Report Designer which includes developing Cascading pick-lists, Drill-throughs, Hyperlinks, sub-reports etc, functionality into these reports.
• Developed several Pentaho Reports, Dashboards, XActions and Analyzer Reports for the client.
• Designed and deployed custom dashboards on Pentaho User Console.
• Integrated Pentaho reports and dashboards with the client’s existing front-end application and web portals.
• Used Pentaho Data Integration 4.0 for ETL extraction, transformation and loading data from heterogeneous source systems such as excel and flat files.
• Used PDI transformations to cleanse data for duplication, derived values and address parsing.
• Created complex PDI mappings to load the data warehouse. The mappings involved extensive use of transformations like Dimension Lookup/Update, Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence etc.
• Extensively worked with enterprise Repositories, PDI Job Servers and Enterprise console.
• Responsible for Debugging and testing of PDI Jobs.
• Optimized data mappings to achieve faster load.
• Performed debugging and performance tuning of sources, targets and mappings.
• Worked with Parameters/Variables in PDI jobs and transformations to achieve automation.
• Created Java Scripts and worked with Conditional statements and While Loops to implement complex logic.
• Extensively used “Define Error Handling” to handle exceptions and wrote Scripts to automate the Job Process.
• Performance tuning of the SQL queries by restructuring the Joins, creation of required indexes to avoid table scans, error handling of queries etc.
• Loaded Data into Target using from flat files, XML and database tables as source.
• Performed migration of Data from Excel, Sybase, Flat file, Oracle, Mongo DB and MS SQL Server.
• Tested and Validated PDI ETL Jobs, monitored Daily PDI ETL schedules.
• Performed troubleshooting and provided resolutions to ETL issues.

Environment: SQL Developer, Oracle 10g, SQL Server 2005/2008, Pentaho BI Suite (Data Integration Designer, Report Designer, Dashboard Designer, Analysis View, Pentaho Analyzer, Design Studio, Mondrian Server), SQL Management Studio 2008, SQL Server 2005 & 2008,Windows Server 2008, JavaScript

Confidential, Sanjose, CA

Sr.Pentaho Developer

Responsibilities:

• Participated in Requirement gathering sessions and developed PDI job specifications based on information acquired from analysis of source data, user requirements and business Rules.
• Extracted the data using Pentaho Data Integration Designer (Kettle) from the flat files and other RDBMS databases like SQL Server 2005/2008 and Oracle 10g into staging area and populated onto Data warehouse.
• Collaborated with Database Administrators, Developers, and Analysts on all aspects of data management.
• Used error handling strategy for trapping errors by defining error handling in all crucial steps of ETL transformations and sending errors to an error table.
• Monitored and performed troubleshooting batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets and was associated with Production support team in various performance related issues.
• Developed UNIX shell scripts to move source files to archive directory.
• Designed various types of reports using Pentaho Report Designer with Complex Formulas, Custom Functions, JavaScript Expressions, Sub Reports and Drill throughs by means of hyperlinks.
• Assisted in constructing reports UI with Java Eclispe SDK to include parameter values to be passed to reports.
• Designed the reports with multi level of groupings (hierarchies).
• Helped tune the database to resolve performance issues and ensured high performance through periodic performance evaluation and improvements.
• Involved in Unit, Integration, system, and performance testing levels.
• Interacted with executives to learn the business objectives and propose creative solutions to meet the objectives
• Provided Recommendations for cost mitigation solutions brought to the table with design approaches with the software development team to effectively represent the required data for analysis
• Documented for ERDs, Pentaho Report Templates and Pentaho Schema and Cube Designs.

Environment: SQL Server 2005/2008, Oracle 10g, Pentaho BI Suite (Kettle, Report Designer, Design Studio, Pentaho Mondrian), SQL Management Studio 2008, Windows Server 2003/2008, JavaScript

Confidential, Chicago, IL

Pentaho Developer

Responsibilities:

• Involved in gathering business requirements, functional requirements and data specification.
• Designed Data Warehouse and Database for the system using Star Schema which includes Tables, Stored Procedure and Indexes in SQL Server Management Studio.
• Used Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Created and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Created and run Sub-reports, Drill-down reports, Matrix or Crosstab reports and Summary reports in SSRS.
• Created Subscriptions to generate reports on daily and weekly basis via FTP.
• Managed Report Security using SSMS. Connect to Reporting Server and set different roles and different security level to different users.
• Used SQL Server Profiler for tuning report queries and improve performance in SQL Server.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the development work.

Environment: MS SQL Server 2005 Enterprise Edition, Windows Server 2003, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), Pentaho Kettle Spoon Designer v3.2, SQL Server Reporting Services (SSRS), Microsoft Visual Studio 2005, IIS.

Confidential

SQL Developer

Responsibilities:

• Gathered requirement from the business users, prepared functional specification and design documents.
• Prepared program specifications and development of PL/SQL packages, procedures and functions as required by the business users.
• Generated server side PL/SQL scripts for data manipulation and validation.
• Analyzed the existing method for data repository refresh and then developed an ewpackage with tuned queries to improve the performance and reduce the time taken for their fresh.
• Loaded data into oracle database from flat files using SQL*Loader.
• Created Materialized View for extracting the data from the remote databases.
• Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Generated and maintained Keys, Constraints and Relationships between the tables for OLTP database.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Optimized critical queries to eliminate Full Table Scans, reduce Disk I/O and Sorts.
• Fine Tuned SQL statements for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Tracesessions for Cost based and Rule based Optimization..

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Windows.