Operating Systems

Windows NT/XP /Server, Linux,Unix ,Solaris,AS400

Databases

Oracle 6,8,9i,10g ,MSSQL 2000,2005,2008 ,DB2

Scripting Languages

Unix SH Scripting, VBscript -WSH /WMI and

Dos Batch ,Perl

Web-Development Languages and Scripting

HTML/CSS, JavaScript ,VBScript and Visual Web

Developer ASP. Net ,PHP

Database Scripting Language

PL/SQL ,T-SQL

Application Developing Tools

Visual Studio 2005/2008 2.0 and 3.5 .Net Frameworks ,Oracle Developer Suite,PL/SQL Developer,TOAD,SQL Navigator ,LLBL ORM Tool ,Oracle Discoverer 4,QBMSXML api Quickbooks Merchant Services XML api ,EWS Exchange Web Services api

BI Tools

Oracle Discoverer 4

Web Server/Application Server Technologies

IIS6/7,Apache,Oracle Application Server

Code Versioning

SVN,Visual SourceSafe

Company

Confidential

Position

Database Developer Junior DBA Functions

Client:

Environment

Windows, IIS, T-SQL,VBscript,ASP.net/C ,SQL Server DTS, Crystal Reports, SSRS,SQL Server 2008,CollabNet SVN, QBMSXML api QuickBooks Merchant Services XML api ,EWS Exchange Web Services api

Responsibilities

• Analysis and Design of Information System modules via reverse engineering of existing code and database structures.
• Design and creation of enhanced and newly developed modules, via refactoring database objects and data migration plus instructions.
• Analyzed and establish business processes related to financial stats , reconciled financial stats related to third party services and created database structures for supporting and identifying AR and AP, identified problems in the Business process later on mitigating problems, and also identified revenue points obtaining over 60k .
• Managing of resources for deliveries of short-term project deliverables.
• Analyzed and transcribed Business Requirements to IT by the creation of ERDs and Flowchart diagrams.
• Established and integrated controlled environment for DEV and UAT environment using versioning tool CollabNET SVN and migration of Database to each environment via Database restoration process.
• Created ETL scripts for data migration between two IS based on reverse engineering/System Analysis functionalities from both systems.
• Analyzed and created performance reports for end users and contractors for identifying possible causes of fraud and delinquent performance rate and aging reports.
• Enhanced performance load on the database for login modules from 3 min to 10 seconds and dashboard modules by 80 by applying indexes and refactoring stored procedure t-sql code .
• Maintained Asp.net forms by modifying and refactoring code for meeting newer stored procedure specs and also created interface to handle simple middle-tier communications tasks by triggering an event from the database calling an asp.net form on the frontend utilizing stored procedures and asp.net/C and SQLServer DTS task.
• Analysis, design and code for backend ETL solution that fetches emails data that filters based on predefined content keywords and later on persisting the data to backend with C and EWS Exchange Web Services
• Prototyped E-commerce Credit Card payment gateway with QuickBooks Merchant Services XML api, ASP.net/C FW 4.0 and created backend database objects for persisting the data.

Company

Confidential

Position

Oracle Database Developer

Client:

Confidential

Environment

Unix,Windows,IIS,Unix Shell scripting ,Perl,PHP,PL/SQL,SQLLDR,External Tables,Oracle Discoverer 4,Oracle Enterprise Manager,TOAD,ROBO FTP Scripting,Oracle Database 9i,10G

Responsibilities

• Optimized and Reorganized database structures to meet the client expectations and deliver credible data .Increased by a 60 the data credibility by normalizing and enforcing data constraints within the database for the Customer and Loans Admissions Department.
• Responsible for the Analysis, Designing, Coding and Documenting of the Database modules and processes .
• Creation and maintenance of the Data Warehouse objects ,Business Intelligence reports and supporting back-end database objects.
• Creation and maintenance of Automating tasks that are orchestrated between the Databases and OS for handling ETLs and Batch processes for the Compliance , Accounting and Admissions departments.
• Give support to Users and Auditors by creating adhoc queries and/or reports and communicating with frequent JAR/JAD sessions.
• Reversed engineered and analyzed the client's Loan Decision System workflows process which resulted in more effective and credible reports.
• Created BI Reports for the Admissions department for monitoring the centralized office employees and branch employee's performance.
• Maintenance of the Client's applications by providing database objects and integrating them within the applications.

Projects and Deliverables

PL/SQL and Oracle Discoverer

• Database Normalization /Applications Database
• Created and implemented a newer normalized database environment for the subscriptions/Applications database, with enforced referential integrity and unique constraints ,supported the database with dimension tables ,cleaned duplicated data.
• That was the first step needed for a series of reports for the Admissions Department being developed could be created with the most safe and trusted data.

Development tools used : PL/SQL

Confidential

• Design and implementation of Extraction Transforming and Loading data from a relational download extract into a newly created normalized, constrained referential and unique constraints environment.

Development tools used : PL/SQL ,Oracle External Tables , Unix Bash SH

Company

Confidential

Position

Oracle Database Developer

Client

Confidential

Environment

Unix,Windows,IIS,Unix Shell scripting ,ASP.NET /VB.NET,VB6 ,PL/SQL,Crystal Reports,T-SQL,MSSQL Server 2000 and 2005,Java Based Application,Oracle Database, 9i,7, VBScript,AS400,AS400 IBM Client Sdk,LLBL ORM

Responsibilities

• Responsible for the analysis,design,coding and documenting of the database modules supporting the Billing,Treasury and Accounting departments for the In-House Information System.
• Creation and maintenance of centralized Crystal Reports and their respective database backend objects.
• Monitor ,diagnose and troubleshoot the performance of daily backend processes for Batch and online processes running in the database ,test and deliver promptly corrections.
• Create,convert and modify new or existing applications that support the In-House Information System for new added functionality or correct existing bugs.
• Aid and support Users,DBAs and Project Managers by communicating frequently via JAD/JAR sessions.
• Review ,analyze and prepare Project's hour estimates and deliveries by documenting and creating Project's Plans and Statements of work.
• Collaborated and brought support to the Client's special projects such as :Tax Informative Returns 2008 Achieved ,for the first time ,the culmination of the projects 1 week before the project's deadline,this once a year project always culminated 2-3 weeks after it's deadline.

Projects and Deliverables

• Tax Informative Returns System / Application
• This application Maintains and prepares tax informative data 480.6x,480.7X forms from payments to Agents, Providers and BI Bodily Injury Claims paid .The application extracts the data from various Information Systems where the P C ,Life ,Health policies are stored. The user is able to modify data for all payments and payee personal data : addresses ,names ..etc ,and then the user generates an archive for the PR PAY software where the user generates an archive for Hacienda

Development tools and languages used : SQL Server Management Studio/T-SQL,PL/SQL Developer/PL/SQL,ASP.net/C .

• AutoPlan Billing and Printing Automatization Process
• This task processes policies /supplements that automatically identifies AutoPlan Auto Insurance product Policies ,processes cancellations ,reinstallations ,prints a batch of documents Billing and Pre-Billing notifications ,and transfers a digital copy of the documents into the WISE Document Management System