Sangeeta Pratap

• Reviewed customer orders to ensure accuracy of product specifications, pricing and delivery dates.
• Developed processes for order management and worked with internal stakeholders to ensure compliance.
• Analyzed inventory levels and customer demand to identify potential supply chain issues.
• Created reports on the status of existing orders, invoices, shipping documents and other related documents.
• Managed all aspects of customer order fulfillment including tracking shipments, resolving discrepancies, ensuring timely deliveries and providing follow-up communication with customers.
• Coordinated with vendors to confirm availability of products in a timely manner.
• Provided technical support to sales representatives regarding order entry procedures.
• Performed data entry into the company's ERP system as required for processing customer orders.
• Monitored incoming emails for inquiries about product availability or changes and cancellations in existing orders.
• Order Entry: Facilitate the entry of prescription orders into the pharmacy's IT applications accurately and efficiently.
• IT Application Support: Provide technical support and troubleshooting assistance for pharmacy software and IT systems used for order entry and processing.
• Data Accuracy: Ensure the accuracy and completeness of prescription order information entered into the pharmacy system to minimize errors and ensure patient safety.
• System Maintenance: Assist in the maintenance and updating of pharmacy IT applications, including software upgrades, bug fixes, and data backups.
• User Training: Conduct training sessions for pharmacy staff on the proper use of IT applications for order entry, including new features and functionalities.
• Workflow Optimization: Identify opportunities to streamline order entry processes and improve workflow efficiency through the use of IT solutions and automation.
• Compliance Monitoring: Monitor adherence to regulatory requirements and pharmacy policies regarding order entry and documentation within the IT system.
• Documentation: Maintain detailed records of prescription orders entered into the system, including timestamps, user IDs, and order statuses for auditing and accountability purposes.
• System Integration: Collaborate with IT teams and vendors to integrate pharmacy order entry systems with other healthcare IT systems for seamless data exchange and interoperability.
• Continuous Improvement: Participate in quality improvement initiatives to enhance the performance and usability of pharmacy IT applications for order entry and processing.

· Design DataMart Entity relation, data model, make necessary changes in oltp to capture information as per need as part of auditing (AS-AT, Overwrite or Hybrid). Read the data from scheduled jobs and process it to DataMart via created dB objects.

· Create any necessary views, Audit triggers, stored procedures, packages and SQL functions to support processing of data and generation of extracts for EDW.

· Utilize SQL Server Integration Services (SSIS) to create ETL processes that import/export data in a timely, accurate, and appropriately formatted fashion with robust error handling and data integrity checks.

· Convert long running PL SQL etl code/object to SSIS or SQL solution for efficiency and speed.

· Set up and Control job execution with help of homegrown scheduler and $Universe.

· Create status reports to business users to track status of 300+ ETL processes.

· Identify opportunities for structural and/or procedural enhancements to existing processes/dB objects.

· Meet with stakeholders, create ad hoc queries, reports to extract data from disparate databases and analyses data to produce dashboards, metrics, or insights and identify trends or anomalies using Power BI.

· Execute performance test, optimization, and tuning activities. Optimize/reengineer existing code/objects where performance is high importance.

• Analyzed large datasets to identify trends, patterns and correlations for business insights.
• Leveraged SQL queries to extract, transform and load data into databases.
• Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
• Optimized existing database structures for better performance on analytics tasks.
• Collaborated with stakeholders across the organization to understand their needs from a data perspective.
• Performed quality assurance testing on newly developed reporting solutions.
• Defined KPIs based on collected data sources.
• Built visualizations that enabled users to quickly interpret results from complex analyses.
• Utilized data analysis to monitor process efficiencies and identify data integrity exceptions.
• Partnered with data scientists to support ongoing research and analytics initiatives.
• Provided technical support for existing reports, dashboards or other tools.

· Analysing the requirement and understanding the functional specifications.

· Development using ASP.Net and SSIS.

· Creation of health behaviour traits dashboards using BI tools.

· Data analysis and forecasting using tools like Power BI.

· Optimization of long running jobs using various tools, techniques such as SSIS, pl sql procedures and SQL tuning.

· Optimization of dB objects by modifying or re-writing Packages, procedures, functions, triggers, views, materialized views and existing dB scripts/codes.

· Data quality improvement by running scans across systems, one shot and permanent fixes.

· Estimation the effort involved in fulfilling the requirements.

· Implementing permanent fix (problem tickets) for issues arising from similar problem.

· Implement archiving strategy for oracle dB tables.

· Business Command Center issue resolution support.

· Preparing the unit test plan and specifications using Test Data Generator tool and generating the test cases based upon the given set of design level functional.

· Communication to stakeholders – Business partners and IT Management .

· Making Usage of IPMS for project monitoring and tracking.

• Maintained documentation of all the processes related to Data Analysis.

• Medication Dispensing: Prepare and dispense prescription medications accurately according to orders from healthcare providers and under the supervision of a pharmacist.
• Inventory Management: Monitor and maintain appropriate inventory levels of medications and supplies to ensure uninterrupted pharmacy services.
• Prescription Processing: Receive, review, and process prescription orders from healthcare facilities, ensuring accuracy and compliance with regulatory requirements.
• Patient Profile Maintenance: Update and maintain patient profiles and medication records, including allergies, medication history, and dosage instructions.
• Prescription Labeling: Properly label prescription medications with patient information, dosage instructions, and other relevant details in accordance with pharmacy regulations.
• Patient Counseling: Provide medication counseling and education to patients and caregivers regarding proper medication usage, potential side effects, and drug interactions.
• Quality Assurance: Participate in quality assurance activities, such as medication reconciliation and medication error reporting, to promote patient safety and compliance with regulatory standards.
• Collaboration: Collaborate with pharmacists, healthcare providers, and other healthcare professionals to ensure comprehensive and coordinated patient care within the long-term care facility.
• Verified accuracy of medication orders and entered data into pharmacy system.
• Provided guidance on the selection of over-the-counter medications and supplements.
• Received telephone calls from physicians, nurses or other healthcare professionals requesting information about medications or supplies.
• Performed administrative duties such as filing documents, faxing forms, answering phones.
• Processed medical insurance claims to calculate copayments.

• Prepared medications for dispensing by counting, pouring, labeling, and verifying doses.
• Performed data entry for patient profiles, billing information and prescription orders into the pharmacy software system.
• Provided customer service to patients by answering questions about medications and health-related topics.
• Assisted pharmacists in compounding sterile products according to state regulations.
• Managed filing of prescriptions, both electronically and manually.
• Verified accuracy of medication labels before they were dispensed to customers.
• Ensured compliance with all federal, state, local laws and company policies related to pharmacy operations.
• Resolved customer complaints in a timely manner while maintaining professionalism at all times.
• Checked expiration dates on medications to ensure that only unexpired products were dispensed.
• Transmitted claims to insurance companies for payment and reconciled EOBs.
• Leveraged database to confirm validity of prescriptions, patient data and drug side effects.
• Operated cash registers to accept payments from customers.
• Answered telephones to respond to questions or requests.
• Communicated effectively with doctors and insurance agencies to resolve prescription cost discrepancies.