|
|
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
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
|
|