Forum | Russian | FAQ | SiteMap | Contact Us








123456789

Resume 7

Astansir Sawala
WASHINGTON, DC

H1B Visa Holder

Summary
  • Systems Analyst, Project Leader, Web Developer, Application Developer, Lead Oracle DBA.
  • 13 years of progressive experience in all phases of application development life cycle.
  • Proven analytical, Designing, Development, trouble shooting and managerial skills in development/Production environments.
  • Expert in ORACLE DBMS, Web Technologies, C, and COBOL.
  • 9 years Application Development experience using ORACLE
  • 6 years Project Leader experience 12 Programmers, various Projects.
  • 2 years Oracle Database Administration
  • 2 years in Web Development
Skills
  • Platforms : NCR 3450 with 2 * RAID class 6298, 6257.

  • Database : Oracle 8.x, Oracle 7.x

  • OS : UNIX, Windows 2000, Windows NT 4.0, Novell

  • Development Tools : Designer 2000, ERWIN 2.6, Developer 2000, SqlForms 3.0, Report Writer 1.1, SqlPlus, Pro-C, SQLDBA, Server manager.

  • Web Tools : Java Script, VB Script, XML, JSP, Servlet, JAVA, JDBC, SQLJ, Dreamweaver, ColdFusion.

  • Networking : Install & Configure Networking & Communication Equipments and Protocols like TCP/IP, IPX, DNS, WINS, DHCP, etc.

Academic Education

Diploma in Financial Management, 1989, 61
Bachelor of Commerce, 1988, 64

Professional Education

Oracle Certified Professional Oracle 8i DBA Track , 2002, 80
Oracle Certified Professional Oracle 8 DBA Track , 2001, 94
E-Commerce, 2000, 80
Programming in JAVA, 2000
Programming in COBOL & DBMS, 1989, 90

Experience

04/2002 - Till Date
Seagal Consultants Inc., Washington, DC

  • Analyze, Design and Development of Web Applicationfor Online Media Sales using tools/technologies like Dreamweaver, ColdFusion, JSP, Servlet
  • Setting Up Web Development Environment

OS - Windows 2000 Professional
Web Server - Microsoft IIS
Application Server - Apache Tomcat
Database - Oracle
Development Tools - Dreamweaver, ColdFusion

03/1993 - 03/2002
Yousuf LLC, Dubai, United Arab Emirates MIS Dept

Developer/Systems Analyst/Project Leader/Lead DBA-Oracle
  • Analyze activities of various Divisions/Departments
  • Data Modeling/Design New Business Applications, New functionality / Modifications into existing Applications.
  • Developed Applications - Have had various level of Involvement:
    • Writing database triggers and procedures.
    • Developed Screens using Oracle Forms 4.5.
    • Developed complex reports using report writer 1.1/ 2.5
  • Developed Schema Objects & Constraints , Back End Core Modules.
  • Application Tuning to enhance the performance of Applications.
  • Guide, Advice & Supervise Staff of MIS Dept.
  • DBA Task - Designed new Oracle 8 database.
    • Planning the Physical & Logical Layout of Database.
    • Writing Scripts to monitor Database performance.
    • Planning & Implementing effective Backup and Recovery mechanism.
    • Creating & Maintaining Schemas
    • Creating & Maintaining User Accounts
    • Configuring Clients to connect to database using HOSTNAMES, TNSNAMES, DNS, TCP/IP.
  • Design & Development of a Web Site for Online Automobile Information using diverse technologies like JavaScript, VBScript, JSP, XML, Java, Dreamweaver, ColdFusion.
  • Evaluate Products.
  • Migrated data of COBOL based application to an Oracle database.
  • Developed following Business Applications
    • SMS Short Message Service
    • Barcode Scanner Programming
    • General Ledger
    • Customers & Credit Control
    • Finance Management
    • Accounts Receivables
    • Accounts Payables
    • Job Costing
    • Inventory Control Discrete & Non-Discrete Products
    • Sales & Customer Order Tracking
    • Purchase & Ordering
    • Manufacturing
    • Payroll
    • Renting & Leasing
3/1990 - 2/1993
Yousuf LLC, United Arab Emirates Software Consultancy Dept

Software Consultant / Developer - COBOL
  • Technical discussion with Clients
  • System Analysis, Design, Develop & Implement Customized Software.
  • Suggesting clients on Hardware & Networking solutions.
  • Analyzed, Modelled & Developed following Applications:
    • Integrated Accounts, Inventory & Production Job Control System
    • Integrating Accounts and Service Job Control System
    • Integrated Accounts, Payroll and Job Costing for a Garment Factory.
    • School Time-table Module.
    • Car Financing Module.
  • Installing & Configuring OS & Networking
    • Xenix, Unix, Novell
6/1989 - 2/1990
Zerind Limited Pharma & Chemical Manufacturing Co. , India

Programmer - COBOL & Foxbase+.

Programming, Implementation, Maintenance, Documentation, Enhancement of different program Modules like:

  • Sales,
  • Share Accounting,
  • Payroll,
  • GL,
  • Receivable & Payable.

4/1989 - 2/1990
Shantilal C Mehta & Co., India Part Time

Analyst Programmer - Foxbase+

System Study, Design, Developed an Integrated Accounts & Inventory Application.

Place/ Date of Birth

Bombay - India / July 29, 1966



123456789











Untitled Document