PROFESSIONAL SUMMARY

• A skilled software professional having around 7 Years of experience in Business Intelligence.
• Worked on the complete Software Development Life Cycle (SDLC).
• Strong knowledge in OOP’s (Object Oriented Programming) concepts and 3 - Tier Architecture.
• Excellent Knowledge in RDBMS Concepts and Data Modeling using Erwin 4.0, Star and Snowflake Schemas.
• 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, PostgreSQL, 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.
• Proficient in implementing the business logic to design/develop the Cubes, Aggregation, Measures using SQL Server Analysis Services (SSAS).
• 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.
• Having good knowledge of Business Object.
• Experienced work in Team Foundation Server.
• Experienced in Google Analytics

TECHNICAL SKILLS

Database: SQL Server 2008/2005/2000 , Oracle 9i, MySQL, PostgreSQL, Microsoft Access.

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

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

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

Data Modeling Tools: ERWIN, MS Visio, 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, Nashville, TN

BI 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 with data modelers and report developers to ensure that ETL design aligns with data models and report requirements
• Collaborate with Project Manager, Tech Lead, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support the achievement of business outcomes.
• Have a thorough understanding of business scope and requirements and effectively communicating with business and technical teams and translating between business and technical terminology.
• Participate in data definition and data management reviews
• Partner with 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, Memphis, TN

BI 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 developthis 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 that’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 withSSISPackages.
• 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 withlookup tableto maintainParent- Child relationshipand maintainhierarchy.
• Used transformation likeMerge Join, Pivot, lookup, Fuzzy lookup and slowly 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.
• Created differentuser level groups, and assigned appropriatepermissionlevel 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
• UseData Viewersin SSIS Packages to check the flow of data during Execution of Packages
• Generated reports usingSSRSthat 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 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 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.
• Created various stored procedures in Oracle 10g database using PL/SQL language to be used in reports for Oracle-based clients.
• Effective utilization of Dynamic SQL in stored procedures to generate the query dynamically within 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 2008 which were lying on SQL Server databases.
• Scheduling and maintaining routine jobs, tasks, and alerts.
• 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, Memphis, TN

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 Denormaliser.
• 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, Somerset, NJ

BI Developer

Responsibilities:

• Responsible for transformation of the various legacy systems running on Oracle 10g on HP-Unix and Linux machines into Windows Platform with database on SQL Server 2005.
• Designed and developed SKYVIEW, a CRM system for HONDA dealers.
• Actively involved in development of Excell 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.
• 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 that are callable from any PL/SQL program.
• Involved in optimizing code and improving efficiency in databases by re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Performed software configuration management (SCM) and version control using IBM Rational ClearCase.
• Interaction with business and technical teams across geographic boundaries, with 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.
• 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 with referential integrity and developed queries using SQL.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Supported technical teams involved with MS SQL issues and operations.
• Involved in the maintenance of the database.

Environment: MS SQL 2000, Windows NT