Sulakshana Boddula
* *******.*******@*****.***
Status: Citizen
http://www.linkedin.com/in/sboddula
Summary
Accomplished and results driven professional with 10 plus years of professional experience worked as a Software Quality Engineer. QE in reviewing product requirements, reviewing designs, creating test plans test cases,review and tested the reports, demonstrated ability to communicate and work with co-workers at all levels
Expertize in manual and Strong skills in automated testing of data analysis, ETL data testing, Big data testing web applications on Windows and UNIX operating systems.
Ability to work on Agile, SDLC, Scrum and challenging environments with focus on product delivery. Be consistent and committed to Quality goals.
Actively involved in various phases of testing life cycle such as functional, non-functional, regression, integration, system and User acceptance testing (UAT).
Have clear understanding and experience with Data warehousing and Business Intelligence concepts including OBIEE, Cognos 8 BI, SAP Business Objects with emphasis on and life cycle development using (ETL)Informatica Power Center, Repository manager, Designer, Workflow Manager and Workflow Monitor, Data Stage.
Experience in UNIX Sun Solaris, basic shell scripts, Dimension modeling, and data warehouse concepts.
Experience with different software engineering methodologies (AGILE, Waterfall, Kanban).
Strong SQL and NoSQL knowledge, including writing and executing queries to analyze data
Performed Back-End testing to ensure data consistency on front-end by writing and executing the Complex SQL queries on database.
Working and good hands on in BIG data technologies like Azure data lake, Spark, Hadoop, Hive, Google Cloud.
Performed GAP analysis of business rules, business and system process flows, ensuring accuracy and deadlines were met. Interacted with business users to prepare and update Business process BPR and software system requirement SSR, created test cases and test scripts.
Experience in processes consisting of data sourcing, data transformation, mapping, conversion and loading.
Experience in mapping analysis, Test Plan, Test case preparation, test execution, defect reporting, and regression testing and final documentation.
Wrote Automation in Scala/python in ETL end to end testing.
TECHNICAL SKILLS
Language:
HTML, XML, Core Java, SQL, JavaScript, Python, Scala
Databases:
MS Access, Oracle10g 11g, DB2,Microsoft SQL server, MySQL, PL/SQL
Operating Systems:
Windows 95/98/NT/XP, UNIX,Linux, PuTTY
QA Tools:
Quality Center 8.2,9,9.5/10(ALM), JIRA, Bugzilla, Selenium IDE
Microsoft Applications:
Additional Skills
MS Word, Power point, Excel.
Tool: Informatica 7.1/8.6,9.0, Data Stage OLAP Tool: Business Objects 3.1 X, Cognos 8BI, Oracle CRM Salesforce, Business Intelligence OBIEE11g, Raid SQL, Teradata, Word, PowerPoint, Visio, Sql Developer, Toad, Rapid SQL, DataStage 11.5. TIBCO, CASSENDRA, Big data- Apache Hive, HADOOP,PIG,TIBCO
PROFESSIONAL EXPERIENCE
Macys.com, San Francisco,CA
Cloud migration/ETL Regression/IDM support
Sr. Test Automation Engineer/Analyst Sep’13 – Present
Description: My project is to lead all the all activities including ETL and Big data technologies related and DB activity. ETL was responsible for execution and validation of all the regression test cases. I was also responsible new project, END to END testing.
Delivered price service project. Leading google cloud migration project.
Responsibilities:
• Managing testing team of 7-12 members, have been working and providing guidance in day to day activity.
• Reviewed project status and worked with product manager and delivery managers.
• Reviewed and corrected all the features and stories created by Product Manager, SA’s and BA’s.
• Worked as Data Analyst on few projects, managed project end-to end.
• Good exposure in GCP component, Airflow, Big Query, Scheduler, Composer, Data-proc.
• Developed automation framework (Scala, python) for End to End validation and Project code validation.
• Experience with databases and cloud storage such as Oracle, Db2, Azure Datalake, Google Cloud, MYSQL, Hive,
Sqoop command, NOSQL- Cassandra.
• Worked in Agile methodology and participated in pre inception, inception and Iteration process of projects.
• Performed and monitored various types of testing include functional testing, regression testing and system testing, Integration testing, end to end testing during different stages of Stella MCOM, BCOM testing application.
• Worked on different Integration, migration projects and other user experience projects across different teams.
• Experienced in testing of ETL and message queue workflows and workloads, including such tools as Apache Kafka.
• Worked in TIBCO EMS server and GEMS messaging layer, HIVE Hadoop Projects.
• Tested all the created data on MCOM (Macys.com), BCOM (Bolmindale.com) test application in different databases.
• Has been working on Teradata migration project to Google Cloud. Testing hundreds of table’s every day.
• Working with application team on sign-off/showcase the test result. Coordinating with business, Development, offshore
on day to day activity.
• Extensive Knowledge of running on Jenkins Continuous Integration Environment and Code push in GIT repository.
• Verified all the generated data in CSV files /Test files/Avro files with database and data dictionary.
• Performed Aggregation and loaded all the CSV files to the site databases with proper commands.
• Executed complex queries in SQL to validate the output in database.
• Excellent communication and interpersonal skills with problem solving abilities, effective in working independently and an exceptional team player.
Environment: Putty, SQL Developer, Jira, Test Link, Microsoft Excel 2007,UNIX, Cognos, Rest Console, Rest Client, Mozilla Firefox, Eclipse, Jenkins and Window, Data stage 11.3,Hadoop, Scala, Python, GCP(cloud), Version one, Jira, Hadoop, Hive/Pig, service now
Netapp (IBM), Sunnyvale,CA
Support site data mart/ Support site web portal
Sr. Quality Engineer Oct’12 – May’13
Description: Support Site with Portal and Enterprise Content Management (ECM) integration to deliver critical baseline NetApp business functionality to create/capture, manage, publish, and retire electronic information.
Responsibilities:
Participated in the requirement gathering of the various work streams by meeting with the Business user, base lining the details and documentation.
Utilized advanced MS Excel and database design to create test cases in mapping process.
Provided specifications and instructions for Operations team to build QA and stage environments.
Analyzed Business Requirement and Functional Specification documents.
Translate the business rules from data mapping documents into SQL queries for validation.
Involved and coordinated QA/UAT offshore team and supported production releases.
Identify business requirements, develop test schedules, review testing plans, and track and document the development and results of these plans.
Involved in coordination with off-shore team, and managing team.
Tested and worked with the implementation of Content Management Systems (Oracle site studio) on Netapp Support site
Reviewed the docs from the Dev team and reported the bugs in JIRA
Tested mapping in Informatica to load the data from various sources into Data ware house using different transformations like Joiner, Aggregator, Update Strategy, Rank, Lookup, sequence Generator, Sorter, Source Qualifier.
Worked as a Production and acceptance tester, who was responsible for accepting and raising incidents.
Responsible as onsite QA lead, did bug-reporting, follow up and tracking.
Tested SCD type-1, 2, 3 mappings.
Worked with QA team to design test plan and test cases for User Acceptance testing (UAT).
Experience in testing and writing various reports and Validation of the data by using SQL queries.
Functional testing of front-end web application user interface, including verification of layout, metadata, browser compatibility, on-screen calculations, error handling, navigation.
Experienced at ETL and flat file data transfer validation,the data mapping from Source to Target and validate report using OBIEE tool
Testing ETL sessions and UNIX scripts in data warehouse applications.
Monitored and tested the Informatica workflows using Power Centre monitor, Session log files.
Extensively worked in HP (QC) and ALM upgrade, maintained all the test cases.
Tested Content Management Database on Oracle site studio and Ominature Debugger to analyse the web site.
Tested Support Site Order status, Technical Assistance, Software Downloads, Product Documentation, User Registration, and Exception License Delivery applications.
Collaborated with the analysts and developers in testing the customer reported issues in Production.
Worked in releases for every 2 months with bug fixing.
Environment: SAP, ALM, HP Quality centre(QC) 11.0,ETL/informatica 9.0, Site Catalyst (CMS), Window, Linux, J2EE, oracle site studio.
Animation Mentor, Emeryville,CA
Web Application
QA Analyst May’12-Oct ‘12
Description: Online animation school that teaches students character animation skills. Animation Mentor is a distance learning school at which animation professionals teach character animation to students in over 50 countries.
Responsibilities:
Involved end to end testing of complete web based site.
Perform cross browser testing and file many bugs with detail issues.
Reviewed business requirements and technical specifications.
Performed positive and negative test scenarios including functional testing, GUI testing, system, integration testing, backend testing with SQL server database.
Worked and tested on Virtualization environments be installing Linux based VMware workstation
Work closely with scrum team, Development and Product teams to clarify requirements and iterate on them
Developed test plan for functional testing Student.animationmentor.com project.
Performed testing on Cart Application and Credit card check, billing.
Environment: SQL Server 2005, Apache, Cold fusion, Web services, Window, Bugzilla, Higher Reach Jenzabar
Wells Fargo, San Francisco,CA
WRTT - Master Data Mart
ETL data Quality Engineer Feb’11 - Apr’12
Description: Managing changes in the Master Data Mart as part of the merger efforts between Wells Fargo and Wachovia in the brokerage business. This highly visible data warehousing project represented an effort to provide a view into and interact with wealth data using a single OBI (Oracle Business Intelligence) Dashboard utilizing agile methodology. This dashboard provided flexible investment reporting functionality, views and client-facing reports, as well as integration of Risk Monitoring functionality and Risk Optics product information including brokerage, Private banking and Compensation.
Responsibilities:
Participated in the requirement gathering of the various work streams by meeting with the Business user, base lining the details and documentation.
Reviewed business requirements and technical specifications.
Developed test plan for financial project such as Brokerage, Private Banking, Investment management as well on reporting functional domains and delivered the Quality products time to market.
Ability to multitask as a result worked more then 3 projects at a time
Utilized advanced MS Excel and database design to create test cases in mapping process.
Provided specifications and instructions for Operations team to build QA/UAT and stage environments.
Extensive experience in writing test plan for using Informatica tool for implementation of methodology in Data Extraction, Transformation and Loading ( ETL).
Monitor production validation of monthly loads, daily loads and weekly loads.
Monitored the Informatica workflows using Power Centre monitor. Checked session logs in case of aborted/failed sessions.
Tracked defects using Jira and generated defect summary report.
Maintained MDM standards and making sure the mappings and workflows are following MDM standards.
Identified and logged the defects in Quality Canter. Participated in the Defect Review Meetings.
Maintained and executed automated Test scripts using QTP 10.0 as per the requirement
Researched and troubleshoot customer data during all phases of, starting with load and processing issues involving extracts, file formats, character sets and formatting issues and other data gaps.
Deployed new builds and maintained the QA Environment.
Extensively worked on SQL's to do positive and negative tests against informatica to compare the data.
Automated the QA environment services monitoring script and data purge scrip on Linux environment and notify in email.
Performed manual, functional testing, Integration testing and regression testing.
Reviewed the docs from the Dev team and reported the bugs in JIRA.
Organized bug review and task review to assign/ re-assign the tasks and their priorities meetings.
Environment: SQL Server 2005,DB2,Oracle 10g, MS Excel, OBIEE 11g, UNIX, JIRA, Toad. Informatica 9, Synsort, Quality Center 10, Embarcadero Rapid SQL 7.7.2
Bionovo Inc, Emeryville,CA
Project: Web application
QA Engineer/BA Analyst Nov’09-Dec’10
Description: Bionovo is the founder of the biotechnology industry has been delivering on the promise of biotechnology for almost 15 years, using human genetic information to discover, develop, commercialize and manufacture biotherapeutics that address significant unmet medical needs. Bionovo is a drug discovery and development company focused on developing safe and effective drugs for the treatment of unmet medical needs in women’s health and cancer.
Responsibilities:
Developed Automation tests with Selenium for functional testing of CRM Sales force application.
Created and developed test cases to test the web application called e-shopping and Client link management based on HTML, CSS, XML and JavaScript.
Prepared the traceability matrices to fill the gap between the requirements and the test cases covered.
Interacted with the Client to understand the functionality of the Application under test (AUI).
Created test cases to test Web Application.
Actively participated in Scrum meetings, reviews and developed test scenarios.
Ran automated test cases on Selenium RC (IE7, Firefox 2.0X).
Worked with client to establish and maintain a consistent test methodology and to resolve questions during the testing process. Served as a coordinator for all testing activities on a project.
Worked on script preparation, execution within framework, around 3 web pages involved flex designs and Flex application testing was also carried out using selenium.
In Regression phase, the project was automated using selenium, with developing a dynamic framework which could automate all the test cases.
Full life cycle experience including requirement analysis, test strategy, test cases design, testing, release new version of product and End-to-end testing.
The scope of testing included functionality, performance, GUI, usability, regression, builds acceptance, and localization.
Tested individual components in Windows and LINUX/UNIX environments and the integration of the backend JAVA Services with the front end.
Developed Methodology, Test Plans, Test Matrixes, Test Cases and Test scripts for functional testing
using the Quality Center as a central repository for test assets during all levels of IT testing cycle.
Environment: SQL Server 2005,DB2,Oracle 10g, MS Excel, OBIEE 11g, UNIX, JIRA, Toad. Informatica 9, Synsort, Quality Center 10, Embarcadero Rapid SQL 7.7.2
Skoobit, Florida
Project: e-Shop(e-commerce)
QA Engineer Sep’07-Nov’09
Description: Consulting for Skoobit which is an online textbook rental company. Students rent textbooks typically by ordering online, and return books after the semester. This project includes Web-site with e-Shop based .The main challenges are transaction reliability and security, access rights, e-payment system, database correct performance.
Responsibilities:
Analyzed the various automated testing tools available in the market to pick a tool according to the platform and application’s testing requirements, resources and budget.
Tested various features and functional areas of the application including New Customer Registration, Billing, Credit Card Processing, and Shopping Cart.
Tested Order-to-Cash (O2C), Point of sale(POC) module included functionalities as order entry, creation of order/booking of order, order fulfillment, invoicing, customer payment/collection and cash application.
Worked with Q team to design test plan and test cases for User Acceptance testing (UAT).
Experience in testing and writing various reports and Validation of the data by using SQL queries.
Authored test cases in test lab, Quality Centre after the analysis of requirement/Use cases.
Analyzed massive and highly complex data sets, performed black box testing and data manipulation using Excel and MS Access.
Prepared Test Plans and developed test cases based on the requirements for various web applications.
Involved in maintenance automated regression test scripts in VBScript.
Parameterised the required fields to run in different environment using Data Driven in Quick test Professional.
Created data driven test scripts, which retrieve the test data from an MS Access Database and use the data to automatically test the application.
Performed GUI testing and Navigation Testing.
Performed analysis based on the source systems and existing OLTP database systems.
Validate the data using SQL queries (TOAD) extensively.
Tested the applications for security like SQL Injection, LDAP Injection, URL tampering and cookie tampering.
Worked with developers and designers on bug and issue resolution.
Responsible for creating the User Manuals and Trouble shooting documents.
Environment: Apache, Win/NT/XP/98/95, MS Excel, MS Visio, INFORMATICA 7.1, Oracle 9i,MySQL, VBScript, IE 5.x, Firefox, Mozilla,HTTP, QC 9.5
Caritor India
Jan’06-Jan’07
Test Engineer
Description: Smo is an extremely realistic sumo tournament game intended for mobile phone users. It supports a wide range of devices among the Symbian, Brew and J2ME handsets. SUMO allows choosing whether you wish to play in a single player or a multiplayer mode via Bluetooth.
Responsibilities:
Tested network security routine and integral part of the system and network operations.
Performed negative test cases for testing, network testing, setting response, memory handling, and battery for unauthorised hosts connected to the organization’s network. Identify venerable services.
Involved in generating SQL Reports.
Involved in base line testing for the entire system.
Tested the most important system first and Use caution when testing.
Developed Test Cases and test plans for various modules.
Created Silk Test scripts for acceptance and regression tests
Maintained test scripts using Winrunner 6.0.
Responsible for unit testing, System testing, Web testing after every build.
Regularly met with the developers to discuss issues and enhance the system.
Documented the test results and provided oral and written analysis of the entire testing phase after its completion.
Environment: C++, HTML, JavaScript, IE 5.x, Netscape 4.x.IP,TCP/HTTP,ASP,.NET,QTP, Test Director 8.2
EDUCATION
1) BS, Electronics and Communication Engineering:
JNTU India,
2) Visa Status: US Citizen