We provide IT Staff Augmentation Services!

Ms Sql Server Developer Resume

Rhode Island, RI

TECHNICAL SKILLS:

  • Develop, modify and optimize SSIS packages
  • SQL 2005
  • SQL 2008
  • Experience building SSIS packages using built - in SSIS components
  • Experience writing complex T-SQL
  • Experience analyzing, profiling, manipulating data from a large variety of sources
  • Experience loading data into a SQL Data Warehouse
  • Troubleshoot abstract data, profile, analyze and optimize data
  • Develop error checking and resolution routines
  • Data modeling experience
  • Analyze and optimize table design

PROFESSIONAL EXPERIENCE:

Confidential, Rhode Island, RI

MS SQL Server Developer

Responsibilities:

  • Involved in the migration of databases from MS SQL 2005 to MS SQL Server 2008 and managed indexing, debugging, optimization and performance tuning using SQL Profiler and SQL Server Agent.
  • Created Logical and Physical data models using ERWIN.
  • Developed Functions, packages, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications. Designed and implemented stored procedures and triggers for automation tasks.
  • Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files
  • Designed and implemented user log in and security.
  • Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling.
  • Implemented Data modeling techniques and table design.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse.
  • Developed and deployed data transfers packages to the appropriate destinations using SSIS.
  • Created SQL server configurations for SSIS packages and experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
  • Identified the database tables and created reports based on the business requirements using  SSRS 2008 Report Builder.
  • Created various reports including Cross-tab, Conditional, Drill-down, Sub reports, parameterized reports and also created number of complex formulae in sub report.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically.
  • Implemented error checking and resolution routines
  • Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
  • Implemented Star Schema for OLAP cubes using SSAS.
  • Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.

Environment: MS SQL Server 2008/2005, T-SQL, SSRS/SSIS, MS Excel, MS Access, Windows 7, SQL Plus

Confidential, Austin, Texas

MS SQL Server Developer

Responsibilities

  • Installed SSRS 2008 and upgraded SQL 2005 to 2008
  • Performed dimensional Modeling and created data warehouse using the Kimball and hybrid methodologies
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Developed T-SQL automation scripts for SQL Server database, as well as Excel-VBA scripts to communicate with SQL Server
  • Identified the data source and defined them to build the data source views.
  • Spearheaded the QA process for the data and coordinated the push to Production for these departments as well.
  • Moved data from the FTP server and loaded the Data Warehouse with the help of complex SSIS packages and then reports created from the DSS DB
  • Implemented Data modeling techniques and table design.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, tables, views and other SQL joins for Marix Central.
  • Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation
  • Organized a team that redesigned an extensive yet archaic reporting system to use data warehousing and OLAP on SQL 2008 with a web front-end. Created data warehouse and several star schemas from OLTP data with extensive use of SSIS. Over 20 cubes were created and used.
  • Implemented Data modeling techniques.
  • Use ActiveX scripts within SSIS for complex maneuvers. Exploring solutions employing custom tasks (COM objects using SSIS)
  • Implemented ETL framework and developed solutions with SQL Server Integration Services
  • Designed and implemented stylish report layouts, and related MS SQL Server Reports and Dashboards using SSRS 2008. .
  • Wrote Query for generating drill down reports, standard, ad-hoc and parameterized reports in SSRS 2008.
  • Modified the Report Data Source Properties
  • Implemented error checking and resolution routines
  • Monitor existing usage and growth of the Regional Data Mart, and central Data warehouse
  • Maintain Database Backup/Restore (Daily, Weekly, and Monthly), maintain Standards and procedures
  • Monitored and administered critical database servers, supported real-time data replication, established robust installation, Upgrade, Backup, Maintenance, Archive and Disaster Recovery plans

Environment: MS SQL Server 2005, SSRS 2005, SSIS 2005, and ERWIN

Confidential, Chicago, IL

BI Developer

Responsibilities:

  • Designed and developed database models with MS Visio, that can handle fulfill client’s dynamic reporting need
  • Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems
  • Completed T-SQL stored procedures that are consumed by SSRS
  • Designed and implemented reports with different layouts using SSRS 2005 and exported them into Excel, PDF and HTML.
  • Created SSIS package to load data from Flat File, CSV File, and Oracle to Data warehouse and Report-Data mart and applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, Pivot Transformation, and Merge Joins in SSIS R2/2005.
  • Designed reports with interchanging features based on selection criteria or report detail display.
  • Defined parameters for parameterized reports inclusive of complex default parameters and cascading parameters.
  • Installed SSRS 2008 and upgraded SQL 2005 to 2008
  • Implemented Data modeling techniques and table design.
  • Interacted with SharePoint 2007 to manage reports in development, test and production
  • Created Cascading parameters, Drill thru Reports, and sub report for reports.
  • Implemented error checking and resolution routines
  • Generated views to allow for centralized stored procedures to generate both live and archive reports
  • Generated reports that exported report headers/parameter info to the header section of Excel to eliminate cell merging.
  • Designed reports with interchanging features based on selection criteria or report detail display.
  • Performed Report Testing and Verification as per Internal Reporting system requirements
  • Designed the Security for the reports in the report manager, assisted in development of AD groups required to run reports
  • Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS)
  • Implemented Star Schema for OLAP cubes using SSAS

Environment: MS SQL Server 2005, SSRS 2005, SSAS 2005, Microsoft VSS, MS SharePoint 2007

Confidential, New York, NY

MS SQL Server/ SSRS Developer

Responsibilities:

  • Performed tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS
  • Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS
  • Created ETL packages to transfer data from multiple environments.
  • Loading Test Data into the database utilizing SSIS.
  • Created report templates to accommodate multiple reports in the future.
  • Extracted data using XML Web Service data sources in SSRS Designer.
  • Embedded various images within complex tabular reports based on conditions written in expressions
  • Designed and developed SSIS packages for Historical Load and Incremental Load (Daily Updates) to feed the data warehouse.
  • Created Side by Side reports and parameterized reports in SSRS 2005 and wrote expressions to execute complex reporting requirements.
  • Completed T-SQL stored procedures that are consumed by SSRS
  • Implemented error checking and resolution routines
  • Designed reports with interchanging features based on selection criteria or report detail display such as report layout, margins, color schemes, font selection, border style, padding and chart selection.
  • Created multiple data sources and datasets to use within a single report.
  • Installed SSRS 2008 and upgraded SQL 2005 to 2008
  • Migrated reports through the stages of development (including System Test, Model Office and Production).
  • Went through the QA process with some departments before deployment to the production environment.
  • Defined parameters for parameterized reports inclusive of complex default parameters and cascading parameters.
  • Implemented Data modeling techniques and table design.
  • Worked as a developer in creating Stored Procedures, functions, views and other SQL joins and statements associated with reports.

Environment: MS SQL Server 2000/2005, MS SQL Server Reporting Services 2000/2005, SSIS, SSAS, and C#.

Confidential, San Jose, CA

MS SQL Server Developer

Responsibilities:

  • Created ad-hoc, parameterized, drill down and cascaded parameterized reports in Crystal Reports.
  • Extracted data from Oracle and migrated data from various sources (text based files, Excel spreadsheets, and Access) into SQL Server DTS
  • Responsible for transferring packages using DTS on to production Server.
  • Designed, Developed and Deployed reports in Crystal Reports.
  • Implemented error checking and resolution routines
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and worked with database objects like Tables, views and indexes.
  • Implemented Data modeling techniques and table design.
  • Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
  • Monitor existing usage and growth of the Regional Data Mart, and central Data warehouse
  • Completed T-SQL stored procedures that are consumed by SSRS
  • Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.

Environment: Windows XP, MS SQL Server 2000, Crystal Reports, DTS, Excel, Acrobat Reader.

Hire Now