SUMMARY

• Over 6+ years of IT Experience in design, analysis, development and implementation of Various applications using BI Tools in different kinds of environments
• Expertise in reporting with Tableau visualization which provides business insights
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Bubble Charts, Tree Maps, Geographic Visualization and other making use of actions, other local and global filters and parameters according to the end user requirement.
• Experience working on Tableau Desktop, Tableau Reader and Tableau Server.
• Hands on experience in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Create the public objects like metrics, filters, prompts, custom groups, consolidation and reports.
• Worked on Calculated fields, parameters, different data sets and functions in Tableau.
• Well experienced in writing complex queries, stored procedures, functions using PL/SQL programming.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live datasets.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Extensive knowledge in Oracle Business Intelligence Enterprise Edition 11g.
• Well experienced in Data Modeling, Star and Snowflake schema
• Well experienced in Oracle BI Analytics, Repository (.rpd) which consists of: Physical Layer, Business Model and Mapping Layer, Presentation Layer and Interactive Dashboards, Reports with drill-down capabilities using page and dashboard prompts and other Web Catalog Objects such as Filters, Folders and data level security.
• Experience in creating dimensional hierarchies, level-based measures and adding multiple sources to business model objects.
• Extensive experience in building Interactive Dashboards with drill- down and drill- across capabilities
• Experience in modeling aggregate tables to speed processing and building calculated measures for the fact tables.
• Hands on experience in developing OBIEE repository development, configuring metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports).
• Proficient in using the Time-Series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts and creating pivot tables using OBI.
• Use of Key Performance Indicators for clear analysis for business users
• Good knowledge in data warehouse concepts, slowly changing dimension models, etc.,
• Strong understanding of software development life cycle methodologies.
• Outstanding knowledge in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint)
• Strong knowledge in OOPs concepts in core java, C++ and good knowledge in Hadoop architecture.
• Good Knowledge in Testing and software Engineer development life cycle methodologies
• Quick learner, excellent team player with the ability to meet deadlines under pressure.

TECHNICAL SKILLS

Operating Systems: Windows (2007/08/XP/Vista), UNIX, Linux

Languages: sql developer, sql plus, MS Sql Server 200X, Oracle 11g/10g/9i, C, C++, Core Java, SQL, Shell programming, putty, sql server management studio 2008, XML, html, python, JavaScript, CSS3, Booststrap

Business Analysis Skills: Requirement gathering and analysis, Use cases, Activity diagram, UML Rational Rose, System design, Process workflow redesign, software methodologies (SDLC)

Reporting/ETL Tools: Tableau desktop/server/reader 9.3/9.2/9.0/8. x, OBIEE 11g, Informatica Power Center 9.1, Informatica Repository Manager 9.1, Informatica Designer 8.6, Informatica Workflow Manager 9.1

Data Modeling: DW/ETL, OLTP, Erwin, Oracle SQL DM, Rational Rose, Kimball Datawarehouse

Others: MS Office, MS Visio, TOAD, FTP, SFTP, Toad, SQL Developer, Data Profiling, Data Mining, Eclipse IDE, RAD

PROFESSIONAL EXPERIENCE

Confidential, Fremont, CA

Tableau Developer

Responsibilities:

• Connected to mySql database and to create live connection to tableau workbooks.
• Developed reports for property management as per the requirement of business people.
• Customized the reports with total number of property listings and sold prices.
• Customized tooltips and labels to user understandable format in displaying number of days etc.,
• Generated data extracts and improved performance by reducing the amount of work for displaying of data in the visualization
• Building customized interactive reports, dashboards and story boards
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed various kinds of views which are visually appealing and clear in understanding even for a person from non-technical background.
• Applied global filters or choose a particular attribute in database to be as global filter to all the reports depending upon the requirement
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report
• Modeled all dashboard with appropriate filters for comprehensive analysis
• Many visualization alterations to a view in title, size and in different components of a dashboard page.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Public which allowed end users to understand the data with the usage of quick filters for on demand needed information.
• Used different kinds of views like line graphs, bar graphs, bubble charts, scatter plots etc.,

Environment: TableauDesktop 9.3,TableauPublic,MS Office Suite,MySQL, MS. Excel

Confidential, PA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Automate regular repository back up based as per business needs.
• Analyzing the existing system and to identify the areas of improvement.
• Create Technical design document, provide end user and manual.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Create the public objects like metrics, filters, prompts, custom groups, consolidation and reports.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: Tableau 8.3,9.0, Agile-Scrum, Informatica, UNIX, MS VISIO, Microsoft Office Suite, SQL developer, Oracle 11g

Confidential

Tableau developer

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Used Tableau to create visual interactive dashboards using calculations, parameters and workbooks for decision making.
• Worked on generating various dashboards in Tableau server using various sources like Teradata, Big data like Hive Hadoop.
• Experience with design and development of Tableau visualization solutions.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server, creating new schedules and checking the tasks daily on the server.
• Performed thorough unit testing, data validation, reviewed code, system testing & user acceptance testing prior to sign off & subsequent migration to production.
• Experience and knowledge on Data Profiling and Mining
• Data Warehouse Data modeling based on the client requirement using Erwin (Conceptual, Logical and Physical Data Modeling).
• SCRUM approach for monitoring daily progress
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Involved in Testing the reports and writing Test cases for Reports developed.

Environment: Environment: Tableau8.1 Reporting, InformaticaPower Center 9.5/9.0.1, SQL Server 05, PL/SQL (Stored Procedure, Trigger, Packages), T-SQL, CSV Files, XML Files, SQL Developer, Teradata (13), Teradata SQL Assistant, Erwin 7.2 Data Modeling, Oracle 11g

Confidential

BI Developer

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Involved in creating the Star Schema, Logical and Physical Modeling.
• Built the repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• Created Complex Joins, Alias Tables and Views.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics.
• To prepare and deliver a variety of interactive and printed reportsused SSRS along with crystal reports.
• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Oracle BI Answers and assigning them to application specific dashboards.
• Designed the Row Level Security for the Managers to View the Reports pertaining to their Region.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Involved in Testing the reports and writing Test cases for Reports developed.

Environment: OBIEE 11g 10.1.3.x, Web Logic Server 10.3, 10.3.3, Oracle 10g

Confidential

BI/SQL Developer

Responsibilities:

• Gathered business requirements, analyzing the requirements and writing detail design documents.
• Coordinated the requirements from external clients.
• Evaluated and documented existing processes for improvements.
• Involved in updating the logical model with all related entities, attributes and relationship with each entity based on the business rules/requirements using ERWIN.
• Data Analysis and validation of data using SQL.
• Involved in indexcreation, index removal, index modification, file group modifications,andadding scheduled jobstore-indexandupdate statisticsin databases.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Run the various Optimization technique to optimize the performance of queries by avoiding unnecessary use of The UNION, <> into statements & by using the TOP operator to limit the Select Statement in certain Queries

Environment: SQL Server management studio 2008, MS Excel