Data Project
Resume:
Laxmi Bandari
Contact 201-***-****
Email *************@*****.***
10+ years of IT experience in Analysis and Quality Assurance of Data warehouse, ETL, BI tools in Informatica, ODI, Data Stage, Cognos, MicroStrategy, Tableau reports, Web and Client/Server applications in various domains like Retail, Finance, SCM, Shipping, Manufacturing, Health, Retail and Workflow applications in enterprise architecture environment.
Strong Experience in all aspects of Software Development Life Cycle, Quality Assurance Life Cycle (Analysis, Test Plans, Test Scenarios, Defect management, Functional, Regression and Production testing) in an Enterprise Datawarehouse environment.
Strong experience in Oracle 10g/11g, Sybase 10.x, data analysis, ETL methodology in data extraction, loading and transformation using Informatica/ODI ETL tools.
Strong Experience in writing complex SQL scripts for data validations source and target databases in Oracle, Exasol and Sybase databases.
Extensive experience in analyzing Business and Functional requirements, Data models and source to target mappings and translate them into test scenarios, test cases, test execution and identifying defects.
Experience in actively participating in Defect review meetings with Business and Technical teams to prioritize the defects and service calls on daily basis.
Experience in interaction with business and technical communities, co-ordinate QA effort, KT to offshore teams, status tracking and reporting to project stake holders to meet the project schedules and deliverables.
Strong experience in QA of Client server, Web and Workflow enterprise projects in Oracle, Visual Basic, and Lotus Notes Domino technologies
Strong skills in multi-tasking and ability of adapting to project schedules with strong task-oriented approach and have good problem resolving skills.
Worked with IT consulting companies like Infosys, EDS, Vertex (now Acindo) and Optimum solutions in a global delivery model with onsite and offshore coordination in testing of EDW systems.
Education
Master’s in computer applications (MCA)
Bachelors in Electronics and Math (B.Sc.)
Certification
Awarded National Certificate by Prime Minister of INDIA for excellence in academics.
Certified in Oracle 8i SQL Programming.
Certified in IBM Lotus notes Domino professional.
Technical Skills
OS
UNIX, Windows NT4.0/2000/XP
Database
Exasol, Oracle 11g/10g/9i/8i/7x, SQL Server, Sybase 10.x and Teradata
ETL/BI tools
Informatica 9.x, Sunopsis 2.0 (ODI 10g), Data Stage, Cognos 8.2, MicroStrategy 11.x, Tableau 2019.1 and Business Objects XI R2
QA tools
TOAD, SQL Developer, Rapid SQL, Ultra Edit, Mercury Quality Center, ServiceNow and JIRA
Languages
C, SQL, Java, HTML, XML, JavaScript, VB Script, and Lotus script
Web servers
IBM WebSphere, Java Web Server, Domino web server
Other Software /Version tools
Lotus Notes, Visual basic, MS Visio, MS Project, Visual source safe, Citrix, HP service desk and Folio
QA Methodologies Waterfall and Agile Methodologies
Data Visualization Analyst
Interstate Batteries, Dallas-TX, USA Jul 2015 to Till Date
Role
Involved in reviewing the business and functional requirements, data models, Source to Target Data mappings and converting them into Test plans and Test scenarios.
Involved in preparing test scenarios, test cases, data creation and traceability matrix against business and functional requirements.
Involved in running and monitoring ETL workflow jobs to load the data into Data Warehouse, debug the jobs, identify the root cause and escalate to the teams.
Involved in executing the test scenarios, writing SQL queries to validate the data in source and target databases and BI (MicroStrategy and Tableau) dashboards.
Participated in standup meetings with development and business teams to prioritize the defects, evaluate test results.
Involved in unit, functional, integration and regression testing and Production smoke testing after deployment of each Module/Release.
Involved in functional testing, data base testing, regression testing and production support testing in different environments.
Environment: Oracle 11g, Exasol, MicroStrategy 11.x, Tableau 2019.1, ServiceNow
Sr. DW/ETL/BI QA Analyst/Lead
GAP Inc, CA, USA Aug 2013 to Jan 2015
Global Flashboard Reporting
Role
Involved in reviewing the business and functional requirements, Source to Target Data mappings, data models and converting them into Test plans and scenarios
Involved in team coordination, team status meetings, status review, task allocation, coordination on daily and weekly basis
Involved in understanding the Data models, Source to target mappings and writing SQL queries to validate the data in source and target databases.
Involved in preparing test scenarios, test cases, data creation and traceability matrix against business and functional requirements.
Involved in running and monitoring ETL workflow jobs to load the data into Data Warehouse, debug the jobs, identify the root cause and escalate to the teams.
Involved in executing the test scenarios, writing SQL queries to validate the data in source and target databases and BI reports.
Participated in defect meetings with development team to prioritize the defects, evaluate test results.
Involved in unit, functional, integration and regression testing and Production smoke testing after deployment of each Module/Release.
Involved in functional testing, data base testing, regression testing and production support testing in different environments.
Environment: Teradata 13.0, DataStage, MicroStrategy 9.4, SQL Assistant, Essbase, Mainframes,
JIRA 6.3, CAWA and Folio.
Technical Test Lead / DW QA Analyst
Morgan Stanley, NY, USA May 2010 to May 2012
Corporate EDW Performance Reporting
Role
As an Onsite QA Lead, participate in client business meetings to understand business and functional requirements.
Involved in reviewing the business and functional requirements, Source to Target Data mappings, data models and converting them into Test plans and scenarios
Involved in offshore coordination, team status meetings, status review, task allocation, coordination on daily and weekly basis
As a QA, involved in review and understanding of Business and functional specification documents.
Involved in understanding the Data models and Source to target mappings and writing complex SQL queries to validate the data in source and target databases.
Involved in preparing test scenarios, test cases, data creation and traceability matrix against business and functional requirements.
Involved in running and monitoring EDW ETL workflow jobs to load the data into Data Warehouse, Data marts and debug the jobs, identify the root cause and escalate to the teams.
Involved in executing the test scenarios, writing SQL queries to validate the data in source and target databases, BI reports.
Participated in defect review meetings with development team to prioritize the defects, evaluate test results.
Involved in unit, functional, integration and regression testing and Production smoke testing after deployment of each Module/Release.
Involved in functional testing, data base testing, regression testing and production support testing in different environments.
Environment: Oracle 10g, Informatica 8.1, Toad 9.0, MS Project, Mercury Quality Center 9.0 and Cognos 8.2.
Sr. DW QA Analyst
Client - Pepsi Co, NY, USA Jul 2009 to Mar 2010
Project - Sales Tracking and Reporting (STAR)
Sales Tracking and Reporting (STAR) project consists of ODS, EDW, Data marts and Business Objects Reports. STAR takes the data from the front-end java applications and transform the data using Informatica ETL tool and load the data into ODS (Oracle database), from ODS the data will be send to different Blue Books like Customer, Product, Invoice etc.
Role
As QA Module lead, co-ordinate and work with business users and QA resources on QA task assignments and status reporting to project management.
Consolidate and report production service calls from regions in service desk and prioritize on daily basis.
Involved in understanding data models and source to target mappings and translate them into test scenarios, test cases and traceability matrix against business requirements.
Wrote complex SQL queries for data performance in source and target databases and executing scenario’s, identify and prioritize defects and track with Business and Technical team
Involved in Bug review meetings with Business and Technical team to prioritize the bugs on daily basis and publish QA status and defect reports to project stake holders.
Participated in cross training in various modules and KT sessions.
Environment Oracle 10g, Informatica 8.1, Business Objects XI R2, Toad 9.0, MS Project, MS Visio, Mercury Quality Center 9.0 and Windows 2000
Sr. ETL/BI QA Analyst
Client - NYK Lines, NJ, USA Jul 2005 to Jun 2009
Project - Management Information System (MIS)
MIS (Management Information System) project consists of CDW (Centralized Data Warehouse), Data marts, Cognos Cubes and Cognos Reports. MIS takes the data from the ODS (Operational Data Store) i.e., Sybase from 23 different modules (18 Gemstone and 5 web modules) and transform the data using Sunopsis/ODI tools and load the data in CDW and Data marts. Reports will be building based on the mart data and using Cognos cubes.
Role
As a QA, involved in review and understanding of Business and functional specification documents
Involved in understanding the Data models and Source to target mappings and writing complex SQL queries to validate the data in source and target databases.
Involved in preparing test scenarios, test cases, creation of service contracts as part of data creation and traceability matrix against business requirements
Involved in running EDW ETL workflow jobs to load the data into Data marts and debug the jobs, identify the root cause and escalate to the teams
Involve in defect review meetings, evaluate test results and communicate with development team
Participated in defect review meetings with development team to prioritize the defects
Involved in unit, functional, integration and regression testing and Production smoke testing after deployment of each Module/Release.
Involved in functional testing, data base testing, regression testing and production support testing in different environments
Environment Oracle 10g, Sybase, Sunopsis 2.0, ODI 10.x, Cognos 8.2, SQL, Toad 9.0, Rapid SQL, MS Visio, Mercury Quality Center 9.0 and Unix
IT Applications Consultant
Client - IBM Singapore Pte Ltd, Singapore Jun 2004 to Jan 2005
Project - Mktg Strategic Intelligence System
The MYSI and OSC will handle the creation and workflow approval of the Teardown reports. The system will automate the process like creation of Teardown Reports, editing and approval of the reports, dissemination of reports, search within the reports, maintaining the Readers and Authors profile and allowing the system admin to assign readers and authors for the reports.
Role
Involved in review and understand of requirements, functional specifications
Prepared test scenarios, test cases, execution and test reports in both positive and negative testing.
Tested and debugged SQL scripts for data performance
Evaluate test results and communicate defect information with to developer team
Participated in bug meeting reviews with development team to prioritize the bugs
Tested HTML, Java script, GUI interface, web links, design of screens, forms for consistent look up.
Involved in functional, regression testing and troubleshooting.
Environment Oracle 9i, SQL, Toad 8.0, Test Director 7.x, MS Project, MS Visio, Crystal reports 8.5, HTML, Domino server and Windows
Applications Consultant
Client – General Motors Corp, Singapore Dec 2003 – Apr 2004
Project - Vendor Order Management System
GMC developed the project to generate reports for Purchases Orders, Vendor Acknowledgement reports, PO delivery schedules, Inventory stock levels and Weekly shortage reports.
Role
Involved in review and understanding of Business and functional specification documents.
Interacted with analysts to translate requirements and source-to-target mappings into test cases.
Involved in testing of extraction, transformation, and load (ETL) mappings and processes
Tested various reports like tabular, cross tab, chart, drill-down BO reports.
Tested SQL queries, PLSQL scripts to validate and improve the backend data
Participated in defect review meetings with development team to prioritize the defects.
Involved in functional, integration and Regression testing and test results capturing.
Involved in production smoke testing after each module/release deployment
Environment Oracle 8i, SQL, Informatica7.1, Business objects, Toad 7.x, Test Director 7.x, MS Visio, MS Power point, MS Project, Windows 2000 and UNIX
Applications Consultant
Client – DBS Bank, Singapore Feb 2003 – Nov 2003
Project - ITD Process Automation System
ITD System will automate three ITD process namely Problem Management System, Service Request System and Change Request System on web-based interface.
Users log the problem electronically the helpdesk will be notified via email for them to either solve the problem or assign it to a service officer. The system also generates various reports like Service complete by percentage, no of service requests by date, by monthly, quarterly and yearly using crystal graphical reports.
Role
Developed test cases for comprehensive coverage of application functionality.
Involved in black box, white box testing and executed SQL queries for data validation and table updates.
Participated in project sync meetings during all phases of testing
Performed positive and negative testing, Regression and Integration testing
Tested Production modules like SR, PM and CR modules
Preparation of test cases, test execution, UTR and PTR documents
Environment Oracle 8.x, Toad 7.x, Crystal reports 8.x, Test Director, Lotus Notes R5.x, HTML, Java Script, MS Project and Windows NT 4.0/2000
Developer/ QA Support
Client - Singapore Bus Services Transit Ltd, Singapore Dec 2001 – Dec 2002
Project - Service Management System (SMS)
My Service Adviser Scheme system provides all the users an electronic feedback form on browser, to fill their Service feedback. Once it is submitted it will be routed to the respective district’s General Manager. If the feedback is for Information, the GM will route to the all departments for maintaining the information.
Role
Involved in design, development, testing, technical and production support.
Used Lotus Notes for develop screens, forms, views using HTML, Java Script and to incorporate graphs, URL links and validations.
Wrote @functions, formulas and Lotus script agents for document routing.
Involved in unit testing, test cases, execution and bugs fixing, black box and white box testing
Generated crystal reports by connecting to lotus notes using ODBC.
Environment Lotus Notes R5, Domino server, Oracle 8.0 and Crystal Reports, HTML, Java Script, Windows NT 4.0
IT Trainee Programmer
Apollo Hospitals Group, India Nov 2000 – May 2001
Project - Billing System
The purpose of the Outpatient Counter Billing System aims at generating bills for outpatients, which is a daily operation. The project deals mainly with four different modules namely Master Module, Daily Operations Module, Daily Reports Module and Periodical Reports Module. The Master Module mainly stores all the relevant information regards to the patient, doctor, company, tests, package etc.
Role
Involved in designing of forms, reports and coding of the form validations and reports
Designed various forms like Master module, Daily operations module, reports module and Periodical reports module.
Used VB Script programming for front-end validations.
Involved in programming and testing of the application.
Environment Windows NT 4.0, VB 5.0, Microsoft Access
***
Contact this candidate