Manager Data
Resume:
Jyotsna S. Prajapati
*** ********* *****, ******, ** 08817
****************@*******.***
OBJECTIVE
QA Analyst/Tester's position in a reputed and stable organization with
growth oriented opportunities in the field of Software Testing/ Application
Validation and Technical Writing in Client Server environment. In addition
looking to work for an organization, which is seeking smooth operations,
quality troubleshooting & quality product development.
PRACTICAL TECHNICAL SKILLS
Languages: C, UNIX, Shell Scripts, SQL, PL/SQL, HTML.
Office Skills: MS Office, MS Excel, PowerPoint, Windows.
RDBMS : Oracle, Sybase, Informix
ETL Tools: Ascential DataStage
Oracle Tools: SQL*Plus, PL-SQL, Pro*C
SUMMARY
U.S. Citizen, 10+ years of experience in IT Development and Full Cycle
Testing, 10+ years of pharmaceutical industry experience. Accomplished full
cycle Q/A Testing: Developed, reviewed, documented & executed Test Plans
according to quality procedures SOPs & SOQs per requirement documents.
Communicated heavily with clients & System Analysts for creating complete
and elaborate requirement documents. Experience in testing different
products at Dendrite International. Performed & documented Gap Analysis.
Performed testing at several levels e.g. Functional Testing, Regression
Testing, Performance Testing & more. Tested backend Interfaces for loading
Initial Data as also maintenance data. Tested import/export processes using
Ascential DataStage. Utilized defect tracking & reporting system "Clarify"
for logging, assigning and coordinating resolution of defects, which
provided Quality improvement statistics and Root Cause Analysis of defects.
Experienced in analyzing Problem/defect severity. Maintained Test
Coverage Matrix (TCM).
Developed, tested and maintained ETL (DataStage) jobs and processes for
DataStage modules to load data into the production system involving full
cycle: Data Analysis, Design Source to Target Data Mapping, Data
Validation, daily scheduling, Rejection Analysis and Error Reviewing &
Analyzing, Production Support, resulting in smooth integration of business
processes and cost efficient operations.
Technically strong in Programming & Q/A Testing, SQL, PL/SQL, Stored
Procedures, Triggers, shell scripts, C, UNIX, Oracle.
Energetic, committed, hard working, skilled with self-initiative, very good
track record of accomplishing DataStage Development & Testing (Unit
Testing, Integration Testing, Product Testing) assignments independently
complying with requirements documents. Very supportive team member enjoys
coaching & training less-experienced teammates, experienced in integration
& testing.
Excellent communication skills: Gathered requirements, wrote design
documents, participated in weekly conference calls with clients, meeting
with developers for requirement & design review. Keen to learn additional
skills.
PROFESSIONAL WORK EXPERIENCE
Dendrite International, Bedminster, NJ
QA Analyst
03/02 - Present
Employed as QA Analyst working for Web Force (sales force automation)
Development Team at Dendrite International, Inc., the leading provider of
pharmaceutical CRM solutions. WebForce enables the client companies to do
market research and identify profitable opportunities. Being part of
WebForce Team, Developed, tested and maintained ETL jobs and processes for
customer maintenance module to load customer data into the production
system involving full cycle: data analysis, design source to target data
mapping, data Validation, daily scheduling, rejection analysis and error
logging and error processing, resulting in smooth integration of business
processes and cost efficient operations.
1. Extensively interacted with users/managers for requirement gathering,
prototyping and Completed Documentation for ETL processes: Data
Requirements, Data Design, Detailed Design, Unit-Test Plan, Integration
Test Plan, Release Notes for several clients: Purdue Pharmaceutical,
Bristol-Myers Squibb, Sanofi Aventis and Procter and Gamble.
2. Part of Quality Assurance team and Production group for Product Testing
for several clients.
3. Accomplished Q/A testing for Purdue Pharmaceuticals: creating test
plans, Test documents, STTS, executing and evaluating test plans for ARD,
IRD, ESD and Scrub, performing sanity testing, functional testing & GUI
testing.
4. Involved in testing of All FDA expected Validation activities, Planning,
Specifications, Testing and QA review on validating electronic
records/signatures.
5. Utilized defect tracking system "Clarify" for logging, assigning and
coordinating resolution of defects.
6. Completed Validator Testing for ICOS client to validate the Prescribers
Data against the Analytica Database.
7. Implemented Validator for Sanofi client.
8. Developed scripts and programs using SQL, SQLPlus, PL/SQL procedures and
Triggers as part of Force Pharma Configuration.
9. Extensively interacted with clients/managers for requirement gathering,
prototyping and prepared various documents like Interface Requirement
Document, Customer Requirement document, Integration test plan, Unit test
plan, Release notes etc.
10. Installed & Tested Web Services and Support Services: Force
Administrator, Force Analyzer, Sample Enforcer, Radweb, Refresh Manager,
Realignment Manager, Subscription Manager, Synchronization Manager, Merge
Manager, Purge Manager.
11. Designed and Implemented export and import interfaces for call data
sharing for Eli Lilly and ICOS.
12. Performed Structural Call Notes testing for Purdue.
13. Developed DataStage Interfaces & Jobs for Customer Data, Location Data,
Territory Data, Product Data and Call Data for Purdue Pharmaceuticals per
business & technical requirements.
Technologies: DataStage, Shell Scripting, UNIX HP-UX 10.20/NT, Oracle 8.x,
Sybase SQL Anywhere 5.0/7.0, PL/SQL, SQL, SQL*PLUS, SQL*LOADER,
TOAD,
SalesPlus/CORNET (A dendrite International Company), Stroudsburg, PA
Developer
11/99 - 02/02
Involved in Sales Force Automation project being developed for
pharmaceutical companies.
14. Involved in development, enhancement and maintenance of Dataload
software for loading third party data (client specific) from client feeds
into Oracle database.
15. Developed SQL reports for extracting data from client databases.
16. Involved in development, enhancement and maintenance of Catalyst System
(client specific e.g. Forest Labs).
17. Maintain national databases (Oracle) for the clients (e.g.
pharmaceutical companies like Forest Labs)
Technology used: C/C++, UNIX, Oracle, PL/SQL.
EDUCATION
The Chubb Institute, North Brunswick, New Jersey
Diploma in Client Server Programming, 1999
Gujarat University, India
BS (Chemistry), 1987
Bilingual: English, German.
Contact this candidate