Porugajte resume. MS SQL Developer. Intermidiate level?

В областях, не связанных с IT
User avatar
MYYY
Уже с Приветом
Posts: 268
Joined: 26 Jun 2002 15:04
Location: Boston, MA

Porugajte resume. MS SQL Developer. Intermidiate level?

Post by MYYY »

OBJECTIVES: Challenging position as Data Analyst or Database Programmer.
PROFESSIONAL SKILLS:
Languages: strong SQL, VB 5.0/6.0, HTML, VBScript, XML, JavaScript, VBA
Packages & Technologies: MS SQL Server 6.5/7.0/2000, Onyx CRM applications
(Onyx Employee Portal (OEP,OEAS 3.0/4.0); Onyx Customer Center (OCC 3.5/4.5/4.51/5.01/5.02)),
FirstLogics Server, Onyx ACE Batch, Sybase ASA 6.0, Access 7.0/8.0, MS Visual InterDev 2000, FrontPage 2000, ASP
Operating Systems: Windows 98/NT/2000
EXPERIENCE:

4/2003 – present [N.], Waltham, MA
Business & Data Analyst / Developer
• Current project: Import pre-processing application. It will validate data received from external sources, clean, restore, create or suggest missing blocks and links to existing customers, notify responsible representatives (MS SQL Server, MS Excel).
• Analyzed external data from multiple sources to import into Onyx database (MS SQL Server 2000/MS Access/MS Excel). Gathered all business and system’s requirements and rules.
• Implemented import processes and Data Transformation Packages.
• Created specifications and test plans. Communicated with users and data vendors through all stages of the project.
• By analyzing system’s workflow, current data and business needs suggested a list of enhancements to increase data validity, database integrity and application’s performance.
• Performed research on data cleansing options. Installed eQualityData software (Onyx ACE 2.51), applied customizations and tested. Provided user recommendations.
• Created a number of Marketing reports.


5/1998 – 3/2003 [G.], Norwell, MA
Data Analyst / System Developer
• Performed complex analysis, design, development, testing, and debugging of computer software in support of Onyx Customer Relationship Management System to help company successfully align sales, marketing and service strategies and processes around Giga Information Group customers.
Last completed project - "Inquries to 0nyx". The project was planned and successfully implemented to consolidate Inquiry and other Analyst Activity data into the Onyx system.
My role included:
- Development, testing and troubleshooting of database structures to support new Onyx Customer Portal functionalities and business rules (MS SQL Server 2000).
- Creation of web-based components and modification of existing modules to implement security logic and improve usability (XML, JavaScript) .
- Building link between OEP and Windows-based client object to consolidate data entered from different applications. (MS SQL Server 2000).
- Analyzing, coding and testing of data import process (MS DTS packages,
TSQL)
• Designed and implemented applications to import external data into master CRM database (VB/MS SQL/Access/Excel/Lotus Notes).
• Built a number of automated processes to write third party data into master CRM database including database bulk copy, restore options, avoiding excessive locks technique, data warehousing, etc. (SQL Server 6.5/7/2000)
• Created, troubleshot, modified and implemented two-way communication processes between different databases using MS SQL Data Transformation Packages (MS DTS).
• Analyzed and optimized database for Onyx Customer Center Application (OCC 3.5/4.5/4.51/5.01/5.02). Wrote a number of stored procedures and “clean up” scripts. Created and altered tables, triggers and indexes.
• Communicated and documented data status/knowledge/issues with clients, other members of the implementation teams (including other functional areas), program manager and senior management.
• Ensured cross-functional coordination of project, as well as ensured that standards and best practices are followed in the data implementation.
• Created VB COM objects to meet different types of needs for Sales department (VB 6.0).
• Created web pages using ASP and XML technologies for browser-based CRM Client.
• Provided detailed project status, resource utilization and metrics to management team.
• Provided direction, coaching and mentoring of junior project members.

5/1996-3/1998 Saga Corporation, Moscow, Russia
Programmer/Analyst
• Developed and supported a Client/Server Inventory/Warehouse System for food distribution company. Modified Purchase/Order System (VB 4.0/5.0, Sybase 6.0, Access 7.0)
• Participated in database design and normalization.
• Prepared technical documentation on various stages of product development.

EDUCATION:
2000 Earned certificate “Microsoft: Mastering Web Application”
Boston University, Boston
1995-1996 Certificate Graduate program (computer science)
MHTI, Moscow, Russia
1986-1992 BS Major in Chemical Engineering,
Moscow Mendeleev University of Chemical Technology, Russia

References: Furnished upon request.

Return to “Карьера и Работа”