Mohammad M. Jamal Email & Phone Number

Austin, Texas, Us

Oracle APEX application developer supporting the NBOME mission to protect the public by providing the means to assess competencies of osteopathic medicine.● Worked on a 500+ page web portal for osteopathic students and colleges nationwide. The APEX v21 applications facilitated the delivery of multiple exams related to osteopathic medicine. The workflow ranged from exam development to students registrations to final score delivery.● Built robust RESTFul ORDS APIs for multiple vendors providing them with data in JSON format.● Utilized external RESTFul APIs to process exam data sent as JSON files. ● Implemented security measures using Oauth2 guidelines● Developed several APEX pages to expedite routine functions such as monthly invoice reconciliations and scheduled score releases.● Invested personal time in learning many existing and latest features of APEX including generative AI using Cohere's LLM in APEX version 24

Chicago, Illinois, Us

Worked on the Emotomy platform for the digital investment advisory group. The platformallows retail investment advisors to personalize their portfolio offerings for their clients. Itstreamlines the entire workflow from client onboarding to trade execution and reporting.● Part of a global team managing and supporting the Emotomy platform built usingPHP running on MySQL.● Conduct daily scrum meetings and manage workload and deliverables of a team consisting of 4 developers and an analyst.● Used GIT/Bitbucket for version control and Jira for task management.● Used Bamboo as CI/CD pipelines for deployments

New York, Ny, Us

• Part of the IT team supporting Investment Risk, Valuation, Solutions, Analytics and Data Technology needs of Nuveen.• Support data, reporting and business intelligence needs of multiple business areas/verticals at the firm including Performance, Pricing Operations, Risk and Valuation.• Manage, Code and support multiple SSIS ETL solutions accessing and integrating large datasets from disparate platforms including SQL Server and Oracle. • Prepare for and manage production releases and development utilizing established CI/CD processes and tools.• Performance tune, monitor, and provide off-hours production support for various applications in order to meet SLAs.• Gained good understanding of pricing operations, portfolio management and securities trading.

Oak Brook, Illinois, Us

• Facilitated the implementation of the corporate digital road map strategy aimed to make RSNA a data-driven organization.• Worked with AWS Redshift Enterprise Data Warehouse supporting enterprise wide reporting needs.• Coordinated with business analysts to understand data requirements, kpis and metrics and then provide the data architecture and artifacts to furnish those needs.• Developed physical and logical data models for in-house applications being developed on Amazon Aurora.• Provided quick solutions to data mining tasks against S3 buckets using Amazon Athena and RedShift Spectrum. Also used CloudWatch to set up alerts and notifications monitoring the RedShift cluster.• Took custody of the Microsoft SSIS / Visual Studio 2015 ETL solution for the EDW pulling data from on-premise relational databases. web api calls and google analytics. The SSIS was on SQL Server running on an AWS EC2 instance. • Worked with off-shore resources by providing them guidance and specifications for data integration tasks.• Worked closely with business intelligence team in developing Tableau dashboards and reports for multiple business units at RSNA.• Routinely perform detailed data analysis of source systems, identify gaps and provide documentation to assist with resource management.• Interviewed candidates for enterprise data team• Well versed in Agile project management approach.

Lisle, Il, Us

Member of the Oracle Business Intelligence consulting practice. AST is an Oracle Business Intelligence (BI) and Hyperion Enterprise Performance Management (EPM) Pillar Partner. Oracle BI / Data Integration – OBIEE 11g / ODI 11g• Implemented AST Grants analytics OBIEE solution at the Department of Human Services for a state government. Developed numerous BI Publisher reports and provided training to state employees.• Performed data integration using Oracle Data Integrator for a large metropolitan transit authority. • Led the effort to migrate an Informatica ETL process to Oracle Data Integrator 11g for a transit analytics OBIEE solution.• Part of the team responsible for transitioning a major US city from Oracle EBS 11i to Cloud ERP. Developed new reports in BI Publisher and modified several seeded reports for ERP modules.• Perform systems and data flow analysis of existing 20+ applications at a leading research lab. This was part of the effort to consolidate them into 3 application based on a logical data warehouse design using data virtualization tools such as Denodo.Cloud• Converted an OBIEE 11g application from an on premises model to Oracle BI Cloud Services (BICS). The application provided transit analytics for public transport operations.• Manage AST’s Oracle Iaas and PaaS platforms. Involved from subscription to maintenance.Other• Conduct presentations on Oracle Cloud Services and Oracle Big Data Discovery.• Work with cross-functional technical teams and sales teams in preparing responses to RFP’s for BI and Big Data solutions.

Oracle application development experience at numerous clients on engagements that have lasted anywhere from a couple of weeks to several years. Developed web-based applications against Oracle databases as well as stints as Oracle data architect, designer, programmer and instructor.

Chicago, Illinois, Us

• Led segments of an Oracle Data Warehouse implementation project that was a critical part of the management's agenda. The goal was to provide the underlying data warehouse to support the web-based portal providing family office functions for wealthy clients. • Custodian of the database design and architecture. Offered advice and input on several data architecture and design issues. • Led the team responsible for coding ETL routines for data migration from operational mainframe systems to Oracle database utilizing external tables. Provided PL/SQL related technical assistance on numerous occasions to members of data warehouse and other teams.

Chicago, Illinois, Us

• Responsible for providing specifications and implementing a data mart for a data warehousing project. The data warehouse contained payor log detailing all patient visits, charges accrued, adjustments as well as insurance reimbursements since 1997. • Performed detailed data analysis and followed basic data warehouse design techniques in creating the data mart. Responsibility included coding and performance tuning queries that ran against tables with tens of millions of records across multiple Oracle instances. • Employed various application level tuning techniques as well as recommended system level techniques to database administrators.

• Designed and coded a web based Oracle PLSQL application to streamline thepharmacy license transfer process. Incorporated electronic payment processing via Paypal. • Technical resource for an Oracle Applications implementation. Coded PLSQL routines to retrieve data from underlying membership management module tables that adhered to the TCA specifications and save data back into E-Business suite using Oracle provided APIs. Extensively used ETRM and other documentation to gain a good understanding of the underlying schema.

Lemont, Il, Us

Advanced Photon Source (APS)(1999-2004)• Managed and provided technical assistance in the development of a high visibility web-based research proposal submission system for the APS. Received the Pacesetter Award for exceeding expectations in successfully delivering the application under a very tight deadline. • Managed and delivered on another web-based safety related application that received a Director’s award from the laboratory.• Responsible for the complete logical and physical database design and architecture. Design standards for using normalized and de-normalized data structures. Define common design patterns for modeling various types of relationships.• Implemented several Business Objects universes based on materialized views and logs for fast access to pre-calculated data. Center For Nanoscale Materials (CNM)(2010-2013)• A key member of the MIS team at CNM supporting top tier research conducted at the facility. • Responsible for some of the front-end web based application development using the LAMP technology stack and CakePHP (MVC) framework. • Managed the coding and implementation of all of the related back-end functions which involved shell scripts, data loaders and XML parsers. • Fulfilled numerous ad hoc and planned reporting requirements laid down by the Department Of Energy. This involved many data mining, data integration tasks across multiple silos of electronic data. • Designed data flow and auditing processes to support reporting services and data analysis• Employed web services using SOAP and Rest to interface with systems in other departments.• Used ActiveCollab project management tool for task management, team collaboration and communication.

Alpharetta, Ga, Us

Taught numerous courses over the years in a range of topics including PLSQL, Advanced PLSQL, Oracle Forms and Oracle Reports. Assisted in developing course materials in a number of other topics.

Southfield, Mi, Us

• Lead developer of an Oracle Forms 5.0 Application And Contract System (ACS) handling the application process for automobile financing. • Integrated the Kelley Bluebook vehicle valuation functionality into the system. Coded several reports using Oracle Reports.

Chicago, Il, Us

Worked for the marketing, sales and syndication loans department. Developed client-server applications using Oracle Forms 4.0 and 4.5 to maintain a customer information database that tracked syndicated loans to corporate customers. Responsible for administrating the production and development instances of an Oracle V6 database as a junior DBA. Responsibilities included maintaining and modifying backup scripts, managing user accounts, table space management and performance tuning.

B.Sc. (Cum Laude), Computer Science

H.S.

Education record