Mahendra Aseri

Digital Transformation Data Analysis and Insights Strategic Planning Performance Optimization Offshore operations

Managed structured and unstructured data from diverse systems, transforming it into actionable insights for executive decision-making and enhancing patient care for clinical teams. Roles included: Data Engineering Data Science Data Visualization Clinical Research Decision Support & Cost Accounting

In this role, I designed and built a subscription analytics solution, focusing on optimizing performance in high-volume scenarios. This involved architecting and developing custom data service jobs and procedures in HANA. Additionally, I implemented specialized FACT and Dimension tables to enhance performance and efficiency within the analytics environment.

As a Data Modeler for Health Science products, my responsibilities included: • Reviewing and developing data models for the product. • Overseeing the Business Intelligence (BI) and Data Warehouse (DWH) architecture. • Leading early adoption initiatives for new technologies, conducting Proof of Concepts (PoCs), developing prototypes, and implementing best practices.

Worked as a Technical Lead for Credit Suisse, focusing on the enterprise data model for the collateral management system supporting daily trade and margin calculation processing for the investment bank. • Designed and developed logical and physical data models for both OLTP and OLAP systems. • Defined load strategies and implemented real-time and batch ETL processes to optimize data flow and accuracy. • Delivered complex reporting solutions and designed aggregates to enhance performance and analytical capabilities. Additional Assignment: • Led the development of a data mart integrating legacy systems to provide managerial insights and performance metrics. • Defined and built ETL architecture and framework for automation of batch and real-time loads. • Delivered advanced dashboards and reports to support strategic decision-making. Technologies: • Erwin (LDM & PDM) · Oracle 10g/11gR2 · Informatica · Business Objects · XML/XSD · Data Warehousing • ETL Architecture · Performance Tuning · BI Reporting & Optimization

At Yahoo, contributed to one of the world's largest data warehouses, an Oracle Database exceeding 200 TB. Optimized critical "fact loading" and Dimension jobs, analyzing execution plans and aligning with team requirements, implementing architectural enhancements. Produced large-volume ad-hoc data through optimized SQL queries. Designed and developed custom reports using PERL CGI scripts for extensive data provisioning for Business Analysis. Technologies: Databases: Oracle 10g Data Warehousing/ETL development Perl/Unix shell scripting BI Reporting

Worked for Agilent Technologies Worked on Enterprise Content Management (ECM) application for Life Science and Pharma domain to control the chromatography instruments remotely. I was involve in -->> Managing application database i.e Creating users, Priviledges, Index Rebuilds, Query Optimization, Oracle Enterprise Manager etc -->> Enhanced the application custom report using COM, DCOM. -->> Implemented wrap up scripts and PL/SQL code to take care complete application objects. -->> Troubleshooting Technical issues in Chemical Laboratory. -------------------------------------------------------------------------------- Technology work on: • Databases - Oracle 9i, 10g • Data Warehousing / ETL developer • Perl/Unix shell script • BI Reporting • C,C++, COM, DCOM

• Incorporate location analytics into different areas of business, including strategy, marketing, operations, sales, information systems, finance, and human resources • Identify the role that location analytics can play in different business sectors for competitive advantage on a local, regional, national, and global scale • Employ location intelligence to strengthen critical thinking and empower managers and leaders to make more effective decisions

Specializing in rapidly expanding fields such as Data Engineering, Data Analytics, Internet of Things, Embedded Systems, Security, Networks, Cloud, and Wearable Computing. Data Engineering Engaged in a dissertation titled "Optimizing ETL with Advanced Database Features." Conducted a practical case study on an Oracle RAC (Real-time Application Cluster) system, fine-tuning the performance of the existing ETL process using advanced database features, and upgrading coding standards with new functionalities.

The four-year Bachelor of Engineering in Computer Science program focuses on computer science and engineering, covering hardware and software fundamentals. It applies engineering concepts to system and software design, addressing challenges across disciplines. Students learn essential computer science principles for hardware, software, and network development, including circuit design and digital signal processing.