We provide IT Staff Augmentation Services!

Principle Database Consultant/senior Dba Resume

Santa Monica, CA

SUMMARY:

Confidential is a senior hands - on Concur Implementation and Integration Specialist with ten-years of experience developing and optimizing for Concur. He strives for the development of elegant solutions for complex problems; Confidential developed a level of mastery of Concur integration APIs and T-SQL coding as well as familiarity with Concur techno-functional nuances. A typical project involves Concur API, XML, C#, and T-SQL development around database integration of ERP.

TECHNICAL SKILLS:

Concur: Expense, Expense Pay, Insight Essentials, Travel, Purchase Order, Invoices, API(v1.1, 2.0, 3.0, 3.1)

ERP Integrations: Epicor, NetSuite, Peoplesoft, Great Plains, MS Dynamics, SAP, VMS, Novatus

Databases: MS SQL Server (Versions 2005, 2008 R2, 2012, 2014, 2016, 2017, 2019, Azure) T-SQL, DTS, SSIS, SSRS, SSAS, Clustered Server, Link Server, Replication, Mirroring, XML, MSMQ, MDX, OLEDB) Oracle (Versions 8i, 9i, 10g, 11g, PL/SQL, OCI, PRO*C), Sybase (Versions 12.0, 12.5, 15, T-SQL, Replication, IQ), Informix (On-Line, SE, 4GL, Ace, ESQL/C, Redbrick)

Development/Reporting: SSRS (2014,2016, 2017), SAP Crystal (XI,2008,2011,2013), XML, HTML, VBScript, Excel VBA, C#, .NET, REST, SOAP, JSON, Java, Fiddler, WTC, Shell Scripts, DataWeave

Tools: Confidential, PerfMon, Legato, Quest BenchFactory, SQL StressTest, SQL BackTrack, RedGate

PROFESSIONAL EXPERIENCE:

Principle Database Consultant/Senior DBA

Confidential, Santa Monica, CA

Responsibilities:

  • Established a consulting practice concentrating on Epicor, Concur and MS SQL Server contract work.

Confidential

Concur Integration Developer

Responsibilities:

  • Created a Concur to Salesforce.com integration of expenses.
  • Enhanced Concur data with Internal system’s data and distribute data to SalesForce.com and other internal systems.
  • Developed solution using Confidential Anypoint Studio, Java, Concur connector, DataWeave, as well as a mixture of direct Concur API calls from versions 1.0, 2.0, and 3.0.

Concur Integration Developer

Confidential

Responsibilities:

  • Created NetSuite to Concur two-ways integration of invoices, payments, expenses, vendors, connected lists, and attachments.
  • An inconsistent off-the-shelve connector was replaced with a custom Integration platform that fully integrated NetSuite with Concur.
  • Users can update data in either system and the data will flow seamlessly to the other system.

Concur Integration Specialist

Confidential

Responsibilities:

  • Created a seamless integration of Epicor Enterprise 7.4 to Concur AP using Concur FTP and SQL.

Concur Integration Specialist

Confidential

Responsibilities:

  • Created a one-way integration of Concur Expense to MS Dynamics to Concur Invoice using Concur API v1.1.& 2.0)

ERP & Concur Integration Specialist

Confidential

Responsibilities:

  • Designed and developed a seamless two-way integration between Concur and Epicor.
  • Helped organization transition to Concur Purchasing through detail analysis and data migration.
  • Expanded implementation of Expense module and standardize interface of expenses to financials.
  • Concur, Epicor, T-SQL, XML

Concur Implementation consultant

Confidential

Responsibilities:

  • Implemented Concur expense, Expense Pay, Insight Essentials, and Concur Travel modules for a medium manufacturing company.
  • The implementation included data setup, configuration, user training, company adaptation, and interface to financials.
  • A follow-up project converted the interface to a new ERP system adapted by the organization.

Concur Developer

Confidential

Responsibilities:

  • Automation of Concur approval for Confidential ’s custom application using both Concur API and screen scraping.
  • Concur API’s lack of support for vendor invoice approval created the need to augment API development with screen scraping (Fiddler)

Concur Integration Specialist

Confidential

Responsibilities:

  • Created a two-way integration of VMS community management application.
  • The project required a cleanup of a defunct invoice integration effort as well as additional development of payments, attachments, vendors, and custom connected lists integration.
  • The resulting product was a full-featured integration platform that requires minimum maintenance.

Data conversion Architect

Confidential

Responsibilities:

  • Provided data conversion architecture, data modeling, reporting architecture, DBA, and business analysis on a major implementation of the studio’s asset management system.
  • Brought the project from inception to successful completion.
  • The new system managed all studios’ assets and incorporated diverse technologies and data from all studios’ systems.
  • The projects included asset configuration, ordering, multi-warehouse management (bar-coding, scanning, picking, packing, shipping), asset tracking, pricing, asset categorization, interfaces to financial and royalty systems.
  • The project extended to integration of data from a newly merged organization and external post-production labs. The required complex analysis and data mapping tested the original design, which proved to be modular and flexible.

Sr. Database Consultant

Confidential

Responsibilities:

  • Provided Data modeling, database programming and performance optimization of a portfolio risk analysis tool for an institutional Investment house.
  • T-SQL development of investment risk analysis, indices-based algorithms, and complex portfolio management utilities.
  • Created ETL programs to capture/clean/transform financial data. (MS SQL Server)

Chief Technical Officer (Consultant)

Confidential

Responsibilities:

  • Provided database architecture and CTO services to a leading provider of entertainment news, information, and movie-ticketing.
  • Led the restructuring of the IT department as well as a major website redesign.
  • Established hardware and software architecture; including load balancing, content distribution, Ads serving, traffic tracking, and video production/encoding/streaming.
  • Created an enterprise-wide database that captured data across from all sites and enabled easy publication of dynamic data.
  • The database was monumental in company expansion through the creation of new websites for delivering movie/celebrity/TV/music information. (MS SQL Server)

Vice President of Engineering (Consultant)

Confidential

Responsibilities:

  • Management and technical consulting for a start-up, who is now the world leader in tier-1 convergent OSS Mediation.
  • Work included recruiting engineers, contributing to the business plan, helping secure first and second round VC financing, establish technology direction & architecture.
  • The application created sniffed Internet traffic and reconstructed HTML/UDP/DHTML specific usage information from IP packets.
  • The application architecture, which allowed for infinite scalability, proved invaluable to the company’s growth. (Oracle, MS SQL Server)

Hire Now