Candidates About

PROFESSIONAL SUMMARY:                                                                                                              

• 8+years of experience in Information Technology in System analysis, design, development, Implementation and maintenance of client server applications and Data Warehouse, providing Business Intelligence and OLAP solutions to Financial, wholesale distributing, Health Care, and Banking Sectors
• Extensive Experience in Tableau Desktop various versions of Tableau 6.1,7.1, 8.x,9.0,10.0 as a Developer and Administrator.
• Over 4+ years of Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage in Data Warehousing concepts.
• Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM) and its deployment.
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Exceptional understanding of Business Intelligence and Data Warehouse concepts.
• Experienced in Training & Supporting end-user reporting needs using Business Objects.
• Devised solutions to expedite the procurement of required data for unique website architectures comprised of X/HTML, JavaScript, jQuery, CSS, and AJAX.
• Handled importing of data from various data sources, performed transformations using Hive, MapReduce, loaded data into HDFS and extracted the data from MySQL into HDFS using Sqoop.
• Provided User training for the various dashboards.
• Developed Map-Reduce programs in HIVE and PIG to validate and cleanse the data in HDFS, obtained from heterogeneous data sources, to make it suitable for analysis.
• Conducted user training for core members to help them use the business process in standard SAP system.
• Core Team training in the HR module of SAP R/3 version 6.0. 
• Worked with transactional Data Info sources to load data from SAP R/3 and Flat Files into SAP BW.
• Working on Data Extraction from SAP R/3 using Generic, LO Extractions, Data Loading (Full/Delta Upload).
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Implement handful of dashboards in QlikView 11.
• Part of the end user team where in gathered requirements and organized scrum meetings.
• Prepared projects, dashboards, reports and questions for all JIRA related services.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Good Knowledge in relational/multidimensional databases and data modeling for OLAP/ROLAP.
• Extensive knowledge and experience in dealing with Data Warehouse and Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Good experience in Migration of Reports & Packages using Data Warehousing concepts.
• Strong understanding of Data Modeling in Data warehouse environment such as star schema and snow flake schema.
• Excellent knowledge on ETL tools such as Informatica, SAP to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards. 
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Deployed tableau server in clustered environment by adding worker machines. 
• In-depth knowledge on SQL queries and working with SQL Server 2000/2005/2008, Oracle 11G/8i, PL SQL.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Worked on data blending and increased the dashboard performance by extracting data.
• Experienced in Analyzing the BI Needs, interpreting business user requirements and translating them into reports.
• Good interaction with clients, understanding Business Applications, Business Data Flow and Data Relations.
• Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.
• Involved in various activities of the Software Life Cycle.
• Strong commitment to organizational work ethics, value based decision-making and managerial skills.

EDUCATION:

Bachelors of Technlogy (JNTU)

TOOLS AND TECHNOLOGIES:

PROFESSIONAL EXPERIENCE:         

Responsibilities:

• Led Visualization Architecture, promoted Best Data Visualization Practices.
• Designed Interactive Visualizations of Fragmentation, Compression, Usage, Query Optimization Statistics for all SQL Server Instances and Databases across entire corporate network.
• Worked as a Team Lead for this project and has been mentoring the other developer’s as well throughout this project.
• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Deep experience with the design and development of Tableau visualization solutions.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Set up groups and users for Business Objects deployment.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Installed and configured MapReduce, HIVE and the HDFS. Implemented CDH3 Hadoop cluster on CentOS. Assisted with performance tuning and monitoring.
• Created HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Loaded the customer profiles data, customer claims information, billing information etc. into HDFS using Sqoop and Flume
• Created reports for the BI team using Sqoop to export data into HDFS and Hive.
• Designed REST APIs that allow sophisticated, effective and low cost application integration.
• Responded to all incoming questions and inquiries related to JIRA applications.
• Developed rich interactive graphics and data visualizations of large structured data in browser-friendly formats.
• Supported customers in optimization and improvement of existing features of all API applications.
• Designed and documented REST/HTTP APIs, including JSON data formats and API versioning strategy.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.Creation of metrics, attributes, filters, reports, and dashboards.
• Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Writing tera data sql queries to join or any modifications in the table.
• Creation of customized Mload scripts on UNIX platform for Teradata loads.
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using dimension modeling with Teradata and Oracle.
• Expertise in working in Teradata V2R12.x systems and used utilities like MultiLoad, FastLoad, FastExport, BTEQ, TPump, Teradata SQL.
• Performed data extraction, transformation and loading from SAP and non-SAP source systems into the SAP BW.
• Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of reports Using BExAnalyser.
• Maintained Test log and Wrote test Evaluation, Summary Reports. Extensively involved in doing user acceptance testing (UAT).
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Experienced in designing report layouts in SSRS and deployed cubes using SSAS.
• Blended data from multiple databases such as Green plum, MS Excel and Oracle SQL database by assigning primary key from each databases. 

Responsibilities:

• Created dashboards according to user specifications and prepared stories to provide an understandable and helpful vision.
• Involved in creating dashboards by extracting data from different sources and also used data blending to blend two data tables in case of merging data using Tableau 9.0 Desktop.
• Created data visualizations and dashboards and applied various actions(URL, Filter, Parameters) in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Hands-on development assisting users in creating and modifying worksheets and visualizations dashboards.
• Created dashboards from different source systems such as Excel, Oracle, SQL Server and MS SQL Server.
• Maintaining server activities, user activity and customized views on Server Analysis.
• Integration of Tableau reports with web apps and usage of JS API for performance improvement.
• Designed standardized data mart with aggregated data, calculated metrics to suffice the source that the data need for various tableau reports and also worked with ETL developers, DBAs to implement the same in Development, Test and Production environment.
• Creating user groups, Data Connections and settings as a Tableau Admin.
• Knowledge on designing dashboards in QlikView.
• Participated in Qlikview and tableau comparison sessions.
• Created different types of charts in Qlikview Dashboards and also imported various data sources into the Qlikview Application.
• Used SQL, Powerpoint, InfoView and Excel daily to generate various performance reports for analysis.

      Responsibilities:

• Created dashboards according to user specifications and prepared stories to provide an understandable and helpful vision.
• Part of the requirements gathering team where in collected requirements from the end user.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters. 
• Participated in building and visualizing dashboards using Tableau Desktop. 
• Used Tableau visualization software to generate Tableau combination dashboards. 
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions. 
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Designed and developed Tableau dashboards using stack bars, bar graphs, scattered plots, Gantt charts.
• Blended data from multiple databases into one report by selecting primary key's 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. 
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets. 
• 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. 
• Created Stored Procedures, Triggers, Views and Functions with extensive use of PL/SQL and T-SQL.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Created SQL Queries for testing the tableau Dashboards.

   Responsibilities:

●        Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

●        Gathered user requirements, analyzed and designed software solution based on the requirements.

●        Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.

●        Interact professionally with diverse group of professionals in the organization including managers and executives.

●        Extracted the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau.

●        Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps,  using show me functionality.

●        Used Groups, hierarchies, sets, localization to create detail level summary report and Dashboard to cater users from different countries.

●        Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems

●        Coordinated database middleware issues with DBA's, system performance with System Architects.

●        Maintained server activities, user activity, and customized views on Server Analysis.

●        Implemented data security by creating user filters.

●        Developed and maintained web applications.

●        Designed Web Applications using JS, HTML and CSS.

●        Created SQL Queries for testing the tableau Dashboards.

Responsibilities:

• Created a data model for sales data in MySQL DB.
• Performed appropriate analysis on data forecasting and modelling.
• Created stored procedures on relational and dimensional data.
• Performed data validation for accuracy precision and scope.
• Performed DB Backup as another task which is a sub task of disaster recovery.
• Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions).
• Integrated various data file formats into single data file for report generations.
• Involved in gathering the requirements and identifying the key performance metrics for end users.