SUMMARY:

• Over all 10+ years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 5+ years of Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• In Depth Experience in analysis, design and development of reports using Tableau, Oracle SQL, PL/SQL and Data analysis
• Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Involved in Tableau Server Installation, Configuration,Creating Users, Groups, Projects and Assign Privileges etc.,
• Experience working in various industry sectors Health care, Pharma, ECommerce and Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth.
• Utilized all Tableau tools including Tableau Desktop, Tableau Public and Tableau Reader.
• Experience in Installation, Configuration and administration of Tableau Server in a multi - server and multi-tier environment.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Created and maintained various reporting dashboards to consolidate multiple views for internal and external purposes.
• Wrote SQL scriptsand queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports.
• Built and expanded reports available for both internal support and external customer/ carrier reports, which included increasing the scope of data extracted and utilized for reporting purposes.
• Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts.
• Tackle the most difficult of challenges and know how to get to the best solution.
• Excellent communicator - ability to tell a story through data.
• Experience with analysis, data, databases, and business intelligence.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Excellent with Actions and Quick Filters
• Created detailed design documentation for all the programs modified which includes data mapping, Process flow diagrams, high-level functional specification and detailed technical documenta tion using MS Word.
• As a team member Responsible for Understanding the business functionality of the system.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyse the level of effort on project specifications.
• Participated in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyse the level of effort on project specifications.

TECHNICAL SKILLS:

Reporting tools: Tableau Suite of Tools 9.0, 8.2, 8.1, 8.0, 7, 6, 5.1 includes Desktop,Server, Online and Public and Administration of Tableau Server.

Data modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema modeling,Snowflakemodeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWI, Oracle Designer and MS Visio.

Database: Teradata14.10/14/13, Oracle-11/10g/9i, MS SQL Server- 2012/2008/2005, DB2, MS Access.

SQL Programming: SQL, TSQL, PL/SQL.

Tools: & Languages: Teradata SQL Assistant, SQL Navigator, SQL Developer, TOAD, HP Quality Center, C#, Java, JavaScript, .NET, HTML, SQL

WORK EXPERIENCE:

Confidential, Minneapolis, MN

Tableau Developer

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.0, 8.2and 8.1.
• Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed Business requirements and prepared the dashboards as per the requirements
• Extracted data from different sources connecting them and used the same to create dashboard
• Modified the existing dashboard as per the user requirements. Used Tableau Desktop for creating different interactive views and dashboards.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Wrote UNIX and SQL scripts for pre & post session processes and to automate daily loads.
• Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities.

Environment: Tableau 9.0, 8.1, 8.2, Teradata 13, Oracle 10g, Crystal Reports 2008, MS Office Suite.

Confidential, San Jose, CA

BI Tableau Developer

Responsibilities:

• Interacted with Business users, Business Analysts to understand reporting requirements and transform them into technical specifications.
• Involved in the development of new TableauDashboards and publishing them to Tableau Server.
• Effectively involved in the data migration from Teradata server to MySQL Server of other reporting Systems.
• Effectively involved in the administration of TableauServer.
• Involved in the upgrade of Tableau server to its new version 9.1
• Build many Tableau reports using Bar Char, side-by-side bars, stacked bars, maps, tree map, pie charts, line charts, interactive reports using Tableau Desktop and Dashboard.
• Developed Tableau workbooks using DataBlending feature which involves the integration of multiple data sources like relational database and flat files.
• Involved in the different Dashboard actions like URL Filters, Action Filter and User Filters.
• Performed different calculations like Quick table calculations, Date Calculations, Aggregate Calculations, String and Number Calculations.
• Build Tableau Dashboards on different sources like Oracle Database, Flat Files (excel, csv) and OLAP database.
• Created Tableau data extracts (.tde) files to import dashboard users from csv file to Tableau Server using Extract API.
• Involved in the creation of Users and User Groups in the Tableau server.
• Worked on Tableau Command line tools tabadmin for Configuration settings in tableau Server and tabcmd for users, groups creation.
• Effectively involved in the maintenance of DataServer, metadata management, creating shared Datasources and publishing them to Tableau Server.
• Involved in creating Project workbench and published the reports as Object Package to BI Platform.
• Created Teradata External loader connections such as MLoad, Upsert,Update, and Fastload while loading data into the target tables in Teradata Database.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTILOAD andFASTLOAD.
• Created TD Objects like Tables, Views and used TeradataMacros for various Teradata analytic functions with the usage of techniques like RANK, ROWNUMBER and Ordered Analytical functions.
• Automate Teradata SQL Jobs in LINUX using Shell scripting.
• Involved in Performancetuning, including collecting statistics, analysing ExplainPlan& determining which tables needed statistics.
• Experience in scripting using Python.

Environment: Tableau 9.1, MongoDB 3.0, Teradata, Python, MySQL Server 6.2, Oracle 11g, Oracle PL/SQL Developer, Python 2.7

Confidential, Inc. San Jose, CA

Tableau Developer

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1.
• Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed Business requirements and prepared the dashboards as per the requirements
• Extracted data from different sources connecting them and used the same to create dashboard
• Modified the existing dashboard as per the user requirements. Used Tableau Desktop for creating different interactive views and dashboards.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Wrote UNIX and SQL scripts for pre & post session processes and to automate daily loads.
• Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities.

Environment: Tableau 7.0, 6.0, 5.1, Teradata 13, Oracle 10g, Crystal Reports 2008, MS Office Suite.

Tableau Developer

Confidential

Roles and Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1.
• Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed Business requirements and prepared the dashboards as per the requirements
• Extracted data from different sources connecting them and used the same to create dashboard
• Modified the existing dashboard as per the user requirements. Used Tableau Desktop for creating different interactive views and dashboards.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Wrote UNIX and SQL scripts for pre & post session processes and to automate daily loads.
• Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities.

Environment: Tableau 7.0, 6.0, 5.1, Teradata 13, Oracle 10g, Crystal Reports 2008, MS Office Suite.

Report Analyst - Process Associate

Confidential

Roles and Responsibilities:

• Creating MIS report and support the largest FMCG companies like Procter & Gamble and Unilever to know their product and Market Standards.
• Creating interactive dashboards in spreadsheet, power points and submitting to the client.
• I have played a team lead position and updating the triggers, work allocation, conducting daily review meetings.
• Handling Client Calls from ASIAN, ASEAN, GC, ANZ regions.
• Involved in writing SQL queries to retrieve data for Sales and Marketing Trending Report.
• Created Dashboards with interactive views, trends and drill downs.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created group and users in tableau server.
• Involved in creating VBA Macros in MS Excel to automate the day to day activities
• Handled Quality Documents - COQ, SLA, Monthly Dashboards, Defect Log, Metrics, and TriggerUpdating for my team.
• Responsible for prioritizing and allocating the day to day activities for the team
• Efficiently solved different escalations / issues / queries directly with customer.
• Worked with US, Australian, Singapore and New Zealand Clients directly.
• Maintaining MIS reports and Data Base on daily basis
• Provided Basic Training in Advisor and Process support for the new project team members.
• Preparing Monthly score card for our process.
• Preparing Unified Project Plan for our process.
• Experience in QC (Quality Check) for various processes Advisor, Nitro applications in TCS with additional Excel knowledge.
• Involved in Event Management

Technologies Used: SQL Developer, MS Excel, Citrix, MS Project Plan, and Advisor & Nitro tool

Confidential

MIS Reporting Analyst

Roles and Responsibilities:

• Provide support and maintenance to existing management information systems (MIS).
• Develops MIS documentation to allow for smooth operations and easy system maintenance.
• Provide recommendations to update current MIS to improve reporting efficiency and consistency.
• Perform data analysis for generating reports on periodic basis.
• Develop MIS system for customer management and internal communication.
• Provide strong reporting and analytical information support to management team.
• Generate both periodic and ad hoc reports as needed.
• Understand customer problems and provide appropriate technical solutions.
• Analyze business information to identify process improvements for increasing business efficiency and effectiveness.
• Participate in cross-functional meetings to resolve recurring customer issues.
• Training conducted for Franchise MIS tool to the fresher’s.
• Involved in the full systems life cycle and responsible for coding, testing, implementing, maintaining and Supporting applications software.
• Worked closely with customers, business analysts, and team members to understand business requirements

Technologies Used: SQL, Excel,FMIS, Power Point, MS Access