Senior Database Developer/System Integration & Design Specialist Resume Los Angeles CA - Hire IT People

SUMMARY

Senior information technology professional with diversified expertise in software design, development and testing (QA).
Demonstrated leadership and proven results in management and execution of large projects with excellent communication and problem solving skills and the ability to work with cross - functional teams.
Extensive experience in Oracle, Postgres and hands on experience writing SQL queries and PL/SQL and PL/pgSQL stored procedures, functions, packages, triggers.
Proficient in writing and tuning complex SQL statements using tools like Explain Plan, SQL*Trace.
Successfully managed complex data migration projects.
Experienced in using Oracle utilities like Data pump for import/export databases and SQL*Loader.
Experienced in developing Unix/Linux shell scripts.
Strong knowledge of SDLC, testing methodologies and techniques.
Experience in developing automated tests using Selenium, QARUN.
Skilled in project management, team leading, customer relations management.
Experienced in system analysis, gathering, documenting and translating business requirements into technical specification.

TECHNICAL SKILLS

Environment: s: UNIX/LINUX(Ubuntu/CentOS), Windows.

Languages: SQL, PL/SQL, PL/pgSQL, JAVA, C, JSP, COBOL

Database/Software: Oracle, Postgres, MySQL, SQL Server, TOAD, SQL Developer Apache/Tomcat, JasperReportServer 4.5, IReports 4.5, Drupal, JasperETL/Talend, VirtualBox, Selenium HQ, GIT, PVCS, SVN, Crystal Reports, VERSATA, SSIS(DTS), QARun

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

Senior Database Developer/System Integration & Design Specialist

Responsibilities:

Designed and developed ETL processes using SQL*Loader to pull SAP data into supply chain database.
Collected, documented and translated business requirements into technical specifications.
Developed and modified PL/SQL and PL/pgSQL packages, functions, procedures, triggers.
Created a set of PL/SQL procedures/functions to process forecast netting.
Analyzed data, created indexes and views to improve the overall system performance.

Confidential, Los Angeles CA

Senior Database Developer/Data Integration Analyst

Responsibilities:

Provided recommended approaches and practices for data migration and implemented migration procedures using Postgres SQL for consolidation of data from disparate sources.
Designed logical and physical database models using TOAD Data Modeler.
Developed and modified PL/pgSQL functions, triggers.
Created and enhanced customized reports using Crystal Reports.
Developed variety ad hoc SQL scripts in response to senior management’s request.
Developed database models and functional requirements documentation and processes, which resulted in acceptance with minimum adaptation and savings on development time.

Confidential, Los Angeles CA

Senior Software Engineer

Responsibilities:

Responsible for ongoing enhancement, maintenance and support for ETL (mappings and scripts).
Extensively used SQL and PL/SQL to write stored procedures, functions and triggers.
Created, enhanced and deployed customized reports using iReports, ORACLE /MYSQL/ POSTGRES databases.
Designed and implemented of generic loader to automatically deploy to JasperReportServer 4.5 folders, data types, data sources, reports, etc. using Java and JSON files.
Provided design and implementation for consolidation of reports transaction data using JasperETL/Talend.
Developed automated test harnesses using Selenium HQ.

Confidential, Los Angeles CA

Senior Software Developer

Responsibilities:

Provided design, architectural consultation, quality assurance testing, and successfully managed complex migration projects using utilities, such as SQL Server Data Transformation Services (DTS) and Oracle SQL.
Created and enhanced reports using Crystal Reports, Oracle PL/SQL stored procedures, views and custom tables.

Confidential, Los Angeles, CA

Senior Programmer Analyst / Senior Software Developer

Responsibilities:

Designed, architected and implemented migration procedure using Oracle SQL for moving of mission critical transaction data from the Theatrical Accounting Distribution System (TRIAD) to THOR.
Developed and enhanced custom reports using Crystal Reports, Oracle PL / SQL procedures, views and tables.
Responsible for ongoing enhancement, maintenance and support for JAVA based client and server side applications using VERSATA Logic Server / Studio, which resulted in increased user satisfaction.
Enhanced and supported Theatrical Accounting Distribution System (TRIAD) running on UNIX/ORACLE platform.
Redesigned and enhanced COBOL programs using C API database calls to well-tuned Embedded SQL.
Modified C API layer and executable UNIX scripts for TRIAD system migration to an AIX 4.3/ORACLE 8.

Confidential, Los Angeles, CA

Software Engineer

Responsibilities:

Developed C code for “state” calculations of various devices (track circuit, signal, switch, etc.).
Developed database models and functional requirements documentation and processes.

We provide IT Staff Augmentation Services!

Senior Database Developer/system Integration & Design Specialist Resume

Los Angeles, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship