SUMMARY:

• Over 8+ years of working experience in IT industry as BI Developer, Tools including Tableau, QlikView and Hyperion with strong background in design, development and administration of transactional and analytical data constructs/structures.
• Experience in data quality, data organization, metadata, and data profiling. Involved technical support on data warehouse teams. Demonstrated ability to move from one sequential assignment to the next.
• Involved in creating Dashboards using Tableau Desktop, Tableau Server, and Business objects. Worked closely with Business during conversion of Business objects reports and dashboards to tableau.
• Experience in Installation, Configuration and administration of Tableau Server in a multi - server and multi-tier environment. Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from (Tableau7.0 to 10.0).
• Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Teradata, MS Access and client/server applications.
• Involved in developing custom images on Cloud using AWS images and on VMWare ESX using templates and involved in building physical servers using Kickstart PXE Boot and Jumpstart .
• Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin , normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000 .
• Strong knowledge of data and dimensional modeling, experienced in group facilitation with participants from diverse business functions and work skills.
• Able to perform development activities from gathering requirements and designing solutions, through developing code /reports to testing and release/deployment.
• Created Dashboard's using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, etc.
• Involved in health check of servers after patching/rebooting and checked all the services of Linux on AWS Cloud and also physical servers. Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers. Exposure to Mem SQL.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources ( Excel, CSV, Oracle, flat file, Text Format Data ) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Skilled in best practices related to reporting, dashboards, and data visualization; Salesforce integration. Design, implement , and maintain new and existing database objects including tables, indexes, constraints, stored procedures , and user-defined functions in support of data conversion projects.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Survey data, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project. Trained the users to understand Tableau in a better way.
• Extensive knowledge of CA Clarity data model and database tables, Stored Procedures, Functions & Triggers
• Strong technical and working experience with Crystal Enterprise Administrator Launchpad, Crystal Management Console, Crystal Configuration Manager, Crystal Migration Wizard, Crystal Publishing Wizard and e-portfolio.
• Strong in troubleshooting, monitoring, training and 24/7 production support in mission critical environments Worked with systems support team to define, architect and maintain highly available production systems.

TECHNICAL SKILLS:

Reporting Tools: Tableau 6/7/8,9.2,9.3,10.0,10.2,10.3 Desktop/Server, Central Management Console, Designer, Info View, Performance Manager, Dashboard Manager)

Methodologies: RUP, OOA, OOP, OOD, UML, Agile Modeling, SDLC model, Waterfall model, Spiral model, Use Cases, JAD

Databases: Oracle 11g/10g, MS SQL Server 2008/2005/2000 , IBM DB2 UDB 8.0/7.0, MS Access 7.0/2000, Erwin 3.5/3.x, XML, PL/SQL, SQL, SQL Loader and Developer 2000 and SAP HANA

ETL: Business Objects DI, Informatica (Power Mart & Power Center)8.1/7.x/6.x/5.x, Data stage 8.x/7/x, SQL Server/SSIS

Data Modeling: Erwin, PL/SQL Developer, SQL Navigator, SQL Loader, ER Diagrams, Conceptual, Logical & physical modeling

Programming Languages: C, C++, C#, SQL, PL/SQL, T-SQL, R- programming, Python

Web Technologies: Web Logic Application Server 6.1 / 5.1, Web Sphere 4.0.2/3.02

Operating Systems: Linux, UNIX, Sun Solaris UNIX, Windows NT/2000/2003

PROFESSIONAL EXPERIENCE:

Senior BI Tableau Developer

Confidential, Tampa, FL

Responsibilities:

• Experience with health care data with the understanding of business and data requirements to design Dashboards as per the business requirement.
• Experience in Medicare, Medicaid environments and worked with huge amount of data to support Business Intelligence/Analytics and have good knowledge on survey data.
• Worked with all aspects of Tableau development and production environments to build dashboards and to improve data analytics.
• Experience with the technologies like Greenplum, Hadoop, SQL in writing custom SQL and working with large data sets and optimize performance within Tableau.
• Providing the needs and fulfilling the requirements of the users with technical expertise in the development of technical, structural and organizational specifications.
• Creating documents and implementing standard and complex modeling requirements to monitor and enhance the capacity and performance of the tableau environments.
• Supporting the Business Intelligence/Analytics with the understanding of business and data requirements to design visualizations. Performing complex analyses and reviewing applications being released into production.
• Involved Conceptual, Logical data models based on Source system analysis and then built Physical data models including tables, primary keys, foreign keys, indexes, views, Stored Procedures and data types.
• Responsible for the design, implementation, and maintenance of various complex Tableau dashboards and reports for both external and internal end users.
• Advanced Tableau experience from dashboard design and development. Expertized with use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions.
• Well-versed to identify, design, and implement appropriate and effective visualizations as determined by available data.
• Performing design and development of Greenplum databases in testing, development and production environments.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Excellent analytical, communication, and time management skills; particularly the ability to effectively communicate technical ideas, needs and processes to non-technical audiences. Experience with analytics and BI reporting in Tableau.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

Environment: Tableau Desktop 9.2, 9.3, 10.2, 10.3, Tableau Server, Greenplum, Hadoop, PL/SQL developer, Visual Studio 2008, Oracle, MS Access 2010.

Senior Tableau Developer

Confidential, Carrollton, TX

Responsibilities:

• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Experience in working with Tableau and Business Objects presenting data via reports. Interpret measurement definitions, and perform data decomposition. Well versed in profiling data & interacting with business users.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Responsible for creating reporting data model as per the requirements. Experienced in constructing UX (User Experience) frameworks for desktop and mobile platforms. Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement.
• Experience in creating highly interactive data visualization Tableau Desktop & Tableau Server dashboards using features such as data blending, extracts, Level of Detail (LOD) calculations, filters, actions, parameters, context filters, sets, groups and aggregate measures.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Experience with data modelling using MemSQL both Row store and Column store. Experience with Oracle, DB2, HANA and good knowledge on in-memory functions. Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Expertized in troubleshooting the problems pertaining to pentaho reports and the reporting database environment. working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• 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.

Environment: Tableau Desktop 9.2,9.3, Tableau Server, MS Office Suite, Oracle, MS. Excel, MS Excel, PL/SQL developer, SAP HANA.

Senior Tableau Developer

Confidential, Dallas, TX

Responsibilities:

• Worked with Relational Database Management Systems (RDBMS) and data warehouse , including full reference architecture from data integration, through semantic layer and reporting.
• Independently worked on owning IT support tasks related to Tableau Reports on Server and worked as a Tableau admin , in charge of the report development and maintenance. Understanding of HR Datacenter based infrastructure ( server, storage, virtualization, BRS)
• Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels. Ability to influence multiple levels on highly technical issues and challenges.
• Involved in creating dashboards by extracting data from different sources. Created dashboard using parameters, sets, groups and calculations .
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment.
• Migrated existing legacy reports into Tableau while building new reports from formal data warehouse initiative. Worked to develop and manage the Tableau semantic layer through reusable data sources.
• Expertised to blend data from multiple sources to discover new opportunities. Worked to develop a front-end navigation scheme to support a formal dashboard portfolio strategy, including strategic, tactical , and operational dashboards.
• Built and maintained many dashboards. Created Backup scripts to take periodic backups for the content on Tableau server .
• Created Ad-hoc Reports based on the user requirement and modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Good experience in creating pivot tables and charts in Excel using data sources ( SQL Server, SSAS cubes, Access ) and power pivot.
• Demonstrated understanding of Business Intelligence Tool Development, Data Modeling, and Teradata database design.
• Developed a front-end navigation scheme to support a formal dashboard portfolio strategy, including strategic, tactical, and operational dashboards.
• Expertised in analyzing, designing and to build business intelligence solutions using Informatica, and databases technologies like Teradata.

Environment: Tableau Desktop 8.1, Tableau Server, MS Office Suite, Oracle, MS. Excel, Informatica 9.1, MS Access 2010, PL/SQL developer, Visual Studio 2008.

Senior Business Analyst Developer

Confidential, Coral Gables, FL

Responsibilities:

• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Experienced in developing dashboards and design requirements based on discussion with an understanding of technical and visual design considerations.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel. Performed queries to fetch new data, and create reports in Business Objects XI3.1 by connecting to Oracle Data Sources.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the HRdata on the fly with the usage of quick filters for on demand needed information.
• Working knowledge in technical aspects of business intelligence including data modeling, relational database management systems, ETL, metadata / data management, and OLTP tools.
• Data Management and Architecture experience. Understanding of the benefits of data warehousing, data architecture, data quality processes, fact and dimension tables, and data modeling.
• Knowledge of brokerage business, financial services, and Schwab. Created and updated conversion logic to resolve client issues in test and production environments.
• Expertise in query performance tuning . Developed and modified stored procedures and T-SQL scripts in response to validation exceptions.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting. Installed and configured the components required to integrate SSRS with MOSS Enterprise Edition.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, Business Objects 4.0/XI 3.1, Crystal Reports 2011/ 2008/XI/10.0, Oracle 9i/11g, MS Excel, PL/SQL developer.

Tableau Admin and Developer

Confidential, Hartsville, SC

Responsibilities:

• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users by using HR data.
• 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.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Involved in Writing Detailed Level Documentation for reports and Universe design. Involved in the designing and Building of Universes from different data sources like Teradata, Oracle/SQL Server.
• Generated reports using free-hand SQL, which had complex Business Logics. Created local variables with complex logics in the reports for calculating the metrics in the canned report. Used advanced functionalities like Optional prompts, Hyper-linking.
• Used Hibernate framework for the backend persistence. Tested the report data by comparing with the data from the report with the SQL outputs from the database to ensure the quality of reports generated.

Environment: Business Objects XI-r2, Web Intelligence, Desktop Intelligence, MS SQL Server 2000, SQL, Oracle Application Server.

Tableau Dashboard Consultant

Confidential, Chicago, IL

Responsibilities:

• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently. Analyzed the source data and handled efficiently by modifying the data types.
• Experience in creating multiple reports ( SSRS ) in Drill mode using tables, financial tables, crosses tabs and charts. Handled Tableau admin activities granting access, managing extracts and Installations. Published Workbooks by creating user filters so that only appropriate teams can view it.
• Embedded Tableau views into SharePoint. Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel. Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel. Designed, developed, and executed ETL packages to convert client data using stored procedures, functions, and SQL scripts in a Microsoft SQL Server environment.
• Created and maintained databases, spreadsheets, interactive self-service reporting web front ends, and other tracking mechanisms. Evaluated data collected and accurately identified and interpreted trends. Based on findings, prepared and communicated results and recommendations to various levels of senior management.
• Performed data analysis to identify data patterns and anomalies and done basic troubleshooting of conversion logic.
• Created and updated conversion logic to resolve client issues in test and production environments. Developed and modified stored procedures and T-SQL scripts in response to validation exceptions.
• Performed SQL Server administration activities ( backup, restore, DBCC commands, indexing, shrink ).
• Created Drill Down Hierarchies, Levels and implemented logic by creating Level Based Measures at BMM Layer.

Environment: Tableau Server 7.0/6.1, Tableau Desktop 7.0/6.1, Business Objects 4.0/XI 3.1

Report Developer

Confidential

Responsibilities:

• Involved in postproduction Support and gave training to the end users to create ad-hoc reports.
• Created full client and Web Intelligence reports. Modified the existing by adding new columns based on the result set.
• Created Web Intelligence reports with more than 10 data providers and synchronized the data using the merge dimensions option. Design and implemented process for migrating existing data from MS Access to MS SQL Server.
• Analyzed, designed and created reports for users Using Business Objects. Going through the client’s requirements and coming up with database design and application architecture.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Involved in translating high-level business requirements into logical business dimensional model.
• Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool. Written VBA macros and BOSDK for automation of execution of BO reports
• Scheduled reports with BAS. Created cascading list of values to enable cascading prompting in the reports using Designer.
• Published Crystal Reports to Business-Objects Enterprise System using publishing wizard.
• Created interactive Dashboards and Business Presentations with Crystal Xcelcius using QAAWS. Created new Universes specifically designed for creation of Dashboards.

Environment: Business Objects 6.5, Crystal Reports 8.5, Oracle 8.0