ZACH M. AHMED

*** ****** ****

Medina, OH *****

440-***-****

Email = adenx7@r.postjobfree.com

PROFESSIONAL SUMMARY

I am an accomplished Senior DBA and Software\SQL Database Developer with 25 years of combined experience writing Pharmacy Benefit Management (PBM),Automotive, Financial, Medical and Event Management applications using C#, VB. My IT experience also includes supporting large n-tier SQL Server\Oracle\MYSQL databases. I am also an SQL Server\ETL\ODI developer and have a clear understanding of performance tuning, indexes, clustering and data migration. I am also experienced in Azure SQL Server 2017 Cloud base, JIRA, Confluence and MS Team Foundation Server and GIT.

TECHNOLOGY SUMMARY

Systems: MRP\ERP J.D Edward, Financial Navision, Business Intelligence and Process Control Systems.

Programming: Developed management methodologies for n-tier relational databases, Created system solution for EDI modules in banking industry using VFP\VB 6.0 and .Net. Created financial reports using SQL Reporting and Crystal 8.5 in Window XP\2000 server.

Database: Relational databases architecture for Microsoft SQL Server 2005/2008 R2 and SQL Server 2014, Developed procedures for data mapping\deployment, Lead architecture in large complex data conversions. Experienced with TOAD and Oracle SQL Developer.

ERP: I worked on standard workbook called sales (invoiced) workbook the amount (net) column which shows the amount in local currency and I converted to the local currency into USD using consolidated exchange rate for specified accounting period. To convert the currency I added a column in the workbook with custom formula.

I also provided the currency-wise report on the transactions and how much was gained or lost due to the fluctuating exchange rates against each country. This alerted the management to increase the margins for specific deals where the deals have mostly ended up in the red because of the exchange rates.

I worked on a JD Edwards / inventory management system, which is a full ERP and have all module. I needed to integrate financial data from in house application called charisma to the JDE, so 1- when the update to the price amount in ERP occurred, the price amount of Charisma was also updated.

Healthcare: I have PBM experience working with government agencies such CMS addressing regulations for Medicare PartD and creating monthly EOB reports. I was also involved migrating HICNS to MBI.

EXPERIENCE

June 28, 2020 to present IntelliPaat Bengaluru, India

Working on creating the ETL packages using Informatica 9.6 to update the OLAP database.

April 2016 to Rite Aid (EnvisionRX) Twinsburg OH

June 28, 2020 ETL\BI Developer

Develop, maintain and support PBM applications using ETL\SSIS 2017 loads to load data into the Tableau reporting database using SSIS packages, and creating stored procedures and functions required to extract data for the load Design SSIS packages to upload Medicare Claim data.

Participate in data model reviews

Manage\develop Data Warehouse and OLAP Cubes including daily processing and updates.

Support IT staff and end users in the development, usage and troubleshooting of database driven applications.

Developed data-cubes and trend company KPI’s.

Conduct BI solution performance tuning, troubleshooting, support and capacity estimation.

Prepare test data and analyze program performance during testing

Participate in analysis of information systems problems and the development of applicable solutions.

Support information technology functions of the company in accordance with its policies and practices.

Snap On Business Solutions Richfield OH

July 2007 to March 2016 DBA SQL\Oracle\PostgreSQL and MYSQL

Responsible for daily operations for Oracle, SQL Server and PostgreSQL databases

Also perform installation, configuration, upgrade migration, database security, storage, capacity planning, and performance monitoring, tuning and data movement of Oracle, Postgres and SQL Server.

Troubleshoot long running queries, deadlocks, investigate CPU spikes and memory errors.

Automate data migration using SSIS package and ODI.

Designed SSIS packages to migrate client data warehouse from SQL Server 2005\2008r2\Oracle\MYSQL to SQL Server 2012\2014 environment

Included alert in the SSIS packages to send error messages to IT in case of failure and potential rollback.

Wrote C# script to migrate the data from different domains using various data format.

Responsible for documentation, designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports, and reporting environments.

Assist both internal and external developers in determining best business architecture needs.

Saved Snap-On Tools money and over 40 hours of labor work by automating the ETL data migration jobs.

Improved customer satisfactions by reducing errors by 90%

Trained other developers on how to convert Oracle ODI packages into SSIS, thereby reducing the financial cost.

April 2005 to Experient, Inc. Twinsburg, OH

July 2007 APPLICATION DEVELOPER

I develop and maintain multiple Event Management applications written in VFP6.0 with backend SQL server 2000.

Responsible for writing complex stored procedures and making sure that SQL server is performing at its max.

Responsible for daily backup\restores and making sure data is normalized and that there is no redundant data for data duplication.

Responsible for writing stored procedures (utilizing T-SQL), batch process and encryption in SQL 2000 environment with 500+ 5mb databases.

Conversion of current Event Management system from VFP 6.0 to C# .NET.

Responsible for security administration, data management and creation of reports using Crystal 8.5 and SQL reporting.

Responsible for the monthly preparation of the Financial Performance Report and analysis of monthly financial statements for senior management.

Troubleshoot, tune and support 15 -10 gigabyte SQL 2000 databases

Responsible for setting up disaster recovery procedures and backup plans

Convert VFP 6.0 application into C #.Net platform.

Designed encryption process for security purposes

April 2004 to National Association of College Stores Oberlin, OH

November 2004 SR. DATABASE MANAGEMENT ADMINISTRATOR

Managed 15 large SQL 2000 databases and 8 Servers.

Business Analyst Lead. Project responsibility included 30 cycles of testing with interfaces feeding data from legacy systems and other third party software.

Developed AMS (Association Management software) using VB 6.0 and Crystal with SQL Server 2000

Managed all phases of project from requirements gathering through user acceptance, testing and documentation development.

Developed project\deployment plans and schedules. Took lead role in numerous projects and

Consistently exceeded customer expectations.

September 2001 to MobilePro Corp Cleveland, OH

April 2004 SR. SOFTWARE DEVELOPER\SQL DATABASE DEVELOPER

I tuned SQL databases, wrote complex stored procedures, designed DTS packages to export\import data into the server. Installed the SQL 2000 server. Setup batch jobs to transfer data between SQL 7.0 and SQL server 2000. Wrote applications in VFP\VB.

Administration of SQL Server 7.0\2000 and development of dynamic, complex queries, stored procedures, business rules, linked servers and data constraints.

Developed macros in Visual Basic to update Excel files.

Project manager responsible for projects from cradle to grave including design, system analysis, testing, training and documentation.

Developed Accounting\EDI software for major telephone companies using VFP 6.0.

Wrote ASP codes for company web applications.

December 1999 to Renaissance Business Systems Inc. Brunswick, OH

October 2001 SENIOR SOFTWARE DEVELOPER

Customized a manufacturing package called Made to Manage (M2M) by creating client specific screens such as EDI, sales entry, customer email maintenance, general ledger, import\export inventory, barcode and customer update.

Wrote account payable, account receivable and cost analysis modules in M2M.

Developed software using Visual FoxPro 6.0 for clients such as Malley’s Chocolates, Main Street Lighting and Athens Foods.

Wrote strategist documentations for testing newly created applications.

Created user's specific graphic web sites.

Implementation, administration, maintenance and backup of SQL Server 7.0\2000

Install, Configure and support SQL server databases

Developed disaster recovery and data maintenance strategies.

July 1995 to Global Technology Business Systems Inc. Bedford, OH

December 1999 SOFTWARE DEVELOPER\ANALYST

Developed n-tier medical system (CateTrak) using Visual FoxPro 6.0.

Developed medical billing software using Health Care Financial Administration (HCFA) standards using VFP 6.0.

Project lead. Duties include solution analysis\development as well as overall technical support for software packages.

Developed documentation rules for software testing. These phases included: unit testing, system testing and production testing.

Developed strategies for data management utilizing database formation and OLEDB.

EDUCATION

1988-1994 Cleveland State University (one semester short of BBA) – Cleveland, OH

Major: Computer Information System

Minor: Marketing

Contact this candidate