19 Grande Blvd, Delran, NJ 08075
Cell: (609) 221- 8512
oksana_syrkin@yahoo.com
SUMMARY
Senior Developer with over 11 years of experience in designing and building custom applications using Oracle and SQL Server databases and tools in Unix and Window environments. Energetic self-starter with excellent analytical and organizational skills. Achieves goals, objectives and milestones in an accurate and consistent manner.
Possesses expert skills in the development of appication:
Lead the development of various dashboards, management reporting processes with CrystalReport using sub-reports, advanced formulas/algorithms, conditional formatting.
Oracle 10 g experience creating complex database queries, writing Constrains, Indexes, Views, Stored procedures, Cursors and Triggers.
Advanced SQL query writing in SQL Server 2008, including the writing of complex stored procedures with Transact-SQL.Inbound Interfaces using SQL loader/FTP process
Expertise in providing services related to software design and development, testing, integration and implementation.
Good exposure of Quality processes (Sarbanes-Oxley Audit standards).
Strong Interpersonal Skills, Self-motivation, Co-ordination Skills and the ability to communicate both orally & in writing with people at all levels.
Committed to client satisfaction, detail-oriented, positive thinker and reliable multitasking team player.
TECHNICAL PROFICIENCY
Operating Systems: Windows NT/2003/2008, HP/AIX UNIX
Databases: Oracle 10g/8i, MS SQL Server 2005/2008, MS Access
Languages: PL/SQL, T-SQL, VB 6.0, VB. NET, ASP.NET, VB Script
Framework: NET FW 3.5
Designing Tools: Visual Studio 2005/2008
Reporting Tools: Crystal Reports 8.5/9.0/10.5/11.0, Crystal Reports.NET
Version Control: PVCS, Visual Source Safe
Other Tools: Microsoft Excel, Symantec Pc Anywhere, SQL Navigator 5.5, TOAD
PROFESSIONAL EXPERIENCE
CTN Solutions (ctnsolutions.com) Senior Crystal Developer / Consultant February 2011 - Current
Reviews and analyzes Dexter + Chaney’s Spectrum® Construction system including encoding, testing, debugging and installing using SQL server 2008 and Crystal Report 11 skill set.
Interfaced with various users to gather information and determine needs. Crystal Report creation:
• Advanced formatting (insert objects group by cross-tab, conditionally format groups, filter by group).
• Develop subreports, sharing formulas, running totals, cross-tab reports (conditional formatting).
• SQL coding within Crystal tool (use of SQL aggregate functions, SQL joins, subqueries, SQL expressions).
Test and evaluate information and reconcile any differences from expected results. Provided project status updates.
Wedgewood Pharmacy (www.wedgwoodpharmacy.com )
Senior Programmer Analyst June 2010 – January 2011
Responsible for designing, developing, and testing custom software modules for the Sage MAS 500 ERP system on (VB/SQL Server platform). Handling analysis, design, development, implementations, enhancements, testing, deployment, training, maintenance and documentation of information systems in pharmatestical industry.
Independent research/ analysys on relational database structures: tables, data types, data model schemas. Created, maintained, and supported complex reports (cross tabs, drill downs, etc.) and sub-reports with multipart formulas and customized functions.
Schedule the Report, if required, to produce on requested frequency.
Increased productivity by reducing the report generation time from over 2 hours of manual labor to less then a minute
Merck and Co., Inc (www.merck.com)
Crystal Reports Developer March 2010 – May 2010
Provide consultative services to the business users related to the use and management of data. Ability to design, run, and maintains a library of report to support operational departments that support medical costs, utilization, provider performance and patient outcomes.
Jones Apparel Group, Nine West Distribution Center
Oracle Developer May 2000 - January 2010
Jones Apparel Group, Inc. (www.jonesapparel.com) is a leading designer, marketer and wholesaler of branded apparel, footwear and accessories.
Overview
In-depth knowledge of Nine West Warehouse management system/Distribution system i.e. DMS, RF Application, MDC, Nordol purge system.
Involved in designing major modules for DMS/MDC system, which includes receiving, shipping, packing slips, ship labels applications using SDLC approach. The responsibility included defining/understanding business need from business users, conduct system analysis, coordinate manage development team, unit testing and to deliver a fully functional system.
Key resource in designing, developing and implementation of Nordol purge system - The system is subset of DMS application.
Played a key role in building road map for migration of distribution center legacy applications to modern technological platforms that includes migration from Oracle 8i to 10g, VB6 to VB.NET and certain other legacy applications.
Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
Troubleshooted, fixed, and implemented bug fixes and enhancements within tight deadlines.
Worked extensively in developing .NET Screens (VB.NET/ ASP.NET), VB Screens, Crystal report 11.0 based on DB stored procedure/views, DB objects includes Triggers, Views on Oracle 10g.
Project Undertaken
DMS - Distribution Management System–
The responsibilities includes understanding/managing the requirements from business users and provide design recommendations and custom solutions to meet various business needs, including major enhancements to existing systems using latest technology trends (SOA Architecture), using SDLC approach.
Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, triggers.
Technology migration - VB6 to VB.NET and Oracle 8i to Oracle 10g.
Designed forms for RF Handheld devices in ASP.NET to support barcode scanning and receiving/put away/shipping operations.
Created documentation for all aspects of the project including training the end users.
Involved in Maintenance/enhancement/Support of the application.
MDC – Multiple (warehouse) Distribution System–
Development of New screens/reports for adding capability in DMS to support another warehouse (MDC).
Aggressively participated in Unit testing/UAT for MDC.
Involved in Maintenance/enhancement/Support of the application.
Nordol – Nine West Purge System–
Migrations of Nordol purge system from legacy platform to latest technical platform using client server architecture. Their platform used for development/migration is .NET (VB .NET/ASP.NET) and Oracle 10g(PL/SQL) as Database on Framework 3.5.
Designed interfaces to process the inbound data and prepared outbound interfaces for central system (order management system). This involves job automation and scheduling.
Reports were designed using Crystal report 11 using Oracle Native driver and ODBC driver.
Coordinated UAT/SIT with end user for acceptance.
Currently providing maintenance support for the application.
EDUCATION AND TRAINING
Programmer/Analyst, Information Technology, CHUBB Institute, North Brunswick, NJ 2000
M.S., Engineering, Leningrad Institute for Textile and Light Industry, Saint Petersburg, Russia 1988
SAGE University, Irvine, CA
Software Development Kit 2010
ONLC Training Center, Mount Laurel, NJ
Crystal Reports 11.0 Advanced 2008
Core Windows Forms Technologies with Microsoft Visual Studio 2005 2008
Programming with Visual Basic .NET 2007
Developing Web Applications using Microsoft Visual Studio 2005 2007
Learning Tree, Philadelphia, PA
Oracle PL/SQL programming 2007
. .