SMITA PAI
11 Crystal CT Milpitas, CA 95035
Email: [Send email using form at bottom]
Phone: [Send email to request phone number] 45-9976
SOFTWARE ENGINEER
.NET Framework | Visual Studio | SQL Server | Crystal Reports
Detail oriented programmer with over 8 years of experience devising tailored web
solutions to meet ever-changing business requirements within diverse industries.
Advanced skill with programming skills and rapidly utilize emerging technologies.
Accomplished software engineer with many complete product development cycle and
release experiences seeking to utilize these technical skills and merits into a
challenging software development position
Environments Windows, Unix, Linux
Programming ASP.net, C#, AJAX,ASP,VB 6, COM, HTML, DHTML, JavaScript, VBScript
Development Object-oriented Design(OOD), Project Management, Technical
Documentation, Quality Assurance
Reporting Crystal Reports, Access Reports, Excel reports
Database MS SQL , MS Access
PROFESSIONAL EXPERIENCE
SOFTWARE ENGINEER, APRIL 2007 – JULY 2008
Public Wireless - Milpitas, California
Develop, maintain and test website solution for wireless coverage. Website
development to make it SEO optimized. Design Web applications and maintain
content for .NET based systems.
Website for Public Wireless/ Amber Networks:
Google maps API usage for creating search-ring area of any shapes polygon,
rectangle circle or any other shape the user selects. Displaying the search ring
as per user login and preference.
Extensive use of AJAX for adding locations on the map. Database optimization for
the locations added. This website contains a CRM module, where companies can be
added and contacts are linked to each company. Any conversation between contacts
or companies is recorded and can be viewed upon authorization.
The reporting module gives a series of options list where the user can choose
from to get the specific result set. Designed and developed reports for MLA
(Marketing Level Agreement) and SLA (Service Level Agreement).
SQL server transaction log backup and clearing on a regular basis. Optimized
database by adding indexes, replacing stored procedures by functions thus
reducing processing time by 6%.
SENIOR PROGRAMMER ANALYST, December 2004 – March 2007
San Francisco Health Plan – San Francisco, California
Designed and developed desktop applications for intake of comma de-limited files
from UCSF.A web-service sent e-mail confirmations upon new file dump and the C#
application processed this file on a monthly basis. This traversed through
thousands of membership data records and any invalid data used to be stored in
separate data base table for error checks. The idea behind doing this was not to
completely reject the whole file but process as many records as possible. The
project currently submits all this data to the state and hence has a big impact
on the organization receiving funds.
Engineered DTS packages and jobs for capitation process to incorporate HIPAA
compliant file transfer and processing. Capitation files 820 and claims 837
mapping to database tables and processing of these files and output in HIPAA
format for EDI exchange.
Documentation of the program Healthy Kids and Young Adults and all the processes
involved.
Testing of all the processes and using source control Visual Source safe. ETL
jobs created to move snapshot data on to staging server for report generation.
Data mining done for the HKYA(Healthy Kids and Young Adults) program tables to
predict and come up with analysis on growth of membership per ethnicity, location
and age group.
QA and Programmer, November 2003 – March 2004
SKIRE – Menlo Park, California
Charged with testing and communicating with programmers prior to product release
cycle.
Designed test plans and verified results on every product version change or
enhancement.
Developer, May 2003 – October 2004
Droox – Menlo Park, California
A health care project based on HIPAA compliances. This web based tool aims at
solving various problems that are faced by healthcare industry in US. Bridges
down the gap between doctors and patient, so that each of them are aware about
their insurance policies and can access their respective providers. In order to
be HIPAA compliant various levels of security using RSA encryption protocol and
libraries provided by ASP.Net are used. Using the SMTP respective emails are sent
to the users of this system for any changes to their account.
Assistant Consultant, Aug 2000 - Jan 2002
Genisys Software India Pvt. Ltd. – Bangalore, India
Requirements Specifications, Low Level Designing, Database Design, Coding as per
ISO standards, Code Level Testing, Hosting websites. Selected projects include…
• Consulting Company based in UK.This had sophisticated stored procedures for
all the search pages written in SQL and were executed on the client CLICK
function in ASP. www.mclarensolutions.co.uk/hr/middle.htm •
• Barkers - (UK project) - Work executed in London as well as the Indian office;
Work done includes Web pages designed in XML/ XSL and internally calling COM
components interfacing VB which intern would talk to the SQL Server which
executed the stored procedures. Also used Seagate’s Crystal 8.0 created objects
from ASP and had web reports hosted on IIS •
• Delarue (Project Hive) - Extensively used JavaScript for developing the
territories module. Also developed Patent for this company. www.delarue.com ..
Programmer, July1999 - August 2000
Primark - Bangalore, India
Conceptualizing and executing layouts for the web medium. Interacting with
finance department to understand the tax calculation and executing printer
customized Java ERW reports.
Development Engineer, May 1998 - June 1999
Project Planning Services Ltd. - Bangalore, India
Thorough study of MIS (Management Information Systems). Understanding ISO forms
and procedures and implementation of the same in projects. Conceptualized &
executed the following projects with formal meetings with the clients. Selected
projects include…
Deldot Private Limited - Developed Integrated Quality Management & Information
System as an Intranet system for internal users to track the employee daily
report and rate the effectively working hours by every individual which thus
counted for an appraisal done bi-monthly. Also Visualization Document for every
Team Leader to view progress of his/her subordinate and every Project Manager to
view each Team Leader's job and rate their respective subordinate with different
levels of authentication so as to keep every rating secretive. This level of
authentication required an extensive database designing and various relations.
EDUCATION
Masters of Science - Computer Science
|
