Sonali Devaraj

**** ***** **** **. ***** Clara, CA 95051

Cell: 415-***-**** acrzll@r.postjobfree.com LinkedIn

Profile

Highly Motivated Software developer, with over 8 years of hands on work experience in analysis, design, effort estimation, development, implementation and life cycle management for commercial applications

Successfully led teams for over 7 years, in which the team has implemented and developed software for customers like British Telecom and Merck &Co. Inc.

Awarded and recognized for outstanding performance including the prestigious GEM (Going the Extra Mile) award at Cognizant for going above and beyond the assigned responsibilities.

Recognized for excellent communication and leadership skills.

Core Strengths

SDLC

Business Analysis and Requirements gathering

SQL, PL/SQL, MySQL

Data Modeling/Design

Oracle Web Toolkit

Project Management

Oracle 9i/11g

Professional Experience

Cognizant Technology Solutions

Sr. Developer/Team Lead June 2011 – January 2015

Client Description

Merck &Co. Inc. is a global research-driven pharmaceutical company dedicated to putting patients first. It was established in 1891. They discover, develop, manufacture and market vaccines and medicines in over 20 therapeutic categories. The company also devotes extensive efforts to increase access to medicines through far reaching programs that not only donate their medicines but help deliver them to the people who need them. 60,000 employees, the client conducts research at 11 major centers in the United States, Europe, and Japan, manufactures products in 32 facilities and sells products in approximately 150 countries.

Project: Safety and Aggregate Reporting

Client: Merck &Co. Inc.

Duration: Sept 2013 - Dec 2014

Programming Languages: Oracle SQL, PL/SQL

Tools: Toad, Microsoft Excel (VBA Macros)

Description:

Global Pharma Co-vigilance Safety and Aggregate Reporting provide support for the generation of aggregate reports, ad-hoc/custom reports and tailored reports from the data systems. The scope of GPV Safety is to provide timely Safety Update reports, Legacy Aggregate reports.

Roles and Responsibilities:

Coordinating with clients and business architects to understand the business requirements and convert it to technical design.

Writing PL/SQL packages, procedures, functions and other database objects, to support custom report development

Involved in basic performance tuning of queries and in building an Excel tool using VBA Macros in order to automate the execution of a set of reports, which was otherwise a manual and tedious process

Estimating efforts based on custom methods currently in practice in the project, planning and monitoring the delivery according to timelines.

Coordinating everyday with onsite teams for smooth continuation of development tasks, following the Agile method of software development.

Providing development support to ticketing teams, with priority tickets, in debugging and solving issues within timelines.

Maintaining QA documents and coordinating with support teams for related activities

Mentoring juniors

Awards and Appreciations:

Awarded the GEM (Going the Extra Mile) award

Recognized as a valuable team player and equally liked by juniors as a good lead.

Project: MyEvent Compliance System

Client: Merck &Co. Inc.

Duration: March 2013 – Aug 2013

Programming Languages: Oracle SQL, PL/SQL

Tools: PL/SQL Developer

Description:

My Event Compliance System was designed for use by functions of Marketing, Sales, Finance and Compliance, in order to track and manage events between client and healthcare professionals. The system was aimed at catering to compliance issues in Indonesia and Vietnam. The system would improve the efficiency of overall event management process with electronic approval, better tracking, monitoring and in future easily adoptable by other market participations, like Korea.

Roles and Responsibilities

Leading data modeling with the team, including client coordination and gathering desired outcomes to design technical specification.

Proposing alternate ways of implementation, identified gaps and helped bridge the same.

Followed the Agile method of development for developing required database objects, using PL/SQL, to build the backend modules for the application (which had a Java frontend)

Writing PL/SQL packages, procedures, functions, Dynamic SQL, Ref Cursors, Bulk Collections and SQL Loaders

Involved in basic performance tuning of queries

Deploying objects onto different environments

Coordinating with test teams with time to time testing reports and feedbacks

Documenting the database design as a technical article.

Maintaining the knowledge repository of the team, updating with new learnings and sharing required reports with senior management.

Project: Client’s Community Health Assist Scheme

Client: Merck &Co. Inc.

Duration: Sept 2012 – Feb 2013

Programming Languages: MySQL

Version Management: CVS

Tools: Toad for MySQL

Description:

Merck’s Community Health Assist Scheme is used to provide and track the free drug samples distributed by physicians to their patients (Patient part of Community Health Assist Program launched by Singapore government).

Roles and Responsibilities

Lead data modeling with the team, including client coordination

Developed required database objects, using the Agile method of development

Involved in basic performance tuning of queries

Coordinating with Infra and test teams to successfully move changes to PROD and assisted in maintaining test environments.

Maintaining QA documents as required by the project.

Documenting the database design as a technical article.

Awards and Appreciations:

Received appreciation from senior management, for successfully implementing the backend, single handedly.

Project: Client’s EMEA website backend development

Client: Merck &Co. Inc.

Duration: June 2011 – July 2012

Programming Languages: Oracle SQL, PL/SQL

Version Management: CVS

Tools: PL/SQL Developer, SQL*Plus, SQL Loader

Description:

Merck maintains a medical web portal that provides support to millions of doctors across the globe. This has been developed in J2EE environment on Weblogic 8.1 Application Server. Tibco Portal Builder is integrated as content manager for this application. This application is hosted on the Apache Web Server which also does the load balancing job.

The site also hosts small J2EE applications which are used by users across many locations worldwide. These applications involve technologies such as Spring, Hibernate and Ext-JS. The site provides unbiased medical information services to their users, spread worldwide, in 35 countries.

Roles and Responsibilities

End to end database development for the site (Application Support and Maintenance)

Coordinating with multiple internal and external teams to ensure smooth and defect free deliveries.

Proactively created and maintained the code versioning for database modules.

Involved in developing and testing Oracle Stored Procedures, Functions and Packages and performance tuning of queries and also SQL Loader for loading large volumes of data in tables.

Review of code changes and coordinating with Infra team to move changes to PROD

Was responsible for analyzing and solving production issues.

Awards and Appreciations:

Received a ‘Spotlight’ award for being a quick learner and successfully delivering a complex module, within three months of joining the team.

Tech Mahindra Ltd.

Team Lead April 2009- May 2011

Project: QuickQuote

Client: British Telecom

Duration: July 2006 – May 2011

Programming Languages : Oracle SQL, PL/SQL, JavaScript

Tools Used: SQL*Plus, Toad, Bridge Clarify, Borland Star Team, Visual Source Safe, HP QC, Subversion, SQL Navigator

Technologies: Oracle 9i, Oracle 9iAS, JavaScript

Description:

The project involves enhancement and maintenance of a web based budgetary pricing tool for British Telecom – UK. Though a small application, it is a business critical application, used by sales personnel to provide indicative quotes to customers. It was required that the application show accurate quotes for the services requested as order placements and major bids were placed using the pricing displayed by the application.

Client Description

BT is one of the world’s leading communications services companies, serving the needs of customers in the UK and in more than 170 countries worldwide. Their main activities are the provision of fixed-line services, broadband, mobile and TV products and services as well as networked IT services.

In the UK they are a leading communications services provider, selling products and services to consumers, small and medium sized enterprises and the public sector. They also sell wholesale products and services to communications providers in the UK and around the world. Globally, they supply managed networked IT services to multinational corporations, domestic businesses and national and local government organizations.

Roles and Responsibilities

Team Lead and Sr. Developer leading a team with maximum strength of 8

Analyzing and converting the client’s functional requirement into Technical Specs. Involves interaction with Solution Designer and Client

Preparing Component Design and documents related to QA & QC of the project

Proactively created an internal process for the team to follow, which ensured consecutive, successful, defect free deployments, which was also recognized and appreciated by higher management and clients.

Deployments on UAT and maintaining the test environments.

Monitoring the project metrics and Providing effort estimates using Function Point Analysis

Driving and tracking the technical deliveries and reviewing technical artifacts and code

Configuration management (experience with VSS, Borland Starteam and SVN)

Interacting with multiple external teams (test team, design team, deployment and delivery management teams, application support groups and clients)

Monitoring and tracking bridge cases using Bridge Clarify

Writing PL/SQL packages, procedures, functions and other database objects to build and maintain the application (Use of Waterfall methodology and gradually moved to using Agile method of development)

Used Oracle Web Toolkit (OWA) to build the front end web pages and JavaScript to make the pages dynamic

Used XML Parser inbuilt packages of Oracle to parse XML and used UTL_HTTP packages of Oracle to establish interface interaction using XML

Debugging and fixing issues (LIVE as well as test) within given timescales.

Defect management.

Maintaining the database design document.

Managing the project with regards to timelines, audits, task assignment, tracking deliverable keeping in mind the leaves and vacation plans of the team, providing internal reports to management etc.

Awards and appreciations:

Received appreciation mails and ‘Thank You’ e-cards from clients.

Received Pat on Back and Cookies awards for excellent performance.

Received appreciations from senior managers

Recognized as valuable team player and liked by the team as a good lead.

Academic Qualifications

Masters of Science, Software Engineering Dec 2010

Birla Institute of Technology and Sciences University, India CGPA: 8.47/10

Bachelor of Science, Computer Science June 2006

Fergusson College, Pune University, India

Contact this candidate