PROFESSIONAL SUMMARY:

• Over 12 years of work experience in IT in Data warehousing/ Business Intelligence and Quality Assurance. BI Developer with 5 plus years of experience developing Data visualization solutions, Data Models, data quality, analytics, dashboarding, and reporting.
• Technically proficient in Tableau platform, SQL, SQL Server, Oracle.
• Experience coding and modifying SQL/ETL/Alteryx based on dashboard requirements in Tableau Designing and developing data source, dashboards in Tableau.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Extensive experience in managing business requirements gathering, analysis, design and implement business systems projects in Financial, Mortgage and Logistics domain applications.
• Experience with data Quality, integrity, Data format and Quality checks.
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Extensively using joints and sub - queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
• Advanced in Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.
• Developed Tableau dashboards using complex relational and multi-dimensional data sources like Teradata.
• Analytics experience with forecasting methods, reporting packages and looking for trends.
• Analysis experience such as pulling data together from various sources, looking for Confidential ways to analyze, looking for trends in data and writing use cases.
• Exposed to all phases of Software Development Life Cycle. Involved with teams in requirements gathering, analysis, design, development, testing, implementation and maintenance
• Experience in implementing SDLC methodologies including Waterfall Model, Agile methodology and Enterprise decision methodology (EDM).
• Expert level skills in Implementation and Testing of Enterprise Data Warehouses using Informatica Power Center 9.6/9.1/7.1.3/6.1 ETL tool.
• Expert in writing SQL queries and optimizing the queries in Oracles Server 2008 and Netezza.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and data warehouse.
• Excellent analytical, technical skills, problem solving, customer relationship management and team building skills.
• Solid experience working on business process design, data warehouse life cycle and business intelligence related projects.
• Extensive experience in define stakeholder requirements, technical specifications, mapping document of data movement.
• Experience in working with Multiple Relational Databases like Oracle 12i/9i/8i/7.x, Aginity SQL Server 2000, MS Access, XML and Flat Files.
• Work individually, as well as in team environment to achieve project quality goals. Well experienced to handle complex situation and time critical schedules, Excellent communication skill and ability to speak with different development group and clients.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6/9.1/8.5/7.1.2/7.1.3 , Informatica Data replication (IDR), MDM,Golden gate

Data Management: Oracle12.5/10g/9i/8i/7.x, DB2, TOAD, SQL, PL/SQL, Netezza, Aginity, MS SQL Server

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.

Bug Tracking Tool: JIRA, HP ALM, Clear Quest, Test Director, Quality Center and PVCS Tracker.

Testing Tools: HP ALM, Quick Test Pro 9.0/10.0, Win Runner, Rational Clear Case, Rational Test Manager HP Quality Center

Automation Tool: UFT,Selenium, Cucumber, Ruby, Jenkin, GIT

Project Management: Agile, waterfall, Jira

Web Technologies: HTML/DHTML, XML, Perl, JSP, ASP, Java Script, VB Script

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

PROFESSIONAL EXPERIENCE:

Tableau Developer

Confidential, Reston, VA

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 Confidential 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.

Confidential

Tableau Developer, Mc Lean, VA

Responsibilities:

• Analyze business requirements and data sources from Excel, Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Create views in Tableau Desktop that are published to internal team for review and further data analysis and customization using filters and actions.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and SSRS.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Improved performance of the dashboard at report level, by reducing the scope of the visualization with respect to sheet and data sources, reducing number of filters in the view, creating efficient calculations.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Experience in designing various Data Visualization Dashboards, gathering customer requirements, writing test cases, preparing analytical reports to help users to identify critical KPI's and partnering with developers to ensure full understanding of internal/external customer needs.
• Extensive experience as Tableau Admin in installation, Migration, configuration, Patching and upgrading of Tableau tool across all environments.
• Secured Tableau Server by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Proficient in analysis, preparing Business specifications, implementation, designing, developing reports and performance tuning.
• Experience in creating the extracts in Tableau from various source files including flat files, excel sheets, Access files and different databases.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices

Confidential, Sterling, VA

Sr. QA Analyst

Responsibilities:

• Reviewed requirements for testability and usability, consulted development team with regards to system functionality.
• Extensively involved in Backend Testing.
• Performed Backend Testing with SQL commands on Database with TOAD 8.5.1 and verified/validated the test results
• Involved in Positive Testing, Negative and End-to-End Testing.
• Extensively involved in Data and Format Validations prior to data upload for claims processing.
• Involved in Testing Methodologies which included Black Box, Functional, System, Regression and User Acceptance Testing.
• Involved in preparing Test Plan, Test Scripts and Test Cases based on the Functional Requirements and Business Rules and prepared test results after every test and Regression Test Cycle.
• Involved in Web Services testing of the application after the application was tested by the functional testing
• Involved in testing the Contract Creation Process in Oracle Applications- Service Contracts Module.
• Tested the Payments Lifecycle for the claims submitted in Oracle Applications- Accounts Payables Module.
• Involved in testing of the Upgrade Instance from Oracle 11.5.6 to 11.5.10.
• Involved in testing the Adjudication Rules for the claims submitted by the service centers.
• Tested the claims data format before loading into Oracle by B2B workbench.
• Wrote SQL Queries to test Data validations and Consistency using TOAD.
• Involved in the entire Life Cycle of QA Methodologies starting from Planning, Capturing, Creating, and Executing, Reporting and Tracking the defects.
• Documented bugs with evidence and reported them with detailed information to the development team.
• Coordinated with developers to fix the problem and enhancing the application.
• User- Acceptance Test (UAT) with 100 % compliance and all end-to-end test specifications.

Confidential, Secaucus, NJ

Sr. QA Analyst

Responsibilities:

• Responsible for planning activities, creating test plan, requirements Traceability Matrix and standard templates (Daily status, defect status, defect process etc.)
• Analyze the requirement documents and creating test cases to cover all the possible scenarios
• Perform white box testing on the Informatica code that developers built and validate that against the system requirement documents
• Validate the ETL mappings and developed SQL queries for Big data to validate the data from the source to the target tables.
• Developed end to end SQL queries to validate huge volumes of data and validate all possible joins and lookups in system test environment
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation and actual ETL functionality
• Extensive use of UNIX commands to move source files (XML and txt) and trigger files to ETL QA server.
• Using workflow manager to edit, validate and run workflows, worklets and tasks.
• Using workflow monitor to monitor the status of workflows and sessions.
• Test Aggregator, Sorter, Router, Filter, Joiner, Expression, Lookup and Update Strategy, Union, Sequence Generator transformations in Informatica
• Extensively worked with large number of complex transformations to validate marts and facts tables.
• Querying data from different database tables as per the requirement and executing the source queries from workflows.
• Using PL/SQL developer for generating SQL queries for checking the Data Transactions and Database Integrity
• Perform UAT testing to verify that user requirements are met.
• Responsible for verifying the session logs for all IDR workflow sessions and report issues to the developers.

Confidential, Reston, VA

Quality Assurance Tester

Responsibilities:

• Created test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Review the requirements and prepare requirements documents based on review sessions.
• Perform test data set-up for testing and update changes based on the requirements.
• Create Confidential build and database backups. Create and maintain test environment.
• Responsible for writing Test plans, Test scenarios and Test cases based on business and functional requirements.
• Creating test case and test sets, tracing them to requirements and executing them in Mercury Quality center.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Test Director.
• Performed black box testing by designing and constructing test cases, test data and test execution.
• Verified defects and Perform database functional, integration and regression testing as needed to minimize defects.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Executed test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
• Performed database validation by comparing the source to the target.
• Responsible for the requirements: ETL Analysis, ETL Testing and designing of the flow and logic for the Data warehouse project
• Created and executed SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure successful transformation.

Confidential

Jr. Test Engineer

Responsibilities:

• Thorough Testing of the Application using Manual Approach.
• Developing, documenting, executing and verifying “black-box” test cases.
• Performed business functionality testing and GUI testing.
• Analyze business requirements, creation of test plans and project documentation to create test scripts.
• Develop and execute test scenarios, test cases based on Business Requirements.
• Developed the Test Cases based on Use cases and functional Specifications.
• Involved in Front End, Back End, Integration testing, System testing and UAT Testing by combining the code modules, individual applications.
• Performed Regression testing and end-to-end testing of overall application to ensure end-to-end usability.
• Create and document test cases and manage tasks for performance testing of business applications
• Responsible for Functionality testing, Integration testing and Regression testing.
• Performance testing for transaction time taken for a set of simultaneous connected users at a transaction point.
• Functionality Test of Role based activities