SQL Developer/Programmer Analyst
Resume:
GEETHA RAMKUMAR
**************@*****.***
Title
SQL DEVELOPER
Primary Skills
SQL Server, PL/SQL, HTML, DHTML, ASP, JavaScript, VBScript, HTML, DHTML, VB, Crystal Reports, VBA in Excel, Access and Word
Location
Alpharetta, GA
Professional Summary
• Over 12 years of compound experience in IT, 8 years of SQL development and support experience with DBA duties.
• Experience working with database of size upto 400+gb and tables containing 50 million to 140 million rows.
• Extensive Experience in developing and monitoring DTS packages
• Extensive experience with SQL Server and T-SQL in constructing complex procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Working Experience in designing, implementing, maintaining and documenting complex database applications in retail and financial environments.
• Excellent report creation skills using Crystal Reports 8 .5 - XI
• Extensive experience in PL/SQL in creating complex procedures, indexed views, tables, triggers, indexes
• 5 years of web development, support and administration experience.
• 3 years of experience in web application setup, configuration and support.
• EXPERT Level skills in ASP, MS Visual Basic, IIS, VB Script, HTML, DHTML, Java Script, SMTP, Crystal Reports 8.5 to XI (English & Japanese versions)
• Expert level skills in MS Access, MS Excel, MS Word, VBA programming
• Experience in TOAD, Dbase, Foxpro
• Over 3 years of IT training experience
• Excellent communication, presentation and interpersonal skills
• Strong troubleshooting and organizational skill
Technical Skills
• Database SQL Server 2000/2005
• Oracle 8i/9i
• Foxpro, Dbase, Mysql, Sybase
• SQL, T-SQL, PL/SQL, SQL/PLUS
• Performance Tuning, Installation
• ODBC, OLE DB, DTS, DAO, ADO
• Languages VB6.0, HTML, DHML, ASP, JavaScript, VBScript, C++, Java, VC++
• VBA in Excel, Access
• Operating Systems Windows Enterprise 2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional/NT 4.0 Server/Terminal Server.
• UNIX, Red Hat Linux
• UNIX Shell Scripting
• Crystal Report 8.5/9/10/11, Crystal Enterprise
• UML
• Visual Studio 6.0
• IIS
• Protocols HTTP, SMTP, TCP/IP, FTP
• DNS
Non-Technical Skills
English, Japanese (communication Level)
Work History
AMS Inc. Jul 2008 till date
AMS, Inc. is a fully licensed and insured Georgia Corporation specializing in the collection of delinquent real and personal property ad valorem taxes for County and City governments. Appalachian’s client list includes only city and county governments.
Responsibilities –
1. Collected and managed data information
2. Involved in the migration of data from MS Access to SQL Server
3. Developed and optimized stored procedures, triggers
4. Developed Oracle based applications, and managed implementation to ensure successful execution of the application
5. Troubleshoot databases and custom application issues
6. Generated reports using crystal reports
Environment: VB, MS Access, SQL Server , Windows Enterprise Server 2003, Crystal Reports XI, MS Excel
Gwinnett County IT, Atlanta Nov 2005 till June 2008
Gwinnett Justice and Administration center is the county office that includes Tax Commissioners, tax Assessors, court, elections, water, parks and recreation and police depts. This office provides services to the Gwinnett county residents. Gwinnett county IT dept caters to all their application requests and manages their databases around 400+ GB and tables of sizes ranging from 50 to 140 millions rows.
Responsibilities Include –
1. Involved in the Migration of Oracle databases to SQL Server 2005
2. Developed and optimized database structures, stored procedures, views, triggers and user-defined functions
3. Developed sql scripts for tax staff on adhoc requests
4. Managed TAX database upgrades on PRODUCTION and TEST environments
5. Supported the critical tax system (Manatron GRM) which included both the application and database, used by the county and coordinate between between the vendor and the county staff in implementing the system.
6. Designed and Developed complex reports and the related sql scripts using Crystal Reports XI for the TAX commissioners and Assessors, Elections and police depts.
7. Developed standalone applications using VB/Oracle/Crystal Reports as required
8. Provided support in IIS server setup on Windows 2003 for the Tax system
9. Developed technical and end user documentation for all tools
Environment: SQL Server 2005 Enterprise, Oracle, Windows Enterprise Server 2003, IIS 6.0, .NET, Microsoft Reporting Service, Crystal Reports XI
PRADA Japan Co., Ltd, Tokyo, Japan July 2001 to Sep 2005
Prada is a high-end Italian fashion label, specializing in luxury goods for men and women (ready-to-wear, leather accessories, shoes, and luggage and hats), founded by Mario Prada in 1913. Prada is considered one of the most influential clothing designers in the fashion industry. PRADA Japan has around 150 stores in Japan. My responsibilities in PRADA were to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of sales, inventory databases in both development and production environment. My responsibilites also included developing web application that catered to reporting and data entry needs of Merchandizing, logistics, HR, visual merchandizing and sales departments and all stores.
Responsibilities Include –
1. Collected and managed data information from the departments, employees, stores and offices from HO in Italy
2. Designed and implemented SQL Server 2000 databases for mission-critical business applications
3. Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
4. Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors
5. Generated the weekly, monthly, and quarterly report by using Crystal Report
6. Data transfer from Foxpro (Point of sales system) to SQL Server 2000 on a daily basis, which I automated using SQL Jobs
7. Designed and developed bilingual web application.
8. Developed small standalone applications using VB/SQL Server/Crystal Reports as required
9. Provide support in IIS server
10. Provided Training to staff on the end product
Environment: SQL Server 2000 Enterprise, Windows 2003, IIS, Crystal Reports XI, VB Script, Java Script, ASP, Visual Basic, Foxpro
NIIT Ltd, India Nov 1996 to July 2001
NIIT is a leading Global Talent Development Corporation, building a skilled manpower pool for global industry requirements. It provides training solutions in IT, Business Process Outsourcing, Banking, Finance and Insurance, Executive Management Education, and Communication and Professional Life Skills,to around five million learners every year. My responsibilities included managing web based projects on client sites like Merril Lynch Investment Managers, Japan, training trainers, students, setting up new training centers in India and Sri Lanka.
Responsibilities Include –
• Collaborated with web developers on the backend design and development to support the survey UI and applications. Ensure queries are optimized, tables are correctly indexed, and data is accurate.
• Developed and created stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Work with end users to define, implement, and maintain their reporting requirements
• Develop and maintain complex DTS packages.
• Provided IT training to trainers and students
• Setup a new training center in India and Sri Lanka
Education
BS in Electronics and Communication, Gulbarga University, India
Professional Training
Course in IIS 4.0, NIIT Ltd, India
Course in SQL Server 2000, NIIT Ltd, India
Course in Oracle, SQL Star International, India
Contact this candidate