About

Kapil Vasani is a highly experienced Senior Database Specialist with over 12.6 years of expertise in IT industry. His professional background includes Analysis, Design, Development, Implementation, and Management of projects, with a focus on Oracle (Sql, PL/SQL) with Oracle 9i/10g/11g/12c, DB2 (SQL, PLSQL), and SAP HANA development. Kapil is proficient in translating business requirements into the creation of Database Objects, writing Simple and ComplexSQLs, PL/SQL Functions, Procedures, Packages, and creation of Oracle Objects such as Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables, Collections, Normalization, Database Design, creating Indexes, Nested queries, Analytical Queries, and Date warehousing concepts. Kapil has hands-on experience in the development of different ERP modules, Design & Development of Electronic Brokerage, credit unions, payments, Smart Clouds, and Telecom System. These applications are developed under Oracle SQL, PL/SQL Programming, DB2 DBA, SAP HANA, and Crystal Reports. He also has good experience in Performance Analysis and SQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution plan, Hints, TK- Prof, AWR reports, and Explain Plan. Kapil has worked with technical, implementation team, customer support, and business teams in finding resolutions to critical issues. He has traveled onsite to work on projects, and has experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. He is highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on databases. Kapil is currently working as a Senior Database Specialist at Persistent Systems, and has previously worked as a Senior Software Engineer at Fiserv and a Program Analyst at Syntel. He holds a Bachelor of Engineering degree from Saraswati Vidyalaya Nagpur. Kapil's tech stack includes SQL, test, Normalization, and Software Engineering, and he has relevant experience of 17.62 years.