sowsur8

sowsur8

On-lineOffline

SOWMYA SURESH
34200, Ridge Rd., Apt.216, Willoughby, OH-44094
sowsur8@[login to view URL]
Home: 440-943-9242
Cell : 719-231-3148
Note: I have a Green card which allows me to work for any company anywhere in US without Visa sponsorship.
Professional Summary
SQL Server DBA/Software developer with over Six years IT experience, including more than 2 years as a developer developing Visual Basic 6.0/VC++ 6.0 applications. Proficient in SQL Server 7.0/2000 Oracle 8.i, Visual Basic and C++ .Possess strong communication and problem solving skills developed through a variety of projects. Offer proven abilities in team leadership and proactive systems support.
Experience Summary
1 Six years of IT industry experience in designing and developing end-to-end solutions.
2 Designed and developed medium-to large-scale client-server/distributed software and desktop solutions using wide variety of technologies: Visual Basic, SQL Server 2000, Oracle, C++ and Visual C++ on Windows NT/95/98/2000/XP
3 Extensive experience as SQL Server/Oracle DBA. Experience in design development, testing, debugging and quality assurance strategies in accordance with the software development methodology. Experienced in design and architecture of n-tier systems..
4 Self-motivated, creative team player with effective communication and leadership qualities.
Area of specialization
Application Development
Database Administrator/development
Technical Support
TECHNICAL SKILLS
Databases: MS SQL Server(6.5,7.0,2000), Oracle(7.0-8i), SQL*Plus, PL/SQL
Languages: SQL Programming, Visual Basic 6.0, MS Office, C++,
VisualC++6.0,HTML,ASP,XML,UML,Developer2000, Forms, Reports
Operating Systems: Windows NT, Windows2000, Windows 95-98, UNIX(SUN Solaris 2.6)
Tools: Remedy, TOAD, SQL Navigator, Clear case, ETL
Miscellaneous: Windows API, Stored Procedures, Triggers, VB Scripts, FTP Scripts, ODBC(ADO & DAO), Active X, COM, disaster recovery, DTS, web publishing, data warehousing , T-SQL
PROJECT DETAILS
MCI WorldCom Jan 2001- Aug 2003
Database Administrator/Application Developer
Responsible for Design, Programming and Management of SQL Servers/databases. Managed an integrated system of over 20 Microsoft SQL Servers. This production SQL server system supports the databases for customer service/telemarketing applications for MCI. Identified and resolved numerous upgrade issues dealing with non-compliant 2000 SQL code in numerous stored procedures and triggers.
Environment: SQL Server 2000, VB Script, Windows 2000, Mainframe Servers, FTP Servers
Responsibilities
• DBA roles, programming, database/application support and data transformation.
• SQL Server installation/upgrade, Administered SQL Server security.
• Daily support of all the databases including monitoring, alerting, and problem resolution.
• Daily support, troubleshooting, performance monitoring, optimization and tuning of server and SQL server environments across entire system.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, space capacity planning and indexing updates.
• Optimization and automation of data loading procedures for sales, pricing, and catalog ,implementation of test and staging servers, and creation of policies to guide use of same.
• Transact-SQL Programming and Optimizing Transact-SQL stored procedures and query performance. Executed data transfers and loads using DTS and BCP utility.
• Creating and managing new database objects: tables, indexes, triggers and stored procedures, views.
• Writing SQL stored procedures to enforce business logic on the server side.
• Database administration, including: Database setup, backups and restore, data loads, table/index creation, SQL security, Setting up SQL Mail and report generation
• SQL code migration from development to test and production environment.
• Conversion of database objects from Oracle 8i to SQL Server 2000
• FTP data over to customers for reporting purposes, ftp from Mainframe(DB2) to SQL Servers
• Support of the 1000s of SQL Server application users, software installation and configuration under Windows 2000 and Windows NT 4.0 Workstation
Oracle to SQL Server conversion
Responsible for converting Oracle Databases, Stored procedures, triggers, packages, tables, views into SQL Server. The applications utilized by the customer service reps and telemarketing reps required the data residing on the Oracle servers. The Oracle databases were converted over to SQL Server database for easy maintenance.
Environment: SQL Server 2000, Oracle 8i, Windows 2000
Monitoring Applications
Responsible for the design and development of most of the Summit Monitoring Applications. The Summit Monitoring applications provided the monitoring of various Oracle, NT, 2000 and SQL Servers hosting many applications used by Customer Service reps and telemarketing reps who are responsible for generating valuable customers for MCI. These applications would generate an alert and send this alert to Netcon servers, a centralized alerting system which would alert the DBAs or System administrators responsible for the maintenance and performance of servers. This system proved to be very efficient as the critical issues were resolved and hence improve the business.
Environment: Visual Basic 6.0, C++, ADO, SQL Server 2000, Oracle 8i , ActiveX controls, Windows 2000, Windows NT
Responsibilities
• Design and development of monitoring applications for 100 Oracle Servers, database, SQL Servers/databases monitoring whether the server/database is down.
• Design and development of monitoring applications that keeps an eye on the growth of the oracle tablespace and helps to take immediate action before the tablespace grows completely and caused problems in the server
• Design and development of the LoadServer monitoring application that monitors whether the loadserver is up and processing the records at an acceptable rate.
• Design and development of the application that keeps track of the data loaded to the different stagetables , monitors the number of opencursors and notifies in case of errors, monitors the slow posting of records and functionality of the crucial Backend jobs , monitoring Blocks, Scheduled Tasks and SQL modes
Remote Cient/Server application tool
The monitoring applications developed to monitor some of the servers, were down when the servers went down. This remote tool automatically restarted the monitoring applications. The tool was later made an Active X control to incorporate into Netcon system.
Environment: Visual Basic 6.0, C++, ADO, Active X controls, Winsock controls, SQL Server 2000, Oracle 8i , Windows 2000, Windows NT
CANDID SOFTWARE CORPORATION Jan 2000 - Jan 2001
Marketing Activity Tracking System
This system was developed for a major farm vehicles manufacturer. The goal was to track, manage & analyze marketing activities at sales offices for subsequent sales target generation to boost sales. This elaborate GUI-based application relies on VB to provide the front-end and serve as a conduit for information transfer between an Access database and Excel spreadsheets. At the Corporate Office, a VB application accepts “a plan” with activities and various other parameters (deadline, resources etc.), validates that all parameters are within specified limits (pre-entered into a SQL Server database) and stores them in a separate SQL Server database. The VB app. then proceeds to calculate time and quantity targets for dealers based on the input plan. Using OLE, these targets are populated into Excel spreadsheets sent to dealers. The dealers manually update these spreadsheets based on progress made on the specified activities. Updated spreadsheets from all dealers are processed weekly by the VB app. (using OLE) for progress tracking and new target generating
Environment: Win NT, Visual Basic 6.0, SQL Server 2000 and ActiveX
Responsibilities:
• Design and development of the system in a 3 person team.
• Writing code to develop various ActiveX controls
Stock Maintenance System
This system was developed for the third party vendor. The goal was to track and manage the equipments required.
This elaborate GUI-based application relies on VB to provide the front-end and Oracle at the back-end. This project involved the design and development of the database. A VB application accepts “a plan” with various other parameters, validates that all parameters are within specified limits (pre-entered into a Oracle database) and stores them in a separate Oracle database. All communication between VB and Oracle is using ODBC.
Environment: Win NT, Visual Basic 6.0, Oracle 7.3 and ActiveX
Responsibilities:
• Design and development of the system in a 2 person team.
• Writing code to develop various ActiveX controls
Directorate of Training and Employment (India) Dec 97 - Dec 99
Payroll System
This Project was developed using Oracle as the database and Developer 2000 as the front end. This package monitors the salary details of each employee. The personal details as well as monthly transactions of each employee were maintained. To accomplish this, the whole project was divided into 3 modules: Employee set up module where the personal details of an employee are maintained, Transaction module where in the monthly transactions of all the employees are maintained, Reports module wherein the overall summary and the individual pay stub of all the employees are generated. The database of the employees was developed using Oracle. SQL queries, PL/SQL control structures, Triggers, Procedures, Packages and Exceptions were used in the development of the database. Developer 2000 was used on the client side. Communication between the front end and the backend was using SQL*Net.
Environment: Win NT, Oracle 7.3, Developer 2000, Forms, Report Writer, SQL*Plus
Responsibilities:
• Design and Development of code on both Client & Server side.
• Database Design and generation of reports
• Used Developer 2000 to develop user input screens and reports
Sales Management System
The client server architecture was implemented around a Visual C++ on the client side and Oracle as the database. This package consisted of four modules: Customer module, Product master, Sales order Processing, Sales invoicing. Project data, Vendor data & time-tracking information is entered via the GUI and stored in the Oracle database. The communication between VC++ and Oracle was using the ODBC. This system manages Customer information, Quotes, Customer orders, Stock maintenance of Items, Sales and Shipping details. Upon user input a Visual C++ application stores data in an Oracle database.
Environment: Windows NT, Visual C++ 5.0, Oracle 7.3
Responsibilities:
• Primary responsibility for development of the Customer, product and sales order module, which maintains customer and product information, Sales order processing and Sales invoicing. It also has a provision for Tax calculations.
• Design, development and maintenance of Database, SQL Queries and reports
• Responsible for Unit and Integration testing of several modules.
Library Management System
This package helps the industrial training institute (ITI) students with their library management work. Through this application students will be able to select books for the classes they are enrolled in. The librarian will be able to look up account information such as the books due, etc. User input was accepted using forms and screens designed with VB. Active X controls were created and used in the application. COM components were created, registered and referenced, and the object browser was used to get information of the COM components. These were later reused in other applications outside of this system.
Environment: MS SQL Server7.0 on Windows NT, Visual Basic 5.0
Responsibilities:
• Design and Development of the COM objects
• Coding for the entire project
Department Information System & ITI Automation
A simple client-server system was developed using a Visual Basic front-end application and a back-end SQL Server 7.0 database. This package gave all the details of the staff of the ITI’s and various other details of the courses available like the fee structure for each course and start and end dates of the course etc. This package consisted of six modules: Staff module, Student inquiries, Enrolments, Fee collection, Course up-gradation, Dropout checking. The staff module gives the details of the staff. The course details will be displayed and the desired course can be selected. When a course is selected, the course contents will be displayed along with the details of the starting and the ending dates of the course. At the time of enrolment, the discount (if any) given for the course is recorded. The monthly fee is calculated using the discount .The course up-gradation deals with adding the up-gradation fee and changing the end date of the course. The dropout module checks the attendance of the students.
Environment: Win 95, Visual Basic 5.0, SQL Server 7.0
Responsibilities:
• Design of the database
• Design and development of the Visual Basic application
EDUCATION
1 Bachelors of Engineering
BS in Electronics and Communication engineering.
References
Will be furnished on request.