Post Job Free
Sign in

Software Developer Sql Server

Location:
Agoura Hills, CA
Posted:
July 18, 2017

Contact this candidate

Resume:

Yariv Kirschner

Agoura Hills, CA *****

(H) 818-***-**** / (M) 818-***-**** • **********@*****.***

https://www.linkedin.com/in/yariv-kirschner-15919970 Database Developer

Seasoned IT professional with distinguished career planning, creating, testing, and deploying custom software systems QUALIFICATIONS PROFILE

● Display senior level expertise in overseeing all phases of the application development lifecycle including design, development, testing, implementation, and support to deliver the highest quality technology solutions.

● Proficient in software analysis and implementation, database management systems, design and implementation, web development, and web content management systems.

● Highly skilled in estimating, planning, designing, coding, and implementing application software using various development tools. Armed with advanced knowledge of project management methodologies including agile/scrum.

● Skilled team leader and trainer with a track record of directing direct multiple tasks effectively to ensure on target completion of all deliverables. Outstanding interpersonal and communication strengths leveraged to train users, troubleshoot system issues, and ensure total client satisfaction. TECHNICAL PROFICIENCIES

Platforms: Windows, iOS, Linux

Languages: SQL, PL/SQL, T-SQL, Ruby, C#, Delphi Object Pascal, XML, EDI, JSON Databases: MS-SQL, PostgreSQL, Firebird, SQLite, Oracle Methodologies: Data Modeling, Database Normalization, Test-Driven-Development, Object-Oriented-Design, Agile Development, ETL, SSRS, SAP Crystal Reports

PROFESSIONAL EXPERIENCE

Casamba LLC, Agoura Hills CA

Software Developer ( 2014 - 2017)

Analyzed, designed, and developed complex MS-SQL stored procedures for reporting, document distribution, and XML data export. Utilized programming tools effectively to ensure accuracy and enhance productivity.

Proficiently utilized SQL to create custom data to extract into CSV, XML, and other text file formats.

Generated reports using .NET C# with DevExpress and MS SQL following business specs.

Acknowledged for personally developing SQL Server jobs and steps for executing nightly ETL processes.

Played a pivotal role in designing R ails application for automating scripts generation for iOS mobile application resulting in 80% time saving.

Reduced the number of technical support inquires, by creating documentation addressing common technical issues L & L Manufacturing Co., El Segundo CA

Information Technology Manager / Software Developer ( 1997 - 2014)

...Continued...

Yariv Kirschner

Page Two

Provided technical direction through the overall software development lifecycle f or order control, accounting, costing and inventory enabling the company to operate globally.

Designed and developed client/server application suite with multiple modules such as Purchasing, Order management, EDI, Shipping and Inventory.

Designed and developer SQL database for that system with over 200 tables, numerous stored procedures and functions.

Spearheaded daily operations of IT department and managed ERP system with 60 workstations and 5 servers.

Provided advanced technical support for applications and peripherals for all manufacturing activities in the US and Mexico.

Provided tier I, II and III technical engineering support to fashion designers, pattern and marker makers on Mac OS X Window and Unix workstations.

Significantly reduced shipping errors through designing EDI translator enabling the business to comply with client's

(Wal-Mart & JCPenney) custom EDI specifications.

Improved manufacturing performance by optimizing the processes and tuning the complex SQL.

Performed hands-on configuration and custom development of reports, using advanced queries to achieve reporting requirements, within performance constraints.

EARLIER CAREER:

Production Manager: L & L Manufacturing Co., Los Angeles CA (1992 - 1997) Production Planner: M cDonnell Douglas, Long Beach CA ( 1989 - 1992) PROJECTS

Glaser Forensic Group, Encino CA

Psychological Services Case Management

Designed and developed database and user interface of searchable, retrievable digital case records, resulting in expansion of businesses through higher efficiency in the areas of appointment scheduling, billing, collections, and report management. Created billing process that complies with the Healthcare Industry EDI 837 and EDI 835 Transaction Sets. Alef Standard Packaging, Philadelphia PA

Inventory and Warehouse Management System

Devised a unique application to retrieve items in the warehouse with location assignment resulting in productivity enhancement by 15%. Imaged product database supporting accurate order fulfillment resulting in 20 person-hours savings a month and reducing use of paper photo catalog. Monitored and responded to potential breakdowns in 24/7 web services. Designed maintenance-free website linked to company database system ( www.alefpackaging.com) . L & L Manufacturing Co., El Segundo CA

Order Management, Shipping and EDI system

Centralized database and client server technology enabled L&L Manufacturing to operate globally. Resulted in 120% increase in shipment labeling essential for complying with JC Penney’s Transportation Management System (TMS) requirements.

Digital Document Archiving Software

Yariv Kirschner

Page Two

Eliminated paper-based documentation archiving saving 1225 sq/ft of storage area and saving $7000 annually on binders. Fulfilled U.S. Customs and Border Protection criteria for long-term data retrieval and storage. Garment Costing Application

Linked inventory and cost sheets, resulting in increased accuracy in valuation of work-in-process and finished goods resulting in 250% improvement in time needed for compiling quarterly. EDUCATION

ISRAEL INSTITUTE OF TECHNOLOGY (TECHNION), Haifa, Israel Practical Engineer in Mechanical Engineering

Courses:

DEV Bootcamp: Web Developer, Ruby, Ruby on Rails, JavaScript, PostgreSQL Microsoft: Microsoft Certified Professional (MCP) Lynda.com: Installing SQL Server 2012, Advanced SQL Server: Reporting Services, Installing SQL Server 2012, SQL Server 2012: Designing Database Solutions, Tableau 9 Essential Training



Contact this candidate