SUMMARY 

• Total Experience of 9 Years in Data Analytics, Reports, Dashboards and KPIs
• Extensive Experience of around 3.5 years in Tableau Desktop and Tableau Server in various versions of Tableau 8.0, 8.1, 8.2, 9.0, 9.3, 10 as a Developer.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Expert in design/development using Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• 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.
• Extensive Knowledge in use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project.
• Outstanding knowledge in writing complex SQL queries.
• Strong data analysis expertise in the field of Financial Analysis, Financial Modeling, Accounts Receivables, Accounts payables.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Extensive experience in Rally tool for Project Management
• Strong data analysis expertise in the field of Financial Analysis, Financial Modeling, Capital Markets, Industry Research and Product Development

SKILL SET:

Project Methodologies: RUP, Waterfall, Agile (SCRUM) 

Databases: MS Access, SQL Server, Oracle

Datawarehouse /BI Tools: Informatica, Teradata

MS Office Suite (365) : Word, Excel, Access, PowerPoint, Project, Outlook

Domain : Banking, Financial, Capital Markets, Natural Resources, Metals & Mining, Telecom

PROFESSIONAL EXPERIENCE

Tableau Developer

• Understanding the business requirements by interacting with the business users.
• Created own customized visualizations in tableau
• Developed Proof of concept to showcase and measure the efficiency of the proposed solution
• Conduct kick off and follow up client meetings for these dashboards
• Development of dashboard in Tableau for data visualization to expedite the data analysis process and report automation.
• Design, configure, and document Tableau Data Source and Extract
• Built the Data Visualizations using Charts, Drill - Downs, and Quick Filters.
• Built the Dashboard View for Senior Executive Team.
• Involved in writing SQL queries using Teradata, Oracle 10g.
• Liase with various stakeholders to gather requirements and write functional requirement documents and mapping documents.

Environment: Tableau Desktop 9.0 Tableau Desktop 10.0 Tableau Server 9.0 , Oracle SQL, MS Office Suite, Teradata

Tableau Developer

• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• 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 Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• 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.
• Users to interpret functional requirements into report specifications. Involving in writing complex SQL queries to verify data from Source to Target Performed data validation testing writing SQL queries
• Accountable for creating financial Reports and Dashboards. Application has been designed driver-based planning - an approach that bases financial forecast on operational drivers supports Companies performance management. Created rolling forecast based budgeting, this will help FP&A team to plan ahead and more often and updated forecast with actuals. Developed several data input forms for Inventory, Accounts Receivables, Accounts Payables, Capex, Workforce and Financial statement planning.
• Had conducted deep dive meetings with the business users to understand the current automation process and Adhoc jobs for budget/forecast calculations
• Documented various business requirements, deployment plans and prepared various users guides to facilitate the users to learn and adapt to the new systems.

Environment: Tableau Desktop 9.0 Tableau Desktop 10.0 Tableau Server 9.0 , Oracle SQL, MS Office Suite

Tableau Developer

• Extracting data from different sources connecting them and used the same to create dashboard
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Creating data blending in case of merging two different datasets.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Developed product for Working Capital Management. The product is connected to a live database (S&P CapIQ). The data is pulled from the database into the excel which is fed into tableau. Calculations are performed in tableau for working capital. The product is fully automated, when the company ticker is changed, the data will update automatically according to the input.
• Worked on creating reports for every item under working capital such as Inventory, Accounts Receivables, Accounts Payables etc.

Environment: Tableau Desktop 8.3 Tableau Desktop 9.0 Tableau Server 9.0 , Oracle SQL, MS Office Suite

Research Analyst

• Defined and established strategies for data acquisition and processing of corporate actions, dividends, shares out, financials and estimates for Equities in the North American markets using vendor, temps & full time resources.
• Metals & Mining sector specialist covering African region. Analyzed industry trends and company drivers to quantify Bloomberg consensus sell side estimates. Initiated, developed and managed relationships with sell side sector analysts.
• Accountable for coordination of overall operations in writing company notes and earning updates on Financial Analysis on stocks listed in global stock exchanges.
• Perform assigned tasks in Metals & Mining and telecom sector; spearheads Initiation Coverage (IC) notes on the companies listed in the global stock exchanges with in-depth study of Economy, Industry and Company (EIC) analysis.
• Conduct Thematic Research on countries analyzing various parameters such as economic, political etc and prepare reports for review and reference.
• Efficiently employ Reuters Knowledge research tools and data sources like Bloomberg for screening companies

Assistant System Engineer

• Coordinated and worked on Data warehousing and Business Intelligence ETL tools to transform data from mainframes systems to Teradata. Collaborated with Project Manager, Business analysts for requirements gathering, business analysis and designing of End to End solution for Lincoln Financial Group Data Ware house Project.
• Employed Informatica tool to transfer the data into staging and then to Teradata database efficiently. Extensively involved in developing ETL Informatica mappings/sessions/workflows for all 4 different source systems using various Informatica transformations, which involve Source Qualifier, Expression, Aggregator, Union, Lookup, Filter, Router, Sequence Generator, Normalizer and Update Strategy etc.
• Involved in Documenting ETL Design Document for test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.

Environment: Informatica, Oracle SQL, Teradata, MS Office Suite