Sonali Aurora Email & Phone Number

United States

United States

Purchase, Ny, Us

New York, Us

Us

• As PO/BA for McKinsey-MDL, worked on domains involving Data Analytics and Reporting for multiple studies driving decision support interventions for enhancement and growth.• Worked extensively with Pharmaceutical clients for defining sales and marketing strategy for different drugs.• Hands on experience in designing and implementation of interactive analytical dashboards for regional and global domains of the Education sector. • Lead the analysis, planning, implementation and management of the project, while understanding requirements, business processes and client’s actual needs within and across the domains.• Providing options for feasible technology development solutions considering Time, Cost, requirements and current state of the client technology stack.• Supporting a team of Data Engineers, Business and Product Analysts in analyzing, defining, designing and documenting business and Technical Requirements. • Leading and guiding the team to execute the project as per design and defined milestones.• Organize and participate in problem solving and brainstorming problem solving sessions to come up with acceptable and alternate solutions to achieve the end goals of the study.• Performance tuning, trouble shooting and defining work around and options for resolution of issues impacting client decisions and milestones.• Analysis of the data collected from the client's data lake, defining scope of enhancement to data model considering the scope of requirement involved in the enhancement, workflow definitions and interface designs as customized and adaptable to client specific study/project.• Well versed with using Alteryx and Tableau for analysis, design and execution of a POC for the domain in question.• Working knowledge of big data and cloud concepts involved in the likely digitalization of domain.

Bellevue, Wa, Us

• As Lead Product Analyst for the Population Dimensions (PD) Product, supporting a team of Business and Product Analysts in analyzing, Defining, designing and documenting business and Technical Requirements. • Playing the role of a Scrum Master/Product Owner for a team of 15 (Analysts, Developers and QA). Followed Agile Scrum with 3 week Sprint Cycles and 3 to 4 Sprint Release Cycle.• Analyzing and documenting various sources and formats of patient HIE data, building requirements for normalization and persistence of Medical data.• Defined precedence rules and logical work flow of medical data Correlating and Aggregating persisted data for consumption by PD product and reports.• Patient Medical data ingest resulted in the presentation of longitudinal patient record that supports planning, decision making and execution of Value based care for a patient. • Documenting and delivering requirements for persistence of ADT-A01 (Admit), A02 (Transfer), A03 (Discharge), A04 (Registration), A05 (Pre-Admission), A08 (Information Update), A11 (Cancel Patient Admit), A12 (Cancel Patient Transfer), A13 (Cancel Patient Discharge), ORU-R01, CCD, 837 P and 837 I• Defining and designing Upsert Strategy for Persisted Information from the ADT, 837 and ORU.• Capturing and Implementing Business needs for deduping and correlating various medical information for the patient from multiple data sources.• Ingest and Management of Client Master Data registry for Organizations, Providers and Users of the system.• Design, Document and Management of Master Reference data information covering Standard Clinical codes, User defined HL7 tables, custom client codes and internal Product codes.• Analyzed the business need and requirements for implementation of EMPI (Enterprise Master Patient Index).• Analysis and requirement documentation of Patient Consent.

Hartford, Connecticut, Us

Have worked extensively on the ODS (Store for all the transactional data), ESB (Enterprise service bus utilized for synchronizing data work flow), HIE (HL7 standard ingest from EHR Data), DataMart (Reporting and Analytics), AdminSuite (Reference data management system), MAH Product (Member Portal), ACT Product (Provider Portal) and ETL AHDI Ingest of standard Payer data from clients and Aetna. Integration of all or some of these systems, support in analysis of the ingested medical data for evaluating member’s health and provider’s care management and performance.Medical Data from Payer Clients and Provider clients are utilized for evaluating the member’s health for Provider care management. HIE data formats like HL7 V3 CCD, HL7 V2 ADT Data from 837i, 837p are also ingested for some provider clients to provide value add for the member’s health analysis.Health Analysis for the members is being generated with the help of predefined clinical rules by the clinical team via an in-house Clinical Rule Engine which identifies the potential members for a condition and suggests care considerations to help manage the condition.These rules help in managing member outreach for care management and provide solutions for lowering the medical costs.The data is also used for generating research and study reports for predictive health analysis for a defined population.

Hartford, Connecticut, Us

• Responsible for designing solutions in accordance with Organizations information system techniques.• Good knowledge and understanding of adapting and utilizing available technology, tools and existing designs to apply skills towards scope of enhancement.• Extensive applied knowledge in monitoring and guiding activities supporting applications systems analysis, design, implementation and maintenance.• Implemented projects requiring integration, support and maintenance of several smaller projects or applications to help achieve the over all organizations goal and business strategy. • Successfully implemented and documented Projects using Project Management Techniques across the entire SDLC like SRS gathering, Business Analysis, Design, Testing, Implementation and Support.• Well versed with Agile and Scrum project development methodologies.• Under taken initiatives to provide User Acceptance Test (UAT) Scenarios for most of the projects undertaken to support Quality analysis of the deliverable.• Expertise in ensuring business and IT deliverables across complex and multi platform computing environments.• Planned and integrated releases to multiple environments to support cost effective and timed deliverable to Production.• Providing business and data analysis utilizing industry System Engineering processes and techniques in designing efficient and cost effective solutions to meet business strategic direction.• Extensive Technical knowledge supporting all phases of the development and implementation process.• Expert Leadership qualities supporting quality and effective communication with Business and IT teams.• Extensively used Data Analysis skills to integrate data from multiple sources for supporting business reports, requirements, data interpretations, conclusions and effective data quality enhancements.• Designed projects requiring ETL processes integrated with Application flow for promoting efficient business solutions to meet customer requirements.

Iselin, New Jersey, Us

Clients worked foro ActiveHealth Management (Aetna), NYo McKinsey & Company, NYo Depository Trust & Clearing Corporation (DTCC), NYo Mitsui O.S.K Lines (America), NJVedicsoft Solutions Inc. is a global IT Professional Services and Solutions company engaged in providing system design, development, and implementation of software systems through there Onsite, Offsite and Offshore service models. There solutions comprise of building, re-engineering, enhancing and supporting enterprise Data Warehousing, ERP and EAI applications for fortune 2000 companies. The main responsibilities and the clients served are as mentioned below. Responsibilities:• Identify, Analyze and study the overall business and information needs of an organization in order to develop appropriate Information Technology solutions and strategies.• As the key liaison between business and information technology departments, responsible for gathering and documenting business requirements and translating them into functional system design specifications that can be successfully executed by IT development teams.• Validate and document business, organizational and operational requirements. • Design Solutions often including a systems development component, process improvement or organizational change. • Design and execute strategic solutions supporting performance improvements, minimized development costs and project delays. • Analyzing the communications, informational and programming requirements of clients; planning, developing and designing business programs and computer systems.• Designing, programming and implementing software applications & packages customized to meet specific client needs.• Training of clients on the use of software applications and providing trouble shooting and debugging support.• Some of the clients served during the duration are.

Armonk, New York, Ny, Us

• Major responsibilities covering all areas of System’s Operations to support an active company location to function without any disruptions.• IT installations, implementations and maintenance.• Security, Change request, Logs and Audit process implementations.• LotusNotes application Design, Development, Implementation, Maintenance and technical and design documentation.• LotusNotes, AIX, Windows NT server and various Hardware and Software installation, administration and maintenance.• Interact with users for Software Requirement Details and to analyze the need to automate there requirement.• Design, develop, test, implement and maintain applications involving the software supported by the clients and customers. • Deploy new Applications following through the entire Project cycle. Maintain, enhance and modify existing applications.• Document technical features for applications to enable Customer support process. • Designing, programming and implementing software applications & packages customized to meet specific client needs.

Pgdcs - Post Graduation Diploma In Computer Sciences, Computer Science

Ace - Advanced Computer Education Certification From Ibm

Education record

Bachelor Of Computer Applications., Mathematics And Computer Science