SUMMARY

• Over 9.5+ years of IT experience in all phases of Software Development Life Cycle (SDLC) and Agile methodologies, Implementation of (BI) Business Intelligence applications and CRM applications for various clients in Financial domain
• Experience in designing stunning visualizations using Tableau 8.3 and 9.x software and publishing and presenting dashboards on Tableau server and Tableau desktop platforms
• Good knowledge of migrating/recreating reports to tableau from other BI application like OBIEE
• Experience in configuring reports from different data sources using data blending
• Implemented Tableau/oracle BI security at the Data (Data security - Filters) and object (Roles and Permissions) security
• Have been working with various data sources such as Salesforce, Oracle, SQL Server and flat files. Also very good knowledge working with dimensional tables for reporting/visualizing using Tableau dashboard
• Excellent understanding of Star Schema modeling, Snowflake modeling and designing fact, dimensional and aggregate tables for Business Intelligence Universe from Dimensional data mart / data warehouse.
• Expert in presenting any excel spreadsheet data in to Interactive reports/Dashboard to remove gap between data analysis and visual presentation.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Groups, hierarchies to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts
• As a BI developer, have extensive experience in writing DDL, DML and DCL scripts, developing all database objects such as Tables, Views, Temporary tables, Partitions, Indexes and programming using PL/SQL to create Stored Procedures, Functions, Cursors, Triggers and Materialized Views
• Worked on Data Mapping from OLTP to OLAP databases for BI Reporting.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools
• Strong Team spirit, excellent interpersonal and management skills
• Ability to work independently and deliver on time

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g/12c, MS Access, SQL Server

Core Skill Set: Tableau 7.1, 8.3, 9.3, OBIEE, Data Modeling, SQL, PL/SQL, and Data Warehousing

ETL tools and Utilities: Informatica Power Center, Apex Data loader (Salesforce), SQL*Loader, DAC, TOAD, SQL Server Management Studio and WinSCP

Programming Languages: Shell, PL/SQL, eScript, C, C++, java

Job Scheduling tools: ESP Agent, Unix Crontab and windows task scheduler

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Developed dynamic and complex worksheets and embedded into dashboards
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications
• Prepared dashboards using calculated fields, parameters, groups, sets and hierarchies in Tableau
• Created different visualizations using Bars, Lines, Pie charts, Maps, Scatter plots and Heat maps
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Mentored business power users to create reports/dashboards usingtableaudesktop
• Published several data sources to tableau server
• Organized all the workbooks in Microsoft team foundation server and used it as a version control system for tableau development
• Administered access control to users by creation separate dl’s in active directory for different levels of access like interactor, read with edit access
• Developed Executive summary dashboard with drilldown capabilities
• Used view as a different user option to validate data for different types of users
• Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).
• Functional and Technical Specification documents creation and gathering approval from leadership
• Published the validated dashboards into production and ensured the data was up to date by scheduling extract refreshes
• Troubleshooting and solutions for production issues

Confidential, Austin, TX

Tableau Developer

Responsibilities:

• Developed Executive summary dashboard with drilldown capabilities
• Consolidated data from several sources - Salesforce, Oracle data warehouse, Microsoft TFS, Share point and BMC Remedy
• Selective data import after complete analysis of underlying data
• Scheduled extracts appropriately to improve performance
• Designed and developed various analytical reports by blending data on a single worksheet in Tableau Desktop
• Created Dashboards with Quick filters, Parameters and sets to handle views more efficiently
• Restricted data for particular users using Row level security and User filters
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Built Complex Formulae in Calculated fields, performed various Table calculations for achieving desired results.
• Created different visualizations using Bars, Lines, Pie charts, Maps, Scatter plots and Heat maps
• Geographic Visualizationand other making use ofactions,otherlocal and global filtersaccording to the use cases.
• Implemented industries best practices across all worksheets and dashboards
• Effectively used data blending, quick filters, actions and hierarchies in tableau
• Enabled the business power users to create reports/dashboards usingtableaudesktop
• Built complex reporting involving a series of calculations and aggregations
• Embedded Tableau views into SharePoint and used share points access control as an additional security control

Confidential, Austin, TX

Tableau Developer

Responsibilities:

• POC’s to business, enabling them to move on from traditional BI tools.
• Foundefficientways to make tables and graphs, which were visually easy to understand, and at the same time maintaining the accuracy of the core information content.
• Used SQL queries at the custom SQL level to pull in completed data into Tableau
• Created Context Filters, Sharing Filters, Quick Filters in the reports.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Developed complex reports and visualizations using Tableau Desktop
• Played as a liaison between the Business team and Technology team
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance
• Prepared Dashboards using calculations, parameters in Tableau
• Extensive data analysis on Activity, Opportunity, Customer & Accounts data
• Delivering Functional and Technical specifications documents for every release
• Tracking development items progress via daily stand up call with offshore
• Scheduled frequency and time to refresh data for the while publishing data sources to the server
• Extensive working knowledge in all SDLC and Agile methodologies including requirements gathering, analysis, design, review, documentation, development, testing, deployment and production support.

Confidential, Atlanta, GA

Senior Systems Engineer & Offshore

Responsibilities:

• Performed data migration from legacy Java system to Siebel CRM
• Reused integration objects with minimal modifications
• Worked on EAI and workflow process monitor components
• Worked as a coordinator between Siebel and legacy systems
• Implemented multi-orgs involving different date format, currency etc.,
• Replicated product structure, pricing, order processing, etc.,
• Provided solution and fix for production issues within SLA
• Created Products, product classes, attributes and complex product structures
• Extensively worked in Siebel Data Map and DVM, Run Time Events for meeting business requirements which improved the performance and maintainability
• Extensive working on EIM module
• Prepared IFB Files for accounts, order, order item and assets data load
• Tuning of workflow policies to send emails in real time faster
• Replaced eScripting with User Properties to improve performance
• SQL preparation for all Ad-Hoc requests to improve production support turnaround time

Confidential

Systems Engineer

Responsibilities:

• Actively involved in development of Order Management (ABO) module
• Authoring Server side and Browser side eScripting
• Implemented custom data encryption for specific fields in UI
• Optimal use of eScripting and extensive use of Workflows and Configurations
• Creation of thin BC’s to improve integration performance
• User property creation at field level and business component level
• Complex Refund calculations for Modify and Cancel order scenarios
• Provided Solutions and Fixes for production issues within SLA
• Created EBC to display data from other databases using DB Views and tables
• Updated Siebel data in bulk using PL/SQL for one-time data fixes
• Created HTML email templates and content management
• Created Batch processing using RCR component invoking workflows and business services