SUMMARY:

• Over 8+ years of experience in Business Intelligence, Development, Design, and Implementation and with strong background in Databases and Data warehousing concepts.
• Expertise in Tableau 9.3/10.2/10.3/10.5 , Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
• Proficient in data visualization, Reporting and Analysis using Bar Charts, Line Charts, Tree Maps, Pie Charts, Heat Maps, Scatter Plots, Dual Axes, Sankey Charts, Geographical Maps in Tableau Desktop.
• Setup and configuration of Tableau server 10.3, 10.5 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Designed, developed, and maintained reports and multi - level dashboards in Tableau.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Installation and Configuration of PostgreSQL and MySQL Software and Creating Databases.
• Regular Proactive Health Checks for all the PostgreSQL and MySQL Databases through my automated shell scripts.
• Used SAS in the area of Analytics and ‘Analytical Data Preparation’ and Tableau in the area of data discovery, visualization and intuitive, interactive dashboarding.
• Created actions, customized relationships, data blending, filters, calculated fields, parameters, hierarchies, groupings, sorting, live and extract connections, drill down analysis on Tableau Desktop.
• Extensive working knowledge on advanced Tableau features such as Level of Detail expressions, Parameters, Sets, Groups, Forecasting, Viz in a Tooltip, Data Blending etc.
• Created advanced analytical dashboards using Lines, Bands and Trend Lines.
• Experience in development of user defined reports to provide on demand data analysis using Excel and created charts and pivot tables in Excel.
• Worked on AWS instances for setting up authentication and integration between the applications.
• Experience in Migrating the existing BI system to the AWS cloud and Redshift.
• Used AWS's Virtual Private Cloud(VPC) feature to set up a separate logically isolated network for to launch and run server.
• Knowledgeable in setting up and managing various AWS Services such as EC2, S3, Auto Scaling and IAM.
• Tested Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
• Experienced in Python to develop analytic models and solutions
• Extensively used Python libraries Numpy, Scipy and Pandas for data Analytics
• Extensive experience in using Python to code and design various phases for data processing pipeline.
• Extensive working Experience with cloud platform development like amazon web services(AWS)
• Experience in delivering to others on the use of Tableau. Proven ability in Tableau, SQL and Excel.
• Expertise in writing complex SQL queries to fetch complex data.
• Created users, groups, projects, data connections, settings as a tableau administrator.
• Prepared Dashboards using calculations, parameters in Tableau
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• Connected to different databases like Greenplum, Redshift, MS SQL, SAS, Access etc.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters in Tableau Desktop.
• End to end experience in designing and deploying data visualizations using Tableau.
• Experienced in writing queries, stored procedures and functions using SQL.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Manage the lifecycle of MongoDB databases including database sizing, deployment automation, monitoring and tuning
• Hands on experience in developing Stored Procedure and UNIX Scripting
• Identifying Business Data and requirement and modifying it to logical data models
• Knowledge in creating Crystal Reports using crystal reports formulas, Grouping, Parameters, selection criteria to handle the customer’s requests from Tables, Views and command objects.
• Quick Learner with excellent analytical and problem-solving skills with positive attitude towards new challenges
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
• Expertise in generating reports using global variables, expressions and functions for the reports.
• Experienced in tuning long running SQL queries for better performance.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level Data Analysis and Data Management Services.
• Experience in Technical Support, Troubleshooting, Report Design and Monitoring of system usage.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS:

Operating Systems: Windows 10/8/7/VISTA/NT/XP, LINUX/UNIX.

Programming Languages: C++, Java, SQL, T-SQL, Postgre, PL/SQL, Python, HTML, XML.

Databases: MS SQL Server, Oracle, IBM UD2 DB2, SAS MS Access 2000, SAP BW,Mongo DB.

AWS: Cloud Technologies, Connecting Instances, Configuration Management, Linux System Administration, Cloud Formation .

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Senior Data Analyst/Tableau Developer

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Optimized data collection procedures and generated reports based on time.
• Setup and configuration of Tableau server 10.5 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Hands on experience with Tableau 10.x
• Used the multiple data sources joins in Tableau 10.x
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Setup trusted authentication in Tableau server and pass requests from Web server
• Worked heavily using Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Designed and setup user security to facilitate Windows AD login.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Setup of Distributed Server environments for optimum load balancing.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Perform document modeling, querying, indexing and tuning for both MongoDB and Solr environments.
• Worked on various POC’s on Azure and AWS instances for determining the best option to deploy on-prem server.
• Managing/Building Standby (Slave/Replication) Servers for all the PostgreSQL and MySQL Databases as requested by the Application Teams based on criticality of the Applications.
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
• Involved in deployment of project using AWS and Created S3 backup and moved objects to Amazon glacier for archiving
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Implemented Garbage collection with C Python to enhance the performance, by garbage collecting the older generated objects.
• Automated RabbitMQ cluster installations and configuration using Python/Bash.
• Using a generic ODBC connection, and by enabling the SAS ODBC connectivity on the SAS server side and having the SAS ODBC drivers installed on my desktop.
• Connected to Amazon Redshift data source and created visualizations by statistically analyzing the data.
• Used Python to build statistical models involving Linear Regression, Ridge Regression, Lasso Regression, Elastic Net Regression for estimating the risks of assets.
• Wrote Scripts in Python using for extracting data from XML and JSON files
• Involved in deployment of project using AWS and was responsible for maintenance and performance of EC2 instances
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Involved in reviewing requirements and data sources form AWS Redshift, MS Excel for design, development.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion.
• Importing tables using Warehouse catalog and Creating Logical Tables
• Involved as a technical expert providing input to application design regarding performance tuning and administration requirements.
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.
• Partner with the Technology teams to deliver a stable and highly available reporting platform.
• Plan and implement the overall analytics and business intelligence strategy.

Confidential, Qunincy, MA

Data Analyst/Tableau Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Experience in migrating client's reports from excel (static) based solution to an interactive service.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI's.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 9.0 in Dev, QA, UAT and Prod environments.
• Installed patches on the server and documented upgrade plan from Tableau 9.0 to 9.1
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Developed web application using python, Django framework, MySQL
• Deftly designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Proficient in performing Data analysis and Data Visualization using Python libraries.
• Scaling up projects using python tools like multithreading, celery.
• Collect the Dumps generated by several reports from PostgreSQL Databases and importing to MySQL Databases.
• Write Complex Shell Scripts that automate the Import of Reports to PostgreSQL and MySQL Databases.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, AdHoc, business views along with user acceptance test and data accuracy test.
• Connected to the AWS Red shift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Professional experience in designing, development, testing, deployment and support of applications programmed in Python, Django, Flask, MySQL, PostgreSQL, Apache, Gunicorn
• Added support for Amazon AWS S3 and RDS to host static/media files and the database into Amazon Cloud.
• Used AWS's Virtual Private Cloud (VPC) feature to set up a separate logically isolated network for to launch and run server
• Access dashboards from any browser or tablet.
• Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Cognos Reports into Tableau Dashboards.
• Having experience in SME (Subject Matter Expert) in all BI tools.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Worked on scheduling the extracts and setting up the permissions.
• Extensively used Tab admin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Confidential, Northern California

Data Analyst

Responsibilities:

• Built interactive dashboards and stories using Tableau Desktop for accuracy in report generation applying advanced tableau functionality: parameters, actions, tooltip modifications & API.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server and tableau Online.
• Extensively worked on metadata in Tableau desktop to modify data types, rename fields, joins, assign roles, refresh data and change extract data options to prepare data sources to be used by users.
• Developed effective and interactive Dashboards using Dashboard objects and Dashboard Actions.
• Created advanced analytical dashboards using Trend Lines, Forecasting, Linear Regression Models etc.
• Optimized existing pivot tables’ reports using Tableau and proposed an expanded set of views in the form of interactive dashboards using line graphs, bar charts, heat maps, tree maps, trend analysis, Pareto charts and bubble charts to enhance data analysis.
• Designed Alteryx workflows in Alteryx designer for data manipulation and data preparation.
• Translated business logic and rules from the existing system (SQL) to Alteryx.
• Involved in upgrade of Tableau Server from 10.0 to 10.3 and also created Users Groups, Projects, and assigned Access levels in Server.
• Extensive worked on using spatial fields, geo maps and geo-coding.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Extensively worked on performance tuning of Tableau dashboards using Performance recording feature.
• Created PL/SQL scripts for data extraction and transformation to ensure that the data is properly extracted for building Tableau dashboards.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Created dashboards and reports for ad-hoc reporting.
• Provided post implementation production support.

Confidential, Austin,TX

SQL developer

Responsibilities:

• Liaised with project management and development teams to identify and implement reporting, control, and automation
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Monitored and provided front-line support of daily processes.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.

Confidential, New York City, NY

Business Intelligence Developer

Responsibilities:

• Conducted user acceptance testing and wrote SQL queries in Oracle for data manipulations.
• Validated requirements during the inception phase of SDLC and delivered functional specification documents.
• Worked with the QA team to review the test plan and test cases for System Integration Testing and UAT.
• Developed a batch optimization process using lean principles which saved 100-man hours/week of the testing team.
• Efficiently prepared solution documents and carrying out proof of concepts to check the feasibility of a solution for new requirements and Change Requests.
• Created mock up dashboards and presented to the higher-level end users to have them a look and feel of the dashboards.
• Worked with the QA team to review the test plan and test cases for System Integration Testing and UAT.
• Created macros in Visual Basic to create automated monthly reports in MS Excel.
• Ensured projects were completed on time and within budget.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.