Developer Experience Sql Server .Net Management
Resume:
VASANTHA SANKURI
abhijs@r.postjobfree.com
***** ******* ***** **, **********, MD 20874
Summary
. In-depth understanding and knowledge of Relational Database Management
Systems and Software Development Life Cycle (SDLC).
. Good understanding of Relational Database Design Concepts and Object
Oriented Concepts.
. 2 years of real time experience as Database Developer / Analyst /
Administration using SQL Server 2005, Database Engine, OLAP, ETL and
SSIS.
. 1.5 years of educational experience as Database Developer using SQL
Server 2005, SSRS, SSIS, Oracle 10g, MYSQL, PostgreSQL and MS Access..
. Experience in creating Database Objects tables, relationships
(referential integrity), stored procedures, views, cursors and
triggers, indexes, queries and scripts using SQL.
. Experience in using different databases SQL Server 2005/2008, Oracle
10g, MYSQL, PostgreSQL and MS Access.
. Good understanding, management and experience in the database
performance (Job activity monitor), backups, replication and security
(Logins).
. Experience in Data analysis, export/import (ETL) of data in SQL Server
2005, Cognos and MS Access.
. Experienced in developing web Applications using C# and VB.Net in .Net
2.0/3.5 framework (visual studio 2005/2008).
. Experience in gathering requirements, designing, coding and testing
the applications
. Exceptionally good in problem analyzing, solving and troubleshooting
skills.
. Excellent communication, interpersonal and presentation skills, self
starter and quick learner.
Software Skills
. Programming Languages: C++, VB6, VB.Net, ASP.Net, C#, SQL, ADO.Net
. Web Technologies: HTML, CSS, JavaScript, VbScript, AJAX
. Operating systems: WINDOWS 98/NT/2000/XP/Vista/7, MAC,
UNIX
. Databases: Oracle 10.x, SQL Server 2005/2008, PostgreSQL,
MYSQL, MS Access
. Web Server: Microsoft IIS, APACHE
. Business Intelligence Tools: IBM Cognos 8
. IDE: Eclipse 3.0, Visual Studio 2005/2008,
Dreamweaver
. Microsoft Products/Tools: Microsoft SharePoint, Windows
SharePoint Services
3.0 (WSS 3.0), Source Safe, MS Office, InfoPath
Education
M.S - Information Systems, George Mason University, Fairfax, VA
GPA: 3.43, May 2009
Bachelors - Electronics and Communications, JNTU, INDIA GPA: 3.64,
July 2006
Work Experience
Junior Database Administrator / Developer
Feb 2010 - Present
Innovative Technologies Inc, Chantilly, VA
Roles & Responsibilities:
. Developing and maintaining the databases for .Net applications and
SharePoint.
. Designing, creating, updating and maintaining the databases, Schemas,
tables and relationships.
. Creating database diagrams, queries (such as sub queries, joins, group
by), stored procedures and triggers.
. Creating logins / users profiles in the databases.
. Performing backups of the databases and Scheduling Jobs in Job
activity monitor.
. Troubleshooting issues related to database performance (Job activity
monitor).
. SharePoint: Created web applications, sites/subsites, document
libraries and form libraries. Integrated SharePoint with InfoPath.
Handling user permissions at different levels in SharePoint sites.
Using STSADM tool to perform export, import and backups.
. ATS (Applicant Tracking System): Web Application developed in .Net
(Visual Studio 2008) using C# with a SQL server 2005 backend database.
Tables, relationships, queries, stored procedures and triggers have
been created. Performed data analysis and import/export of data from
old database to new database. Created database diagrams and logins in
the database. ATS is used by internal HR (Human Resources) people to
filter the resumes based on the job requirement. Wrote adhoc SQL
queries. Features such as adding a new candidate profile,
modifying/deactivating existing profile, searching profiles, sending
emails to the user profiles, etc are provided with in the application.
. Helpdesk Application: Application designed and developed in .Net and
is used to track issues people having with SharePoint, Software and
Network. Users will create trouble tickets using this web application.
. Performing testing for the existing applications after the
enhancements is performed.
Designing, updating and maintaining company website (Html, CSS, JavaScript
and C#).
Handling user accounts and permissions in active directory and for network
drives.
. CMMI: Involved in achieving CMMI level 2 rating for company. Learned
different process areas of CMMI level2: Configuration Management,
Product and process quality assurance Measurement Analysis, Project
monitoring control, Project planning, Requirements management. Gained
knowledge in various stages in project life cycle (requirements, plan,
design, code, testing and maintenance) for CMMI process.
Database Developer Dec
2009 - Jan 2010
PTAP, George Mason University, Fairfax, VA
Roles & Responsibilities:
. Develop, update and maintain PTAP databases and websites.
. Database creation and maintenance using MS SQL 2000/2005 (Referential
integrity, Normalization, backups and security)
. Create and maintain SQL queries such as Stored Procedures, views,
cursors, and Indexes.
. Maintaining and enhancing Novaptac and Vaptap Websites at
https://novaptac.org/, https://vaptap.org/ based on the business
requirements.
. Updating the WebPages using HTML, ADO .Net, CSS and JavaScript.
. Creating modules with new functionality in ASP and JavaScript
Database Analyst / Developer June 2009 - Nov
2009
Business Intelligence, Fairfax, VA
Roles & Responsibilities:
. Worked in NAEP (National Assessment of Educational Progress) project
for Department of Education
. Design, develop, maintain and update the databases using Sql Sever
2005 and MS Access
. Performing data analysis and import/export (ETL) of data using Sql
Sever 2005, Cognos and MS Access.
. Developed tables, relationships, queries, stored procedures, views,
indexes and triggers in SQL Server database and MS Access.
. Developed macros, forms, reports for the Access databases using VB6.
. Web technologies used to design the web pages are HTML, CSS,
JavaScript, and VBScript. Experience in using ADO.Net to connect to
SQL Server Database.
. Developed models/packages in Cognos Framework Manager.
. Developed Namespaces, Queries, Dimensions, and Relationships for the
models.
. Developed D-Cubes, D-Lists, D-Links, A-Tables and File maps in Cognos
Planning - Analyst. Developed applications in Cognos - Contributor.
. Developed reports in COGNOS 8 using report Studio.
Graduate Student Assistant Dec 2007 - May
2009
PTAP, George Mason University, Fairfax, VA
Roles & Responsibilities:
. Develop, update and maintain PTAP databases and websites.
. Maintaining and enhancing Websites at https://novaptac.org/,
https://vaptap.org/ based on the business requirements (tools used are
HTML, ASP, ADO .Net, CSS and JavaScript).
. Database maintenance using MS SQL 2000/2005 (Referential integrity,
Normalization, backups and security (user profiles)), create and
maintain SQL queries.
. Perform Market Research Analysis and Generating reports for the Client
requirements.
Relevant Courses
Database Management Systems, Advanced Database Management, Software
Requirements Analysis and Specification, Object-Oriented Software
Specification, .Net Programming.
Academic Projects (George Mason University)
. On Line Gift Shopping - Designed and developed a website for online
gift shopping with a backend database created using MS Access.
Customers login to view and buy different products and can place
orders. Created tables and relationships in database. Performed Sql
queries against the database to create, insert, retrieve, update and
delete the data in tables (MS Access, Oledb, HTML, asp, CSS,
JavaScript, VBScript, IIS)
. Online Media Library - Developed Software requirement specification,
Use case diagrams, Design constraints, Context diagram and Statement
of Work. "Online Media Library" is a web project that provides
customers with online access to media.
. Degree Audit System - Created a website for students to enter their
degree program, classes taken, grades, classes planned, and
concentration. Database is created using SQL Server 2005. Web
application is developed using visual studio 2005. The DAS system
provides an interface to students to select different courses such as
core courses and elective courses. Created tables and relationships in
database. Performed Sql queries.
. Department Store - Creating a database of Department Store using 3
Normal Form. Wrote complex SQL queries and stored procedures to access
the database and its implementation in JDBC. Prepared ER Diagram,
Relation Schema, PK And FK Constraints, SQL queries ( DDL and DML
statements, Unions, Joins, group by, Aggregate queries, sub queries,
nested queries, stored procedures), JAVA Code (JDBC implementation
using Eclipse for dropping of tables, creating tables, inserting
values into tables, SQL queries and outputs) and Normalizing the
database (Oracle 10g and Eclipse).
References
Available upon request.
Contact this candidate