PROFESSIONAL SUMMARY:

• Over 8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains.
• Highly experienced in 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).
• Experienced in developing Data Warehouse architecture, ETL framework and BI Integration using Pentaho Reports and Pentaho Dashboards.
• Proficient in writing T - SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors and Query Optimization.
• Hands on experience in creating and debugging Stored Procedures, Functions, Packages, Triggers, Cursors and Object Types in PL/SQL using TOAD and Oracle SQL Developer.
• Experience with exception/error handling in PL/SQL.
• Experience in converting stored procedures, functions and triggers written in PL/SQL code into T-SQL.
• Experience in Installations, Up-gradations, Configuring and Maintenance of Microsoft SQL Server 2005/2008, Microsoft Visual Studio 2005/2008.
• Responsible for performance tuning of stored procedures, Database Tables using Table Partitioning, SQL Profiler and Database tuning wizard.
• Hands on experience on the whole ETL (Extract Transformation & Load) process.
• Skilled in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, MySQL, flat file, Text Format Data).
• Hands-on experience in MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS) using Business Intelligence development studio (BIDS).
• Worked on upgrading from DTS to SSIS packages.
• Experience in designing Database Models using Microsoft Visio and creating class diagrams, activity diagrams, use cases diagrams, sequence diagrams and flow charts.
• Worked on Notification services in setting up the Scheduled jobs and alerts.
• Hands-on experience on Data warehouse Star Schema Modeling, Snow-Flake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and Pivot Charts/Tables in MS Excel Spreadsheet.
• Deployed SSRS Reports on SQL Server Report Server as well as on SharePoint Server.
• Extremely motivated, diligent, conceptually strong team player with ability to take new roles and adapt quickly to new technology.
• Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS:

Business Intelligence: Microsoft & Pentaho BI Tools

Databases: Oracle 10g, SQL Server, DB2, MySQL, MS Access, Vertica

Tools: MS Visio, SAS/Access, Crystal Reports8.5, 10, XI, R2, Business Objects, Microsoft office 2003/2007/2010

Operating Systems: Mac OS X 10.0/10.1/10.4/10.7/10.8.4 Windows 95/98/XP/Vista/7, Windows NT/2000, Server 2003

Programming Languages: T-SQL, PL/SQL C, C++, HTML, XML, MYSQL, DHTML, VB.NET, ASP.NET, .NET Frame Work, C#

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

FTP Tools: Putty, OPENPGP

Pentaho Suite: Pentaho Data Integration (Kettle), Pentaho BI Server, Pentaho Analysis Tool, Pentaho Report Designer, Pentaho Mondrian, Pentaho Metadata Editor, Pentaho Design Studio, Mondrian OLAP Server

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

BI/Pentaho Developer

Responsibilities:

• 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 developed designed document for ETL flow, analysis of database architecture, created various complex Pentaho Transformation and Jobs using PDI Spoon.
• Identify, document and communicate BI and ETL best practices and industry accepted development methodologies and techniques.
• 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.
• Installed and Configured Pentaho BI Suit 4.2 & 4.4 along with Enterprise Repository in Pentaho BI server.
• Setup UNIX groups and defined UNIX user profiles and assigned privileges.
• Created UNIX script to manage file transfer architecture and to control ETL package version.
• Use Pentaho Import Export utility to Migrate Pentaho Transformations and Job from one environment to others.
• Used different types of input and output steps for various data sources including Tables, Access, Text File, Excel and CSV files.
• 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.
• Implemented Logic with Database lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Use Pentaho Design Studio for creating custom parameters as well as generating report.
• 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.
• Automated file transfer processes and mail notifications by using FTP Task and Send Mail task in Transformations
• Deployed reports on Pentaho BI Server to give central web access to the users.
• 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.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Report Designer, Pentaho Dashboard Designer, MySQL, Vertica, Entiera, SQL Profiler

Confidential, Independence, OH

Senior SQL/Pentaho Developer

Responsibilities:

• Coded several database Stored Procedures, Functions, Packages and Triggers in PL/SQL, and maintained Integrity Constraints.
• Provide enhancements and maintenance support to current application.
• Extensively usedData Stage Designerto develop various jobs to extract, cleanse, transform, integrate and load data into target Database. Also involved in converting server jobs into parallel jobs.
• Developed complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.
• Wrote UNIX shell Scripts for file validations and scheduling Data Stage jobs and for preprocessing and post processing of the files.
• Designed pilot system using Pentaho Kettle for ETL enhancements and Pentaho BI Server for publishing the Pentaho Reports on user funds transfer measures.
• 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.
• Developed SSIS Packages to generate the reports in Excel sheets required by the managers for analysis.
• Created SSIS package to get data from different sources, consolidate and cleanse the data and merge it into one single source.
• Designed Data warehouse including star schema design, DW capacity planning, MySQL performance and tuning. Implemented Orders and Points DW using star schema, Orders and Points Business domain using Pentaho Meta Data. Created Stage based DW supported by that’s completely implemented in Pentaho Kettle.
• Participated in design ofStaging DatabasesandData Warehouse databaseusingStar Schema.
• Successfully converted all database code including stored procedures, functions and triggers written in PL/SQL into T-SQL to be created in new system running on SQL Server Database.
• Created several SSIS packages in Business Intelligence Development studio (BIDS) to extract data from OLTP systems and load into staging databases.
• Wrote complex stored procedures in T-SQL using SQL Server Management Studio (SSMS) to summarize the data in staging environment and then developed SSIS packages to load the summarized data in Data warehouse Data Mart Dimension and Fact Tables.
• Created triggers on master data tables in OLTP to keep track of insertion and updates.
• Create several user-defined functions to server miscellaneous purposes like getting a comma-separated list of values, performing aggregation etc.
• CreatedProfiling, Cleansing and auditingplans withSSISPackages.
• AppliedConfiguration, Logging, Error reportingto all packages to make package deployment easy and troubleshoot package on run time.
• Load data in Data ware House by usingSlowly Changing Dimension
• UsePackage Configurationto Migrate SSIS package from one environment to other.
• Use differentcontrol flow controlslikefor each loop container, Sequence container, Execute SQL task, Send mail task.
• Useevent handling to send E-mail on eventlike on error.
• Generated reports usingSSRSthat could be used to send information to different managers of Different Branch.
• Actively participated in all phases of system development life cycle (SDLC) starting from requirement gathering all the way up to deployment in production and system testing.
• Created different type of reports includingCross-tab, Tabular, Charts, graphs, Sub reports, Drill-down reports with Cascading Parameter prompts.
• Deployed SSRS reports using Report Manager and scheduled the reports to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment:Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Design Studio, Pentaho Report Designer, MS SQL Server2005/2008,SQL Server Integration Services (SSIS), Oracle 10g,Enterprise ManagementStudio

Confidential, Cleveland, OH

Sr. Pentaho/ETL Developer

Responsibilities:

• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Prepared detailed design documentation including ETL data mapping documents and report specifications.
• Used Pentaho Data Integration Designer v4.0 to extract data from various sources including flat files of fixed format, Excel, XML, CSVs and databases like IBM DB2, MySQL and SQL Server.
• Used several transformations in Kettle to cleanse, validate and improve quality of data before loading it into target schemas.
• Coached a team of developers to develop Pentaho Reports, Dashboards, XActions and Analyzer Reports for the client.
• Developed complex custom reports using Pentaho Report Designer which includes developing Business Views, Cascading pick-lists, Drill-throughs, Hyperlinks, sub-reports etc, functionality into these reports.
• Problem solving: One such problem resolved was introducing an efficient and cost-savings approach to pass multiple parameters to a report using a dynamic pick-list or list of values, and also developing custom and complex stored procedures from Oracle and/or SQL Server databases which includes supporting both application and custom tables, views, triggers, and functions to aid in the design of these reports. Another was developing an Adhoc solution for Abbott laboratories using Pentaho Analyzer. Project was developed and deployed by myself via SDLC, and integrated within the application using Pentaho Java
• Deployed custom dashboard deliverables to clients on time. This was accomplished using the Pentaho Dashboard designer hosted on Pentaho BI Server using Pentaho User Console interface.
• Modified and/or re-created existing reports from excel requirements.
• Integrated custom pentaho reports into the Profiler application with JSP calling the pentaho report after validating parameter values from the application interface in UAT environment before deploying to production
• Created ROLAP cubes using Pentaho Schema Workbench for group web meetings for demonstrating the powerful functionality of Pentaho Mondrian Server with Ad-Hoc reporting. Power users were based out of Germany and Switzerland. Thus, also responsible for constantly communicating updates between business users and local management
• Involved in Weekly meetings to streamline and define requirements and business rules to arrive at a general consensus between the analysts, business users, and software development team.

Environment: SQL Developer, Oracle 10g, SQL Server 2005/2008, Pentaho BI Suite (Data Integration Designer, Report Designer, Dashboard Designer, Analysis View, Pentaho Analyzer, Design Studio, Mondrian Server), SQL Management Studio 2008, SQL Server 2005 & 2008

Confidential, Indianapolis, IN

SQL/BI/Pentaho Developer

Responsibilities:

• Developed DDL scripts for creation of tables, indexes, views and other Oracle Server objects.
• Coded several database Stored Procedures, Functions, Packages and Triggers in PL/SQL, and maintained Integrity Constraints.
• Provide enhancements and maintenance support to current application.
• Designed pilot system using Pentaho Kettle for ETL enhancements and Pentaho BI Server for publishing the Pentaho Reports on user funds transfer measures.
• Used various types of inputs and outputs in Pentaho Kettle including Database Tables, MS Access, Text Files, Excel files and CSV files.
• Developed SSIS Packages to generate the reports in Excel sheets required by the managers for analysis.
• Created SSIS package to get data from different sources, consolidate and cleanse the data and merge it into one single source.
• Developed SSIS packages to transfer data from heterogeneous database (Oracle) & different files format (Text File, CSV, Spread Sheet) to SQL Server and vice versa.
• Used SQL Loader to import bulk data in Oracle tables from data files of different formats including fixed record, variable record and stream record format.
• Created and scheduled Various Daily running and Month end SQL Jobs, using SQL Server Agent to perform various ETL operations.
• Created new tables, wrote PL/SQL stored procedures and user defined functions for Application Developers.
• Created SQL scripts for tuning and scheduling.
• Created Triggers in PL/SQL to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Optimized long running SQL queries and PL/SQL stored procedures.
• Performed development support, documented reviews and test plans.
• Created and maintained Indexes for various fast and efficient reporting processes.
• Implemented package configurations in SSIS packages allowing transferring packages from one Environment to other.
• Deployed SSIS packages on production servers and scheduled those to run on routine basis and monitored the error log for any errors.
• Created users and roles in Oracle as well as Windows 2003 Server and maintained proper security procedures by assigning appropriate permission levels to the users.
• Worked with the Planning team to forecast the business requirement

Environment: PL/SQL, SQL Loader, Toad, Oracle SQL Developer, SSIS, Unix, Windows 2003 Server, SQL Server 2000/2005, Management Studio, Pentaho Suite (Pentaho Data Integration PDI/Kettle, BI Server, Pentaho Report Designer), Visio, MS Excel, VB.Net, ASP.Net

Confidential, Iselin, NJ

SQL/Pentaho Developer

Responsibilities:

• Monitor all aspects of organizational business engagements, both internal as well external, to ensure that the interfaces are developed and delivered to meet ETL standards and best practices
• Loaded monthly, weekly, daily data, to track issues and resolve them based on the priority.
• Extracted the data using Pentaho Data Integration Designer (Kettle) from the flat files and other RDBMS databases like SQL Server 2005/2008 and Oracle 10g into staging area and populated onto Data warehouse.
• Collaborated with Database Administrators, Developers, and Analysts on all aspects of data management.
• Used error handling strategy for trapping errors by defining error handling in all crucial steps of ETL transformations and sending errors to an error table.
• Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Developed UNIX shell scripts to move source files to archive directory.
• Designed various types of reports using Pentaho Report Designer with Complex Formulas
• Designed the reports with multi level of groupings (hierarchies)
• A great deal of my assignment was in creating standard templates while designing reports to work with conditional formatting, sorting and running totals, converting old reports from MS-Access and Excel to Pentaho reports (prpt files), and creating functionality for a smooth export into various formats like EXCEL, PDF, HTML, and RTF per user requirements
• Spent time working with business users on getting specifications for reports and build prototypes developed for implementation on Pentaho Enterprise Server for User Acceptance Testing(UAT). This would involve constant analysis, regression testing, and iterative solutions before published it on Pentaho Enterprise Server production environment. In some cases, the responsibility of assuring scheduled reports got to intended recipients’ email for quarterly ends.
• Helped tune the database to resolve performance issues and ensured high performance through periodic performance evaluation and improvements.
• Involved in Unit, Integration, system, and performance testing levels.
• Interacted with executives to learn the business objectives and propose creative solutions to meet those objectives
• Provided Recommendations for cost mitigation solutions brought to the table with design approaches with the software development team to effectively represent the required data for analysis
• Documented for ERDs, Pentaho Report Templates and Pentaho Schema and Cube Designs.

Environment: SQL Server 2005/2008, Oracle 10g, Pentaho BI Suite (Kettle, Report Designer, Design Studio, Pentaho Mondrian), SQL Management Studio 2008, Windows Server 2003/2008

Confidential

MS SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using Erwin.
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2000.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Worked with DTS packages and MS OLAP Services.
• Maintained the consistency of the client’s Database using DBCC.

Confidential

SQL Server Developer

Responsibilities:

• Created DTS packages for the loading the data.
• Implemented and maintained database security.
• Administrator tasks like managing users, roles, and profiles.
• Performed Database backups (operating system, flat file backups & export/import).
• Used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Used Query Analyzer to optimize SQL Queries.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Coded Procedures & User defined Functions in TSQL.
• Established and documented a complete Disaster Recovery Plan for the Database servers.
• Rebuilding indexes on various tables.
• Provided 24/7 round the clock production support to facilitate smooth execution of clients’ applications.