We provide IT Staff Augmentation Services!

Sql Resume

Pittsburg, PA

Professional Summary:

Around 7 years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2008 / 2005 / 2000 in Development, Test and Production Environments on various business domains like Financial, Insurance and Manufacturing.

  • Hands on experience in Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2000/2005/2008.
  • Extensive experience in database activities like Data Modeling, Database Design, Development, Data Transfer, Documentation.
  • Experience in migrating from SQL Server 2000 to SQL Server 2005 ,SQL Server 2005 to SQL Server 2008
  • Strong experience with ETL tools components like Mapping, Transformations, Expressions, look-ups and Aggregations.
  • Experience with writing scripts in C#, VB.net tointegrate information from multiple sources to execute effectively and efficiently in a dynamic environment
  • Expertise in Database Normalization for Transactional System by providing proper Primary Keys, Foreign Keys Relationship.
  • Strong SQL skills, including writing Joins, CTE’s and Sub-Queries for Complex Queries.
  • Extensively worked on Data extraction using SSIS 2005 and SSIS 2008
  • Experience in Creating Simple and Parameterized reports using SSRS
  • Experience in Extracting, Transforming and loading of data from sources like Excel, XML, Text File, Flat file, Oracle, DB2 into MS SQL Server using SQL Server Integration Services (SSIS).
  • Expertise on Microsoft Business Intelligence Tools SSIS/SSAS/SSRS 2005/2008(Analysis Services, Integration Services and Reporting Services).
  • Experience with logical and physical data modeling and involved in creation of Star Schema and Snowflake dimensional schema Data Model’s using Erwin Tool.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS 2005/2008), Log Shipping, DTS, Bulk Insert and BCP.
  • Experienced in Data Warehouse Design and architecture, Data Analysis, Relational data modeling, Dimensional modeling.
  • Good experience in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2008.
  • Experience in modifying Cubes and Dimensions in SSAS.
  • Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft sql Server Analysis Services 2005/2008.
  • Extensively used tools like Management Studio, SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
  • Extensive experience in creating Tables, Views, Indexes, writing Stored Procedures, Triggers as well as analyzing and debugging existing complex stored procedures.

Education: Bachelor of Technology

Technical Skills

Languages

C, C++, C#, T-SQL.

RDBMS

MS SQL Server 2008, 2005, 2000, Oracle 9i/10g, SQL Server Management Studio(SSMS), SQL Server Analysis Services 2005,MS SQL Server Integration Services 2005, MS Access.

Front End

MS Visual Basics 6.0.

Reporting Tools

SQL Server Reporting services 2005,2008.

Data Modeling Tool

ERWIN 4.0, ETL, Visio 2002.

Operating System

Windows 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 95/98/2000 XP.

Professional Experience:

Confidential, Kanas City, MS
Role : SQL developer
Duration: May 2011 - Present

Responsibilities:

  • Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
  • Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.
  • Worked with development teams in the design of physical databases and in modification.
  • Created Packages in SSIS with error handling.
  • Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
  • Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.
  • Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
  • Worked with different methods of LogginginSSIS.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Involved in migrating data from DB2, MS-Access, MS-EXCEL and other external data sources.
  • Created complex SSIS packages using proper Control and Data flow elements.

Environment: MSSQL Server 2008 and 2005, T-SQL, Erwin, ASP.Net 3.0, Ado.Net 3.0, C#.Net, Excel, SSIS

Confidential, Pittsburg, PA
Role : SQL developer
Duration : July 2009 – May 2011

Responsibilities:

  • Involved in gathering requirements from Business Users, Analysts by scheduling meeting at regular basis.
  • Followed the four step procedure for building data warehouse solution which comprised of Analyzing Business Processes, Identifying the Grain, then identify Dimensions and Facts.
  • Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
  • Involved in debugging Reports and deploying Reports.
  • Created Tabular Reports, Cross Tab Reports and Sub Reports.
  • Scheduled the Reports to run automatically.
  • Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
  • Used data modeling tool Erwin for creating Logical, Physical data models and DDL’s.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
  • Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Created SSIS packages to migrate data from Oracle DB to SQL Server 2005.
  • Involved in Creating Stored Procedures for Reports generation.
  • Performed Documentation for all kinds of reports and DTS and SSIS packages.
  • Designed and implemented stored procedures and triggers for automating tasks.
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
  • Tested applications for performance, data integrity and validation issues.

Environment: MS SQL Server 2008/2005, ANSI SQL, SSAS, SSIS, BO XI, Informatics, MS SQL Server Reporting Services 2005 (SSRS), COGNOS, DDL, Erwin, SharePoint Moss Server, ASP.Net, ETL, Erwin, C#.Net, SAP, CSS, Java Script, XML, HTML.

Confidential, Boston, MA
Role : SQL developer
Duration : Aug 2008 – June 2009

Responsibilities:

  • Writing stored procedures, triggers, cursors, and views to improve the quality of application, and manage mission-critical information using T-SQL.
  • Develop and support reports built with Microsoft Reporting Services on SQL 2005 SSRS.
  • Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis.
  • Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
  • Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation
  • Ensure that periodic (daily, weekly and monthly) reports are delivered in a timely and accurate fashion using Reporting services SSRS.
  • Using Integration Services (SSIS), built high performance Data Integration Solutions,including extraction, transformation and loading (ETL) packages for data warehousing.
  • Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Migrated data from the DB2 database using SSIS Packages.
  • Optimized performance and capacity planning of various data transformation processes related to the reports.
  • Provided technical support to internal developers and external clients.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Develop and support reports built with Microsoft Reporting Services (SSRS) on SQL 2005.
  • Maintain and monitor the data warehouse to ensure its proper operation, performance and availability.

Environment: SQL Server 2008/2005, SSIS, SSRS, SSAS, MDX, DB2, ETL, Visual Studio.NET, Erwin, DB Artisan, Windows NT/2003, UNIX.

Confidential, Alabama
Role : SQL Server DBA/Developer
Duration : Jan ’06 - July ‘08 .

Responsibilities:

  • Installed SQL server 2000 on windows 2000 server, applied service packs and security fixes.
  • Designed databases for different projects and resolve database issues.
  • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Addressed the Replication Issues. Created new replications, DTS packages to maintain high availability of the data between the servers.
  • Implemented the SQL login security for developers and users.
  • Created DTS packages to pull data from Oracle and Flat Files.
  • Created DDL for physical model using Erwin and handed over to the DBA team.
  • Running DBCC consistency checks, and fixing data corruption in user databases.
  • Involved in planning and monitoring Log Shipping.
  • Used the descriptors for getting the input and output values in ANSI SQL.
  • Planning, Implementing and trouble shooting Replication.
  • Created logical and physical data modeling for development database using ERWIN tool.
  • Creation of schema objects, rules and granting of roles to the users.
  • Worked and coordinated with developers in writing and tuning new stored procedures.
  • Worked on DTS packages to import the data from Oracle, Access and text files.
  • Developed business, database objects and security objects using C# and ADO.NET
  • Used C# for XML web services in project
  • Used CSS (Cascading Style Sheets) for branding purposes and user look and feel.
  • Setting up backups for the newly created databases.
  • Scheduling transfer of backups and log files to different servers.
  • Provided a support for data issues and given appropriate solutions.

Environment: MS SQL Server 2005/2000, MS Access, ANSI SQL, C#.Net, ADO.Net, CSS, Oracle, Windows 2000, XML, SQL Profiler SQL SSIS,SSRS,SSAS, MDX Cubes.

Confidential, India
Role : SQL Server Developer
Duration : July ’03 – Nov ‘05

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 DTS for moving data from MS Access to SQL Server.
  • Managing historical data from various heterogeneous data sources (i.e. Excel, DB2, Access).
  • Assisted the Application team in data modeling and T- SQL coding.

Environment: SQL Server 2000/7, Visual Basic 5.0, DB2, Windows NT, T- SQL, MS EXCEL, MS Access.

Confidential, Hyd - India
Role : SQL Server Developer
Duration : Jan ’03 - May ‘03

Responsibilities:

  • Actively participated in gathering of User Requirement and System Specification.
  • Created new database logical and physical design to fit new business requirements, and implemented new design into SQL Server 2000.
  • Succeeded migrating old data from legacy system into SQL Server 2000 using DTS and Backup and Restore option.
  • Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).
  • Created Users and Roles, and managed security and permission of database.
  • Created stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects.
  • Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2000 Enterprise Edition, .NET, VB, Crystal Reports.

Hire Now