SUMMARY

• 7+ years of overall IT experience in software development, project management, client communications and onsite/offshore team co - ordination including startup experience.
• Data Warehousing, ETL and Business Intelligence experience using Pentaho Suite (Pentaho Data Integration / Kettle, Pentaho BI Server, Pentaho Meta Data and Pentaho Analysis Tool & Mondrian OLAP)
• Extensive experience in installing and configuring Pentaho BI Server 3.6 for data warehouse ETL and reporting purposes. Managed license files for subscription of the products in Enterprise Console.
• Developed Data Warehouse architecture, ETL framework and BI Integration using Pentaho Reports and Pentaho Dashboards.
• Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling them on Pentaho BI Server.
• Excellent knowledge in databases like Oracle 8i/9i/10g, SQL Server 2000/2005/2008 , DB2 and MySQL.
• Excellent backend programming skills in creating database objects like Tables, Views, Stored Procedures, Indexes, Triggers and Functions.
• Experience in various other ETL tools like DTS and SSIS (SQL Server Integration Services) on Microsoft Platform.
• Experience in Java development working across multiple technologies.
• Experience with other Reporting tools like SQL Server Reporting Services (SSRS) and Crystal Report.
• Have very good experience in full life cycle of the projects including data analysis, database design, development, implementation, testing and maintenance.
• Expert in troubleshooting performance related issues.
• Experienced in implementing backup and disaster recovery procedures, Replication and Snapshots.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Possess knowledge sharing attitude with strong passion for mentoring and educating team members about new technologies.
• Strong passion to learn, ability to adapt, and commitment to perform with excellent communication skills

TECHNICAL SKILLS

Pentaho BI: Pentaho BI Suite ( Pentaho Data Integration/Kettle, Pentaho Report Designer, Pentaho Meta Data and Pentaho Analysis Tool & Mondrian OLAP), Pentaho BI Server

Other ETL/Reporting Tools: SSIS, DTS, SQL Server Reporting Services (SSRS), Crystal Reports

RDBMS: Oracle 8i/9i/10g, SQL Server 2000/2005/2008 , DB2, MySQL, MS Access

Modeling Tools: E/R Studio, Visio, Erwin

OS: Windows 95/98/XP, Windows NT/2000, Server 2003, Vista, Unix, Linux

Languages: T-SQL, PL/SQL, C, C++, VB.NET, C#.NET, ADO.NET, VBScript, Java scripting, Java

Query Tools: Toad, SQL Plus, SQL Developer, SQL Server Management Studio, SQL Workbench

FTP Tools: FileZilla, CuteFTP, Putty,WinSCP

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Pentaho Developer

Responsibilities:

• Installed and configured Pentaho BI Suite 3.7 along with Pentaho Data Integration Server 4.1 on BI production box.
• Created Enterprise Repository in Pentaho BI Server to store Pentaho ETL jobs and Reports.
• 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.
• Created user accounts in Pentaho Enterprise Console for end users/Business Analysts who were supposed to view the reports using Pentaho User Console.
• Created mapping documents to define and document one-to-one mapping between source data attributes and entities in target database.
• Used Pentaho Data Integration Designer 4.1 to create all ETL transformations and jobs.
• Used different types of input and output steps for various data sources including Tables, Access, Text File, Excel and CSV files
• Identify and analyze data discrepancies and data quality issues and works to ensure data consistency and integrity.
• Made use of different transformations in PDI designer to cleanse and manipulate source data e.g. Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence etc.
• Implemented Slowly Changing Dimension Type 1 and Type2 in ETL jobs for certain Dimensions.
• Saved Pentaho jobs in enterprise repository and scheduled them to run in production on daily basis.
• Used Pentaho Report designer to create various reports having drill down functionality by creating Groups in the reports and drill through functionality by creating sub-reports within the main reports.
• Created various types of chart reports in Pentaho having Pie Charts, 3D Pie Charts, Line Charts, Bar Charts, Stacked Bar Charts and Percentage Bar charts.
• Created single value as well as multi-value drop down and list type of parameters with cascading prompt in the reports.
• Implemented security in Pentaho reports by assigning permission to specific users to view the reports.
• 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.
• Deployed reports on Pentaho BI Server to give central web access to the users.
• Created several dashboards in Pentaho using Pentaho Dashboard Designer.
• Used Pentaho Schema Workbench to create Cubes, Dimensions and fact tables in Pentaho.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Converted Abstract specification in executable java code, and performed unit and integrated testing of different modules.
• Tuned report queries running against Oracle database to get optimal performance.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Ran Oracle Import/export to load data between DEV and TEST Servers.
• Provided CSV and Excel files to managers for particular records they wanted to look at in different meetings.
• Actively participated in 80 hrs review meetings with Sr. Business Analyst and Project Manager to ensure that the development of projects met business requirements.
• Tested Pentaho ETL jobs, reports and database stored procedures being called in the reports.
• Participated in Business Analysis & requirement collection. Interacted with clients directly before writing requirement specification documents.
• Worked very closely with Project Manager to understand the requirement of ETL and reporting solutions to be built.
• Designed Data warehouse including star schema design, DW capacity planning, performance and tuning.
• Implemented security and permissions for enrolled users on different reports in Enterprise Console.
• Analyzed the source data coming from various heterogeneous data sources to be consumed in the ETL procedures to load data into data warehouse.
• Created Production Release documents and user manuals for end users to educate about reports execution.
• Enabled knowledge sharing across all team members.

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

Confidential, NY

Senior Pentaho BI Developer

Responsibilities:

• Created Enterprise Repository in Pentaho BI Server to store Pentaho ETL jobs and Reports.
• 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.
• Created user accounts in Pentaho Enterprise Console for end users/Business Analysts who were supposed to view the reports using Pentaho User Console.
• Implemented security and permissions for enrolled users on different reports in Enterprise Console.
• Analyzed the source data coming from various heterogeneous data sources to be consumed in the ETL procedures to load data into data warehouse.
• Created mapping documents to define and document one-to-one mapping between source data attributes and entities in target database.
• Participated in Business Analysis & requirement collection. Interacted with clients directly before writing requirement specification documents.
• Worked very closely with Project Manager to understand the requirement of ETL and reporting solutions to be built.
• Designed Data warehouse including star schema design, DW capacity planning, performance and tuning.
• Designed, created and maintained database in Oracle 10g Release 2 for data warehousing usage, configured the database for DSS environment and tuned instance parameters for better performance, scalability and reliability.
• Installed and configured Pentaho BI Suite 3.6 along with Pentaho Data Integration Server 4.0 on BI production box.
• Used Pentaho Data Integration Designer 4.0 to create all ETL transformations and jobs.
• Used different types of input and output steps for various data sources including Tables, Access, 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, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence etc.
• Implemented Slowly Changing Dimension Type 1 and Type2 in ETL jobs for certain Dimensions.
• Saved Pentaho jobs in enterprise repository and scheduled them to run in production on daily basis.
• Used Pentaho Report designer to create various reports having drill down functionality by creating Groups in the reports and drill through functionality by creating sub-reports within the main reports.
• Created various types of chart reports in Pentaho having Pie Charts, 3D Pie Charts, Line Charts, Bar Charts, Stacked Bar Charts and Percentage Bar charts.
• Created single value as well as multi-value drop down and list type of parameters with cascading prompt in the reports.
• Implemented security in Pentaho reports by assigning permission to specific users to view the reports.
• 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.
• Deployed reports on Pentaho BI Server to give central web access to the users.
• Created several dashboards in Pentaho using Pentaho Dashboard Designer.
• Used Pentaho Schema Workbench to create Cubes, Dimensions and fact tables in Pentaho.
• Created/updated Stored Procedure, Triggers, User Defined Functions, User defined data type, Scripts and batches.
• Developed across all layers of various JEE applications.
• Removed Duplicate records from the source using complex query, analytical functions and ad-hoc scripts.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Tuned queries using Query Optimization techniques.
• Validated Dimension and FACT data using Data Profiling Task to check correct data population.
• Validated Cube aggregations and calculations with source tables.
• Tuned report queries running against Oracle database to get optimal performance.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Ran Oracle Import/export to load data between DEV and TEST Servers.
• Provided CSV and Excel files to managers for particular records they wanted to look at in different meetings.
• Actively participated in 80 hrs review meetings with Sr. Business Analyst and Project Manager to ensure that the development of projects met business requirements.
• Tested Pentaho ETL jobs, reports and database stored procedures being called in the reports.
• Enabled knowledge sharing across all team members.
• Educated team members on how to create and deploy custom ETL transformations, jobs, reports and dashboards.
• Created Production Release documents and user manuals for end users to educate about reports execution.

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

Confidential, Pittsburgh, PA

Senior Pentaho Developer

Responsibilities:

• Developed complex ETL Procedures to migrate huge amount of data from the old system to the new one.
• Designed, implemented and configured ETL procedures by creating transformations and jobs using Pentaho Kettle Spoon designer v3.2
• Scheduled Pentaho ETL jobs and deployed in Pentaho BI Server in production environments.
• Developed various reports for the client using Pentaho Report designer.
• Created various dashboards using Pentaho Dashboard designer.
• Gathered business requirement by understanding business Processes and needs
• Developed SSIS packages to copy data periodically from Production to Data Warehouse DB.
• Used OLEDB Connection managers to configure database connections for SQL Server Production and Data Warehouse Databases
• Wrote script components in SSIS packages using VB.NET to implement typical data transformation.
• Involved in loading the flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Worked with team members to tune the SQL queries using SQL Profiler.
• Automated file transfer processes and mail notifications by using FTP Task and Send Mail task in packages
• Implemented Slowly Changing Dimensions to maintain historical data in Data Warehouse
• Implementing maintaining database security(Create and maintain users and roles and Login access, assign privileges).
• Worked on wide range of website and web applications using Java, including building and maintaining customer end applications in J2EE, Implementing new canceled-check imaging system, which eliminated necessity for physical documentation and reduced wasted time by 25%.
• Migrated DTS 2000 packages to SSIS 2005 packages.
• Maintain all the SQL documents includes installation and data conversion Procedures documents
• Generated the weekly, monthly, and quarterly report by using SSRS
• Provided support at time of outages, patches, security, replication, backups and given 24/7 on call support.

Environment: Pentaho BI Server, Pentaho Data Integration v3.2, Pentaho Report Designer, Oracle 9i, SQL Server 2000/2005, Windows Server 2003, Windows XP, SSIS, SSRS, VB.NET, FTP., Java.

Confidential

Database Developer

Responsibilities:

• Created new tables, views, indexes and user defined functions
• Created DTS packages to output SQL Data to various data sources for documentation purposes, designed the database to fasten certain daily jobs
• Developed SQL queries and complex stored procedures using SQL server 2000
• Involved in performance tuning of T-SQL queries and Stored Procedures
• Wrote T-SQL statements for retrieval of data
• Created data model, logical design, and physical design of the database
• Developed complex stored procedures to create various reports
• Created Complex ETL packages using SSIS to Import data from different sources Oracle/Access/Excel Sheets into staging table and then transform and load into the data mart for various analytical and reporting purposes.
• Maintained Business (functional) Application production support, including installation, configuration, tuning complex stored procedures and index structures to improve performance of Enterprise-Level SQL Server environment
• Worked with SQL Server 2005 DBMS, Windows server administrator for OS patches, coordinated in outages and during up gradation of Client's Application. Provided problem resolution, data analysis using SQL, file systems, security, clustering, environment and monitoring, trouble shooting, applied patches, automated report generation, job scheduling SQL Server Job Agent.
• Applied patches and service packs to keep the database application at current patch level for Development, Test, Production environments.
• Worked in OLTP & OLAP environment that includes Production (24x7), Test and development databases in SQL Server.
• Involved in developing complex stored procedures, triggers for the application.
• As part of work did Performance tuning analysis of application environment, Prepared O & M technical documentation development, extensively worked on documentation with 3rd party vendor on software/support.
• Create, Deploy and schedule Reports using SSRS, SQL Server job agent as per client’s requirement to generate on daily, weekly, monthly and quarterly Reports.
• Participated in implementation of s/w new version releases.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows Server 2000, Windows 2003 SP2 Server, SQL Server 2005, DTS, SSMS, SSIS, BIDS, T-SQL and DB Tuning Advisor, VSS, FTP Tools