Sql Server Software Development

Profile Summary

** ***** ** ********** ** Manual Tester and ETL developer with ample knowledge of Data Warehouse project life cycle. Experience with Agile software development practices. Quick learner, excellent analytical, design and problem-solving skills. Good exposure to Oracle, SQL Server. Interested in learning new skills for efficient and quality product development and project accomplishment. Demonstrated the ability to work effectively as team player and team leader in the company. Worked independently to achieve organisational objectives and initiatives at client site in London, United Kingdom

Organizational Experience

Millennium Software QA – Nov 2023 to Mar 2024

Kore. Ai, Inc QA – Sep 2022 to Apr 2023

NTT DATA Bangalore Team Lead – Oct 2010 to Feb 2016

Cognizant Technology Programmer Analyst – May 2007 to Oct 2010.

Solutions India Pvt. Ltd

Education

Master of Computer Applications Birla Institute of Technology (BIT Mesra) June 2007

Technical Skills

Issue Tracker Tool : JIRA, HP Quality Centre

Language : Java, SQL

Test Tools : AccelQ, MTM

DW Tools : Informatica, BODS

Databases : Oracle 9i, Oracle 10g, SQL server 2008

OS : Windows, Unix

Configuration Management : SVN

Professional Experience

Project name: Delaware Cerberus Application

Client: Deloitte

Duration: Nov 2023 to Mar 2024

Project Description: Testing for the SailPoint SSO and Cerberus

As part of the Cerberus project, Delaware Health and Social Services was implementing an Enterprise Identity and Access Management (IAM) solution, to provide modern IAM capabilities to various internal and external users that access DHSS applications and systems. It will replace several legacy systems including Oracle IAM, Ephemeral Identity Management System (EIMS), Enterprise Identity Management System (EIAM), Integrated Authorization System (IAS) and DHSS Access Request application. The Cerberus platform consists of the following Commercial Off the Shelf (COTS) solution components from SailPoint and ForgeRock product vendors:

· SailPoint – Identity IQ (IIQ) and Active Directory (AD) IQ Service

· ForgeRock Access Management (AM)

· ForgeRock Identity Gateway (IG)

· ForgeRock Directory Services (DS)

These solution components integrate with several DHSS systems and applications, including:

· APPS AD Domains (PROD/TEST/DEV)

· My Account Application (MAA)

· PHRST Batch Process (Note: PHRST Batch provides user profile attributes from PHRST to APPS AD via MAA, but there is not direct integration planned between Cerberus and PHRST Batch during the initial release)

· Business Applications, including ASSIST and other DHSS applications

The applications were integrated with the ForgeRock and SSO application to provide the following capabilities:

1. Login

2. MFA

3. Session Management

4. Single Sign On (SSO)

5. Role Based Access/Page Level Security

The list below provides a summary of the capabilities provided by the Cerberus platform.

1.Worker User Self Service:

· View Profile (Self)

· Change Password – SailPoint

· Change Password - SSO App

· Forgot Password

· Password Expiry

· View Request Status (Self)

2.Worker User – Provisioning

· APPS AD Connector – SLA*

· APPS AD – Account Creation in SailPoint (after aggregation) *

· APPS AD Connector - Account Update in SailPoint (after aggregation) *

· APPS AD Connector - Account Delete in SailPoint (after aggregation) *

3.Worker User – Access Management

· Login

· MFA

· Session Management

· Single Sign On (SSO)

· Role Based Access/Page Level Security

Active Directory Lock/Unlock Account

4.Worker User - Batch Process

· Disable Inactive Users

· Disable User Account on Expiry

· End Date Reminder

· Inactive User Reminder

Password Expiration Warning

5.Worker User – Administration

· Create User

· View Profile (Admin)

· Enable/Disable User Account (Supervisor)

· Enable/Disable User Account (IRM Security Admin)

· Unlock User Account

· Reset Account Password

· Revoke Access

· Update Profile (Admin)

· Transfer

6.Worker User – Add/Remove Access and Roles

· Manage Access and Roles Task Submission

· Add/Remove Access and Roles - Approvals

· Add/Remove Access and Roles - Provisioner Work Items

· Add/Remove Access and Roles - Cerberus Role Assignment

· VIP Substitution

· L2 Escalation

· Pending Task Reminders (Supervisor)

· Pending Task Reminders (Data Guardian)

· Pending Task Reminders (Provisioner)

· App List and Roles Management (Admin)

· Data Guardian App Assignment (Admin)

· Data Guardian Workgroup Management

Responsibilities:

Preparation of Master Test Plan, Test Design Documents, Test Cases and Test Completion Report.

Involved in the System Test Execution Phase.

Acquired knowledge on MTM testing tool.

Wrote multiple test cases for testing the functionality and executed them.

Raised defects for tracking the bugs in the system.

Involved in the preparation of integration/regression test cases and ramping up new resources.

Performed smoke testing on multiple applications for every deployment.

Coordinating with team to help them understand the exact business need for any problems.

Tested the functionality of the system thoroughly to see if it works as expected.

Reviewing the Test Designs and Test Cases prepared by team members.

Worked on testing different applications websites used by Delaware state government for Cash, Food, Medicare benefits for proper functionality.

Managing and reporting testing status to the client in meetings.

Professional Experience

Project name: Frontier Chatbot

Client: Frontier Communications

Duration: Sep 2022 to Apr 2023

Project Description: Testing for the chatbot developed for Frontier communications

Frontier communications has a chatbot implemented to meet the needs of customers. I worked as an onshore manual tester for the testing of this chatbot developed by the Kore. Ai developers. Along with the chatbot I worked on testing the internal product of Kore.AI (Smart Assist) which is being used by the live agents of Frontier Communication to interact with the customers.

Responsibilities:

Coordinated with the client to understand the requirement since the start of the project.

Acquired knowledge on the product developed by Kore.AI which can be used by agents to chat with the customers.

Gave demo multiple times to the explain the functionality of the product to the business.

Gathered the requirements for the chatbot development from the client.

Cooperated with developers for the creation of test cases and maintaining ownership of test results throughout SDLC.

Understanding the business requirements and reviewing solution implementation in application.

Analyzing issues in context of requirements and writing detailed bug reports.

Used JIRA for test case management and bug reporting.

Used AccelQ to upload the manual test cases and manage the project testing lifecycle.

Involved in the preparation of integration/regression test cases and ramping up new resources.

Creation of structured documentation for all end-user requirements during the liaison between the client and development team.

Subject matter expert resource for testing production issues.

Interacting with client site BA’s and Architects to identify the business-critical test scenarios.

Coordinating with team to help them understand the exact business need of any problems.

Managing and reporting project status to the client in project board meetings.

Providing technical assistance to client during UAT and post production.

Preparation of Master Test Plan, Test Design Documents, Test Cases and Test Completion Report.

Involved in the System Test Execution Phase.

Reviewing the Test Designs and Test Cases prepared by team members

Professional Experience

Project name: Kiln Insurance

Client: Kiln Insurance

Duration: Oct 2011 to Jan 2016

Project Description: Manual Testing of the major applications for Kiln Insurance

Kiln is the leading insurance provider in the UK market. The system has these major applications: Forecasting, Binders and FReD, Claims Management System, Actuarial Data mart, Catastrophe Risk Modelling. These applications support the client for their business. Forecasting is the system where underwriters enter their business through the portal. The requirements of these applications are to provide the reports of monetary movements of their business.

Responsibilities:

Cooperated with developers for the creation of test cases and maintaining ownership of test results throughout SDLC.

Analyzing issues in context of requirements and writing detailed bug reports.

Use of JIRA for test case management and bug reporting.

Involved in the preparation of integration/regression test cases and ramping up new resources.

Creation of structured documentation for all end-user requirements during the liaison between the client and development team.

Subject matter expert resource for Estimations, resolving production issues.

Understanding the business requirements and reviewing solution implementation in application.

Interacting with client site BA’s and Architects to identify the business-critical test scenarios.

Coordinating with team to help them understand the exact business need of any problems.

Managing and reporting project status to the client in project board meetings.

Providing technical assistance to client during UAT and post production.

Preparation of Master Test Plan, Test Design Documents, Test Cases and Test Completion Report.

Involved in the System Test Execution Phase.

Reviewing the Test Designs and Test Cases prepared by team members

Prepared various templates to test the ETL data migration from one system to another.

Project name: IRB Development and Testing Support

Client: Cricket Communications

Duration: May 2011 to October 2011

Project Description: Manual testing for the IRB application

This project involved the validation and maintenance of the data as per business rules. This is to maintain the changed billing system for Cricket Communications.

The billing system contains various subject areas; Subscriber, Phone, Work Order and Point of Sale etc. The Business Intelligence system consumes the EDW data to generate reports for decision making. So the testing was involved to validate the data.

Responsibilities:

Played a Role of Data Warehouse Tester/DB Tester

Responsible for testing the functionality

Understanding the requirement and writing/executing test cases

Reporting bug in bug tracking tool.

Testing the migration data from source to target system

Report defects found during test cycles and retest fixed defects and update in tool.

Project Name: Sigma Aldrich Data Migration

Client: Sigma Aldrich

Duration: Oct 2010 to April 2011

Project Description: Data Migration from SAP 4.6 PRD and SAP 4.7 PRE into new SAP ECC

Migrate full Data from SAP 4.6 (PRD) and SAP 4.7 (PRE) into new SAP ECC EHP6 systems for 16 plants using SAP Business Objects Data Services 4.1 toolsets for the following Master data objects:

Material Master: MARA, MAKT, MARC, MARM, MARD, MVKE

Bill of Material - STZU, MAST, STKO, STOP, CUKB

Purchasing Info record - EINA, EINE,

Source List- EORD

Master Recipe - PLKO, MAPL, PLPO, PLMZ

SD Pricing – KOMG, KONH, KONP, KONM, KNOW

Inspection Plans – PLKO, PLKO / E B119, MAPL, PLPO

Inspection Methods – QMTB, QMTT, QMTB

Master Inspection Characteristics - QPMK, QPMZ, QPMT

Material QM Inspection type - QMAT

Responsibilities:

As a module developer responsible for the following:

Set up a new repository which includes creation and configuration of the repository, attaching it to a database, attaching the user and its repository to CMC and job server.

Establish the data store connections.

Pull the data from the SAP source, apply all the business rules and process the modified data through IDOC to load it into the target systems.

Test the data and validate it as per the rules and Idoc processing in SAP system.

Project name: Enterprise Sales Commission System

Client: Wellpoint

Duration: July 2007 to September 2010

Project Description: ESCS system is used for loading data from various inbound interfaces to True Comp staging area and develops custom reports

ESCS system is used for loading data from various inbound interfaces to True Comp staging area and develops custom reports. The loaded transactions have to meet all the business rules supplied by the client & Callidus. True Comp is a product of Callidus which helps compensation analysts and brings a high degree of flexibility, scalability and adaptability to the variable compensation management process. The True Comp tables are further used for calculation of bonus and doing payments to various agents who are involved in working across all lines of business of health care units. The software streamlines the modelling, design, reporting and analysis of incentive compensation programs.

Responsibilities:

Analysing High level design documents

Updating Requirement Traceability Matrix

Preparing Detail Design deliverables

Worked on processing relational database, flat file formats and handling CSV files with multiple delimiters

Understanding the requirements, S-T mapping and preparing technical design documents

Extensively used ETL Mappings, Mapplets, Workflows, Worklets, various transformations like Filter, Sorter, Aggregator, Lookup, Expression, Filters, Router, Update Strategy, Joiner, Normalizer etc.

Handled slowly changing dimensions to maintain historical as well as incremental data using Type I, Type II and Type III strategies.

Worked closely with Onshore and offshore application development leads

Identifying efficiencies and ways to improve design and development processes

Preparing test cases

Fixing Release defects

Contact this candidate