We provide IT Staff Augmentation Services!

Sql Server Etl Developer Resume

Jacksonville, FL

SUMMARY

  • Over 7+ years of IT working experience in SQL Server database developing and implementing using SQL Server 2008/2005/2000 , Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS) and MDX for data warehouse and data mart solutions
  • Solid experience in database development and support, Database migration, SQL Server 2000 upgrade to SQL Server 2005
  • SQL database design, architecture, data modeling (logical and physical design) using ERWIN and VISIO.
  • Thorough understanding and experience in data warehouse and data mart design, star schema, snowflake schema, normalization and demoralization concepts and principals.
  • Expert in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, and Data Migration projects.
  • Expert in creating Indexes, Views, Triggers, TEMPeffective Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
  • Expert in database activities like Database creation and Maintenance, Performance Monitoring, Tuning and Troubleshooting
  • Expertise in generating reports using SQL Server Reporting Services (SSRS), Crystal Reports and Excel spreadsheet.
  • Developed several complex MDX queries and used those to build the reports by using SSRS.
  • Experience in scheduling and deploying reports on report manger.
  • High availability support for SQL Server Failover clustering, database mirroring, log shipping, replication.
  • Hands on experience on SQL Server Notification Service, Service Broker.
  • Solid experience in software development life cycle and n-tier applications development.
  • Development and programming experience wif ASP.NET, C#, VB .NET, XML, ASP, Access, and VBA.
  • Consistent, well-organized and dependable performer wif the flexibility to adapt to constantly shifting priorities.
  • Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.

TECHNICAL SKILLS

  • MS SQL Server 2008/2005/2000 /
  • Oracle 10g
  • MS Access
  • SQL
  • Transact-SQL (T-SQL)
  • PL/SQL
  • C
  • C++
  • HTML4.0
  • XHTML1.1
  • XML
  • ASP.NET
  • VB.NET
  • Java Scripts
  • VBScript
  • MS SQL Server Integration Service (SSIS)
  • MS SQL Server Analysis Services (SSAS)
  • MS SQL Server Reporting Service (SSRS)
  • SQL Profiler
  • MS SQL Server Index Tuning Wizard
  • Visual Studio 2008/2005
  • DTS
  • Rational Clear Case
  • Clear quest
  • Autosys
  • TOAD
  • SQL *Plus
  • SQL Developer
  • ERWIN
  • Crystal Reports 8.5
  • MS VISIO 2003
  • Cognos
  • UML
  • Windows Server- 2003/NT/XP/2000
  • Windows7
  • MS DOS
  • UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

SQL Server ETL Developer

Responsibilities:

  • Analyzed existing DB2 database (Reporting database) for different stores and documented.
  • Created physical and logical structure of the new data warehouse modules (SQL database) and process work flow by using ERWIN.
  • Created several tables, views and stored procedures using SQL Server 2008 and Toad for SQL.
  • Developed several ETL packages and data flow tasks by using SSIS.
  • Extracted data from DB2 and stored in to SQL Staging tables in BI Staging database.
  • Responsible to extract data from staging to ODS, applying complex transformation and finally loading to DSS after creating Dimensional and Fact tables.
  • Created SSIS (SQL Server Integration Service) packages to extract data from OLTP (DB2) to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
  • Wrote T-SQL queries, Store Procedures.
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
  • Created different data points and pulling those using SSIS package.
  • Responsible to create several SSIS schedule tasks and monitor those tasks regularly.
  • Analyzed the error output and error log of an automated process in case of failure of the process.

Environment: MS SQL Server 2008 R2, SSIS, SSAS, Windows XP, DB2, Toad for SQL, Toad for DB2 4.7, MS Office 2007, Excel 2007, ERWIN, Oracle 10g.

Confidential, NY

MS SQL Server Developer/ETL Developer

Responsibilities:

  • Created DDL scripts to create database schema and database objects
  • Extracted data from Oracle and stored in to SQL Staging tables of staging database (Staging Raw).
  • Responsible to extract data from staging (Staging Raw) to Staging2 (ODS), applying complex transformation and finally loading to Data warehouse after creating Dimensional and Fact tables.
  • Deploy SSIS Package into Production and used Variables to export various package properties to make package environment independent.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy lookups using SSIS tasks.
  • Worked wif T-SQL to create Tables, Views, and triggers and stored Procedures
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Created/Updated database objects like tables, views, stored procedures, function, packages,
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
  • Involved in table and index partitioning for performance and Manageability.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
  • Used SQL Server Profiler to trace the slow running queries and the server activity.
  • Automated and enhanced daily administrative tasks including database backup and recovery.
  • Involved in setting up SQL Server Agent Jobs for periodic Backups wif backup devices, database maintenance plans and recovery.
  • Provided 7 x 24 Production support for the database and application issues.

Environment: Microsoft SQL Server 2008, T-SQL, SSIS, SSRS, SSAS, Erwin, Windows server XP, SQL Profiler, SQL Navigator, Visual Studio 2008, Oracle 8i and 10g, Visual Source Safe.

Confidential, NY

ETL/SSRS Server Developer

Responsibilities:

  • Analyzed existing DB2 database (Reporting database) for different stores and documented.
  • Created physical and logical structure of the new data warehouse (SQL database) and process work flow by using ERWIN.
  • Created several tables, views and stored procedures using SQL Server 2008 and Toad for SQL.
  • Developed several ETL packages and data flow tasks by using SSIS.
  • Extracted data from DB2 and stored in to SQL Staging tables in BI Staging database.
  • Responsible to extract data from staging to ODS, applying complex transformation and finally loading to DSS after creating Dimensional and Fact tables.
  • Created SSIS (SQL Server Integration Service) packages to extract data from OLTP (DB2) to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
  • Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
  • Developing several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS 2008, Excel 2007.
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
  • Responsible to create all the SSRS report using Cube as data source.
  • Developed several complex MDX queries and used those to build the reports by using SSRS.
  • Created different data points and pulling those using SSIS package.
  • Developed several Ad-hoc reports by using MS Excel 2003 / 2007 and automate some of these Ad-hoc reports based upon business demand.
  • Responsible to create several SSIS schedule tasks and monitor those tasks regularly.
  • Analyzed the error output and error log of an automated process in case of failure of the process.
  • Developed high level daily summary report (Flash Report) and monthly business summary report (Monthly Management Report) and distributed these reports across different business units.
  • Responsible to load data from any email attachment to SQL database.

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, Windows Server 2003, DB2, Toad for SQL, MS Office 2003, Excel 2007, ERWIN.

Confidential, Manhattan, NY

SQL Server Developer

Responsibilities:

  • Created Logical and Physical data models using Erwin as data modeling tool.
  • Developed complex Stored Procedures, Functions, SSIS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
  • Designed and implemented stored procedures and triggers for automating tasks.
  • Tested the reports and fixed bugs in Stored Procedures, Tables and Triggers.
  • Schedules and performed data transfers using SSIS including filtering appropriate to the data mart for data analysis
  • Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, SSIS, Instances, Linked Servers and Indexes.
  • Re-hosted Variable Annuity processing system to run on SQL Server.
  • Compressed data files by removing empty database pages and updating index statistics.
  • Configured snapshot replication for reporting, user acceptance test and development servers.
  • Developed and edited many reports wif SSRS.
  • 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 and batch queries.
  • Planned the complete back-up of databases for disaster recovery scenarios.

Environment: Windows 2003 server, Microsoft SQL Server 2008, Microsoft Access, SQL Server Profiler, SSIS, BCP, SSRS.

Confidential, Wayne, NJ

SQL/ETL/SSRS Server Developer

Responsibilities:

  • Involved Logical, Physical design and Development of the DSR (Data Staging Repository) for Beacon Database and AMS (Asset Management Reporting System) using Erwin.
  • Define Check constraints, Business Rule, Indexes and Views.
  • Worked wif data modeling product support team on tool features, functionality and maintenance.
  • Installed SQL Server 2005 and Management tools using SQL Server Setup Program.
  • Design and develop SSIS (ETL) packages for loading data from ERP(ORACLE APP) & EDI system, DSR (Staging Database) to Beacon Database & AMS
  • Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
  • Perform T-SQL tuning and optimizing queries using SQL server 2005.
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the ERP & EDI system, DSR to SQL server.
  • Schedule Jobs to run SSIS package in night feed to Beacon Database and AMS for fresh day data.
  • Load data form Beacon database to Data warehouse using SSIS packages.
  • Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
  • Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
  • Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using SSRS.
  • Created ABC Reports, ATS (Available to ship), Forecast consumption, Warehouse, Backlog, and Stock High Low Reports Using SSRS
  • Run Import/export wizard to provide CSV and Excel files to mangers for the particular records they want for different meetings.
  • Created Cubes i.e. Material Cube, Forecast cube and Stock cube using SSAS.
  • Responsible for Backup and Recovery Strategy and Planning.
  • Develop Technical Design and code for the interface required to support the development of in-bound feed for beacon database.
  • Provided 7 x 24 Production support for the database and application issues.

Environment: SQL Server 2005, ETL/SQL Server Integration Services (SSIS), MS Excel 2007, Electronic Data Interface (EDI), ORACLE Apps, Management Studio, MS SQL Query Analyzer, SQL Profiler .Database Tuning Advisor, SSRS and SSAS

Confidential, East Hanover, NJ

MS SQL Server Developer/ SSRS, SSIS, SSAS

Responsibilities:

  • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
  • Extensively involved in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
  • Extensively used T-SQL statements and created multidimensional cubes for the analyzer and used pivot table to halp the end-user get familiar wif cube.
  • Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
  • Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
  • Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
  • Created the structure of the model and cube in SSAS and reviewed Cube wif end user and changed the cube and documentation according to their requirements.
  • Extensively involved in migration of data from MS SQL 2000 to MS SQL 2005.
  • Monitored performance and optimized SQL queries for maximum efficiency using SQL Profiler.
  • Involved in gathering and analyzing business requirements for reporting purpose.
  • Created dashboard pages that use Excel Web Access Web parts and Reporting service Web parts.

Environment: MS SQL Server 2000/2005, MS SQL Server Integration Services 2000/2005, SSRS, SSAS, T-SQL, MDX.

Confidential

Database Developer

Responsibilities:

  • Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
  • Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Configuring, tuning, and optimizing SQL Server 2000/2005.
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
  • Transformed data from various data sources using OLE DB connection by creating various DTS packages.
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Proactive and Reactive tuning of databases in every stage of the project.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
  • Developed Reports to generate daily, weekly, monthly, yearly Reports using Crystal Reports.

Environment: Microsoft SQL Server 2000/2005, Windows XP, Crystal Reports.

Hire Now