AddThis Social Bookmark Button
Anupama Jasti
TX - 75038 USA
Expertise :SQL server
Status :
Job Type :
All - W2,1099
Position :

Resume
 

Objective
Sr Programmer Analyst


SUMMARY :
Offers more than 8 years of strong professional software development experience using Microsoft Technologies in the fields of web and client server applications.
Involved in various phases of Software Development Life Cycle ie Analysis, Design, Implementation, Testing and User Training.

Strong interpersonal, written and oral communication skills and client relations experience.

Manages, coordinates and facilitates multiple projects in the software development and System Integration in organization.

Extensive experience in Web Based Applications, Client Server Architecture, Object Oriented Programming and Relational Databases
Expertise in ASP 2.0/3.0 ASP. NET, C#, Visual Basic 6.0/ 5.0/ 4.0 COM/ DCOM Technologies

Offering Solid Experience in MS NET Framework.
Worked extensively with scripting technologies like VBScript, JavaScript, DHTML/ HTML, XML, XSL, XSLT.
Database implementation in SQL Server 6.5/7/2000 Oracle 7. x/8i and used DAO/ ADO data Access technologies for accessing the Database.

Worked extensively in writing Stored Procedures, Functions, jobs, DTS packages, SQL Scripts other database related activities.

Experience in MS SQL Server installation, configuration, performance tuning, client, server connectivity, query optimization, back up, recovery, running Database Consistency Checks using DBCC.
Expert level knowledge in Visual Studio .NET, Visual InterDev 6.0.
Knowledge in Object oriented design and Programming.

Excellent work ethics, self motivated quick learner, team player and team oriented.

provide value added services to client through thoughtful experience, productive coding habits and excellent logical aptitude and communication skills.

TECHNICAL SKILLS : GUI : VISUAL BASIC 6.0 or 5.0 or 4.0 VS .NET
RDBMS : ORACLE 8I/7 .X, MS SQL SERVER 2000/7.0/6.5
MS ACCESS
SCRIPTING LANGUAGES : VB SCRIPT, JAVA SCRIPT, DHTML
WEB TECHNOLOGY : ASP.NET, MS NET, XML, XSL, HTML, MS SITE SERVER, VISUAL INTERDEV, AND MS COMMERCE SERVER
LANGUAGES : C#, VB. NET, C/C++, PL/ SQL, JAVA

OTHER TECHNOLOGY : ACTIVE X, COM +
OPERATING SYSTEMS : WIN 2K, WIN NT 4.0 WIN95 UNIX, AND MS-DOS
CONFIGURATION MANAGEMENT : VISUAL SOURCE SAFE, STAR TEAM
PROJECT MANGEMENT : MS EXCEL, MS WORD, MS OFFICE, VISIO

PROFESSIONAL EXPERIENCE :
Self Service and Analytics - Irving, TX. 11/01 - tilldate
Senior Programmer Analyst.

Projects : 1. eDesk 2. Decision Support System 3. Verizon.Com Ordering

Edesk is a Comprehensive Reporting tool provides abstract, analytic information for www.verizon.com based on Click Stream and Transactional data.

Created and maintained Stored Procedures, Functions, Jobs, DTS packages, SQL Scripts other database related activities.
Created ETL Scripts to provide the data for Various Reports related to www.verizon.com.
Worked extensively in understanding client requirements and change them into various value added and meaningful Reports.
Created Cube Reports using MS Analysis Services which provides multi dimensional view of data.
Nordic Tool Data loading and transforming data into Reports.

Worked on ongoing development activities in Development, System Test, UAT and Production environments.

Maintained daily activities related to Database, Fine tuning existing Stored Procedures and functions.
Provided value added Adhoc Reports and Complete, Comprehensive Analysis for each of them to the Clients.
Created Parsers to retrieve Data information from Text files, SQL Tables, Excel and load them into Database.
Worked extensively on DM, AG Model for the applications Ordering, Registration, Billing which are key elements in www.verizon.com.

ASP. NET, C#, ADO. NET,. NET FRAMEWORK, WEB SERVICES, SOAP, WSDL, SQL SERVER 2000 XML, XSLT, JAVASCRIPT, WIN 2K SERVER, VSS AND MS EXCEL.

2. Decision Support System

Verizon DSS is a business intelligence tool that helps achieve the goal by focusing on information needs and ensuring that one can make confident, precise decisions based on the complete knowledge of customers' actual behavior, online, offline, web based or client server. DSS Analysis Engine goes beyond standard reporting by offering true interactive analysis. Features drill down, drill through, detailed visitor path analysis and broad access allow all of the key people in the organization to pose questions on-the-fly, revealing important relationships in the data and how those trends change over time.
Implementing front end in ASP.NET with C# code behind for the Administrator Console Reports, User Registration for the intranet website.
Developed XML schemas for different applications Ordering, Repair, Registration and Billing and loaded them into database.
Developed DBWrapper Classes to render the data from database.
Developed Web Services using .NET Framework for the Add package application to show the Error Message Count.
Created and Involved on various Customized adhoc reports which greatly and help higher managers in Decision making for various projects.
Suggested and implemented initiatives to enhance the Order numbers for applications like AddLine by using the statistics based on Metrics and Click Stream Analysis.
Involved in the process of analyzing the decision metrics for different applications like Ordering, Billing, Repair and Registration which are key elements on Verizon.com.

Created and maintained Stored Procedures, Functions, jobs, DTS packages, SQL Scripts other database related activities.
Created ETL Scripts to provide the data for Various Reports.

ASP. NET, C#, XML, XSLT, ADO. NET,. NET FRAMEWORK, WEB SERVICES, SOAP, WSDL, SQL SERVER 2000HTML 4.0 CSS, JAVASCRIPT, XML SPY, IIS5.0 WIN 2K SERVER, AND MS EXCEL.

General business Ordering website is the place where customers can order the phone connection
Online. To order a new phone connection customer has to register with the VZ.com website. This Mini Registration process is eliminated for the New Connect users.

Created Various Web Pages using HTML/ ASP/ VBScript, JavaScript.
Developed XML schemas and XSL validations for the ordering using
XMLSPY, Ultra Edit.
Performed Client Side validations using JavaScript, VBScript.
Business Logic is implemented using the VB COM Component.
used Commerce Server for the data persistence.
Configured and deployed the commerce server site in system test and user acceptance test servers.

All the profiles and the catalogs used by the website are stored for caching using Commerce Server 2000.

ASP 3.0 VB SCRIPT, JAVA SCRIPT, MS-SQL SERVER 2000 VSS, HTML/ XML, XSL, DHTML, IIS 5.0 VB 6.0 WIN 2K ADVANCED SERVER, COMMERCE SERVER 2000 COM+

4. Verizon.com Bill view

The module Bill View is to view the telephone bill online which is developed using ASP, XML, COM+ and SQLServer 2K using which customers can manage to view the phone bill without any paper bill. This Billview for Small Business having customers in different regions based on which identified by 3 interfaces Express, North and South. Customers can select the billing telephone numbers and they is navigated to view there past billing cycles from which they can select the cycles and view their bills online. The Information about the billing cycles is coming in XML format and in ASP pages that is parsed accordingly. A service is run everyday which will pump the new cycles to the interface.

Developed the whole front end framework using Visual Interdev.
Developed XML schemas for the bill using XMLSPY, UltraEdit.
Implemented core component in VB6.0 which handles business logic.
Created Various ASP Client Pages to test the COM + components.
Performed Client Side validations using JavaScript, VBScript.
Created XML, XSL Stylesheets and DHTML to parse the XML Bills.
Used Visual Basic 6.0 client to test the middle tier Components.
Implemented XML helper classes and applies XSL depending on region.

ASP 3.0 VB SCRIPT, JAVA SCRIPT, MS-SQL SERVER 2000 VSS, HTML/ XML, XSL, DHTML, IIS 5.0 VB 6.0 WINDOWS 2000 ADVANCED SERVER, COM+


Employment

2000 -  2001
Analyst

INTEL Corp Seattle , WA Programmer Analyst Integrated Services Platform Group Projects : 1. SportsBroadcasting 2. MockupToolManager .

SportsBroadcasting is an E-commerce site to Purchase the favorite Basketball teams Video clips. From this site customers can watch clip of the day using Real Media player or Windows Media Player and they can purchase the events based on Team, Player and Events. This store site includes the functionality of Sign in, Billing, Shipping, Review Order and Payment, Receipt the 5 - step process and the basket includes the items to their Baskets. The entire store is divided into Soft goods and hard goods. Customers can check the order status based on their order tracking number and there is a provision for Returns only for hard goods. Customer has to register themselves with Username and password before they can buy the events from the store. The text Search is provided for the Customers where they can search by entering keyword. The Calendar in the site holds the events that are purchased by the customer which retrieves records from Database. The Events are categorized as Subscriptions, Packages, Schedules and Equipment. Ad services Provides the Banner Advertisements to the System.

Involved in Analysis and Design and coding for User COM + component which implements the Login, Logout, Create New password, Change Password and other functionalitys
Created proto type in Visual Basic 6.0/ COM +
Coded the Data Access layer of the component which uses ADO objects
Coded generic function to create Parameters on the fly and execute stored procedures.
Created ASP Client Pages using HTML/ ASP/ VBScript to test the COM + component
Performed Client Side validations using JavaScript.
Defined the standards for coding COM components in Visual Basic 6.0.
Used XML Code Generator to generate Visual Basic Classes from XML Schema
Coding of XML documents.
Designed web pages using Visual InterDev and website is developed using MS Siteserver

Mockup Tool Manager

This Mockup tool provides the Managers, Artists with in the Organization to create Storyboards where they can walk through the Story of a project along with their customers. Using this tool Users can Work on Images, Projects and Administering the Users. Manager can create a project with the images and he can edit, view and delete the images of a project. The System provides main features Display tool, Manager Tool and Admintool. Using Admintool, Manager can give access to projects by adding Username and password to the System. File Transfer Protocol used to transfer the files to the server.
Developed the whole System from Design, Coding to Implementation.
Developed web pages using HTML4.0 ASP 2.0 JavaScript and VBScript for providing web Interface to the users.
Developed stored procedures to Update, Delete and Insert Records from the Database.
Developed Active server pages using VISUAL INTERDEV 6.0
Used JavaScript, VBscript for validations


2000 -  2000
Analyst

ENVIRONMENT : ASP 3.0 VISUAL INTERDEV6.0 VB SCRIPT JAVA SCRIPT VB 6.0 MS-SQL SERVER 2000 STORED PROCEDURES STAR TEAM HTML/ XML XSL IIS 5.0 WINDOWS 2000 ADVANCED SERVER , MS SITE SERVER 3.0 COM+ MICROSOFT CORP , WA Programmer Analyst CAD Project . INTEL Corp Seattle , WA Programmer Analyst Integrated Services Platform Group Projects : 1. SportsBroadcasting 2. MockupToolManager .

The CAD Project is to focus on providing the functionality to Finance College Web Site to include a Personal Development Plan, Assessment Analysis, Gap Analysis and Manager Toolkit features. The Website gives an opportunity to the employees of Microsoft to view the Development Opportunities with in the Organization so that they can select best out of it and they can assess themselves for their improvement in all aspects. Managers can view the assessment of their employees and Gap Analysis provides the Gap between employee Skill level and Proficiency level.
Defined Interfaces in Visual Basic 6.0.
Created proto type in Visual Basic 6.0/ COM.
Tuned various SQL statements for performance enhancements.
Developed stored procedures to Update Delete and Insert Records from the Database.
Performed Client Side validations using JavaScript.
Coded the Visual Basic Client application to test the components.
Created ASP Client Pages using HTML/ ASP/ VB Script/ Visual Interdev to test the components.


2000 -  2000
Developer

ENVIRONMENT : ASP 3.0 VB 6.0 VISUAL INTERDEV6.0 VB SCRIPT JAVA SCRIPT MS-SQL SERVER 7.0 COM STORED PROCEDURES IIS 4.0 VISUAL SOURCE SAFE AND WINDOWS NT 4.0 New York www.ActBig.com . Developer INTEL Corp Seattle , WA Programmer Analyst Integrated Services Platform Group Projects : 1. SportsBroadcasting 2. MockupToolManager .

Act Big is a central, web based market place where buyers and sellers can initiate, participate in and interact around a wide range of group purchases. Act Big consists of 3 main zones : BIG deals, BIG ideas and BIG talk. In BIG deals, we can search or browse ongoing group purchases which we call shopping blocs. In BIG ideas we can organize group purchases with unprecedented ease using building blocs. In BIG talk, we is able to participate in sounding blocs, discussion groups where you can exchange tips, information and ideas with other buyers and sellers. It is a unique website where user is paid commission if he is the intermediate between buyer and seller.

Created ASP Client Pages using HTML/ ASP/ VB Script/ Visual Interdev to test the components.
Performed Client Side validations using JavaScript.
Developed procedures, functions and packages in PL/SQL
Used the IIS Administrator 1.0 Type Library to automate the IIS part of configuration on the web servers
Used the MTS 2.0 Administrator Type Library to automate the MTS part of configuration on the web servers
Worked with QA department on executing Functional Verification Scripts
Coded the FormsLogin. asp to enable the SSL using the HTTP and the HTTPS protocols.


1999 -  1999
MTS Administrator

ENVIRONMENT : VISUAL BASIC 6.0 COM ASP2.0 VB SCRIPT JAVA SCRIPT HTML ORACLE 8.I, PL/ SQL CRYSTAL REPORTS IIS Administrator MTS Administrator AND VISUAL INTERDEV CS Software Hyderabad . Programmer Daspalla

Daspalla Hotel has 6 venues for the Banquet. A person can approach the Banquet as an individual or a corporate body. His approach is to book a space for an event, A Birthday party, a reception or a kitty party. The person can represent a corporate body which is interested in booking the space for the seminars, annual general meetings or any event. The criteria are how many people are expected. Depending on the space available on the day of the event and timeslot required, the venue is booked and then the menu for food is selected. The menu selection is package type or custom type. When the user selects the items from the available categories and the prices are added depending on the number of people attending the event.

Extensive usage of Vbscript for development of the Website
Created triggers and procedures using PL/ SQL
Performance tuning of various SQL statements

Created Registration form for personal details using JavaScript, HTML and ASP
Developed Booking Information to select the category types
Maintained the database using Oracle as backend.
Involved in debugging the scripts written by team members.


1998 -  1999
Programmer

ENVIRONMENT : ASP 2.0 VB SCRIPT JAVASCRIPT HTML DHTML ORACLE 7.3 PL/SQL STORED PROCEDURES TRIGGERS FUNCTIONS . A and T InfoTech Hyderabad . Programmer Data Conferencing in JAVA

The Data Conferencing System provides data exchange facility to the users of the network.
The system includes the features Registration, Logging On and Chatting in common room and Private room. The user interface is stored in the server in the form of a Java applet.
The clients through the web browser access the applet. A web Server serves the applet. A relational database is used for maintaining the users and password information required for administration.

New User Registration : A hyperlink would be available in the home page through which a user can access the registration Page. The user fills up the login name and password and submits it by pressing Submit button and user gets logged in automatically.
Log in : This feature would be available in the home page to enter in into the Common Room. The users would be given a login name and a password for authentication.
Common Room : After the user logs in, a common room is displayed for him for data conferencing, along with the messages user name is displayed. So 1 can identify that which message is coming from which user.
Private Room : If user wanted to talk to someone privately then he will have option to change room from common to private.
Created User Interface Using AWT.
Developed Login Room and Password Authentication using applets.
Maintained the database using Oracle as Backend.


1997 -  1998
Programmer

ENVIRONMENT : JDK 1.1.5 AWT APPLETS SERVLETS AND ORACLE7.3 . VT Industries Hyderabad Programmer Machine Maintenance System




Education

MS in Applied Mathematics



Miscellaneous
With the help of this project we can know the status of any machine with the machine name or due date of the servicing date.
First all the machine records is updated in a table with machine name, machine parts, when the machine is serviced last time and due date.
Based upon the due date every day preventive maintenance schedule reports is generated.
With the help of preventive maintenance reports maintenance department will service the machines and after servicing is over due date and remarks of the machine is updated.
Created User Interface using Visual Basic 5.0.
Maintained the Database using MS Access as Backend.
Designing and coding on all modules
Reports generated using Crystal Reports
Customer Master Module : Add, Modify, View and Delete Customer details any time. The user is not able to delete the Customer from the Database if there are any invoices against him in the Current Financial year.
Sales Tax Module : Percentage of Sales tax is changed any time easily. So any change in sales tax is implemented very easily.

ENVIRONMENT : VISUAL BASIC
5.0 CRYSTAL REPORTS, ACCESS, AND WINDOWS NT

Microsoft Certified in Visual Basic 5.0
Microsoft Certified in implementing Database Design using SQLServer 6.5




Quick People Search



People like Anupama

Popular skills