SUMMARY

• Tableau certified professional currently working as a Tableau/BI Developer in a reputed organization.
• Involved in creation/review offunctional requirementspecifications and supporting documents for business systems, experience in database design and data modeling process
• Merit of incorporating database objects with Hive - SQL and Spark SQL/DataFrame
• Excellent knowledge of developing and designing reports through Tableau
• Strong advocate of dashboard visual best practices and designs

TECHNICAL SKILLS

Database: Hadoop File System (HDFS), SQL Server 2016

SDLC: Agile, Scrum

Database Programming: Hive-SQL, Spark SQL, T-SQL, Dynamic SQL

Analysis Services: SSAS, OLAP Cubes, Apache Druid

Reporting Tools: Tableau Desktop

Source Control & Collaboration Tool: Git, GitLab, GitHub

Cloud Technologies: Amazon Web Services - S3, Athena, Glue, EMR, Lambda, etc...

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Tableau/BI Developer

Responsibilities:

• Design multiple tables and jobs and integrate them into team’s job flows in Azkaban to feed data for Tableau reports and ad-hoc tickets
• Monitor and troubleshoot issues caused by upstream data feed delay or legacy logic in codes that created contradict data quality checks
• Contribute in scripting Hive SQL queries, ranking functions, derived tables, common table expressions (CTEs), user-defined function, encrypt/decrypt functions for PII data
• Contribute in scripting Spark SQL queries that leveraged Spark engine
• Package shared Scala functions in jars to be easily shared by team members and maintain the packaged jars upon feedback and reviews
• Optimize existing queries performance with partition pruning, set commands, CTEs, Hive UDFs, Scala functions, Hive and Spark configurations
• Refactor ETL processes/jobs to delegate all aggregations on the ETL side, therefore reduce Tableau extract size by 90%, and also massively improve loading time of multiple legacy Tableau reports
• Build interactive dashboards utilizing visual best practices such as data-ink ratio, limited color schemes, relevant chart selections, dashboard actions with appropriate instructions
• Effectively utilize extract/data source filters and generate aggregated calculated fields, LOD expressions, and custom shapes and color schemes in Tableau Desktop
• Discuss the business requirements with stakeholders; design the technical specifications document for ETL processing of data into master data warehouse and strategize the integration test plan and implementation.
• Communicate with stakeholders to understand their decision-making parameters and purpose of each chart as well as dashboards as a whole, analyze the available data to build Tableau Dashboards, the availability of functions of the current Tableau Desktop version, and manage the delivery
• Strong hands on experience in implementing dash boarding, data visualizations, and analytics using Tableau.
• Manage different versions of scripts in GitLab; document using GitLab Wiki and Lucid Chart

Environment: Hadoop File Systems (HDFS), Hive SQL, Spark SQL, Apache Azkaban, Jenkins, JIRA, GitLab, Tableau Desktop, Tableau Server, Bash, Scala, VS Code, IntelliJ, AWS Services (Lambda, ERM, S3, CloudWatch, Step Functions, Glue), Apache Druid, Imply

Confidential, Scottsdale, AZ

Tableau Developer

Responsibilities:

• Collaborated with the project team to outline project requirements in JRD meetings
• Contributed in scripting T-SQL queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDFs), constraints, and database triggers
• Contributed in tuning SQL queries and improving the performance of the database to improve the latency
• Designed the technical specifications document for ETL processing of data into master data warehouse and strategized the integration test plan and implementation
• Effectively utilized data blending, filters, actions, and hierarchies feature in Tableau
• Built interactive dashboards utilizing various visuals such as charts, table, maps and custom LOD expressions in Tableau Desktop
• Generated aggregated calculated field in the Tableau Desktop
• Interacted with business stakeholders to understand their decision-making parameters, analyze the available data to build Tableau Dashboards and manage the delivery
• Designed and deployed reports with drill down, drill through and drop down menu option and parameterized and linked reports using Tableau
• Strong hands on experience in implementing dash boarding, data visualizations, and analytics using Tableau

Environment: SQL Server 2016, SSMS, SSDT, T-SQL, SQL Profiler, Tableau

Confidential, San Diego, CA

Tableau Reports Developer

Responsibilities:

• Coordinated with business users and stakeholders in JRD sessions to gather business requirements
• Performed data analysis and data profiling utilizing complex SQL on various sources systems
• Designed and optimized complex stored procedures to perform data profiling and auditing in the pre-staging database
• Utilized T-SQL constructs such as joins, subqueries, derived tables, and views for querying data
• Established joins and created indexes whenever necessary based on requirements
• Enforced business rules by creating constraints in both the production and relational data warehouse databases
• Gained extensive knowledge in various reporting objects such as facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters, and so on, in Tableau
• Prepared dashboards using calculations and parameters in Tableau
• Tested the data connections bringing the data from the database to the Tableau dashboards in order to develop the reports
• Built complex formulas in Tableau for various business calculations
• Developed complex visualizations reports using data from relational databases using Tableau Desktop

Environment: SQL Server 2012, Erwin, SSDT, T-SQL, Erwin, MS Excel, Tableau

Confidential, Hillsboro, OR

Reports Developer

Responsibilities:

• Gathered business specifications through JRD sessions with business analysts, project managers and developers
• Normalized and de-normalized existing tables thereby enhancing query processing
• Created stored procedures for executing index maintenance and data profiling for loading data marts and generating report datasets
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team and Reports team during development
• Deployed and subscribed reports utilizing SSRS to generate all daily, weekly, and monthly reports

Environment: SQL Server 2012, T-SQL, SSRS, SSMS, SSDT, SQL Profiler

Confidential, Portland, OR

SQL Report Developer

Responsibilities:

• Conducted JRD meetings for gathering and analyzing requirements to define BRD for BI applications
• Administered schema objects such as tables, views, indexes, and referential integrity
• Amended temporary tables, indexes, and lookup techniques to optimize stored procedures
• Created reports based on the requirements through SQL Server Reporting Services (SSRS)
• Optimized slowly running reports utilizing Caching and Snapshot in Report Manager

Environment: SQL Server 2008 R2/2012, T-SQL, SSMS, BIDS, SSRS

Confidential, Rancho Cordova, CA

SQL Developer

Responsibilities:

• Gathered business specifications from end users via JRD sessions
• Wrote CTEs and ranked functions for removal of duplicate records in OLTP tables to maintain data consistency
• Enclosed dynamic SQL for developing customizable queries, answerable by the OLTP Server
• Developed codes regarding security vulnerabilities to prevent SQL injections attacks
• Created data profiling, cleansing, validation, and verification SQL stored procedures

Environment: SQL Server 2008 R2, T-SQL, SSMS, BIDS, SSRS, SQL Profiler