SUMMARY:

• Highly accomplished IT professional with 25+ years extensive experience in developing Client/Server and multi - tier distributed applications, using PowerBuilder, Oracle, Sybase and MS SQL Server DBMS, Informatica
• Cloud for Data Migration and Integration, installations, conversions, troubleshooting, coding, testing, debugging, and implementation. Extremely flexible, resourceful, and able to thrive in various work settings. Demonstrates extensive expertise in collaborating with teams, management and users to guide the delivery of technology and business solutions to drive continued growth.

TECHNICAL SKILLS:

• Oracle PL/SQL, Oracle SQL Developer, Oracle TOAD, MS SQL Server, Sybase, T-SQL, PowerBuilder, Informatica Cloud
• JIT, JIRA, TFS, HTML, XML, Crystal Reports, Microsoft Windows, Microsoft Teams, Microsoft Excel, Microsoft Word, Microsoft PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, California

Oracle SQL Conversion Developer

Responsibilities:

• Creating new and modifying existing Stored Procedures, Triggers, Functions to support conversion project mapping requirements from source to the target database in Oracle 12c
• Working conversion development team to Manage SQL scripts Conversion Orchestration Processing.
• Provided technical assistance developers to support and troubleshooting of conversion scripts code
• Analyzed and identified performance issues and provided solutions for faster execution of scripts
• Created numerous complicated SQL reportsfor users and familiar with various types of stored procedures, views, joins, union, intersect, sub queries, alias, formatting.

Confidential, California

Sr. Software Developer

Responsibilities:

• Developed and maintained database objects like SQL blocks, Packages, Stored Procedures, Functions, Triggers, Types, Collections, Materialized Views, complex SQL queries using Oracle 12c, Created Tables and Indexes on the tables for faster retrieval of the data to enhance performance.
• Developed integration processes and mapping documents for Data Migration and Synchronization between legacy system and Salesforce platforms using SQL, SOQL and Informatica Cloud.
• Developed Data Integration and conversion mapping design documents, ETL processes to transform data from Oracle and Salesforce into target data stores and data warehouses for BI reporting.
• Used Informatica Cloud to create Connections, Schedules, Mappings, Mapping Configuration Tasks and Task Flows to setup processes for Data integration Salesforce and Legacy system.
• Managed end-to-end processing of Overrides Payments in accurate payments calculations to Field.
• Created new and modified existing functionality for Sales Operation and Payment Processing System in PowerBuilder 12.5.2 based on business new requirements. Involved in the continuous enhancements and fixing of production problems
• Created MS Linked Server for data migration from Oracle into Microsoft SQL server.

Confidential, Woodland Hills, California

Sr. Programmer Analyst/Consultant

Responsibilities:

• Migrated existing PowerBuilder client/server applications from v9.0 to v12.5.2
• Enhanced existing client server applications in PowerBuilder v12.5.2 accessing to Oracle Database 11g to support client Sales Operation Billing and Payment Processing System.
• Designed, developed, and deployed web-based applications with ASP.NET and C#, using Visual Studio v2012 and Microsoft SQL Server. Writing and Maintaining MSSQL stored procedures and functions.
• Integrating third party tools andOLEobjects into PowerBuilder applications.

Confidential, Los Angeles, California

Sr. Software Developer/Programmer Analyst

Responsibilities:

• Developed and modified existing client server applications to support company Work Tracking and Integrated Application Systems using PowerBuilder and Oracle 8i,9l,10g.
• Created/Modified Data Windows, Windows, User Objects, Functions and Menus in PowerBuilder
• Designed Database objects and created tables, keys, foreign keys, complex database triggers, packages stored procedures, functions, and views in Oracle and SQL Server.
• Migrated existing applications written in old versions of PowerBuilder 6.51 to PowerBuilder 12.5.
• Utilized Crystal Reports to design, develop and distribute interactive reports to management and users.
• Facilitated full systems life cycle, including analyzing, designing, coding, testing, debugging, documenting, implementing, maintaining, and supporting application software for Work Tracking Processing System.
• Worked with customers to gather business requirements and writing of technical documents.

Confidential

Programmer/Analyst

Responsibilities:

• Designed and developed client/server applications for entertainment industry, including film licensing system and international television distribution system, using PowerBuilder (v5.03, v6.5) Sybase 11.5.
• Analyzed and designed data models and implementation of client server applications. Utilized PowerBuilder PFC Class libraries to create base classes, reusable objects, and security systems.
• Wrote and maintained stored procedures, functions and triggers. Assisted business analysts with writing of technical documentations.

Confidential, Los Angeles, California

Jr. Programmer/Analyst

Responsibilities:

• Modified existing online programs in insurance systems, using COBOL and CICS. Utilized UMAP and ULIB utility programs to create and catalog maps and online programs.
• Utilized DYL-280 to maintain VSAM and index sequential files to create quick reports.
• Developed and modified existing production job streams, utilizing MVS/JCL.