Sql Server Developer
Resume:
KALYANI JALA
*****.***@*****.***
Cell: 972-***-****
PROFESSIONAL SUMMARY
. Around 7 + years of total IT experience in the Design, Modeling, and
Development of SQL Server 7.0/2000/2005/2008.
. Expertise in Transact-SQL (DDL, DML), views, stored procedures and also
using database triggers
. Extensive knowledge in tuning SQL queries and T-SQL programs with a goal
to improve query performance and user response time.
. Proficient in Microsoft SSIS, Transact-SQL exception handlers, DTS Export
& Import.
. Experience in .NET/C# application development environment using SQL
Server databases.
. Extensive data integration design and development using BCP, DTS, SSIS
packages and Jobs for MS SQL SERVER.
. Proficient in SQL Server Integration Services (SSIS) 2005 and 2008
. Responsible for maintaining built cubes using SSAS and populate the cubes
with the data
. Created Ad -hoc reports for the Business Users in SSRS.
. Monitored and tuned MS SQL Server databases with tools including Index
Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal
performance.
. Experience with database administration in MS SQL Server 2005/2008,
including tasks such as data loading, batch jobs, data unloading, backup
& recovery, user and application table management, upgrades, creating
databases/File groups/files/Transaction logs
. Involved in optimizing code and improving efficiency in databases
including re-indexing, updating statistics, recompiling stored procedures
and performing Database tuning & other maintenance tasks.
. Excellent communication skills and experienced in client interaction
while providing technical support and knowledge transfer.
. Excellent writing skills and the ability to conceptualize and effectively
document.
. Excellent in collaborating with others in a team environment.
TECHNICAL SKILLS
Tools/Utilities : SSIS, SSRS, Enterprise Manager,
Profiler, Query Analyzer,
Export Import (DTS), Visual
SourceSafe 6.0, Visual Studio,
IBM ClearCase
Microsoft Management Console, DTS, SSIS, Business
Intelligence Development Studio (BIDS), TOAD, IIS&
Erwin 4.0.
RDBMS : Microsoft SQL Server 2000/2005/2008, MS
Access
Data Modeling : ERWIN, TOAD
ETL : DTS, SSIS 2005, SSAS 2005, SSIS
2008, SSRS 2008
Business Objects XI R2,
5i, 6i
Programming Languages : Transact-SQL (T-SQL), VB scripts, C, Java and
Oracle
Application Development : HTML, XML, CSS, .NET, C#
IT Processes : Software Development Life Cycle
(SDLC), Project Management
Productivity Applications : MS Word, MS Excel, MS Access, MS Project,
Visio, MS
FrontPage
Operating Systems : Windows 2000/NT 4.0, Windows 2003
Advanced Server/
Windows 95/98/200/XP-pro,
MS-DOS
EDUCATION:
Masters in Management Information Systems
Bachelors in Computer Science Engineering and Technology
Work Experience:
Medsynergies Inc, Irving,TX
Dec2011- Till Date
ETL Developer III
Responsibilities:
. Responsible for create/design and implement SSIS templates.
. Responsible for producing documentation for the best practices, SSIS
packages
. Involved in code review and peer review of the code and ETL design
. Responsible for implementing a business requirement in the ETL design.
. Design and implement new data models for projects
. Analyzing the requirements and design a solution for business need
/business change request.
. Developing ETL packages to load data into various systems
. Created master ETL packages which include various packages in them and
scheduled them to execute based on the given requirement time.
. Perform unit testing, regression testing and smoke testing of the ETL
Packages.
. Develop Ad-hoc,custom SSRS reports for Client reporting
. Implement re-startability, code-reusability in the ETL solutions
. Performing root cause analysis for projects.
. Generating Excel, CSV reports from Great plains Accounting database
for Accounting department
. Day-to-day job includes resolving user-tickets
. Provide on-call support for nightly data load process
Macys Inc, Atlanta, GA
April2011 - Dec2011
Sr. SQL Server Developer
Responsibilities:
. Responsible for create/design and implement SSIS templates.
. Responsible for producing documentation for the best practices, SSIS
packages
. Involved in code review and peer review of the code and ETL design
. Mentoring team mates to implement best practices of ETL methodologies
. Responsible for implementing a business requirement in the ETL design.
. Design and implement new data models for projects
. Analyzing the requirements and design a solution for business need
/business change request.
. Developing ETL packages to load data into various systems like
Teradata/SQL /BAM servers
. Created master ETL packages which include various packages in them and
scheduled them to execute based on the given requirement time.
Aflac Incorporated, Columbus, GA
Aug 2010 - April 2011
Sr. SQL Server Developer
Responsibilities:
. Creating Database objects - tables, views, and functions and
developing procedures for implementing application functionality at
the database side for performance improvement.
. Design and implementation of Security Model, policies and procedures
. Creating and Modifying T-SQL stored procedures/triggers for validating
the integrity of the data.
. Configured complex queries (SQL) to meet customer requirements as
needed.
. Worked as a developer in creating complex Stored Procedures, triggers,
cursors, tables, views and other SQL joins and statements for
applications.
. Performance tuned SSIS packages making them efficient and tremendously
increase in performance
. Migrated DTS packages to SSIS packages.
. Creating Store Procedures for SQL Server Reporting Services (SSRS)
reports
. Writing MDX queries for SQL Server Analysis Services SSAS Cubes
. Modify/deploy & process OLAP SQL Server Analysis Services (SSAS)
cubes
. Developing dynamic MDX queries
Microsoft Corporation, Redmond, Washington
June 10 -Aug10
SQL Developer
Responsibilities:
. Automated the process of monthly dashboards
. Developed SSIS packages for loading and extracting data from various
heterogeneous sources
. Used SCRUM methodology for development
. Developed complex store procedures in T-SQL for business logic
. Develop SSRS (SQL Server Reporting Services)reports to run the monthly
dashboards for the Accuracy Metrics
. Optimizing the queries to improve the performance of SQL server
Verizon, Tampa, FL
Oct 08 - Mar 2010
SQL Server Developer/DBA
Responsibilities:
. Involved in logical & physical design, development and testing of the
system.
. Involved in the normalization of the Database.
. Created new Databases and maintained existing User / System Databases.
Involved in Logical/Physical design of database and maintenance.
. Creating Database objects - tables, views, and functions and
developing procedures for implementing application functionality at
the database side for performance improvement.
. Design and implementation of Security Model, policies and procedures
. Creating and Modifying T-SQL stored procedures/triggers for validating
the integrity of the data.
. Responsible for Query optimization and Performance tuning
. Used NT Performance monitor to monitor CPU & Memory usage and SQL
Server Profiler to oversee the development of data warehousing and
Business Intelligence projects and their related databases,
warehouses, marts and cubes.
. Design and build relational databases, multi-dimensional databases and
data warehouses.
. Design, development and maintenance of end-to-end data warehouse
(OLAP/BI) solutions
. Overall responsibility for our SQL Server 2005/2008 OLAP
implementations, including ownership of high-level architecture,
performance, storage and general health.
. Developed complex Stored Procedures, triggers, cursors, tables, views
and other SQL joins and statements for applications.
. Implemented user interfaces, procedures and functions for
software application requirements.
. Tuned query performance by observing trace in SQL Profiler.
. Creation of New NT Logins and granting privileges to users/Groups and
objects
. Used DBCC commands to check physical and logical consistency of the
databases and Rebuild indexes
. Backup and recovery of Master, MSDB and Application databases
. Studied the existing business rules and understood the client's new
reporting requirements by interacting with the Business managers and
users.
. Created new reports from the scratch for new requirements and modified
some of the existing reports using SSRS.
. Created SQL Server Reports using SSRS 2005.
. Created weekly and monthly reports as per requirement using SSRS.
. Created Ad -hoc reports for the Business Users in SSRS
. Modified databases in QA and Production environment as per need and
user's request.
. Provided documentation of reports and the development process in order
to support the system
. Developed Custom Reports for contact management information system.
. Created SSIS packages to get data from various OLTP databases and
scheduled it for every day using SQL Server Agent and Migrated SSIS
2005 packages to SSIS 2008
. Responsible for maintaining built cubes using SSAS and populate the
cubes with the data
. Created Error Logging in SSIS, so that Error Code, Error Description
is saved to the tables in the database.
. Modified databases in QA and Production environment as per need and
user's request.
GameStop Inc, Grapevine, TX
Feb08- Oct 08
SQL Developer
Responsibilities
. Designed, coded, tested and implemented user interfaces,
procedures and functions for new and existing
software application requirements.
. Monitoring of database size, disk space in both Production &
Development environments.
. Creating and monitoring all maintenance jobs on all databases.
. Used Agile working methodology for development
. Tuned SQL Queries and Store Procedures, making sure each and every
query is using appropriate useful indexes.
. Involved in all stages of Software Development Life Cycle
. Worked as a developer in creating complex Stored Procedures,
Triggers, Functions for various Batch and reporting purposes
. Managed index statistics, Tables, Views, cursors and optimizing
queries by using execution plan for tuning the database.
. Optimized the performance of queries by modifying the existing index
system and rebuilding indexes.
. Performed database transfers and queries tune-up, integrity
verification, data cleansing, analysis and interpretation
. Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS
areas, trouble- shooting process issues and errors.
. Transferred huge amounts of history data into the databases using
Import\Export wizard
. Maintained the physical database by monitoring performance, integrity
and optimized SQL queries for maximum efficiency using SQL Profiler.
. Analyzed the existing Data warehouse ETL (DTS) software process to
develop T-SQL code and MS SQL Server 2005 jobs
. Scheduling Jobs and Alerts using SQL Server Agent.
. Used Performance Monitor and SQL Profiler to optimize queries and
enhance the performance of database servers.
. Developed SSIS packages to populate date into Enterprise Data
Warehouse from ODBC Sources.
. Migrated Database/DTS packages to SSIS 2005 &2008.
. Installing SQL Server on Various Environments like Development, Stage
& QA
. Performance tuned SSIS packages making them efficient and tremendously
increase in performance
. Migrated
. Performed unit, system and integration, validation tests to ensure
quality.
. Wrote visual basic scripts to automate jobs and software tasks
. Created reports that call Sub reports in SSRS.
. Responsible for creating fact and dimension and fact tables and build
cubes using SSAS
. Involved in creating ODS
. Experience in Designing, Building the Dimensions, cubes with star
schema using SQL Server Analysis Services (SSAS) for analyzing
purpose.
. Deploying SSAS cubes.
. Created master ETL packages which include various packages in them and
scheduled them to execute based on the given requirement time.
. Developed SSIS packages to import data from Various sources like Flat
File Sources, e.t.c
Microsoft, Seattle, WA
Oct 07- Dec07
SDET
Responsibilities
. Responsible for creating Databases, Tables, Cluster/Non-Cluster Index,
Unique/Check Constraints Views, Stored Procedures & Triggers
. Developed custom reports using SSRS/SQL Server BI studio.
. Monitored SQL Error Logs /Schedule Tasks/database activity/eliminate
Blocking & deadlocks /user counts and connections/locks etc.
. Used NT Performance monitor to monitor CPU & Memory usage and SQL
Server Profiler to monitor and record database activities of
particular users, applications
. Scheduled Jobs and set up Notifications and Alerts using SQL Server
Agent
. Responsible for database security including adding logins, roles,
groups at O/S level and MS SQL Server and maintaining proper security
procedures.
. Created SQL Server Reports using SSRS 2005.
University of Memphis, TN
Aug06- Aug2007
Research Assistant
Responsibilities
. Maintain & update database for Supply chain management department.
. Monitor and maintain user accounts and grant access privileges from
Active directory Systems and User Manger for Domains.
. Design, develop and update the Research website.
. Solve optimization problems using VBA.
. Upgrade enhancements, maintenance, and support and fix bugs for the
front end.
. Monitor Server Level Blocks/deadlocks & Maintain all the OLTP Servers
with Maximum Database Availability, Reliability & Investigate and
resolve any Database Related issues /performance related issues with
Minimal Downtime & Maximum Reliability
GENPACT, Hyderabad, India
Mar 2003 - Dec 2005
DBA Developer
Responsibilities
. Responsible for SQL Server 2000 database development, database
modeling, database program, database administrator
. Performed DBA tasks through Enterprise Manager, Query Analyzer,
English Query, Import Export wizard
. Responsible for remote database servers
. Involved in designing and writing Stored Procedures, functions and
packages using T-SQL for SQL Server 2000.
. Maintain and implement the database using SQL Server 2000 back-end
tools and DTS.
. Design, develop and administer the E-Work platform website
. Involved in complete SDLC, which includes requirement gathering,
analysis, design, development, Implementation,
. Upgrade enhancements, maintenance, support and bug fixing for the
product.
. Performing query plans and making sure each and every query is using
appropriate useful indexes.
. Used Performance Monitor and SQL Profiler for Monitoring memory,
processor, Disk I/O, SQL Queries, other etc.
. Rebuilding Indexes and Tables as part of performance tuning exercise
. Set up some tables in the main server as a snapshot publication and
push them to the warehouse server (Subscriber) on the nightly basis.
This eliminated the old way of emailing spreadsheet on the weekly
basis.
. Successfully migrated data to new location using Snapshot Replication,
and implemented Merge Replication to support up to date record of
Inventory Information.
. Creating, modifying and monitoring replication on all databases.
Contact this candidate