Developer Sql Server

Murat T Abrarov

**** ******* ******,

Northbrook, IL 60062

********@*****.***

224-***-**** (cell)

847-***-**** (home)

Career Summary

Comprehensive experience and practice of full SDLC in client server and web environments. Wide practical skills of program database units, performance tuning and modeling of relational database (ORACLE, SQL Server). Broad practice of extract, transform and load ( ETL) data from outside sources, object oriented programming and design (OOP/OOD). Over 15 years of IT consulting experience in supply chain, financial, food, logistics, insurance, non-profit businesses.

Technical Skills

Languages: SQL, PL/SQL, Unix Shell, MS ASP, Crystal Server Pages, Visual Basic, VBScript, C, C++, JavaScript, HTML, DHTML, XML, Perl

Operating Systems: Windows 7, NT, XP, UNIX

Databases: Oracle 10g, 11g, MS SQL Server , MS Access, DB2 UDB

Software: SQL *plus Oracle Developer 2000 Tools (Project Builder, Form Builder, Report Builder), SQL Navigator, TOAD, SQL Developer, SQL Loader, Crystal Reports, Crystal Enterprise, EDI, ActiveX, COM, DCOM, JDK 1.2, Visual Café, IIS 6.0, Visual lnterDev 6.0, Visual Studio 6.0, Visual SourceSafe, 6.0,PVCS 6.8, ERWIN, Visio, MS Project, WS_FTP Pro 6.6, UltraEdit-32, Altova XMLSpy 2012

Additional Skills:

Mortgage Loan Originator: More than two years of experience of origination and modification of residential mortgage loans at multi-branch mortgage company. Broad understanding of residential mortgage loans and federal regulations governing residential real estate lending. Strong organizational skills and the ability to prepare and make presentations to individuals

Loan Originator (License No. 031-*******)

Certifications

Oracle Certified Professional (Internet Application Developer, Oracle Forms Developer)

Microsoft Certified Professional (ID: 1224128)

Mortgage Loan Originator License

Professional Experience

Terra Technology, Schaumburg, IL

Sr. Development Engineer - 07/2010 - Present

Using Oracle 11g developed of Multi-Enterprise Inventory Optimization (MIO) – supply chain software product

• Created set of packages, procedures to implement forecast calculations based on business requirements

• Efficiently processed large amount of data using Bulk Collect, Pipelined Table functions, Dynamic partition, Ref cursor, Collections, Nested and PL/SQL tables

• Gathered requirements and implemented a new logic to load data specific for each OS user (by redesign tables and use SYS_CONTEXT function)

• Enhanced performance by Parallelizing, use collections, table of types, and pipe row to store data in memory to avoid multiple calls (loads)

• Used dynamic SQL to create Indexes, build and populate required set of DB Tables

.

Keane Consulting Inc, Chicago, IL Client: City of Chicago

Sr. Principal Consultant - 08/2005 - 07/2010

Design and development from scratch (SDLC) an application to automate business of Mayor’s Liquor Licensee Committee (Oracle Forms and Reports v.10g)

• Created High Level design of DB Model, Flow Screens Diagram and discussed technical solutions with end users.

• ETL source data from Mainframe and loaded into ORACLE (SQL Loader)

• Translated business requirements into technical specifications and created detailed design of application

• Development of Screens, Reports, and scripts for conversion data into the new system.

• Managed development team, conduct process of testing, implementation and production support of application at the stabilization phase

Responsible for enhancements and production support of application to process City of Chicago payments

• Designed and developed set of Shell/Perl scripts to implement ETL from different financial sources (Bank of America, JPM Chase.. Harris etc.)

• Enhanced and monitor a process of loading data using SQL Loader

• Created set of views, tables, and triggers to process Revenue payments in Oracle

• Organized and conduct development of a set of Survey and Adjudication reports (Oracle Reports)

• Participated in hiring process of new developers for different projects

BN Owner Mortgage Inc.

Mortgage Loan Originator – 04/2007 – 06/2009

As a Second Job on the weekends

• Solicited residential first mortgages through contacts with realtors, neighbors, friends and co-workers.

• Prepared loan application package, maintaining loan application records, assembling all required documents.

• Negotiated terms and conditions of load with mortgagors.

Conagra Foods Inc, Schaumburg, IL Consultant - 11/2002 08/2005

Responsible for analysis of business requirements, create technical design, validation and support of the integration process of HUB (warehouse system) and multiple logistics sources

• Translated business requirements into technical specifications for developers. Communicated with developers to clarify business rules, defined solutions for technical difficulties

• Implemented standard Electronic Data Interchange (EDI) formats and data dictionaries for inter-system communications

• Created unit test plans and prepared sample data to execute complex test cases. Validated test results and resolved issues, working with both business and technical personnel

• Designed, developed of corporate web reports for Transportation and Warehouse Management Systems (Crystal Reports, Crystal Enterprise) and complex stored procedures, and packages (Oracle)

• Authored functional requirements, technical designs, and unit test plans

Comdisco Inc, Rosemont, IL Software Developer 2 - 10/1999 05/2002

Responsible for the development of a B2B Asset Management System (IT CAP Solution) used MS Active Server Pages, combined standard HTML/DHTML elements, CSS, and scripting languages (JavaScript, VBScript)

• Used ActiveX Data Objects (ADO), MS ASP, packages and stored procedures (SQL Server) to display information in near real-time

Rotary International Evanston, IL Senior System Engineer - 07/1997 - 10/1999

• Designed and developed of the company’s Website (http:f/www.rotary.org) and an Intranet Application for generating the Semi-Annual Reports (used Oracle Application Server’s PL/SQL Agent and Java Interpreter cartridges)

• Involved with all stages of Donor application development (Visual Basic front-end, Oracle back-end)

AON Inc, Chicago, IL Consultant, Programmer/Analyst – 03/1997 - 07/1997

• Converted mainframe data into a normalized relational database structure (MS SQL Server)

• Developed multiple reports to display custom financial calculations (MS Access)

TASC Inc., Chicago Programmer Analyst - 10/1995 -03/1997

• Developed and supported applications for Client Tracking System using Visual Basic, MS SQL Server, MS Access and Crystal Reports

Certifications

06/2008 –Mortgage Loan Originator. License No 031.0022494. Certificate:97115-470418026339

08/2002 - Oracle Certified Professional (Internet Application Developer, Oracle Forms Developer)

06/2000 - Microsoft Certified Professional (ID: 1224128)

Education

1994 – 1995 - Advanced Technology Institute (ATI) - Chicago, IL

Computer Science Training Courses

1989 - Moscow Scientifically Research Institute of Art of Education

Ph.D. in Education - Moscow, Russia

1983-1987 - The Russian Gnesins Academy of Music, - Moscow, Russia

MS in Music Education

Training Courses

Keane Inc.

Productive Project Management September 2005

De Paul University.

Java Application Development March 1999

Contact this candidate