Sql Server Project
Resume:
Anusha K
******.*******@*****.***
Objective:
Over 3+ Years of IT experience as a SQL Server Developer and also as a Data
Analyst. To obtain a full time position in the field of Information
Technology that will give me an opportunity to apply my knowledge in
solving real time problems.
Technical Summary:
. Experience in project management and planning.
. Experience in working with version control tools.
. Worked in developing business reports using SQL Reporting Services
(SSRS).
. Experience with Full Software Development Life Cycle (SDLC) from
inception to delivery of product including requirements gathering, use
casing, functional specification, estimation, implementation,
debugging and documentation.
. Strong Technical background with excellent problem solving and
communication skills. Good team player with reputation of integrity
and an ability to work on multiple technologies.
Education:
MS in Computer Science - December 2009
Stratford University, Falls Church, Virginia. GPA: 3.5/4.00.
Bachelor of Sciences - April 2004
Andhra University, India. GPA: 3.6/4.00.
Related Coursework:
. Project Management
. C# & .Net
. Network Security
. System Design and Analysis
. RDBMS.
Professional Experience:
AT&T, Chicago, IL
(Dec 2010-Mar 2011)
Title: Data Analyst
Environment: Teradata SQL Assistant
This Project involved Pulling and retrieving data (view is used to retrieve
data) from multiple data sources.
Responsibilities:
. Developed SQL code in Teradata SQL Assistant and implemented reports
using the SQL Server and other data sources like MS Access, MS Excel.
. Pulled the reports using SQL code in MS Access database and posted in
ATT intranet website.
. Wrote complex SQL queries to populate data from different tables and
which can be used for reports
. Script SQL statements to extract data from the SQL Server for data
cleanup
. Monitored the table-spaces for the production databases on daily basis
and increasing the sizes if required
. Involved in writing SQL Joins, sub queries, and usage of temp tables
and table variables.
Green Globe Laboratories, West Chicago, IL
Title: SQL server developer
(Feb 2010-Nov 2010)
Environment: SQL Server 2008, SSRS, SSIS
I developed a Database Repository for the Laboratory inventory tracking to
assist the Chemical Engineers. The database also contained information
about the various chemicals used for different experimental procedures,
client information and billing details. I also designed several Reports
some of which are Ad-hoc Reports using SSRS to generate the billing
information to the clients based on the chemicals used for testing. I built
few SSIS packages to import some of the historical information from Excel
Spreadsheets and CSV Files to the SQL Server Database.
Responsibilities:
. Created complex Stored Procedures, Triggers, Cursors, Tables and other
SQL Joins for Applications by using T-SQL in SQL Server 2008.
. Automated daily and monthly inventory check by creating SQL Server
Agent Scheduled Jobs.
. Created SSIS packages to extract historical information from the Excel
Spreadsheets, CSV Files and load them onto the SQL Server Database.
. Designed and deployed various SSRS Reports with Ad-hoc features
in SQL Server 2008.
. Designed and implemented Parameterized and cascading parameterized
reports using SSRS.
. Prepared comprehensive test cases and performed Unit Testing and
Integration Testing.
. Successfully deployed the database scripts on the Production SQL
Server.
. Used Visual Source Safe for source control.
Teaching Assistant: Stratford University, Falls Church, Virginia, USA.
August 2008 - November 2009
. Teaching Assistant for the courses "System Design and Analysis" and
"Databases" in the Computer Science Department.
Software Developer: Starex Technologies., Hyderabad, India. (Nov 2005 -
March 2008)
Client: Aditya Construction Company Ltd., India
Title: SQL Developer
Environment: SQL Server 2005, SSIS, SSRS, Windows NT, T- SQL
Project Billing Management System and Invoice Management System (PBMS and
IMS) is a tool used by all Finance In-Charges of the Client to generate the
Billing Advices and Invoices. This system is presently integrated with 3
systems. After getting the approval by the Chief Finance Officer, Finance
In-Charge will generate the Billing advice. In the Billing advice
generation process this system picks all the project related information
from the Project Repository system (PR), all the associate effort details
from the Time sheet Management System (TSMS) and applies the commercials
and generates the billing advices which are directly ported into Invoice
Management System (IMS) for the Invoicing process. I was involved in the
backend application development using SQL Server 2005.
Responsibilities:
. Worked on PBMS and IMS project as a developer on MS SQL Server 2005, T-
SQL.
. Developed SQL Server Stored Procedures.
. Performance tuning of SQL queries and stored procedures using SQL
Profiler.
. Performed Unit testing and Integration Testing of the modules.
. Created SSIS packages for ETL process.
. Involved in the end to end delivery of the application from
requirement gathering to delivery of the application.
Client: IntelliGroup Asia Private Ltd., India
Title: Developer
Environment: SQL Server 2005, DB2, Windows NT, T- SQL, MS EXCEL, MS Access.
Intelligroup Asia Private Limited provides information technology solutions
for corporations and public sector organizations. The company offers
development, integration, implementation, hosting, and support of e-
commerce and enterprise applications. Intelligroup Asia Private Limited was
incorporated in 1996 and is based in Hyderabad, India. Intelligroup Asia
Private Limited operates as a subsidiary of Intelligroup Inc.
This project involved migration of data from SQL Server 2000 to SQL Server
2005 and then executing complex queries on the data.
Responsibilities:
. Worked with Implementation team and closely moved with end users to
implement manufacturing solutions.
. Worked closely with developers, end users and Administrators in
designing and creating databases and other objects.
. Actively involved in designing databases for the system.
. Developed several database objects such as tables, triggers and views
and also stored procedures.
. Created Snapshot Replication for the Development and Testing Databases
across different Servers.
. Created and scheduled jobs and alerts.
. Studied the existing environments and accumulated the requirements by
interaction with various aspects.
. Written several stored procedures to achieve various functionalities
of the system.
. Created packages using SSIS for moving data from MS Access to SQL
Server.
. Managing historical data from various heterogeneous data sources (i.e.
Excel, DB2, and Access).
. Assisted the Application team in data modeling and T- SQL coding.
Technical Skills:
. Operating Systems: Windows, UNIX.
. Languages: C, C++
. Web Technologies: HTML, PHP, CSS, XML.
. RDBMS: SQL Server 2000 / 2005/2008, MS Access 2007.
. Reporting Tools/ Utilities: SQL Server Reporting Services (SSRS), SQL
Server Integration Services (SSIS), SQL Server Analysis Services
(SSAS).
. Scripting Languages: JavaScript.
. Version Control Tools: Visual Source Safe.
References:
References available upon request.
[Anusha Kodali]
Contact this candidate