SUMMARY:

• My skills are mixed of Data Management, Study Management, Technical, and Finance that gives me the ability to fully understand business process of pharmaceutical Companies.
• Experience on many application used in Pharmaceutical Industry like IMACT (CTMS), Oracle Clinical, ClinTrial, CRF Workflow, AWS etc.
• Consultant with 12 + years of experience with expertise in Business objects BOXI R2/ 3.1, 6.5, 6, 5.X (Webi/Deski)PL/SQL, Client Server Internet and Intranet technologies.
• Expertise in developing Standard, Interactive, Drill Down, Master - Detail and Cross Tab reports.
• Wrote scripts for derived tables for Business Objects reports with complex calculations
• Experienced with Software Development Life Cycle (SDLC), including requirement analysis, design, development, testing and implementation (Tool Used QC & Concerto).
• Well acquainted with Word Processors, Spreadsheets, and Office Communication Tools.
• Experienced in writing Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers and Performance Tuning.
• Excellent analytical Skills, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Outstanding work ethic, time management skills and a consistent team player.
• Performed Data management activities and developed PL/SQL packages and BO Reports for DM, Tracking and CRF Workflow application.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/2003/NT/ XP, UNIX

Business Objects Tools: BO (XI 3.0/XIR2/6.5/6.1a/5.x), Designer, Desktop Intelligence, Crystal Reports.

ERP Application: People Soft Tools like SQR and People Code.

Databases: Oracle 10g/9i/8i/7.X, Sybase, MS-Access 97/2000.

Oracle Utilities: TOAD, SQL Developer, PL/SQL Editor

Languages: SQL, PL/SQL, Trans SQL.

Web Tools: HTML, DHTML.

Scripting Languages: VBScript, Java Script

Applications: MS-Word, MS-Excel and MS-PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential

Functional Lead and architect

Responsibilities:

• Confidential t Exposure Data.
• FDA Audit
• Dispense Summary
• Confidential t Enrollment
• Product wise and Study wise analysis
• Pharmacovigilance Master File for EMA reporting needs
• Metrics for ICD-9 Codes
• Clinical Studies Tracking using CTMS database.
• Analysis of Departmental Expenses
• Cashforecast & Budgets for studies
• Generating reports and presentations for top management.
• Reports for FDA Audits.
• Applications Support
• Collecting Requirements from Users
• Expense Reports Using Cognos 8

Confidential - New Jersey

Power Builder & Business Object Developer (BOXI) R2

Responsibilities:

• Help in maintaining the current universe.
• Developed reports with Alerters and Sort & Filters.
• Multi level break reports.
• Cross Tab Reports
• Wrote pl/sql function and created object using created function.
• Reports with Sections
• Break Calculations for multiple level
• Created reports with multiple queries
• Created multi tab reports.
• Created Multi table reports for receivable summary
• Created report with Alerters which keeps Track of all outstanding payments.

Confidential - New Jersey

Application Manager/Business Object Developer (BOXI) R2/BO 6.5

Responsibilities:

• Created customized objects using PL/SQL function to full fill the need of summary calculations
• Developed highly customized reports with Alerters, multi- level break calculation and sorting, user prompts
• Created external pl/sql procedure calls from BO reports using objects in designer
• Wrote Stored Procedure to populate the table for calculation and added to Universe.
• Created object customized quarter as quarter was not regular quarter for example Q1 = 26Dec to 25 Mar
• Alerters which show report row in red color depending on the result.
• Provided the facility to take input from user in prompt.
• Break calculations at many levels.
• Enhanced and maintained the IMPACT Universe.
• Customized sorting.
• Lot of calculations of different levels using ‘IN’ operator
• Listings from Oracle Clinical Data Base like Investigators, Sites details etc.
• Report with Splitting columns.
• Generated customized percentage wise summary at the bottom of report by using independent rows.
• Displayed user’s selection in the report
• Created customized prompts for quarterly reports
• Wrote test scripts for newly developed reports.
• Reports with multiple queries.
• Report with Multiple tabs where every tab shows different level information and can be exported to Excel with all tabs.

Confidential

Application Manager/ Business Objects 6.5 and I-review Report developer

Responsibilities:

• Master Details reports for CRF Workflow application
• Chart Reports for analysis graphical view.
• Analysis reports to decide Investigator performance.
• Cross tab Reports for analysis.
• Visit design reports for the selected study.
• Reports with sections for IMPACT application.
• Gathering requirements from Users and creating specifications
• Wrote test scripts for Business Objects Reports
• UAT for Business Objects Reports
• Generated listings depending of user input from CRF Workflow application.
• Reports for existing Investigators and enrolled Confidential ts for user’s selected study
• Developed many stored procedures for AWS and CRF Workflow using Oracle Database.
• Report for the sites set up in Oracle Clinical
• Ad hoc reports for the Oracle Clinical regarding received DCMs, DCI, Question etc.
• Helped Data Managers in solving issues for their study in application CT4.
• Wrote test scripts for the new version of CRF Workflow.
• Create sites, Investigators, Confidential t positions in OC.
• Mapped OC fields with CTI application tables for Page Tracking.
• Find out the discrepancy in two databases CTI and ClinTrial.
• Keep track of CRF pages and Queries from site as and when required.
• Database Setup for Missing Pages in ClinTrial 4.
• Generated Confidential t Profile Using I-Review tool.

Confidential

Database Specialist (IMPACT (CTMS), Business Objects 6.0 & Oracle)

Responsibilities:

• Report of analysis of sites using Cross Tab
• Graphical representation of data using Business Objects
• Wrote scripts for derived tables for complex calculations of the report (MIS Reports)
• Developed Drill down Business Object reports
• Generated and published the Business Objects using filters and custom sorts.
• Report writing in I-Review.
• Create Sites Through application Profile.
• Checking data consistency using I-Review and Oracle (Clintrial database and IMPACT database).
• Set up study in IMPACT on Study Level, Country Level & Site Level.
• Set up visit design in IMPACT.
• Writing programs in Oracle 9i pl/sql.
• Ad hoc reports as per requirements using I-review.
• Multiple Query Report Of Missed Cycles of Confidential ts - Object created in Business Objects which calculates date for every visit for whole duration & checks whether Confidential ts has attended that visit.
• Multi table Report of screen failures - Business Object report gives % of screen failures for each study.
• Reports using filters. If visit is missed then the package keeps tracks of the money that should not be paid.
• Complex calculation in Business Object reports for Variance (Actual Vs Estimated) at Country and site level.
• Report displays Cost and Cash forecast for entire study - Enables very effective planning.
• Master Details reports for study and country
• Visit schedule of given study for all the countries and all the sites.

Confidential

Database Specialist - Power Builder & Business Objects

Responsibilities:

• Developed software to track clinical trials and tracking of Confidential t’s visits.
• Business Objects Cross Tab report for Confidential t’s recruitment analysis for the sites (Investigator) selected by user.
• Business Object Reports of sites, which have received shipment of drugs but no recruitment.
• Report using complex formulas for Percentage wise analysis of Progression of disease & Deaths of studies.
• Multi table Reports to calculate percentage of actual Confidential ts enrolled and Confidential ts uploaded in IMPACT Country and study level.
• Reports for site wise analysis to decide monitors performance using complex formulas.
• Summary Reports for Confidential ts Enrolled - Actual and in IMPACT.
• Preparing functional Specification documents and getting approvals from client.
• Coordinating with client’s representatives and functional consultants for finalizing scope of system, preparing project plan in consultation with Project Manager.
• Compare the data which is loaded by monitors from sites using portable IMPACT.
• Confidential ts Randomized/Completed - Actual and in IMPACT.

Confidential - California

Programmer/Online Result System

Responsibilities:

• GUI: Power Builder 6.5 / 7/ Sybase 11.9/ NT
• Confidential Inc. is a leading laboratory specializing in drug testing products and services. As a programmer/analyst I handled the following areas of the project:
• Customer Setup - This module handles customer login & access control based on user profile.
• This was done using PFC Power Builder Web Application: Developed & implemented the frame work to send customer related data from PB data windows to the web pages through Developed new reports giving advanced sales details for selected customers.
• Gathering & Understanding requirements.
• Preparing functional Specification documents and getting approvals from client.
• Designing GUI screens.