| Candidate Information | | Title | Sql Server Software Development | | Target Location | US-TX-Irving |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateProfile Summary10 years of experience as 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 KingdomOrganizational ExperienceMillennium Software QA Nov 2023 to Mar 2024Kore. Ai, Inc QA Sep 2022 to Apr 2023NTT DATA Bangalore Team Lead Oct 2010 to Feb 2016Cognizant Technology Programmer Analyst May 2007 to Oct 2010.Solutions India Pvt. LtdEducationMaster of Computer Applications Birla Institute of Technology (BIT Mesra) June 2007Technical SkillsIssue Tracker Tool : JIRA, HP Quality CentreLanguage : Java, SQLTest Tools : AccelQ, MTMDW Tools : Informatica, BODSDatabases : Oracle 9i, Oracle 10g, SQL server 2008OS : Windows, UnixConfiguration Management : SVNProfessional ExperienceProject name: Delaware Cerberus ApplicationClient: DeloitteDuration: Nov 2023 to Mar 2024Project Description: Testing for the SailPoint SSO and CerberusAs 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 applicationsThe applications were integrated with the ForgeRock and SSO application to provide the following capabilities:1. Login2. MFA3. Session Management4. Single Sign On (SSO)5. Role Based Access/Page Level SecurityThe 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 SecurityActive Directory Lock/Unlock Account4.Worker User - Batch Process Disable Inactive Users Disable User Account on Expiry End Date Reminder Inactive User ReminderPassword Expiration Warning5.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) Transfer6.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 ManagementResponsibilities: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 ExperienceProject name: Frontier ChatbotClient: Frontier CommunicationsDuration: Sep 2022 to Apr 2023Project Description: Testing for the chatbot developed for Frontier communicationsFrontier 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 BAs 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 membersProfessional ExperienceProject name: Kiln InsuranceClient: Kiln InsuranceDuration: Oct 2011 to Jan 2016Project Description: Manual Testing of the major applications for Kiln InsuranceKiln 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 BAs 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 membersPrepared various templates to test the ETL data migration from one system to another.Project name: IRB Development and Testing SupportClient: Cricket CommunicationsDuration: May 2011 to October 2011Project Description: Manual testing for the IRB applicationThis 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 TesterResponsible for testing the functionalityUnderstanding the requirement and writing/executing test casesReporting bug in bug tracking tool.Testing the migration data from source to target systemReport defects found during test cycles and retest fixed defects and update in tool.Project Name: Sigma Aldrich Data MigrationClient: Sigma AldrichDuration: Oct 2010 to April 2011Project Description: Data Migration from SAP 4.6 PRD and SAP 4.7 PRE into new SAP ECCMigrate 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, MVKEBill of Material - STZU, MAST, STKO, STOP, CUKBPurchasing Info record - EINA, EINE,Source List- EORDMaster Recipe - PLKO, MAPL, PLPO, PLMZSD Pricing KOMG, KONH, KONP, KONM, KNOWInspection Plans PLKO, PLKO / E B119, MAPL, PLPOInspection Methods QMTB, QMTT, QMTBMaster Inspection Characteristics - QPMK, QPMZ, QPMTMaterial QM Inspection type - QMATResponsibilities: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 SystemClient: WellpointDuration: July 2007 to September 2010Project Description: ESCS system is used for loading data from various inbound interfaces to True Comp staging area and develops custom reportsESCS 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 documentsUpdating Requirement Traceability MatrixPreparing Detail Design deliverablesWorked on processing relational database, flat file formats and handling CSV files with multiple delimitersUnderstanding the requirements, S-T mapping and preparing technical design documentsExtensively 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 leadsIdentifying efficiencies and ways to improve design and development processesPreparing test casesFixing Release defects |
