Ketaki Gatne
Sammamish,WA
Summary
Over 7 years of work experience as a Software Developer / Business Analyst and Reporting Team Lead, aspiring to re-enter the workforce after a voluntary caregiving break. Specialized in Oracle SQL and PL/SQL and ERP implementations of Financials, Supply Chain, Manufacturing and Service modules for large and medium-scale businesses. As Tech-Consultant and Programmer/Business Analyst, worked on Business Requirement Definition (BRDs), Application Design and Development (SDLC), Performance Tuning (Optimization) and software implementation rollouts (Live-site Support).
Looking forward to working in the Business Intelligence / Data Analysis / Databases fields.
Overview
7
7
years of professional experience
Work History
Oracle SW Developer / BA / Reporting Team Lead
WORTHINGTON INDUSTRIES
Columbus, Ohio
07.2005 - 12.2006
- Responsible for supporting Oracle ERP implementation for Finance and Manufacturing modules including Order-Management, Supply-Chain, Accounts-Receivable (AR), General Ledger (GL) and Bill-of-Materials (BOM) systems
- Worked with cross-functional business leads to analyze existing systems and capture user-stories and business requirements (BRDs)
- Developed high-level designs and technical specifications for reviews with business stakeholders.
- Reviewed project requirements to identify customer expectations and resources needed to meet goals.
- Was responsible for code development, testing, and production rollouts of the new Oracle modules.
- Developed BI Reports and User Training guides, and participated in user training workshops with end-users of the product.
- Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
- Technologies Used - Oracle EBS, SQL, PL/SQL, Reports, Toad, SQL Navigator
Oracle Tech Consultant - Software Developer / BA
ANCHOR HOCKING
Lancaster, Ohio
01.2005 - 06.2005
- Worked on the Oracle ERP implementations of modules for Financials (Accounts Receivable, Accounts Payable and Order Management)
- Responsible for analyzing business requirements and developing technical design
- Worked on application development, unit testing and implementation of the new systems.
- Technologies Used - Oracle EBS, SQL, PL/SQL, Reports, Toad, SQL Navigator
Oracle Business Analyst, Reporting Team Lead
SAFELITE GLASS CORP
Columbus, Ohio
05.2004 - 12.2004
- Responsible for supporting Inventory and Order Management Systems.
- Responsible for gathering requirements, defining tech specs, and building detailed design documents for various Finance and SCM related modules, including Inventory, Purchasing, Order Management, General Ledger, Accounts Payables, and Receivables.
- Worked as a liaison between the Business heads and led the BI Reporting team to develop precise and helpful metrics as required by the business users.
- Designed test plans, scenarios, scripts, cases, and results matrices to validate system functionality.
- Provided technical support during user acceptance testing cycles.
- Technologies Used - Oracle EBS, SQL, PL/SQL, Reports, Toad, SQL Navigator
Intern/Programmer & Business Analyst
CUMMINS INC
Pune, India
07.1999 - 12.2003
- Worked in the Tools department to help develop the Tool Crib Management system.
- Worked as a programmer/analyst supporting the payroll function and transitioning to the Oracle implementation of the SCM and Manufacturing functions.
- Identified needs of customers promptly and efficiently.
- Collaborated with stakeholders across departments to define requirements for new projects.
- Monitored project timelines and budgets by tracking milestones, deliverables, tasks.
- Presented complex technical concepts in clear manner suitable for non-technical audiences.
- Organized client meetings to provide project updates.
- Developed new web-based MIS systems for internal customers and Cummins dealerships across the country.
- Primarily responsible for building functionalities and customization in Oracle Service, Oracle Order Entry, SCM, Bill-Of-Material, and WIP modules.
- Designed test plans, scenarios, scripts, cases, and results matrices to validate system functionality.
- Received Chairman's Award for Technical Excellence.
- Technical Skills used: Oracle EBS, SQL, PL/SQL, Reports, Toad, SQL Navigator, FTP.
Education
M.S. in Computer Science -
University of Pune
Pune, India01.2000
B.S. in Computer Science -
University of Pune
Pune, India01.1998
Skills
- ORACLE APPLICATIONS 11i
- 11x Modules (Purchasing, Order Management, Accounts Receivable, General Ledger, Inventory and Purchasing, Service, Bill-Of-Materials)
- ORACLE (SQL AND PL/SQL) 12C, 9I, 8I, Transact SQL, SQL SERVER
- DEVELOPER REPORTS 6I, 6, 25 / FORMS 6I, 6,45
- SQL NAVIGATOR
- TOAD
- SQL TUNING
- SQL DATA LOADER
- CRYSTAL REPORTS
- MS EXCEL
- MS OFFICE SUITE
- FTP
- SQL mastery
- Python Programming
- Requirements Gathering
- Process Documentation
Retraining
- Oracle Certified SQL 12C Associate (OCA) – Oracle University, 10/2023
- Python Certified Programmer – PCEP – Python Institute, 09/2024
- Power BI Data Analyst Associate – Microsoft, 10/2024
- EDX Verified Certificate in Transact SQL, 08/2022
Languages
English
Native/ Bilingual
Hindi
Native/ Bilingual
Timeline
Oracle SW Developer / BA / Reporting Team Lead
WORTHINGTON INDUSTRIES
07.2005 - 12.2006
Oracle Tech Consultant - Software Developer / BA
ANCHOR HOCKING
01.2005 - 06.2005
Oracle Business Analyst, Reporting Team Lead
SAFELITE GLASS CORP
05.2004 - 12.2004
Intern/Programmer & Business Analyst
CUMMINS INC
07.1999 - 12.2003
M.S. in Computer Science -
University of Pune
B.S. in Computer Science -
University of Pune
Similar Profiles
Jimmie Brown JrJimmie Brown Jr
Team Lead at Worthington IndustriesTeam Lead at Worthington Industries
Isaac BaddohIsaac Baddoh
Material Handler at Worthington Industries IncMaterial Handler at Worthington Industries Inc
Tyler MohlerTyler Mohler
Forklift Operator at Worthington Industries IncForklift Operator at Worthington Industries Inc