SUMMARY:

• Strong in Business Intelligence landscape with 9+ years of experience in Data Analytics, Balanced Score Cards, KPIs and Reporting, exploring data and connecting the dots
• Over 4 years of experience in Tableau Desktop/Server in creating high interactive Data Visualization
• Strong expertise in developing a high performance dashboards with Story points and Advanced calculations
• Expertise in project management of schedules, resource planning, dependency management, risk analysis, and issue resolution
• Functional and domain experience with Financial, Investment, Insurance, Telecom and Commercial applications
• Experienced on Tableau Admin activities , Multidimensional database and SQL
• Strong expertise in design and development of BI applications using Cognos, BOBJ 4.0 Suite, Tableau.
• Experience installing, upgrading and configuring Tableau Server for high - availability
• Responsible for security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication
• Data modeling, data visualization, dashboard development using Cognos, BOBJ suite, Tableau
• Designed, implemented QA environment in manual and automated test suites for GUI/ETL testing
• Experience in Change Management - Detects, documents, alerts and continuously maintains shift and drift system configuration resulting from planned and unplanned events and Risk Prevention.
• Proven capability in business analysis , data quality improvement, data visualization and data science , turning business requirements into advanced dashboard and reporting solutions that provide actionable insight
• Experience with RDBMS like Oracle, SQL Server, MySQL
• Capable of managing small to medium sized projects with solid experience documenting existing process flows and proposing new process implementations using new/evolving industry standards
• Excellent written and oral communication, interpersonal skills and presentation skills. Proven ability to work efficiently in both independent and team work environments.

TECHNICAL SKILLS:

Operating Systems: UNIX, WINDOWS 95/98/ NT/ 2000/2003/2008/ XP/7

Testing Tools: Quick Test Professional (QTP), LoadRunner

Test Management Tools: Test Director, Quality Center.

Business Intelligence Tools: Tableau (8.x/9.x), Tableau Server 8.x/9.x, Crystal Reports

Cloud Technologies: Amazon Web Services (AWS)

Web Technologies: ASP, HTML, DHTML, Java Script, VB Script, and XML

Web/Application Servers: IIS

Database: ORACLE, MS SQL Server / 2008, DB2

Programming Languages: Visual Basic, VB Script, C, SQL, PL/SQL, Java Script, XML, PHP, JSP, and Java.

GUI: Visual Basic 5.0/6.0, VB.Net, ASP, ASP.Net, Developer2000

Other skills: MS Word, MS Excel, MS Access, MS Project2000, MQ Series, MS Visio, JIRA, PVCS, Serena

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Tableau Lead Developer

Responsibilities:

• Lead a team and successfully migrated SAP BO, Cognos reports consisting of metrics into Tableau with high data visualization
• Automated the metadata audit for all identified Tableau Data Sources using Workbook Tools for Tableau and created a Data Dictionary of Metadata report to selectively drive the metadata view
• Interacted with business users, gathered requirements and translated the business to data visualization
• Trobleshooted the performance issues and successively optimized the workbook by using performance analyzer
• Successively developed Semantic layers, shared with business/functional users and assisted to develop the Tableau Content
• Executed Tableau Doctor Session to business users, resolved the challenges and suggested the best practices
• Successively initiated the data sources release using PVCS and Serena and monitor the version control
• Followed JIRA SCRUM methodology, met the challenges and produced a value added Tableau Product
• Played a role of Admin in Tableau Customer Portal and monitor the license distribution for Tableau Content Developers
• Ensured Action Filters on the reports shared with users with added row level security
• Performed Tableau Admin activities in creating the Active Directory, scheduled Refresh and monitored the alerts
• Enhancements of ACE application to support the representatives, regional heads for planning/forecasting and execution of marketing the products by ranking, positioning, category, brand, weighted & un-weighted.
• Designed and developed Ad-hoc reports with filters, Quick Filters, Context Filters, Global Filters, Parameters, Data Extracts and Calculated Fields using Tableau.
• Compared data and analyzed using Data Blending, Groups, Combine Fields, Calculated Fields, and Aggregated Fields, Spotlighting.
• Worked with Sets/Groups to display top products based on their sale.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Utilizing capabilities of Tableau such as Data Extracts, Data Blending, Forecasting, Dashboard Actions and Table Calculations.
• Developed reports using multiple measures like Individual Axes, Blended Axes, and Dual Axes.

Environment: Tableau Desktop (8.x/9.x), Tableau Server (8.x/9.x), SQL Server, Oracle, Excel DB2, windows, PVCS, Serena (Dimensions), JIRA.

Confidential, San Antonio, TX

Tableau Developer

Responsibilities:

• Developed a reports using KPI and allowed the business users to take key decisions
• Created a TDE s, published to Tableau Server and scheduled a Incremental refresh
• Created custom SQL to meet the requirements and shared the Tableau Data Source with end users
• Analyzed the data, performed the transformation and developed a analysis showcased the Story points
• Collected data from different data sources for building the data mining database
• Manage the application’s users, groups, and integration with Active Directory
• Experience in taking back ups and restoration of Tableau repository
• Developed reports in Tableau by connecting to various data sources like MS SQL Server, Oracle, MS Excel and CSV)
• Synchronized and audited the AD Groups
• Generated ad-hoc Tableau reports based on user requirements.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports
• Combined multiple data sources by joining tables and using Data Blending
• Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drill down and drill up reports
• Worked on groups, sets, different calculation functions including Table calculations
• Created dashboards with the security using filters for the clients to measure cost saving
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified
• Designed and developed Business Intelligence end to end solutions using Tableau
• Published Workbooks by creating user filters and security, so intended teams can view it
• Developed tableau dashboards with combination charts for clear understanding
• Build complex calculations using advanced functions
• Created visualizations in Tableau using Excel data extract source
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively

Environment: Tableau (8.x/9.x), SQL Server, Teradata, MS Access, Microsoft Office Suite (Word, PowerPoint, Excel).

Confidential

Data Analyst / Tableau Developer

Responsibilities:

• Reviewed Test Strategy, Test Plan documents and Test scenarios
• Involved and managed defect management process, scenarios and test steps
• Created and executed test cases for functional testing
• Interface with development teams to clarify issues and resolve any conflicts
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives
• Administered user , user groups , and scheduled instances for reports in Tableau
• Create, customize & share interactive web dashboards in minutes with simple drag & drop
• Created incremental refreshes for data sources on Tableau server
• Coordinated database middleware issues with DBA's, system performance with System Architects
• Defined best practices for Tableau report development
• Worked on SQL Tuning and Optimization of the reports

Environment : Business Objects XI R2/ 3.1, Rich Client, Info-View Web Intelligence, CCM, CMC, Designer, Crystal Reports XI, SQL 2008, Oracle 10g, Microsoft Excel 2007, Tableau 7.0.

Confidential

SQL Developer

Responsibilities:

• Regression testing using Selenium at various phases of the development
• Prepared and Executed Test cases as per the Requirements
• Created complex SQL stored procedures and functions using Microsoft SQL Server 2008R2
• Involved in code review and code review meetings
• Involved in error handling, performance tuning of stored procedures
• Used Team Foundation Server for version control needs, track check-ins and roll back code as necessary
• Coordinated with Technical Analysts in understanding the business requirements and translated them in to technical specifications
• Analyzed the data as per business needs to build the Interface
• Developed Scheduled Jobs to automate the packages

Environment: Windows 2003/XP, Selenium, Java, Oracle, SQL, PL/SQL, HTML, XML, PHP, UNIX

Confidential

Analyst/BA

Responsibilities:

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Developed Test Plan covering functional, integration, regression and end-to-end testing.
• Analyzed system requirements and formulated Test Plan that contains test scenarios for functionality and Security testing of the application.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL.
• Performed Load, Performance and Stress testing
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Environment: QTP, QC, ApTest Manager, SQL Server, SSIS, Import/Export tools, PL/SQL.

Confidential

QA Analyst

Responsibilities:

• Involved in creation of Test Strategy and Test Plan.
• Created high-level test scenarios, test cases and test scripts.
• Worked with different phases, testing of Functional, Regression, Integration and System Testing.
• Generated, executed automated scripts using QTP for Functional and Regression testing.
• Tested real time interfaces and batch interfaces between the vendors.
• Involved in Performance testing using Load Runner tool

Environment: QTP, VB, VC++, QC, Load Runner, VB.net, TSO/ISP, Oracle 9i/10g and MS access, MS SQL Server 2005, MS Project, MS Excel, Toad, SQL *Loader, SQL *Plus, Oracle SQL Developer