Sql Developer/EDI Associate
Resume:
Olegs Dobrikovs
Worcester, MA *1602
Email: **********@*****.***
SUMMARY: A team player with superior efficiency, ability to multitask and problem solve with over 15 years experience developing web-based applications/programming EDI transactions.
This includes:
Health&Benefits Solutions, such as creating EDI transaction sets/files/reports
including EDI 834/D Bill/Cobra/DOL/Confirmation Letter/PEW/Letter Alert and more
Government Solutions, such as Case Management which includes Offender Tracking, Job & Resume Bank Tracking and Homeless Case Management.
Real Estate Solutions such as Request™. Developing reports which structure facilitated real estate management. These reports included highly detailed features, such as Asset, Fund and Partnership Summary, Financial, Operational, Property and Tenant information.
Well-versed in all phases of the software development lifecycle. Excellent organizational and interpersonal skills. Attentive observer. Dedicated, with superior work ethic.
Programming:
T/PL-SQL, ASP.NET, Visual Basic 6, Vbscript, Javascript, HTML, DHTML, ASP, CSS, IIS
Databases:
Oracle 9/10/11, DB2, SQL Server 6.5/7/2000/2005, Access’97/2000/2003/2007
Platforms:
Windows NT 4, Windows 98/2000/XP/7/8, Windows Server 2000/2003
Tools:
Visual Studio .NET, Visual Studio 6, Microsoft Reports, Visual Web Developer 2005 Express Edition, Crystal Reports 9, DB Artisan, Toad, Microsoft Office 97/2000/2003/2007, Visual Source Safe, NotePad, DJ Map Creator, DI Data Integrator, InfoMaker, Adobe Acrobat Distiller, My SQL Tool, Claredi
PROFESSIONAL EXPERIENCE:
MERCER – Norwood, MA 2007 - Present
(PL-SQL, Windows XP/7/8, Oracle 9/10/11, DJ Map Creator, DI Data Integrator, InfoMaker, Adobe Acrobat Distiller, My SQL Tool, Claredi)
Programmer/Implementation Analyst -> Senior Programmer / Implementation Analyst
Responsible for logical and physical design, creating new and maintenance existing EDI transaction sets/reports/files.
Work closely with different teams (Client Service, GOSS, QA and Release Managements) and participating in all phases of the development lifecycle:
gathering requirements for necessary changes or creating new outputs
updating/developing new code
QA testing
providing Client service team and Clients with test files
analyzing and incorporate feedback into future releases
deployment of changes/new jobs in Production
ongoing support(including researches related with data or/and design)
Assisting in the development of training materials and documentation.
Providing training/sharing experience/mentoring new hired people in the team for programming methodologies and best practices.
Perot Systems – Norwood, MA 2007
(PLSQL, Windows XP, Oracle 9, NotePad, InfoMaker, DJ Map Creator, Claredi)
Associate EDI Analyst
Responsible for logical and physical design, maintenance and population EDI transactions/ reports. Gathering requirements for necessary changes, modifying and deploying reports
Work closely with different Teams to make sure all necessary changes was done as requested.
Modify existing EDI transactions/reports as per requirements.
Resolve Technology – Boston, MA 2006-2007
(ASP.NET, T-SQL, CSS, SQL Server 2005, Windows XP, Visual Studio .NET, Microsoft Report Services, Visual Web Developer 2005 Express Edition)
Software Engineer
Responsible for logical and physical design, maintenance and population of a Microsoft SQL Server 2005 data warehouse. Creating, modifying and deploying reports which include high level of detail to assist real estate managers by providing reliable data which maximizes the performance of every square foot of the portfolio. Developing reports which streamline operations by enabling manager’s to more fully utilize property and asset information. Modifying existing and creating new forms using ASP.NET.
Assess and optimize performance of existing SQL scripts and entity relationships which included its tables, views and stored procedures
Understand and refine the data warehouse population routines
Utilize input from clients to improve and enhance GUI and functionality of an existing reports.
Work closely with the lead product developer, project management and the QA Team to understand how the warehouse can be developed and best coordinated with other application tiers.
Modify existing and creating new forms.
Assist in the development of training materials and documentation.
Softscape, Inc. – Wayland, MA 2000-2005
(ASP, T-SQL, PL-SQL, CSS, IIS, Vbscript, JavaScript, HTML, DHTML, XML, SQL Server 7/2000, Access 2000/2003, Oracle 9, DB2, Windows NT 4, Windows 2000/XP, Windows Server 2000/2003, Visual Studio 6, Crystal Reports 9, DB Artisan, Toad, Microsoft Office 2000/2003, Visual Source Safe)
Software Developer 2004-2005
Responsible for complete lifecycle of web application development – from designing and developing to enhancing existing applications, addressing user issues and performing quality assurance testing.
Technical architecture and design. Performed database structure, which included its tables, views and stored procedures.
Building interface, forms and reports. Created different type of access menus for various security groups.
Creating and implementing Application Enhancements. Worked with clients to improve and enhance GUI and functionality of an existing application.
Participated in functional designs of specifications.
Thorough unit testing to assure application is ready for quality assurance testing.
Senior Technical Consultant 2002-2004
Worked with different State Departments, various Counties and numerous Communities across the United States. Created and developed web applications to case manage through forms that intake and functionality that assesses, plans, supervises and maintains to meet Federal, State and County client management needs.
Team Technical Leader, responsible for training new hires.
Designed and developed over 20 government projects for Massachusetts, Connecticut, Illinois, New York, North Carolina, South Carolina and California.
Technical Consultant 2000-2002
Created functionality that provided solutions to automate public sector management. Developed intake, tracking and assessment forms and functionality. This included offender tracking for the Judicial System and an ability for an unemployed individual to participate in programs which matched their specific employment needs.
.
Developed, tested, and debugged custom screens and tables for court automation system.
Developed, tested, and debugged custom reports in support of State’s Workforce Investment Act Program and Welfare.
Developed, tested, and debugged custom reports, forms, menus and workflow in support of Juvenile Justice Client Tracking and Case Management Information System
Designed and developed over 6 government projects for Massachusetts, Connecticut, Illinois, New York, North Carolina, South Carolina and California.
Technical Solutions – Boston, MA 2000
(ASP, T-SQL, CSS, IIS, JavaScript, HTML, DHTML, SQL Server 7, Access’97, Windows NT 4, Microsoft Office 97)
Programmer/Analyst
Created web-based application for a recruiting company, enabling candidates to post their resumes and employers to perform submissions.
Developed a secured administrative part to allow recruiters lookup and edits of submitted material.
SIA Gorelic Baltija – Riga, Latvia 1999 – 2000
(Visual Basic 6, SQL Server 6.5, Access’97, Windows NT 4, Microsoft Office 97)
Programmer/Analyst
Developed Intranet application to allow distributors to access information from SQL Server.
Created a workflow functionality enabling non-authorized buyers to submit purchase orders for approval.
Developed Dynamic HTML pages with client side Java Script, server side ASP, VB Script.
Designed and maintained SQL Server database, created and stored procedures.
BiLuks – Riga, Latvia 1997-1999
(Visual Basic 6, SQL Server 6.5, Access’97, Windows NT 4, Microsoft Office 97)
Developer
Developed, programmed and tested custom database management applications.
Analyzed client requirements and developed GUI according to user specifications.
Designed a database structure using Access.
Riga Train Research Institute – Riga, Latvia 1992-1997
Business Analyst
Designed and developed algorithm programs for microprocessor systems.
.
EDUCATION: Master Degree, Computer Science, Riga Technical University, Riga, Latvia 1986-1992.
Additional training, Computer Training School, Riga, Latvia 1997-1998.
References furnished upon request
Contact this candidate