TECHNICAL SKILLS:

.NET Skill Set: ASP.NET, C#, VB.NET, ADO.NET

Oracle 11g, MS: SQL Server 2005/2008, Sybase 11

Reporting Tools: SSRS, Oracle Reports

ETL Tools: SSIS, DTS

Oracle Forms, T: SQL, PL/SQL, PowerBuilder

Methodologies: Agile, SDLC, Waterfall

Documentation: Functional, Technical

Operating Systems: Windows 8, Windows Server 2008/2003, Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, Covina, CA

Developer - Contractor

Responsibilities:

• Designed an Archive/Purge process for teh various tax systems at Confidential .
• Created Techincal Requirement Document (TRDs) per business needs.
• Developed & fixed various bugs utilizing ASP.NET 3.5/4.5, C#, and SQL Server 2012
• Utilized Sharepoint for document repository.
• Utilized TFS for Version Control

Confidential, Norwalk, CA

Developer - Contractor

Responsibilities:

• Developed various modules in ASP.NET for PRMS Application from legacy Oracle Forms PPI Application.
• Developed in VS 2013 utilizing ASP.NET4.5, C#, and AJAX extension controls for validation.
• Created packages & stored procedures in PL/SQL utilizing SQL Developer for Oracle 11g.
• Utilized Tortoise SVN for Version Control.

Confidential, Encino, CA

Developer - Contractor

Responsibilities:

• Supported & Maintained JEMP app for Customer/Order data..
• Utilized ASP.NET4.0 and C#.
• Utilized exsiting SSIS package to import Customer/Order data to SQL Server tables.
• Utilized SQL Server 2008 to maintain/modify existing stored procedures.

Confidential

Software Engineer

Responsibilities:

• Developed, Supported & Maintained various EMR(Electronic Medical Records) apps which which contain teh Veteran’s data and diagnosis.
• Developed in VS 2012 utilizing ASP.NET 4.5, C#
• Utilized WCF to invoke stored procedures.
• Utilized both Toad for Oracle 11g & SQL Server Management Studio 2008 to modify / create stored procedures.
• Supported & Maintained Billing Legacy app in Oracle Forms.
• Collected user requirements and documenting functional / technical specs as needed
• TFS was used for both Source Control & Sprint Planning utilizing Scrum/Agile Mythodology.

Confidential, Los Angeles, CA

Developer - Contractor

Responsibilities:

• Developed, supported and maintained existing Hope for Health application for various hospital clients
• Utilized both ASP.NET 2.0 & C#
• Utilized SQL Server 2005 to modify / create stored procedures
• Collected user requirements and documenting functional / technical specs as needed
• Utilized Visio to create various use cases & activity diagrams based on user requests and business logic
• Utilized SSIS (SQL Server Integrated Services) to transfer data between SQL Server & Excel

Confidential, Carlsbad, CA

Develper - Contractor

Responsibilities:

• Developed & supported existing IBS app for their client Videocon in India
• Documented integral processes such as Logisitics describing teh process of incoming message from SAP to IBS and outgoing messages to from IBS to SAP
• Utilized both ASP.NET 3.5 & C#
• Utilized Oracle using Toad to modify / create stored procedures
• SharePoint was used as a repository for documentation
• Mercury was used to track bugs

Confidential, San Diego, CA

Developer - Contractor

Responsibilities:

• Developed and supported existing FlexLeague Application & TLCA (Tennis Link Common Admin Application) for their USTA Client
• Utilized both ASP.NET 3.5 & VB.NET
• Modified and created stored procedures utilizing SQL Server 2005
• SVN was used for Version Control

Confidential, La Jolla, CA

Developer - Contractor

Responsibilities:

• Fixed existing bugs in current MedNeutral application
• Utilized both ASP.NET 3.0 & Windows Forms using C#
• Modified and created stored procedures utilizing SQL Server 2005
• Team Foundation was used for Version Control

Confidential, Los Angeles, CA

Developer - Contractor

Responsibilities:

• Developed an“Outreach” application to track appointment calls made to patients
• Utilized ASP.NET 2.0 using C#
• Utilized WCF to invoke stored procedures.
• Created stored procedures utilizing SQL Server 2000
• Utilized DTS to transfer data from Excel spreadsheets to SQL Server tables
• Perforce Version Control was used for Version Control

Confidential, Woodland Hills, CA

Programmer / Analyst

Responsibilities:

• Developed, Supported, Maintained, and Documented CLM Central EMR System (Electronic Medical Records) in ASP.NET 2.0 utilized both C# and VB.NET
• Utilized C# Classes for both Business Logic Layer &Data Access Layer
• Utilized VB.NET for Presentation Layer
• SQL Server 2000 was used in teh back-end
• Visual Source Safe was used for Version Conrtrol

Confidential

Developer - Contractor

Responsibilities:

• Developed, Supported, and Maintained various external & internal applications utilizing ASP.NET
• Migrated a number of existing PowerBuilder applications from version 8 to version 10 as well as fixed various bugs and maintained these applications.
• Both PVCS & Visual Source Safe are used for version control
• Utilizing Ingres via Unix as well as SQL Server

Confidential, Sacramento, CA

Developer - Contractor

Responsibilities:

• Moved existing PowerBuilder 9.0 applications from both Visual Source Safe & Clear Case version controls to CAST Server to be analyzed
• Utilized Analysis Manager to run teh PL/SQL, ASP.NET, PowerBuilder jobs, Metrics & System View jobs
• Analyzed teh log files after each of teh above jobshad been ranby checking for errors & inconsistencies
• Created a snapshot using DSSADMIN & launched APM to view teh various statistics such as metrics, maintenance costs etc….

Confidential, Encino, CA

Consultant

Responsibilities:

• Implemented an Invoice System to display various services provided to clients.
• Modified teh Financial Report System that was originally displayed in Acrobat to allow teh users to manipulate teh data by using various filters etc....
• Both systems retrieved their data from SQL Server 2000 and utilized various datawindows created in PowerBuilder 8.0 which allowed teh users to make or modify existing financial data..
• Once teh systems were in place, continued support according to user needs by fixing bugs & making additional enhancements as required.

Confidential

Consultant

Responsibilities:

• Supported teh IOPEO System for teh Retirement Services Division utilizing PowerBuilder 6.5 and SQL Server 2000.
• Developed Multi-RowSelection functionality from teh original Single-Row Selection functionality to enable users to allocate multiple fixed holding allocation funds from teh original contract to many other affiliates or subsidiaries( sub ids) for teh given contract.
• Fixed bugs in PowerBuilder 6.5 & modified stored procedures in SQL Server 2000
• Utlized Visual Source Safe for version control
• Utilized CAST to debug stored procedures as required

Confidential

Consultant

Responsibilities:

• Supported internal inventory tracking system utilizing PowerBuilder 6.5 and SQL Server 2000 to track client info such as system hardware configuration service dates,, billable rates, etc..
• Migrated Inhouse application from PowerBuilder 6.5 to PowerBuilder 8
• Incorporated PowerBuilder Foundation Class Libraries (PFC) in teh application for code reusability and object orientation

Confidential, CA

Programmer/Analyst

Responsibilities:

• Supported teh Intellectual Property System“Rights System” for three entertainment lawfirms as well as onsite users such as recreation groups, consumer products etc… comprising between users.
• Utilized PowerBuilder 6.5 & 7.0 to create Production Builds and installations using FTP and batch files to download remotely.
• PowerBuilder Foundation Class Libraries (PFC) was used throughout teh application ensuring a stable object oriented application by turning on/off teh necessary services as required.
• Used Object Cycle to check in/out objects such as various scripts for version control
• Fixed bugs in PowerBuilder and modified stored procedure,triggers in Sybase 11.5
• Created enhancements as required by users
• Created additional enhancements in Visual Basic 6 utilizing various VB controls such as ADO, Data Grid, Common Dialog Control etc…
• Assisted Project Lead in modifying & restructuring database by ensuring referential integrity
• Designed & Documented Functional & Technical Specs based on User Requirements

Confidential

Programmer/Analyst

Responsibilities:

• Supported various Insurance applications such as Property, Casualty, & Construction
• Responsible for maintaining Property System by adding, changing, endorsing, inquiring, and producing various reports related to submissions,policies,and endorsements.
• Adjusted calculations relating to Layers and Aggregate Reports associated wif various zones such as Earthquakes,Wind, and Floods.
• Ensured calculated fields for Premium Allocation,Resinsurance,and Spot Fac were in sinc
• Tested all fixes by duplicating errors prior to moving to Production for eg. Adding a test Policy ID, endorsing teh policy,and booking teh policy
• Fixed bugs in PowerBuilder 6.5 & modified stored procedures in SQL Server 6.5 using CAST, ISQL
• Moved pbds & exe to production by logging remotely to various districts in teh U.S comprising of over 100 users using teh application nationwide.
• Assisted users in articulating their requirements and developed accordingly

Confidential, Boston, MA

Programmer/Analyst

Responsibilities:

• Assisted Business Analyst and Project Lead in Defining, Designing, Developing, and Deploying Deal Process System using Erwin & SQL Server to assist in Data Modeling
• Utilized PowerBuilder 5.0 & 6.5 to modify code on existing systems according to user needs for production
• Updated and modified stored procedures in Sybase11.5 & SQL Server6.5