Business Intelligence Data Analysis

Raj Lammata

Status: US Citizen

Phone +1-503-***-**** Email: *************@*****.***

Professional Summary

Tableau Developer with 11+ years of experience in data analysis, data visualization, and business intelligence. Known for creating effectual tools/solutions and leading efforts to improve data analysis and organizational capacity, increase efficiency, significantly simplify processes, and enhance performance and productivity. Expertise with Tableau, Microsoft SQL Server, Python, NumPy, and Rally.

CORE STRENGTHS:

Tableau Desktop [2022.2] » Tableau Server/Administration » Microsoft SQL Server & Server Reporting.

Python » Rally » NumPy » Pandas » Crystal Reports » Tableau Development » Reporting Package Creation.

Project Management » Project Deadline Adherence » Complex Problem-Solver » QA Methodologies.

Dataset Pattern & Trend Identification » Technical/Client Support » Report & Document Generation

Professional Experience

Qualinfotech, Dallas,Tx

Tableau Developer Sep 2023 to Present

Project Leadership: Directed a team of [X] Tableau developers and analysts, overseeing end-to-end development of interactive dashboards and reports.

Data Visualization: Designed and implemented complex Tableau dashboards, ensuring alignment with business requirements and enhancing data-driven decision-making.

Stakeholder Collaboration: Acted as the primary liaison between business stakeholders and technical teams, translating business needs into technical solutions.

Performance Optimization: Enhanced dashboard performance by optimizing data models and queries, leading to a [X]% reduction in load times.

Leadership: Demonstrated ability to lead cross-functional teams, manage projects, and mentor junior developers.

Training & Mentorship: Conducted workshops and training sessions for team members on best practices, new features, and advanced Tableau techn

Data Modeling: Skilled in data multiprocessing, and data warehousing concepts.eg, ETL

SQL: Advanced SQL skills for querying and manipulating data to support dashboard development.

Tableau Desktop & Server: Proficient in Tableau Desktop, Tableau Server, and Tableau Online with extensive experience in building and deploying dashboards.

Communication: Strong interpersonal and communication skills, capable of presenting complex data insights to non-technical stakeholders.

Problem-Solving: Excellent analytical and problem-solving skills, with a track record of overcoming technical challenges and delivering innovative solution.

Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router, Aggregator and lookup Transformations to create mappings.

Extensively used Informatica client tools to extract data from different sources like flat files and Oracle.

Developed several complex mappings and reusable transformations to facilitate one time, Daily, Monthly and yearly loading of data.

Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.

Responsibilities: Involve in Planning, Defining and Designing data based on business requirements and provide documentation.

Verizon, Dallas, TX Feb 2022 to Aug 2023

Tableau Developer/Data Analyst

Designed and built dashboards for use in monitoring performance metrics while maintaining existing dashboards for accuracy and efficiency and incorporating changes using Tableau.

Used advanced chart visualizations in Tableau—such as dual axis, box plots, bullet graphs, tree maps, bubble charts, and waterfall charts—to solve complex problems and to create interactive dashboards and visualizations.

Served as a Tableau Liaison to mentor our team on all Tableau best-practices while supporting other developers specifically in data-source identification.

Developed and reviewed simultaneous SQL queries in Tableau Desktop to validate both static and dynamic data for data validation.

Methodist Health System, Dallas, TX March 2018 to Jan 2022

Tableau Developer/Data Analyst

Conducted data analysis, performed business-analysis tasks (such as creating project plans), received data and records in multiple formats, and worked on performance-turning to help in comprehending joins and data distribution.

Utilized Tableau Desktop to create multiple rich dashboards that appropriately told stories of business status and success, strengths and weaknesses, and potentials; also offered at a glance, visual representations of profitability, products, and customers.

Created a data-collection template on Excel for reinsurance metrics that were approved for ongoing use.

Designed stored procedures, triggers, cursors, tables, and views for several applications while generating comprehensive analytical reports by running SQL queries against current databases to conduct thorough data analyses.

Strategically implemented incremental data extracts (which were updated on a timely basis as data updates), refreshed extracts, optimized and tuned applications for maximum memory management, and performed scheduling.

Nation Wide, Columbus, OH Sep 2016 to January 2018

Tableau Developer/Data Analyst

Responsibilities:

Roles and Responsibilities: Interaction with business to collect and understand Requirements.

Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router, Aggregator and lookup Transformations to create mappings.

Extensively used Informatica client tools to extract data from different sources like flat files and Oracle.

Developed several complex mappings and reusable transformations to facilitate one time, Daily, Monthly and yearly loading of data.

Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.

Used Informatica Workflow Manager for creating, running the Batches, Sessions and scheduling them to run at specified time.

Citizen Bank, RI June 2015 to August 2016

Tableau Developer/Data Analyst

Responsibilities:

Analyzed existing requirements with end user and documented them for Tableau.

Extracting metadata and source queries from SSRS reports.

Developing new versions of reports in Tableau using Analysis on older SSRS Reports.

Prepared and published customized reports/dashboards.

Converted Micro strategy reports into Tableau.

Created different Action filters, Parameters and calculated fields to create most complicated dashboards.

Worked with Tableau administrator in managing Production, Test and Development environments.

IMHC, Salt Lake City, UTAH February 2014 to May 2015

Tableau Developer/Data Analyst

Responsibilities:

Customer Support calls were recorded in this project and analysis is performed to check the overall satisfaction of the customer.

Depending on the call logs analysis is performed to check out most frequent questions asked by customers and their solutions are implemented in automated manner in the form of IVR.

Responsibilities: Involve in Planning, Defining and Designing data based on business requirements and provide documentation.

Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.

Optimize Indexes, Views, Stored Procedures and Functions using Oracle.

Create Schedules and extract the data into Tableau Data Engine.

Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.

Manage the Tableau solution architecture, administration and actively manage the performance and usability.

Allstate Insurance, IL June 2013 to December, 2013

Tableau Developer/Data Analyst

Responsibilities:

Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc).

Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.

Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.

Used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards.

Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.

Expert level capability in Tableau calculations and applied complex, compound calculations to large, complex data sets.

Technical Skills

Operating Systems: Windows [Version #s]

Languages: SQL, PL/SQL, T-SQL, Python, R, Visual Basic (VB), .NET, Java, Python, C++, Scala, MATLAB

BI Tools/Reporting: SSRS, Tableau [2022.2], Crystal Reports

Software: Microsoft Office suite (Word, Excel, PowerPoint, Visio)

Development Tools: Microsoft Visual Studio

ETL/Agile Tools: SSIS, Rally, TFS (Team Foundation Server)

RDBMS: Oracle, Microsoft SQL Server, Microsoft Access, DB2

Networking: Ethernet, TCP/IP, VPN, LAN/WAN

Education

Bachelor’s Degree from Andhra University, India

Contact this candidate