BOB MOSSANEN

Sherman Oaks California

818-***-****

acn04v@r.postjobfree.com

Updated on: Jan 2 2015

PROFILE SUMMARY

• Senior .Net Architect/Developer with strong background in developing custom business solutions at all

levels including direct interaction with business analysts and project owners performing requirement analysis,

high level and low level design diagramming, database design, Service Oriented and Object Oriented Design

and development, testing and deployment - for Web and Windows Forms applications.

• Over 20 years of hands on experience in designing enterprise software solutions with many industries

collaborating the development of custom software with on-shore and off-shore team members, utilizing the

latest Microsoft Technologies with focus on practicing S.O.L.I.D. (O.O.P.) principles

• Experience with both Agile (certified Scrum Master) and waterfall methodology for SDLC.

Recent professional experience as a database designer, architect and lead developer:

1. Developed e-commerce applications for connecting internet and mobile customers to Psychics using Jquery

Mobile, Backbone, underscore, C# 4.0, RESTful API, Service Stack; design and developed Interactive Voice

Response system (Twilio,Tropo API & Amazon Cloudfront API),TFS, Entity Framework, IBATIS, Ruby,

VMC5, JQuery, CSS3, Bootstrap HTML5, Team City and SQL Server 2012 using Agile methodology.

2. Designed multi-layered framework solution for re-developing multiple enterprise applications. Participated in

the interview process and hired new developers for building framework’s common components (Security,

logging, Exception, Caching, etc. modules), co-developed Recruiting Application using MVC5, MVVM,

SQL Server 2012, Visual Studio 2013, TFS Web API, Web Services, Entity Framework, JQuery, Java Script,Json, MSMQ, XML, Bootstrap, CC3, Html5, Resharper, Kendo, Knockout, and resume parser software

RChilli, Sovren, etc.

3. Designed and developed database schemas, web services, and Web and windows applications for

Technicolor Digital Cinema division. Collaborating with talented team of developers for order processing

and booking for digital distribution of movies and advertising media to theatres across the world for studios

such as Disney, Warner Brothers, Sony, Paramount and etc. These applications are developed with Agile

methodology using Microsoft technologies under windows OS, using Visual Studio 2012, SQL Server 2012,

C# 4.5, IIS 7, Telerik Web Controls (Ajax), TeamPulse project planning, TFS, WPF. WCF (SOAP and

RESTful) services, ASP.NET, LINQ, ReSharper 8.0, Windows forms, Scrumwise, RedGate, Web API, Java

Script. JQuery, Html5, CSS3 and a very rich Framework libraries.

4. Designed and developed enterprise business application solution for Lender Processing Services.

Collaborated with a large team of developers in developing and deploying number of Web applications and

Web Services for new products related to property information for all addresses in United States. The solution

uses very large databases for property data warehouse, customer orders, customer service and billing

information. The solution is architected around multi layered, multi-tiered SOA with build-in code generated

units tests for various layers of the solution. Used SQL Server 2008, Visual Studio 2010, Windows Workflow,

Windows forms, WCF, ASP.NET, MVC 3 & 4, Java Script, JQuery, CSS3, Html5, Entity Framework,

Enterprise Library, LINQ, XML, App Fabric, MS Windows Services, and TFS with gated check-in

(continuous integration). Developed very sophisticated XSLT code generation engine for data driven custom

reporting services and XML transformation. Developed many stored procedures and optimized database

performance. Developed Health Monitoring Web Site and User Guide and Info Center Web site using MVC

3, MVVM.

5. Designed and developed websites for http://www.RollAdditives.Com (Petroleum Technology Company)

with database driven content management with built-in Role, privilege and function base

1

security system using SQL2008, VS2010, C# 4.0, Jquery,Json,CSS,MVC3, MVC4, Silverlight, Code Smith

Code generation tool, CKEditor, CKFinder, Resharper, XML, LINQ, JQuery, Java Script, Html5, CSS3,

Entity Framework etc.

6. Designed and develop and enhance an Application for creating interfaces to IBM data power Gateway (XI50)

for all Web Services and applications (Registration & Certification, Authentication and Authorization) for

Bank of America. Worked with Web Services Framework and Asynchronous framework (ATLAS).

Prototyping Asynchronous WCF processing solution for integration with ATLAS. Worked on performance

optimization and database partitioning and multi-threading processing in Windows applications.

7. Designed and developed Website and health monitoring applications using VS2010, C#4.0, ASP.NET 4.0, VS

Unit Test, WCF, and Re-Sharper for Bank of America.

8. Architected and developed series of applications for tracking business alliance records of financial

institutions, home builders and realtors for Bank of America. Used SharePoint for tracking all design artifact

and .Net technologies: VS2008, TFS, C#, XML, XSLT, XPATH, HTML, CSS, Java Script, Web Services,

WCF, Windows forms, ASP.NET 3.5, Ajax, SSRS, VSTS Unit Test, JQUERY, JSON, LINQ, Web Parts,

JavaScript, Windows Work Flow (WF), SSIS and MS SQL 2005, Oracle, OOD, N-tier architecture, Design

Patterns, Dependency Injection (Unity) and INFRAGISTICS.

9. Designed and developed Integrated ERP system (Windows and Web Applications) that includes wholesale

distribution system, Point of Sales, OLAP, CRM functionalities, E-Commerce (B2C-C2C) using C#,

VB.NET, SQL2000,2005, VSTS Unit Test, NUNIT, ADO.NET, XML, AJAX, VB6, CSS, HTML, VSS, TFS

and JavaScript for number of wholesale distributors. Part of the legacy code was migrated from VB6 to

VB.net and C#

Developed Data Transformation Services, SQL Server Integration Services, SQL Server Reporting Services,

10.

Web Services and Intranet applications using Object Oriented design and programming with design patterns

such as CRUD, Singleton, MVC, Factory Pattern, etc for Jones Trading Inc and Bank of America.

Data warehousing and OLAP applications using MS SQL 2000, 2005 OLAP, and ESSBASE for NBC

11.

Universal and Jones Trading,

Database design and creation of sophisticated Stored Procedures, Triggers, User Defined Functions, Views,

12.

CLR, automated tasks and jobs for Bank Of America, Jones Trading, Media Services and number of

wholesale and retail corporations.

Performance optimization for ASP.NET applications and database objects for Bank Of America and Media

13.

Services Company and TASER Evidence.COM

Performed architectural audit for TASER corporation (Evidence.COM and RouteCloud.COM)

14.

Principal Architect using Agile methodology with Scrum Master Certification for Civic Resource Group

15.

2

TECHNICAL SKILLS

Languages / C# 2003/2005/2008/2010/2012/2013, ASP.NET 1.1/2.0/3.5,4.0, and 4.5,4.5.1, AJAX,

Technologies: MVC2, MVC3, MVC4, MVC5, XSLT, CSS, VB.NET 2003/2005/2008/2010, ADO.NET,

XML, Visual Basic 3.0/4.0/5.0/6, VBA, ASP, VB Script, JavaScript, JQUERY, ADO,

ADO.NET, HTML5, DHTML, Silverlight 4, Silverlight 5, CSS3, ANGULAR, Knockout,

Bootstrap, T-SQL, Backbone, JQuery Mobile, Underscore, Interactive Voice Response-

IVR (Twilio, Tropo), Ruby

Methodologies / SOA, Object Oriented Programming, Design Patterns, Web Services, N-tier, Windows

Frameworks / Communication Foundation (WCF), Microsoft Windows System Services, Web

Architecture: Services, ORM (Object Relational Mapping), SOAP, Test Driven Development (TDD),

COM, COM+, UML, Agile (Scrum)

DBMS & related LINQ, LINQ TO SQL, Entity Framework (EF), IBATIS (ORM), SQL Server Integration

Technologies: Services(SSIS), SSRS, Sybase, Access, SQL Server 6.5, 7.0, 2000, 2005 and 2008, 2012,

OLAP, Hyperion, ESSBASE, MySQL, Oracle, T-SQL

Design Patterns: MVC, Factory, Singleton, MVVM, Observer, Repository, Dependency Injection,

Decoration, Façade, Adapter, Iterator, etc.

Tools & Others: SQL Server Reporting Services (SSRS), SSIS, VSS 2005, INFRAGISTICS, MS Office

.NET(Outlook, Excel, Word, Access, MS Project, etc.), MSMQ, SharePoint, Test Driven

Development (TDD), NUNIT, App Fabric, Active Report, Visual Interdev, Crystal

Reports Crystal Info 5.0, Erwin Data Modeler, Embarcadero, Erwin, VISIO, EAS, Lotus

Notes, Dev-Express, ReSharper 8.0, TELERIK controls(AJAX), Fortify(XSS),

Requirement Analysis Tools (Steel Trace), Code Smith. JSON library (Newton Software),

Unity Framework, Fiddler, TOAD for Oracle, RedGate, Automapper, Dynamic Data

Site, glimpse, TELERIK Team Pulse (project management), ScrumWise, Orchard CMS,

Chrome mobile emulator and debugger, Team City

IDEs: Team Foundation Server (TFS ), Visual Studio 2003, 2005, 2008,2010, 2012 Star Team

3

ASSIGNMENT PROFILES

Period: August 2014- Present

Title: Senior Software Engineer

Employer : Outlook Amusements

Location : Burbank California

Responsibility: Develop mobile global e-commerce application for selling Psychic services to international customers

using Jquery Mobile, Backbone, Html5, CSS3, underscore, service stack, REST API, Twilio, Tropo, Ruby, C# 4.5,

MVC5, SQL Server 2012, TFS, under Agile methodology

Accomplishments:

1. Bug fixes & research on using Jquery mobile multi-page approach for the application

2. Developed common custom client side validation routines using JQuery Mobile and

underscore

3. Developed purchase reading page and purchase review pages with reusable templates for

Psychic information, buying options, credit card processing using JQuery mobile,

underscore, Service Stack API services

4. Developed Interactive Voice Response application to callback customers and connect

them to their psychics using Twilio/Tropo API, Web API, SQL server 2012, C# 4.5, TFS,

MVC5.

5. Enhanced functionality to retrieve Communication Voice Transaction details through a

Web Portal solution using ASPNET MVC5, HTML5,CSS3, Bootstrap, Amazon Cloud

Front, Track-It API, Web API Services, IBATIS ORM software and SQL 2012.

6. Developed ability to maintain configuration setting for switching between IVR service

providers by features and customers.

7. Merge and deploy codes to higher environments using TFS and Team City

8. Used Amazon Cloud Front API for recording and retrieving files.

9. Designed and developed Windows Service for Transferring files from FTP folders to

Amazon Cloud front and other network folders.

10.Bug fixes related to Release of Twilio Telephony applications (Interactive Voice

Recognition modules).

11. Work on web portal to play all call audio recordings for customer and advisor

conversation prior to start of all conference calls.

Period: March 2014- July 2014

Role: Senior .NET Developer / Architect

Client: Cydcor

Location: Westlake Village, California

Responsibility: Architecture, design recruiting Application for group of independent organizations affiliated to

Cydcor corporation. This solutions is designed with enterprise architecture to include many other applications using

Microsoft Technologies. Collaborated with a team of developers, QA, DBAs, business analysts and a scrum master

(Agile development methodology).

Accomplishments:

1. Analyzed and proposed Security System using Microsoft Claims Principal (.Net 4.5.1)

2. Participated in conducting technical interviews for hiring new developers

3. Collaborate with Database team in creating enterprise data models

4

4. Created N-Tier solution that include Data Contracts, Repository Factory, Framework for

all common components such as security, logging, Exception tracking, Caching, and

Utility modules

5. Designed and co-developed Recruiting application for tracking Applicants, Resumes,

Job Sites and Job Postings using Visual Studio 2013, SQL Server 2012, MVC5, MVVM,

Entity Framework, Web API, Web Services, JQuery, LINQ, Bootstrap, CSS3, HTML5,

MSMQ, Kendo (Telerik), JQuery Plug in, CKEditor, SSIS, TFS,Json, XML, etc.

6. Developed interface to resume parsers APIs such as RChilli and Sovern

7. Developed Calendar tracking module for creating interview appointments for candidates

using Kendo (Telerik), and Knockout.

Period: May 2013- Feb 2014

Role: Senior .NET Developer / Architect

Client: Technicolor Digital Cinema

Location: Burbank California

Responsibility: Design, plan, estimate and develop number of custom Internet, Intranet and desktop applications and

tools for order processing for worldwide distribution of digital cinema and advertising media to theatres for number of

studios under Agile methodology using Microsoft platform and technologies.

Accomplishments:

1. Enhance studio web portal site for screen specific order processing of movie and advertising media

compositions for digital distribution to theatres by studios, countries, circuits, and cities

2. Database schema design and development of stored procedure for distribution of movie and advertising media

electronically or by USB drives. Maintained WPF windows app for tracking status of USB drive status and

web application that reports status of electronic and USB by theatre and flight dates.

3. Prototype WCF services application (RESTful protocol) for direct file upload as Json or XML for order

processing of certain studios through Java client.

4. Enhanced booking application with full text search for theatre lookup by selected fields. Enhanced the

Framework library with a utility module that can be used for any complex search criterion across fields of any

table or view.

5. Enhanced the web application for tracking and reporting theatre related information and status of media

distribution by current and future flight dates.

6. Planned, estimated and developed Open Key Order Processing for Studio Web Portal Site. The process of

order taking is tracked in a single ASP.NET page using Telerik controls and each step of the order is

organized in simple wizard like tabs.

7. Web Portal applications for Movie Titles & Compositions search by Packages and Movie Title Management

web pages by Studios, Distributor, and countries

8. Developed framework library modules for various Caching choices with capability of full text search at

service and client layers using LINQ, Log4Net, Entity framework, WCF, AOP, and Dependency injection.

All of the above applications are designed in multi-layered, multi-tiered, Service Oriented Architecture with full

localization of content. Full development life cycle is exercised with full participation of team members in planning,

designing, estimating, developing, and unit testing with code review process for minimizing complexity, optimizing

performance and increasing maintainability.

Following software tools are used:

VS 2012, C# 4.5, ASP.NET, TELRIK controls (AJAX), WCF, WPF, Windows Application, and SQL 2008 R2, TFS,

and Team pulse, LINQ, JQuery, Html5, JQuery, Java Script, CSS3, ReSharper 8.0, RedGate and ScrumWise.

Period: May 2012- May 2013

5

Role: Senior .NET Developer / Architect

Client: Lender Processing Services

http://www.lpsvcs.com/Pages/default.aspx

Location: Pasadena/Irvine

Responsibility: Designed and collaborated with a large team of developers to develop property information products

to be used by Web site users and API developers through a web service operations using Agile development

methodology

The solution uses many projects under various layers for presentation, proxy, services, applications, databases and

tools.

Accomplishments:

1. Maintain Large database for tracking property information including lien and foreclosure data on B2B Web

Portal using ASP.NET and Microsoft Windows System Services

2. Documented current and future state of a new system

3. Prepared business requirement documents with high level and low level diagrams using power point and

VISIO, MVC4 wire frame prototypes

4. Created tools (windows form application) for data transformation (XSLT code generation) and mapping

source and target data elements for custom reporting for Web Portal and API Web services

5. Developed proof of concept projects for comparing alternatives for web services transformation processes.

6. Collaborated with a large team of developers to create new products using Visual Studio 2010, C# 4.0, SQL

Server 2008, Work Flow, MSMQ, WCF, LINQ, App Fabric, MVC3, JQuery, CSS, Html, Entity Frame work,

Enterprise Library enhanced code Generation for unit testing and DTO regeneration modules.

7. Worked on optimizing database performance by partitioning large tables and revising their indexes

8. Develop Health Monitoring Web Site using MVC3 for testing various products

9. Developed API Integration Guide (Info Center web Site ASP.NET MVC)

Each product was related to searching property information based on various search criterions and reporting

information such as property valuation, parcel maps, document retrieval, property locations, property characteristics,

legal tax info, assessor tax information, lien and foreclosure history, sales transaction history, loan transaction history,

mortgage transaction history & etc.

Period: Oct 2011-May 2012

Location: Oxford UK

Client: Petroleum Technologies

Responsibilities: Designed, Co-developed complete website with an off-shore resource with the following features:

1. Content Management for all data

2. Search capability based on users’ role and privileges

3. Price Comparison feature for process of fulfilling orders

4. Role based security for all levels of users (Customers, Admin users, Suppliers, Manufacturers, etc.)

5. SSL for sensitive content

6. MVC3,4 for entering orders and price quotations

7. Control on SQL Injection and Cross Site Script attack

Used VS2010 C# 4.0, IIS 7, SQL 2008, Code Smith, CKEditor, CKFinder, Newton software, Jquery, CSS, Java Script,

Http Handler, MVC3,4, MVVM, Silverlight 4,5

Period: August 2010 – Sep 2011

Role: Senior .NET Developer / Architect

Client: Bank of America

Location: Agoura Hills, California

Responsibilities: Design and development of software in Central Services and Home Loan and Insurance Technology

Departments

6

Designed and co-developed health monitoring application that logs and reports status of various web sites & services

for tracking number of Data In and Document out (DIDO) operations. Worked on Fee Engine, Competitive

Information Analysis tools (Excel Pivot tables and charts), and Fraud Detector System (MVC pattern). Enhanced

MDR (Meta Data Repository tool) for managing version of all applications related to Web Services operations through

an interface to IBM Data Power gateway (XI50) for Registration and Certificates in relation to Authentication and

Authorization functionalities for Home Loan & Insurance IT Division. Prepared high level and low level design

documents using Power Point, Word Templates, UML, database schema, sequence, class, and work flow diagrams.

Optimized number of critical and complicated routines to achieve remarkable performance boost. Wrote script

generation procedures for partitioning large database tables. Performed research and development on seamless

integration of WCF services with current Web Services framework (ATLAS) with focus on Asynchronous Framework.

Used VS2010, Re-sharper 5.1, Asynchronous WCF, C# 4.0, ASP.NET 4.0, NUNIT, VS Unit Test, Multi-threading,

Fortify (Cross Site Scripting and SQL injection tool), XML Diff, XSD, XSLT, XPATH, VISIO, LINQ, VBA, SQL

2005/2008, Idera, Red Gate SQL products, MVC3,Jquery, CSS, Valium (Web service Test Tool). Etc.

Period: May 2010 – July 2010

Role: Senior .NET Developer / Architect Client: Civic Resource Group

Location: Los Angeles California

Responsibilities: web application development and design web site architecture

Collaborate with a team of developers to develop number of public facing web applications and Content Management

framework for various government agencies using Visual studio 2010, SQL Server 2008, TFS, java Script, Web

Services, WCF, AJAX, JQUERY, JSON, ASP.NET, C# 4.0, Vb.net 4.0, LINQ To SQL, Agile methodology (Scrum),

TELERIK controls, and number of Open Source software (DDAY.ICAL, Newton Software, etc.). Developed reusable

calendar control and integrated it with the content management framework utilizing 100% JQUERY, HTML, CSS and

C#, JSON with highly interactive UI. Collaborated on design of security system for the framework of the existing and

future web applications for view, edit and publish privileges in relation to all kinds of contents and related categories.

Created high level design diagrams and documentation for entire content management framework, and proposed

approach for improving the framework for all future website projects.

Period: March 2010 - April 2010

Role: Senior .NET Developer / Architect / Auditor

Client: TASER.COM

Location: Scottsdale, AZ

Responsibilities:

• Conducted audit on TASER Corporation’s software architecture:

• Reviewed overall architecture, design of databases, SDLC processes and deployment processes for

Evidence.COM. Documented the entire system (High level diagram, database schema diagram, sequence flow

diagram, class diagram, code analysis reports, etc.).

• Captured performance trace of daily transactions and analyzed the design flaws and bottle necks in the system

• Prepared power point presentation showing all issues with the system and recommended approach to correct the

problems for the system to become more dependable and scalable to be deployed internationally

• Reviewed architecture and software development life cycle and management for RouteCloud.com and

Protector.com and suggested recommendation for launch of the application.

Technologies: Microsoft .NET, Java, JavaScript, C++, C#, MS SQL2008, MySQL, SOA, CSS, HTML, SQLite, Web

Services, JSON, XML, XSLT, SOLR, PostgreSQL, ATLASSIAN tools, Subversion, Windows, and etc.

Period: Jun 2008 - Feb 2010

Role: Senior .NET Developer / Architect

Client: Bank of America

Location: Agoura Hills

Responsibilities:

7

• Designed, architected and co-developed number of .NET Web and Windows applications for Strategic Business

Alliance (SBA) department in Bank of America. Collaborated with over 50 members of on-shore and off-shore

team and developed very sophisticated, lean and scalable alliance relationship tracking system. Some of the

accomplishments are:

• Developed .Net framework for most of the common functionalities for rapid development of the applications. It

included code generator classes that produced stored procedures, triggers, C# classes for business objects, UI

objects, data access, caching, notifications, exception logging, etc.

• Created high level and low level design documents (UML, database diagram, sequence diagram, class diagram,

code generation and framework enhancements, development of complex part of the application)

• Participated in Interview and hiring off-shore and on-shore senior developers.

• Participated in project planning and task assignments to developers

• Designed databases and the applications’ architecture with appropriate Admin tools

• Built interface to nationwide corporate organizational and employee hierarchy databases.

• Maintained close collaboration with business analysts - performing system analysis, and work flow analysis and

user interface. Provided recommendations and approved business requirements.

• Implemented design patterns for various processes, so developers can follow a uniform standard for coding all

forms and processes for storing and retrieving data between database servers and web services.

• Collaborated with all developers and mentored the junior developers to follow and implement the right solution

for the business requirements.

• Performed High level and Low level design for various software components and conducted code review with

developers.

• Wrote scripts for configuration migrations between Development, QA, UAT and Production environments.

• Analyzed third party software and tools such as Crystal Reports, SSRS, INFRAGISTICS, etc. created live

demonstration of these products to management with my recommendation to make the right purchasing decisions

Period: Nov 2007 - Jun 2008

Role: Senior architect, developer and project manager

Client: NAIMIES Beauty Supply Center

Location: Valley Village, Los Angeles

Responsibilities:

• Managed a team of software developers and IT professionals.

• Conversion of legacy application from VB6 to VB.NET and C# using .Net framework 1.1 up to 4. Part of the

VB6 cods was created as COM objects and was referenced and used in the .NET code as well.

• Architected, designed and developed number of enhancements to Point of Sales, Inventory Tracking, Purchase

Order Processing, Sales Order Processing, Accounts Payable and E-commerce applications. This work included

developing physical inventory system with wireless hand held computers, PC Charge credit card processing,

upgrading numerous reports and CRM functionalities within Web and Windows applications.

Technologies: .NET

Period: Dec 2006- Nov 2007

Role: Senior Developer/ Architect

Client: Jones Trading

Location: West Lake Village

Responsibilities:

• Data transformation tasks for trading data for a clearing company named Pershing.

8

• Web request Service job to update new account databases with real time account information (SOAP

Document request from Pershing Hosting servers).

• Generic solution for data validation, error logging and updating of various daily trades downloads from the

Pershing FTP sites.

• Framework library in C# 2005. This framework incorporates many common utility classes to expedite the

.NET application development for Data Access, XML, ad hoc query and reporting with MS office integration

• Web portal that integrates all reports from multiple reporting servers using Web Services (SSRS Server/Client

Factory library).

• Developed a Task Status library with an appropriate web portal with built-in Admin capabilities. This web

portal contained maintenance of all applications’ configuration settings with log status viewer. This tool has

helped IT managers and developers to quickly diagnose errors and malfunctions for the scheduled jobs.

• Admin functionalities for a new application that integrates electronic communication between outside traders

and Jones Trading traders (JTEC). This application used MVC design pattern and WCF.

Period: Apr 2006- Sep 2006

Client: Sage Publication

Location: Westlake Village

Role: Senior developer consultant

Description:

• Enhanced Book and Journal publication tracking systems.

• Developed CRM functionalities for authors, contributors and clients to existing Intranet applications (Smart

Books, Spin Journals Customer Care Operating plan and Project Management System).

Period: Oct 2005- Jan 2006

Client: NBC Universal Home Entertainment Department

Location: Studio City

Description:

• Worked on Sales Forecasting and Data Warehousing application.

• Used VB6, ASP.NET, VB.NET, ESSBASE 7X API, Hyperion and Excel VBA, MS application blocks (Data

Access / Exception Handling), MS Project, ESSBASE API, Enterprise Architect, ESSBASE Administration

Services (EAS), VSS, KINTANA and INFRAGISTICS 5.2.

• Developed and implemented new features to Sales Forecasting system including time series analysis, multi-

product forecast update (ASP.NET, VB6) for ESSBASE cubes.

Period: Nov-2004 – Sep 2005

Client: Media Services

Location: Westwood

• Worked as technical project leader used VB.NET, ADO.NET, N-tier design, SQL 2000, Crystal 9 &10, Excel,

SQL Reporting services, and Access to develop highly complex payroll applications.

• SQL server database included over 4000 database objects (Stored Procedures, Views, Triggers, UDF, etc.).

Managed a team of programmers and worked on developing solutions to number of complex reports.

• Wrote number of Audit reports to identify business objects errors.

• Worked on performance tuning and optimized the important procedures and managed to gain significant

improvements (100 times).

Period: Feb-2002 – Oct 2004

Client: Several clients of Total Systems Approach namely Zaken Corporation, LA Gym, Epsilon Electronics,

Naimies Beauty Center & Infinity Schools.

9

Location: Sherman Oaks

Role: Senior consultant

Description:

• Developed number of desktop and web applications namely e-commerce, Point of Sales, Mail Order, Accounting

Systems, Help Desk Tracking, Online Courses and Exams Tracking, Survey Tracking system, Data Warehousing,

and interface to major search engines (www.google.com, www.msn.com, etc.).

Technologies: VB, ASP, VB.NET, ASP.NET, ADO, ADO.NET, N-tier design, OLAP, SQL 2000, XML, C#, Crystal,

Active Report, Excel, Word, and Access

Period: Nov 2000 – Feb 2002

Client: Universal Music Group (Studio City) (SWAT) (www.universalmusic.com)

Role: Senior consultant

Description: Designed, co-developed, and managed the following applications: Retail Detail, Order Link

(SQL/mainframe interface), People Depot, People Development, Mail Bag, Set Up Sheet, Store Display, TDS (Train-

time Data System), and XML Database Conversion.

Used: ASP, VB script, SQL 2000, HTML, Java Script, ADO.NET, CSS

Period: Sep 1996 - Oct 2000

Client: Several clients of Total Systems Approach, LA Gym Equipment, 1800-USSearch, California Power

Exchange, Avco Financial Services, Huges Space & Communication, Omelveny & Myers Law Firm, etc.

Role: Senior consultant developer

Description: Designed, developed and maintained numerous applications using Microsoft technologies on Windows

and Web platforms for all of the above clients. The details of the work and accomplishments will be available upon

request.

Used: VB6, Access, SQL, MS Office, ASP, HTML, CSS, Java script, VB

Contact this candidate