Printing tool Download PDF

Souradip Pal

Technical Specialist


Jan 2012Present

Application Cluster Lead / MACS | Client : Sanofi

Cognizant Technology

The cluster I am working for is a large scale application support, maintenance and development project for a leading pharmaceutical company named Sanofi. As an application cluster lead, I am supporting more than 20 applications. Most applications within my scope are very complex in nature as due to its interface with multiple applications and synchronization of business critical research data in the R&D space. There are multiple technologies involved like ETL-Informatica and TIBCO. Most of these applications are event driven or are daily batch load. Various TIBCO features like Business Works, Business Events, EMS and RDV bus are used for data synchronization. For Informatica, it is normally a daily ETL process and my responsibility is to monitor ETL loads and to find out data integrity issues. I also help the clients to build data checking tool in order to identify ETL load issues.


  • Support critical applications in R&D portfolio, which does sensitive Chemistry, Biology and analytical data synchronization
  • In-depth technical analysis in Informatica and TIBCO along with providing fix (data or code)
  • Proposing bug fixes for Informatica mapping issues
  • Proposing bug fixes for TIBCO issues
  • Creating SQL scripts for data checking for DW tool
  • Coordinating with offshore team and helping them with ticket resolution/incident management in PROMISE (BMC Remedy)
  • Leading the 20 research based application for L2 support
  • Coordinating development activities for the applications
  • Coordinating with clients for requirements gathering and understanding the need for enhancement work
  • Providing CSI to clients, to improve the process and application functions
  • Client management and pursuits for other projects onsite 

Key Contribution(s):

I have automated many processes including the data validation check for R&D data warehousing application

Apr 2010Jan 2012

Database Lead | Client : Forest Labs

Cognizant Technology

The project required conversion of legacy clinical data to CDISC-SDTM v3.1.2 format for leading pharmaceutical company Forest Labs. This was an end to end process where I analyzed the clinical data and convert the same to FDA submission ready CDISC-SDTM v3.1.2 format. The data was delivered to cognizant in SAS datasets format.  The project activities also involved automation of certain features of the in-house CDISC-Gateway tool used for study migration. The GUI of the tool is built in JAVA and the backend is Oracle 10g. There were existing processes like deriving certain fields, which were manually populated. My aim was to enhance the tool, that would populate those fields and automate the key areas. Maintenance and database backup, database administrative task and performing the monitoring activities on the database were also part of my key responsibility. My other responsibilities were to write shell scripts for data import from csv, xls and flat files to oracle database through UNIX cron jobs.


  • Coordinating with Cognizant internal functional team for requirement gathering
  • Design, development and unit testing of the enhancements using PL/SQL
  • Analyzing legacy data and performing the data conversion to SDTM standards
  • Converting oracle data to SAS datasets using Base SAS
  • Developing new report programs for clinical data transformation using PL/SQL
  • Administration and maintenance of Oracle 10g database. This also includes taking daily and weekly backups
  • Writing shell scripts in UNIX for data import jobs
  • Performance tuning suggestions for database through query optimization and code tuning

Key Contribution(s):

Improved the coding reusability, through modular approach. Re-designed number of procedures from performance point of view

Jun 2008Apr 2010

Database Developer | Client : United Technologies

Wipro Technologies

The project was to develop and maintain a HR application (ESS) for an USA based client UTC (United Technologies Company). ESS was used by all divisions of UTC as a Human Resource Management System and it comprises of around 30 different modules of sub application like ESP (Employee Scholarship Program), EXECAPP (Executive Appointment), PFT (Performance Feedback Tool), etc.. The technology behind the application was Oracle Web Applications, which uses PL/SQL. The mechanism behind Oracle Web Application was to generate HTML pages using Oracle predefined PL/SQL packages. These predefined packages were invoked from procedures and functions. On submission, these procedures and functions get submitted to OAS (Oracle Application Server) and dynamically generate the HTML pages. Also ESS had two databases, production and reporting.  Replication used to happen between these two DBs, using nightly batch jobs or through materialized views. The project was to develop new applications as well as the support and maintenance of the existing application.


  • Coordinating with clients for requirements understanding for large enhancement work (SR). I was also involved in analysis of small bug fixes (PR)
  • Design, development and unit testing of SR’s and PR’s
  • Performance tuning suggestions for database through query optimization and code tuning

Key Contribution(s):

  • Worked on development of ESP Reporting, which is a nightly batch cycle to replicate the data from production database to reporting database for one module of ESS (i.e. ESP)
  • Worked as a developer, in the development phase of module W4, which is built using ASP.NET and VB.NET. My role involved designing and developing the interface between ESS and external payroll software. W4 is an application which is used for online filling and submission of USA tax forms
  • Improved 80% of the performance of the Report Builder application, which generate reports from the production database
  • Improved application response time by merging ‘Union’ queries into a single query by introducing ‘OR’ clause, and using session specific global temporary tables

Aug 2007Jun 2008

Database Developer | Client : Continental AG

Wipro Technologies

This project was related to migration of CBS3 application.The CBS3 application was used by the R&D department of Continental AG (Tires Division), Germany to control the compounding and mixing processes in all plants for tire manufacturing. The application runs independently in 7 Continental Tire plants across Europe. The front-end of the application was PowerBuilder 9.0 and the back-end was Sybase.  The seven independent databases are distributed over seven different plants, each implemented with different versions of Sybase. While most of the implemented databases share similar characteristics in terms of objects and data, each of them had their own unique objects. They interact with plant specific interfaces, ranging from legacy mainframe applications to SAP based applications. The central R&D database send data to the plant databases using Sybase Replication Server. The platform was either IBM AIX or HP Open VMS, which varies from plant to plant.  The project was to centralize seven databases with different versions into a single ASE 15(target) database and to enable the CBS3 application in order to connect to the centralized database.


  • Identifying and modifying the physical and logical data model as and when needed, for the purpose of centralization of the databases
  • Object migration from source databases to centralized target database
  • Bulk loading and merging of data from seven different source databases to the centralized target database
  • Identifying and cleansing duplicate data residing in source databases while merging
  • Identifying and modifying stored procedures to facilitate execution in centralized environment
  • Modifying plant specific interfaces to interact with the centralized database

Key Contribution(s):

Automated the process of weekly data by refreshing them from different productions to centralized database for development and testing purposes


Jul 2003Jul 2007

Bachelor of Technology

Bengal Institute of Technology / W.B.U.T.

Computer Science and Engineering

May 2001May 2003

Higher Secondary (12th)

Baranagar Narendranath Vidyamandir / W.B.C.H.S.E.


May 1991May 2001

Secondary (10th)

Baranagar Narendranath Vidyamandir / W.B.S.E.




Oracle Certified Associate


PL/SQL Developer


Oracle 10g Administration Workshop I


Oracle DBA


Cognizant Certified Professional


Life sciences L0 certification



  • Super Hero Award by Cognizant France
  • Feather in My Cap Award by Wipro India