We provide IT Staff Augmentation Services!

Bi /dw Developer Resume Profile

4.00/5 (Submit Your Rating)

SUMMARY OF QUALIFICATION

I am an IT professional with 13 years experience in windows based client-server/web application development using PowerBuilder, Visual Basic, and ASP.net. I have been actively using Microsoft SQL Server, Sybase SQL Server, Oracle 9i/10g for database management and support. The projects I have been involved in were related to various aspects of business applications including Financial, Inventory Management, Telecommunications, Airline, Gaming and Data Warehousing.

II.

SUMMARY OF TECHNICAL PROFICIENCY

TOOLS

TECHNOLOGY

OPERATING SYSTEMS

:

Windows 98/NT/2000/XP/2003/HP UX/Solaris

DATABASE SYSTEMS

:

Microsoft SQL Server 2000/2005 , Oracle, Sybase SQL Server, Access 2000, MYSQL

PROGRAMMING LANGUAGES

:

PowerBuilder ver 4/6/7, Visual Basic 4/5/6 .NET, Java Programming, Developer 6i, HTML, JavaScript

SOFTWARE TECHNOLOGIES

:

Crystal Report ver 9.0, SQL Server Reporting Services, Microsoft Sharepoint 2007, Qlikview

HARDWARE AND PERIPHERALS

:

OTHER APPLICATIONS

:

NT Administration,TCP-IP, Bourne Shell Scripting HP AUX , PERL, MS Exchange 5.5/ SQL Server/Apache Tomcat/IIS 6.0

III.

PROFESSIONAL BACKGROUND

Confidential

POSITION: BI /DW Developer

  • Responsible for reviewing current Business Intelligence BI architecture, providing strategic and technical solution recommendations, participating in the creation and ongoing updates to the BI strategy roadmap, translating requirements into reporting solutions, systems upgrade planning and scheduling, user acceptance testing and subject matter expert training in order to deliver effective reporting solutions.

Confidential

4

POSITION: Senior Operations Analyst

  • Proactively monitors status of application products being hosted for Navitaire clients, responding to alerts and user requests, troubleshooting and escalating as necessary. Resolve online issues for production environments. This could include coordinating with other teams in the organization and customers globally until service interruptions are resolved. Responsible for developing tools which would automate the existing manual process and support the core product application.

Major Projects Handled

Tools/Technologies Used

Sun Solaris Operating System

SQL Server 2000/2005, Oracle , Sybase Server

Perl/C-Shell Scripting

C .Net/VB.Net

Confidential

  • To support, maintain and further develop departmental website and applications. To analyze the groups software requirements, new or changed product and processes and carry out the complete change process - design, development, test, implementation and end-user support. Analysis of user reporting requirements

Major Projects Handled

Tools/Technologies Used

  • Network Rollout Database monitors the progress of the cell sites construction, from nomination to the time it was put on-air
  • Vendor Survey Tool
  • Conversion of Nokia Datawarehousing to Local/Inhouse system

Frontend ASP.net/Crystal Report ver 9

Backend - SQL Server 2000

Frontend - ASP.net/Crystal Report ver 9

Backend Oracle 10G

Frontend SQL Server Reporting Service/ASP.net

Backend Oracle 10g

Scripting Shell/Perl Scripting

POSITION : Datawarehouse Developer/ Programmer 2

Confidential

To support, maintain and further develop corporate DataWarehouse DWh . Provide technical support for the configuration, management, and optimization of Microsoft SQL Server Datawarehouse in banking system. Assure performance monitoring, Initiate and implement appropriate enhancements for performance tuning, Act as primary point of contact for information related to DWh, support and train users on reporting / querying, Perform tasks of application and database architect, further develop existing program modules and database objects, Actively gain and maintain necessary database administration skill set and closely cooperate with IS DBA group, Responsible for the extraction of data from a heterogeneous source into a text file format, Backup and Restoration of Database, Responsible for developing the cubes and dimensions for warehousing, Responsible for the development of the datawarehouse vb6/.net maintenance application .

Major Projects Handled

Tools/Technologies Used

  • Datawarehouse for the GL/Budget and Control Module of the bank
  • .Net Program to Automate ETL Extraction/Transfer/Load of data

Analysis Services/MS SQL Server 2000/VB6/VB.Net

VB.Net

10/2001 to 5/2003

POSITION : Analyst/Programmer

Confidential

Assist with the development and support of nationwide system environments, Responsible for analysis, implementation and support of all systems related to the main system, Provide technology expertise and support to the deployed project, Provide hands-on programming work and support in the server and workstation, Provide hands-on support for installations and deployment of package standards, Install and support solutions

Major Projects Handled

Tools/Technologies Used

  • Motor Vehicle Registration System/Driver's License System
  • Motor Vehicle/Law Enforcement Traffic and Adjudication /Revenue Collection System Statistical Reports summary reports for the apprehended motor vehicle
  • Viewing Facility for Revenue Collection a tool which extracts data from a nationwide system and sum up all revenues collected in each region.
  • Requisition/Issuance module for Inventory Management System
  • Manual system transaction for Motor Vehicle Registration and Driver's License System enables the district offices to transact data even if they're not connected to the main server. Once on-line, all offline transactions will be uploaded automatically to the central database.

Powerbuilder 7/Visual Basic 6/Sybase SQL Server 11/12

POSITION : QA Software Engineer

Confidential

Responsible for testing products due for release by formulating test cases which will be used to determine bug severity and product performance on multiple platform/environment. Responsible for planning, leading, organizing and coordinating work activities of quality assurance department relative to the development and implementation of quality procedures.

POSITION : Analyst/Programmer

Confidential

Responsible and involved in the design and development of a required client server systems, from the initial phase of data gathering, prototyping up to the programming, testing and training of end- users.

Major Projects Handled

Tools/Technologies Used

  • School Collection and A/R System - Monitors the daily collection and payment pertaining to student billing and keep track of the outstanding balances of every student per school year and section. The system can print reports on different format and extracts data, which then can provide the finance department, accounts receivables per level and per grading period.
  • Seamen's 201 File System - Provides the needed information experience, dependents, Beneficiary, list of seamen per region needed to process the benefits of all union members. The system is directly linked on another module, Billing and CBA system. It can generate reports on different format and query criteria as each user may require.
  • Registration/Grading System - Directly linked to A/R collection System. The Program enables the record section to keep track of all incoming students and provide on-line information for each student active/inactive .

Powerbuilder 7/Visual Basic 6/Microsoft SQL Server 7

We'd love your feedback!