We provide IT Staff Augmentation Services!

Sql Developer Resume

Dublin, OH

Summary

  • 7+ Years of extensive experience in data warehouse complete life cycle using SQL Server 2005, SQL server 2008 suite of products SSIS, SSAS and SSRS
  • Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration
  • Experience in writing complex Stored Procedures, Indexed views and triggers for data consistency and manipulation.
  • Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Hands on experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
  • Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
  • Strong understanding of finance module and loan center application. Performed dynamic calculations, developed, reviewed, and optimized queries in SQL Server.
  • Good Knowledge in creating cubes and dimensions, handling multi dimensional reports.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2008/2005).
  • Worked with writing the ETL process to implement the hybrid data environment using SSIS and custom query.
  • Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services.
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
  • Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2008/2005
  • Skilled in sorting the data and defining subtotals for the reports.
  • Good Knowledge in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
  • Good Knowledge in Kalido tool for Master Data Management.
  • Experience in Documenting Existing Process, Creating and Analyzing Business Requirements, Functional and Technical Documents.
  • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.
  • Self-motivated, diligent with the ability to quickly adapt to new environments and changes

Technical Skills:

Languages: SQL, T-SQL, PL/SQL. C, C++, VB 6.0, HTML, XML, JavaScript Databases:SQL Server 2005/2008/R2, Oracle 9i/8.x, DB2 MS Access Reporting Tools:SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9 ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services) Other Software:MS Office- 2010/2007/2003, Adobe Professional Operating Systems:Windows /98/2000/2003/XP/Vista/7 Database Tools:SQL Plus, TOAD Methodologies:Logical and Physical Database Design, UML

Professional Experience:

Confidential Feb 2010 - Till Date DUBLIN, OH Role: SQL Developer Confidential is a leading asset-light based transportation and logistics services provider. Within North America, Pacer manages one of the most comprehensive double-stackintermodal networks with more than 100,000 route miles of double-stack rail operations, integrated with a nationwide truckdrayagenetwork for door-to-door service delivery. Pacer accounts for about 20% of all domestic intermodal container moves in the U.S. and is the largest single provider of intermodal container services between the U.S. and Mexico. Confidential also provides an array of other transportation services including truck services and brokerage, flatbed/specialized trucking, international ocean shipping and freight forwarding, warehousing and distribution, and transportation management. Responsibilities:

  • Actively participated in gathering Business Requirements and System Specification from system users.
  • Implementation of MS SQL Server Management studio 2008 to create Complex Stored Procedures using T-SQL to evaluate result for the reports.
  • Developed different Scripts for the Data analysts for verification of reports.
  • Responsible for performing T-SQL tuning and optimizing queries for reports which take longer time in execution with SQL Server 2008.
  • Utilized Pivot tables to provide structure to Reports in proper format like months etc.
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert for ETL purposes.
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
  • Involved in writing MDX queries for cubes in Business Intelligence Development Studio (BIDS), deploying them on the server.
  • Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
  • Modified the current database by removing unwanted columns and also adding proper constraints, rules and defaults to tables
  • Created Indexes on tables for new database to faster retrieval of data for the Reports.
  • Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution
  • Used SSRS 2008 to create customized reports and ad hoc reports.
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
  • Generated DTS packages to schedule migration for old system data to a new system and verify by making different reports on new system
  • Converting all existing DTS package old system to new system by adding extra SSIS task.
  • Develop backup & restore scripts for SQL Server as needed

Tools and Technologies: Microsoft SQL Server 2008 Enterprise Edition, Microsoft SQL Server 2008 R2, SQL Server Reporting Services 2008 (SSRS), Management studio, XML, VB.net, SQL Server Integration Services (SSIS), Windows Server XP and MS EXCEL.

Confidential, Chattanooga, Tennessee Jan 2009 - Jan 2010 Role: SQL Server Developer Worked with Health Care Data Analytics team. Activities included gathering requirements from end user groups and report design and generation using Crystal Reports and Customized Reports. In addition, was responsible for optimization of stored procedures and backup and recovery activities. Responsibilities:

  • Used SSRS to create customized reports and ad hoc reports.
  • Implementation of MS SQL Server Management studio to create Complex Stored Procedures using T-SQL to evaluate result for the reports.
  • Developed different Scripts for the Data analysts for verification of reports.
  • Responsible for performing T-SQL tuning and optimizing queries for reports which take longer time in execution with SQL Server 2005.
  • Utilized Pivot tables to provide structure to Reports in proper format like months etc.
  • Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
  • Modified the current database by removing unwanted columns and also adding proper constraints, rules and defaults to tables
  • Created Indexes on tables for new database to faster retrieval of data for the Reports.
  • Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution
  • Loading data to the destination base tables.
  • Involved in Data scrubbing, and scheduling SSIS packages .
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
  • Involved in developing and modifying XML reports for exporting the reports to web application.
  • Generated DTS packages to schedule migration for old system data to a new system and verify by making different reports on new system
  • Converting all existing DTS package old system to new system by adding extra SSIS task.
  • Develop backup & restore scripts for SQL Server as needed

Tools and Technologies: Microsoft SQL Server 2005 Enterprise Edition, SQL Server Reporting Services (SSRS), Management studio, XML, SQL Server Integration Services (SSIS), Windows Server 2007

Confidential, WA Jan 2008 - Dec 2008 Role: SQL Server Developer Confidential is a consumer-governed, nonprofit health care system based in Seattle,Washington and provides operational outsourcing solutions and information systems for health plans, providers andinsurers. Responsible for loading the data and to support the software development team by providing tuned queries. Generated crystal reports. Responsibilities:

  • Created schema modification scripts to implement the logical design into SQL Server 2005
  • Responsible for ODS production support and helpdesk.
  • Participated in the migration of ODS from SQL Server 2000 to SQL Server 2005 and in converting DTS packages to SISS package.
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert for ETL purposes.
  • Involved in the troubleshooting of Database performance issues and implementing necessary DB changes.
  • Responsible for developing reporting stored procedures and ad hoc reports using Crystal Reports.
  • Responsible for creating Test Cases, Test Plans and Release Notes.
  • Developed, tested and implemented robust Disaster Recovery Plan.
  • Planning and scheduling backup strategy to ensure reliable backup.
  • Developed DTS packages to load policy feeds onto ODS.
  • Involved in building an extensive OLAP data warehouse on SSAS (Cubes, star schema)
  • Responsible for developing and maintaining ODS run book

Tools and Technologies: SQL Server 2000, SQL Server 2005, Management Studio, SSAS, SSIS, SSRS, OLAP, Crystal Report 10 & Windows 2000/NT,OLTP, ASP.net, VB.net, UML, MS ACCESS, MS EXCEL.

Confidential, Charlotte, NC. Jan 2007 - Dec 2007 Role: SQL Server Developer The project, Customer Information System (CIS), keeps track of bank's NC region database. My team was responsible for separating customers based on the customer details and their business side view. My role in the application was to collect the data from various heterogeneous data sources like Web, Flat files, etc., and use them for further processing according to the business needs. Responsibilities:

  • Create Database objects including Tables, Triggers, Views, Stored Procedures, Data Modeling, Indexes and Rule.
  • Set Database access privileges for different Users and User Groups.
  • Perform optimization of SQL queries in SQL Server.
  • Import Data from MS-Access Database and XML to SQL Server Database.
  • Maintenance of Clustered and non-Clustered Indexes.
  • Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
  • Create DTS Packages in SQL Server Database.
  • Perform database consistency checks at regular intervals.
  • Monitor SQL Server activity through profiler.
  • Develop backup & restore scripts for SQL Server as needed.
  • Design and implementation of database maintenance plan
  • Performance optimization and normalization of database
  • Tuning and optimizing queries and indexes.
  • Job, Scheduling, batch, alert and E-mail notification setting.
  • Monitor SQL Server log files.

Tools and Technologies: SQL Server 2000, MS-Access, MS Excel, XML, TSQL, Stored Procedures, Triggers, Views, Crystal Reports and Visual SourceSafe

Client: Confidential, Gujarat, India Jan2003 -Nov 2006 Role: MS SQL Developer Confidential is a diversified business corporation with a balanced portfolio of assets straddling the manufacturing and services sectors: Steel, Energy, Power, Shipping, Communication, Logistics and Construction information. The project involved migration of the existing database in MS Access to MS SQL Server 6.5. As a SQL developer, the job involved planning & administration of the entire migration and worked on the tuning aspects to achieve an efficient & cost effective system. Worked on optimizing the existing SQL queries and improved the performance of the system. Responsibilities:

  • Installation, Configuration and Maintenance of MS SQL Server 2000.
  • Held in charge of analysis, design and development.
  • Gathered functional requirements and written the technical specifications
  • Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
  • Wrote T-SQL statements using DML and DDL for retrieval of the data.
  • Created complex stored procedures, triggers and cursors in SQL Server.
  • Extensively Involved in Designing (Logical and Physical) of Databases.
  • Created & managed the Database Users, Login Ids and Security.
  • Created database objects like tables, views, indexes etc.
  • Created and modified stored-procedures, triggers, cursors.
  • Wrote T-SQL for the retrieval of the data.
  • Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
  • Used SQL Profiler for getting the trace activity for the Various Stored procedures and used Index Tuning wizard for performance betterment.
  • Checked Performance Tuning, Indexing, Query Optimization.
  • Used database consistency checks using DBCC Utilities.
  • Developed source to target specifications.
  • Created Databases, Tables, Views and Indexes.
  • Created DTS Packages to import data from Excel spreadsheets.
  • Used DTS to created jobs to populate some of the tables with data from other servers.
  • Good exposure in running jobs in Enterprise Manager using job-scheduling tool.
  • Performed Database Backup and recovery strategies.

Environment: MS SQL Server 2000, MS Access, Erwin 4.1, DTS, SQL Profiler, Query Analyzer, MS SQL Server 7.0/6.5, T-SQL, windows 2000.

Education: Bachelors of Engineering in Computer Science.

Hire Now