SUMMARY:

• 12 years of overall experience in ETL and Data Warehousing applications development using Informatica, Pentaho in UNIX and WINDOWS environment.
• Experience in Informatica, Pentaho server installation, networking and configuration in UNIX and WINDOWS environment.
• Having exposure to reporting tools Pentaho BI, Power BI, Clicdata and OBIEE.
• Design and developed Multidimensional model using Pentaho ETL to grab data from Salesforce and forming data warehouse.
• Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Pentaho 6.0, 7.1. and Informatica Power Center 9.x, 8.x.
• Installation and configuration of all Java components and web servers using Tomcat.
• Exposure to Redshift database and installation of Pentaho in AWS.
• Used java as a supporting platform for all kind of ETL validation and automation.
• Designed XACTION file using Design Studio for various requirements.
• Working knowledge basic in UNIX commands and CRONTAB.
• Involved in Performance tuning of SQL and Pentaho Transformations.
• Strong experience in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow - flake Schema, FACT and Dimension tables), Logical and Physical Data Modeling.
• Experience in code debugging, bug fixing and production support. Excellent written, verbal communication skills, presentation and problem solving skills.
• Excellent team player, quick learner and demonstrated ability to handle multiple deadlines.

TECHNICAL SKILLS:

• Informatica
• SDLC
• SQL
• Stored procedures
• Pentaho DI
• Systems analysis
• Pl/SQL
• Workflow
• UNIX
• Database
• Pentaho BA
• QA
• Python
• Server administration
• Oracle
• Slowly changing dimensions
• ETL
• Apache tomcat
• Informatica powercenter
• Netbeans
• Power BI
• MYSQL
• J2EE

PROFESSIONAL EXPERIENCE:

Confidential, Boston, Massachusetts

ETL and Dashboard Developer

Responsibilities:

• Design and develop ETL to load data from Salesforce to data warehouse.
• Integrate dashboard reports to work on Salesforce platform.
• Design and develop Analyzer and Interactive reports using schema workbench and Metadata editor.
• Custom design for all drill through reports using Java scripts.
• Design multiple reports using Pentaho BI and Power BI tools.
• Develop XACTION to generate UUID to set session level parameter.
• Developed custom JSP access to Pentaho file directory using API.
• Scheduling reports using CDE and Pentaho API.
• Involved while Implementing Redshift as a new component to the existing environment.
• Custom design of drill downs using Java script.
• Implementation of dynamic schema processor for report level security.
• Implementation of multi-level tenancy in Pentaho reports.
• Design views for all complex business logics.
• Support for all defect fixing and testing team.
• Implementation and support for all architectural challenges and development.
• Design integrated report platform use CDE tools.

Technology Used: Pentaho ETL, Power BI server, SQL Server, java, JSP, servlet, Tomcat, Java script.

Confidential

BI Developer | Pentaho | ETL | Dashboard

Responsibilities:

• Used Pentaho DI to transfer data from core to stage to mart.
• Involved in creating various transformation in Pentaho DI to transfer data between stage and mart.
• Developed Automation scripts in java to validate ETL.
• File handling (list, download) in JSP using Pentaho API.
• Design XACTION to run KTR from an API call.
• Setting up Pentaho environment in AWS EC2 Linux Instance including Quartz, JCR, Hibernate.
• Cloud scale performance monitoring in AWS on various factors including RW.
• Created custom java library using core java to implement security in Pentaho multilevel tenancy.
• Involved in troubleshooting and fixing issues related to ETL transformations. Designed various kind of reports requested by the clients using CDE tools. Worked on Metadata editor to design interactive reports and published in Pentaho BA
• Worked on schema workbench to design Cubes in Mondrian schema file Designed queries using SQL editor and tuned existing queries to render the reports quickly.
• Involved in development of Dashboard reports using Pentaho BA. Worked on enterprise data integration server Pentaho 7.1 (spoon).
• Worked on source/target connections. Familiar with input, output, transform, lookup, joins in Pentaho.
• Installed and configured Pentaho DI and BA servers on Linux platform. Worked on Shell Scripts and scheduled jobs on Crontab.
• Presented our lot of dashboard products to our clients on our monthly meetings.
• Worked on an Agile based development project and delivered on time.

Technology Used: Pentaho ETL, BI server, AWS, Oracle, SQL Server, java, JSP, servlet, Tomcat, linux, Design Studio

Confidential

Project Manager/ETL

Responsibilities:

• Involved in analyzing and development of the Data Warehouse. Used Pentaho to transfer data to stage and UDB.
• Developed “Query Engine” in Java web app to validate business logic on the DW
• Extract data from Advantage database server in “Medisoft”
• Worked on open source data integration server Pentaho 7.1 (kettle). Worked on source/target connections. Familiar with input, output, transform, lookup, joins in Pentaho
• Convert EDI files using PDI.
• Created various Jobs in Pentaho including emails as alerts, file access on successful completion of jobs.
• Worked with sessions and batches using Server Manager to load data into the target database.
• Created various mappings using Aggregate, Filter, Join, Expression, Lookup, Update Strategy and Router.
• Worked on Informatica power center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer Extensively used ETL to load data from different databases and flat files to Oracle.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Created and scheduled Sessions and Batches through the Informatica Server Manager.
• Testing for Data Integrity and Consistency.
• Responsible for business outcomes as per defined SLAs and contractual terms
• Expected to recruit and coordinate with dedicated project teams and internal teams to ensure timely delivery of client projects and also benchmark the quality of delivery with industry benchmarks and best practices to ensure highest quality of deliverables.

Technology Used: Pentaho ETL, BI server, Informatica, Advantage database server, Oracle, Mysql, java, JSP, servlet, Tomcat

Confidential

Research Officer/ETL Head

Responsibilities:

• Design and developed web based tax valuation system and reporting (We used Java for building the web application).
• Used Struct framework for support model view control
• Develop rest API to communicate between file server and application server.
• Used Pentaho 7.1 data integration server as a tool for transferring the existing data from the MYSQL server to Oracle.
• Worked on Transformation, job and database connection in Pentaho. Used parallel data transfer from different tables to UDB using Pentaho. Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement logics. Checked Sessions and error logs to troubleshoot problems
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Coordinating between client and a team of 9 developers, 2 Tech leads.
• Preparing detailed project objectives, Business needs analysis, well defined and structured requirements, and requirements feasibility and risk analysis. Preparation and working of SDLC. Key player between development team and client.

Technology Used: Pentaho ETL, Informatica, Oracle, Mysql, Core Java, JS, JSP, Tomcat

Confidential

Offshore Manager

Responsibilities:

• 24/7 Support for Confidential, USA. I was working as an offshore coordinator.
• Worked on SOP's on a daily basis and ensure data integrity.
• Offshore coordinator will be providing ETL Technical/Functional documents and acted as a Point of Contact for offshore team.
• Responsible for requirement gathering, user meetings, discussing the issues to be resolved and translated the user inputs into ETL design documents.
• Extracted data from various heterogeneous sources like MySQL, Oracle, SQL Server, Flat files.
• Worked on Jira tickets raised by onsite and resolved ETL issues and documented.

Technology Used: Informatica, Oracle, Mysql

Confidential

Systems Analyst - Team Lead

Responsibilities:

• I worked as a team lead.
• Involved in System Study and Understanding the requirements Involved in ETL, Data Warehouse Design
• Development of Data Warehouse is done using Informatica SQL Transformation and Debugging

Technology Used: Informatica, Oracle

Confidential

ETL System Analyst

Responsibilities:

• I am appreciated and given an internal job change in the field of data warehousing with the tool of informatica.
• Since this is my 1st project so I was mainly involved in understanding the technology. I used Informatica (Power Mart 5.1.0) ETL tool and Oracle SQL. I also focused to understand the various components of SDLC (software development life cycle). Designed various user defined functions, procedures, packages,
• Developed various mappings for extracting the data from different source systems using Informatica Power Mart 5.1.0 - Server, Server Manager, Repository Manager and Designer