We provide IT Staff Augmentation Services!

Senior Associate Resume

AZ

SUMMARY:

  • Having 11+ years of experience in software industry which includes Manual, Automation, Mainframe, Database, ETL/Datawarehouse, SAP CRM & BO, Web technologies and Big Data/ Hadoop - Hive testing .
  • Onshore experience with Confidential, State of California, USA and Barclays Bank, Manchester, UK.
  • Data warehouse testing in Big Data, Spark, Kafka, Scala, Python, AWS (EMR, S3, EC2, Lambda), Hadoop, HDFS, Hive, Pig, Impala, MySQL, UNIX, Teradata, Informatica, ETL.
  • Data Warehousing - Expertise in developing strategies for ETL using Informatica Power Center and SAP BO reports.
  • Experience in Selenium, Quick Test Professional (QTP) and IBM - Rational Functional Tester .
  • Experience in JAVA web-based applications, Oracle databases, and Client/Server applications.
  • Experience in AWS and Azure Cloud Mirgration.
  • Knowledge in Robotics Process Automation - Blue Prism & Automation Anywhere.
  • Excellent Knowledge of Database Systems - Oracle 10g, SQL server, IBM DB2 and Data warehouse concepts.
  • Extensive experience in developing SQL scripts to validate the databases, tables and reports data for backend database testing.
  • Proficient in troubleshooting database issues and experienced in using performance monitor/profile to solve dead locks/ long running queries.
  • Experience in RDBMS, Microsoft SQL Server, Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge, PEGA and UNIX applications.
  • Extensively worked on testing tools like Application Lifecycle Management, QC, Rational Test Manager, Rational Quality Manager and Test Director.
  • Certified IBM - Rational Functional Tester for Java certification, Agile Scrum Master & Application Test Designer.
  • Experience in testing SAP CRM and ECC modules. Strength in SAP CRM 7.0 Sales and Interaction Center on Web UI Platform.
  • Project Management: Ability to work with and drive cross functional teams to ensure completion of all commitments made relative product development timelines, delivery, quality and business matters.
  • Manage programs through entire product life cycle, interfacing with onsite teams on technical and business matters.
  • Exposure in Project and Release Planning, resource estimation and conflict management.
  • Liaised between onsite - offshore project leaders and performed the role of a facilitator between multiple teams.
  • Dynamic work allocated to the team members on a priority basis and ramping up the teams’ knowledge base if the team member is new to the product or process by providing appropriate trainings. Swift learner and venerable team player, ability to meet tight deadlines and work under pressure.
  • Expertise on different types of functional, integration, system & regression testing.
  • Good understanding on SDLC/STLC the software testing, planning, quality assurance and quality control and w orked in different phases of V-model, waterfall and agile methodology.
  • Experience in test management, traceability to requirements and defect tracking.

TECHNICAL SKILLS:

Domains: Healthcare, Banking, finance, Insurance and Retail

Automation Tools: HP - QTP, IBM - Rational Functional Tester

Testing Tools: Rational Quality Manager, RTC, TD, Quality CentreALM, Clear Quest and BugZilla

ETL Tools: Informatica and Datastage

Databases: Oracle 8i/9i/10g/11g, DB2 8.0, SQL Server 2005/2008Teradata, MS Access

Methodologies: Waterfall, V-model, Agile scrum

Operation Systems: Windows XP/ 2000/2007/2010 and UNIX

Mainframe: DB2, CICS, VSAM

Languages: VB script, Java script, JCL, COBOL, SQL, Scala, Python, HQLSpark, Unix Korn Shell

Other Utilities: Oracle SQL, WinSCP, Putty, AWS, Hive, BigD, Spark, HadoopHIVE, Sqoop, Kafka, flume, Pig

PROFESSIONAL EXPERIENCE:

Confidential, AZ

Senior Associate

Responsibilities:

  • As a working module lead role, handling team members and involves the following:
  • Test Requirement gathering, analysis, Create Test plan, Create Test scripts.
  • Work with developers to build code and code migration.
  • Test execution, Test results validation and test results documentation.
  • Import-export data into HDFS format, analyze V=Big data using Hadoop environment, Developed UDFs using Hive, Pig Latin and Java.
  • Experienced in writing the UDF (User Defined function) which makes hive easy to plug in your own processing code and invoke it from a Hive query.
  • Provide sign-off for production implementation.
  • ETL testing using Spark, Kafka, Scala, Python, AWS (EMR, S3, EC2, Lambda), Hadoop, HDFS, Hive, Pig, Impala, MySQL.
  • Test Auto file trigger for AWS and Oozie workflow scheduling for Hadoop HDFS batch processing
  • Developed HIVE SQL queries to validate the complex business rules
  • Working as Test Lead and is responsible for ETL testing, helping other team members to ensure delivery of quality deliverables, meeting the timelines, perform end-to-end testing and provide weekly status on projects to management
  • Interacting with clients, business analysts, end user to get business requirements from them, providing estimates, Translating business requirements into test requirements, coordinating with offshore to ensure the defect free deliverables identified major Performance Issues in QA testing and work with developers on performance tuning guidelines to meet SLA
  • Exchanged data between S3 and Hadoop HDFS.
  • Analyze data Integration & flow from 3 data sources
  • Preparing and Executing the test cases in the Hive SQL, Beeline, Big Decesion and Oracle SQL Developer.
  • Testing the reports in Tableau.
  • Co-ordinate UAT testing, act as a SPOC between Confidential and Confidential
  • Perform defect management and tracking of defects identified in SIT and handle triage calls and manage defects.
  • Filled the knowledge gaps by arranging the required KT sessions to team members

Environment: JAVA (JDK), Apache Tomcat, R Studio, Sql Server, Informatica BDM, Tableau, Cloudera, Spark SQL, Spark Streaming, Kafka, Python, AWS (EMR, S3, EC2, Lambda), Hadoop, HDFS, Hive, Pig, Impala, Scala, Spark, Big Decision, WinSCP, SQL Developer, PuTTY, MS Office 2013

Confidential

Team Lead & Management

Responsibilities:

  • As a working Offshore module lead role, handling team members and involves the following:
  • Coordinate with onshore for Test Preparation, Execution and Status reporting.
  • Coordinate with client, other vendors and address the issues and share the testing deliverables.
  • Review the Test Strategy,Test Planning documents.
  • Test Management Tool setup, maintenance, Resource Management.
  • Coordinate between BAU support team, Migration Team and Testing Team.
  • Coordinate the Refresh Plan in Baseline Systems testing.
  • Coordinate the Azure Cloud Migration in Dry Run testing.
  • Coach my team to develop them to highly productive, apply testing methodology and produce high quality deliverables while executing test cases for each modules.
  • Daily interacting with onshore and offshore team.
  • Daily assign the task to the team members, and s ending daily catch up with offshore achievement for the day status, Test execution status for CON,Reference systems & Dry Run Testing status report to onshore/client team.
  • Filled the knowledge gaps by arranging the required KT sessions to team members.

Environment: SAP - BW, PI, EP, PORTAL, SCM, SRM, HR, BO, ECC, SD, MM and NoN SAP systems, DB- Oracle to SQL 2014,OS Migration - Unix to Windows Server 2012 R2, office 2013, IBM - Rational Quality Manager (RQM), Rational Team Concert (RTC).

Confidential

Team Lead

Responsibilities:

  • As a working module lead role, handling team members and involves the following:
  • Analyzed the business requirements and functional specifications.
  • Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
  • Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
  • Developed complex mappings in Informatica to load the data from various sources.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Parameterized the mappings and increased the re-usability.
  • Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
  • Created procedures to truncate data in the target before the session run.
  • Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
  • Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
  • Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
  • Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
  • Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Created Test cases for the mappings developed and then created integration Testing Document.
  • Filled the knowledge gaps by arranging the required KT sessions to team members.

Environment: Oracle 10g/11g, Informatica Power Center (Power Center Designer, workflow manager, workflow monitor), SAP Business Objects - Crystal Reports and Dashboard, IBM - Rational Quality Manager, SQL developer, TOAD, SQL, PL/SQL, FileZilla, PuTTY, Mainframe, Clear Quest, Rational Quality Manager, Manual and MS Excel.

Confidential, Oakland, CA

Test Lead

Responsibilities:

  • As a working module lead role for application, handling 15 team members and involve the following:
  • Involved in sprint and walk through meetings to go through the Business Requirements and understand the scope of the project.
  • Mapped requirements to test cases to maintain accurate Traceability.
  • Automated, Executed and Maintained Test cases through Selenium Web Driver.
  • Built a detailed, reusable Page object Framework for over 80% Test cases using Selenium Web Driver + JAVA (No Record and Run).
  • Responsible for review of Test cases and Test Scripts (Manual + Automation) written by Peer.
  • Worked on Selenium Web driver for automating over 70% of cross browser testing on IE, Firefox, and Chrome.
  • Involved back end validations using MySQL.
  • Performed Smoke test on the build to ensure its clean enough for QA testing to proceed on the delivered builds.
  • Logged and Verified defects accordingly using BugZilla.
  • Involved in defect triaging with developers and other project stakeholders to get updates on defects.
  • Involved in updating the Dashboard with daily status update on execution of TC's and defect report and Involved in retrospective meetings.
  • Responsible for testing and automating hand held devices.

Environment: Web Driver, Java, TestNg, Manual and Automation (Selenium RC, WebDrvier),BugZilla, MS Office, BugZill and SQL .

Confidential, St Louis,MO

Test Lead

Responsibilities:

  • Coordinate between Clients and Offshore teams.
  • Preparing estimates for the release work proposed and getting approvals for the same from Clients and Confidential Management.
  • Understanding end to end Business functionality, Analysis of Requirement documents.
  • Preparing resource utilization metrics and sharing the same with the Clients and leads.
  • Addressing application access issues
  • Preparing Status Reports on testing activities/efforts
  • Addressing issues raised by the team and clients
  • Coordinating Automation work from Onshore and helping offshore Automation resources by providing resolutions for the questions raised.
  • Tracking Release schedules and Resource estimations.
  • Constant follow-ups with clients to track the change requests and updating the team as and when needed.
  • Developed and Executed Test Plans, Test Cases and Test Scripts.
  • Close coordination, seamless communication and daily Touch Point & hand off calls with the Team to update the leads and clients on progress and issues.
  • Constant monitoring of effort and schedule, escalating the project dependencies much in advance to mitigate the risk of show-stoppers while testing.
  • Participated in defect management calls with the onshore functional team.
  • Used RQM and share point for test case management, defect tracking
  • Performed a wide range of quality tests, functional, user interface, regression, connectivity, smoke tests, performance,user acceptance, failover and recovery.
  • Continuous review process - peer review with offshore and onshore to avoid any issues with the Test Scenarios and Test Cases.
  • Filled the knowledge gaps by arranging the required KT sessions to team members .

Environment: Java, J2EE, XML, Share Point, RUMBA Mainframe, Claim Research Tool, Oracle Developer, Windows, Rational Quality Manager, Excel.

Confidential

Team Lead

Responsibilities:

  • Played Module Lead for applications handling eight member team.
  • Understanding and designing of the test cases based on the functional requirements
  • Coordinating the team and assigned daily task and consolidated the reports.
  • Developing/review/modify test plan, test cases, test data and coordination with the development team.
  • Review/modify/create test cases and test scenarios for different types of testing like UAT testing, End to End, Product integration testing and regression testing as per the requirements.
  • Validated SAP CRM and ECC screens for data validation and sales related screens and distributing to warehouses.
  • Co-ordination with the onshore team for the status meetings and issue clarification.
  • Raising and tracking defects during test execution in IBM - Rational Quality Management.
  • Participate in bug review sessions and coordinate with development teams.

Environment: Rational Quality Management, SAP Testing , Share Point, Windows, Excel,SAP CRM & ECC

Confidential, Pittsburg, PA

Senior Software Engineer

Responsibilities:

  • Responsible for preparing WSR(Weekly Status Reports) and presenting the same in weekly status meetings with offshore, onshore & client teams.
  • Responsible for addressing the issues raised by the team and clients and follow up until closure.
  • Constant follow-ups with clients to track the change requests and updating the scripts as and when needed.
  • Helped team improving their functional and technical skills.
  • Point of Contact for all automation activities from offshore.
  • Close coordination, seamless communication and daily handshake meetings to update the onsite leads and clients on progress and issues.
  • Constant monitoring of effort and schedule, escalating the project dependencies much in advance to mitigate the risk of show-stoppers while testing.
  • Continuous review process - peer review, onsite review with offshore and onshore to avoid any issues.
  • Responsible for Preparing Automation Process Documents for the Team.
  • Responsible for Developing and Executing Automation test scripts using RFT for 12 different web applications.
  • Responsible for automating different applications like Capes Pega - Workflow, ECS - Membership, OPIS and Bill Core - Ebill etc.
  • Regression testing of the applications using RFT.

Environment: Java, J2EE, XML, Share Point, MQ Series, Rational Functional TesterRational Quality Manager, DB2, Windows, Excel.

Confidential

Senior Software Test Engineer

Responsibilities:

  • Using High level design documentation and use cases to derive test scenarios and test cases.
  • Taking ownership & responsibility for UAT to facilitate testing for the introduction of new r revised functionality.
  • Working as a single point of contact for technical and testing guidance for other capability groups in the core banking system.
  • Ensuring that all capability groups test the changes appropriately and reporting the progress and test results to supervisor.
  • Preparing test scenarios, test conditions and review of test scenarios and conditions.
  • Responsible for execution test scripts.
  • Performing Functional, Regression testing and defect retesting.
  • Training sessions conducted for new associates and project related tasks.
  • Involved in meetings for preparing test plans based on Software Requirements Document
  • Involved in business functionality review meetings
  • Interacted with Functional and Technical Managers & QA team for understanding requirements
  • Prepared MOM for meetings and status calls and regularly updated the SharePoint for future reference
  • Escalation and communication bridge for Offshore and Onsite.
  • Defect tracking and Defect analysis using Quality Center 9.2 and provide an accurate
  • Defect Management Report like Test Metrics detailed daily status report.
  • Thoroughly tested application along with bug reporting, bug tracking till bug closure.
  • Also, I was involved in generating production packs and performed the QA and also sending the reports to the Client.
  • Extracts reports from the QC and the update reports in a specific format
  • Implemented PDF process production checklist for each pack
  • Daily created a For Final Metrics PDF Consolidation to update Pack for both LTSB and
  • HBOS Packs.
  • Reduced the time required for QA the reports (instead of excel reports to make a PDF’s) mins thereby saving time by 70% approx
  • Delivered on time and schedule as directed by the client.

Environment: V.B, .net, Share Point, MQ Series, Windows 2007, Oracle Developer, Windows, Quality Center, Excel.

Hire Now