Technical Support Management

ADITI THAKUR

Mobile – 650-***-****

Technical Skills

Programming Languages : SQL, PL/SQL, Java

Operating Systems : DOS,Windows, Linux

Databases : ORACLE, MYSQL

Other Tools : SQL Developer, ARGUS 7.0,Pentaho

Professional Summary: 3+ years in Health and Pharma IT Industry

Strong expertise as an SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of Client/Server and multi-tier applications on different platforms

Proficient in PL/SQL Programming – Stored Procedures, Functions, Packages, SQL tuning and creation of Oracle Objects – Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links and User Defined Data Types.

Good experience of Performance Analysis and SQL Query Tuning, while designing scalable application from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans

Experience in migration and conversion from MS Access/SQL Server to Oracle.

Involved in all phases of SDLC with timely delivery against aggressive deadlines in Pharma, and Healthcare industry

Worked in fast paced AGILE environment and attended daily SCRUM meetings.

Strong Analytical and Problem Solving skills, Multi-Tasking abilities with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.

Possess a strong work ethic with superior communication, interpersonal, and team leading skills.

Business analysis and Requirement Gathering

Co-coordinating between users and product engineering team to troubleshoot issues, analyze enhancements and provide resolutions

Professional Experience

1.SUJANSKY & ASSOCIATES, LLC. (ASSOCIATE CONSULTANT & DATA ANALYST) Since July 2015

Sujansky & Associates specializes in Clinical Data Engineering (CDE). The company provide clients with a variety of services, ranging from the technical to the strategic Healthcare information Exchange and Clinical Decision Support & Reporting.

Job Summary

Requirements Analysis

Technology & Vendor Evaluation

Product Management

Regression testing

Technical support

Project Experience

1.Client : CJRR (California Joint Replacement Registry)

As an Associate Consultant, I am responsible for:

Analysing and documenting the functional requirements for the CJRR hosted technology.

Designing the standardized file formats (in Microsoft Excel) to collect data from participating health care organizations and provide technical support to these organizations.

Overseeing the implementation of the CJRR hosted technology and the collection of data from participating sites using SQL in MYSQL.

2.FORESIGHT GROUP INTERNATIONAL AG, NOIDA, INDIA (ASSOCIATE CONSULTANT) JAN 2013 – JUNE 2015

Foresight Group International AG is a global professional services company focused exclusively on clinical and post-marketing drug safety and surveillance and risk management services and solutions. I being part of the company have over 2 years of experience in data migration, implementation, upgrade, requirements analysis, design, testing and support of drug safety system (Argus Safety).

Job Summary

Data Migration development-Writing SQL, PL/SQL, packages, procedures, functions, triggers in Oracle 11g

Design and development of PL/SQL scripts as part of configuration changes like new reporting rules, soft and hard edit checks, workflow etc in Argus database.

Design and scripting of custom PL/SQL for upgrades and interfacing with other medical operation systems.

Writing and executing validation scripts.

Co-coordinating between users and product engineering team to troubleshoot issues, analyze enhancements and provide resolutions.

Business analysis and Requirement Gathering.

Coordinating with off-shore teams while monitoring, debriefing the business requirements and managing the deliveries.

Project Experience

1.Client : GSK (GlaxoSmithKline)

As a Data Migration Analyst, I was responsible for:

Development of migration mappings and codelist configuration mappings between source and target environments.

Design and setup of staging database for processing the migration. This included migration specific tables for capturing migration details.

Design and Development of JPSR report migration from source to target environments.

Migration Code development and execution.

Data Analysis of Source System and preparing Mapping Sheets.

Testing the Migrated Data by Application to Application & Report Comparison between Source and Target.

Post go live support.

As a Validation Analyst, I was responsible for:

Functional-User Acceptance Test Scripts, SOPs’, Risk Assessment documents and Traceability Matrix.

Creating test cases scenarios.

Authoring and executing Operational Qualification scripts.

Testing Reporting Rules by developing the scenarios.

As a Configuration Analyst, I was responsible for:

Configuring Argus Safety system – Code Lists, Business Configurations, Access Management & System Configuration using in-house developed CBD Automation Tool.

Development and maintenance of Configuration Baseline Document.

Creation, Execution and Review of OQ and PQ scripts.

Functional testing, System Testing, and Dry Run of Test Scripts.

2.Client : UCB

As a Configuration Analyst, I was responsible for:

Capturing and updating the system configuration and Development of Configuration Baseline Document.

Writing configuration verification scripts.

Performing Formal Verification dry runs of OQ’s.

Active participation in the business workshops and providing inputs as and when required.

3.Client : SPMSD (Sanofi Pasteur MSD)

As a Validation Analyst, I was responsible for:

Authoring and executing Operational Qualification scripts and performing internal dry runs.

Maintain Traceability Matrix.

Requirement Analysis and Risk analysis of functional requirements.

Education

MASTERS OF COMPUTER APPLICATIONS (2010-2013),

Rukmini Devi Institute of Advanced Studies (Absolute grade - 81.83%) Pitampura, New Delhi, India.

Projects

Project on online polling titled ‘the Global Poll’ based on JAVA and JSP (4th sem MCA)

BACHELOR OF COMPUTER APPLICATIONS (2007-2010),

Jagannath Institute of Management Studies (JIMS) (Absolute grade – 79.45%) Vasant Kunj, New Delhi, India.

Projects

Project on ‘Manpower Management System’ based on JAVA and MYSQL

Project on ‘Insurance Website’ based on HTML and CSS

Personal Details

Hobbies : Reading, Writing, Dancing, Art & craft, Painting.

Date of Birth : 21st August 1987

Assets : Excellent communication skills, affable, highly energetic, Innovative, A team player and easy to work with person, Ability and willingness to learn new technologies and domains quickly.

Currently on L2 Visa with valid EAD

Contact this candidate