SUMMARY

• Having total 17+It experience and 8+ years of experience in the field of Quality Assurance with expertise in the areas of ETL Testing, Manual Testing, Database Testing, API testing, Performance Testing and Integration Testing.
• 9 years of experience skilled Oracle professional with experience in complete Software Development Life Cycle and agile methodologies of complex systems in the domains of Telecommunications, Government, Manufacturing and inventory aspects, Purchase Ordering, Sales Analysis and Service Maintenance Systems, Healthcare and finance.
• Specialized experience in Software Quality Assurance using Manual and Automation Test Procedures and Methodologies in multiple environments.
• Expertise in Software Development Life Cycle processes Waterfall, Agile, SCRUM, Iterative and Test - Driven Development.
• Well versed with the Documentation Test Strategy, Test Plan, Analyzing Test Results and generating Defect Reports and Metrics preparation such as Test Effectiveness, Defect Leakage and Requirement stability Index.
• Strong abilities in software testing involving setting up of test environment, creation of test scripts/ cases, execution of Grey-box, Black-box testing including Smoke, functional, regression, System Integration Testing, Security testing, Graphic User Interface, End-to-End Testing, compatibility, web services, database testing and tracking of defects using various tools.
• Expertise in using and maintaining TestDirector, JIRA, ALM as test management systems.
• Experience in Erwin / Dimensional Data Modeling, Logical Database Administration and Stored Procedure Application development using Oracle SQL, PL/SQL.
• Proficiency in quantitative data analysis and developing statistical models.
• Strong relational and dimensional data modelling and database design skills, application design and Process engineering experience.
• Experience in designing and developing Informatica ETL Jobs/Mappings/Workflows.
• Experience in mapping source system data to data warehouse models and data mining and an in-depth knowledge of Data Science techniques.
• Collected, cleansed and provided modeling and analyses of structured and unstructured data used for major business initiatives using Data Mining and Data Modeling techniques.
• Strong experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Extensive experience in designing and developing applications to manage the databases through Oracle PL/SQL back-ends.
• Excellent knowledge on UNIX shell scripts having developed generic loaders and extractors for healthcare providers.
• Experience being part of requirement gathering and functional design team.
• Extensively worked on Normalization concepts while designing data models.
• Modified and maintained PL/SQL packages, PRO*C programs, created/updated scripts, and performed Logical Database administration duties.
• Proficiency in back-end database testing using Oracle.
• Worked as PL/SQL Application Developer developing Data Migration solutions.
• Extensive experience on Siebel data operations - data loads, automation and provided Tier II support for pharmaceutical application by troubleshooting work orders, severity incidence resolution, performing change control activities.
• Experience in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.
• Strong communication skills with experience in client liaison and managing the onsite/offshore teams for project delivery and have worked with interdisciplinary business teams and can thrive in a constantly changing environment.

PROFESSIONAL EXPERIENCE

Confidential

Test Lead

Responsibilities:

• Analyzed software design specification and understanding the configuration of Account assignment and Quota model in Anaplan.
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Organized data to create models that depicts trends in the customer base to improve forecasting activities.
• Involved in test coverage, test case development, test case review and tracked the defects in JIRA.
• Took complete ownership of all the assigned User Stories and raised appropriate defects wherever and whenever necessary and ensured that each User Story meets the Acceptance Criteria.
• Involved in daily scrum meeting with Product Owner, Business Analyst and Development model building team.
• Periodically reported status to the client particularly Confidential escalation and resolution points and ensures that the client is satisfied with the implemented resolution.
• Ensured all the planned test cases have been executed on schedule with quality and all the reported defects are getting resolved as per release criteria.
• Discussed all the User Stories with the Twelve team model builders and ensured the validation and verification was performed by the QA based on the design and build criteria.
• Participated in the Quota Anaplan User Acceptance testing.
• Documented all the test cases with details of execution steps capturing screenshots of dashboards for every modules and line items for role-based security testing.
• Performed extensive ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from different sources.
• Extensive SQL querying on Staging, Data warehouse and Data Marts
• Created test cases for ETL mappings and design documents for production support and tested a number of complex mapplets and reusable transformations for daily data loads.
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).

Confidential, BREA, California

Sr.Quality Assurance Engineer

Responsibilities:

• Responsible for handling project management activities which include project planning, design, scope management, cost, quality, time, stakeholder management, risk management, develop periodic reports and resourcing
• Responsible for managing offshore resources effectively to deliver optimal efficiency.
• Arranging periodic review meetings and develop progress report for effective monitoring.
• Developed innovative solutions to complex business and technology problems.
• Shaped business decisions by performing research, analytics and statistical analysis on various metrics/business cases.
• Engaged with Data Architects, Developers and Business Analysts to understand business logic and data access paths
• Extracted, compiled and tracked data and analyzed data to generate reports.
• Developed, reviewed and updated manual test scripts using ALM / Quality Center / JIRA / Enterprise Tester.
• Developed, reviewed and updated manual test scripts using JIRA.
• Created automation test scripts to test all end-to-end components -- legacy mainframe, Web and upgrade.
• Extensively executed Confidential -SQL queries in order to view successful transactions of data and for validating data in SQL Server Database. Created Test Cases and filled on Clear Quest and Quality Center ALM 11.5.
• Developed Test Scripts to implement Test Cases, Test Scenarios, and features for BDD (Behavior Driven Development), TDD (Test Driven Development) using Cucumber .
• Worked with customers to schedule, prepare and conduct successful UAT sessions with appropriate audience(s) utilizing the UAT test plan.
• Created and executed Test Cases for Functional, System, Integration and UAT Testing with VSTS.
• Created manual test cases in Excel sheets and imported to Quality Center regularly.
• Performed Manual, Automation and Performance Testing on Web Client.
• Performed ETL and Database testing, wrote complex SQL queries, for Data Profiling, Data validation, Source-2-Target Mapping applying transformation rules and BI Report Testing.
• Actively involved in functional, unit and integration testing in Agile methodology.
• Responsible for providing Risk Assessments, test Plans, test cases and executing and creating Test Results them within an AGILE software development SCRUM environment.
• Developed and supported quality assurance processes throughout the project life cycle.
• Created numerous simple to complex queries involving self joins, sub queries and scripting.
• Created email notification of workflow failures and used linking conditions to direct the workflow and build dependency.
• Tuned and optimized mapping and queries by altering database design, analyzing different query options and indexing strategies to handle millions of transactions.
• Performance tuning Confidential each level from creation of database to query modification using explain plan to gathering statistics of the environment including tables and schemas.
• Investigated and identified defects on application level before product release.

Confidential, Boston, MA

Test Director

Responsibilities:

• Responsible for development for the extraction, transformation & loading of IDR data into IDM using Oracle PL/SQL packages.
• Responsible for Customizing IDM Job Loaders and Schedules.
• Responsible for monitoring daily and monthly data loading processes into the application and to finetune the functionality of these jobs to increase the performance.
• Responsible for requirement gathering and functional design in the team during every release.
• Responsible for execution of jobs during their failures after debugging the log files.
• Sole point of contact to the client for all customer care activities by resolving calls raised by end-users and represent Confidential the client site.
• Worked with business analysts to determine source of system and development errors and determine solutions.
• Developed tests to validate the application Confidential different levels like functional, system, performance and load.
• Implementation of Change requests management logging change control requests.
• Involved in Upgradation and Maintenance of the existing system.
• Performed back end test executing SQL queries to ensure data integrity and check the data flow from its source to the back end.
• Developed SQL scripts for verification of data Confidential extraction phase, transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules
• Used TestDirector to track, analyze and document defects.

Confidential, Thousand Oaks, CA

Responsibilities:

• Design of Dimension Model, which suits the analytical reporting requirements of Business Users that includes the logical design of data model and physical data model using ERWIN.
• Responsible for the ETL design & development for the extraction, transformation & loading of CRM data into Datawarehouse/Datamarts using Informatica.
• Responsible for daily and monthly data loading processes into the application and to finetune the functionality of these jobs to increase the performance.
• Responsible for requirement gathering and functional design in the team during every release.
• Responsible for development of PL/SQL Procedure by populating EIM Tables as per requirement, configuration of if files, and monitoring the EIM process and loading the Base Tables.
• Responsible for EIM Data mapping and writing an if file.
• Responsible for execution of EIM Server Task and debugging the log files.
• Sole point of contact to the client for all customer care activities by resolving calls raised by end-users and represent Confidential the client site.
• Implementation of Change requests from data management.
• Impact analysis on Orion application with respect to data due to various UI changes.
• To participate in activities involved during Orion release.
• Involved in Upgradation and Maintenance of the existing system.
• Responsible for pre-populating data to execute data flux jobs.
• Generate weekly reports for Data Management.

Confidential, Boston, MA

Responsibilities:

• Reviewed source systems and proposed data acquisition strategy.
• Extensively used Erwin tool in forward and reverse engineering, following the corporate standards in naming conventions.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Developed procedures to supply default data when there is an absence of migration data.
• Created test cases for end users.
• Developed SQL queries for Tax Registration,TJ report,State GSC Matrix and related reports.

Confidential

Responsibilities:

• Logical database management for offshore team responsible for data modeling, database tuning, incremental data feeds and user support.
• Development of data migration procedures, fine tuning of SQL queries, maintenance of database scripts base lining for each release.
• Responsible for creation of packages, triggers and test data creation scripts for data validation.
• Involved in writing SQL queries for developers based on use case.

Confidential

Responsibilities:

• To lead DDMS Enhancement activities and also partake in production support activities.
• To design and implement the solution for DDMS loaders and extractors and act as a liaison between client and Confidential .
• To Design and Develop generic loaders and extractors for all new development activities to be used as reusable components especially
• Xponent hospital rollouts and Pharmatrend rollouts using PL/SQL and shell scripts.
• Responsible for analysis of requirements, Preparation of Software Requirement Specifications
• Preparation of design specifications and to write database triggers and PL/SQL programs from specifications
• Extensively used Informatica Workflow Manager to run the workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Tested the ETL Informatica mappings and other ETL Processes
• Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
• Responsible for code reviews, walk-throughs.
• Production deployment and Production testing.

Confidential

Responsibilities:

• Logical database management for offshore team.
• Involved in environmental setup for Confidential reports (using the Oracle Application Server) for the client.
• Used ER Model Diagram to understand and analyze tables and its relations present in Confidential Server which serves as a source for the project.

Confidential

Responsibilities:

• Responsible for Design and Development of Reports, Review, Unit Testing, Module testing, Planning the development phase of the module
• Metrics Collection and Analysis, Defect Analysis (Using various Statistical Control Techniques), coordinating with other branches.
• Involved in User Acceptance Testing ( Confidential ), System Testing, Integration Testing and implementation of the audit module

Confidential, Cincinnati, OHIO

Responsibilities:

• Responsible to design and modify new / existing tables.
• To assist developers, construct proper SQL queries to access database efficiently.
• To Design, develop and test Stored Procedures/Functions/Packages using PL/SQL.

Confidential

Responsibilities:

• Analysis of Focus reports.
• Preparation of specifications and Review of specification.
• Development of BO report, Review and testing of BO report.
• Assisted in the design of Business Object Universe.