SUMMARY

• Over 7+ years of 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.8 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 noledge 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 with other Reporting tools like SQL Server Reporting Services (SSRS) and Crystal Report.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Utilized Reporting Manager to secure the Reports with windows user groups and roles for individual reports and folders.
• Used Report builder and provided multiple types of reports in SQL Server Reporting Services (SSRS) including drill down, drill through, parameterized, sub reports and linked reports.
• Has 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.
• Strong passion to learn, ability to adapt, and commitment to perform with excellent communication skills

TECHNICAL SKILLS

Business Intelligence: 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

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

Operating Systems: Windows 95/98/XP, Windows NT/2000, Server 2003, Vista,7, Unix, Linux

Programming Languages: T-SQL, PL/SQL, C, C++,C#

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

FTP Tools: FileZilla, CuteFTP, Putty, FTP Commander

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Pentaho BI/ETL Developer

Responsibilities:

• Worked closely with Business Analyst and Team Lead to understand the requirement of ETL and reporting solution to be built.
• Created ETL transformations and jobs using Pentaho Data Integration Designer (Kettle-Spoon) and scheduling them using Cron Job.
• Used CE Pentaho Data Integration Designer 4.2 to create ETL transformation and Jobs.
• Used different transformation in PDI to cleanse and manipulate source data e.g Database lookup & Join, Generate Rows, Calculator, Row normalizer & De-normalizer, Java script, Add constant, Add sequence etc.
• Created mapping documents to define and document mapping between source data attributes and entities in target database.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Created oracle objects like Stored Procedure, Functions, Triggers and Packages.
• Modified and Created shell scripts adding new process to run using cronjob.

Environment: Pentaho Data Integration/Kettle-Spoon, Oracle11g, SQL, Oracle SQL Developer, Toad, Erwin, Subversion SVN, Putty, Filezilla, MS-Excel, Windows.

Confidential, Minneapolis, MN

SQL Developer/BI Developer

Responsibilities

• Worked very closely with Project Manager to understand the requirement of reporting solutions to be built.
• Gatheird business requirement by understanding business Processes and needs.
• Installed and Configured Pentaho BI Suit 3.5 & 3.8 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.
• Designing reports using Report Designer and xactions files for the report using Design Studio.
• Created xactions and sub actions using JAVA script.
• Created an ETL process using Design Studio to generate real time data for students attendance, including assigning a control number and error codes to the Pentaho Report.
• Use Pentaho Design Studio for creating custom parameters as well as generating report.
• Integrate the Design Studio xaction file with the front end application SCHOOLMAX and add it its menu.
• 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.
• Deployed reports on Pentaho BI Server to give central web access to the users.
• Tuned report queries running against Oracle database to get optimal performance.
• Working closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Knowledge sharing about the Pentaho BI tool across all team members.
• Creating Production Release documents and user manuals for end users to educate about reports execution.

Environment: Pentaho BI Server 3.5/3.8, Pentaho Data Integration (PDI/Kettle), Pentaho Design Studio, Pentaho Report Designer, Pentaho Dashboard Designer, TOAD 11.5, Oracle 10g, Oracle SQL Developer, SQL Profiler, Windows 7 64-bit Edition.

Confidential, Detroit, MI

Senior Pentaho BI Developer

Responsibilities:

• 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.
• 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.
• 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.
• 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.
• Tuned queries using Query Optimization techniques.
• 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 dat the development of projects met business requirements.
• Tested Pentaho ETL jobs, reports and database stored procedures being called in the reports.
• Enabled noledge sharing across all team members.
• 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, Oracle 10g, Oracle SQL Developer, SQL Profiler, Windows Server 2008/XP 64-bit Edition.

Confidential, Washington, DC

Sr.SQL Server/BI Developer

Responsibilities:

• Gatheird requirements from finance department and documented them based on functional specifications.
• Documented the technical design, detailing about the whole flow of the package, so user can easily understand the flow of process.
• Installed and Configured SQL Server 2005.
• 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.
• Created stored procedures to in corporate the flow from a Sales force CRM LINKED SERVER into the staging table and called various stored procedures from SSIS packages to make the flow of the package effective.
• Created Store procedure, Views and user defined function using the tables. Extensively used joins on the tables in joining the data on Microsoft Dynamics ERP system. These store procedures and views were used in the later part of the project while designing the SSIS package.
• Rewrote the existing SQL queries according to the requests made by the clients and executed them to check the performance.
• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time.
• Used PACKAGE CONFIGURATION for making the package scalable, allowing it to be used for future acquisitions.
• Worked in OLTP & OLAP environment dat 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.
• Documented the PACKAGE RELEASE NOTES, detailing about the deployment steps halping in moving the package from TEST environment to PRODUCTION.
• Created SSRS reports in the test environment for data validation.
• Involved in troubleshooting the deployment of reports in the test and production environment using SSRS.
• Formatted reports using Global Variable, Expressions and Functions.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS 2005.
• Enhanced the old Excel files and Crystal Reports to new SQL Server Reports to fit new business requirement and implemented into SQL Server 2005
• Participated in implementation of s/w new version releases.
• Provided 24x7 on-call supports, Supported systems beyond regular hours/ weekends/ holidays

Environment: Windows 2003 SP2 Server, SQL Server 2005, DTS, SSMS, SSIS, SSRS BIDS, T-SQL and DB Tuning Advisor.

Confidential, Wayne, NJ

Senior ETL/BI Developer

Responsibilities:

• Gatheird business requirement by understanding business Processes and needs
• 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 SSIS 2005
• Scheduled ETL jobs and deployed in production environments.
• Developed various reports for the client using SSRS
• 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
• Optimized the performance of various T-SQL scripts, stored procedures and triggers by using embedded UDFs, Recursive CTEs and System stored procedures.
• 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)
• Migrated DTS 2000 packages to SSIS 2005 packages
• Maintain all the SQL documents includes installation and data conversion Procedures documents
• Involved in installation, configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008 across various environment.
• Designed different types of reports such as Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services (SSRS) as well as managed the subscription and autantication of these reports.
• Created report models from cubes as well as relational data warehouse to create ad-hoc reports and chart reports.
• Managed very large reports dat return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Involved in formatting of reports for various visual representations using conditional formatting and templates in SSRS 2008.
• Created report snapshots and cache for better performance as well as deploying and scheduling reports.
• Scheduled the delivery of reports in different formats such as PDF and excel using standard and data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Provided support at time of outages, patches, security, replication, backups and given 24/7 on call support.

Environment: Oracle 9i, SQL Server 2000/2005, Windows Server 2003, Windows XP, SSIS, SSRS, VB.NET, FTP.

Confidential

SQL Server Developer

Responsibilities:

• UpgradedSQL Server 7.0to SQL Server 2000 and migrated data from old systems to new systems
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training
• Actively involved in Normalization & De-normalization of database.
• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• 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

Environment: MS SQL Server 2000, T-SQL, DTS, Windows Server 2000, VSS, FTP Tools