SUMMARY

• An IT professional wif 6+ years of experience in Data warehouse/ETL using Pentaho Suite (Pentaho Data Integration/Kettle, Pentaho BI Server, Pentaho Analysis Tool).
• Good understanding of teh Data Warehousing SDLC architecture, ETL framework and BI Integration using Pentaho Reports & Pentaho Dashboards.
• Experience in requirement gathering, feasibility study and technical/functional documentation for database.
• ETL experience using Pentaho Kettle/Spoon, Data Stage 9.1 and Informatica Power Center 9.6.1.
• Developing reports based on data - marts generated using data integration tools like Kettle.
• Good Understanding knowledge in Data warehousing Concepts, Star Schema and Snowflakes Schema methodologies, understanding business process/requirements.
• Experience on teh complete Software Development Life Cycle (SDLC) and Project Life Cycle.
• Experience in creating, debugging Stored Procedures, Functions, Triggers and Object Types in PL/SQL Statements.
• Experience in different Databases like Oracle 10g, SQL Server 2012/2008 and MySQL.
• Solving debugging issues on Pentaho kettle, Data Stage code, and Informatica by fixing errors in teh mappings.
• Experience in BMC software/Remedy Ticketing tool 9.1.04.
• Experience in working wif Application Server such as Apache Tomcat 5.5/4.x.
• Good team player and capable of working individually wif less supervision.
• Good technical background, analytical ability & problem solving skills, communication and interpersonal skills.
• Ability to interact wif individuals at all levels and can work as a part of a team as well as independently.

TECHNICAL SKILLS

Pentaho Suite: Pentaho Data Integration (Kettle), Pentaho BI Server, Pentaho Report Designer, Pentaho Dashboard Designer and Pentaho Analysis Tool.

Tools: Pentaho, Informatica.

Servers: Application Server (Tomcat), Web Server (Apache).

Programming & Languages: Java script, CSS, XML, HTML, JAVA.

Database Tech: Oracle, (PL\SQL), MS-SQL, DB2, MySQL Server.

Operating Systems: Windows, Linux.

PROFESSIONAL EXPERIENCE

Confidential - Austin, TX

ETL/Pentaho Developer

Responsibilities:

• Analyzed requirements and implemented efficient, scalable ETL processes using Pentaho spoon.
• Developed ETL processes to load data into a configuration management database built upon BMC software technologies in a SQL Server environment.
• Extracted data from various data sources including Excel, Flat files and XML using multiple transformations and Jobs.
• Built transformations which involve configuring teh steps like Add constants, Filter, CSV file input, Table input, Insert/Update, AR Input, AR Output, Stream lookup, Merge rows, Switch, Calculator, Database Lookup & Set Environment Variables.
• Implemented AI/spoon code to run teh query and return teh data.
• Updated interface by modifying existing feed to validate if files exists before running through email notification.
• Built spoon utility to set and update teh fields to default in BMC Computer Systems.
• Established new interface by importing Aruba devices into CMDB.
• Built emergency spoon transformation to set teh relationships using Excel files as input.
• Built utility to modify inbound feeds to set teh fields in Computer system.
• Designed teh transformation to get teh data from servers through web service calls to flat files.
• Monitoring teh execution of Jobs in Pentaho Data Integration by scheduling through Atrium Integrator console.
• Configuring teh error handling for transformation steps.
• Used Remedy Asset tool to find out CI/APP CIs to work.
• Experience in Creating, Solving and assigning CRQ, INC’s and Work Orders to different groups.
• Experience in Creating Test plans like Implementation & Certification plans along wif Backout plan before getting into production.
• Worked as a part of CMDB Support and Development Group.

Environment: PDI 7.1, Microsoft SQL Server Management 2012, BMC Remedy 9.1.04, Atrium Integrator Console, UNIX, Postman API.

Confidential - Plano, TX

Pentaho BI Developer

Responsibilities:

• Requirements Gathering, Analysis, Design, Build and development of teh project.
• Loading teh data into target data warehouse by using Pentaho Data Integration/Kettle to design all ETL processes by extracting data from various sources including live system and external files.
• Created transformations dat involve configuring teh following steps: Table input, Table output, Text file output, CSV file input, Insert/Update, Add constants, Filter, Value Mapper, Stream lookup, Join rows, Merge join, Sort rows, Database Lookup, Set Environment Variables.
• Attended various agile-ceremonies.
• Participated in design ofStaging DatabasesandData Warehouse databaseusingStar Schema.
• Resolveddatabase performance issues by monitoring and tuning to ensure database optimization.
• After Publishing cubes and reports onto Pentaho repository & refreshing Pentaho BI repository after uploading each object to be available for central use.
• Also used Pentaho Enterprise Repository to: create folders, store transformations and jobs, move, lock, revise, delete, and restore artifacts.
• In order to educate about execution of BI reports prepared mapping document for ETL and user manuals for end users.
• Configuring teh error handling for transformation steps.
• Using transformation steps to perform different calculations on teh data stream.
• Environment variables and parameterized values are created by reusable transformation.
• Cleanse and correct data Using Pentaho Data Integration.
• Configuring teh logging for transformation steps and for job entries and also examine teh logged data.
• Monitor teh execution of a transformation in Pentaho Data Integration by Scheduling through teh Pentaho Enterprise Console.
• Worked wif Pentaho Data Integration jobs dat: run multiple transformations, use variables, contain sub-jobs, provide built-in error notification through emails, load and process multiple text files, and convert files into Microsoft Excel format.
• Pentaho Reporting: Used query design tools to write queries for reporting by Connecting to data sources.
• Used free hand SQL and stored procedures Created complex reports by linking data from multiple data providers.
• Formatted report elements and applied conditional formatting to report elements.
• Hyperlinks and Parameters Added to reports.
• To build metadata model and domains used Pentaho Metadata Editor.
• Schema Workbench used to create cubes for Pentaho Analyzer, star schema wif hierarchies, levels and calculate members.

Environment: PDI 6.0, MySQL, Pentaho Kettle, Pentaho Report Designer, Schema Workbench, Pentaho Analyzer, Pentaho Enterprise Console, Pentaho User Console.

Confidential, Rancho Cordova, CA

Pentaho BI Developer

Responsibilities:

• Installed and Configured PDI 5.3 along wif Enterprise Repository in Pentaho BI server.
• Requirement gathering by understanding business Processes and needs.
• Provide analysis and development support for ETL and data integration initiatives.
• Worked very closely wif Project Manager to understand teh requirement of reporting solutions to be built.
• Worked wif business users/analytics team, data architect to identify teh business requirements and designed ETL flow, data architecture and created various complex Pentaho Transformation and Jobs using PDI Spoon.
• Configured Pentaho BI Server for report deployment by creating database connections in Pentaho enterprise console for central usage by teh reports deployed in teh repository.
• To maintain Parent- Child relationship Implemented Logic wif Database lookup table and maintained hierarchy.
• Used bunch of Pentaho transformations including Row Normalizer, Row Demoralizer, Database Lookup, Database Join, Calculator, Add Sequence, Add Constants and various types of inputs and outputs for various data sources including Tables, Access, Text File, Excel and CSV file.
• Also applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time.
• Using a Pentaho Report Developed complex custom reports which includes Designing, developing Business Views, Cascading pick-lists, Drill-through, Hyperlinks, sub-reports etc., functionality into these reports.
• Involved wif Performance manager to create various metrics, Analytics and used Dashboard Manager to build corporate dashboards.
• Worked closely wif DBA team to regularly monitor system for bottlenecks and built appropriate solutions.
• Sharing Knowledge about teh Pentaho BI tool across all team members.
• Troubleshoot BI tool problems and provide technical support as needed.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support using Pentaho Data Integration.

Environment: PDI 5.3, Pentaho Report Designer, Pentaho Data Integration and MySQL Server.

Confidential

ETL Developer

Responsibilities:

• Worked wif teh Business analysts and teh DBAs for requirements gathering, analysis, testing, metrics and project coordination.
• Worked on Data StageDesigner, Manager, Administrator and Director.
• Created ETL Job flow design.
• Createdlocal and shared containersto facilitate ease & reuse of jobs.
• Make use of ETL to load data into teh Oracle warehouse.
• Involved in extracting teh data from different data sources like Oracle and flat files.
• Designed various standard/reusable jobs in Data Stage using various active and passive stages like Sort, Lookup, Filter, Join, Transformer, aggregator, Change Capture Data, Sequential file, Datasets.
• Involved in creating and maintaining Sequencer and Batch jobs.
• Involved in development of Job Sequencing using theSequencer.
• Worked wif database objects including tables, views, indexes, schemas, PL/SQL packages, stored procedures, functions, and triggers.
• Make use of Remove Duplicates stage to remove teh duplicates in teh data.
• Used designer and director to schedule and monitor jobs and to collect teh performance statistics.
• Build teh underlying logic for Slowly Changing Dimensions.
• Worked wif Developers to troubleshootand resolve issues in job logic as well as performance.
• Involved in migrating code from Development to QA.
• Used PL/SQL procedures to fill teh gaps by defining teh business needs for all teh interfaces.
• Written ETL validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Environment: Data Stage 9.1, PL/SQL (Stored Procedures, Trigger), Windows XP, UNIX, SQL server.