Project Developer

RUPESH SHINDE

A Technical Specialist, Business Analyst, Project Manager, Team Lead with 10 years of IT experience in Data Warehousing (Clinical Trials, Sales and Marketing, Legal Reporting etc.) for the Pharmaceuticals clients in Life Science domain.

Current Location - New Jersey

Visa Status - H1B

Email Id - **************@*****.***

Contact # - 973-***-****

Executive Summary

Currently working with Cognizant Technology Solutions since Nov, 2007.

Senior Business Analyst / Clinical Trial Management System Expert.

Expertise in Gathering requirements, Analysing business needs & executing projects from initiation to closeout.

Involved in all phases of SDLC from requirements gathering, business case development and maintenance, defining strategic solutions in business needs using, Agile as well as Waterfall Model.

Experienced in Software development life cycle (SDLC) and Software Testing life cycle (STLC)

Experience in Development, Testing and production support for Data Warehousing Projects for Life science industry.

Expert in handling Clinical Trial Management Tools like IMPACT, Optimus etc.

Excellent analytical, problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast paced team environment.

Expertise in creating Documentation including FRS, URS, Test Cases, Test Scripts, final Test Reports and defect reports based on client business, software and interface requirement specifications.

Proficient in understanding business processes / requirements and translating them into technical requirements and test strategies.

Experience in time & resource Estimation, Project Management, project tracking and resource management.

Expert in coding (PLSQL script writing) to move the data from Source to Target as per the business requirements using ETL.

Work with the both project and support teams to understand existing systems and to help troubleshoot, optimize, and tune ETL processes as needed.

Good Knowledge in BI reporting using Cognos, Qlikview etc.

Experienced in creating documentation, providing production support, development and enhancements on oracle (SQL, PLSQL), UNIX and Cognos/Qlikview (BI Tools) projects.

Ability to quickly learn new technologies and implement them.

Undergoing training for AWS, Big Data to seek the opportunity to work on these technologies.

Technical Skills

Certifications

Database: Oracle 11g, 12c

Oracle 8i certification

Reporting Tools: IMPACT, Optimus, Cognos 10, Qlikview 9.2

ORACLE SQL Certified (Iz-007)

Languages: Unix shell scripting, PL\SQL, SQL

Cognos Developer Certification (COG-112)

Documentation Tools : MS Office, MS Excel, MS Power Point, Microsoft Project, PROTON

ITIL Foundation, Six Sigma

Current Project Details

Project : DARWIN IMPACT

Client: Novartis

Industry: Pharmaceutical, GCO Drug Development Solutions Group

Role: Business Analyst

Technology used: IMPACT tool for Clinical Trial Management System, PROTON Testing tool, MS Excel, MS Word etc.

Project Summary:

DARWIN IMPACT - IMPACT Clinical Trial Management System software testing for Novartis Pharmaceutical.

IMPACT is the software developed by 3rd Party for Clinical Trial Management System. This project scope includes the testing of the functionality, configuration and migration of the IMPACT software and its parameters.

ClinAdmin is the Novartis Clinical Trial Administration System. It supports the planning & tracking of all trial phases, management of trial countries, sites & patients, administration of logistical and regulatory information, supports financial processes, triggers payments, tracks trial progress, etc.

Responsibilities: As a BA the responsibilities are as follows:

End to End Project Deliveries

Estimation of Projects, Resource management, Delivery Lead

Create URS/ FRS Documents

Draft Test Scripts for Configuration/ Security / Migration / UAT etc. as per the URS documents.

Coordinate with business for review and finalize the above scripts

Route Configuration scripts for approval from business

Coordinate with testing team for the test script execution.

Time management for the whole UAT phase

Complete Dry runs and UAT

Co-ordinate with end users and train them for UAT

UAT Execution / Defect Management

Post Production Go-Live Support

Previous Projects Details

Sr. No.

Project Name

Client

Role

Industry

Technology Used

1

Enterprise Business Analytics - EBA

Mylan

ETL Team Lead

Pharmaceutical

Oracle PLSQL, UNIX, Cognos, Qlikview

2

Novartis BICC

Novartis

BI Onsite Team Lead

Cognos

3

COMPASS

ETL Team Lead

Oracle PL/SQL Developer, UNIX, Cognos

4

FLM Dashboard ADM Support

ETL Team Lead

5

Report Central ADM

ETL Developer

6

EDNA ( E Data warehouse New Architecture)

ETL Support Team Member

7

RC Process Improvements

ETL Developer

8

Novartis – Report Central Factory

ETL Developer

Other Overall Responsibilities

Responsible for delivery for about 14 applications based on six different countries.

HCM Coordinator ( Manager) for 8 offshore resources

Review of all the offshore deliveries

Handling sales data

Monitoring of end to end ETL jobs to process the data

Handling Break fix and minor enhancements

Process improvements in all the applications

Handling all process related things to manage resourcing and project management

Creating WSR, Application handbook, SMR, Audits, Skillset analysis

Managing and reviewing tickets created in remedy Data models.

Worked as Cognos Administrator for Novartis BICC project.

Prepared the ETL designs and mapping procedures as per Cognizant’s coding standards and implementations.

Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.

Deployment of Packages, folders and Reports from a development environment to Testing and Production environment.

Handling customer queries

Analyze and implement SCR’s.

Assure the quality of all deliverables to Novartis.

Coordinate with team and guide them during design, development and testing of bug fixes.

Develop Oracle packages/procedures and Cognos reports to apply business rules

Interact with Source System Owners / Third Party Vendors to obtain clarifications, if required.

Interact with Technical Infrastructure Group (Unix Admin, DBA) to resolve the issue

Obtain acceptance from Novartis for all deliverables.

Respond to requests for ad-hoc data queries.

Update Production documentation

Support User Acceptance Testing on need basis.

Personal details

Date of Birth – 01/31/1986

Education – Bachelor’s Degree (B.E) Completed in 2007 from India.

Hobbies or Interests – Watching inspirational videos, Innovative videos and TV series like shark tank etc.

Dancing and playing team games like Volleyball and table tennis etc.

Community Involvement - Active member of Cognizant Outreach Team

THANK YOU

Contact this candidate