SUMMARY

• Professional with 7 + years of experience in the area of creating OLTP and OLAP Data ware house using Pentaho Suite which are dependent on Pentaho Data Integration/Kettle, Pentaho BI Server, Pentaho Meta Data and Pentaho Analysis Tool & Mondrian OLAP versions on Linux and Windows platform.
• Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Expertise in creating and debugging Stored Procedures, Functions, Packages, Triggers, Cursors and Object Types in PL/SQL using TOAD and Oracle SQL Developer.
• Integrated RDBMS Concepts and Data Modeling with the help of Erwin 4.0, Star and Snowflake Schemas.
• Used components of different elements in Pentaho like Database Lookup & join, Generate rows, Calculator, Row normalize &de - normalizers. Add constant and add sequence.
• Participated in weekly end users meetings to discuss Data Quality, Performance issues and ways to improve data accuracy and new requirements.
• Skilled in High Level Design of ETL DTS Package from heterogeneous sources for integrating data (Excel, CSV, Oracle, MySQL, flat file, Text Format Data).
• Expertise in configuring and installing Pentaho BI Server 3.6 for data warehouse ETL and reporting purposes.
• Experience in managing license files for subscription of the products in Enterprise Console.
• Experience in creating ETL transformations and jobs using PentahoKettle Spoon designer and Pentaho Data Integration Designer and scheduling them on PentahoBI Server.
• Integrated the evaluation of overall ETL (Extract Transformation & Load) process.
• Experience in Extracting Data from Oracle EBS.
• Skilled in full life cycle including project scoping, requirements gathering, systems analysis, design, development, testing, implementation and maintenance.
• Experience with exception/error handling in PL/SQL.
• Experience in Java development working across multiple technologies.
• Excellent programming skills in creating database objects like Tables, Views, Stored Procedures, Indexes, Triggers and Functions.
• The ability under minimal direction to accomplish tasks and supervision as well as Demonstrated leadership abilities and team work skills.
• Have the experience and knowledge to educate the new teams with upcoming technologies and get them ready.
• Excellent verbal and written communication skills with interpersonal, Detail-oriented, results-driven and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS

Operating System: UNIX, Red Hat Linux, Solaris, Windows NT/2000/XP/7

Languages: SQL, BI-SQL, C#.net, HTML, Shell scripting, Java, C++

Pentaho BI: Pentaho Data Integration/Kettle, Pentaho Meta Data, Pentaho Report Designer and Pentaho Analysis Tool, Pentaho BI Server

Database: MySQL, Vertica, MongoDB, Redshift, Oracle 12c/11g/10g, Oracle EBS 11i, SQL Server 2016/2014/2012/2008 , DB2 9.7 FP1, MySQL, MS Access Sybase 15.x, Pentaho Mondrian OLAP Server

ETL/Reporting Tools: Server Reporting Services (SSRS), DB2, SQL Server, MySQL, Pentaho Kettle, Crystal Reports, Tableau, Spotfire.

FTP Tools: FileZilla, Putty, CuteFTP, WinSCP

Modeling Tools: E/R Studio, Visio, Erwin 4.1, Visual Paradigm

Query Tools: Toad, SQL Plus, SQL Developer, SQL Server Management Studio.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

ETL/Pentaho Developer

Responsibilities:

• Configured and installed Pentaho Data Integration Server 8.0 hierarchically from development to production servers.
• Knowledge of integrating Repository in to store Pentaho ETL jobs and Reports.
• Expertise in using Pentaho Data Integration Designer 8.0 to create all ETL transformations and jobs.
• Knowledge of using Eclipse IDE to create java plugins to work with Pentaho jobs and transformations.
• Created seeding documents for application servers to access DB servers, to maintain and comply with organizational security standards and Created RPM spec files to deploy the pentaho jobs on the servers hierarchically.
• Implementation of security in Pentaho reports giving the permission to access the data only for the specific users.
• Given and maintained the support for deployed pentaho reports during their runs on QA, UAT and production environments.
• Designed various SQL queries to extract data as per the project’s requirements.
• Designed and Developed code to extract data from Oracle EBS.
• Communicated with stakeholders of the project and created technical specifications and use cases for the project.
• Have jobs ran by Unix and have done in it off server.
• Tuned queries using Query Optimization techniques.
• Created Production Release documents and user manuals for end users to educate about reports execution.
• Used pentaho data integration to replace previously existing stored procedures and packages with pentaho jobs, thus decreasing their daily runtimes.
• Identify and analyze data discrepancies and data quality issues and works to ensure data consistency and integrity.
• Made use of different transformations in PDI designer to cleanse and manipulate source data e.g. Database Lookup & Join, generate rows, Calculator, Row normalizer & de-normalizers, Java Script, add constant, Add Sequence etc.
• Converted Abstract specification in executable java code, and performed unit and integrated testing of different modules.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Design Studio, Pentaho Report Designer, Pentaho Dashboard Designer, Pentaho Business Analytics, Java, Oracle 11g, Oracle EBS, Oracle SQL Developer, SQL Profiler, Linux, HP automation server, Eclipse, RPM packaging, Unix.

Confidential, Houston, TX

ETL/Pentaho Developer

Responsibilities:

• Coded several database Stored Procedures, Functions, Packages and Triggers in PL/SQL, and maintained Integrity Constraints.
• Provide enhancements and maintenance support to current application.
• Designed pilot system using Pentaho Kettle for ETL enhancements and Pentaho BI Server for publishing the Pentaho Reports on user funds transfer measures.
• Used various types of inputs and outputs in Pentaho Kettle including Database Tables, MS Access, Text Files, Excel files and CSV files.
• Implemented miscellaneous transformations in Kettle Spoon Designer including Database Lookup, Database Join, Calculator, Generate Rows, Mapping Transformation, Filter Rows, Dimension Lookup/Update, Add Sequence, Add Constants, Row Normalizer and Demoralizer.
• Developed SSIS Packages to generate the reports in Excel sheets required by the managers for analysis.
• Created SSIS package to get data from different sources, consolidate and cleanse the data and merge it into one single source.
• Designed Data warehouse including star schema design, DW capacity planning, MySQL performance and tuning.
• Implemented Orders and Points DW using star schema, Orders and Points Business domain using Pentaho Meta Data.
• Created Stage based DW supported by that’s completely implemented in Pentaho Kettle.
• Participated in design ofStaging DatabasesandData Warehouse databaseusingStar Schema.
• Successfully converted all database code including stored procedures, functions and triggers written in PL/SQL into T-SQL to be created in new system running on SQL Server Database.
• Involved inperformance tuningofSQL queriesand stored procedures usingSQL ProfilerandIndex Tuning Wizard.
• Identified, tested, and resolveddatabase performance issues(monitoring and tuning) to ensure database optimization.
• Created several SSIS packages in Business Intelligence Development studio (BIDS) to extract data from OLTP systems and load into staging databases.
• Created triggers on master data tables in OLTP to keep track of insertion and updates.
• CreatedProfiling, Cleansing and auditingplans withSSISPackages.
• AppliedConfiguration, Logging, Error reportingto all packages to make package deployment easy and troubleshoot package on run time.
• Load data in Data ware House by usingSlowly Changing Dimension (SCD - Type 1, 2, 3)
• Useevent handling to send E-mail on eventlike on error.
• UseData Viewersin SSIS Packages to check the flow of data during Execution of Packages
• Generated reports usingSSRSthat could be used to send information to different managers of Different Branch.
• Actively participated in all phases of system development life cycle (SDLC) starting from requirement gathering all the way up to deployment in production and system testing.
• Prepared user manual and technical support manual
• Created different type of reports includingCross-tab, Tabular, Charts, graphs, Sub reports, Drill-down reports with Cascading Parameter prompts.
• Performed SQL Server installation in Share-Point Integrated mode.
• Deployed SSRS reports on Report Server using Report Manager, as well on SharePoint Server.
• Generated the various kinds of reportsusing Graphs and Images
• Deployed SSRS reports using Report Manager and scheduled the reports to generate all daily, weekly, monthly and quarterly Reports including current status.
• Utilized Dynamic SQL in stored procedures to generate the query dynamically within the procedure using parameter values to make up the query.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Design Studio, Pentaho Report Designer, MS SQL Server,SQL Server Integration Services (SSIS), Oracle 10g,Enterprise ManagementStudio

Confidential, Plano, TX

Pentaho/BI SQL developer

Responsibilities:

• Created user accounts in Pentaho Enterprise Console for end users/Business Analysts who were supposed to view the reports using Pentaho User Console.
• Created mapping documents to define and document one-to-one mapping between source data attributes and entities in target database.
• Used Pentaho Data Integration Designer 4.1 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
• Identify and analyze data discrepancies and data quality issues and works to ensure data consistency and integrity.
• 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.
• Used Pentaho Report designer to create various reports having drill down functionality by creating Groups in the reports and drill through functionality by creating sub-reports within the main reports.
• Created various types of chart reports in Pentaho Business Analytics having Pie Charts, 3D Pie Charts, Line Charts, Bar Charts, Stacked Bar Charts and Percentage Bar charts.
• Created single value as well as multi-value drop down and list type of parameters with cascading prompt in the reports.
• Implemented security in Pentaho reports by assigning permission to specific users to view the reports.
• Implemented data level security by creating database tables to store usernames, user groups and their allowable permissions, and joined those tables in the report queries to make sure each user should be able to see only the permissible data.
• Deployed reports on Pentaho BI Server to give central web access to the users.
• Created several dashboards in Pentaho using Pentaho Business Analytics Platform.
• Used Pentaho Schema Workbench to create Cubes, Dimensions and fact tables in Pentaho.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Metadata Editor, Pentaho Design Studio, Pentaho Report Designer, Pentaho Dashboard Designer, Pentaho Business Analytics, Java, MySQL, Oracle 10g, Oracle SQL Developer, SQL Profiler, Windows Server 2008/XP 64-bit Edition, Linux.

Confidential, Pittsburgh, PA

ETL/Pentaho Developer

Responsibilities:

• Worked with business users/Analytics team, data architects to identify the business requirements and developed designed document for ETL flow, analysis of database architecture, created various complex Pentaho Transformations and Jobs using PDI Spoon.
• Involved in building Data warehouse whose primary source of data comes from external vendors and corporate sources which includes the data from various source system like Oracle 10g, Flat files, and Microsoft Excel file, XML files.
• Involved in the ETL design and its documentation.
• Participated in design of Staging Databases and Data Warehouse/Data marts using Star Schema/Snowflakes schema in data modeling.
• Imported bulk data in Oracle tables from data files of fixed record, variable record and stream record format using SQL Loader.
• Created and executed SSIS packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SSIS.
• Actively Participated in developing logical model and implementing requirements on SQL Server 2005.
• Implemented complex conceptual database design into SQL Server 2008 using various constraint and triggers.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation and data extraction.
• Interaction with business and technical teams across geographic boundaries, with clients, technical architects, project managers, requirements analysts and testing teams.
• Used Workflow Manager to create different tasks, set task properties, Workflows, Worklets to run the logic embedded in mappings.
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Oracle PL/SQL, Toad, SQL Loader, Oracle SQL Developer, SSIS, Oracle Enterprise Manager, SQL Server 2008/2012, SQL Agent, Visio, Erwin, HP-Unix, Linux, Windows XP/Vista/2003 Server.