PROFESSIONAL SUMMARY:

• Over 6 years of extensive IT experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence applications along with strong experience of data visualization .
• Expertise in performing development activities from gathering requirements and designing solutions including analysis, modeling, design, and development of reports and dashboards for analytics and reporting applications.
• Hands on Tableau desktop 7/8.0/8.2/9.0/9.3/10.3 , Tableau server and Tableau Reader.
• Extensive experience working with Tableau Software as a dashboard developer .
• Extensive experience creating canned and ad - hoc reports in Tableau Desktop.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Sets, Groups, Cubes, Calculations and Maps etc.,
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables .
• Practical understanding of the Data Modeling Dimensional Relational concepts like Star - Schema Modeling , Snowflake Schema Modeling, Fact and Dimension tables.
• Mastered in joining tables , multiple data connections using blending , worked on Data Extracts and managing queries.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships , working with Sites , that allowed end users to understand the data on the fly with the usage of quick filters for on-demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Used multiple Tableau data sources (. tds) from excel, CSV, text files and RDBMS (SQL Server) as source systems for workbook generation using Export/Live connection and methodologies.
• Improved Reports performance in Tableau using LOD expressions and context filters .
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Implemented row and column level security .
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Involved in creating Stored Procedures, tables, and views for applications .
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Enhancing my knowledge on Alteryx and Amazon EMR.

TECHNICAL SKILLS:

Operating Systems: Windows, Mac, LINUX

Languages: C, C++, SQL, Matlab

Tools: Tableau Desktop v7/v8/v9/v10, Tableau Server v7/v8/v9, Alteryx, JIRA, Kiel uVision, LabVIEW, Matlab/Simulink

Databases: Amazon EMR, Oracle 11.2, Teradata 13, SQL server, MS Access

PROFFESIONAL EXPERIENCE:

Confidential, Malvern, PA

Sr. Tableau Developer

Responsibilities:

• Created different KPI's based on marketing, operations, and customers. Analyzed KPI scoreboard and compared KPI trends.
• Used interactive Client Dashboards to monitor Client counts, their demographics, balances and assets using bar charts, donut charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Tableau helped the team to get deep insights into different funds and accounts like TA, VBA and VBS accounts and Client types by analyzing YTD and MTD changes, Top and bottom funds, penetration Clients and Assets for different Products and Service Segments.
• Monitored Retail Digital Dashboards to understand client activity, engagement and service adoption.
• Created individual dashboards to monitor different services and client satisfaction like PAS Dashboard, ETF Dashboard etc.
• Helped in identifying right audience for campaign launches.
• Created complex formulas and calculations to do data preparation.
• Created a Project Tracker for Retail analytics Team.
• Created one single tableau portal on Tableau Server to access all different dashboards at one place and embedded this portal on SharePoint.
• Added new functionalities to the Tableau dashboard like one “Reset ALL” filter option, Quick Table of Contents letting two workbooks combine in one dashboard, Zoom In/out Timelines for individual filters, switching chart types/two sheets etc.
• Created different chart types like Sparkline charts with KPIs indicated, Waffle chart, Radial Tree map, Scatter plot, Sankey diagram etc.
• Amazon Web Services is the new adoption in the company, so helping the data lab team to test Adobe AWS data with Tableau using AWS EMR data source.
• Followed JIRA Scrum methodology, met the challenges and produced a value-added Tableau Product.
• Created users, groups, and domains from Active Directory and created different License Levels for each user.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Running What-If analyses for customers trying to grasp the impact of investment decisions.
• Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.

Environment: Tableau 10.3/9.3, Amazon EMR, Oracle 11.2, Adobe analytics, JIRA, MS Excel.

Confidential, Arizona

Sr. Tableau Developer

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Used interactive banking dashboards to monitor Federal Funds Chart, FED funds borrowing and lending reports using Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Analyzing deposits, consumer loan production, new loans, regional comparisons.
• Created dashboards representing the transactional activity and its trends.
• Monitored Household Debt, mortgage conditions and outstanding claims
• Created financial dashboards reflecting revenues, expenses, Net Income, Margin related information.
• Monitored risks; Operational risks and credit risks.
• Followed JIRA Scrum methodology, met the challenges and produced a value-added Tableau Product.
• Converted existing BO reports to tableau dashboards
• Also, involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Scheduled extract refresh for weekly and monthly reports.
• Took back-up of the Tableau Server on a regular basis by using Tabadmin commands and have also restored when there was a system failure.
• Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

Environment: Tableau 9.3/8.2, Oracle 11.2, JIRA, MS Excel and SQL Server 2008.

Confidential, NYC

Sr. Tableau Developer

Responsibilities:

• Involved in end to end implementation and enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop. Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 8.2, Tableau server / Administrator, Teradata 13, SQL Server 2008.

Confidential, New Jersey

Tableau Developer

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Created area map to find out customer base usage within United States and found gaps in areas where Confidential lacked coverage due to internet service provider. Created quick filter to narrow down individual states and cities along with revenue being generated in individual state or city.
• Created side by side bar chart comparison of Confidential users who were domestic vs. international along with providing profit revenue generated.
• Developed Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPIs.
• Extensively used data blending, embed functionalities in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedules and checking the tasks daily on the server.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Performed SQL reporting with the ability to create SQL views and wrote SQL queries.

E nvironment: Tableau Desktop 8, Tableau Server 8.0, Microsoft Office 2013, SQL Server 2005, PL/SQL, T-SQL.

Confidential

Sr. SQL Developer

Responsibilities:

• Plan, design, and implement application database code objects such as stored procedures and views.
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data files for counterparties.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Trained and mentored EBI team, users and assisted and coached them in material, processes and delivery of training, training standards and best practices.
• Interacted with report owners to establish/clarify their requirements and developed report specifications.
• Performed development activities from gathering requirements and designing solutions, through developing code/ reports, to testing and release / deployment

Environment: Microsoft, Linux, Oracle 9i / 8i, SQL Server 2005, MS Access 2010Designed the website and developed web interfaces.

Confidential

Software Engineer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
• Write T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries.
• Managed rollback segments, and tablespaces to ensure less space used by the database.
• Created documentation on the all the tables, stored procedures, views and user defined functions.

Environment: MS SQL Server 2000, Windows Server, Erwin V4.0, Visual SourceSafe, Crystal reports, DTS

Confidential

Business Analyst

Responsibilities:

• Consult on medium to large-scale support projects involving BAs, Software Engineers/Sr. Software Engineers.
• Provides production support, including on-call support as required.
• Work with technology teams to manage help desk tickets for support and enhancement requests.
• Investigates, troubleshoots and corrects data and user related system complex errors.
• Develop and review functional change specifications done by the Business Analysts.
• Maintain smooth day-to-day support and maintenance of applications under Wealth Management Technology.
• Acted as liaison between business and technical teams.
• Developed project Vision statements.
• Reviewed epics, user stories, use cases, and other analysis artifacts produced by the analysts, and provided feedback and guidance.
• Reviewed SQL data models, UML models, and other design artifacts produced by the team, and provided feedback and guidance.
• Worked closely with technical project managers and scrum masters to develop project plans, understand project and team interdependencies, manage risks, and conduct retrospectives.
• Coordinated with the QA team to resolve ambiguities in the requirements and ensure requirements were traced to test cases. Worked with the business to coordinate UAT.
• One of two senior analysts in the Mobile Applications program, supporting the development and deployment of Schwab's mobile applications, including an iPhone application, iPad application, and Android application.
• Defined the Vision for each of the projects (iPhone, iPad, and Android). Identified stakeholders, defined stakeholder needs and current process pain points, developed features which addressed those needs, and worked with the stakeholders to prioritize the features.
• Developed the use case model, detailed use case specifications, and other functional and non-functional requirements. As the program shifted to agile, developed epics and user stories.
• Developed and delivered a series of training courses for Schwab, covering topics such as the role of the BA, key BA skills, playing the role of a lead BA, identifying and modeling use cases, building detailed requirements specifications, and coordinating UAT.

Environment: Windows /XP, Microsoft Office SharePoint 2007, Facets, Rational Requisite Pro, MS Office, SQL Server, Agile/Scrum, MS Publisher, MS Access, EDI, Documentum 2.0., UML.