SUMMARY:

• Over 12+ years of IT experience in Business Intelligence, Data Warehousing and Data Analyst.
• Worked on Tableau Desktop 9/10, Tableau server and Tableau reader.
• Skilled in Tableau Desktop versions 10, 9.x, 8.x and for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines. Also built interactive dashboards using technique like guided analytics and visual best practices provided by Tableau
• Worked extensively on joining tables, multiple data connections using data blending, worked on Data Extracts and managing queries.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Created action filters, parameters and calculated sets for preparing Dashboards and Worksheets in Tableau.
• Experience in configuring reports from different data sources using data blending.
• Strong experience in writing complex SQL queries.
• Experience in writing complex SQL queries and automating the daily data analyst work using SQL/Tableau.
• Experience in documenting business requirements and/or business solutions to solve problems and issues related to business operations.
• Extensively worked on building the end to end data/reporting pipeline from Workday to Tableau using Oracle and reporting infrastructure.
• Solid exposure to Data Warehousing and Data marts concepts. Also having good understanding of various DWH schema designs (Star Schema and Snowflake schemas).
• Extensive knowledge of Software Development Life Cycle (SDLC), Methodologies (Waterfall/Agile).
• Expertise in preparing code documentation in support of application development, including high level and detailed design documents, unit test specifications, interface specifications, etc.
• Outstanding analytical, interpersonal, organizational, communication and problem - solving skills.
• Having strong analytical, logical, communication and problem-solving skills. Ability to adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Reporting Tools: Tableau 9/10, MicroStrategy 8/9

Databases: Oracle, DB2, MySQL

Mainframe: COBOL, JCL, CICS, DB2, IMS, and IBM Utilities

Microsoft Suite: MS Access, PowerPoint, Excel, Word

Scripting: Unix Shell scripting

Platforms: Linux, Windows

Tools: HP Quality Center, JIRA, Office Tools, Visio, SharePoint, Confluence

PROFESSIONAL EXPERIENCE:

Data Analyst/ Tableau Developer

Confidential, Walnut Creek, CA

Responsibilities:

• Working on automating Tableau Financial reports infrastructure for Confidential Insurance.
• Migrating the reports from MS Excel to Tableau, along with backend automation using SQL and PL/SQL.
• Extensively worked on transforming the static tableau dashboards to dynamic with multiple filter conditions.
• Improved the performance of tableau dashboards by 25% by applying the right metric calculation logic.
• Worked very closely with business executives to understand the requirements and automated the financial reports.
• Experience in pulling workday data using API and to load the data into Oracle.
• Worked extensively on data validations and collaborated well with ETL teams to resolve the DQ issues.
• Executed fast-paced and dynamic projects in a highly organized manner on a tight schedule

Data Analyst/Tableau Developer

Confidential, Palo Alto, CA

Responsibilities:

• Extensively used Tableau, MS Access, MySQL, MS Excel to bring meaningful insights to business.
• Worked with Business Analyst and Stake holders to understand requirements, layout, and look and feel of the dashboard to be developed.
• Extensively worked on creating rich dashboards using Tableau and prepared user stories to create compelling dashboards to deliver actionable insights.
• Instrumental in building trust and relationship with business partners and executives.
• Executed fast-paced and dynamic projects in a highly organized manner on a tight schedule
• Combined views and reports into interactive dashboards in Tableau Desktop
• Executed and tested required queries and reports before publishing.
• Expert in data extraction using SQL, exceptional analytical and problem-solving skills

Business Analyst/ Data Analyst

Confidential, San Francisco, CA

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Business Intelligence life cycle.
• Established deep partnerships with business owners to identify BI needs for the business and evangelize existing solutions or develop new solutions appropriately
• Document requirements and proposed high level solution architecture.
• Defined system level block diagram depicting data sources and data flows.
• Started working on data analyst role using MS Excel and BI tools.
• Involved in design, build, maintenance and deployment of reports, dashboards in tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Worked closely with ETL team for various Data sources issues.

Senior Developer

Confidential

Responsibilities:

• Involved in analysis, design, maintenance and execution of the project.
• Generating reports and documentation for the clients.
• Experience with SQL queries, profiling and data quality management functions
• Handling booking, amendment, closure or cancellation of guarantee.
• Providing interfacing services to other system within the bank.
• Developed end to end new modules for implementing newer features in the application
• Distributed tasks in the team during design, coding and testing phases of the new system.
• Performed impact analysis to resolve user queries.

Sr. Software Engineer

Confidential, Woodland Hills, CA

Responsibilities:

• Leaded the data migration effort end to end.
• Extensively wrote complex SQL's to deliver adhoc reports to business team.
• Assisted customers for UAT, created roll out plans and identified training needs.

Software Engineer

Confidential, New York

Responsibilities:

• Extensively worked on new feature developments using COBOL/JCL/CICS and DB2.
• Production support experience in handling mission critical systems.
• Automated regular production job flows using EASYTRIEVE.
• Worked extensively on performance tuning in Mainframe platforms.
• Deployed good practices and runbooks to handle production failures effectively.