SUMMARY

• Over 12 + years of professional experience in IT industry working as a Business intelligenceexpert with more than 4+ years in Tableau dashboard development and 7+ years in SSRS
• Report development in various domains like Financial, Healthcare, Insurance and Bankingwith expertise in Tableau 8.x, currently upgrading to the newest version Tableau 9.0.
• Expertise in Tableau BI reporting tools & Tableau Dashboard developments.
• Expert in installation, configuration, upgrading and administration of Tableau Server.
• Expert in using Tableau desktop and its features like Parameters, Filters, Calculations and formatting the reports.
• Experience in OLTP Extraction from SAP R/3 to BW using different extraction structures such as Generic Extractors, Business Content Extraction, LO Extraction and Flat File Extractions of data.
• Involved in creating Dashboards and Reports in Tableau8.2. Created report schedules on Tableau server.
• Experience and strong proficiency in utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Histograms, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and making use of actions, other local and global filters according to the end user requirement.
• SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
• Experience in Tableau Administration tool on adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• End to end experience in designing and deploying data visualizations using Tableau.
• Extensive experience creating Ad-Hoc Reports in Tableau Desktop.
• Proven ability in defining Query for generating Drill down/Matrix/Charts/ Tabular/Adhoc reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2012, 2008r2.
• Expert in Writing SQL Queries on Oracle and DB2.
• Expert in creating Data mart reports and freeform SQL reports and worked in creating and integrating Microstrategy reports and objects Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidation with the data warehouse.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Exposure to Full Life Cycle Solution Development (Requirement gathering, Analysis, Design, Development, Documentation, Testing and User )
• Intensely interacted with Developers, Business Analysts and Project managers toward testing and documenting new products and enhancements.
• Comprehensive experience in interacting with the clients and understanding business application, data flow in business and data relations from them.
• Extensive knowledge in Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
• Having good communication skills, Team lead and player and interpersonal skills.
• Can handle multitasks at the same time and fulfill the required work before deadlines.

TECHNICAL SKILLS:

Languages & Technologies: Java (JDK), J2EE - Java Beans, SQL, PL/SQL, HTMLETL Tools Data stage, Informatica.

Operating Systems: MS Windows NT/2003/XP/ME/95/98, Windows 7, UNIX.

Databases: Oracle 7.x/8i/9i/10g/11g, SQL Server2000/2009, Teradata

Operating Systems: Solaris 8/10, Linux 6.x/7.x/8.x/9.x, Win 95/98/NT/2000

Web servers: Tomcat, Apache, IIS

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr Tableau Developer/BI Analyst

Responsibilities:

• Move the data from different data sources like ORCALE to SQL server
• Involved in creating database objects like tables, views, procedures, triggers, and functions using SQL Server to provide definition, structure and to maintain data efficiently.
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Fine \tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented data warehouse architecture for corporate circulation data warehouse. Subsequent data marts, extracts and reports were sourced from the architecture of conformed facts and dimensions
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Developed Tableau visualizations and dashboards using Tableau Desktop.

Environment: Tableau Desktop/Server 9.0/8.x, Oracle 11i, SQL, Toad, Windows 2003/ XP

Confidential, Minneapolis, MN.

Sr. Tableau Developer/BI Analyst

Responsibilities:

• Understood the business challenges and translated them into requirements and developed Reporting Queries according to Business Requirements.
• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Development, Testing, Reporting, and Go-live.
• Converted the Functional Specifications to Technical Specifications and prepared Functional/Technical Specification documents and upload the revised documents in SOLMAN and some documents shared folder, changes in documents updated periodically.
• Developed Master Data and Transactional Data process chains based on the SAP subject modules.
• Developed the Reports like Agreements and Agreement Requests, Condition Rate Deviation (for Price Deviations between client and bulk purchasing customers), Billing Documents, Deliveries, and Delivery Delays per Sales Area (This report mainly focused in India region), Incoming Orders Analysis (US and UK Region) and Incorrect Delivery Quantities.
• Designed developed BEx Queries on client SAP subject areas.
• Activated business content of MM & SD to fulfill the End-User report requirements.
• Designed and developed sound BI Data Model to extract data to target system with the required dimensional structures by enhancing the ECC Data Sources, build up Transformations, and DSO/Cubes.
• Designed DSO’s, Infocubes and Multiproviders.
• Activated Standard Datasources, InfoSources, Infocubes and ODS.
• Experience with high-volume SAP BW environments and performance tuning analysis including Indexes, Aggregates, Statistics, Compression, Code Review, Query Design Review, etc.
• Maintained frequent data load failure tracking list among the group members to resolve repeated issues more easily.
• Created Views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Converted Charts into Crosstabs for further underlying data analysis in MS Excel.
• Combined Views and Reports into Interactive Dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Developed Story Telling Dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Blended data from Multiple Databases into one report by selecting primary key’s from each database for data validation.
• Reviewed basic SQL Queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Scheduled Data Refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: SAPBI, ECC6.0, BEx, and Tableau SD &MM.

Confidential, Waukesha, WI.

Sr. Tableau Developer/BI Analyst

Responsibilities:

• Mentored business power users to create reports/dashboards using tableau desktop.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Created Dashboards with interactive views, trends and drill downs.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Published Workbooks and Dashboards to the Tableau server.
• Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
• Upgraded Workbooks and Dashboards from Tableau 7 to 8
• Created groups and users in Tableau server
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau. Effectively used data blending, quick filters, actions, hierarchy features in tableau.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau Desktop/Server 9.0/8.x/7.x, Oracle 11i, Windows 2003/ XP

Confidential, Hingham, MA.

Senior BO/Business Analyst

Responsibilities:

• Worked on improving the cube and query performance by building suitable aggregates and other tuning techniques
• Worked on Sales order, service order and Equipment user and system status to provide latest status of the documents for business community
• Involved in Data Modeling, data extraction, designing, creating, maintaining and analyzing Info Cubes, ODS (DSO) objects, DTP, Remote Cubes, Multi Providers, and Info-Sources, Extract Structures, Update rules and Transfer rules
• Experience in Data Modeling, R/3 and Non R/3 Data Extraction, BEX Reporting.
• Designed, Developed and Implemented around 100 plus reports.
• Design, Customization & development of Info Cubes, ODS, DTP, Multi-Cubes, Remote Cubes, Info Objects, Hierarchies, Data sources, update rules, transfer rules and start routines.
• Designed complex universes consisting of several fact tables and used contexts to meet specific reporting requirements
• Developed a Generic extractor with delta capability from a database view.
• Optimized the performance of data targets (Info cube, ODS, Multicubes) by loading the data through proper selection criteria and maintained the request for each data load to compress it in the future and maintaining proper aggregates.
• Fulfilled end user reporting requirements with Crystal Reports 2008
• Resolved several issues with existing universes and implemented performance increasing solutions in universe design
• Worked on new Crystal Reports development as well as production support for existing reports.
• Conducted Data profiling for OLTP and Business Intelligence applications.
• Created data flows and process flow diagrams.
• Created Meta Data Repository for the management of business and technical Meta Data.
• Performed Data Quality analysis, auditing, metrics gathering, ROI analysis, data cleansing and standardizing data.
• Data Sources included RDBMS, Flat Files and Web Applications.
• Analyzed the Campaign Management System for overloaded attributes, embedded relationships, redundancy and inconsistent data.
• Scheduled reports from CMC and Info view.
• Created Dashboards by using Xcelsius retrieved data from Excel file by using Live Office.
• Developed several Complex Reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.
• Created complex Xcelsius dashboards by connecting directly with existing Crystal Reports and XML files.

Environment: Business Objects XIR2/XI R3, Universe Designer, Web Intelligence, Xcelsius 2008, Windows server 2003, SQL Server 2005, Informatica, Business Objects Data Integrator, Live office, Query As A Web Service, SAP BW 7.3 / BI 7.0 / BW 3.5, ECC 6.0, FICO, SD, PP, MM, CRM, HR, APO Demand Planning Tool.

Confidential, Detroit, MI

Sr. Report Developer / BI Developer

Responsibilities:

• Actively supported business users for changes in reports as when required using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Created linked reports and managed snapshots using SSRS.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Created many complex ad hoc reports like Tabular report, parameter report, drill through, and drill down reports in SSRS; and created reports subscription schedule for managers and clients.
• Used complex expressions to group data, filter and parameterize reports.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services, SQL Server Integrating Services, SQL Server Analysis Services, T-SQL.

Confidential, Jersey, NJ

Sr. Report Developer / BI Developer

Responsibilities:

• Involved in configuring report server using report server configuration manager and deployed the SSRS Reports in report server.
• Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
• Developed complex queries to fetch data from various tables from various remote databases.
• Provided Production support to analyze and fix the problems and errors on daily basis by modifying SSIS Packages and Stored Procedure if necessary.
• Created SSIS packages to load Adhoc tables in the Data warehouse staging environment.
• Created SSRS reports according to the user requirements and technical standard and customized output formats from SSRS to PDF, Excel and CSV
• Used SSIS import / export wizard to perform ETL operations.

Environment: C#, Microsoft SQL Server 2005/2008, SSIS, XML, BIDS, MS Visio, Microsoft Share Point Server, T-SQL, .NET, MS Word and Excel, SQL Profiler.

Confidential, Charlotte, NC

Business Analyst / Reports Developer

Responsibilities:

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Designed and developed project document templates based on SDLC methodology.
• Designed and developed extranet for internal reporting functionality for client.
• Designed and developed shell scripts to schedule data loading process to staging server
• Gathered and documented business requirements for existing and future business systems.
• Responsibilities included requirement gathering, business process flow, business process modeling and business analysis.
• Conducted workflow, process diagram and gap analyses to drive requirements for the automation process.
• Worked with the business unit to define business requirements and analyze the possible technical solutions.
• Providing Support and Maintenance for all the clients.

Environment: Sun Solaris, Windows NT, Oracle 9i, My SQL, JSP, Servlet, MS Office Suite, Micro Strategy, Desktop Report, OLAP Services, Architect, Narrowcast Server, Administration, Erwin, Oracle 10g, and Windows 2000

Confidential, Alexandria, VA

Business System Analyst

Responsibilities:

• Interacted with business owners to identify business system needs evaluated solutions for business problems and proposed alternate methods to increase efficiency.
• Developed Functional Specifications document, Use Cases, Process Flow diagram and Requirements Traceability Matrix for business requirements and enhancements
• Followed the RUP framework of iterative software development life cycle.
• Analyzed and documented information system requirements and the corresponding impact on the business processes.
• Worked as a team with other business analyst to make an object oriented model of the application and create use cases.
• Identified the various table level changes required to implement the new products and changes.
• Performed Gap Analysis for new functionality requirements and prioritized them based on the business needs.
• Responsible for organizing the QA walk through to explain proposed changes. Coordinated with the test team to check the weekly status and report the same to the project manager.
• Responsible for interacting with the developers to explain the proposed changes and understand the system requirements to handle these changes.
• Formulate comprehensive test plan based on requirements and develop test scenarios based on the use cases.
• Responsible for maintaining the minutes of all the requirement gathering sessions.

Environment: UML, IBM, IBM Rational Software Modeler, Java, J2EE, JSP, ASP, HTML, SQL Server 2000, Oracle 11i, Microsoft Office suite, SharePoint Test Director, Win Runner, Macromedia Dreamweaver.