SUMMARY:

• An accomplished Information Technology Professional with experience in systems analysis, programming, design and development of applications for the insurance, manufacturing (such as purchasing, billing and inventory), mutual fund financial, government systems, social services, maritime communications and shipping industry.
• Area of technical expertise is with GUI front - end development using Powerbuilder and Visual Studio.Net with an open architecture set up using MS-SQL Server, Oracle, Sybase ASE, Sybase SQL Anywhere and DB2 and other RDBMSes as database back ends.
• Experiences include knowledge of object oriented development, business intelligence, data replication, data conversion, data modeling, database migrations, systems analysis, programming, debugging, implementation and maintenance.
• Also performs minor DBA responsibility, such as creating and maintaining tables, indexes, relationship, triggers, functions and stored procedures and granting privileges to users.

TECHNICAL SKILLS:

SOFTWARE: OBIEE BI Publisher, Informatica Power Center, WebFOCUS Report Writer, PowerBuilder 4 TO 12.5, Visual Studio.Net, SQL, PFC, POWERTOOL, ERWIN, POWER DESIGNER, CRYSTAL REPORTS, INFOMAKER, JAVA SCRIPT, HTML, COLD FUSION, VISUAL BASIC.NET, C#, TURBO PASCAL, TURBO C, MACRO ASSEMBLY, WINDOWS 95/98, WINDOWS NT, WINDOWS 2000, WINDOWS XP, MS SQL SERVER, SYBASE SYSTEMS 10, SQL ANYWHERE, ORACLE, DB2, FOXPRO, FoxBASE, DBASE 3 PLUS, PVCS, MKS, VISUAL SOURCE SAFE, LOTUS NOTES, CVS

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Application Analyst

Responsibilities:

• Working as Applications Analyst for Confidential CRM Systems Group as an OBIEE BI Publisher Developer. Upgraded CRM reports from SAP Business Objects to Oracle OBIEE BI Publisher environment. Installed and configured OBIEE BI Publisher for Development and QA environment.
• Create OBIEE BI Publisher reports using Word RTF templates on BI Publisher Desktop. Create and write SQL queries for different reports and ad hoc purposes.
• Uses TFS for version control and build management. Create, enhanced and maintains functions, stored procedures and packages using Oracle PL/SQL.
• Support and maintains internal Bill Viewer, a VS.Net C# application specifically created for Confidential .
• Worked with GIS and Engineering Systems group and uses ESRI ArcGIS application suite to support the GIS group operations.
• Use Visual Studio.Net 2013 for GIS customization and Oracle 11g for enterprise backend database and SQL Server Express 2008 for locally managed databases.
• Uses Silverlight 5 on C#.Net to develop and maintain GIS website used over Confidential intranet.
• Successfully upgraded and implemented the GIS web application highly customized for Confidential used and environment.

Confidential, Richmond, VA

Sr. Programmer Analyst

Responsibilities:

• Worked as a Sr. Programmer Analyst for Confidential with the Compliance Repository team.
• Primary duties include support for compliance repository data warehouse that is being used for tax audit purposes, support for users’ application that is being used by the user to access data from the warehouse, reporting and systems interface.
• Uses Informatica Power Center 9.x to manage data warehouse activities such data mining, creating ETL processes and data porting.
• Wrote SQL queries for various uses and ad hoc request.
• Interface Siebel CRM information with our data warehouse.
• Use Access, Business Objects to create users interface with the DW.
• Obtain data from different data sources such as flat files, spreadsheets, different RDBMs, mainframe and the like to be use for ETL jobs.

Confidential, Sacramento, CA

Responsibilities:

• Primary duties include systems analysis and design, systems programming, systems testing and debugging, systems implementation and systems maintenance.
• He has used tools like Powerbuilder, Visual Studio.Net, Crystal Report, and other GUI development tools.
• Utilized different RDBMS like ORACLE, MS SQL Server 2008, Sybase System 10 and 11, DB2 and the like.
• Perform data mining activities to create data marts and data ware house using Informatica Power Center

Confidential, Jacksonville, FL

Business Intelligence Web Developer

Responsibilities:

• Involvement in Customer Hierarchy and Accounts Payable Projects as one of the report writer using WebFOCUS Report Writer.
• Create dashboard components for Web FOCUS report.
• Successful migration of an in-house Powerbuilder applications from version 6.5 to 12.5
• Successful database migration MS SQL Server 2000 to MS SQL Server 2008
• Successful system upgrade, enhancement and implementation for ICECUBE and ORBIT
• Successful integration of a 3rd party taxing system (Vertex O) to the in-house billing systems (ORBIT)
• Stores source codes and compiled codes into CVS version control using WinCVS.

Confidential

Sr. Powerbuilder Consultant

Responsibilities:

• Worked as a Sr. Powerbuilder Consultant for Confidential clients and was assigned to work with Confidential in doing technology upgrades of their in-house billing application using Powerbuilder 12 on a MSSQL Server 2008 database.
• Uses CVS for version control using Win CVS to managed development code.
• He did systems analysis and design for any changes the user request working with assigned Business Analyst.
• He has been involved in full development life cycle from requirement gathering, analysis and design, programming, testing, debugging and implementation.

Confidential, Cupertino, CA

Systems Engineer

Responsibilities:

• Worked with for Confidential Enterprise project in the Confidential.
• Worked to upgrade, enhanced and maintain a legacy Powerbuilder application to Powerbuilder 11.5 and Oracle 11g.
• Uses ClearCase for version control.
• Duties and responsibilities includes preparing work request estimate, preparing systems specifications based on a work request, front end GUI development, data mapping for data warehousing project and closely working with Business Analyst to clear up issues and business rules that are not so clear within the work request.
• He has been involved in full development life cycle from requirement gathering, analysis and design, programming, testing, debugging and implementation.

Confidential, Fairfax, VA

Computer Programmer

Responsibilities:

• Responsibilities include estimation, systems analysis and design, systems programming, systems testing and assist in systems implementation.
• Assigned to work with the Confidential to enhance, maintain and constantly upgrade an in-house Powerbuilder application called UD/MIPS developed using Powerbuilder 10.5 with an Oracle 10g backend database using PVCS as its version control program.

Confidential, Jacksonville, FL

Powerbuilder Developer

Responsibilities:

• Responsibilities include systems analysis and design, systems programming, systems testing and systems implementation.
• Enhanced and maintained an in-house Powerbuilder application called IVSS developed using Powerbuilder 8.0.4 on a PFC framework with an Oracle 9i backend database.
• The version control used is Microsoft Visual Source Safe.
• Whenever possible, also tries to work as a junior dot net developer.
• Responsibilities includes create new modules, enhanced and modify the existing Powerbuilder application to accommodate user’s needs and enhanced its functionality by adding features that are essential to an ever-evolving business practices; enhanced, modify and maintain Oracle DB objects such as triggers, functions, procedures and packages using PL/SQL Developer; set up source code control for in-house development using Visual Source Safe source control; bug fixing, testing and maintenance; create builds whenever development are done.
• Creation of Transshipment Module, Eastern Caribbean Module and other major maintenance releases for IVSS
• Modify application for regulatory compliance changes
• Create and integrate document imaging processes for in house document imaging solutions
• Integrate IVSS to Lotus Notes
• Set up IVSS source code source control using MS Visual Source Safe
• Assist the Business Analyst in design aspect, implementing changes and new features that are constantly being added into the IVSS application.
• Upgrade IVSS from PB 8 to PB 10.5 to PB 11.5

Confidential, Palm Bay, FL

Powerbuilder Programmer

Responsibilities:

• Creation of multiple reports being used by different department within Confidential . These departments include Customer Support, Install Central, Accounting, Production and the rest.
• Enhancement of the Connect Care system by modifying GUI to what users want to see and how users want to use it.
• Data mapping and data conversion from legacy system to the new one, which is Connect Care.

Confidential, Miami, FL

Analyst Programmer

Responsibilities:

• Creation of the MMS Mailing Systems which is being use to generate mailing list of possible MMS clients.
• Create and update the MMS Security Management Module that handles both the domain and DB account creation respectively.
• In charge of developing, enhancing and maintaining reports for the Medicaid Management System.
• Creation, modification, enhancements of existing Cisco IP phone systems report using INFOMAKER and MS SQL Server 2000

Confidential, Jacksonville, FL

Senior Powerbuilder Consultant

Responsibilities:

• Systems development, maintenance, enhancement and conversion of the Notary Automation Program.
• Maintenance of Domestic Partnership Application
• Training and knowledge transfer.
• Spearhead the process of migrating the Notary Automation Program from Powerbuilder 7 to Powerbuilder 8
• Successful migration from Powerbuilder 5/Oracle 7.3 and Powerbuilder 6.5/Oracle 7.3 to Powerbuilder 7.3/Oracle 8i. Both Powerbuilder 6.5 and 7 are using the Powerbuilder Foundation Class (PFC) libraries.
• Total redefinition of the system by modifying the major modules and sub modules.
• Develop and enhance new functionality for modules like the Document Authentication module, Investigation module and the Enforcement module.
• Uses MKS Source Integrity for version control.
• Worked with Metamor ITS as Systems Programmer maintaining CRIMES 5. An application being used by district attorneys’ offices in keeping track of the cases they are handling.
• Developed with Powerbuilder 5.0.04 / PFC with Oracle 7.3 as its back-end and was later on converted to Powerbuilder 6.5/PFC with Oracle 8.

Confidential, Edison, NJ

Powerbuilder Consultant

Responsibilities:

• Developed, test and implement the GUI for Non-MLAM Mutual Fund Pricing System using Powerbuilder 5.0.03 and DB2 as back-end on a Windows NT environment using Shadow Direct to connect to the Mainframe System.
• This pricing system is being used to monitor the mutual fund prices at end of each day and is being used to compare other price sources to come up with a competitive price for each mutual fund that Merrill Lynch’s manages.
• Worked on the development of International Wire Transfer System using Powerbuilder 5.0.03 and convert the said application from using Sybase System 10 to MS SQL Server 6.5.

Confidential

Systems Consultant

Responsibilities:

• Convert the Confidential Inspection Data Capture (IDAC) Systems from Powerbuilder 4.0.06 using PowerTOOL 4.1 to Powerbuilder 5.0.03 using Power Tool 5.0 with Oracle 7.3 as back-end on a Windows NT environment.
• Maintained the IDAC System based on the need of the Confidential ’s Crude Oil Marketing Department.
• Spearhead the development of IDAC Systems using PowerBuilder’s Powerbuilder Foundation Class (PFC).
• Uses PVCS for version control.