SUMMARY

• Have 7 years of experience in the state - of-the-art mission critical and scalable end-to-end (Full life cycle) Data Visualization & Analysis, Business Intelligence/Data Warehousing industry solutions with expertise in Tableau BI, MS-BI (SSIS, SSAS and SSRS), Microsoft Office Performance Point Server 2007(PPS), Informatica and Business Objects hands-on experience in analysis, and development for BI project solutions in banking, insurance, retail, Healthcare and C&HT applications.
• Technically hands-on commercially experience mainly with full range of BI Skills with Tableau 7x, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server 2005, SSIS, SSAS, SSRS, MS Performance Point Server 2007 (PPS 2007), and Informatica .
• Expertise in Tableau BI reporting tools & Tableau Dashboards Developments & Server Administration.
• Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data.
• Hands-on experience with Tableau suite of products- Server, Desktop .ETL, OLAP analysis and reporting processes using Tableau, MS SQL Server 2005 and BO. Working knowledge of ETL processes of SSIS Packages, MS DTS, OLAP analysis SSAS cubes and SSRS reporting applications (Operational and Business Intelligence).
• Involved in implementation and maintenance of high performance BI solutions-, ETL, analysis (OLAP) and reporting of techno-commercial solutions for Biz D’Risking Ops.
• Good knowledge of Business Intelligence/Data Warehousing BIDW Fundamental architecture concepts, dimensional modeling, requirement gathering.
• Strong experience in various top ranked vendor BI specific tools such as Tableau & MS BI.
• Strong skills with Business Intelligence application stack including Tableau Desktop/Tableau Server/Tableau Public/SSIS/SSAS/SSRS, Performance Point Server, multi-dimensional cube building, OLAP/MOLAP and have the solid experience in data warehousing/BI environments.
• Proven myself as a dedicated, worth full and energetic well-rounded Business Intelligence/DWH background professional in growth oriented reputed organizations that gives me scope to apply my knowledge and skills and be a member of a team that dynamically works towards success and growth of the organization.
• Good Communication and interpersonal skills.
• Self motivated high-energy person who enjoys challenging assignments and good Confidential working on multiple engagements.
• Versatile team player with excellent analytical and presentation skills.

TECHNICAL SKILLS

ETL Tools: Informatica 7x\8x, SSIS, Tableau Desktop

Database: MS Access, Oracle 9i, MS SQL Server 2005

BI Tools: Tableau BI Products, Business Objects.

Data Modeling: Erwin, Visio 2003

Reporting Tools: SSRS, Business Objects 6x, Tableau

Scripting Languages: SQL, T-SQL

OLAP Tools: SSAS

Dimensional Modeling: Kimball & Inmon

PROFESSIONAL EXPERIENCE

Confidential, LA,CA

Tableau Developer

Responsibilities:

• Understanding and translation of various existing SSRS reports to Tableau dashboards.
• Design, development and deployment of tableau reports.
• Generation of Tableau extracts and implementation of different calculations, visualizations in the tableau lay out design.
• Installation and configuration of Tableau server in dev. and production environment.
• Authenticating the tableau dashboards before publishing to tableau server.
• Publishing the developed reports to production Tableau server environment.
• Security implementation to tableau server reports based on user community.
• Tableau server API integration with MRCS 4.0 portal integration for trusted authentication.

Environment: BI solutions, BI environment, BI Applications, Tableau 8x BI toolkit\Product stack (Desktop\Server (Suite), Windows 8, SQL Server, and Excel.

Confidential, Santa Clara, CA

Tableau Developer

Responsibilities:

• Experience using Tableau tool to handle the various data feeds from the different data sources using Tableau Desktop tool.
• Creating customized and interactive dashboards using multiple data sources, data extraction and custom objects.
• Migrating some of the existing excel - based dashboards of Tableau.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Understanding of relational database structures and ability to create SQL views.
• Designing, developing, maintaining and supporting multiple Tableau dashboards and apps using Tableau 7x and understanding of new features of Tableau 8x.
• Good experience in Tableau development, analysis and Tableau Desktop, Server &Public support implementations.
• Develop Tableau module deliverables such as workbooks, package workbooks, building data views manually and automatically using different charts, graphs.
• Deploy and administer complex Tableau server environments involving multiple server setups in controlled and secure environments.
• Involved in Tableau server upgraded from single node to distributed environment, making tableau services more scalable and stable.
• Added multiple additional processes (VizQL, Application server, data server and background processes) for performance improvement.
• Helped Tableau power users in optimizing their tableau reports with proper use of filter, optimized SQL queries etc.
• Created Data extracts for better performance and accessing data offline.
• Implementation of incremental data extracts updated on timely basis as database updates, Refreshing extracts, optimization and tuning applications for maximum memory management, scheduling .

Environment: BI solutions, BI environment, BI Applications, Tableau 7x BI toolkit\Product stack (Desktop\Server (Suite), Windows,Accolade, SQL Server, Excel and other internal source applications

Confidential, Greensboro, NC

Tableau Developer

Responsibilities:

• Working on the POC (Proof of Concept) for the Tableau 7x product.
• Hands-on analysis, design and development of reporting dashboards and parameterized and cross tabular reports.
• Experience in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable business executives to take informed action.
• Create PDF push reports and setup email distribution on Tableau server 7.
• Knowledge of Tableau sheet objects and understanding of available functions and properties and Tableau architecture.
• Preserving and/or clearing user selections during tab navigation based upon business need and automation of user actions.
• Understanding of installation, configuration and administration of tableau server and desktop.
• Should have involved in administration (User access, Scheduling, Server configuring.)
• Understanding of the architecture and process of the tableau servers. Performance tuning of the dashboards.
• Published common Tableau reports on Tableau server under appropriate projects.
• Involved in the creation of users, groups, projects, workbooks and the appropriate the permission sets for Tableau server logons and security checks.
• Performance administrative and support activities across a multi-environment Tableau infrastructure including security administration, &troubleshoot and performance tuning or deployment issues when required during the implementations.
• Scheduled data extracts on daily/hourly basis according to business needs, to provide most up to date data to the business users.
• Understanding of Tableau architecture and administration.
• Improved Tableau performance by adding more processes on tableau worker.
• Identify user profiles and design report delivery environment to meet users’ needs.

Environment: BI solutions, BI environment, BI Applications, Tableau 7x version product stack Windows,, SQL Server 2005,& Excel .

Confidential, Dallas, TX

MS BI developer

Responsibilities:

• Working as a BI Consultant in Business Analytics team.
• Supporting and loading the RCA.
• Maintaining the data warehouse, ETL processes ((DTS - SQL 2000)/(SSIS - SQL 2005)) packages and also maintaining the reporting part.
• Working for BOBJ-Business objects - BODI as an ETL process to one of the project.
• Creating the DW bus matrix, dimensionality modeling for the BOBJ by integrating the BOBJ with Kodiak RCA.
• Understanding the existing data modeling (db model) in MS Visio.
• Extracting the different source feeds text file, excel, Siebel CRM Answers feeds into the SSIS\ DTS packages of ARCA (Kodiak RCA, SE (South East) RCA).
• Running the back-end supporting stored procedures to the end reports in MS BI environment.
• Implementing and Supporting the SE RCA ETL process using the MS BI tool for loading the SE RCA data warehouse.
• Developing and Maintaining the BO XI (Xcelsius 2008) to build up the Scorecards and Dashboards to the biz users using BO Power User and Xcelsius.
• Using SQL server Enterprise manager\BIDS as an ETL\DTS for extracting data from source, transformation and load the data into target tables.
• Ad-hoc ETL, Reports requirement runs.
• Working on the SSRS reports/Scorecards to publish to the different user communities and publishing different SSRS reports tabular, matrix, parameterized, and chart reports using SSRS.
• Implemented all the sub component tools of SSRS such as Report manager, Reports, Report server, Report viewer, and Report builder for the SSRS reports generation purpose and also for the ad-hoc report requirements.
• Also implemented and supported some of the most advanced analytical reports with the tool MS Performance point server 2007 (Monitoring, Analysis & Planning) to create the MS PPS models, applications, user roles.

Environment: BI solutions, BI environment, BI applications, MS BI toolkit\Product stack (Suite) Windows, and BOXI- BODI, Power User, & BOBJ

Confidential, Atlanta GA

MS Bi developer

Responsibilities:

• Worked as a BI developer for Data track\BI development team from Offshore using Microsoft most valuable emerging technologies and specific products, solutions suites.
• Worked on MS SQL server 2005(SQL Server\SSIS\SSAS\SSRS, MS Visio, MS PPS 2007 & MS Excel 2007 tools.
• Worked with operational\BI technical Framework\architecture\skeleton\pattern, tools evaluation techniques.
• Prepared the high-level metadata plan for the entire life cycle of the project.
• Prepared the high - level security management plan for the current project requirement.
• Prepared the SSRS report Inventory, report mock-ups, and report specifications for operational reports, analytical (Business Intelligence) reports & DW elaboration and for dashboards and scorecards.
• Mapping the report elements to the report inventory as per the business functionality of the client’s requirements by using the reverse engineering technique.
• Reverse-engineering the clients customers DB models and existed Biz use cases. Also creating the new Biz use cases for some of the modules/functionalities.
• Implemented the standardized report structure (SSRS report designing) of the report Mock-ups for the end users (Biz users).
• Worked on the standardization of report layout- Standardize the report header and footer, page reset using the global variables, conditional formatting and styling the report, displaying the company logos dynamically, Incorporated the @ variables to filter out the data for the input users, page and print layout settings, pagination, multivalue parameters, RDL issues.
• Freezing out the DWH\DM\Biz use cases requirements.
• SSRS and PPS delivery management of report services\managing of reporting solutions-report scheduling, report distribution and bursting, and report user management/administration.
• Deploying the demo cubes to MS Excel 2007 for tactical analytics and also to MS PPS 2007 to create the most advanced BI\Operational scorecards, and dashboards.
• Deploying the work quality deliverables to the client share point site.
• Implementation and delivery of BI platform solutions to develop and deploy ETL, analytical, reporting and scorecard\dash boarding on SQL Server (2000/2005) using SSAS, SSIS/DTS, SSRS.

Environment: MS SQL Server 2005(SSIS/SSAS/SSRS), Microsoft Office Performance Point Server 2007 (Monitoring, Analysis and Planning), MS Excel 2007, Windows

Confidential

DWH Developer

Responsibilities:

• Team member of the BI module and involved in analysis of business requirements template, decomposition matrix, dimensionality modelling and ETL strategy.
• Understanding the Erwin ER diagrams.
• Utilizing the Kimball- Star/Snowflake schemas and slowly changing dimensions.
• Worked on Microsoft SQL Server 2005 Tools-SQL Server Integration services (SSIS), SQL Server analysis services (SSAS) and SQL Server reporting services (SSRS).
• Responsible for extracting the data from different source feeds like Flat file, XML, OLE DB, and Excel.
• Created packages by using sources, destinations and transformations using SSIS designer.
• Connected to different types of sources to extract data and destinations to load the data using Connection manager.
• Defined the data Sources, data Source views, dimensions, cubes within the Business Intelligence Development Studio (BIDS) Using SSAS.
• Administration and development of data warehouse\data marts and OLAP cubes
• Used Business Intelligence Development Studio, Management Studio for developing SSIS, SSAS, and SSRS.
• Involved in the creation of SSRS reports using with\without wizards.
• Performed parameterized reports, reports bursting, and scorecards.
• Involved in performing drill down the data, calculations, sort the data, add groups, subtotals, and colour code the business data exceptions.
• Troubleshooting ETL, OLAP analysis and reporting process failures.

Environment: MS SQL Server 2005(SSIS/SSAS/SSRS), Windows