\

Noman Ali Syed

PROFILE


Address: 43 Thorncliffe Park Drive, Apt: 1720, Toronto, ON, M4H 1J4, Canada
Cell: +1 (416) 471-1461, Email: thengo@dkmif.org

 

An Oracle Professional having 13 years of diversified experience of working in various roles in number of well renowned organizations.

Over the period I acquired experience of studying, analyzing business needs, gap analysis, designing and developing IT solutions for number of industries such as Banking, Telecommunication, Steel Processing and Fabrication, Manufacturing, Glass, Cement, Sugar, papersacks, IT Consulting Services and R&D.

My strong analytical and solution designing skills, systematic problem solving approach, service oriented attitude, capability to handle pressure and challenging situation, good inter-personnel skills, in-depth planning and monitoring skills, and ability to work with bio-diversified work force are the main contributors of growth in my career.

I demonstrated my skills in following area

· Software development using Oracle developer suite 6i/9i/10G, Oracle Discoverer and APEX.
· Conversions, upgrades and custom development of various oracle based business applications.
· Oracle scripting SQL and PL/SQL and UNIX SHELL scripting.
· Data modeling experience using ERWIN and Oracle Designer.
· Design and development of interfaces and conversion routines to integrate Oracle applications modules and external packages and customer applications and extract data from various sources into Oracle application using SQL Loader and other tools.
· Design and development of Application Programming Interface (API) and Electronic Data Interchange (EDI).
· Proven expertise in configuration management using VCS and VSS, project planning using Microsoft Project and users training.
· Understanding of ORACLE E-Business Suite includes Oracle Financial, Fixed Assets, Inventory Control and Supply Chain Management.
· Understanding of OLAP, ETL, and data warehousing.
· Understanding of dimensional modeling, star schema and snow flake schema modeling.
· Understanding ETL methodology for support data extraction, transformations, loading to process solution.
· Self starter, deadline driven with ability to work in challenging roles.

TECHNICAL SKILL SUMMARY


Platforms: All Microsoft Operating Systems, UNIX, Linux, OpenSUSE, Sun Solaris, PRIMOS, AIX, AS400
Languages: SQL, PL/SQL, SQL*Plus, Visual Basic, Java, Armstrong Basic Plus, Cobol, Shell, Perl
Databases: Oracle 7/8/9i/10G/11G, SQL Server, Microsoft Access, My SQL
Development Tools: Oracle 6i/9i/10G DS (Forms/Reports), Oracle APEX, Toad, Oracle SQL Developer, PLSQL Developer
BI Tools: Oracle Discoverer
Case Tools: Oracle Designer, ERWIN, Rational Rose UML Designing, Microsoft Visio
Version Control: CVS for Unix , Visual Source Safe (VSS)
Others: Microsoft Office, Microsoft Project, Lotus Notes, Oracle 10G Application Server, Oracle 10G Wireless Portal

EXPERIENCE

· As an IT Consultant of Steelman Software Solutions Inc. I reporting directly to technology director and establish performance reporting mechanism. I am responsible to provide technology solution to North American (Canada and America) Steel Industries to identify, plan, execute and monitor software, studied and analyzed business needs for automation, transformed business need into system requirement, conceived information system framework and infrastructure for our clients such as Olympic Steel Inc. (USA), Pacesetter Steel Service Inc. (USA), Pakdale Steel Inc. (Canada), Midland Steel Inc. (Canada), and Steel Warehouse (Mexico).
· Designed, developed and Implemented ERP (SEMS) Oracle 10g RDBMS, Oracle 10G Developer Suite, Oracle 10G Application Server (Mid tier infrastructure, Form Server and Report Server), Oracle 10G Discoverer (Business Intelligence) and Oracle 10G Wireless Portal.
· Prime responsible for customization, enhancement and bug fix of some of the modules in existing ERP (SEMS) such as Production, Shipping, Planning, Fabrication, Order Management and Financials using Oracle 10g Developer Suite, PL/SQL, TOAD, PL/SQL Developer.
· Designed and developed Oracle scripts (database package, procedures and functions) for EDI.
· Unit Testing, Functional Testing, System Integration and Testing
· Provide implementation support as well as after sales support.
· Documentation related to software development life cycle.

· As an IT Consultant of Sigma Software Solution Inc. I reported directly to Development Manager. I was responsible to coordinate Number Pool Management for European client TV Cabo, designed and developed for technology solution software for Telecomm reseller and wholesaler Matrixx Telecommunication Inc, with collaboration of Rogers Telecommunication Inc, Canada as service provider for Home Phone and Long Distance services and also provide solution to accommodate Canada government requirement for Wireless Number Portability between Home Phone and wireless service and vise versa.
· Conceptualized business needs to business requirements, designed and developed Order, Customer and revenue Management software product for Telecommunication Industries and vertical market. This software product is well capable to take of all business needs related to Home Phone, Long Distance and Calling Card services as well as Number pool Management and Number Portability.
· Designed & developer Oracle backend packages, store procedures, functions, triggers and shell scripting related to Order Provisioning module for Telcare (Matrixx Communications Inc.)
· Developed, tested and deployed a migration process for home phone services from BELL to ROGERS’s network.
· Developed Test Cases for migrations process of Home Phone services and Long Distance.
· Designed & developed Oracle backend packages, stored procedures, functions and triggers related to Remote Order Entry (Web interface for HBC and Sears) for Telcare system (Reseller and Wholesaler databases)
· Developed an interface to capture remote order entries (ROE) taken by HBC or SEARS websites into Telcare system.
· Responsible for the analysis, designing, programming, debugging and modification of different modules including Load CDR, CDR rating, bill summary, Feature Billing and Order Provisioning modules.
· Assist Project/Team Leader in technical documentation.
· Assist Team Leader in Training of other operational staff including CSR`s and Service Bureau.

· Software requirement analysis, design and implementation, database design and data modeling.
· Designed and developed of Oracle 9i Forms and Reports, PL/SQL code and Oracle Discoverer Reports
· Unit Testing, Functional Testing, System Integration and Testing
· System support and maintenance
· Designed and developed Oracle database packages, procedures, functions and triggers related to Electronic Data Interchange.
· Developed and customized steel production and planning modules in Steel Enterprise Management System using Oracle development suite 9i on front end level and using TOAD on backend level.
· Provide implementation support as well as after sales support.
· Documentation related to software development life cycle.

· Designed & developer Oracle backend packages, store procedures, functions and triggers related to OSS billing module.
· Designed & developer Oracle backend packages, store procedures, functions and triggers related to Order Provisioning module for Telcare (Reseller and Wholesaler databases)
· Responsible for the analysis, designing, programming, debugging and modification for Order Provisioning module.
· Create SQL and PL/SQL Scripts to perform DML and DDL activities for customized requirements.
· Developed Test Cases for Order Provisioning Module.
· Assist Project/Team Leader in technical documentation.
· UNIX Shell Scripting.
· Preparation of test environment and test case documents.

· As a Manager Systems/Project Manager of Ghulam Faruque Group of Companies and Zensoft Software Private Limited. Lead the team of 20 IT professionals, spread over 3 factory locations and 4 branch offices in Pakistan, to identify, plan, execute, monitor and report Information Technology projects.
· Designed, Developed and implemented comprehensive software product consists of multiple integrated modules. The Software consists of GL, AR, AP, Sales and Distribution, Purchase & Imports, Inventory, Customer Services, Payroll and Fixed Assets. The software covers Act as a manager systems, architect, project manager and implementer.
· Analyzed and architect Plant Maintenance System which was implemented in Cherat Cement Co. The software features automatic preventive schedules generation and forecasted parts utilization per month and was implemented in Oracle RDBMS v9i and Oracle Developer 6i.
· Implemented work-flow based Voucher Approval System that was developed in Lotus Notes Domino (v6.5) in all Ghulam Faruque Group Companies.
· Studied business procedures and prepared gap analysis report to assess the magnitude of changes required to modify Zensoft suite of applications for Greaves Pakistan Ltd. Prepared software change plan and system implementation plan. The software consists of Financial, Supply Chain, CRM and After Sales Service areas.
· Conducted the business requirement study phase, evaluated, selected & implemented Oracle Financial Application to carry out financial functions. In the first phase General Ledger, Accounts Receivable and Accounts Payable modules were selected to implement. Build and led the team for implementation. Acted to assessed General Manager and Director to make final decision in all sort of design and parameterization aspects.
· Assessed business requirements, designed and developed Material and Inventory Control and Monitoring System in Oracle RDBMS v8i and Developer 2000.
· Analyzed, designed, developed and implemented integrated Personal & Payroll System.
· Assessed to Carried out preliminary study to identify company processes, automation requirement and scope and also assessed Prepared detail proposal consists of IS solution framework, cost, timelines and acquired multi-million Rupees projects of big brands like LG, Atlas Group, Standard Chartered Bank, Dawlance (biggest home appliances Co. in Pakistan) and Naudero Sugar Mills.
· Actively participate in application development walk through meetings related to Zensoft clients and other group companies.
· Assessed Higher Management to develop a long-term Business Plan for Zensoft (Pvt.) Ltd.

· IT Consultant for application development team and Y2K Compliance team.
· Provide consultancy on IT operational/functional areas such as system analysis, design, development, implementation, support, change management, resources allocation, team building, functional design and testing as IT Consultant

· Key member of Migration from old banking system to new banking system (Systematic) located in Citibank Singapore. To implement systematic in Citibank migrated all Customer Data of Credit Cards System, Consumer Banking System, Citiphone Banking System, One Step Relationship Banking System, Current Account Saving Account System (CASA), Core Banking System, and Delinquency Tracking System. This process includes designing interfaces for data transformation, Testing and Live Implementation. I was involved in live implementation coordination with Singapore Team.
· Responsible for enhancements, modifications and support and development of interfaces for Citiphone Banking System to facilitate the Phone Banking operators and IVR (Interactive Voice Response) machine to provide better customer services in effective manners.
· Design and Implement various new modules of Phone Banking System such as Utility Bill Payments, Fund Transfers (local/International), Pre-Approve Fund Transfer, Fax Back, and IVR, which results increased in customer portfolio by 20% and consumer banking end. Citibank was the first consumer bank in Pakistan who introduces a large variety of customer Tele-Banking facilities and products.
· Integrate consumer credit banking to Phone banking system.
· Provides production support of their online systems. That includes online process monitoring, support service, end of day process support service and end user interaction of their incoming issues and problems.
· Worked with Citibank Project Managers to conduct user acceptance testing includes business cases, test scripts and manage change requests.
· Worked as active member of new banking system (Systematic) implementation team, and design and develop interfaces for data downloading of various products of Citibank includes, Phone Banking System, Consumer Banking System (Customer Accounts), Credit Card Banking, and Personal Finance Banking (Auto Loans, Personal Loan and Housing Loans).
· Design and develop interfaces to transform customer data of countrywide branch network, interfaces for data verification and live implementation.
· Design and coding program, procedure, functions and packages related of different banking software as per specification.
· Prepare documentation related to banking system.
· Provide production support of their mailing system (PakMail).
· In additional, I was also the member of the team whose services were essential for Data Processing beyond normal working hours.

ACADMICS

· M.B.A - MIS in 2001 (from Preston University, Karachi)
· B.Com. in 1999 (from Jinnah Govt. College, Karachi)
· Diploma in Computer Science (Software) in 1993.

ON JOB COURCES / WORKSHOPS / CONFERENCES

· Unified Modeling Language course (UML) from UBITECH, Karachi.
· Oracle Database Administrator (DBA - Oracle 7) from ORA-TECH Systems, Karachi.
· Oracle E-Business Suite - Oracle Financial (GL, AP, Fixed Assets, Supply Chain Management, Purchasing, Inventory modules) from Haven Education and Training Center, Karachi.
· Oracle Developer 2000 from Zensoft Private Limited, Karachi
· Lotus Notes Administrator from Zensoft Private Limited, Karachi.
· Micro Focus Revolve 2000 from Zensoft Private Limited, Karachi.
· Micro Focus Workbench 2000 from Zensoft Private Limited, Karachi.
· Micro Focus SmartFind 2000 from Zensoft Private Limited, Karachi.
· Several conferences and exhibitions in Canada

MEMBERSHIP

· Member of The Ontario Association of Certified Engineering and Technician and Technologist since August 2004 (OACETT; Membership # 827220)

AWARDS / APPRECIATION

· Recognition Award in Implementing New Banking Systems (Systematics) in Citibank N.A Pakistan.
· Appreciation letter from Director of Zensoft Private Limited.
· Appreciation letter from General Manager of Zensoft Private Limited.