Mohd Hassan M Email & Phone Number

Coralville, Iowa, United States

• Develop, maintain, and monitor Databricks job, automated ETL pipelines with a focus on reliability, scalability and data integrity using Pyspark• Designed and implemented scalable data pipelines in Snowflake, utilizing its multi-cluster shared architecture to enable parallel processing• Developed ETL pipelines leveraging Snowflake’s micro-partitioning to integrate data from various sources into AWS Redshift, with data accuracy and consistency• Proficient in setting up and managing data lakes using AWS Lake Formation• Ensured secure, scalable, and efficient data storage and access, leveraging Glue Catalog for metadatamanagement and seamless data integration across various AWS services• Developed and orchestrated robust ETL pipelines using AWS Glue and EMR• Automated data extraction, transformation, and loading processes, enabling efficient data processing and analysis. Leveraged Glue Catalog for maintaining an organized and accessible data repository• Developed Airflow orchestrated core python Databricks jobs in collaboration with Dynamo DB and terraform.• Collaborate with data visualization analysts and learning engineers to develop and maintain interactive dashboards for visualizing and interpreting trends in user data using Power BI• Collaborate with research scientists and learning engineers to develop and maintain data modelling tools for shared understanding of data definitions, lineage and access control.• Extract, parse, analyze, investigate, interpret and extract knowledge from high volume, velocity, and variety of data obtained from online and blended instructional applications and associated outcome measures• Performed advanced queries on relational and non-relational operational databases using sql and other query tools as needed• Part of 4-member team that worked on successful and accepted NCME (National Council on Measuring in Education) research paper on “Improving equity in AI-based learner modelling using aggregated demographic data”.

Project - ACT-Exam data evaluation with Databricks• Used extensively informatica Designer, Workflow Manager, Workflow monitor and Repository Manager.• Designed and implemented Apache Spark streaming application using Python(pySpark) and Java.• Created Sessions, Workflow monitor and Scheduled those in the Workflow manager and Performance tune them.• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.• Used Amazon S3 to backup database instances periodically to save snapshots of data.• Automated system deployment, monitoring, alarming, and scaling in the Cloud.• Wrote AWS Terraform templates for any automation requirements in AWS services.• Implemented the various reporting scripts to resolve conflicts during replications.• Coding and testing of various database objects such as views, Functions and stored procedures using SQL and PL/SQL.• Developed tools using Python, Shell scripting, XML to automate some of the menial tasks.• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.Project- Revopay-Online payment application and SFTP file processing• Responsible to maintain the legacy framework and transition to the modern architecture using Laravel and Spring boot.• Developed an Administrative Interface for admins using PHP, JavaScript, jQuery, MySQL, HTML5, CSS3, Bootstrap and Laravel framework• Sole developer to create SFTP file processing module in Spring Java framework that handles 500,000 transactions per day• Made the solution Cloud compatible. Implemented the necessary changes and deployed the application on AWS cloud• Utilized AJAX and Jquery to improve the performance of the application.• Designed and created effective store procedures in MySQL to handle huge data updates.

Project: CPS Web Application:• Involved in various phases of Software Development Life Cycle (SDLC) such as requirements gathering, modeling, analysis, design, development and testing.• Designed User Interface using HTML, CSS, JQuery and AngularJS and XML in a responsive grid layout. Implemented responsive design template to get a new interface in Bootstrap, HTML.• Automated CPS filing process of courses registration that is accessed by only advisors and students.• Developed notification system that is triggered every time a request has been raised by student to the advisor.• Responsible for site maintenance, development, integration of new features, and making technical decisions on future development of features.• Created a detail user manual for the usage of application using Docbook.

Houston, Texas Area

Experience in developing new feature enhancements for Expensable.com both Corporate and Express. Experience in agile methodology. Experience in handling both front end and back end services. Experience in developing front end of the product using AngularJS and subsequently creating Java back end services. • Developed new process with highly persistent and scalable application with Spring Java REST services and hibernate mappings for company enrollment which resulted in marked performance improvements. • Designed and documented responsive UI web application using angular framework and prepared detailed reports concerning project specifications and activities.• Modified existing software to correct errors, upgrade interfaces and improve performance using SOAP web services.• Stored, retrieved and manipulated data for close analysis of system capabilities using SQL Server.• Interfaced with business analysts and technical support to determine the best requirement specifications and designed job schedule configuration functionality that terminates expired company user accounts.

Hyderabad Area, India

Project 1: Independence Blue Cross - US Health CareDescription: Migration project from Independence Blue Cross to Highmark claims processing platform.• Developed automation scripts in RFT Java for healthcare claim processing in OCWA healthcare web application for all Blue Cross Blue Shield companies.• As lead developer worked closely with other team members to plan, design and develop robust solutions in a timely manner.• Built, tested and deployed scalable, highly available and modular effort optimizer and claim analyzer, VBA tools based on EDI files.• Evaluated Functional and Performance of potential healthcare applications SOAP and REST web services using SOAPUI based on new and existing system development and migration requirements.• Debugged, modified software components and experience in data mining, test scenario creation, test script creation and EDI 837 file processing.Project 2: Highmark - US Healthcare*Developed automation scripts in RFT Java for healthcare claim processing in OCWA healthcare web application for all Blue Cross Blue Shield companies. *Responsible for regression testing strategy and business requirement analysis.*Experience in creating Test Frameworks using Selenium WebDriver with Data Driven Testing, UI Mapping and Design Patterns.*Experience in System Integration testing SIT , User Acceptance testing UAT , Load Testing, Security testing, Browser compatibility testing, and Performance Testing.*Expertise in Functional, Security, and Performance Testing for SOAP and REST web services using SOAPUI.*Expertise in Mainframe manual testing and VBA macro creation.

Master'S Degree, Computer Science

Activities and Societies: American Board for Cybersecurity and Information Assurance - ABCIA

Bachelor Of Engineering, Computer Science

Activities and Societies: Secretary IEEE Computer Society Student Branch, Core Member Muffakham Jah Computing Club, Member of TGC, Hyd.