Vikrant Patel

Background

About Vikrant Patel

More than 15 years of software industry experience includes Requirement Analysis, Architect, Design, Development, Testing and Implementation including 9 years of Data warehousing projects.• Working for Large Pharmaceutical Companies Johnson & Johnson, UCB, Boehringer Ingelheim, Novartis Europe and Novartis US, Bristol Mayer Squibb.Specialties: • Design and Develop Logical and Physical Data Models using data modeling tools such as ERwin and Microsoft Visio.• Solid credentials with background encompassing for converting Business Requirements into Technical Requirements.• Leading data mart architecture team of onsite and offsite developers, contractors and delegate responsibilities and work coordination.• Highly capable of designing and developing Data Process Flow, Data Mapping, Data Dictionary, ETL processes, Unix/Linux batch processes and Technical Documentation.• Creating project estimation, coordination, strategic planning and end-to-end servicing for development, enhancement and maintenance projects.• Excellent knowledge of industry standard methodologies like Agile, Iterative Software Development Life Cycle, Waterfall, and Rational Unified Process (RUP). • In-depth knowledge about Health Care market and analytics for Pharmaceutical domain including Pharmacy claims, Medical claims (Diagnosis, Procedure), CDM (Hospitable Billing) claims. • Expert in designing, developing and deploying applications using Oracle Technologies such as SQL, PL/SQL, Stored Procedures, Packages, Functions and Unix Shell Script Programming.• Extensively Used Oracle Analytical Functions, Partitioning, Sub partitioning, SQL*Loader, External Tables, SQL PLAN, TKPROF, IOSTATS, VMSTAT, Indexes