Sql Server Customer Service Business .Net Project
Resume:
*** ******* ***** 215-***-****
Lansdale, PA ***** ********@***.***
OBJECTIVE:
A position in CIS where my experience in computer programming and system analysis will allow me to provide knowledgeable support.
QUALIFICATIONS SUMMARY:
Graduated with GPA of 3.74 from Villanova University, PA (MS in Computer Science)
Extensive work experience of 9+ years in programming, system analysis and design
Experience in using XML for data interchange between enterprise application
Experience in C#, VB.net, ASP, Visual Basic, ADO.net, SQL Server 2008 R2, SQL Server 2005, SQL
Server 2000, Visual Studio 2010, Visual Studio 2008, Visual Studio 2005, Visual Studio 2003, Oracle
9i, XML, XSL, ASP. Net, eFLOW.
Experience in writing technical documents in IEEE standard, Crystal report
Strong analytical and communication skill; Active team player
US citizen
Passed Security Clearance for USCIS project.
Certified Scrum Master.
SKILLS:
Programming Languages & Technology: C#, C++, Java, Visual Basic 6, VB.net, OQL, HTML, ASP 3.0, ASP.NET, VB- script, JAVA script, XML, XSL, TSQL, SQL, PL/SQL, SQL *Plus (Ver 3), Ajax, Flash(4.5), jQuery,ADO.net, MVC, Web Services, Source control SVN, Windows Service, Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Business Intelligence, EFlow.
RDBMS: Oracle 7.0, 8.xx, 9i, SQL Server 2000, SQL Server 2005, SQL Server 2008 R2.
Certification: Scrum Master (Penn State University, Aug’ 2009).
WORK EXPERIENCE:
Programmer/Analyst March 2009-Till Date
LEAF Financial Corporation, Philadelphia, PA
Developed single sign-on Portal using Visual Studio 2008, C#, SQL Server 2005.
Developed Dealer Portal & CPU(Cost per copy) interface, web-based Reports using MVC, jQuery, Visual Studio 2010, SQL Server 2008 R2.
Developed web sites for Marketing using VS 2010, SQL Server 2008 R2.
Developed several import utilities using SSIS.
Developed “Pay By Phone” application for the customer service associates using VS 2010, SQL Server 2008 R2 and SSIS.
Developed and maintaining several websites using Visual Studio 2008, C#, SQL Server 2008.
Developed web-based online Payment System using Visual Studio 2008, C#.
Converted Web based forms into pdf forms.
Developed Windows Application for in-house use.
Developed multiple export/import utility using SSIS.
Created several WebServices for Portals.
Converted Java web-based Application to .Net.
SHARMILA GUPTA
Technologies used: Visual Studio 2008, Visual Studio 2010, C#, SQL Server 2005, SQL Server 2008, JavaScript, XML, WebServices, iTextSharp, Stored Procedure, SSIS,LINQ,ADO.net, Ajax, Flash(4.5), jQuery.
Consultant Programmer/Analyst April. 2008 –Mar 2009
J & B Software, Blue Bell, PA
Customization of eFLOW (image recognition software) for USCIS immigration forms (N400, N600 etc.).
Created several interfaces for eFLOW to facilitate information processing within different eFLOW stations. This was implemented using C# in Visual Studio 2005, which includes writing Stored Procedure to capture and process eFLOW data and update database.
OCR fine tuning
Developed and customized new and existing web pages to facilitate agents to review and report financial targets.
Developed Web Security interface using ASP .Net Visual Studio 2008 security feature.
Used LINQ query language to process data.
Programmer/Analyst Sep. 2005– Apr. 2008
Astea International Inc., Horsham, PA
Developed several interfaces to Astea's standard application using various .NET technologies to provide integration with client's legacy applications and processes:
Created an interface for Order Penalty Calculation using WebServices that communicate with legacy application's WebServices asynchronously. Provided a mechanism to retry and recover from failed transactions between two systems using staging tables. The WebService was implemented using C# in Visual Studio 2005, which includes writing Stored Procedure to process XML file and update database.
Developed a Windows Services named Dispatcher that monitors certain data transactions at regular interval and takes appropriate action using WebService that allows updating equipment statuses on-demand. The Windows Services was implemented using C# in Visual Studio 2005 and ADO.NET.
Implemented a WebService that allows updating equipment statuses on-demand. The WebServices was implemented using C# in Visual Studio 2005, ADO.net.
Developed processes using SQL Server 2005 SSIS to provide nightly extracts of data from Astea's database and update client’s Database. These processes were created using SSIS, SQL Agent, SQL Job Scheduler and a Business Intelligence project that includes SSIS package development, configuration, deployment and import package.
Extraordinary Client appraisal resulting in a major Service agreement
Remarkable achievement in reviving a dead project of a reputed client and exceeding Company’s expectations by turning it from a disgruntle to a highly satisfied client. The project’s success lead to a bigger customer reference with the client and served as a model for other teams inside the company.
Interfaced directly with client technical resources and provided prompt resolution to their issues.
Worked in Professional Services Organization for customizing and maintaining Astea's CRM solution AllianceEnterprise/AsteaAlliance for service-centric companies.
Analyzed, designed and developed application modules for Astea Alliance service management suite that integrates and optimizes critical business processes for Field Service, Logistics and Inventory.
Interacted with the clients in the pre-implementation phase to understand the business scenarios of the requirements. Helped customers install the customized software
Sole resource for supporting Business Objects reports and Paging module of Astea’s CRM suite
SHARMILA GUPTA
Involved in customizing the standard software according to the requirements by extending/modifying client-side, business logic and backend systems
Provided support for in-house Resource and Project management application.
Instrumental in process improvement by reducing the turn-around time and enhancing quality of customer deliverables significantly.
One of the two programmers working on to develop Business Object reports and RPA mobile application.
Development involved VB, VB.Net, ASP, C#, XML, XSL, JavaScript, VBScript, Business Objects, MS SQL, Oracle
Programmer/Analyst March 2004– March 2005
Strativa Marketing Inc., Malvern, PA
Development of Sales Database Project:
Following responsibilities are applied
System analysis and design.
Complete database development using SQL Server 2000
Wrote Stored Procedures using T-SQL
Created data objects using C#
Created user interface using ASP.NET, generated reports using Crystal Report.
Troubleshoot and debugged the existing Intranet, file management system, forecasting tool that involved coding in ASP.net with C# using Visual Studio 2003, and modification of Database using SQL Server 2000.
Network Support Intern Feb 2004– March 2004
Upper Merion Township, Upper Merion, PA
Troubleshoot network connections, network devices
Set up network resources and drivers.
Programmer/Analyst June. 2003 – Jan. 2004
Mechanics, Calcutta, India
Studied and analyzed system and distribution module of the company. Prepared Customer Requirement Specifications (CRS) for the following modules:
§ Inventory Module
Multi-location, multi-bins design parts order forecasting, lot and Serial no. management
• ABC analysis, stock status, min/max reports
• Stores and WIP physical inventory
§ Purchase Order Processing
• Blanket order processing
• Interface to A/c payable and general ledger
Programmed in TSQL, PL/SQL, XML, ASP.NET with C#, ASP, VB Script, Java script.
Worked with Oracle 9i, SQL Server 2000, Microsoft Visual Studio.
IMS Student Technical Assistant Oct. 2002 – Feb. 2003
Villanova University, Villanova, PA
SHARMILA GUPTA
Provided support for media equipment installation and handled preventive equipment maintenance.
Programmer/Analyst July 1996 – Jan. 1998
Hahnemann Laboratories India Ltd. Calcutta, India
Responsible for system analysis and design.
.
Wrote CRS, SRS and PRS in IEEE standards.
Worked with Oracle 7, 8.x. Programmed in SQL and PL/SQL, Visual Basic.
Designed product interface system to integrate inventory and manufacturing components of production.
Involved in developing the Inventory module of Pre-production and testing phase.
EDUCATION:
Villanova University, Villanova, PA
M.S. in Computer Science - 2003
GPA 3.74.
Contact this candidate