We provide IT Staff Augmentation Services!

Database Developer Resume

0/5 (Submit Your Rating)

Burbank, CA

TECHNICAL SKILLS:

Languages: MS SQL SERVER 6.5/7.0/ 2000/20 , Oracle 10g/11, UDB/DB2, PL/SQL, Crystal Reports, VB.NET, VB6, XML, XSLT, JavaScript, VBScript, DHTML, ASP/ASP.NET, Microsoft Visual Studio, SQL UNIX Shell Script, Clipper, PVX, GUI NOMADS, FoxPro, Fortran, Cold Fusion 3.1, Cobol.

Other: Oracle SQL Developer, TOAD, Oracle Application, SSRS, SSAS, SSIS, Web Service, SQLXML, IIS, COM+, ADO, Perforce, Business Object, SCRUM, Spring Batch framework, Python, IBM WebSphere, Cyber fusion, Hibernate, VSS, CSS, MSMQ, Microsoft Office, MAS90, AutoCAD 13/2, GIS, File Net, Lawson, CSS Impact, SharePoint, Pervasive (ETL), UNIX/LINUX.

PROFESSIONAL EXPERIENCE:

Confidential - Burbank, CA

Database Developer

Responsibilities:

  • Architect, design, develop and maintain high performing ETL process for conversion/export very huge tables from Oracle into Microsoft SQL Server.
  • Design, develop, maintenance databases, SSIS packages, T-SQL stored procedures, create complex T-SQL scripts, and etc (as DBA).
  • Develop, support existing reports from multiple data sources: MS SQL Server, Oracle, Access, Excel, Cognos and etc. Migration Access database to MS SQL Server database.

Technical Environment: MS SQL Server, Oracle 11, PL/SQL, SSIS, ETL, Microsoft Visual Studio.

Confidential - Calabasas, CA

Sr. Software engineer/SQL Developer

Responsibilities:

  • Architect, design, develop and maintain high performing ETL process, including data quality and testing for Health care systems (Epic, Cerner, Meditech, MS4, and other sources, the payments from Rev Express).
  • Write the complex/custom reports and perform analyses on complex data to evaluate outcome, financial performance, and population for Financial, Trust, TPL, Worker’s Compensation and other departments.
  • Design, develop, maintenance databases, SSIS packages, T-SQL stored procedures, triggers, and etc (as DBA).
  • Advanced data integration, data aggregation, reporting and analysis very the huge data from multiple data sources and databases (MS SQL Server, Oracle, Access).
  • Develop, support, test, conversion existing VB.NET/VB6 applications. Designed, prototyped and developed the new reports, reconciliation systems for financial department. Develop requirements, specifications and standard.

Technical Environment: MS SQL Server 2008/2012, Oracle 11, PL/SQL, Crystal Report 11, CSS Impact, Pervasive, SSIS, Microsoft Visual Studio 2010 (VB.NET), VB6, HL7.

Confidential - Agoura Hills, CA

SQL Developer (contractor)

Responsibilities:

  • Developed, supported, tested, modified, integration existing applications: Oracle Application (Inventory and Land Costing), the Matching International Inventory application (the receipt and invoice information match) and etc.
  • Developed database triggers, stored procedures, functions, jobs and packages using Oracle PL/SQL. Researches, troubleshoots and resolves Oracle Applications issues.
  • Developed requirements for building ETL, query for convert data from UDB/DB2 to Epicor Sales Audit.
  • Developed databases, SSRS, SSIS packages and T-SQL stored procedures for data loading, integration, data access, and external data feeds.
  • Designed and developed data preparation components and processes that extract and transform data across disparate database tables for reporting and analytics.

Technical Environment: MS SQL Server 2000/2005/2008 , Oracle 10g, PL/SQL, UDB/DB2, SSRS, SSIS, Oracle Application, Microsoft Visual Studio 2008, SharePoint.

Confidential - Woodland Hills, CA

Sr. Software engineer/Software engineer

Responsibilities:

  • Analyzed, prototyped and developed new Risk Follow up application, business rules for Risk department. Developed, supported Bulk Import/Loader, business rules validation application, integration with AMEX, Confidential and other company and system. Defined and designed XML structure for all channels online application, developed ORACLE XML parser.
  • Supported, tested, modified, integration existing business/financial systems applications. Worked on moderate to complex projects and issues, production support.
  • Defined requirements, designed, and developed monitoring system for all types of applications and credit cards batch processes jobs.
  • Develop SSIS packages and T-SQL stored procedures for data loading, integration, data access, and external data feeds. Migrated data, SP, triggers, views from SQL Server to ORACLE for different applications.

Technical Environment: VB/C# .NET, Web Service, MS SQL Server 2000/2005/2008 , Oracle 10g, J2EE, Crystal Report, XML, IBM WebSphere, PL/SQL, Business Object, UNIX Shell Script, Spring Batch framework, Python.

Confidential - Moorpark, CA

Senior Application Developer/Project Leader

Responsibilities:

  • Analyzed, prototyped and developed new business/financial (credit card processing) system applications, analysis tools, business rules for New Accounts, Sales/Merchant Support, Profitability, Risk, Financial and other departments.
  • Analyzed, prototyped and developed the Retail Online Application (ROLA) for a Credit Card Processing Account to allow the merchant and agent to enter the application over the Internet with an electronic signature.
  • Supported, testing and modified existing business systems applications.
  • Recommend strategies for improving system applications.
  • Developed business rules requirements.

Technical Environment: VB.NET, Microsoft .NET Framework 1.0/1.1/2.0, Web Service, ASP .NET, C#, COM+, XML, XSLT, SQLXML, JavaScript, HTML, DHTML, VBScript, ASP, Visual InterDev, MS SQL Server 2000/2005, SQLXML Communication with Oracle, FoxPro, COM+, File Net Images.

Confidential - Calabasas, CA

Microsoft .Net Developer

Responsibilities:

  • Analyzed, prototyped and develops an accounting system (Beretta loan pricing).
  • The system is based on Microsoft’s VB.NET, ASP.NET, web services, .Net components, and SQL Server 2000.

Technical Environment: VB .NET, Microsoft .NET Framework, Web Service, ASP .NET, COM+, XML, XSL, JavaScript, HTML, DHTML, VBScript, ASP, Visual InterDev 7.0, SQL Server 2000, Microsoft .NET Technologies.

Confidential - Westlake Village, CA

Sr. Web developer

Responsibilities:

  • Analyzed, prototyped and developed an order entry system for Confidential ’s Apartments and Rentals unit. The system included a workflow engine used to manage the order creation process. It integrated with the Solomon Accounting system using custom developed web services. The system was based on Microsoft’s VB.NET, ASP.NET, web services, .Net components, and SQL Server 2000.
  • Analyzed, prototyped, designed and developed the back end order entry system used to build web sites for Welcome Wagon local merchants. The application was based on XML, ASP, COM+, message queue, SOAP, SQL Server 2000, and was integrated with the VeriSign credit processing system. The SOAP interface was used to feed XML data to a system designed to build the live web sites using a page builder tool. The system was used by over 100 account executives.

Technical Environment: Visual Basic 6.0, VB .NET, Microsoft .NET Framework, Web Service, ASP .NET, COM+, XML, XSL, JavaScript, HTML, DHTML, VBScript, ASP, Visual InterDev 6.0, SQL Server 7.0/2000, SOAP, Microsoft .NET Technologies.

Confidential - Westlake Village, CA

Senior Web Developer

Responsibilities:

  • Provided full lifecycle development, including analysis, prototyping, design, coding, testing and implementation of database and business applications for this B2B online marketplace.
  • Provided both development and maintenance coding.
  • Developed Intranet which encompassed site statistics, administration, security and a tool for testing new sites.
  • Part of extensive layoff.

Technical Environment: Visual Basic 6.0, COM+, XML, XSL, JavaScript, HTML, DHTML, VBScript, ActiveX, IIS 5.0, ASP, Visual InterDev 6.0, SQL Server 2000

Confidential - Los Angeles, CA

Senior Programmer

Responsibilities:

  • Designed and programmed database and business applications for a Toner eCommerce online store.
  • Created the ecommerce COM object which allows the ability to integrate the e-commerce storefront with the backend accounting system MAS90. Application allowed for real time processing.
  • Designed and programmed the BestCost application, which allowed users to compare rates and services for different carriers (UPS, FedEx, and RPS) at a glance.

Technical Environment: Visual Basic 6.0, JavaScript, HTML, VBScript, ActiveX, IIS 4.0, ASP, Visual InterDev, PVX, NOMADS, COM, SQL Server, ADO.

Confidential - Manhattan Beach, CA

Developer

Responsibilities:

  • Designed and programmed Computer Telephony Integrated Graphic User Interfaces (to interface the Visual C OCX). Technologies on this project included Visual Basic 5.0, SQL, Access and ActiveX.

Confidential - Woodland Hills, CA

Programmer/Analyst

Responsibilities:

  • Designed and developed Medical Data Management System, including claim analysis reporting and “Fee of Service” utilization summary analysis.

Technical Environment: Visual Basic 4.0/5.0, Oracle ODBC driver for RDB, Oracle RDB, SQL, Access, Datatrieve, VAX/VMS, ActiveX, RDO, COM.

Confidential - Los Angeles, CA

Developer

Responsibilities:

  • Designed and programmed database and business eCommerce applications.

Technical Environment: Visual Basic 4.0/5.0, OLE, Access, FrontPage 97, HTML, VBScript, SQL Server, Office 97/95, ActiveX, RDO, Client/Server technology.

Confidential

Senior Programmer/Analyst, Project Leader

Responsibilities:

  • Designed and developed mapping software and databases applications for a variety of clients, including those in city government, power, railways, oil companies and telephone communications.
  • Designed and programmed GIS “Cartography engineering network”.
  • Integrated GIS with other business, architectural and information systems.
  • Performed database modeling and data integration.

Technical Environment: AutoCAD 13/12, Visual Basic 3.0/4.0, Access, Clipper, AutoLISP, SQL, FoxPro, C.

Confidential

Developer

Responsibilities:

  • Developed Cartography engineering network" for electro - technical lab.

Technical Environment: AutoCAD 12, Visual Basic 4.0, Access, AutoLISP, Clipper.

Confidential

Software Engineer

Responsibilities:

  • Designed, developed and supported system project of PC Boards and manufacturing applications.
  • Provided system level programming of device drivers in C and Assembler.

We'd love your feedback!