LSH, DMW, ALSC, SQL, Informatica, ETL, cognos
Resume:
Education: -
B.Tech (Information Technology) in MITS Engineering College, Madanapalle, A.P.
Should help team in reducing issues and help in maintaining good Quality
Good coding practice session has taken multiple time.
STD call discussion and STD view deployment.
Personal Information:
Name : Abrar Ahmad H
Sex : Male
Marital Status : Married
Father’s name : Mohammed Ismail
Language Proficiency : English, Hindi, Urdu,Tamil
DECLARATION:
Here by I declare that all the information given above is correct to the best of my knowledge.
Place: Bangalore, India - Abrar Ahmad H
Uma Maheswari
SQL, Cognos, Inform, Central Designer, DMW
*********.***@*****.***
PROFESSIONAL SUMMARY:
3.10 Years of professional experience with Accenture Solutions Pvt. Ltd.
Experienced in developing Edit checks, Validation checks, Reports using SQL, Cognos, Inform, DMW.
Extensive experience in writing SQL complex queries using Joins, sub-queries and various analytical functions, which helps cleansing the wrong data from database.
Knowledge on Cognos tool for creating listing reports.
Have ability to Develop new programs and enhance existing programs to support various scenarios to make standard validation checks.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Have good experience in CDM domain and INFORM Tool (ECRFS).
Develop Protocol Specific reports according to protocol milestones using Oracle SQL.
Experience in handling external data and converting into database format and program as per client requirement.
Have 2.6 years of experience in PDAM-NG space (Patient Data Acquisition Management – Next Generation).
RESPOSIBILITIES:
Got trained and mentored in terms of domain, technically as well as process wise.
Understood defined SLA'S, SOPs and BE for the team.
Working as SME (Subject Matter Expert), involves in helping developer by resolving technical queries.
Reviews the requirement before development, requirement changes and discuss requirement finalization by collaborating with clients. Post approval developer starts the development.
Worked as Quality control analyst and Worked independently to meet each report stipulated time lines with good quality.
Worked on creating study Template, creating Data Models, Performing Data transformations between Data Models, creating Validation checks in LSH (Custom Programs) and DMW checks, Reviewing Discrepancies in Listings in PDAM-NG space.
Got trained on ETL(Informatica), knowledge on transformations, testing with SQL queries and all the four stages of Informatica tool.
Project Title
Clinical Data Management
Role
Clinical Trial Analysis Senior Advisor Analyst
Client
Pharma Client (Leading research –driven healthcare company), USA
Environment
Oracle 11g (SQL Developer 3.0), Congos10 (Report Studio), Inform 4.6, 6.1, Central Designer, Data Management Workbench
Project Description
This project involves Clinical Data Management which makes the drug to launch market in a shorter period.
Main project features involve Data validation on the patient data which is taken by investigator. The data validation provides the wrong data and helps to clean the database. After cleaning the database Case Study Report will be generated through which the FDA approves the drug.
Roles & Responsibilities:
Performed data validation as per given specification using different Methods in SQL.
Developed simple, medium,complex and Ad-hoc reports by using joins, inline views, sub-queries, analytical functions.
Determining what data must be returned to the application as per specification by understanding domain wise and writing queries for it.
Reviewing current specification, design and making suggestions for better data validation.
Using Cognos Report Studio, import patient’s data from reporting database which further creates listing report by using same SQL queries and Creation of prompts in Cognos.
Experience in developing new STD, Template and Protocol Specific reports based on design specifications provided by clients and perform necessary validation on developed reports.
As a PL took responsibilities of assigned DRP so that each and every reports should meet its timelines.
Perform QC of developed reports on request, Mentor new joiners in the team.
Copy Study Template and create Data models in DMW in PDAM-NG space
Perform transformations based on mapping document(using joins and union transformations and packages)
Developed custom programs in LSH (Lifesciences Data Hub) to make standard validation checks which includes packages and procedures so that those can be used as mandatary in all trials.
Developed Validation Checks in DMW using simple SQL queries in criteria
Worked as requirement finalization and approval by having discussion with clients in both Integrated Reports and PDAM-NG validation checks
Contact this candidate