SUMMARY

• 5 years of experience in design, analysis, development and implantation of various application environments using BI Tools.
• Strong hands on developing complex Dashboards, Stories using features such as Data Blending, Joins, Custom SQL Queries, Calculation, Filters, Parameters, Sets, Group etc. using Tableau Desktop and Server.
• Created Tableau dashboards using different visualization such as stack bars, bar graphs, Line Charts, scattered plots, Heat/Tree geographical maps, Crosstabs, and Histogram using Tableau Desktop.
• Good experience on in dashboards designing with large data volumes from various data sources ( Sqlserver, Teradata etc)
• Organize and Analyze data using Hierarchies, Context Filters, Trend Line, Level of Detail Expressions.
• Experienced in Analyzing the BI Needs, interpreting business user requirements and translating them into reports.
• Good interaction with clients, understanding Business Applications, Business Data Flow and Data Relations.
• Good understanding of technical trends, architecture and highly motivated to know more about latest technology, new software and products.
• Team player with good communication and interpersonal skills
• Ability to handle multiple tasks concurrently and meet deadlines
• To maintain confidentiality of client data.

TECHNICAL SKILLS

AWS: AWS,S3,Athena,EC2,IAM,Python

DBMS/RDBMS: MS - SQL Server 2016/2014/2012/2008 R2,MYSQL T-SQL, PL/SQL MS Access

ETL: SQL Server Integration Services (SSIS), T-SQL Stored Procedures

Languages: MS SQL, Python

Operating Systems: Windows server 2016,2003/XP/NT 6.0/98/Vista,7,8,10, Mac OS, Linux

Business Intelligence: SSIS, SSRS, Tableau Desktop, Tableau Server

SDLC: SDLC methodologies such as Waterfall and Agile (specifically SCRUM)

Office Tools: MS Word, PowerPoint, Excel, Visio, One note, MS Operations Manager, SharePoint

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer/ Analyst

Environment: AWS S3, Python, AWS Athena, AWS EC2, Tableau

Responsibilities:

• Moved CSV data to S3 bucket landing zone using Python boto3 library
• Downloaded AWS JDBC driver to establish connectivity between Tableau and AWS Athena
• Created a table on the CSV data moved to S3 using AWS Athena
• Queried/Transformed the data using Presto SQL and moved data to production
• Accessed data using Tableau 2020.1 and created a dashboard on data

Confidential

Tableau Developer/ Analyst

Responsibilities:

• Design, develop, test and maintain Tableau functional reports based on user requirements.
• Creation of visualizations for the data extracted with the help of Tableau
• Identification of patterns and meaningful insights from data through analysis
• Designing of dashboards from different sources of data using various Tableau data visualization techniques such as Cross tabs, Pie Charts, Bar Chart, Scatter Plots and Geographical map.
• Utilize Tableau server to publish and share the reports with the business users.
• Implementing data blending to blend data from different data sources.
• Creating different KPI using calculated key figures and parameters.
• Examining glitches in business processes and resolving them
• Finding the key areas of automation to make the business processes smooth
• Wrote Custom SQL to support business requirement
• Responsible for creating calculated fields, set, and hierarchies using Tableau Desktop.

Confidential

Tableau Developer/ Analyst

Responsibilities:

• Execute and maintain reports for external clients and internal supports
• Develop graphs, reports and presentation for project results
• Hands-on development assisting users in creating, modifying worksheets and data visualization dashboards.
• Work on generating various dashboards in Tableau server using various data source.
• Prepare dashboard using calculations, parameters in Tableau.
• Present analysis effectively to internal team and clients.
• Developed Tableau dashboards that provide clear KPI visualization for various subject areas.
• Worked extensively on SQL queries for client warehouse analysis.
• Used filters, set, parameters and calculated fields on Tableau reports.
• Interacted with the business team to identify and gather business requirement

Confidential

Business Intelligence/Analyst

Responsibilities:

• Developed SSIS packages to read and extract data from multiple sources including Microsoft Excel, XML, and OLTP sources to deliver information to the end user according to business and user requirements.
• Designed new reports and reporting solutions based on user business requirements and organizational business needs.
• Prepared ETL process designs based on business requirements and specifications.
• Creating complex SSIS packages to load multiple files from different sources using Foreachloop containers and data transformations, including Conditional splits, Data conversions, Merge Joins, Script Task, Lookup, Derived column, etc.
• Created functional SQL Stored Procedures and user-defined functions from complex business logic to achieve business requirements
• Supported DBA in creating and managing Tables, Indexes, Triggers, DB links and Privileges.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as SQL code from developers.
• Used Agile methodology to keep track of projects and maintain schedule by conducting daily scrums and bi-weekly sprints.