PROFESSIONAL SUMMARY:

• Skilled software professional with 3+ years of experience in creating OLTP and OLAP Data ware house using Pentaho Suite (Pentaho Data Integration/Kettle and Pentaho Analysis Tool) versions 5.4/4.4/4.2 on Linux and Windows platform
• Experienced in developing BI Reports and Dashboards using Tableau and Pentaho Report Designer.
• Worked on the complete Software Development Life Cycle (SDLC)
• Hands on experience working on various Informatica Suites and Informatica Power Centre Tool
• Experience working in On Shore/ Off Shore Company model
• Hands on experience working on Data Warehousing concepts related to Kimball methodologies
• Clear Understanding of Healthcare and Insurance Databases
• Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools
• Proficient in writing T - SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors and Query Optimization
• Experience in converting stored procedures, functions and triggers written in PL/SQL code into T-SQL
• Hands on experience on the whole ETL (Extract Transformation & Load) process
• Tested several complex reports generated by Micro Strategy including Dashboards, Summary Reports, Master Detailed, Drill down
• Extensive experience in Functional Testing, System Testing, Integration Testing, Regression Testing, Performance testing and User Acceptance Testing
• Involved in all the phases of Software Testing Life Cycle
• Experience with test plans, test cases, test scripts and customizing test data
• Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills

TECHNICAL SKILLS:

Database: SQL Server 2014/ 2008/2005/2000, Oracle 9i, MySQL, MSSQL, Microsoft Access

Tools: Toad, Oracle SQL Developer, SQL Plus, Oracle Enterprise Manager, SQL Server Management Studio, SQL Profiler, SSIS, Informatica Power Center 9.1, SAS EM, SAS EG, Rational Rose, Visual Studio, ALM

Pentaho Suite: Pentaho Data Integration (Kettle) 5.4, Pentaho BI Server, Pentaho Analysis Tool, Pentaho Report Designer

Reporting Tools: Tableau, SSRS, Crystal Reports, MS Access, MS Excel

Languages: T: SQL, SQL, Python, R, Java, Visual Basic 6.0

Operating System: Windows 2000/ 2003 Server/ Win XP/Vista/7, Unix, Red Hat Linux

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

ETL Consultant

Responsibilities:

• Extensively worked with Business Users in gathering requirements and actively cataloging and supporting various issues and providing their solution.
• Used bunch of transformations in 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.
• Participated in design of Staging Databases and Data Warehouse/Data mart database using Star Schema/Snowflakes schema in data modeling.
• Troubleshoot BI tool problems and provide technical support as needed. Perform other tasks as assigned.
• Worked very closely with Project Manager to understand the requirement of reporting solutions to be built.
• Gathered business requirement by understanding business Processes and needs.
• Used Pentaho Import Export utility to Migrate Pentaho Transformations and Job from one environment to others.
• Prepared ETL (Extract, Transform and Load) standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Implemented Logic with Database lookup table to maintain Parent- Child relationship and maintain hierarchy.

Confidential .

Mountain View, CA

Technical Intern

Responsibilities:

• Actively Participated in developing logical model and implementing requirements on SQL Server 2012.
• Implemented complex conceptual database design into SQL Server 2012 using various constraint and triggers.
• Implemented complex business requirement in Oracle Production databases using efficient PL/SQL stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Used Oracle Enterprise Manager for troubleshooting, monitoring, and optimizing of Oracle Production and non-production database code as well as PL/SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating new logins and users, changing the roles of the users.

Confidential

Student Assistant/System Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Confidential

Data Analyst

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.
• Participated in design of Staging Databases and Data Warehouse/Data marts using Star Schema/Snowflakes schema in data modeling.
• Used Pentaho inbuilt Change Data Capture utility ( Confidential ) to get the data from source system/ Load data into Data Mart(DM)
• Created Database logging for each Transformation/Jobs into ETL PDI TRANS and setup Email notification failure on each Component level.
• Implemented Logic with Database lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Used transformation component like Merge Join, database Join, XML components to load XML files.
• Use Pentaho Import Export utility to Migrate Pentaho Transformations and Job from one environment to others (DEV/QA/PREPROD/PROD).
• Created Transformations/Jobs to take daily back up Enterprise repository for DEV/QA/PREPROD/PROD.
• Used Oracle Connection managers to configure database connections for Oracle 11g and Data Warehouse Databases.
• Worked with team members to tune the SQL queries. Created necessary Index/Partition on huge fact tables for getting a better performance in ETL
• Automated file transfer processes and mail notifications by using FTP Task and Send Mail task in Transformations
• Implementing and maintaining database security (Create and maintain users and roles and Login access, assign privileges) to each schema level permission.
• Providing Production support to operational team for daily/weekly/Monthly job failure in Production environments.
• Created deployment documentation with the help of other users and operational team to deploy the new release in Production environment

Environment: s: Oracle 11g/10g, Pentaho Data Integration Spoon 4.4.0/4.2.0/4.1.2, PL/SQL, Pentaho Enterprise console, SQL server 2008, My-SQL