Sql Server (dba) /bi Developer Resume
Richardson, TexaS
SUMMARY
- Having 5+ years of IT experience in Development and Support of MS SQL Servers 2008 R 2/2008/2005/2000 DTS/SQL Server Integration in Production, QA and Development environments.
- SQL Development experience in Manufacturing,FinanceandHealthcareindustries with a strong understanding of data and analytics.
- Good Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
- Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions,Extract, Transform and Load (ETL)solutions for Data warehousing applications.
- Experience in creating packages to transfer data between MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS, FTP task to transfer data to local and remote Servers.
- Extensive experience in usingT - SQL creatingTables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined FunctionsandData Integrityin observing Business Rulesin SQL Server 2008/2005platforms.
- Experience in providingLogging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Extensive experience in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reportsusingSQL Server Reporting Services.
- Excellent inrendering reports, managing subscriptions,creating reports with report builder, report snapshot and report cache.
- Hands on experience on SQL Profiler, Windows Perform, Performance Counters and SQL server logs for Monitoring and Tuning SQL Server.
- Extensive experience in creating and maintaining Data flow diagrams and Entity Relationship Diagrams using Erwin.
- Good knowledge of high availability SQL Server solutions using active-active and active-passive Clustering modes.
- Successfully implemented and supported Database Transactional and Snapshot Replication methods.
- Good communication, interpersonal and business analysis skills.
TECHNICAL SKILLS
Databases: MS SQL Server 2008R2/2005/2000, MS Access, Oracle 10g
Programming Languages: SQL, T-SQL
Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook
Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTSImport/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS 2008/2005, SSRS 2008/2005, Index AnalyzerETL Tools DTS 2000, SSIS 2008R2/2008/2005, Reporting Services (SSRS)2008R2/2008/2005, SQL Server 2008R 2/2005/2000.
PROFESSIONAL EXPERIENCE
Confidential, Richardson, Texas
SQL Server (DBA) /BI Developer
Responsibilities:
- Managing all stages of the application from design, development, testing and deploying on Development, Testing and production environments.
- Gather Requirement needed for the Migration project from the Business users to create Functional specification documents
- Created ETL packages using Heterogeneous data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
- Manage process, coordination and scheduling of ETL data loads
- Provide monitoring and support for the intake and export of data
- Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements
- Generated several backend database objects for weekly, monthly, quarterly, yearly, parametric, Congo’s reports.
- Maintain documentation of ETL process and support procedures for each client
- Actively supported business users for change requests.
- Managing all stages of the application from design, development and testing on both development and production environments.
- Developed complex stored procedures to create various reports.
- Create joins and sub-queries for complex queries involving multiple tables.
- Scheduling Jobs to execute SSIS packages.
Confidential, Columbus, OH
SQL Server /BI Developer
Responsibilities:
- Managing all stages of the application from design, development and testing on both development & production environments.
- Involved in gathering and analysis of user requirements.
- Involved in creating of T-SQL Stored Procedures, Table Value Types, Table Value functions and Views.
- Involved in performance tuning of T-SQL queries and Stored Procedures.
- Identified slow running query using SQL Profiler and optimization of stored procedures using Tuning Advisor and execution plan.
- Create joins and sub-queries for complex queries involving multiple tables.
- Design and develop ETL patterns for initial and incremental load in Data Warehouse and Datamart.
- Optimized existing ETL using transformation like: merge join, conditional split and OLEDB command.
- Implement parallel data processing by increasing buffer space and engine threads.
- Deployed SSIS packages into different environments using config files and deployment wizard.
- Developed complex stored procedures to create various reports.
- Created and formatted parameterized reports for clients and end users and deployed them on server using SQL Server Reporting Services (SSRS).
- Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
- Created Drill-down, Drill-through, Parameterized, dash board, calendar and Sub-Reports using SSRS.
- Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
Environment: MS SQL Server 2008/2012, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, C#, SQL Profiler.
Confidential, Columbus, Ohio
BI Developer
Responsibilities:
- Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
- Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
- Drop and recreate index on the DSS system while data migrating.
- Schedule jobs to run SSIS package in night feed to DSS system for fresh day data.
- Used DTS migration wizard to convert DTS to SSIS packages and develop new SSIS packages.
- Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and Scripts.
- Gather Requirement needed for the Migration project from the Business users to create Functional specification documents
- Designed and developed SSIS Packages, Stored Procedures, Functions based on the existing Oracle Environment
- Manage process, coordination and scheduling of ETL data loads
- Wrote documentation for the packages and scripts and job created for migrate data.
- Provide monitoring and support for the intake and export of data
- Converted the Oracle Reports to SSRS reports
- Generated several weekly, monthly, quarterly, yearly, parametric, drilldown and chart reports using SQL Server Reporting Services (SSRS).
- Report issues or delays with data loads to internal/external clients
- Troubleshoot and identify issues with ETL data, file formats and jobs
Environment: Microsoft SQL Server 2008R2 Enterprise edition, SISS, SSRS, BIDS, visual C#, Oracle 10g, Toad and Erwin.
Confidential, Tallahassee, Florida
SQL Server Developer
Responsibilities:
- Worked in the enhancement of an overall initiative in improving an internal custom built Datamarts that supported and provided homeward executives, senior managers, and business analyst with analytical reporting capability.
- Extensively used SSIS for performing the ETL operations, using visual C# to validate the source data.
- Designed and developed Stored Procedures, Functions (UDF), Views, Joins and Sub queries to support the ETL Rule component for the merger process.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
- Experience on created reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports
- Involved in the performance tuning and DB optimization of SQL queries.
- Actively supported business users for change requests.
- Implemented agile project methodology and involved in estimations for each sprint, and provided status in scrum meetings.
Environment: Microsoft SQL Server 2008R2 Enterprise edition, SISS, SSRS, BIDS, visual C#, .Net frame work 3.5, Oracle 10g, XML, Toad, Windows server 2008, MS Excel 2007 and Erwin.
Confidential, Aurora, Illinois
SQL server Developer
Responsibilities:
- Worked closely with the end users in writing the functional specifications, Design (LLD), Developing, Testing and Maintenance based on the business needs.
- Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
- Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Defaults and complex SQL statements.
- Generated different transformations for loading the data into target like Source Qualifier, Connected Lookup, Unconnected Lookup, Rank and Expressions.
- Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages.
- Participated in error handling and troubleshooting using various log files.
- Involved in creating Logical and Physical data models using Erwin.
- Created various complex reports and manage those using SQL server reporting services.
- Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
- Involved in performance and tuning the ETL processes.
Environment: Microsoft SQL Server 2008R2 Enterprise edition, SISS, SSRS,BIDS,.Net frame work 3.5 Microsoft Visual studio, Windows server 2008 and MS Excel 2007
Confidential, Cleveland, Ohio
SQL server Reporting Developer
Responsibilities:
- Responsible for logical and physical design of SQL Server databases.
- Alter the schema for the required objects.
- Used DDL and DML for writing triggers, stored procedures, and data manipulation.
- Created views to restrict access to data in a table for security.
- Performed Bulk data migration using DTS and SSIS from flat files.
- Identified the Data Source and defining them to build the Data Source Views.
- Identified and defined the Datasets for report generationand also included report parameters.
- Make recommendations for File group Creation and Placement.
- Scheduling backups and automating weekend maintenance tasks.
- Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
Environment: SQL Server 2000/2005, SQL Server Integration Services, MS Excel 2003/2007, MS Access 2003, Management Studio, SQL Profiler and SSRS.