Data Engineer
Resume:
PALLAVI PRAKASH MUDALIAR
Email – *******.********@*****.*** Phone – 507-***-****
Location: Mounds View, Minnesota
Objective
To continuously learn, tweak, automate and optimize testing tools & infrastructure for building robust and reliable products and services in any industry that uses software.
Experience Summary
●CMST (Certified Manager in Software testing), CSTE from QAI and ISTQB Certified Quality Analyst with 8.8 years hands on experience in Software testing and quality.
●Team Leader with good experience in creation and maintenance of Requirements traceablility matrix, Test plan, test strategy, estimations, Identify deliverable for each iteration, review of acceptance criteria by business, identify story points, Identify dependencies, risks, coordination with delivery partners, involved in quality verification and validation activities. Coordinating with onshore/offshore teams.
●Experience working and leading test efforts for Unit, Functional, System, regression, automated, User acceptance and performance testing.
●Experience with defect tracking, resolutions and closure through defect triage.
●Involved in project status tracking, test status reporting to management on day to day basis.
●Preparation of metrics – Test and defect metrics.
●Involved in Lessons learned document, make recommendations for test implementation.
●Experience in implementation of various SDLC models, traditional waterfall, V model and agile methodologies. Worked with geographically separated teams implementing agile Scrum methodologies with managing Sprint Planning, Backlog grooming /Prioritization, Acceptance Criteria, Story points / Estimation, Conducting Stand ups & Retros, Story Kick Off /Inception, Defect management, Stakeholder Management, Continuous delivery, Integration Testing, Scrum of Scrums & showcase.
●Experience working with relational database, large data sets, data profiling, data sourcing, metadata testing.
●Experience testing source files through Unix, excel.
●Experience working with databases – Oracle, SQL Server, Teradata
●Experience testing workflows run through scheduling tool – Autotsys using ETL Tools like Informatica, IBM Datastage, test data from staging to Transactional database to datamart.
●Experience in testing reports through Cognos and verify source system data, verify reconciliation statements with Cognos reports.
●Experience in Manufacturing Domain - Order Fulfillment Process, Banking - Internet banking, Payment systems, Investment Banking, Healthcare domains.
●Experience of 3 years as a part Business Analyst, gather requirements from business, user groups, responsible for creation of use cases, identify existing system functionality, creation of As-i work with cross functional teams to gather requirements, provide inputs to Development team to add and improve functionality. Worked with users remotely to lead and perform UAT.
●Good experience in Unit level, functional, system, regression and User acceptance.
●Overall planning, management and oversight of execution of the entire UAT, determine end to end Business process verification. Involved on Uat environment setup, choosing and assigning user roles, determining testing types in UAT, determine timelines against scope of work, manage and train usage of test management tools In UAT, manage change control process, review signoff by UAT team.
●Knowledge of concepts of Android and iOS O/S.
●Implementation of quality processes, part of Center of excellence in setting benchmark for new QA process.
●Involved in forecasting work, planning, allocating resources per estimations and schedule through creation of Work break down structure.
Technical Skills
Languages
Knowledge of C, C++,Scripts
OS
Windows 2k, XP Professional, Unix
Databases
MS-SQL 2008, Oracle 11i
Defect Management Tool
PVCS Tracker, Mercury Quality Center, TeamForge, Jira, Rally
Data migration tools
IBM Data Stage, Cognos, Informatica, Ultra-Edit
Automation Tools
Knowledge of QTP, Selenium
Certifications
CMST (Certified Manager in Software Testing)
Jul 2010
CSTE (Certified Software Test Engineer)
Dec 2008
ISTQB Certification (Foundation Level)
Jun 2006
Diploma in ‘Software Testing Tools’ - Systems Domain, Bangalore
Jul 04 - Oct 04
Experience Summary
Quality Analyst/ Data Analyst
C2IT Solutions, Minneapolis
Nov 24th 2014 Till June 11, 2015
Quality Analyst
Collabera, Minneapolis
Sept 2013 – Nov 21st, 2014
Consultant
Cap Gemini, Bangalore
Oct 2010 – Mar, 2013
Quality Analyst
John Deere India Pvt Ltd., Pune
Nov 2007 - Oct 2010
Sr. QA Engineer
Cybage Software Ltd, Pune
Aug 2006 - Nov 2007
Jr. QA Engineer
First Insight Software, Pune
Dec 2005 - Aug 2006
Professional Experience
Company: C2IT Solutions, Bloomington MN, USA
End Client: TCF Bank, Minneapolis
Title/Role: Quality Analyst
Duration: Nov 24, 2014-June 11, 2015
Location: Minneapolis, USA
Project: Retail Lending Business Intelligence
Environment: ETL Testing, reports testing, Oracle 11i DB, Informatica, Ultra-Edit, Toad
Scope:
The Retail Lending Business Intelligence RLBI - was undertaken to provide a single source of information to support improved reporting and analysis within the Retail Lending group. The project is divided into 6 releases. The Data Store was and data mart was created to support generation of 16 reports needed by the Retail Lending group. There were totally 4 data sources coming into RLBI and there are data flowing into 2 downstream applications. The testing involved verifying staging, data store and data mart for initial loads and incremental loads.
●Key Responsibilities
●Analyse requirements using data architecture and source to target mapping documents. Consultants.
●Involved in test estimation, test planning, test preparation, execution and defect tracking.
●Verify ETL mappings within Informatica.
●Responsible for testing obfuscation of data as per business requirements involved with Data Profiling.
●Responsible for testing staging against source files, verify flow to data store and mart tables.
●Verify type 1 and type 2 dimension tables, test dimension bridge tables.
●Participate in defect triage meetings with team and provide inputs for UAT testing.
Company: Collabera technologies, USA
End Client: Wells Fargo, Minneapolis
Title/Role: Team Lead/Quality Analyst
Duration: Sept 2013 till Nov 21st, 2014
Location: Minneapolis, USA
Project: Apptaker on the web, Capital Markets Integrated Environment.
Environment: Database testing, Manual testing, Oracle 11i DB,
Scope:
AOW is a Loan origination system built for the Home Mortgage Consultants and JV Partners and used to Originating and Managing Borrower’s Home Loan Application. The application involves testing and interacting with third party services like Credit Score, Fees, and Decision making through mainframe system and transmission of Loan into a real deal. The project had a release almost every 2 months impacting around 5 to 6 projects.
●
●Key Responsibilities
●Study of requirements – BRD and FSD through interaction and meeting with Business Systems Consultants.
●Involved in test coordination, test planning, test estimation.
●Creation and maintenance of Requirements Traceability matrix ( Through ALM)
●Serve as liaison between Testing team and business Analysts and Development team.
●Create Ambiguity reviews documents for each FSD to track queries, testability of requirements.
●Responsible for verification activities for testing deliverables - Ambiguity review, Test Plan, RTM, Defect Summary report as per testing methodology.
●Track Testing progress for each test cycle on day to day basis and communicate status to respective stakeholders.
●Participate in defect triage meetings with business team and test Coordinators of each of the impacted projects.
Capital Markets Integrated Environment project is to create a single data repository to provide Wells Fargo data needed for processing, modeling, analytics and reporting in Capital Markets. This a multiple release high visibility project as data is taken from 7 upstream systems and consolidated into a single repository. This involves identification and testing for inbound and outbound interfaces between each system with the CMIE database. Testing included validation of new data elements, into CMIE Db, check for data loaded, test new and updated data from Staging to operational DB, and verify domain table descriptions. The goal of system is to track loans that are created and sold and settled with an Investor.
●
●Key Responsibilities
●Study of requirements – BRD and FSD through interaction and meeting with Business Systems Consultants.
●Test domain table data
●Test and verify data sync between old and new database
●Verify intraday loads and data feeds into the warehouse.
Company: Cap Gemini India
End Client: General Motors
Title/Role: Team Lead
Duration: Oct 2011 till March, 2013
Location: Bangalore, India
Project: ETL, Cognos reports and web testing for a manufacturing giant
Environment: Database testing, Manual testing, Oracle 11i DB, Oracle ADF, IBM DataStage ETL Tool, Cognos Reporting tool, UNIX
Scope:
Next Generation Sales Reporting Project is to centralize 9 different sales reporting applications under one common data integration and reporting platform with objective to create data warehouse for the entire data migrated. The old applications are legacy applications and data is transformed through ETL Tool using IBM DataStage. The migrated data loaded in data mart is transformed into Sales reports involving various calculations through Cognos and Tableau. The reports are made available through online web application built on Oracle ADF platform using java and through Blackberry.
●
●Key Responsibilities
●Study of data sharing agreements and creation of ETL test cases using technical specs.
●Worked as Team Lead and Test Coordinator for the test team
●Responsible for Test strategy, Test plan, Manage change request, Requirements Trace-ability matrix.
●Individually worked on creation of reports test cases, testing reports for specification and calculations, KPI’s.
●Responsible for tracking schedule, efforts and progress on day to day basis.
●Worked as a part Business Analyst for web application. Additional responsibilities included creation of use cases, html mockups, assess current system requirements for Reports, maintain, track and incorporate change requests seamlessly in the releases.
●Load source file through Unix scripts, run jobs through DataStage and validate database for various levels – Staging, Common Template, ODS and data mart for ETL.
●Test reports display in Blackberry using the actual device and online mobile testing.
●Test system for functional, system and regression
●Planning the Schedule, Resources Allocation & prioritizing test activities.
●Participation in Sprint Planning, Backlog grooming /Prioritization, Identify Acceptance Criteria from user stories, Conducting Stand ups, Defect management.
●Worked on and lead team automating web application using selenium, continuous integration tool - Jenkins
Company: Cap Gemini India
End Client: Morgan Stanley
Title/Role: Team Lead
Duration: Oct 2010 till May, 2010
Location: Pune, India
Project: ETL, Cognos reports and web testing for a manufacturing giant
Environment: Java, Exari platform, SQL server, Performance Center
Project: Merger & Acquisition Deal document repository for derivatives
Advisory Deal Document Depository is online tool to track deal documents and entitlements posted by organization for its dealings with various Business Units. It is central repository for collecting legal deal documents with Content Workflow management system for deals across regions. There are deals teams accessing DDR with required access. It is tested with Third party tool: Vault and documents are created through Exari tool. The deals are tracked for all merger and Acquisition deals right through different phases.
●
●Key Responsibilities
●Working as Team Lead and Test Coordinator for the test team
●Responsible for chalking Test strategy and Test plan accurately
●Successful delivery of testing projects within tight deadlines.
●Maintain and track Testing status, efforts and schedule on day to day basis
●Responsible for effective resource utilization
●Planning the Schedule, Resources Allocation & prioritizing test activities
●Performance testing, executing scripts through performance center. Worked on Web(http/html) protocol and generate test report with all the measurements and recommendations
●Test reporting on a daily, weekly basis and consolidate results for very release.
●Publish project Metrics to management.
●Worked on creating proof of concept for automating application using selenium.
Company: John Deere Technology, India
End Client John Deere
Title/Role: Team Lead/Business Analyst
Duration: Nov 2007 to Oct 15, 2010
Location: Pune, India
Project: John Deere Credit Corrective action
Environment: Black Box testing on Java environment, SQL server
Scope
John Deere Credit Corrective action is an Enterprise web based tool to manage Credit revolving plan and payments for New Purchase on Existing Amount Financed for approved John Deere Credit Account. It enables Corrective Action Process for replacements costs for correcting critical or major severity rated problems that occur during the manufacture, assembly and customer use of Deere products. Data migration was tested for migration from Third party database to Deere database.
JDQPS – John Deere Quality Production System is designed to enable shift from paper to application software to control and quantify, approve production mechanism. The project began with the only input of scanned paper documents used on the factory floor of JD. Task involved deep study of identification of users, secondary players, input fields and workflows. Worked with factory head to flesh out the functionality through mock ups and constant reviews.
●Key Responsibilities
●
●Acted as Business analyst, created use cases by studying existing project.
●Identify system actors, users, access groups.
●Succesfully created functionality for JDQPS ( quality process system) .Became one of the first BA/QA in John Deere India facility to implement working software.
●Worked with cross functional teams – Suppliers, Inventory, Factory personnel, HR to gather requirements and develop use cases.
●Point of Contact between Business and development Team for requirements understanding.
●Led a team of different sizes ranging between 4 and 10
●Responsible for Test plan, Test Strategy, Test Estimations, track planned and actual schedule.
●Co-ordination between onsite and offshore testing teams.
●Worked on SOAP REST html http and external data source testing.
●Worked with test teams to set up Test Processes, develop templates.
Company: Cybage Software India Pvt Ltd
End Client: HSBC Global Technology
Title/Role: Sr.QA Engineer
Duration: Aug 2006 to Nov 2007
Location: Pune, India
Project: Personal Internet banking (PIB) (For HSBC Global Technology)
Environment: Integration testing on Java, DB2 8.0, IE 6.0, Mozilla FireFox 1.5
Scope
PIB is a migration project to shift HSBC account holders to current generation banking. The Users are authenticated as CAM 10, 20 and 30 Users with Security device code. The site was developed for Panama and US customers. The enhancement made was for Issuance of E-Statements or Paper Statements according to the flag set in Database. Conducted testing of Services such as Bill payments, Cheque Book services, Standing Orders, and Transfers to HSBC Accounts. Verified customer information on Mainframe side.
●Key Responsibilities
●Analyze requirements and Mock ups.
●Make Test Plan, Testing Estimations, and Test Cases as per requirements.
●Responsible for Unit level testing, performed regression & System testing.
●Worked on testing functional web service tests using SOAPUI
●Preparation of Bug Status report. (Test Management Tool: Quality Center)
Company: Cybage Software India Private Ltd
End Client: HSBC Global Technology
Title/Role: Senior QA Engineer
Duration: Aug 2006 to Nov 2007
Location: Pune, India
Project: Electronic payments (Part of GMG: HSBC Global technology)
Environment: Integration testing on J2EE environment, IBM MQ, DB2
Scope:
Electronic payments enhancement consisted of changes made to Group Messaging gateway message. Functionality for the following being retested: Payments through HSBCNet, Inter account transfers, Priority Payments with RTGS and NEFT, Electronic Cheque payments
Education
Master of Commerce, Pune University
2004
Bachelor of Commerce, Pune University
2002
HSC, Madras Matriculation Board
1997
SSC, Madras Matriculation Board
1995
Contact this candidate