SUMMARY

• 8 years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Over 6 Years of experience working on Tableau (Desktop, Server), creating various Reports and Dashboards using heat maps, treemaps, circle views, bar charts, lines, pie charts, area charts, box and whisker, gantts, bubbles and highlight tables, filled maps, funnel and donut charts according to deliverable specifications.
• Experience in Performance Tuning Tableau reports.
• Developed business critical Interactive dashboards.
• Worked closely with UX and Business teams to deliver the desired functionalities for the reports.
• Experience in Tableau server installation, configuration and enforcing security in Tableau.
• Involved in the deployment activities supporting the software backup and providing extract failure alerts to support teams.
• Integrated the dashboards onto portal by working closely with the UI team.
• Good understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Teradata, Netezza, AWS Redshift and Hive.
• Highly Proficient in Agile, Waterfall and Scrum software development life cycle.
• Experience in ETL design, development and maintenance using SQL, PL/SQL, SQL Loader.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Experience working as a BI Consultant with specialization in Business Objects and Web Intelligence.
• Knowledge in building/maintaining Repository, Universes and creating adhoc reports.
• Experience in resolving universe issues like Loops and Traps using Alias and context.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS

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

Business Intelligence tools: Tableau, BO, Web Intelligence, OBIEE.

Database: SQL Server 2005/2008/2008 R2, Oracle 11g/10g/9i,AWS Redshift, Netezza, Teradata, MySQL, Hadoop.

ETL Tools: Informatica, Alteryx 9.5/10.

Operating Systems: Windows XP, Windows 7, UNIX, Linux, Mac OS X.

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr. BI/ Tableau Consultant

Responsibilities:

• Interact with business users/SMEs in gathering, analyzing and documenting the business requirements.
• Analyze, conceptualize, design, implement and build rich, high-visibility reports/dashboards to support various project initiatives.
• Write SQL, PL/SQL Queries and Data Marts for creating views and validating data.
• Working on building, deploying and automating wireframe, which has more than 40 KRIs on to the server with multiple data sources.
• Developed, published customized interactive reports and dashboards and managed report scheduling.
• Created actions to navigate from one dashboard to another dashboard and also created URL actions to navigate dashboards on tableau server based on parameters.
• Built stories with various data points to narrate the data to the end users.
• Optimized performance of the dashboards by implementing different optimization techniques.
• Performing Tableau Server Installation, maintenance and upgrades when necessary.
• Involved in administration tasks such as creating and managing sites, setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Involved in the deployment activities supporting the software backup and providing extract failure alerts to users.
• Working on data sources such as SQL, Oracleand Hadoop.
• Provide training/demos to users on Tableau for interacting and viewing the published dashboards and development of new dashboards.
• Scheduled Full/Incremental refreshes of dashboards depending on the business requirements for data sources on Tableau Server.

Environment: Tableau 2020/2018, SQL, SQL Server Management Studio, Hadoop, Oracle, Toad, Microsoft office 2010, Windows 7 Enterprise.

Confidential, Santa Clara, CA

BI/ Tableau Developer

Responsibilities:

• Interact with business users closely in gathering the requirements and defining KPI’s for developing the dashboards accordingly.
• Wrote queries in SQL and Oracle for creating views and validating data.
• Worked closely with Data Warehousing team by giving the inputs to them about the reporting requirements.
• Created calculated fields, parameters, context filters and action filters for building dashboards and worksheets in tableau.
• Developed customized charts like Funnel charts, Donut charts for best user interaction.
• Used LOD calculations in dashboards to show the data in different levels.
• Built Operational and Financial dashboards.
• Lead team in educating and following the guidelines to maintain the consistency across all the dashboards.
• Built adhoc reports using Webi.
• Worked on data sources such as Oracle and SQL.
• Provided training/demos to users on Tableau for interacting and viewing the published dashboards and development of new dashboards.
• Scheduled Full refreshes of dashboards depending on the business requirements for data sources on Tableau Server.

Environment: Tableau 10.2/10.5, Webi, Oracle, Oracle SQL Developer, SQL, SQL Server Management Studio, JIRA, Microsoft office 2016, Windows 7 Enterprise.

Confidential, San Rafael, CA

Tableau Developer/ Administrator

Responsibilities:

• Interact with the business users in gathering and analyzing the requirements.
• Writing custom SQL Queries to develop the reports.
• Created calculated fields, parameters, Context filters and action filters for building dashboards and worksheets in tableau.
• Building Tableau dashboards using stack bars, lines, Pie charts, horizontal bars according to deliverable specifications.
• Building, publishing interactive reports and dashboards and prepared user stories to create compelling dashboards to deliver actionable insights.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Developing and implementing different strategies to improve dashboard performance.
• Defined best practices for Tableau report development.
• Performing Tableau Server Installation, maintenance and upgrades when necessary.
• Involved in the deployment activities supporting the software backup and providing extract failure alerts to support teams.
• Working closely with UX and Business team to deliver the desired functionalities for the reports.
• Integrating the dashboards onto Confidential portal by working closely with the UI team.
• Assisted in supporting and updating UNIX control programs.
• Scheduling ETL jobs using Hive via EMR clusters, spinning and maintain EC2 instances.
• Working on data sources such as Redshift and Hive.
• Scheduled Full refreshes of dashboards depending on the business requirements for data sources on Tableau Server.

Environment: Tableau 9.2/9.3/10/10.1/10.2 , Redshift, Hive, Aginity Workbench,AWS, Postgre SQL,JIRA, Microsoft office 2016, Windows 7 Enterprise, UNIX.

Confidential, Bethpage, NY

Tableau/Alteryx Developer

Responsibilities:

• Interact directly with the business team in gathering the requirements.
• Analysis of BRD, design, documentation, estimations and technical specifications.
• Created Tableau dashboards using heat maps, stack bars, lines, area charts, scattered plots, geographical maps using show me functionality.
• Created Groups, Hierarchies, Sets for detail level summary reports and dashboards using KPI’s.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Trend Lines and Reference Lines.
• Effectively used data blending.
• Worked on Motion chart and Drill down analysis.
• Developed Interactive (Dynamic) dashboards, adhoc reports for users.
• Involved in the migration of OBIEE reports to Tableau.
• Involved in the migration of Oracle Discoverer reports to Alteryx Apps.
• Worked on data sources such as Netezza and Oracle.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled Full/Incremental refreshes of dashboards depending on the business requirements for data sources on Tableau Server.

Environment: Tableau Desktop 8.3/9.0/9.1, Alteryx 9.5/10, Oracle, Netezza, Toad,OBIEE, Microsoft office 2010, Windows 7.

Confidential

Tableau/ Informatica developer

Responsibilities:

• Analyzed alerted transactions for suspicious activity, conducted complex case investigations and providing detailed reports.
• Composed Suspicious Activity Reports (SARs) and follow-up reviews, delivering comprehensive research and analysis.
• Evaluated and assessed client transaction activity to determine risk level to the Bank.
• Collaborated and communicated with the team members on cases and investigations of suspicious transactions
• Received and investigated referrals of unusual activity by branch personnel.
• Applied project Management, organization and problem-solving skills across all responsibilities and tasks.