SUMMARY:

• Total 10 years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 3+ years of Experience in Tableau 8 and 9 (Desktop, Server) as a BI Developer. End to end involvement in designing and deploying data visualizations and creating Calculations, Formatting using Tableau Desktop.
• Proficient in data visualization, Reporting, Analysis, Pie Charts Bar Charts, Cross Map, Scatter Plots, Geographic Map, Page Trails, Density Chart and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Knowledge in Tableau server commands to migrate workbooks and Tableau server backup, Debugging and monitoring.
• Used SQL Queries at the custom SQL level to pull the data in tableau desktop.
• Validated the results in Tableau by running SQL queries in Oracle SQL developer.
• Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, prompts, Parametersetc in Tableau.
• Posses strong knowledge of database management in writing complex SQL queries, Joins, query optimization and resolving key performance issues.
• Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, SAS, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Worked with SQL Developer, Advisor Tools, Nitro Tools, Blades server, Microsoft Access databases, and Excel Spreadsheet.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Highly motivated team player and a Quick Learner with good communication, strong problem solving skills and excellent in presentation and interpersonal skills.
• Extremely well organized, meticulous and highly self - motivated.
• Extensive knowledge on Lean & Six Sigma projects.

WORK EXPERIENCE:

Tableau Developer

Confidential

Responsibilities:

• Worked with Business Analyst to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on SQL Server database and generated interactive dashboards.
• Created ad-hoc reports to users in Tableau by connecting various data sources.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Made complex chart like Spider chart and funnel chart to better visualize the data.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Analyzed the source data and handled efficiently by modifying the data types. Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
• Generated tableau dashboards with combination charts for clear understanding.
• Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports user-friendly in analysis purposes.

Technical snapshot: Tableau Desktop, Tableau Server, SQL Server, SQL Develope r .

Tableau Developer

Confidential

Responsibilities:

• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure.
• Created Views, Stored Procedures and validated data for the Performance.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, business views.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Worked closely with Data Modelers in designing various data warehouse schema techniques.
• Worked on the data provider that forms the basis of the ad-hoc analysis.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Executed and tested required queries and reports before publishing dashboards.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals

Technologies Used: SQL Developer, MS Excel, Blades Server and Advisor & Nitro tool

Data Specialist - Senior Process Associate

Confidential

Responsibilities:

• Creating interactive dashboards in spreadsheet, power points and submitting to the client.
• Handling Client Calls from AU and NZ regions.
• Have to analyze Markets / Channels, Products, facts, wise share trend details and create a dashboard based on that data.
• Have to do validation process for all the generated reports before submitting to the client.
• Have to Upload the Different type of analyzed reports in the Client server(Answers Desktop) and giving access permission to the respective client to the respective reports.
• Involved in giving report access permissions to the vendors and the clients.
• Involved in the process of automating the manual process in the sub-project teams.
• Involved in standardizing the SOP and getting approval from the client side.
• Implemented Lean and Six sigma project for my team.
• Involved in Estimating the time and FTE calculation for a new project/requirement.
• Upon request based, prepared and delivery the ad-hoc reports to satisfy the client

Technologies Used: SQL Developer, MS Excel, Citrix, Answers Desktop, and Advisor & Nitro tool

Report Analyst - Process Associate

Confidential

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 Trigger Updation 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

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