Guardian Data Lake is an Enterprise Master Data Ecosystems for all the Guardian’s company data. It’s a centralized, curated, and secured repository that stores all consolidated data, both in its original form and prepared for analysis.

Guardian Data Lake system delivers an integrated suite of services that provide everything needed to quickly and easily build and manage a data lake for analytics. It enables to break down data silos and combine different types of analytics to gain insights and provide better business decisions in cloud environment and all reporting and ML system using this ecosystem as a source. Client data extracts to Data Hub, to S3 and finally into the Redshift data warehouse. For this process used Matillion.Matillionfor AWS Redshift is a GUI-based ELT tool designed for S3 and Redshift specifically.

• Designed data models and ETL processes to deliver high quality information to the end user.
• Brought down the execution time of data processing in ETL packages from 7 days to < 6>
• Worked with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Introduced visualizations (world map, boxplots, trend prediction, etc.), slice and dice functionality to drive powerful insights in the reliability.
• Responsible to rethinking and automation of routine process, and apply solution in new ways.
• Integrated Python and R with Tableau for higher level visualizations.
• Created Interactive Dashboards using Tableau and Shiny programming.
• Designed applications for Load the data from various sources like excel files, text file and different database.
• Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Agile project methodology approach.
• Created Business Requirement Documents & Functional Design Documents. Created Use Cases, User Stories & Test Cases implemented Mapping logics and complex transformations as per business requirements.

Proposed several architectural solutions to the existing design and performance improvement processes

Tableau Push Email is an automation platform intended to seamlessly communicate with Tableau Server with the help of tabcmd utility. The idea behind it is that anyone should be able to easily share and customize any tableau report on email to user. In its current form, Tableau Push Email exists as a PowerShell script that is set up to run at frequent and regular time intervals. All the information it needs to enable to access Tableau Server PostgreSQL repository, and the published views of the Tableau Server it is set to run against. This was a limitation with Tableau server product to send tableau reports in .csv format for user’s inbox.

• Designed and Developed the Tableau Push Email Tool/Process from scratch to final deliver to business.
• Developed the complete script using the PowerShell, Tabcmd, and Python.
• Responsible for developing the client’s internal and External BIA reports and Client Standard data story for emailing.
• Responsible for modification in existing script as per client need.
• Worked on Jenkins deployment for customized report.
• Designed a python script to invoke the tableau server.

Worked on SharePoint form customization

• Gathering and analyzing business requirements, providing solution directions using Tableau thereby translating business requirements into report visualization and insights.
• Developed interactive data visualizations reports and developed automated processes for updating content-Data used in standardized dashboards. Created formulas and calculations within Tableau to meet the needs of complex business logic and comfortable with advanced Tableau topics such as parameters, geographic mapping/coding, data blending and extract optimization.
• 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 customer and campaign KPI's.
• Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Donuts Charts, Maps, Line Charts, Scatter Plots and Combination Chart, Filters, Marking, Drill Down, Hierarchies, Color and Custom Expressions, Actions and Calculations.
• Defined Group level security and ensured Active Directory Integration within Tableau Environment for automated user provisioning, SAML for security architecture and IIS (Ports) for Web Servers., licenses, integration and the appropriate permission sets for Tableau server logons and security checks.
• Managed Tableau platform administration functionalities and Internal Web portal FIT Metrics, by adhering to best practices, metadata management, cache/ history management, user management (managed the users, groups, projects, sites, workbooks), scheduling refreshes, content delivery administration, security implementation, data source configuration, platform environment monitoring and support, server back up and load balancing techniques to deploy Tableau server architecture to support high availability and scalability.
• Acted as tier one support to build custom Admin views (Dashboard/Visualization) of server usage based on input from support team and service reporting (KPI) by leveraging PostgreSQL.
• Performance tuning of workbooks, data sources, and providing best practices for user community.
• Serve as a primary point of contact supporting the Tableau Server platform in Development, Production, and QA and Production Support issue resolution. Monitor and troubleshoot platform to guard against preventable issues and ensure performance that meets SLA.
• Experienced administering using TABCMD and TABADMIN for Tableau server in a multi-site environment, server /platform sizing for projects, hardware and software requirements with a particular emphasis on performance maximization.

Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.