AMER MEHDI
Scarborough, Ontario M1B 2C4
abouy9@r.postjobfree.com
To obtain a challenging Position as Business Analyst/ Data Processing position with opportunity for growth and career advancement.
HIGHLIGHTS OF QUALIFATIONS5+ years of Oracle Database analyses and development experience Highly skilled in Windows System support Windows 2000/ Windows NT and Windows 7 System support and trouble shooting.Highly Skilled in bulk processing and custom ETL development. Wrote SQL, PL/SQL programs including triggers and stored procedures for a Oracle-based Web HR database. Tuned the Oracle database performance. Strong data / object modeling, data normalization, and data analysis. Expertise in Production Oracle 10g/11g environments including RAC, PL/SQL, OEM, RMAN, Data Guard and shell scripting Exceptional technical skills with DB2 and appropriate mainframe OS and products.
TECHNICAL SKILLS:
Languages and Software: C, C++, Java, Visual Basic, VB.NET, SQL, PL/SQL, Oracle Forms and Reports, HTML
Databases : ORACLE,DB2, Microsoft Access
Operating System : Windows7,Windows 2000, Windows XP, UNIX
WORK EXPERIENCE
IT Manager
PM Management Co. August 2011-Feb 2012
Provide the System Support and trouble shoot the System errorsDocumented Data Conversion Requirements and StrategyAnalyze the conversion scope, objectives, approach, requirements, and the strategy for how the conversion will be performed. Prepare the conversion environment for the development and testing of the conversion programs.Data conversion from A&L software System to Optimed Sofware Test the performance of each of the individual conversion program modules.Provide the System Support and trouble shoot the System errors
Perform Conversion Validation Tests
AMER MEHDI 416-***-**** Page 2/1
DB2 System Programmer
RBC Down town July2010 - June 2011
Manager / Technical Specialist at Review and modified T-SQL queries and stored procedures DB2 systems programming in a very large environment.. Studied and test implementations different strategies for temp tables, indexes and temp databases Analyze, define and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration. Create test plans, test data sets and automated testing to ensure all components of the system meet specifications. Provide technical consulting and respond to error reports, problems or questions.
Data Processing Assist. Jan2010 –May 2010
Responsible for gathering, identifying, and retrieving data from various systems. Update and process ESN codes for newly processed units information on TELUS Data Swift Software SystemDevelop customized client reports with SAP R/34.70Design, Construction and Support of Crystal reports for internal data analysis Designs reports and assists in the design and implementation of a reporting infrastructure to support the business reporting needs, Maintaining the units Supply information to the Locate Vendors Supply information in to the System with ( MM ) SAP R/34.70Other Data processing operations as per requirement (Statistics Performing vendor analysis, to monitor whether a certain vendor delivers a material on time and in the desired quantity
AMER MEHDI 416-***-**** Page 3/1
PL/SQL Developer
United Bank, Karachi May2003-Jan 2008
Analyze code for problem resolution and performance optimizationsOracle 9i PL/SQL Systems Programmer at United Bank Exceptional technical skills with SQL and appropriate mainframe OS and products Design and develop a systematic business plan as per the clients' specificationsAssist in product development process and ensure the organization has sufficient resources; the product meets Clients demands and quality specifications; and analyze the product's revenue generation capacity.Collect and analyze data about the performance of product, service or project in the market and submit performance evaluation reports on daily/weekly and monthly basis.Coordinate with the Head office to make decisions on financial aspects like budgeting, cost analysis, revenue generation etc of concerned projectsWrite and maintain functional and technical specifications.
EDUCATION
MS (Information Techonology) 2004 Preston Institute of Management Science & Technology
Diploma in Computer Science 1994
International College of Computer Science
REFERENCES AVAILABLE UPON REQUEST