Vaishali Asmar
**************@*******.***
• Senior applications developer/analyst with over 12 years of professional experience in building highly available enterprise applications.
• Participated in all phases of full project lifecycle development including interaction with business users, requirements gathering, system study, analyzing requirements, estimation, planning, scheduling, documentation, designing, coding, debugging, creating test plans of large scale and complex applications
• Strong communication skills and performs well under demanding schedules to ensure total client satisfaction.
• Proven experience in data modeling, database design, db tunning, architecture and development using MS SQL Server. Very strong in writing SQL queries, DDL and DML statements, Stored Procedures, Cursors, Functions, Triggers. Proficient at Query optimization, tuning and performance.
• A true team player with excellent organizational, presentation, leadership, analytical, qualitative and interpersonal skills. Highly motivated with positive attitude and strong attention to details, top performing team contributor and outstanding learning abilities.
SKILLS
Operating System: MS Windows 95/98/NT/2000/XP/2k3, UNIX AIX 4.1, HP-UNIX Version A Release B.10.20, Linux.
Languages: MS Visual Studio 2k3/2k5/2k8(C#.Net), PowerBuilder 6.0/5.0/4.0, Perl
Framework: .Net framework 1.1/2.0/3.5
Internet Technologies: ASP.Net 1.1/2.0/3.5, ADO.Net, ASP, JavaScript, XML, HTML, IIS, ADO, Web Services, SOAP,
RDBMS & Tools: MS SQL Server 6.5/7/2k/2k5/2k8, Oracle 11g, SYBASE 11.9.2.3/11.0.2/4.5, WISQL, Exceed, DBArtisan 5.2
Version Controlling Tools: Microsoft Visual SourceSafe 6.0/SourceOffsite (SOS).
Office Technologies: Microsoft Sharepoint, Office, Front Page extensions, Infopath, Project, Visio, EXCEL, ACCESS.
Others: FTP, TNVT, RoyalTS for Terminal Services, XML Visualiser, Reflector, ReSharper
PROFESSIONAL EXPERIENCE
Automatic Data Processing, Inc (ADP) .
Project Name: Benefit Collection System (BCS)
May 2005 – August 2011
• BCS provides electronic remittance solution for Union benefit funds.
• It provides a wide range of online contribution services to participating Employers.
• It facilitates a rapid transmission of employer contributions and participant investment dollars to the Funds. BCS provides the front end for processing remittances, payments, employer and employee demographic information and employee status change information electronically.
• There is a nightly feed from COOL (client backend system) to ADP and vice versa.
• It also generates ACH feeds to do the electronic money movement to the Banks.
• The clients are large unions in the NY metro are.
Technology: ASP.NET 1.1/3.5, C#, MS Visual Studio .NET 2003, Microsoft Visual SourceSafe, Microsoft SQL Server 2000/2005/2008, DTS, SSIS.
Tools: XML Visualiser, Reflector, ReSharper, Visual SourceSafe/SourceOffSite (SOS), RoyalTS for Terminal Services.
Role: Gather user requirements, Analysis, Design, Development, Testing, Production Deployments, Production Support, Build and Patch management, Deployment to QA, DB restore from production, ACH module, Debug application code in QA. Primary role is in MS SQL DB.
Professional Detailing, Inc.
Projects Name: Shared Sales.
August 2003 – November 2003
• PDI is a healthcare sales and marketing company.
• Based on the business rules, the data is populated in MS-SQL Server 2000 and then sent in a flat file to DDS Harris.
• DDS Harris prints the Call Cards and mails it to all Reps.
• Reps are assigned Territories, which have many Doctors. Reps go to the Doctors and talk about the product for which the call is assigned. Then reps send the cards to Dakota, which optically scans the call cards and sends the data back to PDI.
• Based on the coming data, which shows the call status, sales reps get paid.
• This whole process was divided into many Stored Procedures.
Technology: Microsoft SQL Server 2000 Enterprise Edition.
Professional Detailing, INC.
Projects Name: Call Reporting For Shared Sales.
June 02 - July 03
• Responsible for developing Reports for different clients.
• This data relates to the calls made by Reps working through out the country. Data from Dakota used to be in text format, which needed to be uploaded in MS-SQL Server 2000.
• All this is done using stored procedures and generating global temporary tables for sending mails.
Technology: Microsoft SQL Server 2000 Enterprise Edition.
Merck-Medco Managed Care, L.L.C., Franklin Lakes, NJ.
Projects Name: MPA, MRxC, DHS, RxSEL
Aug 99 – July 2001
• As a SYBASE/UNIX developer, involved in Analysis, Design, Development, Testing and Automation of the MPA (Managed Prior Authorization), MRxC (Managed Rx Coverage) DHS (Digestive Health System) and RxSEL(Rx Selection) applications.
• Merck-Medco manages the prescription for its clients for different programs like MPA, MRxC, DHS, RxSEL, QPC, PA/PLA etc.
• These programs record, track and maintain interventions submitted for reviews. We get the on-line data from pharmacies (which are part of a Merck-Medco Managed Care Network) for all the clients based on the program they are participating.
• Involved in user requirements and analysis of the Application. Developed shell scripts extensively to automate transfer of data from Mainframe and Warehouse to Sybase in order to get claims and rejects.
• Wrote shell scripts to automate extracting data from on-line server every week and keep the Reporting Server in sink with on-line server. KornShell scripts were used to run the entire Automation process.
• Performance Tuning was used extensively to use the best execution plan in order to achieve best performance.
Technology: Sybase Adaptive Server Enterprise Version 11.9.2.3,Windows NT 4.0, HP-UNIX Version A Release B.10.20, WISQL, DBArtisan 5.2, Exceed, WISQL, UNIX Korn Shell Scripts, Perl, FTP, TNVT.
Pitney Bowes Inc, Stamford, CT.
Project Name: Sales Compensation System.
March 98 – July 99
• Pitney Bowes is a leader in mail metering systems and fax machines.
• Sales representatives sell the system as an individual item or as a packaged item and get paid commissions based on compensation and bonus plans.
• Sales Compensation System computes monthly Earnings and Bonus Earnings for the Sales Representatives and their regional managers using a set of compensation plans customized for various jobs.
• Involved in understanding of user requirements and analysis of the Application. Developed shell scripts to automate validation process.
Technology: Compaq Deskpro , AIX 4.1 UNIX on RS 6000, SYBASE 11.0.2, SQL-Programmer 2.2a, ISQL, FTP, Windows NT.
OMNIPOINT COMMUNICATIONS INC.
Project Name: Site Management System
Feb 97 - Feb 98
• Omnipoint is a PCS communications provider that installs sites containing electrical equipment to receive and transmit communication signals
• This application was used to keep track of all installation activities.
• Site management system contains the following modules: WorkOrder System, Finance System, Material Management System, Real Estate System.
Technology: MS-Windows NT, PowerBuilder 5.0.03 , MS-SQL Server 6.5.
Indian Space Research Organization (ISRO)
Space Applications Center
Mar 92 – Aug 92
• I was working as a project trainee and was a key member of development for Active Radar Calibration for External Calibration of ASAR Bread Board Model.
EDUCATION
1. Post Diploma in Electronics and Radio Engineering. Government Polytechnic, Gujarat, India
2. M.S. in MIS (Management Information Systems) in progress, Fairleigh Dickinson University, Teaneck, NJ
3. Oracle Certified Professional (OCP) 11g in progress, Fairleigh Dickinson University, Teaneck, NJ
TRAINING
1. C# Programming: Hands-On (Learning Tree)
2. Advanced .NET Framework (.NET 3.5) Programming Using C# (HOTT)