SUMMARY

• 8+ years of IT experience in Data Warehousing, ETL, BI and Big Data
• Skilled in full life cycle including project scoping, requirements gathering, systems analysis, design, development, testing, implementation and maintenance
• Proven skills in AWS Redshift, Oracle PL/SQL, PostgreSQL including writing queries, stored procedures, functions and triggers
• Expertise in Data Extraction, Cleansing, Transformation, Integration, Data Analysis, Logical/Physical Relational/Dimensional Database Modeling & Designing
• Active team player and self - motivated with passion for technology and data

TECHNICAL SKILLS

BI Tools: Pentaho, Informatica, Data Pipeline, SAP, SSIS

Databases: Redshift, Oracle, SQL Server, Postgresql

Reporting Tools: Tableau, Pentaho, SSRS, QlikView, SAP BO

Languages: Java, T-SQL, PL/SQL, MySQL, C++, Shell

Operating System: Windows, Mac, Linux

PROFESSIONAL EXPERIENCE

Confidential - Austin, Texas

Data Consultant

Responsibilities:

• Configured AWS environment to extract data from various sources and loaded the data in Redshift using distribution and sorting.
• Utilized SQL to pull data from various databases and created various dashboards, scorecards and reports to support business decision making.
• Actively interacted with business stakeholders, sponsors and client partners for Business Analysis & requirement collection.
• Exported the analyzed data into relational databases using data pipeline for visualization and to generate reports for the BI team.
• Developed ETL process using Pentaho PDI to extract the data from various data sources and populated it in to our BI data warehouse.
• Worked with analysts to understand and build complex business logic, cleaned up and standardized data to create meta tables, fact tables, dimension tables and detailed data marts, applied business rules during the process to derive valuable business information.
• 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 & demoralizers, Java Script, add constant, Add Sequence, Get & Set Variables etc.
• Used Kettle to build the ETL process from data sources to data mart, as well as scheduled the transformations and jobs.
• Performance tuning of slowly running transformations and jobs, Redshift SQL Queries & Stored procedures.
• Designed project through the SDLC process, with best practices and trends in the field of BI and Data Warehousing to help shape company’s BI strategy and solution designs.
• Created deployment documentation with the help of other users and operational team to deploy the new release in Production environment

Environment: Amazon Redshift, Oracle, Pentaho, Tableau

Confidential - Austin, TX

ETL Developer

Responsibilities:

• Installed and Configured Pentaho BI Suit along with Enterprise Repository in Pentaho BI server.
• Configured Pentaho BI Server for report deployment by creating database connections in Pentaho enterprise console for central usage by the reports deployed in the repository.
• Coded several database Stored Procedures, Functions, Packages and Triggers in PL/SQL, and maintained Integrity Constraints.
• Designed automation system using Pentaho Kettle for ETL enhancements and Pentaho BI Server for publishing the Pentaho Reports on user funds transfer measures.
• Identify, document and communicate BI and ETL best practices and industry accepted development methodologies and techniques.
• 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.
• Used different components in Pentaho like Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support using Pentaho Data Integration.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Report Designer, Pentaho Dashboard Designer, MySQL, Postgress

Confidential - Salt Lake City, UT

Sr. Pentaho / ETL Engineer

Responsibilities:

• Participated in cost and schedule estimations of software, database, tools and platforms.
• Influence the BI tool decisions and process design. Assist creation of conceptual, logical, and physical models for data analysis and modeling to help develop a strategy and plan for transition management.
• Participated in design of Redshift Staging Databases and Data Warehouse/Data mart.
• Automated data transfer processes and mail notifications by using FTP Task and send mail task in Transformations.
• Performed advanced-level business system analysis. Worked closely with product owners and analysts to understand and translate requirements into design.
• Helped company refine the process for intake, prioritization, routing, and estimation of BI development requests from the business.
• Using the data Integration tool Pentaho for designing ETL jobs in the process of building Redsfift Data warehouses.
• Used various types of inputs and outputs in Pentaho Kettle including Database Tables, MS Access, Text Files, Excel files and CSV files.
• Responsible for creating database objects like table, views, Functions etc. using Redshift SQL to provide structure to store data and to maintain database efficiently.
• Involved in optimizing code and improving efficiency in databases by re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Created web based reports and dashboards using Report Designer. Presented weekly/monthly reports and dashboards to management team and cross-functional stakeholders.
• Involved in administration tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.

Environment: AWS S3, EC2, EMR, Redshift, Postgresql, NetBeans-Java, Shell, SQLWorkbenchJ, Pentaho, Tableau, QlikView

Confidential - San Fransisco, CA

BI / ETL Developer

Responsibilities:

• Interaction with business and technical teams across geographic boundaries, with clients, technical architects, project managers, requirements analysts and testing teams.
• Provided production support for the production database and also to the code deployed into the production environment.
• Provide analysis and development support for ETL and data integration initiatives
• Worked with business users/analytics team, data architect to identify the business requirements and designed ETL flow, data architecture and created various complex Pentaho Transformation and Jobs using PDI Spoon.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support using Pentaho Data Integration.
• Identify, document and communicate Redshift and ETL best practices and industry accepted development methodologies and techniques.
• Worked very closely with Project Manager to understand the requirement of reporting solutions to be built.
• Implemented Logic with Database lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time.
• Worked on Performance manager to create various metrics, Analytics and used Dashboard Manager to build corporate dashboards.
• Working closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Environment: Pentaho BI Server, Pentaho Data Integration, SSIS, Redshift, SQL Server, Shell, Unix, SQL profiler, XML, SSRS, Tableau

Confidential

ETL / BI Engineer

Responsibilities:

• Actively participated in requirements gathering & preparing detail Technical design by understanding BRD’s.
• Developed Technical Proof of Concept (POC) for critical functional areas.
• Involved in creating Different types of report using Tableau.
• Created Dashboard to have overall picture of business area for higher management.
• 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 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 with only limited changes
• Worked closely with the Testing Team to work towards Zero Defects.

Environment: Oracle, Pentaho Data Integration Spoon, Oracle Toad, PL/SQL, Pentaho Enterprise console, Linux, Windows, Pentaho BI Server, Shell, Tableau

Confidential

BI/SQL Developer

Responsibilities:

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

Environment: PL/SQL, SQL Loader, Toad, Oracle SQL Developer, SSIS, Unix, Windows Server, SQL Server, Management Studio, Visio, MS Excel, VB.Net, ASP.Net