Anup Chauhan
Clinical Data Programmer at SGS Life Science Services, S.A.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
0
/5.0 / Based on 0 ratingsFilter reviews by:
Experience
-
SGS Life Science Services, S.A.
-
Belgium
-
1 - 100 Employee
-
Clinical Data Programmer
-
Jul 2019 - Present
-
-
-
Infosys
-
India
-
IT System Custom Software Development
-
1 - 100 Employee
-
Technical Analyst
-
Mar 2014 - Present
-
-
Senior System Engineer
-
Sep 2011 - Mar 2014
-
-
System Engineer
-
Jun 2009 - Sep 2011
-
-
-
Proximus
-
Mauritius
-
E-Learning Providers
-
Functional Technical Analyst, Oracle PLSQL Developer
-
Mar 2014 - Feb 2019
o Involved in the continuous enhancements and fixing of production problems. Generated server-side PL/SQL scripts for data manipulation.o Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL to implement business logic.o Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.o Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.o Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.o Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.o Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.o Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.o Worked on SQL*Loader to load data from flat files obtained from various facilities every day.o Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.o Collaborated with product management to design, build and test systems.
-
-
-
BT
-
Belgium
-
Financial Services
-
1 - 100 Employee
-
Oracle PLSQL Developer
-
Dec 2009 - Mar 2014
Worked on a project for British Telecomm (BT) as an Infosys Ltd Employee.Responsibilities Included: - Requirement Gathering. - Design & Development for an Oracle PLSQL based application. - Operational Support for Production Issues. - Defect Analysis and Providing Bug Fixes. - Database Installation, Creation and Maintenance. - Database Performance Tuning. - Warranty Support. Worked on a project for British Telecomm (BT) as an Infosys Ltd Employee.Responsibilities Included: - Requirement Gathering. - Design & Development for an Oracle PLSQL based application. - Operational Support for Production Issues. - Defect Analysis and Providing Bug Fixes. - Database Installation, Creation and Maintenance. - Database Performance Tuning. - Warranty Support.
-
-
Education
-
College of Engineering Roorkee
Bachelor of Technology - BTech, Information Technology -
Kendriya Vidyalaya
+2, Physics, Chemistry and Mathematics -
Masseeh Dilasa School
College Of Engineering Roorkee, Roorkee