SUMMARY

• 6+ Years of IT experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of SDLC, using Pentaho, SSIS, SSRS, and SSAS.
• Solid 2+ years Data Warehouse ETL development experience with Pentaho Kettle/ Pentaho Data Integration 4.2.1, 4.4.2, 5.2.0, 5.4.0 versions.
• Setup repositories, Master and Slave Servers, DB connections, schedule jobs.
• Export/Import repositories from one instance to another (DEV, QA and Prod).
• Experience in data modeling, data mapping, data conversion / migration.
• Experience in architecting and designing data warehouses.
• Strong expertise on Data Modeling and Data Analysis.
• Experience in administration and configuring / maintenance of multiple Pentaho Environments (Dev/QA/Prod).
• Create Pivot Tables, Create Graphs for Adhoc queries.
• Onsite / Offshore management.
• Developed Complex SSRS Reports and data visualization involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs, Bar charts, Column charts and Pie charts).
• Strong analytical, presentation, problem solving and excellent inter - personal communication skills with flexibility to learn new technologies in the IT industry.
• Team Player with the ability to communicate effectively at all levels of the development process
• Migration of DTS - SSIS packages.
• Upgraded DTS packages to SQL Server Integration Services (SSIS) and Expertise in Data Transformation Services (DTS) in SQL server 2000.
• Experience working with different databases like Oracle, MS SQL Server, MySQL, PostGreSQL.
• Experience with GIT and Tortoise SVN and also HUDSON deployment.
• Good knowledge of Data Modeling - Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Extensive hands on experience in troubleshooting database issues.
• Migrating data from different sources like Excel and Flat files to MS SQL Server by using BCP and DTS utility.

TECHNICAL SKILLS

RDBMS: Oracle 10g, 11i, MS SQL Server 2000/2005/2008 R2, MySQL.

Programming Languages: T-SQL, PL/SQL, C#, VB 5.0, 6.0, ASP.Net, UNIX Shell Script, Perl Script.

Tools: & Packages SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, DTSxChange, Visual Studio .NET.

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.

Tools: Pentaho 4.X, 5.X, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), GIT, Tortoise SVN, Hudson, MS Visio, Erwin, Crystal Reports 9.0/XI.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Data Warehouse Developer

Responsibilities:

• Created Pentaho jobs and transformations from scratch.
• Designed the ETL architecture for PARTS project team.
• Setup repositories, Master and Slave Servers, DB connections, schedule jobs.
• Save jobs and transformations in Tortoise SVN repository and deploy them into different environments using HUDSON.
• Used VersionOne Control to track defects for our project lifecycle.
• Create Adhoc queries as per the customer’s request for better understanding the data.
• Assists Engagement Managers with scoping, including validation of requirements and time estimates.
• Day to day data analysis for populating the accurate data.
• Serve as technical expert guiding choices to implement analytical and reporting solutions for client.
• Used different Pentaho Plugins, such as Google Analytics, Trim Cuts, Table Compare, Bulk Loaders, Data Grid, Field Calculator etc.,
• Work closely with the business, other architecture team members and global project teams to understand, document and design data warehouse processes and needs.
• Conduct technical orientation sessions using documentation and training materials.
• Design and implement BI and data integration solutions using Pentaho development methodologies.
• Create interactive data visualization modeling to oversee annual revenue.
• Mentor customer's staff members in the use of Pentaho product features.
• Research and resolve installation, configuration, deployment and upgrade issues; acts as advocate for customer and liaison to Pentaho’s Engineering, Product Management and Support organizations.
• Assist Enterprise Architects with the design, development, integration, performance tuning, roll-out, support and optimization of customer implementations of Pentaho products.
• Identify best practices and develops content for training courses and the Pentaho Knowledge Base.
• Assist the continued development of the Pentaho Consultancy Practice by mentoring other consultants, contributing to our knowledge base and training content, and improving the Pentaho development methodologies.

Confidential, Sunnyvale, CA

Sr. Data Warehouse Developer

Responsibilities:

• Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling them on Pentaho BI Server.
• Analysis of high-level design specifications into simple ETL coding and mapping standards.
• Extensively used Pentaho to develop process for extracting, transforming, integrating and loading data from various sources into the Data Warehouse.
• Developed several complex ETL jobs for historical and incremental data loads using various stages.
• Created and tested ETL processes composed of multiple Pentaho jobs.
• Experience in administration and configuring / maintenance of multiple Pentaho Environments (Dev/QA/Prod).
• Created Master sequencers to help call hundreds of transformations for various business models.
• Worked closely with the Data modeler and Database Architect during the design and development of ETL technical specification document.
• Involved in performance tuning of Pentaho transformation while developing the jobs Systems/applications requirements gathering, analysis and specifications.
• Involved in SCRUM team/meetings to help teams understand the concepts/process of Pentaho.
• Systems/applications testing, quality assurance, and implementation and integration activities.
• Extracted data using different strategies from the various heterogeneous sources like Access, Oracle & flat files.
• Used Google Analytics to generate reports for all data related to product details.
• Developed several Server jobs using DataStage Designer. Performed data transformations by using various stages like Transformer, FTP, conditioning, and validation and loading into the Data warehouse.
• Developed test plans and test cases.
• Provide customers and end users with technical training and solutions.

Confidential

MS SQL SERVER BI Developer

Responsibilities:

• Worked closely with the requirement team and designing team for understanding the business requirement.
• Developed SSIS packages to accommodate new business requirements.
• Communicated with the team members on regular basis.
• Change requests had to be made for all the implementations.
• Worked closely with DBA's deploying packages for staging/production server.
• Documented all database objects, which were used in the project and for further upgrades and maintenance.
• Measured the existing size of the data on the relational side, plan for growth (addition of new data everyday) for a year.
• Designed and applied Entity and Attributes description and definition for the models.
• Implemented different types of Constraints on tables designed in the data staging area for the migration.
• Implemented Incremental load, used Event Handlers to clean the data from different data sources
• Generated periodic reports and data visualization reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• Dealt with Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor.
• Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
• Documented and maintained database system specifications, diagrams, and connectivity charts.