Sanjeev Kathawate work email
- Valid
- Valid
Sanjeev Kathawate personal email
• Over 11 years of IT experience in all aspects of System Development Life Cycle (SDLC) with significant expertise in Business Analysis, Data Analysis, Data Testing, Data Migration, ETL validation, Oracle database design and Development.• Worked in Data Migration projects, Data Retention, Data warehouse, database Upgrade and Reporting projects.• Extensive experience in working mission critical applications projects, 24X7 Onsite-Offshore model and a global delivery model.• Managing, coordinating, planning and executing Data warehouse projects.• Extensive experience as ETL Test Lead and QA analyst in co-coordinating with ETL development team, Report development teams such as OBIEE, BO, Tableau and custom BI tools.• Proficient in creating Test Plan, Test strategy, Test Calendar, Test cases and Test Scenarios based on business requirement documentations, technical documents and source to target documents.• Extensive experience in Integration testing, Regression Testing, System Testing, UAT Testing and Performance Testing on enterprise wide applications• Created Test data covering all the possible scenarios for data warehousing and BI projects.• Expertise in writing and executing complex and advanced SQL queries• Good architectural experience in dimensional modeling.• Expertise in Software change management processes• Worked in Agile/Scrum methodology and waterfall models.• Experience in administering HP Quality Center, ALM and Microsoft TFS• Experience in working with Data Modeling tool like Erwin, designing Star Schema and Snowflake Schemas.• Experience in Data masking techniques.• Excellent Interpersonal skills, Ability to Manage and deliver results on multiple tasks by effectively managing time and priority constraints. Able to work within a team as well as independently with problem-solving and trouble-shooting capabilities.
-
Qa EngineerCitiTampa, Fl, Us
-
Qa EngineerAvantax Jan 2021 - PresentDallas, Texas, Us -
Etl Test LeadEcova May 2016 - PresentSpokane, Wa, Us• Participated in daily stand-up, project Sprint Planning and story pointing, Refinement and Retro sessions.• Developed test plans and strategies based on system requirements and design documentation.• Define the scope, test plan, test strategy, and approach for testing.• Worked closely with ETL developers and Business Analyst in understanding the dataflow, Source to Target documents and wrote SQL queries for data validation.• Collaborated with Product Owner and translated the inputs into testable requirements• Created Test data with all possible scenarios.• Tested data warehouse components, data marts, testing of dimension and fact tables• Validated file archival process as per enterprise policy.• Tested data warehouse components, data marts, testing of Dimension and Fact tables.• Worked closely with BI engineers in testing the complex reports.• Identified and analyzed system defects, data issues and reported to development teams with detailed analysis for quick turnaround.• Validated inbound data from various source systems and reported data quality issues with detailed analysis.• Provisioned test environments that accurately represent the integrated systems under test• Lead the regression testing and end to end testing.• Collaborated effectively with remote development and testing resources -
Sr Data Warehouse AnalystCollaborative Consulting Jan 2016 - May 2016Burlington, Ma, Us• Participated in daily stand-up, project Sprint Planning, Refinement and Retro sessions.• Detailed analysis of Registry of Motor Vehicles’ (RMV) Automated License and Registration System (ALARS) IDMS database.• Prepared data dictionary along with data analysts.• Define the scope, test plan, test strategy, and approach for testing.• Validated the source system data with the staging data using SQL scripts.• Cross validated data files data against target table data.• Created Test data covering all the possible scenarios.• Tested historical data migration process from ALARS database to new Oracle database.• Tested components, data marts, testing of dimension and fact tables• Developed detailed test cases and test scripts to validate data for duplication.• Validated Informatica mappings with SCD type 2 and SCD type 3 dimension tables.• Presented Data testing strategy to MassDOT officials.• Prepared detailed analysis on data quality issues, duplicate issues with MassDOT officials.• Developed test scripts to validate every transformation of ETL.• Developed data cleaning scripts using SQL and PL/SQL languages.• Validated Tableau reports -
Software Qa AnalystPnc Nov 2012 - Dec 2015Pittsburgh, Pennsylvania, Us• Implemented Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) along with third party Oracle development team.• Liaison between third party Oracle development team and testing team on all data related queries and defect resolution.• Define the scope, test plan, test strategy, and approach for testing.• Tested OFSAA platform upgrade from 7.2.10 to 7.3.4 BASELL III compliance.• Responsible for OFSAA binary installation.• Tested User provisioning automation in OFSAA.• Administrator for OFSAA platform such as new user and group creation there group mapping, new batch creation, configuring new Information domain, and segment.• Tested OBIEE reports• Tested components, data marts, testing of dimension and fact tables• Helped functional testers in writing custom OBIEE reports using Answers.• Worked closely with Oracle team in resolving SRs.• Tested DeFi, Data Integrator framework, Run rule framework, Business Metadata management on OFSAA platform.• Tested customized OFSAA Data model as per business requirements using Erwin tool• Developed detailed test execution plan, maintained test strategy document and testing calendar.• Conducted in depth two stage data integration testing – Data integration from Banking system to OFSAA model using Informatica and OFSAA Table to Table (T2T) Frame work.• Developed test scripts, coached offshore testing team on effective test planning, test execution and defect reporting.• Issue tracker maintenance and maintaining all defects in Application Lifecycle Management (ALM).• Developed data cleaning scripts using SQL DML scripts.• Tested Data Masking scripts to hide customer sensitive information. -
Data Analyst / Qa LeadPnc Jan 2012 - Oct 2012Pittsburgh, Pennsylvania, Us• Worked with Senior Business Analysts and business users in understanding the business requirements, interacted with source system owners for data requirements in Office of Performance – Sales Reporting project.• Define the scope, test plan, test strategy, and approach for testing• Organized 8 workshops with up to 6 Subject Matter Experts (SMEs) and various source system owners to obtain domain level information.• Prepared ad-hoc reports, scorecards and graphs/charts to PNC’s senior management.• Worked with the BI developers in testing OBIEE reports.• Tested components, data marts, testing of dimension and fact tables• Tested OBIEE write back capability.• Developed data dictionary for data integration team.• Participated in data modelling activity with Data modeler in the design of snowflake schema.• Converted all historical data from complex Excel files for system integration.• Tested several UNIX shell scripts for File archiving process and also PL/SQL stored procedures.• Effectively used Microsoft Excel macros, SQL, PL/SQL scripts for data cleaning, data formatting, and data reconciliation.• Maintained testing strategy document and SQL test scripts for data validation.• Developed code migration document.
-
Etl Test LeadPnc Mar 2011 - Dec 2011Pittsburgh, Pennsylvania, Us• Implemented Oracle HR Analytics application for PNC bank along with third party development team, OBIEE reports development team and offshore testing team.• Define the scope, test plan, test strategy, and approach for testing• Involved in data migration, moving HR analytics data from PeopleSoft to Oracle.• Analyzed and collected source system information, identified system interfaces, and developed the data dictionary.• Tested components, data marts, testing of dimension and fact tables• Performed data analysis on third party systems and its compatibility to Oracle system.• Interacted with business analysts and developers in data validation strategy.• Developed and maintained test strategy document and test plan.• Developed complex SQL scripts for data validation.• Worked closely with offshore testing team on effective test planning, test execution and defect reporting.• Conducted daily calls with offshore testing team and maintained all defects and resolutions in HP Quality Center.
-
Data EngineerPnc Apr 2010 - Feb 2011Pittsburgh, Pennsylvania, Us• Developed clusters of Oracle datamarts for PNC bank’s Enterprise Information Management initiative.• Analyzed business requirements, identified system interfaces, and created data dictionary and data integration plan.• Did a requirement analysis to develop use cases, activity and sequence diagrams. • Managed and tracked change control process of requirements and design changes, documented the changes and issues and their impact on the system design and delivery. • Developed Source to Target Mapping documents and data flow diagrams.• Prepared Test plan and Test cases• Worked on the impact analysis, identified the gaps between tools, and helped developing new ETLs to resolve gaps and move data efficiently.
-
Systems Analyst - Data Migration ConsultantGe Capital Oct 2009 - Mar 2010Norwalk, Ct, Us• Designed Oracle Datamart for data retention of CITI Info-lease system for GE Commercial finance.• Conducted workshops with CITI Info-lease system SMEs in understanding the system for data migration.• Conducted workshops with to understand the federal requirements for data retention. • Documented the data retention strategy as per the federal government guidelines.• In-depth data analysis of non-Relational Database Management System (RDBMS).• Developed SQL scripts and reports for data re-conciliation.• Prepared code migration document.• Obtained IT sign-off on data migration and source system shutdown -
Oracle Developer/Production Support ExecutiveGe Capital Jul 2006 - Oct 2009Norwalk, Ct, UsGlobal Oracle Applications: GE Commercial FinanceProduction support Oracle Applications 11i Financials (GL, AP, FA, AR, and CM Modules)System Administrator for Oracle applications 11i.Developed inbound interfaces for Oracle Account Payables moduleDeveloped outbound interfaces and data extraction scripts for Oracle GL, CashManagement and Account receivables moduleMigrated the data using Data CleanDaily monitoring of Data loads and publishing the statusDaily analysis and handling of Interface rejections on daily basis
-
Software TraineeTata Consultancy Services Apr 2005 - Jun 2006Mumbai, Maharashtra, InDevelopment training on Oracle Forms and ReportsDatabase Testing the developed codes.Development of crystal reports and statement reports using Business Objects.Data Integration methodologies.SQL, PL/SQL.Ensuring the internal quality processes.
Sanjeev Kathawate Skills
Sanjeev Kathawate Education Details
-
Visvesvaraya Technological UniversityMechanical Engineering
Frequently Asked Questions about Sanjeev Kathawate
What company does Sanjeev Kathawate work for?
Sanjeev Kathawate works for Citi
What is Sanjeev Kathawate's role at the current company?
Sanjeev Kathawate's current role is QA Engineer.
What is Sanjeev Kathawate's email address?
Sanjeev Kathawate's email address is sa****@****ght.com
What schools did Sanjeev Kathawate attend?
Sanjeev Kathawate attended Visvesvaraya Technological University.
What skills is Sanjeev Kathawate known for?
Sanjeev Kathawate has skills like Pl/sql, Sdlc, Requirements Analysis, Oracle, Business Analysis, Sql, Agile Methodologies, Business Intelligence, Oracle Applications, Etl, Etl Testing, Software Development Life Cycle.
Who are Sanjeev Kathawate's colleagues?
Sanjeev Kathawate's colleagues are Karen Mendez, Bắc Trần, Natalie Abatemarco, Anabel Ruiz, Alejandra Quesada Guerrero, Map, Andres Ros, Kang Seung-Joo Alex.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial