Resume Builder
Edit this resume to make it your own!

Your Name

SQL Server Architect/Developer/DBA

Sherman Oaks, CA


Highly accomplished Database Management expert with strong background in system and database design, development and implementation including extensive SQL Server database programming experience, performance tuning, report creation, and ETL. 
Strong analytical skills and proven ability to understand the business problem and apply automated solutions. Ability to join the projects in crisis, resolving issues to meet deadlines, to work independently as well as a team player. 
Broad, in-depth experience in object-oriented programming, understanding of SDLC, good technical report writing skills. 
Technical Proficiencies 
Software: .NET, Visual Basic/3d Party Controls, ASP Pages, Java Script, VBA, C, C++, COBOL, Fortran, Macro Assembler, VBScript, WHScript, XML, HTML.  
DBMS:SQL Server 2000/2005/2008 R2, BI suite: SSIS/SSRS/SSAS, Store Procedures, View, Triggers, UDF, TSQL, RDB, MS Access, INGRES, IMAGE. 
Environments: WindowsXP/2000/NT/7,SQL Server 2008 R2, MS DOS, VAX/VMS.  
Tools: MS Visio, BI Documentor, VSS, Active Reports, Crystal Reports, MS Office, Lotus Notes, VBInstaller, InnoSetup5, Orca, VMWare, Plan View, ASPEmail, ACMS DI

Work Experience

SQL Server Developer/DBA

Yoh/NBCU, Burbank, CA

Aug 2010Dec 2011

On-the-job accomplishments: Created normalized databases. Streamlined automation of data load into SQL Server database leading to a better quality of information, faster report delivery to upper management, and improvement of the alert system against piracy. Implemented mirror architecture for several databases. Maintained full responsibilities for production support of the SQL Server databases including installation, migration between servers, replication, and state monitoring.
  • Conducted design, development, and implementation of the Anti-Piracy Data Warehouse and OLTP databases. Redesigned multiple database models by implementing normalization rules in order to better serve the application requirements and improve performance.
  • Created and maintained stored procedures, views, indexes and constraints required to support the data access layer.
  • Created and implemented database backup, health check, performance tuned procedures using advanced indexing strategies and coding best practices.
  • Created and implemented numerous ETL processes to load databases using SSIS packages and .Net applications to automate the data transfer from different sources such as MySql, MS Access databases, Excel, PDF, XML, CVS documents. Created linked server in SQL Server to PostgreSQL database.
  • Setup SSRS servers. Created numerous SSRS reports and Power Pivot reports.
  • Converted multiple Perl/Java/MS Access VBA modules by replacing MySQL data source calls to MSSQL Server database.
  • Kept constant communication with the development team to identify potential issues and provided help by creating complex store procedures, user functions, and views. Resolved technical issues related to business applications.

Project Manager - Assistant

Cognizant/Health Net, Woodland Hills, CA

Nov 2008May 2010

On-the-job accomplishments: Managed conversion of the multi-tier component-based client server Capitation application (HNCAP) significantly simplifying application architecture, improving stability, performance and production support. HNCAP Conversion included migration ACMS tasks from Alpha to Itanium server and replacement of Tibco component with ACMS DI DLL
  • Managed production support and development of HNCAP.
  • Mentored outsourcing team on Production support.

Staff Programmer/Analyst

Health Net, Woodland Hills, CA

Aug 2002Nov 2008

On-the-job accomplishments: Developed and implemented new functionality of Capitation applications saving 25%-45% of time for financial and capitation units maximizing operational efficiency.
  • Converted complex MS Access multi-million dollar application to Capitation Payment Adjustment System application (HNCAS) running against SQL Server. Rewrote MS Access queries to Store Procedures and Views, created triggers to keep track of data modifications.
  • Managed HNCAS production support and development. Introduced functionalities included application security, reporting, data validation and automation of the data load.
  • Redesigned VMS legacy reports by implementing the .NET process on the client site, saving 20% of green paper in HN Printing Facilities and decreasing time on delivery of reports to customers.
  • Designed and implemented the client server batch processes using VB6, SQL Server DTS packages and SPs that automatically load the data from VMS to SQL Server, print the data load reports on user's printers and produce email notifications of load results.
  • Designed and implemented automation of the monthly and daily database backups from SQL server into MS Access database. Performed application conversion from VB6 to VB.NET.
  • Provided continued maintenance and development of bug fixes and patch sets for existing HNCAP application.
  • Designed and implemented Global Copy functions for multiple screens resulting in time and money savings.
  • Provided recommendations and proposals for architectural improvements, design and integration solutions to partner IT teams.

Senior Programmer/Analyst

Universal Music Group,

Jan 2000Jun 2002

On-the-job accomplishments: Created reusable DB class that helped to reduce the existing code of WEB application by 30%.
  • Designed, developed and implemented the client-server application to track new VHS/DVD Releases using VB6 and SQL Server database.
  • Participated in design, development and implementation of the movie promotion WEB application.

Senior Programmer/Analyst, Staff Programmer/Analyst

Health Net, Woodland Hills, CA

Feb 1995Jan 2000

On-the-job accomplishments: Technical lead on development of the 3 tier client server applications running in Production for more than 15 years. Redesigned the CASL (compiler) environment on VMS to allow simultaneous compilation of numerous HN plans leading to elimination of IT night shifts and improvement of Health Plan creation process.
  • Modified GEMS Batch process for data transfer from RDB to Mosas 32 SQL Server database using Shell scripts, MS Access macros and SP resulting in improved run time from 11 hours to 10 min.
  • Designed, developed and implemented Network Data Provider System (NDS), a 3 tier client server application using COM technology with multiple ActiveX DLLs (VB5/ACMS DI/ ACMS Tasks/RDB, DAO, MS Access).
  • Designed, developed and implemented GEMS application (Document Control system) for Contract Department using VB3/VB4/OLE Automation with WORD, MS Access database, ACMS DI middleware and ASMS tasks on VMS. GEMS application created GSA (Group Service Agreement), EOC (Evidence of Coverage), and Summary of Benefits documentation using Master template. Performed application conversion from VB3-16 bit to VB4-32 bit.

Programmer/Analyst, Senior Programmer/Analyst

CTC, Garden Grove, CA

Jun 1992Jan 1995


MS in Mathematics and Computer Science

Baku State University , Baku


Database Architect, Developer, Administartor

Additional Information

  • UCLA Semester on development of the Client Server Application.
  • 5 day classes:VB5, SQL Server 7, ORACLE PL/SQL, VB.NET, ASP.NET, JAVA, JAVA for WEB Development, SQL Server Performance, SSRS, SOA, WCF, WSIT/SOA.
  • On-line weekly webinars on SQL Server from PragmaticWorks
  • Brainbench Assessment Certificates on Data Modeling Concepts, Programming Concepts, Software Configuration Management, Software Testing, Customer Requirements Analysis, Business Communication
  • Active participant of the ExpertExchange site. Published article on database backup in 2010.
Powered by Super-Resume