OBJECTIVE
To work for an organization that will enable the best utilization of my resources and potential for achieving the organizational goals.
PROFESSIONAL SUMMARY
Ø Expertise in extracting, analysis, design, development of various SAS applications for interactive/dynamic reports generation.
Ø Extensive knowledge in SAS/BASE, SAS/MACRO, SAS/STAT, SAS/ACCESS,SAS/WHAREHOUSEADMINISTRATOR, SAS/EIS/OLAP, SAS/GRAPH, SAS/SQL in windows environment.
Ø Enhanced existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
Ø Obtained practical project management experience by gathering data, developing budgets, identifying lessons learned.
Ø Good experience in RDBMS development including SQL and PL/SQL programs and stored procedures.
SKILLS
SASTools : SAS/BASE, SAS/MACRO, SAS/STAT,
SAS/ACCESS, SAS/CONNECT, SAS/GRAPH,
SAS/WHAREHOUSEADMINISTRATOR.
Database Packages : Oracle (SQL, PL/SQL).
Programming Languages : C
Operating Systems : DOS, Windows 95/98, Windows XP/2000/NT.
EDUCATION
M.Sc Microbiology ,Nagarjuna University
PGDIT, Manipal University
B.Sc (MBF), Hindu college, Guntur
PROJECT DETAILS
Project – 1
Title : Clinical Trail Reporting of Drug
Client : NIMS, Hyderabad
Duration : Sept 2006 to Feb 2007
Role : SAS Programmer
Environment : SAS/BASE, SAS/MACROS, SAS/STAT, SAS/CONNECT,
SAS/ACCESS
Description :
Nizam institute of Medical sciences is a world-renowned Hospital working the area of clinical trails. The institute has worked with all major pharmaceutical companies and has developed the protocol and conducted clinical trails for these companies. We are working on clinical trail of Levo-cetrizine in the treatment of Seasonal Allergic Rhinitis (SAR). The CRF was provided by CRO, which is stored in the oracle database. This data was then transferred to SAS System and data sets were created. All statistical analysis reports and other reports such as patient completion status, Randomized patients, Demographics and baseline characteristics were generated with SAS System.
Responsibilities:
Ø Pharmaceutical Data received in tapes and CDs from data vendors, .txt files, Excel files, and Oracle.
Ø Extracted Raw data and created SAS datasets that are required for the project analysis
Ø Cleaning, Validating, Sorting and merging techniques is done using SAS/Base include Macros and SQL.
Ø Once the data is prepared and validated, run linear regression models for analysis
Ø From the processed data several reports were generated.
Ø Involved in delivering output using the ODS
Project – 2
Duration : Oct 2006 to April 2007.
Role : SAS PROGRAMMER.
Environment : SAS/BASE,SAS/MACROS,SAS/ACCESS, SAS/CONNECT, SAS/ACCESS
Project Description:
This Project creates a Warehouse which acts as Decision Support System for the Sales department, Stock comparison. The project mainly reveals all the needs for super markets, Departmental stores, and Customer analytical needs for the way to organize all the possible ways used for the means of better needs for Business Requirements. The fundamental goal of this project is categorized as study of transaction database, requirement study of decision makers for business model, designing data warehouse, transforming and loading data from transactional databases and creating cubes for report generation.
Responsibilities:
Ø Accessing Data from Flat files transferring it into database creating SAS datasets. Transfer the data, files from windows to PC. Used SAS/ACCESS and SAS/CONNECT to connect to different servers.
Ø Creating different datasets for Risk Analysis, Cost Benefit Analysis and forecasting.
Ø Transferred data between databases using import and export.
Ø Used SAS for analysis and producing different reports.
Certifications / Training
Ø Certified ISO14001:2004 Lead Auditor conducted DNV and Internal auditor
Ø Trained in Beverage manufacturing technology in World wide Technical training program conducted by Coca Cola .
Ø Trained in HACCP training program conducted by Coca Cola .
Responsibilities:
Ø Using the SPC (Statistical Process control ) Produce the daily control charts for each pack and flavour to observe the Quality Deviation
Ø Producing the Pie charts and comparison charts to know the Yield and Efficiencies
Ø Generating the Monthly, Quarterly, Half-yearly and yearly reports to know the HOB (Health of Business) of the unit and updating the same to the region office
Ø Implementation of the ISO9001 & ISO14001 systems in the unit and preparing documents related the systems
Ø Worked as Document manager for retaining and preparing the new documents
Ø Total product management coordinator calculate the product age and product availability in the market for business forecasting on monthly basis among the distributor and retailer wise
Ø Training provided to all associates regarding the systems
Personal details:
I do hereby declare that the above details are true to the best of my knowledge.
No comments:
Post a Comment