Sql Server Dba/ Senior Programmer Analyst /architect Resume
3.00/5 (Submit Your Rating)
Santa Cruz, CA
PROFESSIONAL EXPERIENCE:
Confidential, Santa Cruz, CA
SQL Server DBA/ Senior Programmer Analyst /Architect
- Insurance company. Working on in house developed company system.
Confidential
Software Architect
- Provided designs, code reviews and guidance for 7 senior software developers
SQL Server DBA
Confidential
- Responsible for all company SQL Servers maintenance (backups, index fragmentation etc., 8 servers), Database design, stored procedures, triggers, SSIS, SSRS Merge and Transactional Replication, Log shipping, Disaster recovery planning and implementation,
- Provided guidance for developers
- Performed SQL optimizations, enforced data integrity
Senior Programmer Analyst
Confidential
- Designed and developed Rating Engine the central rating engine for the company insurance policy issuance software.
- Designed and developed out - of-sequence endorsements project
- Designed a system to manage and maintain more than 1500 in house developed reports. Designed and implemented a report environment to allow reuse reports’ instances and data retrieval procedures. Provided guidance to the Crystal Reports and SQL Server developers.
- Developed a system to extract, verify and manage addresses from paper forms (for example ACORD).
- Designed and developed cancellation notice system to prepare and manage cancellation notices sent to customers, brokers and loss payees.
- Designed and developed WCF application to print documents consisting of multiple reports, forms etc.
- The system was used to print policies and reduced the printing time from approx. 10 minutes per policy to less than a minute per policy.
- Designed and developed a reporting engine, which prepares UI for reports based on report parameters and predefined rules. The result was sent to Document management, screen, printer, email address or a local file
Confidential
Owner
- Designed and developed R-Tag Report manager, a tool for report automation.
- Added Document management based on MS SQL Server FileStream and MS SQL Server, XML metadata search
Confidential, Chicago, IL,
Lead Software Developer/ Database designer
- Led a team of software engineers to develop commercial software applications focusing on the point of sale industry, loyalty programs, and gift card processing
- Worked with international resources to design, develop, and market applications
Confidential
Senior Software Engineer
- S4 project. Web solution for the service agencies with prime activity management and maintenance of production factories
- School Card project - software for booking prepaid services for schools
- Migration of VB6 applications to VB.NET
Confidential
Senior Developer
- Responsible for the development of Orassys cruise ship based Point of Sale. This POS installation handled all sales, accounting, boarding and security systems on board of tourist’s vessels.
TECHNICAL SKILLS
- .Net, C#, ASP.Net 15 years
- MS SQL Server 18 years
- Oracle, Sybase 2 years