SUMMARY

• Over 8+ years of IT experience and 7+ in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains
• Over 5+ years of experience in Data Warehousing, ETL and Business Intelligence experience using Pentaho Data Integration/Kettle, Pentaho BI Server, Pentaho Meta Data and Pentaho Analysis Tool & Mondrian OLAP.
• 6+ years of experience in developing Data Warehouse ETL processes
• 7+ years of PL/SQL programming experience
• Hands - on experience on Data warehouse Star Schema Modeling, Snowflake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling
• Worked on the complete Software Development Life Cycle (SDLC).
• Excellent Business writing skills with a significant experience in researching, eliciting and creating Business Requirement Documents, System Requirement Specifications, Functional Requirement Documents, Use Cases and User Stories
• Experience with data integration using Pig Scripts, processing the data over HDFS and storing it into S3 bucket with encryption.
• Strong skills using SQL queries on Oracle, DB2, and SQL Server.
• Worked extensively on Performance improvement
• Experience with stored procedures and functions using PL/SQ
• Well versed in creating SQL queries for Data Modeling, Data Validation and Data Integration
• Strong Analytical and Problem Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities
• Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills
• Detail-oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS

Tools: Tableau, BIDS, SQL Server Management Studio, Oracle SQL Developer, SQL Plus, SQL Server Reporting Services (SSRS)

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

Operating Systems: WINDOWS, MacOS, LINUX/UNIX

Scripting, Database and ETL: JavaScript, HTML, SQL Server2005/2008, MySQL,Talend

PROFESSIONAL EXPERIENCE

Confidential, Hastings, MI

Sr. Pentaho Developer

Responsibilities:

• Installed and configured Pentaho BI Suite 3.7 along with Pentaho Data Integration Server 5.2 on BI production box.
• Designed Data warehouse including star schema design, DW capacity planning, performance and tuning.
• Created Enterprise Repository in Pentaho BI Server to store Pentaho ETL jobs and Reports.
• Used Java Naming and Directory Interface (JNDI) for deployment sequence where apps move from development to test to production environments hiding the actual database being used.
• Responsible to manage data coming from different sources.
• Analyzed the source data coming from various heterogeneous data sources to be consumed in the ETL procedures to load data into data warehouse.
• Implemented Slowly Changing Dimension Type 1 and Type2 in ETL jobs for certain Dimensions.
• Implemented data level security by creating database tables to store usernames, user groups and their allowable permissions, and joined those tables in the report queries to make sure each user should be able to see only the permissible data.
• Saved Pentaho jobs in enterprise repository and scheduled them to run in production on daily basis.
• Tested Pentaho ETL jobs, reports and database stored procedures being called in the reports.
• 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.
• 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
• Created various types of chart reports in Pentaho having Pie Charts, 3D Pie Charts, Line Charts, Bar Charts, Stacked Bar Charts and Percentage Bar charts.
• Created several dashboards in Pentaho using Pentaho Dashboard Designer.
• Deployed reports on Pentaho BI Server to give central web access to the users.
• Created user accounts in Pentaho Enterprise Console for end users/Business Analysts who were supposed to view the reports using Pentaho User Console.
• Created mapping documents to define and document one-to-one mapping between source data attributes and entities in target database.
• Used different types of input and output steps for various data sources including Tables, Access, Text File, Excel and CSV files.
• Creation of HBase tables to store variable data formats of data coming from different applications.
• Identify and analyze data discrepancies and data quality issues and works to ensure data consistency and integrity.
• Made use of different transformations in PDI designer to cleanse and manipulate source data e.g.
• Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, Add constant, Add Sequence etc.
• Designed and implemented database architecture for applications using MongoDB.
• Created single value as well as multi-value drop down and list type of parameters with cascading prompt in the reports.
• Implemented security in Pentaho reports by assigning permission to specific users to view the reports.
• Created Production Release documents and user manuals for end users to educate about reports execution

Environment: Pentaho BI Server, Pentaho Data Integration (PDI),Pentaho Mondrian OLAP Server, MySQL, Pentaho Metadata Editor, Pentaho Design Studio, Pentaho Report Designer, Pentaho Dashboard, Hadoop

Confidential, NJ

Pentaho BI Developer

Responsibilities:

• Designed various reports like bar chart, scatter plot, Heat map, Geo mapping depending on the requirement of end
• Created various cubes with different dimensions and hierarchies and used these cubes for various analytic purposes.
• Created various cubes with different dimensions and hierarchies and used these cubes for various analytic purposes.
• Created metadata model using metadata editor for creating various interactive reports and used MQL for row level locking
• Created several dashboards in Pentaho using Pentaho Dashboard Designer.
• Used PostgreSQL bulk loader to stream data from inside Kettle to the psql command using "COPY DATA FROM STDIN" into the database.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
• Performed shell scripting to schedule the jobs and performed various Lookup steps for the slowly changing dimensions
• Used shell scripting in the performance tuning steps for faster executing of jobs.
• Designed various dashboards with different parameters for drill down purposes.
• Created various user accounts in Pentaho Enterprise Console and assigned various roles for different users
• Actively participated in clarification meeting with the Clients
• Provided CSV and Excel files to managers for particular records they wanted to look at in different meetings.
• Designed Data warehouse including star schema design, DW capacity planning, performance and tuning.
• Analyzed the source data coming from various heterogeneous data sources to be consumed in the ETL procedures to load data into data warehouse.
• Made use of different transformations in PDI designer to cleanse and manipulate source data e.g.
• Database Lookup & Join, Generate rows, Calculator, Row normalizer & de normalizers, Java Script, Add constant, Add Sequence etc.
• Implemented Slowly Changing Dimension Type 1 and Type2 in ETL jobs for certain Dimensions.
• Saved Pentaho jobs in enterprise repository and scheduled them to run in production on daily basis.
• Designed and implemented database architecture for applications using MongoDB.
• Deployed reports on Pentaho BI Server to give central web access to the users.

Environment: Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), 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 ClearCase

Confidential, California

Tableau Developer

Responsibilities:

• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements
• Resolved the bugs reported by QA team in existing dashboards
• Involved in creating database objects like tables, views, procedures, triggers and functions using T-SQL to provide definition, structure and to maintain data efficiently
• Creation of packaged workbooks (.twbx) for end-users
• Administered user, user groups, and scheduled instances for reports
• Created Proof of Concept visualizations using Tableau and demonstrated capabilities to the management
• Involved in installation of Tableau desktop 7.0, Tableau server Application software
• Defined best practices for Tableau report development
• Good SQL reporting skills with the ability to create SQL views and write SQL queries
• Responsible for creating reporting data model as per the requirements
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Projected and forecasted future growth in terms of number of sales based on the products by developing Area Maps to show details of which products are being sold the most
• Actively participated in clarification meeting with the Clients
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables

Environment: Tableau 7, SAP Business Objects, Windows 2008, oracle 11g,Oracle AERS, TOAD

Confidential, Atlanta, GA

Tableau Developer/Business Analyst

Responsibilities:

• Deep understanding in design and visualization of tableau solutions
• Used Filters, Trend lines, Parameters and aggregate Functions and created dashboards
• Create interacting workbooks as per requirements, after understanding the requirements, Analyzing systems and source database
• Use parameters and input controls to give users, control over few tableau functions
• Create Tableau Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals)
• Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop
• Server installation, upgrades, server tuning, troubleshooting system issues
• Responsible for security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication
• Assist with development of dashboards as needed
• Expertise in setup of sites, projects, workbooks, views and data sources
• Advanced knowledge of Tableau report performance optimization
• Perform ad-hoc analysis that helps in understanding business and performance trends
• Decompose the business requirements into one or more reusable reports / products
• Resolve Dashboard related issues and continuous development if required
• Responsible for assisting in customization of reports
• Identified new business development opportunities for the firm
• Forecasted company's expense accounts and assisted in vendor contract renewals and invoicing

Environment: Tableau Windows, Linux, DB2, UNIX, IBM Mainframe, AGILE methodology, Windows, XML, HTML