PUSHPA SATISH 647-***-****

** **** ****** *****, **** 506, Toronto, ON M1P 5C5

ace3h8@r.postjobfree.com

SQL DEVELOPER

SUMMARY OF SKILLS

• Over 4 years of experience in SQL Server 2005, coordination, analysis, design and development

of IT solutions; with particular focus on Databases .

• Strong knowledge in T-SQL programming, Stored Procedures, Triggers, Views, Tables; with

proficient in data mining, Data Manipulation, Database Development on SQL and expert in Relational

Database Analysis.

• Excellent verbal and written communication skills, comfortable in breaking down complex

technical solutions in order for colleagues to understand.

• Exceptional analytical and problem solving skills. Team Player with the ability to communicate

effectively at all levels of the development process

• Responsible, dedicated, hardworking and sincere professional with proven experience working

with SQL implementation

WORK EXPERIENCE

FREELANCE Developer, Toronto 2013-2014

• Extensively used SQL to write Stored Procedures, Functions, Packages and Triggers.

• Involved in database development using stored procedures, triggers, views and cursors

• Maintained data integrity by performing validation checks

• Monitored the performance and optimized SQL queries for maximum efficiency

• Involved in creating Indexes for faster retrieval of data.

SQL Developer, Business One Technologies, Bangalore, India 2010

• Created Functions, Views, Constraints, Partitions, complex queries and CTE(Common Table

Expressions) using T-SQL code to implement the business rules in SQL Server 2005/2008 for Health-

care projects

• Created, tested, performance tuned and implemented Stored Procedures and queries in

Microsoft SQL Server 2005/2008

• Prepared ETL design document which consists of the database structure, Error handling, restart

and refresh strategies

• Identified the bottleneck and maintained the indexes.

• Designed and implemented the database architecture concepts and principles throughout the

project.

• Designed and developed projects using Software Development Life Cycle methodologies.

• Created triggers on database objects to perform automatic updates and insertions

• Created new users and roles and set up permissions

• Prepared Test cases for Unit Testing and suggested Test cases with QA Engineers

• Maintained the database objects in Visual source safe

• Assisted in development and deployment of database solutions for a number of large

organizations and tested new systems

SQL Developer, RAMCO Systems Ltd., Chennai, India 2006-2009

• Created T-SQL code, stored procedures, tables, views, triggers, pivot tables to implement the

business logics in SQL server 2000/2005/2008 for Aviation projects.

• Involved in administrative tasks such as performance tuning, query optimization, SQL profiler,

execution plans on database objects.

• Designed and developed reports with clear cut information using SQL Reporting services.

• Evaluated, examined and implemented user roles and assigned relative database access

privileges.

• Provided sessions for juniors about SQL Server 2005/2008 concepts and demonstrated the

projects to the senior managers.

• Maintained and provided the access privileges to access the database objects in Visual Source

safe.

EDUCATION

Master’s in Computer Applications, Bharathidasan University, India 2007

Bachelor's in Computer Applications, Bharathidasan University, India 2004

Contact this candidate