SUMMARY:

• Business Intelligence Developer with 7+ years of overall professional experience with acquired skills, intellectual curiosity, and the ability to mine hidden gems located within large sets of structured, semi - structured and unstructured data.
• 2+ years of experience in Oracle PL/SQL development and 5+ years of experience in Data Warehousing, ETL and Business Intelligence experience using Pentaho BI Suite (Pentaho Data Integration/Kettle, Pentaho BI Server, and Pentaho Analysis Tool & Mondrian OLAP).
• Experience in designing, modeling, performance tuning and analysis, implementing processes using ETL tool Pentaho data Integration (PDI) tool for Data Extraction, transformation and loading processes. Designing end to end ETL processes to support reporting requirements. Designing aggregates, summary tables and materialized views for reporting.
• Expertise in developing Data Warehouse architecture, ETL framework and BI Integration using Pentaho Reports and Pentaho Dashboards.
• Extensive knowledge with Logical/Physical Relational/ Dimensional data modeling, star schema, snow flake schema, Fact and dimensional tables.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Skilled in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, MySQL, flat file, Text Format Data).
• Experience in using Pentaho report Designer to create pixel-perfect reports of data in PDF, Excel, PL/SQL, SQL, T/SQL, JavaScript, HTML, Text, Rich-Text-File, XML and CSV.
• Good Experience in creating cubes by using Pentaho Schema Workbench.
• Experience in designing Database Models using Microsoft Visio and creating class diagrams, activity diagrams, use cases diagrams, sequence diagrams and flow charts.
• Experience in creating various types of chart reports in Pentaho having Pie Charts, 3D Pie Charts, Line Charts, Bar Charts, Stacked Bar Charts and Percentage Bar charts.
• Experience in writing shell scripts for various ETL needs.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and Arrays), Records, Object types and Database Triggers.
• Excellent working knowledge in BI Analytics, Data Warehousing Models, Oracle, SQL, MySQL.
• Strong experience in SQL Server with Business Intelligence in SQL Server Integration Services (SSIS).
• Strong Knowledge & experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support.
• Strong data analytical and debugging skills to ensure accuracy and data integrity.
• Ability to adapt quickly to different project environments, work in teams and accomplish difficult tasks independently within time frame. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
• Experience working in Agile Methodology and ability to manage change effectively.
• Excellent communication skills and problem solving skills.

TECHNICAL SKILLS:

Tools: Pentaho Data Integration (Kettle), Pentaho BI Server, Pentaho Analysis Tool, Pentaho Report Designer, Pentaho Dashboard Designer, Pentaho Schema Workbench, Pentaho CDE.

Database: SQL Server, Oracle 9i, Oracle 10g, Oracle 11g, MySQL, DB2.

JAVA, SQL, PL/SQL, T: SQL, C/C++.

Web Technologies: HTML, HTML5, CSS, XML, Java Script.

Operation Systems: Windows XP/7/8/10, Unix, Linux.

PROFESSIONAL EXPERIENCE:

Pentaho Developer

Confidential, Iowa City, IA

Responsibilities:

• Installed and Configures Pentaho BI suite 4.4 along with Enterprise Repository in Pentaho BI server.
• Worked with business analytics team to identify and gather the requirements.
• Created various Pentaho Transformations and Jobs using PDI Spoon.
• Troubleshoot BI tool problems and provide technical support as needed.
• Used Pentaho Report Designer to design various reports having drill down functionality by creating groups in the reports and drill through functionality by creating sub-reports within the main reports.
• Creating Cube for analysis and interactive reporting, using Schema Workbench.
• Responsible for developing, support and maintenance for the ETL processes using Pentaho PDI.
• Migrating Pentaho Transformations and Jobs from one environment to others by using Pentaho Import/Export utility.
• Used Mapping Parameters and Variables to implement object orientation technologies and facilitate the reusability of code.
• Improved the performance of Pentaho ETL jobs, reports by understanding bottle neck operations.
• Designed and developed UNIX shell Scripts to handle pre and post session processes and also for validation the incoming files.
• Developing the SQL scripts and creating Oracle Objects like tables, Views, Materialized Views, Indexes, Sequences, Synonyms and other Oracle Objects.
• Performed Data cleaning by creating tables to eliminate the dirty data using SSIS.
• Performed various kinds of testing like Unit testing, Regression testing and system test in Dev, QA environments before Deployment.
• Developed Audit Strategy to validate the data between Source and Target System.

Environment: Pentaho BI Server, Pentaho Report Designer, Pentaho Dashboard Integration Spoon 5.4.0/4.4.0/4.2.0, MapReduce, SQL Query Analyzer, MySQL, Sun Solaris, Shell Scripting.

Pentaho Developer

Confidential, Orange County, CA

Responsibilities:

• Installed and configured Pentaho Data Integration Server 4.1 hierarchically from development to production servers.
• Created enterprise repository in Pentaho BI server to store Jobs and Reports.
• Used various types of inputs and outputs in Pentaho Kettle like Database tables, MS Access, Excel files, CSV files, Text files.
• Used Pentaho Data Integration Designer 4.1 to create all ETL transformations and jobs.
• Saved Pentaho jobs in repository and scheduled them to run on daily basis.
• Identified and analyzed data compatibility and data quality issues and works to ensure data consistency and integrity.
• Used Pentaho Report designer to create various reports.
• Implemented Slowly Changing Dimensions Type 1 and Type 2 in ETL jobs for certain dimensions.
• 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.
• Created several dashboards in Pentaho using Pentaho Dashboard Designer.
• Designed Data warehouse including star schema design, DW capacity planning, performance and tuning.
• Ran MySQL Import/export to load data between DEV and TEST Servers.
• Converted Abstract specification in executable java code, and performed unit and integrated testing of different modules.
• Created seeding documents for application servers to access DB servers, in order to maintain and comply with organizational security standards.
• Created single value as well as multi-value drop down and list type of parameters with cascading prompt in the reports.
• Implemented security and permissions for enrolled users on different reports in Enterprise Console.
• Published cubes and reports onto Pentaho repository and refreshed Pentaho BI repository after uploading each object to be available for central use.
• Tuned report queries running against Oracle database to get optimal performance.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Design Studio, Pentaho Report Designer, Pentaho Dashboard Designer, Pentaho Analyzer, Java, MySQL, Oracle 10g, Oracle SQL Developer, SQL Profiler, Windows Server 2008/XP.

Pentaho Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Installed and Configured Pentaho BI Suit along with Enterprise Repository in Pentaho BI server.
• Used Pentaho Enterprise Repository to create folders, store transformations and jobs, move, lock, revise, delete, and restore artifacts
• Used Pentaho Data Integration to design ETL processes to extract data from various sources, cleanse and load the data into target data warehouse.
• Used various types of inputs and outputs like Database Tables, Text files, MS Access, MS Excel, CSV files.
• Developed SSIS packages to generate reports in Excel sheets for analysis.
• Implemented Database Stored Procedures, Packages, Triggers in PL/SQL, Functions and maintained Integrity Constraints.
• Created SSIS package to get data from different sources, cleanse the data and merge into one single source.
• Used SQL queries in the Pentaho Interface.
• Implemented Orders and Points DW using star schema, Orders and Points Business domain using Pentaho Meta Data.
• 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.
• Converted all database code like stored procedures, functions, triggers written in PL/SQL into T-SQL.
• Created different type of reports including Cross-tab, Tabular, Charts, graphs, Sub reports, Drill-down reports with Cascading Parameter prompts.
• 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.
• Responsible for tuning ETL procedures and STAR Schema and Snow flake Schema to optimize load and query performance.
• Provide analysis and development support for ETL and data integration initiatives.

Environment: Pentaho BI Server, SQL Server 2008, Pentaho Data Integration, Pentaho Kettle, Pentaho Report Designer, Schema Workbench, Pentaho Analyzer, Pentaho Enterprise Console, Pentaho User Console, Windows Server 2008/2003, SQL Server Management Studio.

Pentaho Developer

Confidential, NJ

Responsibilities:

• Used various types of inputs and outputs in Pentaho Kettle like Database tables, Text Files, Excel Files and CSV Files.
• Designed and implemented Change Data Capture (CDC) processes for Fact tables and Dimension tables through a combination of Time Stamps, staging and bridge tables.
• Extensively worked in fixing poorly designed mappings and developed schedules to automate the Pentaho Transformations and Jobs.
• Designed Business Intelligence Platform from the scratch and integrated it with upstream systems using Hadoop and other Big Data component for various functionalities.
• Used various in-built components like Select, add sequence, add constant, value mapper, row flatter, row normalizer, string cut, unique rows, split field, concat fields, add a checksum, replace, etc.
• Used various inbuilt components to create jobs like Get files from result, get rows from result, set variables, get variables.
• Used lookup components like stream lookup, fuzzy match, check if column exists, Call DB procedure, file exists.
• Populating the data into SCDs by using dimension lookup/update step.
• Troubleshoot BI tool problems and provide technical support as needed.
• Automated data transfer processes and mail notifications by using FTP task and send mail task in Transformations.
• Build platform for in memory reporting system to report hdfs and respective sub-projects.
• Implemented database objects like table, views, store procedure, triggers, functions etc, using T-SQL to provide structure to store data and to maintain database efficiently.
• Identify, document and communicate BI and ETL best practices and industry accepted development methodologies and techniques.
• Designed advance reports, analysis reports and Dash Boards using Pentaho report designer.
• Configured Data Integration Server to run the jobs in local, remote server and cluster mode.
• Designed cubes by using Pentaho Schema Workbench.
• Saved Pentaho jobs in enterprise repository and scheduled them to run in production on daily basis.

Environment: Pentaho BI Server, Pentaho Data Integration, PRD, Oracle, T-SQL, SQL Server, Shell, Unix, SQL profiler, XML, SSRS, Java Script, Hadoop.

Oracle PL/SQL developer

Confidential

Responsibilities:

• Involved in gathering business requirements.
• Analysis of Sources data, analyzing the Oracle Source Objects and identifying the method for migrating data to target.
• Performed design, coding, implementation and support.
• Involved in implementing business logic with Oracle-stored procedures, functions and triggers using PL/SQL.
• Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
• Worked with Architects, Business Analysts, ETL developers, and QA testers to translate data requirements into the physical schema definitions for Oracle.
• Responsible for decreasing Load times of Data Warehouse by optimizing ETL procedures using PL/SQL.
• Created PL/SQL Procedures using Execute Immediate, Bulk Collect for better performance.
• Defect resolution and Bug Fixing from the code logic using Oracle SQL Developer IDE.
• Loading data from flat files into Oracle tables using SQL Loader, and PL/SQL procedures.
• Creating new process flow using SQL scripts to extract, transform and load the data from different databases to Oracle.
• Created and Modified existing functions and procedures based on business requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE.
• Writing database objects such as functions, stored procedures, packages and triggers to meet the functional requirements using PL/SQL.
• Extensively used JavaScript for Server-side and for client-side validations.
• Worked extensively on tuning SQL queries and database modules for optimum performance.
• Developed batch jobs by using PL/SQL and Shell scripts.

Environment: Oracle 11g, PL/SQL, Stored Procedures, Packages, Triggers, REF Cursors, JAVA, Eclipse, SQL Developer, SQL*Loader, Putty, Unix Shell Scripting, Linux, Windows 7.