SUMMARY:

• Over 8+ years of IT experience in software Analysis, Design, and Development in fields of Databases, Business Intelligence, Client Server Technologies and Web - based applications.
• Extensive Tableau Experience of Enterprise Environment, in Tableau 10.1/ 9.x/8.x/7.x as a Developer and Admin.
• Expert in Data Visualization development using Tableau to create complex, instinctive, and imaginative dashboards.
• Proficient in all periods of the Report improvement lifecycle, including necessities get-together, Design, Development, System Testing and User Acceptance & Support.
• Designed visualizations of new high-impact visual applications to make data actionable and facilitate decision making for the clients
• Working with product teams to provide subject matter expertise throughout the production implementation of visually oriented products and applications.
• Proven capacity to deliver and guarantee achievement in high-weight/high-hazard circumstances.
• Defined best practices for Tableau report development.
• Good comprehension of ideas for example, Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact & Dimensional Tables.
• Involved in making dashboards and reports in Tableau 8.2, 9.3 & 10.4 Made report plans on
• Tableau server.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 9 desktop/Server.
• Created modified reports utilizing different diagram sorts like content tables, bar, pie, Heat maps, line graphs, Area outlines, disseminate plot, double mixes diagrams in Tableau.
• Designed Tableau Data Extracts for improving visualizations perform better.
• Strong learning and comprehension of SQL and capacity to write SQL queries.
• Knowledge in reporting the testing procedure using MS-Office instruments including MS-Word, MS-Excel, and MS-Project.
• In depth knowledge of Software Development Life Cycle (SDLC)
• Knowledge of Agile, Waterfall and Scrum methodologies of client's business Processes.
• Gathered business requirements from client and utilized UML (Unified Modeling Language) in which various diagrams such as Sequence, Flow chart, Activity, Class, Use cases and E-R diagrams are prepared.
• Excellent technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD) and Prototyping.
• Excellent business, communication, and presentation skills.
• Ability to work both independent and in team environment.
• Experience in academic counseling, teaching to students of high school and higher education. Experience in administration and management work.
• Worked on moving Tableau Dashboard from Development to Production Live Environment.
• Worked broadly with Advance Investigation Actions, Calculations, Parameters, Background pictures, Maps, Trend Lines, Statistics, and Log Axes. Groups, chains of command, sets to make point of interest level synopsis report and Dashboard using Tableau's Advanced Capabilities.
• Experienced with ETL tools like Informatica, SSIS, SSRS, SAS.
• Expertise in Tableau Desktop development, inconvenience shooting, report design, execution tuning, determining issues and distributed dashboards, exercise manuals in Tableau server
• Hands-on improvement helping clients in making and adjusting worksheets and information representation dashboards in Tableau.
• Specialist in planning Universes and creating complex and Ad hoc Reports utilizing the Business Objects Reporter/Desktop Intelligence and Web Intelligence Tools
• Expertly took care of information demonstrating (social, dimensional and star construction) and information recoveries utilizing Universes, Personal information records, put away systems and Freehand SQL methods.
• Extensive experience in modeling and developing logical/physical data models using entity relationship modeling tools like ERWIN
• Developed perspectives using advanced calculations like channels, Parameters, Actions, Table computations, Logical estimations, date figuring, and Trend Lines.
• Authorized to work in United States with sponsorship

TECHNICAL SKILLS:

Programming Language: JavaScript, T-SQL, C#, JAVA/J2EE, PL/SQL, SQL, JQuery

Data Visualization and Reporting: Tableau 8.x to 2018.1.2, Altreyx, Business Objects, Power BI Micro strategy, Tableau server, Integrating Tableau with R server.

Environment: Windows NT, 2000, XP, DOS, UNIX.

Databases: MySQL, NoSQL, Cassandra, Dynamo DB, Hive.

Testing Tools: HP ALM, Quick Test Pro 9.0/10.0, Win Runner, Rational Clear Case, Rational Test Manager HP Quality Center,UFT,Selenium, Cucumber, Ruby, Jenkins, GIT

Tools: and technologies: CVS, Git, Tortoise SVN, Microsoft Excel, Google PLX, Tableau.

PROFESSIONAL EXPERIENCE:

Quality Analyst/ Tableau Developer

Confidential, Sunnyvale, CA

Responsibilities:

• Conducted requirement gathering session to gather and understand the requirements of the business users.
• Conducted regular walk through with the client to identify the gaps and to get a clear understanding of the requirements and acceptance criteria (definition of done)
• Eliciting requirements, evaluating information gathered from multiple sources, reconcile conflicts and converting high level information into detailed level information.
• Working as liaison among stakeholders in order to analyze and design business process and system applications.
• Elaborated the user requirements by developing prototypes, wireframes and screen mockups.
• Analyzed business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.
• Worked as Tableau Server Administrator and Tableau desktop developer. Responsible for Preparing the Report Design specifications based on the User's requirement.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Implemented security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication
• Creating epics and user stories.
• Assisting IT teams comprising developers and testers in understanding the business requirements, definition of done and subsequent development.
• Providing UAT support to development team.
• Proficient in requirement analysis, requirement gathering, requirement elicitation, and in creating requirement & functional design documentation.
• Created Test plans & Script, Initial Test Plan and Developed Test Cases and test scripts manually.
• Used Microsoft Excel, JIRA to store all testing results, metrics, Test Cases, Reporting and to tracking them further.
• Tested the Application using Black box Testing Techniques.
• Created, Updated and Reviewed of Test cases and Test Scenarios.
• Prepared meeting notes on daily execution/highlight of the project and send out the keypoints to the team.
• Interact with Developers and Business Analysts to perform various types of testing throughout Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC)
• Mobile and tablet device testing.
• Involved in cross browsing testing of the application on various browsers to ensure it functions.
• Check the updated code of the applications weekly on Dropbox and Github.
• Manage the billing process of the projects: Upwork.
• Worked on Applications like: OPF (Oversize Pilot Finder), Phone Location Tracking (Tracking Application), To-Do List, Sellah (Online classified add application), Photography App, Motzaa, Therapist Application etc.
• Demonstrated ability to quickly understand business requirements and establish cordial relations with team members & positive working relationship with the clients and end users.
• Very well acquainted with the documentation and review process of the artifacts, Process maps, user manuals and functional documents.
• I have used Microsoft Visio for creating process flow / requirement flow diagrams, data flow diagrams, use cases, interface diagrams etc.
• I have experience of working on project which is getting executed using Agile methodology (Scrum) and also have experience of using JIRA.
• An innovative, result-orientated professional with strong analytical & interpersonal skills.
• An effective communicator with good planning, analytical & problem-solving skills.
• An efficient consultant who believes in team work & driving them towards the attainment of goal.
• Applied various types filters like Data source filters, Quick filters and Context Filters. Extracted data from various sources and performed data blending.
• Created Custom Admin Views for the server Using Postgre SQL Database to track detailed view of usage, user activity, server activity etc.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.
• Created Stories using Tableau as part of report presentations to Business.
• Created visualizations reports on sales quotas, attainments and performance on various categories to ascertain the overall sales effectives of each program.
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.
• Developed Tableau data visualization using Cross tabs, Heat Maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures.
• Created Dashboards with interactive views, trends and drill downs.
• Used excel sheet, flat files, CSV files to generated Tableau Ad-Hoc reports.
• Developed different Geographic visualizations using map box services
• Generated dashboards to compare the expected weekly ticket sales Vs projected sales used dual axis for comparison.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and experience with Level of Detail Expressions (LOD) for complex calculations to manipulate the data.
• Worked on dashboards using extracts in server.
• Performed Tableau Admin duties that comprised adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data. Scheduled data extracts daily.
• Resolved end user reporting problems through collaboration with IT and Operations.

Environment: Windows XP, Linux, Windows 7, Tableau, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB.

Tableau Developer /Quality Analyst

Confidential, Chicago, IL

Responsibilities:

• Interacted with business users for gathering requirements and look and feel of the applications to be developer.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards to compare the expected weekly registration and physician specific registrations used dual axis for comparison.
• Explains the Pros and Cons of the requirements to the team.
• Explained all the requirement and possible test scenarios to developer team in meeting.
• Prepared the Test Cases and analyze data.
• Works on Sanity Testing, Integration Testing, Usability Testing, System Testing etc..
• Logging the issues/Bug to Bug Tracker JIRA.
• Get them closed by Developers.
• Retesting and Regression testing of the new modules introduced.
• Demonstrate it to PM and get feedback/review.
• Get involved in User Acceptance testing. (Test as User)
• Analyze the data from Google Analytics and work on website to improve performance and introduce new stuff as a role of Quality analyst.
• Good Knowledge in Requirement analysis and transforming the same with Functionality development/changes to development team.
• Good experience in Manual Testing.
• Experienced in Verifying and Validating Web based applications.
• Good Exposure in Agile Methodology (SCRUM)
• Involved in Functional Testing, Integration Testing, Regression Testing, Compatibility Testing, Migration Testing and GUI Testing.
• Good Interpersonal skills and ability to work with team.
• Extensive experience in coordinating with development team for better performance, status reporting to management and issue escalations.
• Good Knowledge in SDLC and STLC with Test Reviews and coding Standards.
• In depth knowledge of various Software Development Lifecycle (SDLC) methodologies like Agile, Scrum, Water fall.
• Responsible for getting daily stand-ups, facilitated spring planning sessions and provided sprint commitment updates to project stakeholders/ business.
• Preparation of requirement documents such as Functional Requirement Specification (FRS), Scope of Work (SOW) documents and Sign Off Documents.
• Expert in creating wireframes using tool Balsamiq.
• Design Business process models using BPMN tool to express business process and information flows defined by stakeholders
• Experienced in interviewing key stakeholders and documenting business needs and system requirements.
• Managing and prioritizing the complete product backlogs.
• Proficient in creating Change Request (CR) documents.
• Experience in creating user stories using JIRA tool.
• Taking the complete ownership of product, from defining product vision to managing customer support.
• Analyzing market trends, consumer habits, competitor practices and making favourable recommendations for business optimization.
• Communicate project progress with client and stake holders through meetings, conference calls and discuss issues.
• Has proved to be a 'Go-To' person for assisting to solve technical problems and for client communications.
• Communicating with the technical team whenever they need any clarity during the project delivery process.
• Proficient in validating the response of APIs using Postman tool.
• Generated Dashboards by joining multiple complex tables.
• Prepared different views for Patient Registrations, Doctor Scheduling and Lab Tracking.
• Generated dashboard for Billing and Deposit Systems
• Provided security and user roles for all the users of the various modules
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations using Tableau to the senior management at the client as part of the BRD.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.

Environment: TableauDesktop10.4/9.3, Tableau server/Administrator, SQL developer, Impala SQL, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office and Java script.

Tableau Developer

Confidential, Seattle, WA

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions usingT-SQLto provide definition, structure and to maintain data efficiently.
• Played critical role in establishing Best practices for tableau Reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI's and developing POC Dashboards.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to created summary level and detailed Reports.
• Conducted Load and Performance Testing using TabJolt and resolved performance related issues on affected Tableau Reports.
• Connected Tableau server with SharePoint portal and setup auto refresh.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Managed Users on Unix/Linux and Windows systems.
• Develop reports using formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Good knowledge in developing and designing reports through SSRS and Excel.
• Strong experience with MS Excel, PowerPoint, Word and Visio.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7 production support for Tableau users.

Environment: Tableau 8/9, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, UNIX, Business Objects 3.1, Microsoft Excel.

Tableau Developer

Confidential, Atlanta, GA

Responsibilities:

• Perform Requirement Analysis to make sure those serves business goal and appropriate enough for developer to implement
• Work within the Portfolio Delivery Metrics team to design and develop, effective and useful dashboards for improved operation's and oversight of the Scaled Agile Framework rollout.
• Design and create innovative and valuable visualizations in Tableau to track KPI's, metrics and other key data points.
• Used different Data Migration Services and Schema Conversion Tool along with ETL tool.
• Used different custom housekeeping utilities and monitoring services to have the cluster running efficiently.
• Developed end to end SQL queries to validate huge volume of data and validate all possible joins and lookups for business requirement.
• Performed data analysis and data profiling using complex SQL on various sources systems through ETL process
• Build many Tableau reports using Bar Chart, side-by-side bars, stacked bars, maps, tree map, pie charts, line charts, interactive reports using Tableau Desktop and Dashboard.
• Evaluate existing reporting to identify opportunities to recreate in Tableau.
• Develop a solution/framework for provisioning data for consumption by business users who are looking to utilize Tableau.
• Responsible for data preparation, data blending, and the creation of data models / sets using Alteryx.
• Help to design and document guidelines for visualization development.
• Partner with other technical teams to in corporate data security within Tableau.
• Experience in Creating Tableau calculations, table calculations, LOD calculations, blending, actions, time period functions, parameters based on requirements
• Experience coding and modifying SQL/ETL/Alteryx based on dashboard requirements in Tableau Designing and developing data source, dashboards in Tableau
• Suggesting new Viz based on data and analysis
• Improving data processing speed by optimizing SQl and tableau viz.
• Experience and exposure on Data Warehousing and Big Data Ecosystems.
• Participate in visioning sessions and design reviews to develop wireframes.
• Support ad-hoc requests for visualization and dashboards.
• Perform other related duties as required by management.
• Expert in reconciliation of Data Movement between Source vs. Datamart & Business Objects reports
• Reviewed business/system requirements change requests and design specifications to identify gaps and ensure requirements/business rules are clear, consistent.
• Extensively involved in data replication thru Informatica data replication (IDR) from oracle to data warehouse.

Environment: SQL Developer, MS-SQL 2012 R2, MS-Access, MS Excel and JavaScript, Oracle, MS SQL Server. Windows XP, Tableau 8.

Data QA Analyst

Confidential

Responsibilities:

• Worked as ETL developer in development of an Enterprise Information Model
• Development of Informatica CDC between heterogeneous source & Target when staging data in Acquisition layer.
• Worked with Informatica Data Quality 9.6.1/10.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion
• Experience Working with Informatica Data Quality 10.1 transformations.
• Experience doing source analysis by Profiling using IDQ business analyst & building score cards to monitor refined data phases.
• Involved with Informatica team members in Designing, document and configure the Informatica IDQ suite to support loading, cleansing, matching, merging, and publication of DQM data.
• Performed match/merge and ran match rules to check the effectiveness of DQM process on data.
• Row profiling & column profiling by creating business rules on source tables using Informatica Business Analyst.
• Having experience in development, maintenance, support and enhancement inInformatica Power Center, Teradata, Informatica Data Quality (IDQ), Informatica Big Data Management (BDM), Oracle, Hadoop Hortonworks, Informatica Data Validation Option (DVO).
• Experience in implementing Data Quality rules on Hive Data sources using Informatica Big Data Edition 10.x
• Experience using Sqoop and Teradata connectors (TDCH) to export data into Hadoopfrom Teradata.
• Generating weekly score cards out of build profiles to monitor data health in Informatica Business Analyst.
• Development of UNIX shell scripts and for automation of ETL processes.
• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Follow the quality standards and guidelines for configuration management, testing, project planning and execution.
• Developed the test scripts using SQL for the unit testing.
• Extensively involved in Fine tuning the Informatica Code (mappings and Sessions), Stored Procedures and SQL queries to obtain optimal performance and throughput.

Environment: Informatica Power Center 9.6, Informatica IDQ 9.6/10.1, Informatica Business Analyst, Netezza SQLWin SCP.

Data/ Quality Analyst

Confidential

Responsibilities:

• Developed Tableau dashboards with various complex worksheets that help the market planners, regional executives take important decisions on branch transformations.
• Developed python script to load the Excel data to SQL tables as a ETL process.
• Worked on creating Python scripts to automate the Teradata scripts.
• Worked Extensively with Databases, Tableau and Azure.
• Use SQL (SSMS) to create stored procedures and interactive, parameterized reports (SSRS) to programmatically find cost savings based on healthcare contract configuration and sourcing for high-profile clients across several different industries.
• Developed Teradata scripts to update the data infrastructure that feeds the Tableau reports.
• Worked with SAS as an ET tool to extract and load the data into Teradata table from excel data sources.
• Developed and continuing to provide support to the most widely used data product "Micro Market Monitoring" which involves loading and extracting >1TB of data, creating complex reports which provides data analysis in every dimension.
• Gather all the requirements from the operations team.
• Prepared the SRS for the same accordingly.
• Worked with Designers to prepare the prototype for the same.
• Explained all the requirement and possible scenarios to developer team in meeting.
• Prepared the Test Cases and scenarios.
• Works on UI Testing, Functional Testing, Sanity Testing, Integration Testing, Usability Testing, System Testing etc.
• Logging the issues/Bug to Bug Tracker JIRA.
• Get them closed by Developers.
• Retesting and Regression testing of the new modules introduced.
• Demonstrate it to PM and get feedback/review.
• Get involved in User Acceptance testing. (Test as User)
• Performed Performance Tuning for Tableau refresh, which extracts close to 37 billion records.
• Performed testing for data products (Tableau reports and Teradata data infrastructure).
• Created user guide documentation for all the data products.
• Developed proof of concept to replicate the processes and reports using cloud technologies.
• Lead the data Correction and validation process by using data utilities to fix the mismatches between different shared business operating systems.
• Performed Data Quality and Data Modelling.
• Utilized Teradata SQL queries to collect and evaluate data elements from data providers to ensure quality of data and translate the data into reports for marketing department.
• Verifying data quality after every deployment and perform extensive analysis for the data variance pre and post implementation.
• Good knowledge and experience in Software Development Life Cycle (SDLC) and its phases: Requirement gathering, Analysis, Design, Implementing, Testing, Deployment, and Maintenance.
• Used various approaches of SDLC like Agile, RUP, and Waterfall
• Experience in design, development, testing, implementation and support of Enterprise Resource Planning (ERP) and Business Process Modelling Notation.
• Create Functional Specification Documents and Data Mapping Analysis for System Integrations.
• Supported upper level management with financial data analysis by developing data drill reports and Business Intelligence (BI) dashboards.
• Developed in MySQL database. Used Excel and MS Office suite for generating weekly and monthly presentations. Also acquired the data from primary, secondary data sources and maintained databases.
• Monitored performance and quality control plans to identify improvements.

Environment: Teradata, SQL Server, Oracle, Tableau, Python, SAS, ETL, Machine Learning Model, SSMS, SSRS, Agile.