We provide IT Staff Augmentation Services!

Sql Server Developer Resume

Columbus, OH

SUMMARY:

  • Over Seven years of experience in design, development & analysis of SQL Server 7.0/2000/2005/2008 and SQL Server Business Intelligence tools (SSIS, SSRS, and SSAS).
  • Involved in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005.
  • Experience in Up gradation ofSQL Server 2000 databases to SQL Server 2005 and 2008, applying ServicePacks and Hot fixes.
  • Expertise in creating SSIS packages for Extraction, Transformation and Loading (ETL) operations.
  • Experience in Developing, Monitoring and Migration of DTS and SSIS packages as per the business requirements.
  • Designed and developed SSIS packages for loading data from Oracle, text files, CSV files to SQL Server databases.
  • Experience in Deploying the SSIS Packages from development server to production server.
  • Extensive experience in creating and managing reports using MS SQL Server 2005 Reporting Services.
  • Extensively worked on Integration and Reporting services and good experience in data migration from Oracle/Access/Excel sheets to SQL Server 2008/2005/2000.
  • Experience in Administrating the reports to assign permissionto the valid users for executing the reports.
  • Experience in generating Ad-Hoc, Drill down reports using Global Variables and Expressions in SSRS.
  • Extensive experience in Data Warehouse environment.
  • Excellent in developing OLAP cubes by using MSSQL 2005 Analysis Services.
  • Experience in Analysis Services (SSAS) for designing cubes and dimensions.
  • Expert in writing advanced T-SQL queries (DDL, DML).
  • Expertise in Data Modeling using Erwin and MS Visio.
  • Good understanding of ACID properties, RDBMS, Normalization /De-normalization and database modeling.
  • Experience in developing stored procedures, functions, triggers, views, optimizing queries, table normalization
  • Experience in Forward Engineering and Reverse Engineering using Erwin CASE tool.
  • Experience in using DB Tools like Red-Gate Data Generator, Visual Source Safe.
  • Experience in preparing Project Documents, Installation Documents and User Manuals
  • Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS).
  • Excellent knowledge of all the phases of Software Development Life Cycle SDLC.
  • Preparing Test Plans with the help of SQA Teams and conducting Unit, Integration andSystemTesting
  • Good team player and self-starter with excellent communication skills to work independently or as a part of team in Financial , Retail & Healthcare industries.

CERTIFICATIONS:

  • Microsoft Certified Information Technical Professional (MCITP) SQL Sever 2005.
  • Microsoft Certified Technical specialist (MCTS) .Net Framework
  • EDUCATION BS in Computer Science.

    TECHNICAL SKILLS:

    • Operating Systems: Windows 2003/2K/NT/98/95/XP, UNIX
    • Languages: T-SQL,PL/SQL,.NET, C, C++, Java, Visual Basic
    • Web-Technologies: HTML, DHTML, PHP, JavaScript, VBScript, MS FrontPage
    • Database Technologies: SQL Server 2008/2005/2000 /7.0/6.5, MS Access.
    • Tools: Query Analyzer, Enterprise Manager,SSMS,SSIS, SQLProfiler, SSAS, SSRS, Crystal report 8.5/9/10, DTS Packages, BCP, Business Intelligence Studio (BIDS)
    • Web Servers: IIS 5.2/6.2
    • Version Control Tools: Microsoft visual Source safe
    • Data Modeling Tools: MS Visio, ER-Win.

    PROFESSIONAL EXPERIENCE:

    Confidential, Columbus, OH (Jul'08-Current)

    Role: SQL Server Developer Confidential is a high performance organization of dedicated professionals leading Ohioans to achieve optimal health. Confidential and the Office of Vital Statistics are sponsoring a new application called IPHIS (Integrated Prenatal Health Information System). This will streamline the capture, maintenance, and sharing of information related to births in the State of Ohio via a centralized, secure database. The Business is need 24x7 high availability and disaster recovery site for the IPHIS.

    Responsibilities Include:

    • Created Linked Servers between Oracle, SQL Server 2000 and 2005 servers.
    • Responsible for database design using Erwin Tool.
    • Developed SSIS Packages using ADO.NET Connection Manager, OLEDB Connection Manager's to retrieve the ETL data.
    • Involved in Upgradation of DTS packages from SQL Server 2000 to SSIS packages in SQL Sever 2005 database.
    • Deployed the created SSIS packages in Development and Testing environments.
    • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
    • Migrated data from legacy system text based files, Excel spreadsheets and Access to SQL Server 2005 databases using SQL Server Integration Services SSIS.
    • Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
    • Created different reports using complex queries to create the datasets in SSRS.
    • Developed Tabular, Drilldown, Drill Through Parameterized, Ad hoc Reports and Charts using SSRS.
    • Designed and developed Datamart using SSAS.
    • Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
    • Involved in defining the dimensions,fact tables and data loading process.
    • Created MDX queries to retrieve data from the cube and also to generate SSRS reports.
    • Created schema objects like tables, views, indexes. Used DDL and DML for writing triggers and stored procedures.
    • Wrote triggers (After and Instead Of) and stored procedures to capture updated and deleted data from OLTP systems.
    • Conducted Performance Tuning to improve the performance of slow running queries and Stored procedures, like using SQL Server Profiler to trace the slow running activities.
    • I have worked on data access layer using ASP.Net, ADO.Net and C#.

    Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server2005 Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, Oracle9i, XML, ASP.Net , Windows 2003/2000.

    Confidential, Dayton, OH (Aug'07 - Jun'08 ) Role: SQL Server Developer

    Confidential provides award-winning product, service, and training solutions that include a full range of retail and enterprise management systems, Web and Customer Relationship Management (CRM) solutions, learning and consulting services, documents, data management and integration, networking, and hardware leasing services. Confidential serves automotive retailers and OEMs through its partner network, as well as a worldwide consulting practice.

    Responsibilities Include:

    • Involved in different stages of Project Life Cycle.
    • Up graded the databases from SQL Server 2000 to SQL Server 2005 on all domains.
    • Designed Database model of the system using MS Visio.
    • Worked on SSIS packages to import the data from Oracle, Access and text files.
    • Created SSIS Packages using SSIS Designer for export heterogeneous data from Flat file, Excel and Spreadsheet to SQL Server 2005.
    • Designed and migrated all Data Transformation Services DTS Packages to SQL Server Integration Services SSIS and modified the packages accordingly.
    • Worked with different control flow elements like Data Flow Task, Bulk Insert Task,Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
    • Used different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Conditional Split, Derived Column, Pivot etc.
    • Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS. Created Operational reports to improve the operations in the Business.
    • Generated Drill down reports using Report wizard in SSRS.
    • Responsible for deploying reports to Report Manager and Troubleshooting for any errors occurred during execution.
    • Worked with creating MOLAP, ROLAP, HOLAP cubes.Made modifications/and added new MDX queries to cubes.
    • Created Joins and Sub-Queries for complex queries involving multiple tables.
    • Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
    • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
    • Created Clustered and Non-Clustered Indexes for improved performance.
    • Performed optimization of SQL queries in SQL Server.
    • Developed T-SQL queries, triggers, functions, cursors and stored procedures
    • Utilized Erwin's reverse engineering and target database schema conversion process and custom SQL programming.

    Environment: Windows NT/2000 Server, SQL Server 2005/2000,Query Analyzer, SSIS, SSRS, SSAS, Performance Tuning,OLAP, MS Sql Reporting Services, TSQL, DTS.

    Confidential, Huston, TX ( Jan'07 - Jun'07) Role: SQL Server Developer

    Confidential is the leader in information management to the restaurant industry. Confidential turns information overload into informed decision-making. Confidential is a pioneer in delivery of applications over the Internet as an application service provider (ASP). Real-time information pulled from your POS - gives you timely notification of cash overruns, overtime labor exposures or other potential problems before they become major.

    Responsibilities Include:

    • Developed T-SQL queries, triggers, functions, cursors and stored procedures.
    • Upgraded SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages.
    • Created DTS packages for Uploading of Various different format of files and databases to MS SQL using Data Transformation Services (DTS).
    • Conversion of the legacy systems data into MS SQL server using DTS packages.
    • Worked on DTS Package, DTS Import/Export for transferring data from Database
    • Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
    • Created Parameterized reports and Linked reports thorough knowledge of report serving architecture using SSRS.
    • Created Triggers to enforce Data Integrity and Referential Integrity.
    • Designed Cubes, Dimensions with Star Schema using SQL Server Analysis Services (SSAS).
    • Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
    • Designed and developed Star and Snow Flake Schema using SSAS.
    • Managed MDX Cubes and partitioning of cubes.
    • Created the cluster/non-cluster indexes on the tables. Created views, stored procedures, and Triggers.
    • Transferred Flat Files from the old system to the staging area by using BCP and then to SQL Server 2005.
    • Developed Database Objects like User Defined Functions, Tables and Indexes using T-SQL, SQLAnalyzer and Enterprise Manager.
    • Created documentation to install SQL Server, apply service pack, hot fix.
    • Interacted with the users and troubleshooted the problems involved with the development of stored procedures, triggers and problems related to the privileges.

    Environment : T-SQL, SQL Server 2000/2003, ,Query Analyzer, DTS, BCP, Crystal Reports, MS Reporting ,Performance Tuning, Clustering, Bulk Insert, HTML, DHTML, PL\SQL, Windows 2000

    Confidential, Columbus, OH (Apr'05 - Dec'06) Role: SQL Server Developer

    Confidential is one of the leading financial institutions, dealing in businesses such as Credit cards, Mortgages and other financial products including banking. 200 MSSQL Servers and over 300 instances of are installed for business data. Customers access data through various front end applications, Client and the third party tools.

    Responsibilities Include:

    • Involved in Analysis and Design Documentation, gathering User requirements and maintaining good documentation.
    • Implemented Performance tuning in Database level, T-Sql level and operating system level.
    • Responsible for database design using Erwin Tool.
    • Created schema objects like tables, views, indexes.
    • Used all Declarative Constraints for maintaining Data Integrity.
    • Developed Backup and Restore Scripts for SQL Server 2000.
    • Used Enterprise Manager for Job Scheduling.
    • Worked on DTS Package, Import/Export for transferring data from Oracle and Text File toSQL Server.
    • Created DTS Packages to migrate data from various sources to the SQL Server 2000.
    • Used DDL and DML for writing triggers, stored procedures, and data manipulation
    • Created Functions to achieve functionality required by the UI team.
    • Created DTS packages to maintain Central repository.
    • Extensively used different SQL2000 DTS tasks.
    • Used the new features in DTS SQL 2000 and upgraded all the packages. Simplified the DTS functionality by using different tasks in SQL2000.
    • Performed ETL process by pulling large volumes of data using DTS, BCP into the staging database from various data sources like Access, Excel.

    Environment: Windows 2000/NT4.0, MS-SQL Server 7.0/2000, Query Analyzer, Erwin3.5.2/4.0, .Net, vb.net, VB Script, Visual Source Safe , DTS.

    Confidential, India (Jan'02 - Feb'05) Role: Jr SQL Server Developer

    Confidential is one of Asia's leading telecommunications service provider. The Company is India's largest integrated telecom company in terms of customer base and offers Mobile Services.

    Responsibilities Include:

    • Installed and Configured SQL Server 2000/7.0 on windows 2000/NT OS.
    • Created New Databases and maintenance of existing User Databases and System Databases.
    • Implementing Backups and restoring when necessary.
    • Created and modified Clustered and Non Clustered Indexes to optimize the queries using Index Tuning Wizard.
    • Developed DTS Packages to transfer the data between SQL server database and files
    • Creation and management of database maintenance plan for various database consistency Checks.
    • Extracted and transformed data using Bulk Insert, BCP.
    • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
    • Managed users including creation/alteration, grant of system/db roles and permission on various database objects.
    • Managed databases objects like tables, views, indexes.

    Environment: SQL Server 7.0/2000, Query Analyzer, SQL Profiler, T-SQL, DTS, Windows NT, MS Visio ASP.Net, XML, HTML, Windows Server 2000.

Hire Now