SUMMARY:

• 11+ years of professional experience, with 6+ years of experience in designing, administration, analysis, building impactful reports and dashboards using Tableau Business Intelligence, 3+ years of ETL development and testing, 6+ years of experience in Quality Assurance both Manual and Automation testing of client server, web - based applications
• Effectively managed complex projects with global implementations and managed group of testing team members as a Sr. Tableau Developer / Administrator by assigning projects, setting deadlines, tracking project status, publishing project closure report with analysis
• Rich experience in Banking, Insurance and Healthcare domains, Oracle CRM and IBM Mainframe applications
• Proficient in all phases of BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training
• Expertise in requirement gathering, analysis, design, development, testing, and production rollover of reporting and analysis projects
• Expertise in Tableau desktop and server, for data analysis and producing attractive visuals/dashboards to convey the story inside the data
• Proficient in Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server
• Experience in Tableau security implementing row level security and users filters at group level
• Expertise in various reporting objects like Info objects, Data sources, Info cube, Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups, Parameters in Tableau
• Expertise in Joining tables, multiple data connections using Blending, Actions, Calculations, Forecasting, Parameters and Trend lines
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps
• Experience in trouble shooting of performance issues which were associated with Tableau reports.
• Proficient in working with Hadoop Hive and other databases, extracting data to tableau for analysis and reporting purpose
• strong understanding of Data Warehouse Concepts, ETL, OLAP, OLTP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Expertise in preparing Cost estimation, Project plan, Run plan and Statement of Work (SOW)
• Proficient in publishing various status reports like Daily, Weekly, monthly using Peoplesoft
• Well versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle(STLC), Defect Management Life Cycle
• Experience in V & V, Waterfall and Agile methodologies
• Proficient in Defect management system using tool HP ALM, participating defect status meetings, defect reporting and analysis of defect
• Expertise in managing UAT support, ensure the test script, test data preparation, defect management, conducting defect status calls, managing new CR’s till smooth completion of UAT
• Strong working knowledge in NoSQL databases Hadoop Hive, HBase, Cassandra and MongoDB
• Good understanding of SOAP, Web Services, XML, JSON
• Played significant role in various phases of project life cycle, such as requirements definition, functional and technical design, testing, production support and implementation

TECHNICAL SKILLS:

BI Tools: Tableau 8.x/9.x/10.x

ETL Tools: Data stage 8.x/9.x

Database Tools: Oracle 11g,10g, Teradata, SQL developer, SQL server, MS-Access

NoSQL Database Tools: Hadoop - HBase, Hive, MongoDB, Cassandra,

Applications: Oracle CRM, Oracle Apex, IBM Mainframe, Peoplesoft

Operating Systems: Windows, Linux, VMWare

Test Management tools: HP ALM - Quality Center, QTP

GUI Tools: Unix/Shell Scripting, WinSCP, Putty, Toad, CBIS / ISIS (Web Services)

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. Tableau Developer

Responsibilities:

• Participated in Business user meetings for requirement gathering and analysis, managing the deliverables
• Prepared Cost /Effort estimation for subject area based on the business requirements provided
• Created Project Plan documents as per business requirements and providing walkthrough to stakeholders
• Worked closely with Business users, interacted with ETL developers, Project Managers, and members of the QA teams
• Coordinate with the Team Manager & the team for various complex business requirements through SCRUM Agile process
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Configured Tableau Server for granting licenses appropriately to the corresponding users; created and supported new projects and sites
• Worked on several business models and established different parameters for a business and personalized recommendation model for Tableau 
• Defined best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Extracted data from Hadoop hive to tableau for preparing dashboards and stories
• Created Tableau dashboards with interactive views, trends and drill downs along with user level security
• Published and shared the reports, dashboards with business users through Tableau server
• Involved in administration tasks such as setting permissions, managing ownerships and providing access to the users and adding them to the specific group
• Provided Single Sign On (SSO) authentication for specific user group in the identity store using tableau
• Developed Parameter based reports, Drill-down reports, Charts and Tabular reports using Tableau and enabled ad-hoc reporting
• Documented all the dashboards related information, overview of each dashboard, calculations performed on each dashboard
• Prepared and published project status reports like daily, weekly, monthly using peoplesoft, prepared project closure and analysis report
• Prepared test cases for unit testing created various test cases to validate the data, performance and look feel of the reports
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Supported all phases of the project development, testing, Pre-implementation runs and Production support
• Delivered tasks on time, bug free and with high quality also with excellent customer service skills

Confidential, Falls Church, VA

Tableau Developer

Responsibilities:

• Extensively participated in development phase meetings for business analysis and attended both business / functional requirement document walkthrough
• Analyzed the requirements and created Technical specification document based on the functional document provided by the business
• Prepared Cost estimation for subject area based on the business requirements provided
• Prepared Project plan, Strategy and Run plan according to the business requirements for tiny, small, large projects and providing Strategy walkthrough to stakeholders
• Participated in Business user meetings for requirement gathering and analysis, managing the deliverables using Tableau Business Intelligence tool
• Created Project Plan documents as per business requirements and providing walkthrough to stakeholders
• Worked closely with Business users, interacted with ETL developers, Project Managers, and members of the QA teams
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards 
• Defined best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Coordinate with the Team Manager & the team for various complex business requirements through SCRUM Agile process
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Configured Tableau Server for granting licenses appropriately to the corresponding users; created and supported new projects and sites
• Worked on several business models and established different parameters for a business and personalized recommendation model for Tableau 
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Prepared and published project status reports like daily, weekly, monthly using peoplesoft, prepared project closure and analysis report
• Prepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Experienced in Defect Life Cycle Management using HP ALM quality center, Defect reporting, participating defect status call along development, interface, TP system teams for resolving, retesting and closing the defect
• Prepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports
• Used Agile testing methodology (Scrum based testing) for achieving deadlines in UAT testing
• Reviewed, maintained and updated regression suites upon receiving new build and ensure reuse of the suite for CR’s
• Supported all phases of the project development such as UT, ST, SIT, UAT, UVT, Pre- implementation runs and production support
• Delivered the activities on time, bug free and with high quality also with Excellent customer service skills

Confidential

ETL Developer/ Tester

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications
• Performed Data Analysis and developed Data Mapping documents for ETL projects
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration
• Created Datastage jobs, batches and job sequences and tuned them for better performance
• Extensively used different transformations like Source qualifier, Filter, Aggregator, Expression, Sequence generator, Router and Update strategy
• Used Datastage Designer to develop parallel jobs for extracting, transforming, integrating and loading data into corporate Data warehouse - Database DB2, Oracle, Sybase
• Used Datastage Director and its run-time engine to schedule the job and debugging its components, and monitoring the resulting executable versions
• Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements
• Reviewed Business Requirement documents, Design Documents to determine the functionality of the application
• Extensively participated in development phase meetings for business analysis and attended both business / functional requirement document walkthrough
• Prepared Test plan, Test strategy, Run plan and Effort estimation according to the business requirements for tiny, small, large projects
• Provided walkthrough of new requirements and ensured the team understands the same and proceeded further
• Conducted internal Test scenario, test condition and test cases review to ensure the test coverage against requirements
• Prepared Test data based on the test scenarios by using Boundary-value analysis and Equivalence partitioning techniques
• Prepared Run plan, Traceability matrix documents, Day Zero checklists
• Published various status reports like daily, weekly, Monthly and closure report using PeopleSoft
• Performed sanity testing, interacted with various application teams for connectivity testing to ensure the system readiness to kick start testing
• Regular follow-up on testing progress and defect management in HP ALM
• Experienced in Bulk loading process for non ODS countries, loading the files from different TP systems into database
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL for data integrity
• Experienced coordinating Black box testing of the application including Functional testing, Regression testing, System Integration testing, UAT testing and GUI testing
• Coordinated with users in UAT, prepared test scripts, test data, published UAT status report, conducted UAT defect status call
• Gathered new requirements from users on time of UAT, raising CR for the new requirements and followed up till the closure
• Supported all phases of the project development such as UT, ST, SIT, UAT and production support
• Delivered the activities on time, bug free and with high quality also with excellent customer service skills

Confidential

Senior Test Analyst

Responsibilities:

• Analyzed Business requirements, Functional specification document and developed Test scenarios, test conditions and test cases accordingly
• Prepared Test data based on the Test scenarios using equivalence partitioning and boundary value analysis techniques
• Performed sanity testing and coordination with application team for connectivity testing to ensure the system readiness
• Extensively worked in Black box testing including Functional, System Integration, Regression and User Acceptance testing
• Expertise in defect management using HP Quality center for bug reporting, tracking and closure and presenting defect status report, conduct defect status call till the project closure
• Expertise in Bulk loading process for non ODS countries, loading the files from different TP systems into BL database
• Performed database testing to verify backend database transactions and wrote complex queries to compare the counts and data from source to target
• Participated in week end review meetings and reported the status to manager
• Coordinated user acceptance testing activities with users for both offshore and onshore
• Prepared user test scripts for UAT based on business requirements
• Prepared UAT test data requirement and verified the data on basis of user requirement
• Published reports and defect status of UAT on a daily and weekly basis till project sign off
• Used Agile testing methodology for achieving deadlines in UAT testing
• Provided knowledge transfer about the application flow, guiding other host navigation to validate the data against application to end users
• Gathered new requirements on time of UAT from users, raised CR for the new requirements and follow up with other teams till closure
• Got appreciation from business and stake holders for UAT coordination