Amir Ali

• Previous experience as developer, Servus promoted as Core banking application support.
• Leads, Creates, analyzes, coordinates and documents complex IT projects, products and processes and provides resolution recommendations.
• Interacting with business and coordinate with team members on critical issues and solved them.
• Leads and Conducts research, gathers, and interprets requirements conduct analysis and/or develops recommendations and artifacts related to IT processes and/or products.
• Provide end user support for banking systems
• Plan, design, test and implement configuration changes for MS Bots for Banking System.
• Plan, design, test and implement automation for manual process.
• Researching technology solutions pertinent to ongoing or future IT implementations.
• Design and develop UI design for business users using HTML, CSS, ASP.Net, Javascript, Vue and React.
• Comfortable with source control tool such as git and GITHUB as well as TFS
• Efficiency implemented variety of full stack features, including RESTful APIs with C# and ASP.net WEB API 2, server-side views with C# and ASP.net MVC5 and dynamic client-side interfaces with Ajax, JSON, Jquery and AngularJS

Duties as Database Administrator – SQL Server

· Database migration for various internal application from 2005. 2008 to 2012, 2016. Backups and recovery, performance tuning and optimization, troubleshooting and error resolution.

· Rebuilding the indexes on regular intervals and placing the huge/non-clustered index on the separate file group to improve the performance

· Optimized the query performance with modification in TSQL queries

· Designed and implement new SQL HADR solution on SLQ 2016 using Availability group with readable secondaries for upgrade of banking system to a new version.

· Configuring and maintaining transactional Replication from SQL 2012 to SQL2016 for reporting purposes.

· Design and implement effective database solutions and models to store and retrieve data.

· Monitor the system performance by performing regular tests, gathering perfmon counters, troubleshooting and integrating new features including in-memory tables, column store indexes, TDE, Always Encrypt etc.

· Migrated SQL 2016 stand-alone server to SQL 2019 for in house application database server.

Duties as Database Administrator – Oracle

· Installed, configure, and maintained oracle database on Linux server

· Created database as per requirement using DBCA and script

· Created Database object likes tables, tablespaces, rollback segment, multiplexing control files, data files, redo log files, Partition table, views, indexes clusters, synonyms, materialized views, implemented scripts/tools to help rollout and manage oracle in a global/distributed environment

· Setup jobs and events using Enterprise Manager (OEM) console.

· Implemented data guard (physical) for high availability/disaster recovery solution.

· Monitoring Database growth and space administration.

· Experience in developing, maintaining and debugging procedures, packages and functions using sql developer.

· Export & import at full, schema, tablespace and object level.

Duties as Database Developer

Providing production support for DWH/BI ecosystem including planning, configuring, implementing, and maintaining SQL server 2012,2016 and 2017.

· Assisted with Database design, extensive data analysis of all sources system & implemented the ETL architecture to support the migration

· Created and implemented the SSIS package for MDM/MRM project for BI Data warehouse application

· Experience in SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages

· Create package configuration file with connection information source, staging and destination database and send mail task connection information and log directory path value

I offered the multiple small businesses to setup, customize or third party ERP solutions.

• Taught end users to navigate ERP system by developing and presenting training sessions.
• Identified and resolved defects by developing test strategies, testing tools and test scripts.
• Managed customer expectations and relationships through easily understood explanations and clear communication.
• Implemented new ERP systems based on accounting requirements and user needs, assisting with system builds, testing and deliverables.
• Communicated and explained business requirements to team members to understand and implement functional demands.
• Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.

Duties as SQL Developer

· Designed and created database stored procedures, triggers, and functions. Created various reports in SSRS called from .NET front-end.

· Design and develop UI design for business users using HTML, CSS, ASP.Net, JavaScript, Vue and React

· Develop responsive website based on client requirement

· Work on custom back-end application for internal users

· Implemented, maintained, and documented policies, procedures, and standards to ensure security and integrity of test and production data.

• Utilized SSIS to manage and create ETLs to transfer data from various sources.

• Maintained and translated reports from Crystal Reports into SSRS.

• Developed and maintained a backup and recovery strategy for all databases.

• Created documentation for DRP (Disaster Recovery Process).

Duties as SQL Database Administrator

• Responsible for loading, extracting and validation of client data.

• Trace the Error logs for the ERP Database.

• Deals with the Query Indexes.

• Using SQL Profiler to get the query status that how much improvement required for that query. And then test it and apply on production.

• Check the Database file size and log size.

• Test the Database backup

• Liaising with end-users and 3rd party suppliers.

• Analyzing raw data, drawing conclusions & developing recommendations

• Writing T-SQL scripts to manipulate data for data loads and extracts.

• Developing data analytical databases from complex financial source data.

• Performing daily system checks.

• Data entry, data auditing, creating data reports & monitoring all data for accuracy.

• Designing, developing, and implementing new functionality.

• Monitoring the automated loading processes.

• Advising on the suitability of methodologies and suggesting improvements.

• Carrying out specified data processing and statistical techniques.

• Supplying qualitative and quantitative data to colleagues & clients.

Projects

• Internal

Acrodex is using SAGE ERP Application with backend SQL Server Database

· Looking after the DBA task for the ERP Application used by the Company

· Database Backup, Recovery Manager

· Using various tools to check the Database Performance

· Check Database Health

· Perform weekly disaster recovery on test servers

· Created and Maintained the Mirror Database

• External Client

Acrodex is the one the biggest Government Contractor in Alberta Region for sales and support for Computer Hardware, Server, Network. Recently they had introduced Cloud network for their client. My role as Oracle DBA:

· Database Migration from Physical/Virtual network to Cloud network.

· Database Performance tuning

· Database Backup/Restore procedure using RMAN tool Or Oracle tool

• Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
• Updated old code bases to modern development standards, improving functionality.
• Designed reusable and reliable code for use within distributed cloud environments.
• Translated customer requirements into written use cases.
• Led version control efforts for organization, employing public and open source repositories.
• Coordinated with project management on database development timelines.
• Designed customized solutions for proposals to potential customers.

Projects:

Visual Enterprise:

Environment: ASP.NET, Crystal Reports, SQL Server 2005/2008.

Application includes basic modules being Inventory, Finance & System Administration and covers full range of functional areas like Point of Sales, Restaurant management, Production, Quotations, Services, Contracting, Real Estate, Payroll and Fixed Assets.

Visual PLAN.net

Environment: ASP.NET, Crystal Reports, SQL Server 2000.
Software developed for the management of resources and plan the current / new projects according to the resources available.
Ensuring optimum utilization of resources available and avoiding overtimes etc. hence, ensuring maximum profits. Focus is on 3M model that is Man, Machine & Method.

VisualTours

Environment: VB / ASP.NET, Crystal Reports, SQL Server 2000.
Visual Tours in a complete package for Inbound Tourism market, managing Accommodations, Transportations, Tours, Visas and other services. It has a complete cycle from a quotation to Booking to raising an invoices from the booking and further makings its finance postings are taken care of along with generating Hotel booking vouchers, transport requests, transfer arrangements, visas.