PROGRAMMING EXPERTISE:

Language: ruby, ruby on rails, asp.net c#, vb,c#,c, assembler

Database: Sql - server,Sybase,oracle, mysql,DB2

Database Languages: t-sql(Dominion),pl-sql(BP)

Reporting: Crystal reports,sqr, BO

EXPERIENCE:

Confidential

Senior Application programmer

Responsibilities:

• IBM Cognos TM1 provide admin support for MS 2012 Server and TM1 application.
• Support Turbo Integrator scripts
• Wrote production implemented C# Transaction logging program to support TM1 and its audit requirements.
• Supported MS Sql - Server databases
• Supported Informatica ETL.
• Oracle OFSAA
• Provided admin support for OFSAA system.
• Supported Oracle database and requirements including DML executions.
• Supported LINUX Bash scripts and executions.

Confidential

Production Support

Responsibilities:

• Primary support for production batch processes.
• Linux Scripts. Linux Korn scripts include:
• FTP
• SFG
• Mail
• Indirection
• File reading
• PL/SQL
• Batch maintenance updates
• Security queries supporting account expiration requirements
• Oracle PL/SQL development and maintenance
• Table maintenance
• Stored procedure maintenance and development
• Trigger maintenance and development
• Update/insert triggers
• Query development and support
• Wrote Production ready comprehensive report-writing system for management.
• Wrote new routine to connect to Oracle Client.
• Wrote Linux Production scripts with PL/SQL.
• Designed, developed and implemented in production and complete Auditing system.
• Developed 2 versions:
• PB 12.5
• ASP.NET C#,
• Automated the creation of Oracle Triggers using GUI front end.
• Queries Oracle catalog tables for column, data type information
• Once created these triggers are applied to the appropriate tables
• Front-end Audit system allows the user to query update, delete or insertions from the trigger into an Audit table.
• Designed and developed new web version of production application in ASP.NET C#.
• Front end developed in Visual C# with Oracle 11g backend.
• Fully implemented with embedded security.
• Fully implemented & functioning Update, Insert and View pages.
• OO
• Used many classes to support
• Security connectivity
• SQL queries and control optimization(sorting listboxes…)
• Coded in MS/asp.net C#, this program is a complete solution for databases including:
• MS-SQL mySQL
• Oracle
• Technical
• OO
• SSL on server
• Multi-database
• Functional
• Fully functional Report-Writer
• Administration module for report distribution and assignment
• Batch module
• User Page for executing and view report results.
• Developer page with point and click report creation.

Confidential

Systems Analyst Consultant

Responsibilities:

• Member of technical prototype team responsible for setting up 3-tier environment. Responsibility included installing Sybase on HPUX environment.
• Member of technical team that was involved on the CAMP project for its full life cycle development. Integral member of team using Waterfall methodology. Involved in securing requirements definition for Meter Reading.
• Led user meetings to gather information in the design and implementation of the system.
• Responsible for programming bill simulation system utilizing MS-SQL/Sybase, Powerbuilder, CICS and IMS.
• Served as primary DBA for 12 GB Sybase RDMS on a HP9000 860 platform.
• Responsibilities included the design of ER model and implementation on the 86- using ERWIN to write DDL.
• Responsible for performance tuning of Sybase stored procedures (using T-SQL) on the project using temporary tables. System Admin for HP 9000, including setting up the logical volumes to store Sybase Databases.
• Wrote C program to trigger MQSeries message after bill image database insert.
• Wrote Microfocus COBOL programs for batch invoicing updates.
• Wrote Visual C program for Lima Customer Service Office.
• Program required emulation calls to mainframe system to bring data from legacy system to new 3 tier system.

Technical Manager

Confidential

Responsibilities:

• Responsibilities for day to day operations and management of analysts.
• I was responsible for the management of two developers.
• After 2 weeks the entire department was turned over to our team to replace the 21 member IT department that had been outsourced.
• Prepared daily reports for meeting with Confidential CIO. Platform consisted of a HP9000 Farm with HPUX.
• Responsible for rewriting daily sales reports that were running 36 hours. By introducing the concept of temporary tables to the Confidential environment was able to reduce length of report from 36 to 3 hours.
• Also introduced to concept of stored procedures to Powerbuilder language. SQL calls were replaced with calls to store procedures.
• The stored procedures were written within the database to simulate and replace the SQL scripts located within the Powerbuilder application.
• Wrote datamapping program for BP(British Petroleum) for the ISP international data integration project. Used PL-SQL create tables, write procedures and packages. Application was written in VB. Also wrote low-level pro-c code to interface with Oracle.

Confidential

Technical Manager/Consultant

Responsibilities:

• Designed, developed and implemented three-tier database architecture in collaboration with PriceWaterhouse.
• Responsible for SA work on HP9000 including scheduling using CHRON and UNIX scripting languages(KORN), DBA backups and recovery system using Sybase and DB2 databases.
• Developed quality control manual for developers.
• This manual outlined GUI requirements for CAMP project to adhere to standards set forth by Microsoft.

Confidential

Project Manager/Systems Analyst

Responsibilities:

• Responsibilities included leading major client/server projects in a Visual Basic/Sybase environment.
• Using Visual Basic(VB), ODBC, RDMS and MS Access, part of a two-member team responsible for rewriting invoicing system.
• The project included the redesign and reprogramming of several VB programs and the rewriting of the batch routines in Sybase stored procedures.
• Interim Sybase DBA in the IBMRISC 6000 AIX environment.
• Served as liaison with software developers in major new release of social expression software program.
• In this capacity consulted with developers on ODBC and Visual C++ and wrote a conversion utility in VB to port a MS SQL Server for NT DB using ODBC.