Ali Karamat Email & Phone Number

Woodland Hills, Ca, Us

Needham, Ma, Us

• Wrote and optimized queries (changed from hours to seconds) in AWS Redshift (RDS) & Aurora hosted databases like Oracle (PL/SQL), PostgreSQL (PL/pgSQL), and Microsoft SQL Server (T-SQL) in multi-environment (Dev, QA, Prod, etc.) setup.• Created data migration tasks for AWS Data Migration Service (DMS) to transfer data from legacy to new database platform.• Assisted with data migration projects for Healthcare departments of various states involving PostgreSQL, SQL Server, and Oracle Databases in AWS RDS/Aurora.• Used JIRA for ticket tracking and Confluence for documenting the processes.

Administered Azure SQL databases and lead Azure SQL development and code review. Architected various cloud-based applications. Created, maintained and developed database infrastructure for various projects and managed server tiers in Azure.* Architected DB structure* Developed and audited T-SQL scripts for stored procedures, full text searches, Views, Triggers, JSON and XML data, Sequences, and Functions from initial design to releasing into production according to SDLC practices. Also worked with Spatial data.* Created internal and external accounts and security infrastructure for various access scenarios including Row Filtering.* Created/maintained Power Automate Flows to automate DDL/DML and daily reports.* Applied various security aspects to databases including row filtering for sensitive information. Software Architect on various engineering, and ERP/MRP/MES projects in ASP.NET environment:* Collected information and liaised between internal teams to define the requirements.* Designed application process flows along with database backend structure. * Lead/Managed development projects in ASP.NET/Developer Express with 100% on-time achievement of goals. Managed company’s Azure portal. Worked with JIRA, Confluence, Git, Visual Studio 2019, Developer Express ASP.NET, Redgate SQL Toolbelt.

Secaucus, Nj, Us

Member of Bioinformatics Next Generation DNA Sequencing team working on Oracle and SQL Server Databases. Successfully led and completed following projects on Oracle Databases:o Integrated COSMIC Mutation Database into internal database (https://cancer.sanger.ac.uk/cosmic).o Integrated Alamut 1.9 External Mutations Database (https://www.interactive-biosoftware.com/) with NextGen Sequencing Database and internal Pipeline applications and created processes in Bash and PL/SQL to automate annotation of patient samples.o Extension of Pipeline Verifications to Assure correctness of results for each pipeline. Designed, Tested, and Implemented PL/SQL scripts (including Procedures, Triggers, Jobs, UTL packages, DB Emails, ACLs) and Database Structures on Oracle 11.2g and 12.2c and followed SDLC regulations on Development, Validation, and Production servers. Created Control files for Oracle SQL Loader to upload flat files with various formats into database. Created Bash Shell Scripts to manipulate flat data files and execute Oracle SQL Loader and SQL PLUS scripts to perform scheduled and non-scheduled batch processes against Oracle Database. Participated in Enterprise multi-site multi-team projects:o Integration of Enterprise Genetics Laboratory Information Management System (LIMS).o Integration of Pre-Authorizations System with Advanced Sequencing Database and Genetics LIMS.o Comprehensive Inherited Disease Panel (CIDP).o Upgrade of Validation and Production Oracle Database Servers to Oracle 12.2c. Supported SQL Server Databases (Development, Validation, Production) and related developments and interfaced with SQL Server DBA team.

West Hills, Ca, Us

As head of IT applications reported to Global CFO, restructured and aligned applications teams in US, China, and Taiwan. Developed 3-year strategy plan for MIS and Application. Hired and managed employees in USA, China, Taiwan, and India. Supervised, architected, and developed OLTP database applications incorporating Stored Procedures, Views, Triggers, Functions, and jobs in a multi-server global SQL Server and Oracle database farm w/ VB.NET UI. Took ownership and maintenance of orphaned applications and processes in C# / Java. Supervised SQL Server and Oracle DBA tasks and coordinated DBA and Development teams.o Developed ETL jobs in SSIS to send shipping information to customers by email or FTP and import GL data from CSV file (Concur system extract) into Oracle ERP GL system.o Performed performance tuning practices on Production SQL Server (T-SQL) and Oracle databases (PL/SQL). Supervised development and maintenance of global inter-server (MS-SQL, Oracle, MySQL) data synchronization jobs for ERP, MRP, MES, and Shipping modules.  Managed and consolidated various consultants and external companies on hosting and support of ERP, Supply Chain Planning systems, and Financials (Oracle EBS/ASCP/Agile PLM/Hyperion Planning). Interviewed internal business users, scoped and created process flows for global projects such as ERP, CRM (Salesforce), Forecasting, RMA, Intranet, and BI projects. Created scripts and policies to make sure master data being used in HR systems are correct and in sync. Reviewed proposals, and proposed vendors to implement ERP/MRP, CRM, Forecasting, and Intranet projects.  Participated in decision making, selection and implementation of clustered production servers with SAN. Supervisor of Global Travel and Expense system (Concur) and implementation of travel policies. Performed Root-Cause analysis, DIVE process, 5-Why, and Fishbone for failed processes. Supervised migration of in-house CRM to Salesforce.

West Hills, Ca, Us

Reported to COO/EVP of Planning.  Created new or took ownership of existing applications in VB6 and VB.NET and created BI reports: o Overhauled an early version of exiting Manufacturing execution system (MES) application by fixing faulty modules and adding new features to support global site operations (US, China, Taiwan).o Created applications for Planners to create purchase requisitions and change Order Status in Oracle ASCP without using Oracle’s own tools.o Designed and implemented a completely renovated Shipping and RMA processing system for global operations.o Provided Business Intelligence (BI) by creating various live dynamic reports and charts in VB.NET applications, Crystal Reports and Excel pivots connected either directly to Oracle ERP (EBS) / ASCP backend databases, and OLTP data warehouse on MS-SQL Server.  Developed numerous T-SQL code, and modeled and created SQL Server databases:o Created Tables, Indexes, Triggers, Stored Procedures, Functions, SQL Agent Jobs, Views, Pivots and aggregations, RPC calls with XML/XQUERY.o Created database links and queried with internal and external SQL Server, Oracle, and MySQL databases.o Performed performance tuning on queries and database objects. Created and maintained ELT/ETL Tools and packages using SSIS and in-house ELT tool. Installed a two-node Clustered Multiple Instance Active/Active SQL Server 2012o Co-developed and executed a migration plan for existing production SQL Server 2005 to the above-mentioned cluster. During this migration, existing objects and setups including Linked Server connections, scheduled jobs and maintained compatibility with legacy .NET 1.1 32-bit applications running on the server requiring certain 32-bit Oracle client were maintained on the server.o Migrated existing tables into Partitioned structure on a multi-array drive configuration (SAN) with multiple file-groups.

Reported to CEO/President, was tasked to create unified IT department to manage corporate and satellite offices in California and Nevada while continuing to expand and maintain systems and applications.▪Created MIS and IT department and the required infrastructure including Hardware selection and setup, Networking, MS-SQL Server, Mail Server, FTP Server, File Server, and remote access (VPN, pcAnywhere).▪Setup LANs in remote offices and connected to corporate office.▪Hired application developers.▪Maintained previously purchased Courier software through backend database modifications (MS-SQL Server).▪Created a new comprehensive Courier and Logistics application named "Unison" by working directly with president of company to replace the old application. This application was designed from ground up as modular application to support various functions such as Routing System, On-Demand Ordering, Truck Management, Holidays Management, Weight-Based Billing System, Parcel Tracking System, COD Management System, HR, and comprehensive customizable Billing System (done in VB.NET and Infragistics libraries, Crystal Reports and SQL Server).▪Created Windows NT service applications to import and export data in various EDI formats to exchange shipment and billing information with customers.▪Created and maintained client-side applications at customer sites.