SUMMARY

• 7 years of IT Experience in design, analysis, development and implementation of Various applications in environment using BI Tools
• Worked in various phases of software development life cycle (SDLC) including Analysis, Design, Development, Testing and Production.
• Experience in Data Warehousing and Business Intelligence area in various domains.
• Strong hands on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Good experience on in dashboards designing with large data volumes from various data sources ( Sql server, teradata etc)
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts etc.
• Good knowledge of Data Warehousing concepts, RDBMS and multi - dimensional schema (Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases.
• Developed Framework Manager Models (Layers, Relations, Query Subjects, Star-Schema and Packages) and published packages.
• Expertise in complete lifecycle implementation of Data Warehouse / Datamart with Star Schema
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, FACT and Dimensions tables, and Physical and Logical data modeling.
• Expertise Configuring Repository, Create/Manage Dashboards, Reports/Answers and Building Physical, Business Model and Presentation Layer.
• Experience in Creating Dimensional Hierarchies, Level Based Measures and Time series Functions.
• Experience in migrating/upgrading Reports & Packages from obiee10.x to obiee11.x.
• Team player with good communication and interpersonal skills.
• Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Ability to handle multiple tasks concurrently and meet the deadlines.

TECHNICAL SKILLS

BI Tools: Tableau Desktop 9.0,8.3, 7.x Obiee 11.x

ETL tools: Datastage

Databases: Teradata, MS SQL Server 2005/2008/2012 and DB2

Tools: MS Excel, MS Word, MS PowerPoint, MS project, MS Front MS Expressions Web, TOAD, Sql Developer, Sql Star Plus.

WEB Technologies: JavaScript, HTML.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Tableau Developer

Responsibilities:

• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development
• Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
• Worked on loading the data from several flat files sources to Staging using TeradataMulti load, Fast load.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata
• Written Teradata BTEQ scripts to implement the business logic.
• Used Parallel load utilities such as Multi Load, Fast Load, BTEQ for applications which we load data on daily basis, weekly basis . monthly basis.
• Monitoring daily jobs and make sure of them completed successfully.
• Loading weekly data and monthly data into the tables in Teradata development and production.
• Written Fast load and Multi load scripts to load data into the table.

Environment: Tableau 7, 8.1 Teradata, BTEQ, MLOAD, FLOAD, MS Excel

Confidential, Richmond, VA

Tableau Desktop Developer

Responsibilities:

• Worked with business stakeholders and participated in requirement gathering sessions to understand the business needs.
• As a Tableau Desktop Developer I was responsible for creating dashboards and overall creation of data visualizations.
• Good experience on in dashboards designing with large data volumes from various data sources ( Sql server, oracle, spreadsheets etc)
• I have a Strong report/dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design..
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Used Teradata, Oracle and SQL server as data sources for designing Tableau Reports and Dashboards.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF etc.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Validated data at the row level and data level to ensure completeness and correctness of data
• Reconciled the report data with the source systems and reviewed it to find any data anomalies.
• Created custom date time calculations and macros in the reports.
• Created jobs, schedules and report views for the business users.
• Involved in administrative activities, doing deployment and monitoring schedules and jobs.
• Worked on Cognos Security Administration to restrict the users.
• Deployed Framework Manager Models and Reports and Packages from Dev to Test and Test to Production Environment and troubleshoot deployment issues.
• Provided Assistance to users in building reports in Report Studio, Query Studio, and Analysis Studios.

Environment: Tableau Desktop and Server 8, Microsoft SQL Server 2012

Confidential, Columbus, IN

OBIEE Senior Developer

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Participated in documenting Business Requirements Documents and Functional Specifications.
• Responsible for gathering the Meter Reads Billings Management Business Requirements, preparation of Requirement Specifications documents and performed the Gap Analysis.
• Mapped Siebel OLTP data into custom OLAP tables developed.
• Created many PL/SQL packages for ETL Sanity Check and called same in pre & post sessions.
• Implemented the session partitions (Database) for performance issues.
• Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the data warehouse per gaps.
• Created Aggregated Tables to improve the Performance of the Reports.
• Developed Custom warehouse tables to populate Account, Proposal, Product, Opportunity and Time Dimensions and Fact and aggregated Facts.
• Developed Business models to represent business logic for ACS (Accounts and Consolidation Services), AOP (Accounts and Opportunity Planning), Estimator Analysis, Week-Week Analysis, Win Loss Analysis and Sales Analysis.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Worked Extensively on Siebel Answers to create the reports as per the client requirements.
• Slice and Dice data using filters and used pivot/charts for better presentation.
• Configured Intelligence dashboards using links/images for conditional and exceptional reporting.
• Customized the appearance and texts of the various objects in the user Dashboards and answers.

Environment: OBIEE 11.1.3X, Teradata, Toad, Windows XP, Lotus Notes 8

Confidential

OBIEE Developer

Responsibilities:

• Analyzed existing reports and developed functional and technical mappings.
• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Participated in documenting Business Requirements Documents and Functional Specifications.
• Responsible for gathering the Meter Reads Billings Management Business Requirements, preparation of Requirement Specifications documents and performed the Gap Analysis.
• Mapped Siebel OLTP data into custom OLAP tables developed.
• Created many PL/SQL packages for ETL Sanity Check and called same in pre & post sessions.
• Implemented the session partitions (Database) for performance issues.
• Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Warehouse per gaps.
• Created Aggregated Tables to improve the Performance of the Reports.
• Developed Custom warehouse tables to populate Account, Proposal, Product, Opportunity and Time Dimensions and Fact and aggregated Facts.
• Developed Business models to represent business logic for ACS (Accounts and Consolidation Services), AOP (Accounts and Opportunity Planning), Estimator Analysis, Week-Week Analysis, Win Loss Analysis and Sales Analysis.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Slice and Dice data using filters and used pivot/charts for better presentation.
• Configured Intelligence dashboards using links/images for conditional and exceptional reporting.
• Customized the appearance and texts of the various objects in the user Dashboards and answers.
• Maintained iBots and default mail server for error reporting over the intranet framework.
• Developed OLTP and custom OLAP tables to perform ETL
• Maintained staging tables to perform the refresh load and full load effectively.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Designed and developed transformations, mappings and sessions in Data stage to load target database.
• Contributed to full project cycle from business requirements through specifications and implementation for RMW customization and DAC ETL execution plans.
• Created sessions and maintained workflows to fire loads at specified sequenced intervals.

Environment: OBIEE 10.X, Oracle 9i, Toad and Windows XP

Confidential

OBIEE Consultant

Responsibilities:

• Performed GAP Analysis to gather functional mapping by coordinating with the Business Users.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository.
• Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Finance Subject Matter Experts (SMEs), Business Analysts and Users.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed Custom tables to populate Brand, Category, Class, Region, Product, and Time Dimensions and Fact and Aggregated Facts.
• Developed Business models to represent business logic for Market Measurements.
• Created logical tables and defined the complex joins for a business model.
• Created dimension hierarchies for balanced and unbalanced hierarchies and assigned shared levels to respective hierarchy trees.
• Developed measure and dimension based aggregates to improve query performance.
• Developed custom logical columns and calculated measures using expression builder.
• Created presentation catalogs with restricted access to various business users.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema).
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) for performing the Marketing Trends analysis using Siebel Analytics Web.
• Experience in Dimensional Database modeling, Star Join Schema modeling, Snowflake modeling, FACT tables, Dimension tables, Performance tuning
• Expertise in debugging and optimizing Siebel Analytics Dashboards / Reports. Working With Reports & Customer Requirements
• Worked Extensively on Answers to create the reports as per the client requirements.
• Worked with various Market Forecasting subject areas and resolved various issues.
• Edited the download options to restrict public access of data from Dashboards to users worldwide.

Environment: OBIEE and sql.