Bismi Dominic

Bismi Dominic Innovative Petal, Doddanekkundi, Bangalore – 560037 Mob: - E-mail:- A bright, talented and self-motivated data analyst, who has excellent organizational skills, is highly efficient and has a good eye for detail. Has extensive experience of assisting in the development and upgrading of database systems and analytical techniques. Able to play a key role in analyzing problems and come up with creative solutions as well as producing methodologies and files for effective data management. A quick learner who can absorb new ideas and can communicate clearly and effectively. SUMMARY: Six plus years of overall experience, primarily in Pharmaceutical and Health Care domain. Experience in managing and mentoring mid-size offshore team. Experience in performing analyses using industry standard data sources – IMS Prescriber Level, IMS Patient Level, WKH Patient Level, WKH Prescriber Level. Experience in relational database (Oracle) development involving SQL, PL/SQL, stored procedures, performance tuning. Efficient in programming with large and complex databases having more than 100 million records. Use SAS, SQL Developer, PL\SQL, Excel, PowerPoint etc. to generate deliverables. Experience in working with Pharmaceutical Sales, Rx & Claims data. Learn new techniques and improve current algorithms. SKILLS Database Concepts SAS 9.4, PL/SQL, SQLServer-2000/05, Oracle 10g Operating Systems Windows 98/NT/Vista/7, Windows 2005/08 server. EXPERIENCE: IMS Health Bangalore (https://www.iqvia.com/) IMS Health is an American based company that provides information, services and technology for the healthcare industry Sr.Engineer May 2012 – Jun 2017 Project: APLD Analysis Key responsibilities Analyzing and discussing the business requirements with the clients. Analyzing IMS patient level longitudinal data (APLD) to identify brand performance, market dynamics, sources of business, compliance and persistence. Developed excel reports using SOB data allowing an expert user to slice and dice, filter, aggregate and analyze data so that he understands if he has won or lost patients or market share along different dimensions. Developed process to Extract, transform and load IMS data to SAS environment. Creating and maintaining SAS scripts. Designing, developing and maintaining data extraction and transformation processes and ensuring that data is properly loaded and extracted in and out of our systems. Investigating data quality issues and implemented appropriate solutions. Done modifications to the existing methodologies in order to adhere with the client requirement. Experience in managing and mentoring mid-size offshore team. Collaborated effectively with the onshore team for the project execution. Assisted project teams on ad-hoc and tracking studies to deliver quality output on schedule. PharmARC Analytic Solutions (www.pharmarc.com) January 2011 – April 2012 PharmARC Provides marketing analytics and business consulting services to global pharmaceutical and healthcare sectors. Acquired by IMS health in May 2012. Business Analyst Project: Data Analytics Support to Cegedim RESPONSIBILITIES: Assessed and translated both business and functional requirements into design specifications Created and maintained PL/SQL scripts and stored procedures. Experience in Importing and Exporting data to and from Oracle database using SQL stored procedures. Experience with IMS patient level data (APLD) to identify physician’s switching patterns, impactable patient base, and source of business – new to therapy, switch or continuation. Experience in analyzing WK Dynamic claims data to understand the rejection rates across regions, plan & payer types and patient co-pays. Involved in generating monthly reports using IMS Xponent and WK Prescription data. Involved in developing Tracking reports on a monthly basis for different markets which shows the sales trend, adjudication and ROI. Helped to improve the performance, scalability and stability of database systems. Identified and implemented programming enhancements. Handled the client problems and troubleshoot and fixed the bugs Use SQL Developer, PL\SQL, Excel, PowerPoint etc. to generate deliverables. Education MCA 2008 Mount Carmel College (Bangalore University)Bangalore B.Sc Computer science 2005 College of Applied Sciences (IHRD)Calicut UniversityCalicut Certifications Oracle Certified Associate – Oracle 10g REFERENCES References can be provided on request.