ANITHA NALUMACHU
adbh46@r.postjobfree.com
Mobile: 609-***-****
Sunnyvale, CA.
SUMMARY
* ***** ** ********* ********** in SQL, PL/SQL development and testing of Data warehousing tools.
Worked with development and Testing of ETL mappings with Informatica, Talend and Cognos reports.
Good Knowledge of Java Technologies. Hands-on experience with JSF, Spring and Hibernate.
Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate-wide-ETL solution using Informatica
Experience in Testing BI applications using Cognos.
Extensively used HP Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
Experience in writing complex SQL, Oracle PL/SQL queries including calling stored procedures by passing parameters, functions using SQL Developer and Toad as development tools.
Good understanding of Business requirements and interpretation of business and IT terminology.
Quick learner and a proactive individual with excellent communication and strong analytical skills.
Oracle Certified Associate (OCA).
Basic level of Cognos Reporting tool certified.
TECHNICAL SKILLS
Programming Languages: SQL,PL/SQL and JAVA.
J2EE Technologies: JSF, Servlets.
RDBMS: Mysql, Oracle 10g.
Web Servers: Tomcat 5.5,Apache web Server 2.x
Tools: Informatica Power center, Cognos, Talend,.
Testing Tools: HP Quality center 9.0, 9.2 and Remedy.
EDUCATION
Master of Computer Applications - Osmania University - India 2004-2007
Work Authorization
Authorized to work in US. Holds H4-EAD.
PROFESSIONAL EXPERIENCE
LeanTaas Inc. Feb 2015 to Aug 2017
Project: Analytics for Homedepot Rental Business
Role: Senior Test Engineer
LeanTaas built replenishment analytics for Homedepot Rental business using an intelligent algorithm to suggest buy sell and transfer recommendations based on the demand and tool performance. Algorithm also suggests the location based transfer recommendations for tools to meet the demands in nearby stores.
Contribution:
Test engineer for the entire quality analysis of the project’s data warehouse.
Involved in End to end QA process, from reviewing the specs to meet the business need and testing the BI (ETL tool Talend) mappings with and testing the fully functional end tool.
Performed the Unit and functional testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target tables.
Collaboration with offshore teams and stakeholders of all the applications.
Performed SQL validation to verify the data extracts and record counts in the database tables.
Performance Testing of the analytics before and after table partitioning, query tuning, and code refactoring.
Developed few Informatica jobs for automating the possible scenarios in the whole process.
Environment: Liferay portal community, Tomcat 5.5, JQuery, Talend, Fusion Charts, maven build
WalmartLabs Aug 2013 to Jan 2015
Project: Partner Integration
Role: Senior Test Engineer
Working as a Senior Test Engineer as part of a team working on vendor integration with Walmart. The partner integration team Electronically connects all the suppliers, vendors and carriers and integrates various order management systems.Enables communication between Walmart and vendor and supports file format Options such as EDI, flat files, and custom file formats.
Contribution:
Configuring all different vendors of Walmart.
Assigning different carrier codes to the vendor.
Creating custom orders for the external vendors.
Creating different kinds of orders that can accommodate all different possible combinations of shipping and order placement.
Environment: Oracle, EDI, PL/SQL developer, WinSCP, FTP,AS2.
Qualcomm, San Diego, CA Dec 2012 to Jun 2013
Project: QES- NGB
Role: Senior Test Engineer
The Next generation billing (NGB) is the name of the billing implementation project. This system would have a bill run cycle that will once in a month. This basically computes all the charges based on the messages sent, characters sent, size of the message sent discounts, taxes, base charges, off peak hours and peak hours etc and comes up with one invoice per customer for each customer every month. This data is used to generate reports for each product.
Contribution:
Flexible report generation UI and its functionality testing in all possible scenarios by developing the queries on Qualcomm data warehouse.
Validation or Testing of billing report generated in Cognos by writing the suitable queries and running over the database.
Developed utility SQL scripts for data validation that are helpful in the testing process.
Identifying, analyzing, and documenting defects, questionable functions, errors, and inconsistencies in application functions, outputs, and content.
Defects reporting and managing using HP Quality Center.
Mentoring juniors to bring them up to the speed and teaching them data warehouse testing concepts.
Environment: Windows XP, HP Quality Center 9.2, Informatica Power Center 7.x/8.5, Cognos, SQL Developer, Oracle 10g
Qualcomm, San Diego, CA Jan 2012 to Nov 2012
Project: QES- P & L Financial Hierarchy
Role: Senior Test Engineer
The Profit & Loss (P&L) Data Warehouse project will consolidate, into one central database, information of Actual and Budget concerning QWBS financial performance. In order to provide the best possible performance and allow for system growth, this central database will be designed and developed using the standard QWBS data warehouse model. This model will allow for the retrieval and consolidation of large volumes of data from multiple source systems while providing a wide range of end-user reporting and analysis capabilities.
The end users for the P&L Project will consist of virtually the entire QWBS Finance community, including executive level managers as well as those managing and executing the day-to-day financial reporting and analysis activities. Additional users/ beneficiaries of this project may also include anyone who is responsible for managing and tracking the various revenue and cost centers of QWBS.
Contribution:
Review the Business Requirements document with the business and development team to understand the architecture and functionality of the application.
Developed test scripts for all instances of the UI testing.
Developed test scripts for all instances of the database for Manual database testing
Developed and written a suite of Test Scripts that included Acceptance, Functional and Regression test cases using HP Quality Center 9.2.
Execute the test scripts on different releases and validated the actual results against the expected results.
Identifying, analyzing, and documenting defects, questionable functions, errors, and inconsistencies in application functions, outputs, and content.
Tracking test results for management, categorizing issues and creating/distributing defect reports and managing defect database using HP Quality Center 9.2.
Validation of data in the data warehouse & data marts.
Retest the defects, which are fixed.
Sending Daily status to clients as a part of Agile Methodology.
Identifying the key areas/opportunities for the business growth.
Organizing/Conducting program level trainings and knowledge sharing sessions.
Ensure TCS Quality processes are followed in all the projects.
Environment: Windows XP, HP Quality Center 9.2, Informatica Power Center 7.x/8.5, SQL Developer, Oracle 10g
Qualcomm, San Diego, CA Oct 2010 to Dec 2011
Project : Plaza Retail Data Mart
Role : Test Engineer
Project Description:
Storefront (WAP, ODP, Plaza API) gathers click event data to support over 50 metrics for measuring and managing a retailer’s business. Plaza Retail provides standard reports and key metrics for the following:
Visits
Conversions and conversion rate %
Browse (clicks to view title)
Buy (purchase downloads)
Try (demo downloads)
Free (free downloads)
Revenue
Abandonment rate %
Category page views
Search rate %
Banner impressions, clicks, and conversions.
Contribution:
Review the Business Requirements document with the business and development team to understand the architecture and functionality of the application.
Developed test scripts for all instances of the database for Manual database testing
Developed and written a suite of Test Scripts that included Acceptance, Functional and Regression test cases using HP Quality Center 9.2.
Execute the test scripts on different releases and validated the actual results against the expected results.
Identifying, analyzing, and documenting defects, questionable functions, errors, and inconsistencies in application functions, outputs, and content.
Tracking test results for management, categorizing issues and creating/distributing defect reports and managing defect database using HP Quality Center 9.2.
Validation of data in the data warehouse & data marts.
Retest the defects, which are fixed.
Sending Daily status to clients as a part of Agile Methodology.
Identifying the key areas/opportunities for the business growth.
Organizing/Conducting program level trainings and knowledge sharing sessions.
Environment: Windows XP, HP Quality Center 9.2, Cognos 8.3 Report Studio, Informatica Power Center 7.x/8.5, SQL Developer, Oracle 10g
Qualcomm, San Diego, CA Jun 2009 to Sep 2010
Project : VOE (MySourceJ)
Role : Development Engineer
VOE is a module of MySourceJ, which is a Qualcomm internal portal system for all HR activities. VOE (Verification of Employment) contains Standard Letter and Residential Proof Letter for the Qualcomm Indian Employees. This completely automates the residential proof letter handling for various roles and locale people.
Contribution:
JSF user interface screens development for various employee verification forms
Spring, Hibernate DAO layer for persisting and retrieval of data
Role and employee locale based system behavior design and use case implementation.
JUnit test case development for various use case.
Environment: Java, JSF, Spring, Hibernate, Oracle 10g, Tomcat, PL/SQL Developer, Perforce.
Qualcomm, San Diego, CA April 2008 to May 2009
Project : SQR Conversion and EEO Reports
Role : Development Engineer
The Project aims at converting 100+ Batch processes that are coded in PeopleSoft SQRs into PL/SQL Blocks with major performance improvement and schedule them as needed. Report generation (like Termination report, promotions report) and archiving of reports was main functionality in EEO project. Development of user friendly UI using JSF, for complete offline scheduling and triggering of PL/SQL procedures using Flux with full length job monitoring capability.
Contribution:
Migration of PeopleSoft SQRs into Oracle PL/SQL Blocks.
Design and maintain Database scripts for backed tables
Existing EEO reports Enhancements
oDesign change in the table structures
oChange in the functionality by writing PL/SQL blocks
oReports testing and Data validation
Use Flux as the Scheduler
Configuration Management using perforce
Performance improvement of the converted system.
Environment: Oracle 10g, Java, JSF, Spring, Hibernate, PL/SQL Developer, Eclipse, Tomcat.