SUMMARY

• Over 11 years of experience in Information Technology with strong emphasis on software analysis, design, development, testing, integration and implementation of Data intensive applications using different databases like Oracle, SQL Server, Sybase, UDBDB2, SOQL,Denodo and tools such as Embarcadero Rapid SQL, TOAD, SQL Developer and Autosys.
• Over 6+ years of experience as a ETL Tester/ Data Analysis / Database Tester / UAT Tester with good management skills, requirements’ writing, data analysis and Systems and User Acceptance Testing (UAT) of Secondary Mortgage & Logistics.
• Over 10 years of experience working on different DBs like Oracle, SQL Server, UDB DB2, Sybase.
• Over 7 years of experience using full system development lifecycle including Business/Data Requirement Analysis, Quality Assurance, Development, Report/Technical writing, Support & installation
• Over 3 years of experience in automation using Selenium Web Driver, TestNG, JUnit and also cucumber framework
• Over 3 years of experience in creating and maintaining CI/CD pipelines for code deployment using Jenkins
• Over 3 years of experience in using DevOps tools including GIT, Maven, Jenkins
• Over 1.5 years of experience in using Docker and Kubernetes, Ansible, Chef, ELK
• Over 1.5 years of experience in using AWS cloud technology
• Experience in data analysis including the understanding of business and system requirements and documenting clear data requirements for complex business rules for data transformation. Experience working with business experts to validate the requirements for completeness and accuracy.
• Experience working with data modelers to provide a clear understanding of data relationships and cardinality. Working with the data modeler to ensure the model correctly expresses the data requirement.
• Adept at handling multiple projects and tasks simultaneously to deliver solutions from conceptual stage to delivery to end user.
• Strong experience in domains like Single Family Mortgage Loans Accounting and Logistics Domain.
• Excellent interpersonal and communication skills, Strong analytical and problem - solving skills.
• Resolution of critical issues through logic and sound reasoning while focused on goals. Ability to work independently and manage business expectations with a delivery-focused approach to work.
• Good Understanding on both Waterfall and Agile methodologies.

TECHNICAL SKILLS

Databases: Oracle 10g/9i, MS SQL Server 6.5, UDB DB2, Sybase

DB Tools: Embarcadero Rapid SQL, TOAD, IBM DB2 CE, SQL, Denodo, Basics of DataStage / Informatica, SOQL

SDLC Tools / Other: IBM Rational DOORS, HP Quality Center/ALM, UNIX, Putty, AutoSys, SOAP UI, GIT, Maven, Jenkins, Salesforce (Fusion Risk System), Basics of TIBCO, JIRA, CA Service Desk,SWN,JIRA

Languages: XML, Core Java and Servlets (Basics)

Cloud: Amazon Web Services

Certifications: Oracle Certified Associate, ITIL Certified, Agile Certified Scrum Master, Safe Agilist, AWSCCP

PROFESSIONAL EXPERIENCE

Confidential, Tampa FL

DevOps (Automation) Tester /Test Lead

Responsibilities:

• Have worked across all the above-mentioned phoenix applications such as Single-Family Transaction Accounting (SFTA), SF Loan Amortization, Phoenix Reference Data Services, Operational Subledger, SF Asset classification and DAT.
• Analyzed existing applications’ information by understanding the data transition between systems.
• Experience in leading interactions with the business users to break down business requirements into Information/Data requirements, including transformation logic.
• Extensively involved in managing UAT/SIT sessions, Test planning, Test design, writing Test cases, Test automation, Test execution, CSI and related artifacts.
• Developed CICD Automation Framework using Jenkins for microservices based application by coordinating with multiple teams.
• Developed automation scripts using selenium/cucumber for performing regression testing for various production incidents.
• Developed innovation solution for reducing the time of execution in Salesforce Fusion Application.
• Developed complex SQL queries for querying data against different databases for data verification process.
• Developed SQL test scripts based on Technical specifications/Data design documents and Source to Target mappings.
• Responsible for performing the management functions of planning, coordinating, implementing and controlling related to various data quality assessment tasks.
• Developed Test Strategy, Test Plans, Test estimation (resourcing), Test Scenarios/Cases/Scripts and executed the test scripts for Mortgage Servicing Digital Scrum Project (Agile).
• Extensively interacted with developers, business & management teams to understand the business requirements and ETL design document specifications.
• Extensively used and developed SQL scripts/queries in backend testing of Databases and reports modules.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Have led a team of four associates/Testers from both Onsite and Offshore and ensured deliverables are completed on time without issues.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL groups, Acquisition team and business analyst for understating mappings for dimensions and facts in data warehouse and data mart applications.
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Worked on issues with migration of Data from development to QA-Test Environment.
• Worked with business users and the technical teams on fixing defects and on issue resolutions
• Developed the Operational User guide which helps to execute the scripts within the Access database for UAT users.

Environment: UNIX, Windows XP Professional, MS-Office tools, Rapid SQL, SQL Developer, XML, IBM DOORS, DB2, Oracle, Informatica, IBM Datastage, HP Applications Lifecycle Management, Data warehouse, ETL, Autosys, Selenium, Cucumber, Jenkins, Maven, Ansible

Confidential

Project Lead/Tester

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business users and System analysts.
• Analyze the reporting/business requirements from the business users and convert them into technical specifications
• Involved in designing the process flow for extracting the data across various systems interacting.
• Lead the effort in converting the logical design to physical design by enforcing naming standards, referential integrity across multiple subject areas
• Provided various value addition to the customer by means of brainstorming the various new technologies available in current market
• Developed the Runbook / Operational support guide about the application for end users.
• Coordinated with Various Business Users and performed SIT/UAT testing.
• Responsible for performing the management functions of planning, coordinating, implementing and controlling related to various assessment tasks.

Environment: Oracle, Titanium Appcelerator, TIBCO, HP ALM, Rest Webservices

Confidential

Team Lead/ Team Member

Responsibilities:

• Analyze and solve the various production issues and requests raised by the business end users
• Responsible for performing the root cause analysis on repetitive issues.
• Developed various Innovative Ideas which has Resulted in the reduction of incidents
• Implemented various ITIL best practices in the team
• Responsible for performing the management functions for tracking the various metrics.
• Mentoring Various team members and make them productive in quick phase of time.

Environment: JAVA,Android,Oracle,TIBCO,Sharepoint,CRM,CA Service Desk,JIRA,ProAct