Magheswari Balasubramanian Email & Phone Number

Edison, Nj, Us

Princeton, New Jersey, United States

New Jersey, United States

• Worked closely as a team player to develop and design best in class databases for valuation of Pharmaceutical industry.• Manage project team meetings using SharePoint calendars. Participate in writing and filing appropriate FDA premarket submissions.• Develop and implement data management monthly/quarterly goal reports and QC procedures to support them.• Analyze office administration support for analysts supporting various projects to identify efficiency opportunities to prototype and write report of analysis findings.• Analyze pharmaceutical datasets to identify patterns, trends, and insights that drive decision-making.• Ensure accuracy of pharmaceutical data by implementing delivery rigorous validation and quality control processes.• Assist in the design and development of data systems and processes.• Deliver regular reports in Power BI to senior management on data trends and changes.• Mapped current business and operational processes and recommended areas for improvement.

Chennai, Tamil Nadu, India

• Interpret data, analyze results using statistical techniques and provide ongoing reportsDevelop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality• Acquire data from primary or secondary data sources and maintain databases/data systems• Identify, analyze, and interpret trends or patterns in complex data sets Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.• Work with management to prioritize business and information needs. Locate and define new process improvement opportunities• Organize and participate in weekly ad-hoc meetings with the functional teams.• Conducted comprehensive gap analysis, coding, and testing, suggesting appropriate improvement actions and spearheaded multiple projects within production environment, adhering to quality requirements.• Scrutinized specs and deployed changes accordingly into production environment.

Chennai, Tamil Nadu, India

• Responsible for participating in the Software Development Life Cycle (SDLC) phases of the IT Project Delivery• Process and worked with internal stakeholder to support the project charter and satisfy the product requirements using Agile methodology.• Collaborated with stakeholders including business users, Project Managers, and Development teams to elicit documents, and analyze business. Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users, and other stakeholders for open and pending issues to develop specifications.• Created mock-ups and UML diagrams such as Activity flow diagrams, process flow diagrams and data flow diagrams using MS Visio before each sprint for smooth development and testing.• Developed an overall project plan and implementation schedule through consultations with project team, management, employees, and external consultants. Created project artifacts such as user stories, sprint backlogs, epics, functional as well as non-functional requirements and process maps.• Possess ability to communicate thoughts, concepts, and practices effectively at all levels, adjusting as needed to a target audience.• Generated graphs from existing data extracting data using SQL into Excel files and reviewed with business users and stakeholders.• Actively took part in collaboration with cross-functional multi-team environment to develop strategies, reduce bottlenecks, and improve process to achieve business goals that boosted conversions.• Prepared BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions.

Chennai, Tamil Nadu, India

● Analyzed massive data from multiple sources, consulted on checking and standardization with product departments and analytic teams to discuss the metrics for gathering data and the database structures.● Analyzed and manipulated data using SQL.● Provided expertise and translated the business needs to design. ● Developed tools, techniques, metrics, and dashboards for insights and data visualizations using Tableau● Communicated with departments on the features and dimensions of the data needed, and worked with technological teams for solutions to improve internal data gathering systems and databases● Worked closely with business team, designers, and software developers to understand application functionality and navigational flow.● Closely worked with the Data Science team to develop and optimize database systems and data processes.

Chennai, Tamil Nadu, India

● Generates provider data reports and analyzes to support internal client needs including network management, sales, account management, and other key functions.● Analyzed customer datasets with SQL from the previous year sources using different data analysis technologies to calculate the structure of customer compositions and features correlated to insurance loss.● Implemented MS Excel and Tableau to generate detailed dashboards from different complicated databases for the profit and potential loss for the project.● Performed document analysis involving creation of Use Cases and Use Case narratives and use case diagrams using Microsoft Visio, to present the efficiency of the gathered requirements. Defined frameworks for the application development and analyzed the areas of improvement.● Analyzed the security implementation of the application with respect to user’s perspective.● Participated in back-end testing on the database by running stored procedures using SQL queries to verify data conversion and data repetition.● Worked closely with Business analysts and Developers in understanding the business and functional requirements of the application.● Data cleaning using Excel by removing duplicate observations from the dataset, fixing date format, handling missing values, outlier detection etc. ● Used statistical tools to identify, analyze, and interpret patterns and trends in complex data sets that could be helpful for the diagnosis and prediction.

Chennai, Tamil Nadu, India

• Analysis of financial statements and balance sheets.• Prepare, monitor, analyze and distribute daily reports. • Reconcile AP/AR, General Ledger, and bank statements, researching & correcting discrepancies• Checking inbound client documents for accuracy, notating all activities on the account, and submitting accurate forms for final processing to the service center.• Audit and process invoices assembles document and/or data for various types of job-related analysisdocuments to be input into the Client Service System• Preparing & Analyzing MIS report at the end of the month & submit it to Top Management. • Created a safe environment by conducting daily internal audits, monthly audits & yearly audits• Provide timely resolution to customer's questions and disputes