Project Manager Sql Server

Pradip Chatterjee

Email: *********@********.***

Address: ** ***** *****

City: Edison

State: NJ

Zip: 08820

Country: USA

Phone: 732-***-****

Skill Level: Senior

Salary Range: $90,000

Willing to Relocate

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

PRADIP CHATTERJEE

Tel: 732-***-**** (Cell) /732-***-**** (Home), 88 Kelly Drive Edison, NJ-08820, Email: *****@*******.***

EXPERIENCE SUMMARY:

* Total IT Experience of over 12 Years including 10 Years of US Experience.

* IT experience in complete Software Development Life Cycle (SDLC) including requirement gathering, development, unit testing, implementation, integration, QA support, deployment, documentation of web based applications..

* Lead Developer (Working for 5 Years) for requirements study, technical analysis and finalization of design documents and development activities.

* Experience in C# based customization for complex requirement implementation.

* Experience in working with teams in US and offshore development teams in India as lead developer.

* Experience in MS SQL Server (2005/2008) and skilled at developing T-SQL queries, optimizing query performance, stored procedures, triggers, functions and other database objects.

* Customize web based CRM product to meet client requirements. Responsible for integration of various modules developed at offshore

* Experience in Production support to analyze and resolve issues raised by tier 1 and tier 2 help desk

* Experience in Microsoft .NET technologies including ASP.NET, C Sharp, ADO.NET, .NET Framework

* Knowledge in xcode and object-c coding for IOS development.

* Working knowledge of other tools such as. Visual Studio 2006, Visio, Visual Interdev.

* Experience in Pharmaceutical sales force domain, CRM Solution.

* Possess excellent communication and interpersonal skills, positive attitude, willing to learn and adapt. Quick learner.

TECHNICAL EXPERIENCE:

* Databases: MS SQL Server 2005/2008, MS Access, Oracle 10gi

* Development Tools: Visual Studio .NET, Visual Source Safe, xcode (for ios development), SCM, Visual Interdev, ADO.Net.

* Software Engineering Methodologies/Tools/Technologies: .NET Framework 3.5 / 4.0, cocoa framework (for ios development), COM/DCOM, MS Visio, MS Visual SourceSafe, xcode 4.5.

* Frameworks/Web Technologies: ASP.NET, ASP, ActiveX, IIS, JavaScript, VBScripts, HTML, CSS, XML, XSLT, AJAX, Microsoft office, C++, Visual C++ 6.0, embedded Visual C++ 3.0 etc.

* Enterprise Servers: MS SQL Server, Windows Application Server.

WORK EXPERIENCE

Cegedim Dendrite - Bedminster, NJ 04/2002- Till Date

Mobile Intelligence(tm) is a comprehensive, Web-enabled and iPad based solution that improves communications, optimizes promotional activities, and streamlines new product launches for life science companies. The application enables different types of users to access the information most useful to them. It enables sales forces to access product information, evaluate competitors, and record customer and prospect data. Customization of the product for various clients involves extensive knowledge of C#, Oracle / sql server stored procedures, object-c for iOS and virtual machines.

Developer / Lead Developer.

Responsible for Design, Development, documentation, co-ordination with offshore development and testing teams, customization based on client requirements, integration of customized components, unit testing, QA Support, deployment and production support.

Key Activities Performed

* Worked with Client, Project manager, Business Analyst and corporate IT for requirement gathering and prepare high level and low level design document.

* Responsible for Development task allocation for development team members both onshore in US and Offshore teams. .

* Responsible for providing cost effective solution and work a rounds for complex client requirements. Customization of complex modules involving core framework changes .Business rule implementation using C# and database end stored procedure / trigger creation/modification..

* Responsible for monitoring project progress and reallocation of work load based on project progress status.

* Responsible for integration of all developers customization to main module.

* Offline enabling the product for Reps to access and perform daily activities on laptops even when not connected to internet.

* Responsible for Install shield based package creation for deployment of developed package to Production server.

* Responsible for running Unit test and integration test for all modules.

* Responsible for Quality Assurance team support and defect fixing based on the QA Cycle.

* Responsible for Deployment to production.

* Responsible for technical support for Role out of products at respective role out places of client.

* Responsible for Post deployment defect analysis and fixing of defects and deploying to production.

Worked on implementing the solution for major clients such as:

Otsuka Pharmaceuticals, Pfizer Canada, Bristol-Myers Squibb, UCB Pharmaceuticals. Proctor & Gamble, Allergen Pharmaceuticals, Sanofi Pharmaceuticals, Merck Pharmaceuticals.

Long term Care group-St Louise, MO. 08/2001-3/2002

Elderly Long term benefit services application mainly keeps track on List of benefits customers applied for, Premium paid by Customer or Employer and display Company expenditure for Care and protect for over pay during Benefit claims. It is based on Visual Basic Access, Sql Server back end and C++ based module for report Tracking.

Developer

Responsible for Module development based on In house requirement.

* Implementation of User entered duplicity checking and over paid alarm was done through Visual Basic.

* Implementation of database triggers / store procedure for data manipulation and storing in different tables based on checking system output.

* Responsible for accessing Pre implemented COM based function for implementation in main module executes COM Interop.

* File based searching mechanism implemented in C++ for file based searching of Flat files created by LTCG own tracking system with specific search criteria.

IBM / AT & T, Middletown NJ 01/2001-07/2002

BMP (Business Maintenance Platform) Release 16.0 provides a single service database in support of all provisioning and maintenance work center activities. BMP also provides data quality control by means of an automated loop back to engineering to correct critical data elements

System Analyst

Responsible for Unit testing and defect Identification and fixing for newly developed product. Functionality enhancement for reporting services,

* Worked mainly on report server as major on ticket server for defect tracking

* Implementation and testing of Data validation for field to be displayed w.r.t closed, active and inactive tickets

* Implementation and testing of Data validation of user entered data on the user interface screen

* Modification of error tracking system based on C++ based development tool.

* Reposting services functionality modification based on C++ and STL dynamic array (vector class)

* Project Documentation..

Fidelity Investment, Merrimack, NH 05/2000-12/2001

Beni-soft application is Insurance eligibility tracking system is a Visual Basic system and flat File used for data storage. People Information stored in Oracle based tables.

Developer

Responsible for implementation of additional feature based on Visual Basic coding and Oracle Database PL/SQL stored procedure.

* Validation Implementation for duplication. (Based on SSN), and if any, information stored in History file.

* Dependency and Plan wise Data Comparison for customer between Oracle databases from redundant source. In case of discrepancy dump to another flat file.

* Calculate monthly rate of cost of employer for a particular beneficiary based on service status (like active or retired, age, year of service, number of dependent etc.)

* Creating report for rate discrepancy for employer cost, cost carried by employee and difference between the two.

Ceridian Benefits Services, Princeton, New Jersey 10/1999-04/2000

A Qualified Domestic Relations Order (QDRO) Related to Employer`s retirement benefits distribution to other relatives of Employee for situation like divorce based on legal order.

Developer

Web based data stored in Flat files and Information Displayed by VBA (MS Access 2000), consistency was checked using C++ in UNIX and then whole data was migrated in SQL Server.

* Responsible for Analysis of existing system and checking system performance.

* Preparation of Data Flow Diagrams.

* Generation of Program specifications

* Application development based on Visual basic for access 2000, As per requirement document.

* Stored procedure development based on sql server.

* Preparation of software testing plans.

* Defect investigation.

* Acceptance functional testing as per requirement.

* Customer Support.

EDUCATION

University of Calcutta. India

Master of Technology in Applied Physics.

Bachelor in Physics Minor Mathematics

Contact this candidate