Senior Database Engineer Resume

SUMMARY:

Database and application development specialist with 25 years of experience seeking a role that challenges me and fully utilizes my experience and abilities

TECHNICAL SKILLS:

Languages: PERL, TSQL, PL/SQL, JavaScript All flavors of UNIX, Linux, Windows Scripting, PL/SQL,POWER SCRIPT, HTML, Java 8, JSON, T - SQL, PL/SQL, JAVASCRIPT, PERL.

Tools: ATOSYS, CLEAR CASE, CRONTAB, POWERBUILDER, VISUAL BASIC, SECURE SHELL, GIT, CVS, SVN,TOAD, AQUA DATA STUDIO, INFORMATICA POWER CENTER, MS VISUAL STUDIO, ORACLE SQL DEVELOPER, TABLEAU DATA,SSIS,SSRS

REPORTING TOOLS: POWERBUILDER, CRYSTAL REPORTS, TABLEAU DATA. RDBMS: SYBASE 15.0, Oracle 11g/12c, SQL SERVER 2017

SYBASE UTILITIES like DDLGEN,ISQL,BCP and oracle data pumps and Sql loader.

Operating Systems: Solaris, Linux, Windows current versions

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Engineer

Responsibilities:

Created exchange datawidnows and pipeline dataobjects
Created an entire application using pipeline objects to move data between servers
Used enhanced cookies for proxy through PBAddCookie and PBGetCookies methods
Used WebServices Client Extension methods like SoapConnection, SoapException.
Used New RichTextEdit Controls
Used new Objects to execute CRUD Operations overTLS1.2, parse and generate JSON
Responsible for converting 16 applications from SYBASE to ORACLE as the companywide effort to move away from SYBASE due to licensing issues. Worked on recreating the tables in ORACLE 12c .
Modified tables to include identity column introduced in 12c. It needed tables to be recreated since this modification will not be possible without recreating the table. Handled all the procedure changes related to this change and eliminate the unnecessary code to compute the maximum number assigned to the column. Used very efficient new SQL functions introduced in 12c .

Confidential

Senior Database Developer

Responsibilities:

Created PowerBuilder reports for easy access to the information from ICD 9 and 10 and compare it and create a difference DATAWINDOW by grouping by the ICD 9 elements
Used MDI docking behavior in PowerBuilder
Coded SQLPreview Event to combine the user raised messages and and errors returned from DB Vendor
Oracle application involving patient data for insurance purposes and interactive reports

Confidential

Senior Database Developer

Responsibilities:

Created JIL scripts for AUTOSYS to monitor scheduled processes
Improved performance of several old stored procedures in Sybase ASE/IQ databases
Wrote several scripts for payment processing System in SQL SERVER and built tableau reports

Confidential

Lead Database Developer

Responsibilities:

Converted stored procedures in SQL Server 2008 to Oracle 11g for Martini application Wrote UNIX scripts to migrate date from Sybase ASE server to Sybase IQ server
Wrote stored procedure for currency swap and interest rate swaps and fair value adjustments
Computed assets and liabilities for currency swaps and interest rate swaps Built interfaces for summit trading systems
Developed several ETL processes, working with business analysts to create testing environment and redesigning the process with feedback from business
Developed tools for product trends and new initiatives in fixed income with business analysts
Built several Powerbuilder applications for the merger of Nuberger Berman and Lehman
Used Several New features of PowerBuilder to make the application very user friendly for the Business.
Used ADP BPSA and Equity Finance Technology to collect all the information for processing

Confidential

SENIOR CONSULTANT

Responsibilities:

Moved sales data from several relational databases like SQL Server, Sybase and Oracle
Developed ETL Requirements for the complete project and passed it on to the group in charge of the ETL.
Created data models, database objects; coded and optimized triggers, Stored Procedures, created several views to simplify the queries and triggers to maintain the updates consistent across the database for several tables.
Responsible for the change from PowerBuilder environment to Crystal Reports 9.0. Removed the logic from PowerBuilder and moved them to Stored Procedures in SYBASE and generated the reports using Crystal Report s 9.0. Used several data sources to build reports like Log files generated from Internet Information Server, Stored Procedures from Sybase, views from Sybase, text based reports.
Built security applications providing application level security, window level security and menu level security using PowerBuilder. Employed dynamic data windows to make it easier for the security officer to issue permissions.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship