Irina Gorenburg 781 Indian Spring Lane Buffalo Grove, IL 60089 Phone: (847) 943-9089
E-mail: [email protected]
Objective: Seeking a challenging Position in the field of Software Development Skills Summary
a Experience in analysis, design, implementation and testing phases of software applications in client server, windows and web based.
a Proven troubleshooting ability in independent analysis and improvement of larg e complex applications under the stress of time constraints in mission critical situations.
a Professional level skills in the full project development life cycle (SDLC) fr om user requirements to implementation, testing and user training. a Strong experience using RDBMS concept for database design and implementation u sing database objects, stored procedures, views, functions, and triggers using T -SQL.
a Experienced with high volume database transactions. a Familiarity with OOP.
a Hands on using design tools such as Microsoft Visio for development of Flo wcharts, Use Cases, and Class diagrams.
Achievements
www.microsoft.com/learning/mcp/transcripts ID=709168, access code=i5r91201 Microsoft certification in ASP.Net with Microsoft C#.
Microsoft certification in Visual Basic. Technical Expertise
Languages: C#, VB.NET, Visual Basic 4/5/6, T-SQL, XML, XQuery, HT ML, JavaScript, VB Script
Technologies: Microsoft .Net Framework (1.0,1,1,2.0,3.5)
ASP.NET, ADO.Net, ADO,DAO, Windows Service, We b Service
RDBMS: SQL Server 2000/2005, 2008, Microsoft Access
Applications: Visual Studio 2003/2005/2008, Reporting Services (SSR S), Crystal
Report 9.0
ETL Technologies: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)
Source Control: Team Foundation Server Source Control (TFS), Visual Sou rceSafe (VSS)
Work Experience
RCGIT Consulting a" Brightstar Corp, Libertyville, IL - consultant Mar 2010 a" Dec 30, 2010
Brightstar is global services company that provides services and solutions and v alue-added distribution for the three key participants in the wireless device bu siness: device manufacturers, network operators and retailers. Brightstar works with the worldas leading brands such as Dell, Apple, T-Mobile, LG, Motorola, Nok ia, Tracfone.
aTARE_RFIDa Project
The system is designed to process inbound and outbound Advance Shipment Notice E DI messages from and to retailers including pallet and carton information. Syste m creates RFID tags and barcode labels which will be attached to the pallets in order to automatically identify them.
Role:
a Created complex stored procedures to incorporate business process, functions, and triggers.
a Developed Inbound856Editor web page.
a Created deployment scripts, unit and system testing. a Created database projects in Visual Studio 2008 Environment:
SQL, XML, Xquery, SQL Server 2005/2008, C#, ASP.NET 3.5, Visual Studio 2008, TFS
aForward to Reversea Project
The system is designed to direct product returns received from Brightstar Forwar d Warehouse to Brightstar Reverse Warehouse using EDI to communicate the Transfe rs. System also included RMA application and databases.
Role:
a Created stored procedures for the new process.
a Integrated new processes into existing RMA Application.
a Created test plans, testing stored procedures, and deployment scripts. Environment:
SQL, SQL Server 2005/2008, C#, XML, Microsoft Enterprise Library, ASP.NET 3.5, V isual Studio 2008
Tracfone Freight Project
Was a leading member of the team assembled to create the system intended to gene rate Billing and Missing Freight Reports based on XML files received from EDI-21 0 Invoice Carrieras files.
Role:
a Participated in all project activities started from gathering business require ments, technical system architecture, and database design according to xml schem a.
a Created stored procedures, functions, tables, indexes.
a Designed and developed Console application which parses XML files and populate s the database.
a Created reports using Business Intelligence Project in VS 2008. a Created deployment scripts, unit and system testing.
Environment:
C#, Linq, XML, Microsoft Enterprise Library, ASP.NET 3.5, Visual Studio 2008, SQ L Server 2005/2008
Conducive Corp., Lincolnshire, IL - consultant Nov 2009 a" Mar 2010
Online Testing and Exercise System development. Initial system design based on business requirements. Determined major system components and modules. Desig n the database and create db objects. Implementing data tier, middle tier, and w eb interface (Web forms, Master page, and sitemap).
Environment:
C#, Linq, XML, Microsoft Enterprise Library, ASP.NET 3.5, Visual Studio 2008, SQ L Server 2005
LTD Commodities, LLC Bannockburn, IL Sep 2007 a" A ug 2009
LTD Commodities is one of the country's premier business-to-business merchandi sers with clients located throughout the country. All processes in the company f rom customeras orders to final shipments are automated. As a member of the IT de partmentas Warehouse systems development group, worked with applications that ar e used to manage work processes starting from the receiving dock to product ship ment and tracking. These applications create shipment plans, dispatch jobs to th e users, distribute products between conveyors, send parcels to appropriate dest ination, create and send shipment notifications to UPS and the USPS.
Updated multifunctional complex of Warehouse applications to reflect a new type of storage device installed in warehouse area (modified the main warehouse manag ement and business tools aLocator Control Systema and aLocator Systema a" both w eb-based applications). Used TFS Source Control.
Role:
a Modified/ redesigned stored procedures and the web service to reflect a new lo gic for the balance of jobs dispatched between order pickers, rich tracks, conve yor operators, etc.
a Modified the web pages for a new role of the vehicles at the new shelf locatio ns.
a Conducted a code review, created flowcharts with MS Visio for the warehouse process.
a Created deployment scripts and performed deployment.
a Troubleshooted and modified the application to eliminate malfunctioning. Achievements:
a Improved packaging line productivity by even distribution of the workload betw een operators.
Environment:
C#, VB.NET, ASP.NET 2.0, Microsoft Data Access Application Block, SQL Server 200 5, Web Service
PARTS (Package and Reconciliation Tracking System)
Supported, developed, and enhanced a Windows based mission critical applications that track and reconcile shipments in the warehouses and notify customers of th e shipments. All the processes are running continuously throughout the week, tri ggered by a system of file watchers and timer. The multi threaded application u ses Windows Service and SQL Server Integration Services (SSIS) packages for inte gration of multiple databases across different servers. The application uses XML configuration files to control process execution. Used TFS Source Control. Role:
a Modified and redesigned the application code to upgrade the application from S QL Server 2000 to SQL Server 2005.
a Implemented data model changes, software and configuration changes that led to significant performance improvements.
a Designed SSIS packages to replace DTS packages when upgraded to SQL Server 200 5.
a Converted the application from VS 2003 to VS 2008. a Updated and installed Windows Service.
a Served as the key person responsible for day-to-day support and troubleshootin g.
a Developed specifications for UPS Compliance project and was responsible for im plementation effort.
a Created support documents for the help desk. Updated technical specification f or PARTS.
Achievements:
a Greatly improved stability of the PARTS application
Reduced the number of system crashes from 2-3 per week to almost none. a Increased the speed of program execution and reduced the run time. Environment:
VB.NET, C#, XML, ADO.NET, SQL Server 2000/2005, SSIS Packages, Windows Service Industrial Network Systems, Mount Prospect, IL Nov 2005 a" Aug 2007
Enterprise Resource Planning System
Designed Enterprise Resource Planning System for GE Software Solution Provi der. The system is composed of Project Management, Sales, Supply Chain, Financia l, Customer Relationship Management, and Human Resources components. Application manages software and hardware orders, licenses, and all financial aspects of se
lling, upgrading, and product customization. The system interconnects project ma nagement with sales, financial, accounting aspects of day-to-day company busines s activities. The system is a web-based intranet application.
Role:
a Worked with internal business proponents, technical and management members of the team.
a Designed, developed, tested, and deployed the system in Visual Studio 2003. a Implemented security for the web application.
a Set up and maintained the database (complex stored procedures, functions, back ups,
jobs, and schedule).
a Created reports for project management, sales, and accounting in Acrobat using Crystal
Reports, in MS Word, and Excel. Achievements:
a Streamlined the processing of customers orders from initial quotation to the project completion and payments
a Increased effectiveness of day-to-day project management.
a Simplified software orders selection and authorization keys management. Environment:
VB.NET, ASP.NET, ADO.NET, SQL Server 2000, Crystal Report
Systegration Consulting, Inc. Glenview, IL - consultant Feb 2 004 a" Oct 2005
Systegration Management System
Systegration system is a web-based business management application. The applicat ion allows
recruiters to keep track of the companyas clients, projects, potential and curre nt consultants. The system is designed to use SQL Server and C# to enhance perf ormance, scalability and accessibility.
Role:
a Collected requirements, designed database schema and was responsible for the o verall implementation of the system.
a Developed data layer using ADO.NET to interact with SQL Server. Developed stor ed procedures, views, and user defined functions in T-SQL. Conducted unit testin g.
a Used VSS Source Control Environment:
C#, ASP.NET, ADO.NET, SQL Server 2000, Crystal Report
Home Mortgage Center, Northbrook, IL - consultant Nov 20 02 a" Dec 2003
Document Flow Management System
Designed and developed Document Flow Management application provided a consolida ted and detailed views of customeras accounts based on specified parameters: clo sing dates, expiration dates, application status, etc. The system produced daily reports which allowed for efficient workflow, decreased processing time and ear ly problem detection.
Environment:
VB6, ADO, SQL, MS Access
Cors, Inc., Itasca, IL Sep 1997 - Nov 200 1
Research and Sales Tracking System
Lead developer of a client-server application serving as the main business tool for the recruitment research company. The application was used by more than 100 sales associates, research analysts and project managers. The system kept t
rack of prospective sales, included a Customer Relationship module, and produced daily reports.
Environment:
VB 5/6, ADO, SQL Server 7.0, Windows NT, MS Office Library
Bell + Howell Co., Arlington Heights, IL - consultant Aug 1996 - Jul1997
Manufacturing and Testing Project
This application was designed to execute test functions for performance evaluati on of hardware products (industrial scanners) and collection of obtained statist ical data. Designed database, developed the graphic user interface, and develope d various reports.
Environment:
VB 4, C, DAO, SQL, MS Access Education
Web Development /.NET, C# - Advanced Computer Training, Glenview, IL Advanced Computer Courses a" Touro College, New York, NY
