SUMMARY

• 5+ years of experience in Design, Development, Integration, Implementation and Maintenance of Business Intelligence (BI) and Data Warehousing Platforms.
• Responsible for the analysis, development, administration and support of ETL processes for large - scale data warehouses using Asset Control.
• Expertise in Extraction and Transformation (ETL) of data sourced from flat files, excel, xml, Oracle DB and SQL Servers.
• Strong technical background with complete understanding of data warehouse modeling and architecture.
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL processes.
• Strong ETL experience in Repository and Workflow Management, Design, Mappings and Transformations.
• Proficient in creating mappings for data flowing from various sources using transformations like Source Qualifier, Expression, Look Up, Aggregate, Update Strategy, Joiner, Filter and Router.
• Provided in-depth operational and maintenance support for business-critical applications. Assisted with operating systems background server issues, low level data file edits, job ab-end issues, data relationships etc.
• Experienced in administrative activities like creating and managing repositories, monitoring/granting permissions and rights to users, user groups through Central Management Servers.
• Strong knowledge of database management writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Extensive Tableau experience in enterprise environment. Worked in Tableau 7.x, 8.x, 9.x, 10.x as a developer with in-depth knowledge of Tableau Desktop and Tableau Server.
• Expert in design, development & administration of Tableau Dashboards and servers in data warehouse environment.
• Skilled Tableau front-end BI developer integrated with multiple back-end databases and other various data sources.
• Extensive experience creating canned and ad-hoc reports in Tableau Desktop.
• Developed and implemented best practices for using both Live connections and Tableau Data Extracts.
• Proficient in migrating workbooks between different environments in Tableau server using Tabcmd.
• Designed and developed workbooks, dashboards, global filter pages, and complex parameters-based calculations.
• Ability to communicate business and technical issues to both business users and technical users.
• Successfully completion of projects (Commercial/Academic) related to Data Management, Analytics and Project Management.
• Excellent interpersonal and client relationship skills. Proven communication, presentation skills and leadership qualities.
• Completed Indian National Stock Exchange’s certifications in financial markets and equity derivatives modules.

TECHNICAL SKILLS

Business Intelligence: Tableau 7.x, 8.x, 9.x, 10.x, Tableau Desktop, Tableau Reader, Tableau Server

Languages: Python, Oracle SQL, R

Other ETL/Reporting Tools: SSIS, DTS, Asset Control BI, Informatica Power Center, RStudio, Microsoft Azure ML, JMP, Minitab, SQL Server Reporting Services (SSRS), Crystal Reports

Databases: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008 , DB2, MySQL

Operating Systems: Windows 98/XP/7, Windows NT/2000, Server 2003, Vista,7, Unix, Linux

Query Tools: Toad, SQL Plus, SQL Developer, SQL Server Management Studio, SQL Workbench

FTP Tools: FileZilla, CuteFTP, Putty, FTP Commander

Applications: Advanced MS Excel, MS Visio, MS Access, Adobe Dreamweaver, Apache Cordova, Spyder 3

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Tableau Developer / Business Intelligence (BI) Developer

Responsibilities:

• Responsible for designing and developing various weekly and monthly reports showing detailed information that could be used to send information to a diverse group of users, clients, and managers.
• Published various kinds of interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Connected Tableau to various databases to establish live connections. Created schedules for incremental refreshes for data sources on Tableau server.
• Deftly designed dashboard templates as per the requirements & dashboards content which included bar charts, water fall charts, score cards, Gantt charts, Bubble charts, Word maps, Geospatial visualizations, network charts etc.
• Performed generating Daily/Weekly Sales, Finance trending & forecasting reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview of current, historical and future trends.
• Developed advanced tableau skills such as complex calculations, table calculations, parameters, geographic mapping, data blending, and extract optimization.
• Gained extensive knowledge in various reporting objects like attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups and parameters.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option using Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the business analysts.
• Worked extensively in creating dashboards using Tableau Desktop and published them on Tableau Server. Involved in the administrative tasks of Tableau server like installations, upgrades, user & user groups creation and set up of security features.
• Upgraded the existing server version to Tableau 9.3 and successfully migrated existing workbooks and data sources.
• Generated reports using SQL queries and published them to users through Tableau server.
• Involved in meetings with business users to discuss and finalize the requirement and design of reports.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Conducted performance tuning in Tableau to improve report response time.
• Assisted users with questions and issues using Tableau. Worked with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Utilized Tableau’s type conversion functions to avoid unnecessary default data aggregations.
• Provided technical support to all team members during project execution.
• Handled change requests and provided support/maintenance for deployed projects

Environment: Tableau Server, Tableau 9.x, SQL Server, Oracle 10, Microsoft Office Suite (Word, Excel, Power Point)

Confidential, New York, NY

Tableau Developer / Business Intelligence (BI) Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards.
• Extensively used data blending, filters, parameters, sets, groups etc.
• Defined best practices for Tableau report development.
• Executed and tested required queries and reports before publishing.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype of the same using Tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

Environment: Tableau Desktop 10, Microsoft Office (Word, Excel, Power Point), Google Analytics & Surveys.

Confidential

Business Intelligence (BI) Developer/Tableau Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery of reports.
• Created compelling dashboards and prepared user stories which delivered actionable insights.
• Created multiple dashboards which visualized measures of sales, growth, revenue, profits, customers etc.
• Involved in publishing of interactive data visualizations, dashboards, reports and workbooks on Tableau Server.
• Involved in the administration tasks of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Generated reports using SQL queries in Tableau 8.x and published them to business users through Tableau server.
• Involved in generating time period product sales, outlet performance, and financial reports using Tableau by identifying the dimensions, measures, measure values at different level of details/granularity for business analysts & top other stake holders to give an overview current and future trends.
• Developed expertise in creating motion charts, bubble charts and conducting Drill-down analysis using Tableau desktop.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently
• Assisted users to publish and collaborate reports via a web browser embed Tableau views in other web applications like SharePoint.
• Created and modified schedules for extract refreshes and delivering subscriptions.
• Documented complete server administration and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau 8.x, Tableau Desktop, Tableau Server, Oracle DB, MySQL Server, Microsoft Office

Confidential

Business Intelligence (BI) Developer

Responsibilities:

• Performed business and technical analysis with stakeholders to develop requirements document for ETL design specifications.
• Developed and maintained ETL mappings using Asset Control to extract the data from multiple source systems that comprised databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, DW and then to the Data Marts.
• Created mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache
• Hands-on expertize in acquisition, cleansing, normalization, consolidation/integration, validation and distribution of financial reference data to internal and external business applications.
• Designed and deployed multiple jobs for automation of various jobs for extraction, cleansing and loading of files into business applications.
• Communicated continuously with business users to develop consolidation rules for various financial instruments.
• Created and monitored sessions using workflow manager and workflow monitor.
• Created high performance SQL scripts to reduce the time taken for producing ongoing ad-hoc reports.
• Performed data quality testing to ensure integrity, consistency and reliability of data in the applications.
• Recommended scheduling enhancements that improved system performance by 25%.
• Played an integral role in compiling detailed knowledge base documents that helped reduce the request-processing time by 65%.
• Worked with portfolio managers to understand the requirements for delivery of dashboards/reports using Tableau and Excel.
• Created visualizations using Tableau to find trends and identify patterns in time series data associated with securities.
• Created the logical data and calculations’ design within Tableau in order to deliver appropriate KPIs and metrics to the client.
• Coordinated with client’s BI teams to deploy Tableau workbooks to Tableau servers owned by the BI team environments.

Environment: Asset Control DW Solution, Oracle DB, MySQL DB, Unix, MS Excel, Tableau

Confidential

Mobile Application Developer

Responsibilities:

• Designed and developed a mobile application capable of maintaining notes, short multimedia recordings and confidential material.
• Created test cases for new features and performed multiple rounds of regression testing to maintain product quality.
• Ensured prompt resolution of bugs reported by product managers and clients; optimized system performance.

Environment: Android SDK