Asp.net Developer
Resume:
Sujatha Gona
********@*****.***
SUMMARY
Microsoft Certified web programmer with six years of commercial IT experience including extensive analysis, design, development, debugging, testing and maintenance of complex component based (Object Oriented) software applications. My background includes Web Enabling and Client Server environments utilizing .NET Framework, ASP.NET, ASP, XML, WCF, IIS, VBScript and MS SQL Server 2000/2005.
TECHNICAL SKILLS
Languages/Development Tools C#, ASP.NET, VB.NET, Active Server Pages (ASP), Visual Basic 6.0, HTML/DHTML, VBScript, Ajax, JAVA Script
Enterprise Solutions Web Services
Architecture .NET Framework 2.0/3.0/3.5
Infrastructure Windows 2003/2000/XP/NT, UNIX, Internet Information Server (IIS)
Databases MS SQL Server 2000/2005, Oracle 8.0, Stored Procedures, DTS, T-SQL, PL/SQL, MS Access97/2000
EDUCATION/CERTIFICATIONS
NAGARJUNA University, India
Masters in Computer Science
NIIT, India
Post Graduate Diploma in Computer Management and Analysis
MICROSOFT
070-315 - Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
EXPERIENCE
Hawkeye Insurance Services Inc., Dallas, TX Nov ’07 to May '09
ASP.NET Developer/Systems Analyst
DC2 Intranet portal: The responsibilities of the project includes to automate the activities of HI and to ignore all manual processing. The analysis of the project includes discussion of all services provided by the company and the new features that the company is planning to provide to its customers. The finance department calculates the claim amount, expiration date etc. Customer service department adds the new
claim, update or delete existing claim, pass the required data to the finance department. Users are able to view the details of their claims and notifications. Agents were able to view their policy information.
Role & Responsibilities:
Participating in requirement analysis and design phase
Quickly understand the business logic and complete development of several ASP.NET web pages like Time Report Management, Agent and Agency lookup and Claims management etc., for the companies intranet system.
Extensively using debugging methodology and exception handling techniques
Created several SSIS/DTS packages to automate data transfer from text files to database and database to text files.
Developed the classes daily production, monthly production and Total so far this month etc., and developed classes to present data as XML and text.
Environment: ASP .Net 2.0, VB.NET, C#, Ajax, SQL Server 2000/2005, MY SQL 5.0 and Visual Studio 2005
AT&T, Dallas, TX Jan ‘06 to Oct ‘07
ASP.NET Developer /Systems Analyst
ONE SOURCE PORTAL: This intranet site is to collect all internal billing tools, data analysis, reports and other information for the billing operations department. This site houses internal billing tools like Billing Inquiry, Billing Escalations, Bill Audit Tool (BAT), Unbillables, and Project Management. This tool provides opportunity for managers to keep track of the analysts work and train/assist the analyst if necessary.
Bill Round Sync:
Approximately 14% of the DSL/Dial Internet shared billed customers occasionally miss their bill round one month and then receive two charges the following month. This is because of the Bill Round difference between AT&T and the Billing Company Telco. The project is a solution to minimize the occurrence of Internet services missed bill rounds.
Role & Responsibilities:
Analyzed and designed the workflow of the business process using Unified Modeling Language and Microsoft Visio.
Developed stored procedures, SQL Queries, Views to adjust the AT&T bill round according to Telco Bill Round.
Developed the ASP.NET Web pages to monitor Bill Round Sync process like how many Bill Rounds got fixed, % of the fixed count so far etc.
Validated fields using validation controls.
Configured web.config file for debugging and form authentication and authorization purposes.
Developed Bill Validation classes for retrieving the data from databases and presenting the data as
XML.
Special Billing: Cable Switch Credit Processing:
Customers that qualify can receive credits on their phone bill for DSL/Dial-Up Internet or Video service for changing their service from Cable to AT&T/Dish. These credits are calculated based on what the service provider (AT&T/DISH) charges them for Internet/Video service. This credit must appear on the customer’s
bill every month and should be identified on the bill as Cable Switch credit.
Role & Responsibilities:
Created the process to Cable Switch accounts that have been identified by Special billing team.
Automated the process to get the historic data for Cable Switch customers as Cable Switch Credit has given after three months of service in SQL Server 2000.
Created DTS process to upload the Cable Switch supplemental file to SSH folder, which helps Bill Ops team to process the Cable Switch credits.
Developed the ASP.NET Web pages to monitor Switch supplemental file process of Bill Ops like what is the last file that was created, what is the latest file Bill Ops processed etc..
Credit Card Reconciliation:
AT&T sends list of the customers who paid their bill using credit card to the Credit Card Company and Credit Card company sends the confirmation file back to AT&T. This projects handle the reconciliation between this two files. Technically there are 6 different sets of files based on provider and promotions.
Role & Responsibilities:
Created the process to receive files from EMAS and Credit Card Company like chase for the reconciliation.
Automated the process to load the data in to SQL Server 2000 database using DTS.
Developed the ASP.NET Web pages to monitor credit card file process like what is the last file that was received, what is the latest file recon date etc..
Designed and Developed UI and Administrative Interface.
Developed XML Web Services using ASP.NET.
Environment: C#, ASP .Net, VB.NET, SQL Server 2000, Windows XP Pro, UML, MS Visio and Visual Studio 2003.
SBC Internet Services, Dallas, TX Apr ‘05 to Dec ‘05
Systems Analyst
The main goal of the Order Management Database is to effectively manage orders that have not flowed into the main order management tool before Due Date. The SBC DSL Provisioning Database is created by using the SQL Server 2000. The Front end was developed by using ASP. This web tool allows the Order Management Coordinators to support the role defined and to distribute, track the daily orders received into Order Management Group.
Role
Created the front end to assign specific work to Order Management Coordinators of different teams like Errors, Escalation, Validation
Web Pages were created to reassign the unfinished work to Order Management Coordinators
User friendly interface was created to track the work of Order Management Coordinators
Ms Access Database was created to send the reports to Sales Channel
Reports to Management includes Current Inventory(Total Orders), Total Work Assigned Critical Due Date Tracking, Service Readiness Report
Environment: ASP, SQL Server 2000, MS Access 2003
Satyam Computer Services Ltd, India Apr ’04 to Mar ‘05
Programmer
Vigilance Alert System:
This highly automated online system supplemented the existing vigilance alert processes. This system facilitated online access to users with designated officers in the Directorate of Vigilance, who in turn had online access with field officers of Customs and Excise. Feedback, complaint and suggestions could then be sent through web
Participating in requirement analysis and design phase
Designing web pages using both Client side and Server side Scripting
Developing the application in ASP with VBScript
Inserting and retrieving data using ADO.
Environment: ASP, Visual Basic 6.0, SQL Server 7.0
NIIT Pvt. Ltd, India Aug ’03 to Mar ‘04
Programmer
Student tracking and Fee Collection System
Requirement: The project required the existing paper-based system to be fully computerized to track the details of existing and new enrolled students.
Role & Responsibilities:
This system was developed for tracking Student Fee Collection, manage and maintain payment schemes for students.
Used DAO to communicate between database and windows forms.
Front-end design and development, custom designed ActiveX controls to enhance the capability of front-end screens.
Designed and Developed monthly reports for active payment plans, academic discounts tracking, active fee schedule, courses offered and Student progress etc.
Environment: Visual Basic 6.0, SQL Server 7.0, MS Access
Contact this candidate