SUMMARY

• Over 7 years of experience in IT industry contributed in the development of product through software lifecycle, from requirement definitions through successful deployment.
• Expertise in advance development methodologies, tools and processes contributing to the design and rollout of cutting - edge applications.
• Discern key business requirements and objectives by interfacing wif stakeholders. Develop technical solutions dat definitively improve scalability and performance.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support using Pentaho Kettle.
• Expertise in Query optimized coding and new programming techniques using Oracle 10G, SQL Server 2000, SQL Server 2005 and Postgres.
• Extensive Experience in Open Source BI products like Pentaho (Server configuration, Branding, ETL, Reporting, Mondrian cube, Interactive Reporting & Dashboard), Jasper and Birt.
• Worked on data warehouse and business intelligent projects and delivered high quality solutions in a timely manner meeting the business requirements.
• Hands on experience in database like Oracle 10G, SQL Server, MYSQL and Postgres.
• Experience wif ETL (Extract, Transformation & Load) process using PentahoData Integration tool for integrating data from heterogeneous sources (Excel, CSV, Oracle, MySQL, PostgreSQL, flat file, Text Format Data).
• Extensive experience in installing and configuring Pentaho BI Server 3.6 for data warehouse ETL and reporting purposes.
• 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.
• Expert knowledge in data warehousing and business intelligence concepts
• 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.
• Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer andPentaho 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,MSQL and big database like Mongos and Hadoop
• Experience in various other ETL tools like DTS and SSIS (SQL Server Integration Services) onMicrosoft Platform.
• Has very good experience in full life cycle of the projects including Data Analysis, Design, Development, Implementation, Testing, Production Support and Maintenance.
• Expert in trouble shooting performance related issues and hands on Notification services in setting up the Scheduled jobs and alerts.
• Highly organized wif the ability to manage multiple projects and meet deadlines.
• A team player wif excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS

Database: SQL Server 2008/2005/2000, Oracle 9i/10g/11g, MySQL, PostgreSQL, Microsoft Access, Big database- Mongos, Hadoop.

Tools: Toad, Oracle SQL Developer, SQL Plus, Oracle Enterprise Manager, SQL Server Management Studio, Business Intelligence Development studio (BIDS), SQL Profiler.

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

Version Control: SVN, Tortoise and GIT

Other ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services, BCP, Import Export Data, Bulk Insert.

Reporting Tools: SSRS, Crystal Reports, MS Access, MS Excel

Modeling Tools: ERWIN, MS Visio, and ER Studio.

Languages: T-SQL, PL/SQL, ASP.NET, C#, VB.Net C, C++, Visual Basic 6.0

Web Tools: MS-Front Page, Visual Studio 2008/2005, XML, CSS, HTML, IIS.

Operating System: Windows 2000/ 2003 Server/ Win XP/Vista/7, UNIX, Red Hat Linux

PROFESSIONAL EXPERIENCE

Confidential, PA

Pentaho Developer

Responsibilities:

• Designing architecture of Business Intelligence Infrastructure for ISP using Pentaho Suite (PDI/Mondrian/Metadata) for ISP developer Console and publisher console.
• Actively participating as in team to gather requirements to developdis BI projectand also participated in designing Physical and Logical ofData warehouse.
• The Business Intelligence project involves DW development, ETL through Pentaho Kettle, Business Analysis through Pentaho Meta Data Editor and Web presentation using Google Charts and Pentaho BI Server.
• Designing 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 dat’s completely implemented in Pentaho Kettle.
• Participated in design ofStaging DatabasesandData Warehouse databaseusingStar Schema.
• Modified existing Oracle PL/SQL code of stored procedures, functions and packages using TOAD for existing system running in Oracle.
• 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 inperformance tuningofSQL queriesand stored procedures usingSQL ProfilerandIndex Tuning Wizard.
• Identified, tested, and resolveddatabase 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.
• CreatedProfiling, Cleansing and auditingplans wifSSISPackages.
• Created bunch of Cubes in SSAS using BIDS and deployed them successfully on Analysis Services Databases, and created various ad-hoc reports using SQL Browser and exported them into MS Excel.
• 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 (SCD - Type 1, 2, 3)
• Implemented Logic wiflookup tableto maintainParent- Child relationshipand maintainhierarchy.
• Used transformation likeMerge Join, Pivot, lookup, Fuzzy lookup and slowly changing Dimension.
• Actively participating in all phases of system development life cycle (SDLC) starting from requirement gathering all the way up to deployment in production and system testing.
• Preparing 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 Server2005/2008,SQL Server Integration Services (SSIS), Oracle 10g,MS Access2003/200,Enterprise ManagementStudio, MS Query Analyzer, SQL profiler and SSRS.

Confidential -Swanzey, NH

Pentaho Developer

Responsibilities:

• Developed and created logical and physical database architecture using Visio.
• 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.
• 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 Normaliser and Row 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.
• 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 wif 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 -Cranston, RI

ETL Developer

Responsibilities:

• Elicit and document ETL requirements.Understand source and target data models, including normalized and dimensional models.
• Analyze source and target databases for data profiling and patterns
• Develop source to target mappings and technical specification for ETL programs
• Design and develop ETL code Work wif data modelers and report developers to ensure dat ETL design aligns wif data models and report requirements
• 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.
• Created differentuser level groups, and assigned appropriatepermissionlevel to the database using Credentials tool. dis made sure dat only the right person wif enough authorizations would be able to see their corresponding Information
• UseData Viewersin SSIS Packages to check the flow of data during Execution of Packages
• Generated reports usingSSRSdat could be used to send information to different managers of Different Branch.
• Created different type of reports includingCross-tab, Tabular, Charts, graphs, Sub reports, Drill-down reports wif 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 reportsusing 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.
• Collaborate wif Project Manager, Tech Lead, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support the achievement of business outcomes.
• Has a thorough understanding of business scope and requirements and TEMPeffectively communicating wif business and technical teams and translating between business and technical terminology.
• Participate in data definition and data management reviews
• Partner wif QA in test planning and testing activities
• Establish and maintain processes to support and grow data management practices at edo.
• Drive the development and enforcement of development and integration standards, patterns and processes.

Confidential -Baltimore, MD

BI Developer

Responsibilities:

• Responsible for transformation of the various legacy systems running on Oracle 10g on HP-Unix and Linux machines into Windows Platform wif database on SQL Server 2005.
• Designed and developed SKYVIEW, a CRM system for HONDA dealers.
• Actively involved in development of Excel Management System (EMS) for HONDA, an application to provide all dealers statistics regarding sales and services.
• Wrote various stored procedures, functions and packages in PL/SQL for back end reports.
• Created SSIS packages to transfer data from Oracle 10g to SQL Server 2005.
• Imported bulk data in Oracle tables from data files of fixed record, variable record and stream record format using SQL Loader.
• Developed several Monthly Reports, YTD Reports and End-of-month Checks in PL/SQL.
• Wrote Shell scripts in UNIX and PL/SQL scripts to automate daily routine jobs for production databases.
• Modified existing Oracle PL/SQL code of stored procedures, functions and packages.
• Created and executed SSIS packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from OLE DB Source (Oracle), flat files, XML files, CSV files and Excel Spreadsheets to SQL Server 2005 and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SSIS.
• Actively Participated in developing logical model and implementing requirements on SQL Server 2005.
• Implemented complex conceptual database design into SQL Server 2005 using various constraint and triggers.
• Implemented complex business requirement in Oracle Production databases using efficient PL/SQL stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Used Oracle Enterprise Manager for troubleshooting, monitoring, and optimizing of Oracle Production and non-production database code as well as PL/SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating new logins and users, changing the roles of the users.
• Involved in creating logical and physical models of the database using Erwin and Visio.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation and data extraction.
• Used Oracle UTL SMTP package to send email messages using the database as an SMTP mail server.
• Performed software configuration management (SCM) and version control using IBM Rational ClearCase.
• Interaction wif business and technical teams across geographic boundaries, wif clients, technical architects, project managers, requirements analysts and testing teams.
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.

Environment: Oracle 10g, PL/SQL, Toad, SQL Loader, Oracle SQL Developer, SSIS, Oracle Enterprise Manager, SQL Server 2000/2005, SQL Agent, Visio, Erwin, HP-Unix, Linux, Windows XP/Vista/2003 Server, Visual Studio .NET 2005, Crystal Reports, IBM Rational Clear Case.

Confidential

MS SQL Developer

Responsibilities:

• Involved in the entire System study, analysis and design.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Involved in the analysis of how the purchase order process was organized.
• Created SQL tables wif referential integrity and developed queries using SQL.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries dat were generated and handled the performance issues TEMPeffectively.
• Used Oracle UTL FILE package to read and write files on the host operating system.
• Used Oracle DBMS STATS package to gather, view, and modify optimizer statistics.
• Used DBMS SCHEDULER to scheduling functions and procedures dat are callable from any PL/SQL program.
• Created various stored procedures in Oracle database using PL/SQL language to be used in reports for Oracle-based clients.
• TEMPEffective utilization of Dynamic SQL in stored procedures to generate the query dynamically wifin the procedure using parameter values to make up the query.
• Used VB.Net as well as C#.NET in script task and script components and made use ofADO.NETclasses to manipulate data.
• Developing few in-house applications using C#.NET and VB.NET using Visual Studio which were lying on SQL Server databases.
• Scheduling and maintaining routine jobs, tasks, and alerts.
• Involved in optimizing code and improving efficiency in databases by re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Supported technical teams involved wif MS SQL issues and operations.
• Involved in the maintenance of the database.

Environment: MS SQL 2000, Windows N