Gurucharan Sardesai

• Around 15+ years of strong experience in analysis, design, development, production support and deploying Business solutions using Oracle based Technologies. • Around 8+ years of onsite experience (In USA) as an IT Business Analyst/Lead Programmer (Oracle SQL/PLSQL) with ability to lead teams in the software development industry. • Extensive experience in gathering, analyzing & developing detailed business user requirements, system landscape documentation, reverse-engineering systems and documenting data and process flows. • Strong experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME’s), Development and QA teams. • Strong Programming and Designing Experience in Oracle SQL& PL/SQL, SQL* Loader. • Strong experience in creating database objects like Tables, Views, Indexes, Table partitions etc. • Extensive PL/SQL programming experience in writing packages, procedures, functions, triggers etc. To handle day to day transactions of OLTP systems, batch processes using Unix shell scripts. • Expertise in developing applications using Oracle Forms 12C/11g/10g/9i/6i, Oracle Reports 12C/11g/10g/9i/6i and Oracle database 19C/12c/11g/10g/9i/8i. • Good experience on database migration & applications migrations. • Extensive experience in database modeling, data transformations, conversion and designing integrations between various systems using different methodologies like db-links, SFTP, Middleware ODI and Webservices. • Experience working with the Enterprise and Security Architects to define technology roadmap • Experience in Performance Tuning & Query optimization • Strong technical expertise in providing impact analysis for a new change on the existing system, troubleshooting production issues • Strong Experience in Unit Testing, System Integration testing and working with users during UAT, ensuring any defects reported are prioritized and fixed. • Experience using Requirements Tractability Matrix (RTM), test plans, project administration, defect management, configuration management • Experience working in agile environment and understand concepts of Scrum framework. • Reviewing Change Management/Incident Management for ongoing projects. • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment having detail-oriented and problem-solving skills in the technology arena. • Ability to work individually as well as in a team. Self-motivated and committed person with excellent interpersonal communication skills and willingness to learn new tools, concepts