We provide IT Staff Augmentation Services!

Sql Resume

SwitzerlanD

Summary:

  • Over 7 years of experience as Data Base Developer with good experience with SQL Server.
  • Extensive experience in business requirement gathering, data analysis, scoping, documentation (business requirement, functional specification, use case, business process flows, gap analysis, Test plan, test cases, user / training documentation etc.), reporting, designing UI Mockups, conductingUAT and end user training.
  • Strong Programming experience in MS SQL SERVER using T-SQL, SSRS.
  • Hands-on working experience with Integration Services (SSIS) and Reporting Services (SSRS).
  • Expert in Data Extraction, Data Mapping Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), and DTS.
  • Experience in tuning complex SQLs for data extraction and reporting
  • Good experience with Microsoft Office products ( MS ACCESS, MS EXCEL)
  • Excellent skills in database backup, recovery and restoration.
  • Strong experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks.
  • Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
  • Experience in Enterprise Reporting Services SSRS in SQL Server 2005.
  • Strong QA testing skills, test cases, test plan and validating test results
  • Experienced in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills
  • Worked with T-SQL to create Tables, Views, Indexes, Stored Procedures and Triggers.
  • Performance Monitoring with SQL Profiler and Windows System Monitor.
  • Experience working with Query Analyzer.
  • Experience in Replication environment (Transactional & Snapshot method used) to replicate data to other servers.
  • Experience in Data Transfer between various servers using DTS Packages and BCP.
  • Experience in Database Consistency Checks Using DBCC Utilities
  • Experience in using Performance Monitor/Profiler to solve Dead Locks.
  • Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics,Recompiling Stored Procedures and performing other maintenance tasks.
  • Experience & understanding of logical and physical database design.
  • Experience in data modeling using ER-WIN.
  • Hands on experience in writing & debugging stored procedures and triggers, troubleshooting database issues.
  • Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobswith SQL Server Agent, and SQL Profiler.
  • Experience in performance monitoring and performance tuning by implementing efficient schemas, Optimizing queries, Tuning indexes and Database Consistency Checks using DBCC Utilities.
  • Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills. Proactive, independent, self-managing and teamwork spirits.
  • Extensive experience in writing complex scripts tasks to execute business functionality on the data in the SSIS pipeline.
  • Strong understanding of Object Oriented Concepts, .Net Framework, Win Forms, VB.Net and C#.Net.
  • Extensive experience in utilizing SQL Server 2005/2008 as an application backend including data table design, development of Stored Procedures.
  • Sound knowledge of RDBMS concepts and experience in ER Diagrams, Views, Stored Procedures, Functions, Triggers, Indexes, Temporary Tables, SQL, T-SQL and PL/SQL using SQL Server 2000/2005.
  • Experienced in working with Microsoft Visual Source Safe (VSS) and Team Foundation Server (TFS).
  • Agile team player with good oral, writing skills and excellent time management skills.

Skills:

  • Programming Languages: T-SQL, XML, XSLT, VB.NET, C#, ASP.NET, Visual Basic 6.0
  • Databases: SQL Server 2008/2005/2000, Oracle 8.0, Data Warehouse (SSIS)
  • Source Control: Visual Source Safe, Team Foundation Server
  • Platforms and Misc: Visual Studio 2003/2005, Power Builder, IIS, MTS, Windows: XP / 2000
  • Other Skills: All phases of the software development life-cycle (requirements, design, development, testing, release, support), knowledge about agile software development process.
Experience

Client: Confidential, OR Sep 2005 - Current
Position: SQL DEVELOPER - LEAD
Product: Workforce Acquisition
Team size: 10

Confidential, Workforce Talent Acquisition product offers a single unified platform with powerful solutions for high-volume hiring and salaried recruiting, combining industry-leading automation and employee selection tools with smart, friendly technology that creates an easy-to-understand user experience.

Managed and coordinated several change order releases from development to QA and then to UAT and Production. Implemented features and solutions to satisfy the requirements, along with fixing numerous defects identified by SQA and Customer Integration.

Responsibilities:

  • Designed & implemented tables, views, clustered and non clustered indexes in Kronos production environment
  • Coordinated with back-end programmers in optimized stored procedures, implemented referential integrity by using triggers, worked on performanceand tuning..
  • Dropped and recreated the indexes on tables for performance improvements
  • Developed stored procedures, triggers, functions and maintained referential integrity.
  • Write SQL jobs to attach emails regarding the status using the send mail.
  • Worked in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and DTS.
  • Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
  • Tuned large Stored Procedures and carried performance improvement on long running queries
  • Configured the database maintenance plans for database optimization.
  • Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeeded
  • Used DBCC utilities and fixed data corruption in application databases.
  • Implemented Snapshot and Transactional Replication for the reporting databases.
  • Involved in creation of Stored Procedures, Functions and DTS Packages.
  • Worked on creating SQL traces using SQL Profiler Wizard.
  • Experienced in performance tuning using SQL profiler of SQL server.
  • Configured Replication methods like snapshot replication, transactional replication and Merge replication.
  • Worked with developers to tune the queries, run scripts and move the database from production to development servers.
  • Troubleshooting client issues ranging from improper configuration settings or data corruption to issues in underlying code.
  • Working with product management to provide enhancement or other resolution.
  • Participated in project team activities prior to release and contributed to documentation requirements consistent with methodology
  • Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key to streamline the process of replication.
  • Fine tuning and optimization of SQL queries and Stored procedures using SQL Profiler, Trace and Performance monitor and ensuring indexes are using updated statistics.
  • Working with Developers to promote Product releases from development to Test to Production environment.
  • Developed test strategies, test plans and test cases and performed UnitTesting to identify and resolve integration, functional and usability issues before deployment.
  • Used Team Foundation Server(TFS) as central file repository.
  • Used Agilemethodologies, test driven development and automated builds.
  • Actively involved with the team of developers in knowledge transfer, functionality issues, database issues, best coding practices and standards.
  • Created complex Stored Procedures to extract data for generating reports by using SQL Server 2005 Reporting Services (SSRS), Triggers, Indexes and Views.
  • Developed static reports using SQL Server Reporting Services and deployed the reports (RDL files) in SQL Server 2005.
  • Designed and implemented storedprocedures, table scripts, user defined functions in SQL (SQL SERVER 2005) to meet backend requirements as needed for the use case.
  • Added Indexes to improve performance on tables

Environment:SQL Server 2008/2005/2000,T-SQL, SSIS, HTML, C#, C++, ASP.NET, XML, XSLT, Power Builder, TFS

Client: Confidential, Switzerland Jul 2004 - Aug 2005
Position: SQL Developer
Product: Ramco e-Application
Team size: 20

The Ramco e.Application is an E-Enabled ERP system based on
Component Object Model. Ramco Financial is a corporate financial management system that can effectively track financial transactions from dispersed geographic locations in multiple countries. ETA Migration project is Personalized version of Ramco e.Application, it has several new features in activity and task level across the modules (Payable Management, Receivable Management, Fixed Assets, Book keeping, Inventory, Sales & Shipping and Purchase).

Responsibilities

  • Requirements Analysis and prepare design document.
  • Developed stored procedures, triggers, functions and maintained referential integrity.
  • Developed Payable modules (SDIN, SCDN, SNP).
  • Developed test strategies, test plans and test cases and performed UnitTesting to identify and resolve integration, functional and usability issues before deployment.
  • Used Virtual Source Safe(VSS) as central file repository.
  • Actively involved with the team of developers in knowledge transfer, functionality issues, database issues, best coding practices and standards.

Software Used: SQL Server 2000,SSIS,HTML, Ramco Virtual Works 1.4.3 (RVW)

Client: Confidential, India Jan 2004 - Jun 2004
Position: SQL DEVELOPER
Product: Ramco e-Application
Team size: 30

The Ramco e.Application is an E-Enabled ERP system based on Component Object Model. Ramco Financial is a corporate financial management system that can effectively track transactions from dispersed geographic locations in multiple countries. Global Tax Solution is a tax module that used to automate the tax calculation for different tax types. This Project Contains five new components that are Tax calculation, Tax Transaction, Tax Settlement, Tax certificate Generation, Tax Rules Definition and Tax reports.

Responsibilities:

  • Requirements Analysis and prepare design document.
  • Developed stored procedures, triggers, functions and maintained referential integrity.
  • Developed Payable modules (SDIN, SCDN, SNP).
  • Developed test strategies, test plans and test cases and performed UnitTesting to identify and resolve integration, functional and usability issues before deployment.
  • Used Virtual Source Safe(VSS) as central file repository.
  • Actively involved with the team of developers in knowledge transfer, functionality issues, database issues, best coding practices and standards.

Software Used: SQL Server 2000, Ramco Virtual Works 1.4.3 (RVW)

Education

Master of Science (Information Technology and Management)
Bachelor of Science (Computer Science)

Hire Now