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 using UML.
• Experience in Design, Development, Implementation and Documentation of business requirements in Microsoft .NET framework 2.0/3.5 using Microsoft ASP.Net, Microsoft ADO.NET, C#.Net, VB.Net, Web Applications, Windows Applications and XML.
• 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 and 11g, SQL Server, DB2, MySQL, MS Access

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

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

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

Pentaho Support Engineer

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
• Schedule and monitor ETL jobs using UC4
• Actively participated as in team to gather requirements to develop this D I project and also participated in designing Physical and Logical of Data warehouse.
• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• 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.
• 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.
• Build new ETL server, installed Pentaho 4.2.4.
• Installed CoSort and FACT.
• Interacted with FACT Korea team to fix issue in latest release (FACT v3)
• Upgrade and downgrade CoSort and FACT.
• Interacted with IRI to get licenses and fix issues of CoSort and FACT.
• Migrated Pentaho jobs from production to new environment called Confidential .

Environment: Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Metadata Editor, Pentaho Design Studio, Pentaho Report Designer, MS SQL Server 2005/2008, CoSort, FACT, Oracle 11 g, MS Access 2003/200, Enterprise Management Studio, UC4, MS Query Analyzer, SQL profiler and Toad.

Confidential

Senior Pentaho Developer

Responsibilities:

• Actively participated as in team to gather requirements to develop this BI project and also participated in designing Physical and Logical of Data warehouse.
• 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 of Staging Databases and Data Warehouse database using Star Schema.
• 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.
• 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.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Metadata Editor, Pentaho Design Studio, Pentaho Report Designer, MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), Oracle 10g, MS Access 2003/200, Enterprise Management Studio, MS Query Analyzer, SQL profiler and SSRS

Confidential

Pentaho Developer

Responsibilities:

• Actively participated as in team to gather requirements to develop this BI project and also participated in designing Physical and Logical of Data warehouse.
• 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 of Staging Databases and Data Warehouse database using Star 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.
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• 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.
• Wrote cursors in the stored procedures to perform row-wise operations.
• 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.
• Created Profiling, Cleansing and auditing plans with SSIS Packages.
• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time.
• Load data in Data ware House by using Slowly Changing Dimension (SCD - Type 1, 2, 3)
• Implemented Logic with lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Used transformation like Merge Join, Pivot, lookup, Fuzzy lookup and slowly changing Dimension.
• Use Package Configuration to Migrate SSIS package from one environment to other.
• Use different control flow controls like for each loop container, Sequence container, Execute SQL task, Send mail task.
• Use event handling to send E-mail on event like on error.
• Created different user level groups, and assigned appropriate permission level to the database using Credentials tool. This made sure that only the right person with enough authorizations would be able to see their corresponding Information
• Use Data Viewers in SSIS Packages to check the flow of data during Execution of Packages
• Generated reports using SSRS that could be used to send information to different managers of Different Branch.
• Created different type of reports including Cross-tab, Tabular, Charts, graphs, Sub reports, Drill-down reports with Cascading Parameter prompts.
• Performed SQL Server installation in Share-Point Integrated mode.
• Deployed SSRS reports on Report Server using Report Manager, as well on SharePoint Server.
• Generated the various kinds of reports using Graphs and Images
• Deployed SSRS reports using Report Manager and scheduled the reports to generate all daily, weekly, monthly and quarterly Reports including current status.
• Utilized Dynamic SQL in stored procedures to generate the query dynamically within the procedure using parameter values to make up the query.
• Developed some in-house applications using C#.NET and VB.NET using Visual Studio 2008 which were lying on SQL Server databases.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent
• 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.
• Prepared user manual and technical support manual

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Metadata Editor, Pentaho Design Studio, Pentaho Report Designer, MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), Oracle 10g, MS Access 2003/200, Enterprise Management Studio, MS Query Analyzer, SQL profiler and SSRS.

Confidential

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,Windows Server 2008, JavaScript

Confidential

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 : Oracle 9i, 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, XML, VB Script, Visual Source Safe.

Confidential

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, JavaScript

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.