SUMMARY

• Over 9 years of extensive experience in Report design, Dashboard development, data quality testing, Quality Assurance and Testing of Software applications.
• Expert in Data Visualization development using Tableau/Power BI to create complex, intuitive, and innovative dashboards.
• Proven ability to deliver and ensure success in high - pressure/high-risk situations.
• Involved in many aspects of the SDLC including requirements gathering, proof of concept delivery, implementation, user support and maintenance.
• Administered user, user groups, subscriptions and scheduled instances for reports in Tableau.
• Hands-on training sessions with users in creating and modifying worksheets and data visualization dashboards.
• Created incremental refreshes for tableau data sources on Tableau server.
• Experienced in developing Custom Report and different types of, Tabular Reports, Ad hoc reports in multiple formats using SQL Server 2008R2/2012/2014 Reporting Services (SSRS).
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets, bins and set actions to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Self-starter in gathering Business Requirements from product Owner interacting with the Business Analyst, Project Manager and SMEs to get a better understanding of the Business Processes to develop interactive visualizations.
• Stretched tableau limits to create unconventional tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, stacked bar charts, Histograms, Bullets, Heat maps and some out of box visualizations.
• Developed Tableau and Power BI dashboards by sourcing, processing, managing, and distributing business-driven and actionable visual reports for key stakeholders.
• Defined best practices for Power BI report development.
• Prepare and clean data using Tableau Data Prep for data analysis.
• Experience in Alteryx Designer, Alteryx Server and the tools within Alteryx such as Predictive, Spatial, Data Investigation, Parsing and Transforms.
• Translated business logic from one system (SQL, Excel, etc.) into Alteryx in a quick and accurate manner.
• Created Informatica (BDM) Mapping for extraction, transformation and loading of data from heterogeneous sources to target (database, txt, xlsx files) using filter, connected lookup and unconnected lookup, joiner, aggregator etc. transformations which are subjected to run on Hive, Blaze or Spark engines.
• Experience in optimizing query performance, workflow performance and fine tuning the mappings for optimum performance and resolving the bottlenecks in Source, Target, Transformations, Mappings and workflows.
• Created all JDBC, ODBC and HIVE connections to the Informatica Developer Client Tool to import the parquet files and the relation tables.
• Expertise in Design and Development of User Interfaces Using Java Script, Bootstrap, jQuery, HTML and CSS.
• Extracted the data from Oracle, SQL Server using Sqoop and loaded data into HDFS Having good work experience in RDBMS such as Oracle 9i, 10g, DB2, MySQL and SQL server.
• Experience in Relational Database Design, Data Extraction, Data Transformation and loading from large and Complex Data Sources Using MS SQL server 2014/2012/2008 R2.
• Estimating task and workload to achieve deliverables and goals, delivering on time and on estimation. Maintaining technical skills and expertise through continuing education and training.
• Experience in Designing SSIS(DTSX) Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and union all.
• Good experience in working with TOAD, SQL developer, Hue.
• JIIRA, SVN, TFS (Team Foundation Server), Bitbucket.
• Participation in all phases of Software Development Life Cycle (SDLC) including analysis, design, coding, testing and good experience with software development methodologies like waterfall and agile.
• Good exposure to Agile development methodologies, tools and processes (Kanban or Scrum)
• Good understanding of statistics concepts (e.g., hypothesis testing, regression analysis)
• Worked on the development of google, Bing, Facebook AdWords API’s for consumption of AdWords reports daily and develop ETL code to have seamless transition into data warehouse.
• Strong debugging and problem-solving skills with excellent understanding of system development methodologies, techniques and tools.

TECHNICAL SKILLS

Reporting Tools: Tableau 2020.2/2019. x/2018.x/10.x/9.x/8x, Microsoft Power BI, Alteryx 2019.4/11.8/11.7 , Tableau prep, SAP BO, SQL Server Reporting Services, Crystal Reports, Neo 4j, Google Analytics.

Programming Languages: C# (4.0/3.5/3.0), SQL, PL/SQL, R programming, Unix Shell programming, Java Script, HTML.

Databases: Snowflake, SAP HANA, SQL Server, MySQL, Cloudera Hadoop, HDFS, DB2, HP Vertica, Teradata, Oracle 10g/11g, Amazon Redshift, graph database, Google Big Query (GCP).

IDE: MS Visual Studio.NET 2012, 2013, SQL Enterprise Manager, SQL Management Studio, Adobe Photoshop 7.0, Hue.

ETL Tools: Informatica BDM (10.2.0/10.2.1 ), Azure Data Factory, Alteryx, SSIS (SQL Server Integration Services).

Version Control: SVN, Tortoise SVN, TFS, Bit bucket, Azure DevOps.

Other Tools: Confluence, JIIRA, SSAS, VersionOne, Adobe Omniture, HP ALM, Putty.

.Net Technologies: ASP.Net MVC, ASP.Net (4.0/3.5), ADO.NET, Web Services, WIN FORMS

Web Technologies: XML, jQuery.

PROFESSIONAL EXPERIENCE

Confidential

Visualization Analyst

Responsibilities:

• Worked with Business lines to gather the requirements and document Business Requirement for carry out system design, gathering data sources and approach with optimal technical design.
• Responsible for solving highly technical and complex problems on Financial, Inventory Change, Value-chain, Asset Performance, Production and Sales, Material Movement, Shale oil extraction Projects / Use-cases.
• Develop and strategize methods where dashboard would allow users to understand and analyze data facts with real time attributes.
• Facilitated and Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle and to meet S&C Standards.
• Created dashboards in Tableau/Power BI connecting to various sources like HANA, SQL Azure Cloud, SQL Server, Excel, Oracle and Snowflake, Amazon Redshift (AWS).
• Hands on experience in maintaining tables, views and store procedures in SQL Server/Azure.
• Migrated Tableau Dashboards to SAP Analytics Cloud connecting data from Hana and Oracle sources to build models and stories.
• Suggested and Built Power BI reports due to conflict on the Tableau upgrade cycle and hosted the dashboards on Power BI Service.
• Created row level security and created workspace, published apps in power bi service.
• Created Calculated/Materialized views in Hana to implement input parameter driven KPI’s and Metrics via Tableau to balance the high availability of the dashboards.
• Built Profitability, benchmarking dashboards to provide improved management of platforms around the globe and help controllers and asset managers to improve efficiency of operations and cash flow with data from Data flex, EC and BW Hana.
• Built Auditable Facility balance dashboards which helped the reservoir Engineers and Measurement COE to provide visibility on highest risk / highest exposure meters to enhance prioritization of staff deployment and saved $$ in operations.
• Built Plant Mass Balance dashboards to monitor Meter health, inventory changes, material movement of various products produced.
• Designed and developed SSIS packages by extracting data from flat files and json files and load in data warehousing tables.
• Built daily/monthly/reconciled production, inventory, allocation, provisional and consolidated OBO dashboards of onshore or offshore platforms to monitor production and operational KPI’s in Power BI.
• Built Volt Downtime tool to support reliability and production teams better understand and capture information regarding Downtime volumes and events.
• Created dashboards to monitor Tableau session loads and stats for load times.
• Created measures by using complex DAX formulas. Used time intelligence functions, logical functions, conditional formatting, variables.
• Build Alteryx data workflows to source data from the various sources types to a staging area like SQL server database management systems.
• Worked on POC’s to establish data movement via Mule soft API’s to Azure data factory/Snowflake applications to assess best environments to better serve the global users.
• Worked on embedding and Integrating Tableau dashboards inside UI5/Fiori using JavaScript API.
• Created and modified PL/SQL, SQL Loader scripts and stored procedures for data conversions and create database objects dynamically based on user inputs via MDI.
• Worked as a site administrator to create/manage projects, dashboards and permissions.
• Implemented security and authentication with SQL Server/Azure coordinating with the admin team by using SAML Authentication.
• Created visualization in Neo 4j by connecting to graph database using cypher query language.

Environment: Tableau 2020.2/2019. 2/10.5, Azure cloud, SQL Server, Power BI, SAP Analytics Cloud, Snowflake, Bit Bucket, Microsoft office, Amazon Redshift (AWS), SQL Server, SAP BW, SAP Hana Studio, R Programming, Alteryx 11.5/2019.1 , SAP UI5, Graph Database, Neo 4j, TFS, Google Data Studio.

Confidential

BI Developer

Responsibilities:

• Analyze customer behavior working with clickstream or web traffic data and Identify web traffic patterns on digital Marketing & sales of campaigns which support’s client’s decision-making
• Design, develop, Test, and maintain Tableau reports and dashboards based on user requirements connecting to Google Big Query (GCP), Impala, DB2 etc.
• Embed the Visualizations with salesforce product using JavaScript API.
• Restricted data to Individual user using Row level security and User filters.
• Created SQL scripts for building reports in SSRS with SSRS Expressions and built the reports in Ad hoc Tool called Report Builder.
• Administered user, user groups, user-based subscriptions and scheduled instances for reports in Tableau server.
• Create Alteryx workflows for such scenarios where data is not readily available.
• Performed elevation of Alteryx workflows to higher environments, using SVN as a repository to host the Alteryx workflows, Config Files and Macros needed to run the workflow
• Use workgroups database to identify the user adaptability on the dashboards.
• Based on business requirement, developed Complex SQL queries with Joins and sub queries in T-SQL, Stored procedure, Views to implementing the business rules and transformations.
• Developed multiple ETL processes using transformations and containers like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Union All, Flat file Source, Flat file Destination, Conditional Split, lookup, for each loop container, sequence container.
• Subject Matter Expert for raw data and data structures related to the Adobe Omniture product working closely with the Web and Creative Team to enable data visibility from the configuration they would perform through to the data being landed and presented in the warehouse.
• Worked on the development of google, Bing, Facebook AdWords API’s for consumption of AdWords reports daily and develop ETL code to have seamless transition into data warehouse.
• Analyze data from different sources like Oracle, Cloudera, Flat files including Delimited and Fixed width like text files, Adobe Omniture from which the Click Stream data is extracted and understand the relationships by analyzing the OLTP Sources and loaded into Cloudera data warehouse.
• Made use of python libraries to parse xml files for extraction of key attributes.
• Used pandas for processing sets for time series analysis.
• Implemented the application to move the obsolete Informatica objects from main folders to obsolete folder using the UNIX shell scripts.
• Collaborating/Partner with other teams including Enterprise Testing, Release Planning and Management, Development, Project Management, and Application Support on successful delivery of systems enhancements.

Environment: Tableau10.x/9.x/2018.2, Oracle 12c, Cloudera Hadoop, Hive, Impala, DB2 (IBM), HDFS, Eclipse, Hue, HBase, Bamboo, SQL Server, Confluence, Version One, Bit Bucket, Bamboo, Adobe Omniture, HP ALM, Alteryx 11.8/11.7, Tableau Prep 2018.1 and 2018.2, Toad data point, Python, informatica BDM 10.1,10.2, Toad for oracle, Cisco information Services.

Confidential

Tableau Expert

Responsibilities:

• Create different KPI's using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
• Created Complex visualizations sourcing data from heterogeneous sources and cross joined them using Tableau 10.
• Create visualizations using MS Power BI for a POC for comparison with Tableau Dashboards
• Leverage Tableau built in graphical capabilities and functions to create out of box visualizations and calculations.
• Extracted the data from Hadoop Data lake using Hive connection and created Dashboards and Story boards
• Worked on a POC of ThoughtSpot a tool used for Search driven Analytics.
• Integrate Narratives for Tableau for Interpreting visuals in natural language for business users.
• Develop views which can visualize YOY, QOQ, YTD, STLY, QTD and MTD type of analysis and LOD functionality
• Developed several Teradata SQL Queries using Teradata SQL Assistant for Ad-hoc data pull request.
• Worked on optimizing and tuning the Teradata views and queries to improve the performance of batch and response time of data for users
• Integrate Tableau dashboards with third party web-based applications (Microsoft CRM Dynamics).
• Implemented the forecasting using R programming libraries to predict the statistical analysis.

Environment: Tableau 10.0/9.3/9.2/9.1 , Oracle 12c, Hadoop, Tableau Server 9.3/10.0, MS Power BI, Power Pivot, SQL Server, Confluence, Jira, TFS, Microsoft CRM Dynamics, R server, Teradata.