SUMMARY:

• Over 11 years of experience in S oftware Design, Development, Integration, Implementation,Administration and Maintenance of Business Intelligence and Database platforms.
• Proficient in Full Life Cycle Development including requirements gathering/analysis, data modeling - scripting, design, development, t esting, production rollover and release management. Project scope, managing work schedules, project status reporting, project coordination & conflict resolution.
• Ability to quickly Analyze, Synthesize and dissect user requirements/ business data needs/ reporting requirements, critically evaluate information gathered from multiple sources and translate them into actionable and creative visualizations in Tableau. Develop, maintain and manage advanced reporting, analytics, dashboards and other BI solutions using mainly Tableau and QlikView etc.
• Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table Calculation, calculated fields, Level of Detail(LOD), Sets, Groups, Parameters, Forecasting, Blending and Trend lines.
• Extensive experience with SQL Development - Querying data, creating tables, creating views, stored procedures, Triggers etc.
• Leveraged Tableau for quantitative & qualitative analysis of performance KPI metrics, Sales & BI analytics dashboards by integrating, transforming and modeling huge sales data from disparate sources.
• Sales & BI analytics triggered a new cycle of aligning strategy and processes, effectively communicating sales compensation and performance updates, and provided executives with timely, accurate, actionable reports, analysis, trigger-based alerts & insights for Sr. Strategic Account Management.
• Extensive experience in Strategic consulting and end-to-end delivery of enterprise BI applications.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic and comfortable with advanced Tableau topics such as table calculations, parameters, geographic mapping, data blending and extract optimization and data mapping by accessing multiple data sources.
• Experienced in Java scripts API and Rest API for web embedding and on the web interactivity, and Extract API for Creating and Automated refreshing of Extracts .
• Wrote SQL to do initial data mining that can then be communicated or translated to ETL developers for database development with an emphasis on developing most optimal SQL queries scripts for a given solution or metadata layers .
• Knowledge of Data warehouse concept, Data modeling principles - star schema, snowflake schema , normalization/denormalization techniques.
• Responsible for collaborating with the business analyst and data analyst to resolve gaps between the business requirements and information delivery design specifications and ensuring these decisions are documented, performed data validation, analyzed tasks, data flows and dependencies.
• Mastered the ability to design and deploy rich, thoughtful visualization & visual analytics by leading and mentoring Tableau developers, creating functional & technical documentation, provided thought leadership, best practices, and standards for enterprise Tableau environment.
• Blending multiple data sources to design and develop Meta data/semantic models .
• Administered and supported a standalone and multi server Tableau server environments including Tableau installations, configuration and administration, content upgrades analysis and planning, user management, content distribution, monitor server activity , security administration, troubleshooting, performance tuning, and general systems maintenance, server security and general system maintenance including Disaster Recovery Plan and making enterprise tableau environment more scalable, available and stable.
• Responsible for integrating Active Directory with Tableau Server, monitor and support AD synchronization. Managed extracts, data connection maintenance and server's metadata.
• Collaborated with DBAs, Data Scientists, Business/Data Analysts, ETL developers, Metadata and BI Delivery Team & Product/Project Managers and Subject Matter Experts (SME) as well as with end users, project stakeholders and support partners to identify needs and strategic goals.
• Proficient in Excel and SAS, with knowledge of Project Management processes like Agile, Scrum Jira, Rally etc.
• Strong work ethics, positive attitude, excellent negotiation skills, team player with ability to handle a multitude of tasks and issues with excellent interpersonal and communication skills, and capable of exerting strong influence and have an unyielding ownership to produce results.
• Domain knowledge in F inancial, CPG, HR,R etail and I nsurance .

TECHNICAL SKILLS:

Business Intelligence Tools: Tableau Desktop/ Server 8.2/.3/9.0/10, Architecture, Administration, Qlick View, MS SQL Server, SSIS, SSRS, Informatica, MS Excel, SAS, SQL* LOADER, SQL Developer, PLSQL Developer and TOAD.

Programming Languages: SQL,T-SQL, PL/SQL, VB

RDBMS: Teradata,Oracle 9.x, Oracle 11g/10g a, DB2, MySql 4.0, MS SQL Server 2008/2012, MS Access,Netezza, Excel,PostgresSQL.

Operating Systems: Windows 9x/2000/XP, Linux, UNIX, Sun Solaris

Servers: Application Servers (WAS, Tomcat), Web servers (IIS, HIS, Apache).Windows 2008/2012.

Other Skills: MS Excel, PowerPoint, Word, IBM Rational ClearCase, IBM Rational ClearQuest, Red Hat Linux, Data warehouse, ETL Development,DB2Server,SDLC,DataModeling,Server Installation,Tuning,Maintainance,User Permissions.

PROFESSIONAL EXPERIENCE:

Confidential, PITTSBURGH, PA

Tableau Specialist Lead - Developer

Environment: Tableau Desktop/Server 9.0/.2/10.2, Oracle 11g, MS Excel, PostgreSQL.

Responsibilities:

• Data Analysis, Data Modelling with ETL Team, Gathering and analyzing business requirements, providing solution directions using Tableau thereby translating business requirements into report visualization and insights.
• Delivered Enterprise wide highly visible Dashboard for the Organizational Transformation Strategy Flagship Dashboard - The Carnegie Way Maturity Assessment Model which used a Spider/Radar chart not supported/available in Tableau by using Mathematics and Trigonometrical Ratios.
• Confidential Inventory 2017- the F lag ship dashboard of the Global S&OP Management . Complex Dashboard(workbook) with 21 Dashboards, over 100 sheets/views and over 100 Calculations each.
• Other Dashboards include 1) Engineering Assets Revitalization, 2) Coatings Dashboard.
• Collaborated in a Consultative capacity with all stakeholders to identify, research and qualify data across business functions, and established deliverables/solutions, timelines, and translated these into projects by providing thought leadership, best practices, and standards for enterprise Tableau environment.
• End to end data Visualizations solutions, Data modelling, POC, Testing and Data Validation by Analyzing the requirement, building the Logic into Excel Data Model and Managing the content on the server.

Confidential, SMITHFIELD, RI

Tableau Lead - Developer and Administration.

Environment: Tableau Desktop/Server 9.0/.2/.3/10, Oracle 11g, Netezza, MS Excel, PostgreSQL.

Responsibilities:

• Gathering and analyzing business requirements, providing solution directions using Tableau thereby translating business requirements into report visualization and insights.
• Visualized and designed the Flagship Dashboard - APR TCO Investment Posture and other 15 dashboards.
• Collaborated in a consultative capacity with all stakeholders-VPs, Directors and Principals . Developed interactive data visualizations and developed automated processes for updating Content-Data used in D ashboards. Created formulas and calculations within Tableau to meet the needs of complex business logic and comfortable with advanced Tableau topics such as Parameters, G eographic mapping/coding, Data blending and Extract optimization.
• Developed Visualizations using Cross tables, Bar Charts, Pie Charts, Donuts Charts, Maps, Line Charts, Scatter Plots and Combination Chart, Filters, Marking, Drill Down, Hierarchies, Color and Custom Expressions, Actions and Calculations.
• Actively Managed a group of 5 Summer Interns deployed on the Data Analytics Team.
• Acted as tier one support to build custom Admin views (Dashboard/Visualization) of server usage based on input from support team and service reporting (KPI) by leveraging PostgreSQL.
• Defined Group level security and ensured Active Directory Integration within Tableau Environment for automated user provisioning, SAML for security architecture and IIS (Ports) for Web Servers., licenses, integration and the appropriate permission sets for Tableau server logons and security checks.
• Managed Tableau Platform administration and Internal Web portal FIT Metrics, by adhering to best practices, metadata management, cache/ history management, user management (managed the users, groups, projects, sites, workbooks), scheduling refreshes, content delivery administration and security implementation

Confidential, ALBANY NEW YORK

IT Consultant- Developer/Visualizer and Administration.

Environment: Tableau Desktop/Server 8.3/9.0/.2, Oracle 11g, Teradata, MS Excel, PostgreSQL.

Responsibilities:

• Gathering and analyzing business requirements from clients, providing solution directions according to specifications using Tableau thereby translating business requirements into report visualization, design documents/POCs.
• Migrated OBIEE and Cognos based Visualizations to Tableau Environment with enhancements.
• Created Dashboards -Contingency & Total Workforce,GTR Performance Dashboard-Global, Lines of Businesses View, Global Functional View, Cycle Time All Hires, Sources of Global Hires etc.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, parameters. Created External filter, internal filter and Context filter to improve performance.
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Utilized Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used new Teradata OLAP Connector for Tableau which simplified access to the data warehouse and eliminated the cost, time and security risks of moving data out of the data warehouse for analysis. This Connector for Tableau enables to connect to an optimized business intelligence semantic layer in the Teradata Database that can be optimally leveraged to do visual exploration of the data in Tableau.
• Acted as tier one support to build custom Admin views (Dashboard/Visualization) of server usage based on input from support team and service reporting (KPI) by leveraging PostgreSQL .
• Defined Group level security and ensured Active Directory Integration within Tableau Environment for automated user provisioning,SAML for security architecture and IIS(Ports) for Web Servers. Manag ed the users, groups, projects, sites, workbook s, licenses, integration and the appropriate permission sets for Tableau server logons and security checks .
• Managed platform admin functionalities standards/ best practices, metadata management, cache/ history management, user management, scheduling, content delivery administration, security implementation, data source configuration, platform environment monitoring and support, product (Tableau) tuning, back up of servers and load balancing techniques to deploy Tableau server architecture to support high availability and scalability.
• Managed Server Security at various Levels-Authorizations, Authentication, Data Security, Network security and OAuth connections.
• Control Access to published contents on the server by managing permissions/contents permissions to Projects, Workbooks, Views and Data sources and by controlling (changing) the ownerships.
• Upgraded production environment to 9.X Test workbook/server functionality on QA and Prod and executed upgrade test functionality and monitor server performance post-upgrade. Supported and administered all non-production Tableau environments (DEV, QA).

Confidential, CINCINNATI, OH

Business Intelligence & Developer Lead

Environment: Tableau Desktop 8.1, Tableau Server 8.1, Oracle 11g, MS Excel, SAS

Responsibilities:

• Responsible for influencing business stakeholders through impactful data analysis and compelling story telling, organized and led meetings with these stakeholders to promote buy-in and build the BI strategic roadmap, provide leadership and vision for the BI team, Manage capacity and workload of BI team against competing priorities and deadlines.
• Leveraged Tableau for quantitative and qualitative analysis of performance metrics through Sales & BI analytics dashboards solutions by tracking, integrating, transforming and modeling huge sales data from disparate sources.
• Sales & BI analytics triggered a new cycle of aligning strategy and processes, effectively communicating sales compensation and performance updates, and provide executives with timely, accurate, actionable reports, analysis, trigger-based alerts & insights into the performance of sales forces, strategic accounts/channels and sales operations.
• Collaborated with National Strategic Accounts Management and Regional Business Teams to Create Dashboards - Strategic Accounts Managers Book of Business Report, Individual Relationships/ Accounts, Potential Business Opportunities and Pipeline Analytics and Dashboards for KPI such as COGS, Day sales outstanding, Lead Activity, Conversion rate, Customer retention, Life time value(CLV) & Acquisition cost, and Probability Adjusted Pipeline value etc.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views. Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Designed and developed Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Acted as a one-point contact subject matter expert (SME) in the Tableau environment providing technical and analytical expertise to immediate peers, onsite & offshore Tableau Resource and end users.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Identified Tableau content that requires optimization via a programmatic method. Implement automation of repetitive server administration tasks
• Set user permissions and published reports to Tableau Server, and provisioned daily updates via email subscriptions.
• Experienced administering Tableau server in a multi-site environment, server /platform sizing for projects, hardware and software requirements with a particular emphasis on performance maximization.
• Serve as a primary point of contact supporting the Tableau Server platform in Development, Production, and QA and Production Support issue resolution. Monitor and troubleshoot platform to guard against preventable issues and ensure performance that meets SLA.
• Experienced in using TABCMD and TABADMIN
• Performance tuning of workbooks, data sources, and providing best practices for user community.
• Integrating Tableau into various external environments (websites, webpages, SharePoint 2013, etc.)

Confidential, Houston, TX

Business Intelligence Analyst & Developer

Environment: Tableau Desktop 8, Tableau Server 8, QlickView, Teradata, Oracle 11g, DB2, MS Excel.

Responsibilities:

• Responsible for client facing, all aspects of BI technology management, and promoting BI awareness. Strategically, this includes evaluation, design, and implementation of BI Analytics solutions. Work with project managers to meet business requirements for project completion.
• Responsible for collaborating with the business analyst and data analyst to resolve gaps between the business requirements and information delivery design specifications and ensuring these decisions are documented, performed data validation, analyzed tasks, data flows and dependencies.
• ETL development, warehouse modeling and development, and structured & unstructured data analysis. Perform end-to-end Data Analysis and Mapping data points and data sources.
• Collaborated with EDM, C-level executives and senior IT leaders to create dashboards: Confidential Term Distribution-Sales Team, Created Life and Retirement Liquidity Dashboards for all the business with respect to Withdrawals, Surrender, renewals and Deposits (NB &Repeat business). Created dashboards for KPI such as Net Income Ratio, Claims Ratio, Policy Sales Growth YTD, Average Claim Time, % of sales Growth-Renewals and NB, Quotas v/s Production etc. and published on Web, desktop and other mobile platforms.
• Reconciled results in data visualizations to accepted sources, extracting information from data warehousing systems using SQL to obtain existing results.
• Scheduling & distribution, Tableau Server Management, Tableau Licensing, Authentication.
• Evaluate current data source and. tde (extracts) strategy and make recommendations.
• Develop and document technical architecture, system design, performance test results and other technical aspects of the products implementation.
• Monitoring & Tuning & Troubleshooting - Working with the team to constantly monitor, tune & optimize performance, incident management, root cause analysis.
• Responsible for security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication.
• Defined best practices during implementation and integration of Tableau Platform.
• Product implementation, system integration or development experience with strong emphasis on Tableau installations, configuration and administration Strong expertise with Tableau platform sizing, troubleshooting, tuning & disaster recovery.
• Refined and enhanced/upgraded the technical architecture and specifications to keep pace with changing business demands and new Tableau software releases. Provided a high level assessment of the current BI ecosystem/environment (challenges), which included understanding and assessing data a rchitecture, analyzing information flow from legacy applications, identify gaps and prepare a roadmap of futuristic architecture to achieve strategic business capabilities .

Confidential, Houston, TX

Tableau Consultant

Environment: Tableau Desktop 8, Tableau Server 8, Oracle 11g, Teradata, MS Excel

Responsibilities:

• Provided technical leadership to help shape the strategy, architecture, design and implementation of business intelligence solutions platform ensuring accurate, timely and complete information is delivered to business users.
• Tableau server Installation and configuration for a two node Cluster-Primary and worker.
• Active Directory Authentication and synchronization with official domain
• Managed user base of 500+ and ensured they have the legitimate login credentials, permissions, roles etc.
• Published reports to Server and provisioned Alerts and Subscriptions. Content distribution and management.
• Used Existing Teradata access authentication and authorization rules provide built-in security for direct access from Tableau business analytics software to the Teradata database.
• Used Teradata Administrator/Viewpoint/ Manager Tools for monitoring and control the system.
• Teradata Client Utilities and Backup and Recovery Utilities
• Used filters to create custom date ranges such as Selling Season. Used filters to display information from various time ranges such as YTD, TTM, and Fiscal Year-to-date Building complex dashboards in Tableau, building automated reports / report templates and delivering BI solutions .
• Created calculated fields to customize available data for reports and also created Bar-Mekko graph to display percent growth and revenue by channel using marks.
• Created line graphs that displayed current sales against previous years’ sales, budget, and goals.
• Used filters to create custom date ranges such as Selling Season.
• Created multiple extracts to quickly access historical data in lieu of live connections

Confidential, Irving, TX

Tableau Consultant

Environment: Tableau 7x, SQL Server, Microsoft Excel, Microsoft Access, Windows XP

Responsibilities:

• Worked closely with business/ data teams to gather requirements and convert them into technical specifications. Conducted Business Acceptance and user Acceptance testing and sign-off meetings.
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
• Created extracts (. tde files) using SQL and built custom visualizations and Schedule/automated refreshes of the same on the Server.
• Data security-by creating Database login accounts-through Windows NT/database built in security and by Authentication and creating filters as owner of the workbooks.
• Published reports to Server and provisioned security Alerts and email Subscriptions to stakeholders.
• Content distribution and management - workbooks, packaged workbooks, reports and data sources.
• Licensing management and proper documentation for Audit purposes.
• Built, published customized interactive reports and dashboards, report scheduling.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Effectively used data blending, filters, actions, Hierarchies.

Confidential, San Mateo, CA

Tableau Developer

Environment: Tableau 7x, SQL Server 2010, MS Office.

Responsibilities:

• Responsible for the requirement gathering, design and reviewing the Tableau Design Document.
• Build Data Views and Dashboards in Tableau 7.0 Desktop, created workbooks and published them.
• Data blending with multiple data sources on a single worksheet.
• Optimized the performance of the reports in tableau desktop with context filters, groups, sets, and Extracting data from large sets.
• Performance optimization on the DB level by indexing based on execution plans, partitioning.
• Scheduled the extracts daily, weekly and monthly and managed the Subscriptions for users.

Confidential, Herndon, VA

BI Database Developer

Environment: Oracle 8i, PL/SQL, SQL*Loader, ODBC, Windows NT, UNIX.

Responsibilities:

• Documented requirements gathered from the business users and customers.
• Wrote Oracle, SQL and PL/SQL code to implement the technical design.
• Interacted with the business and IT to understand the business process, business needs and how they relate to IT. Actively Participated in JAD session scribed the requirements.
• Developed BRDs in close coordination with the Marketing Group. Decided, on visual and functional aspects required for the developed reports.
• Assisted users on useful business cases to display on the reports. Developed a thorough understanding of the business process while doing so.
• Responsible for Report design, and supporting modification of existing reports. Reports dealt with user related KPIs based credit scores.
• Helped end users to design test cases and worked through multiple UAT cycles.

Confidential

Software Engineer

Environment: HTML, CSS, Java Script, Ajax, Windows XP / 2003 server, Oracle 10g, SQL, PL/SQL, MS-Office.

Responsibilities:

• Heavily involved in Object Oriented programming and software development (using J2SE).
• Led a companywide team of Java Developers establishing in-house GUI and Java usage standards.
• Developed repository database of design cores with Java Class Loading and Java Runtime.
• Wrote the foundation classes for a GUI component library for an e-ink device at Ricoh.
• Frequently act as mentor to other Python programmers.
• Preparing Web based User Interface using HTML, CSS, Java Script, and Ajax.
• Have a significant personal module library with exemplary code quality and style.
• Strong knowledge of the language specification (JLS) and Java virtual machine principles (JVM).
• Have ported Java ME to an embedded MIPS/NETBSD architecture.
• Implemented XLET life cycle management, involving solid understanding of class loading and garbage collection.
• Developing PL/SQL stored procedures and functions for data base intensive operations.
• Responsible for implementation of Replication methodology using PL-SQL triggers.
• Participated in the evaluation and trial of spring (MVC, AOP) framework for the application.
• Application Source code control using Microsoft VSS and CVS.
• Coordinate application end-to-end integration testing for various project build releases.
• Identifying and troubleshooting the failure of production deployment in clustered environment.

Confidential

Junior Software Engineer

Environment: Java Script, C++, Ajax, Windows XP / 2003 server, Oracle 10g, SQL, MS-Office.

Responsibilities:

• Creating Database scripts for tables, views, triggers.
• Developing User Interface forms using Visual Basic 6.
• Prepare and conduct unit testing and User Acceptance Testing.
• Preparing user manuals and conducting onsite User training.
• Developed repository database of design cores with Java Class Loading and Java Runtime.
• Wrote the foundation classes for a GUI component library for an e-ink device at Ricoh.
• Frequently act as mentor to other Python programmers.
• Participated in the evaluation and trial of spring (MVC, AOP) framework for the application.
• Application Source code control using Microsoft VSS and CVS.
• Coordinate application end-to-end integration testing for various project build releases.
• Identifying and troubleshooting the failure of production deployment in clustered environment.
• Developing offline thick client solution using Java Swing for a specific segment of customers.