SUMMARY

• 8 years of professional experience on Design, Development, and Maintenance of Database using tools of MS SQL Server 2008R2/2008/2005 as a Developer.
• Knowledge of Software Development Life Cycle from requirement analysis to testing phases.
• Knowledge of data base administration, such as backup, recovery, mirroring, replication, and log shipping.
• Experienced in data modeling using Erwin and Visio tools.
• In - depth understanding in Client Requirement Analysis, Physical and Logical Design, Development (using Erwin, Normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support, and Maintenance of business applications using MS SQL Server 2012/2008R 2/2008/2005/2000 , DTS, SSIS, SSRS, and SSAS.
• Experienced in creating complex Stored Procedures, Indexes, Functions, Triggers, Cursors, Tables, Views, and other SQL join statements to assist efficient data manipulation and data consistency.
• Well versed in Data Extraction, Transformation, and Loading (ETL) using various tools, such as SQL Server Integration Services (SSIS), DTS and Bulk Insert and Bulk Copy Program utility.
• Experienced in Deployment and Scheduling of packages using SQL Server Agent.
• Implemented complicated transformations to be used in SSIS packages.
• Supported team in resolving SQL Server Reporting Services and T-SQL related issues and proficiency in creating different types of reports such as Ad-hoc, Cross-Tab, Drill-down, Drill-through, Parameterized, Cascading Parameterized, and Sub reports and formatting them.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, and Scheduling DTS packages.
• Experienced in converting DTS packages to SSIS packages.
• Experienced in installing, upgrading, and configuring Microsoft SQL Server.
• Expert in performing query optimization using SQL Profiler and Index Tuning Wizard.
• Experienced in providing 24x7 support and trouble shoot production issues on high availability systems.
• Organized professional wif excellent oral and written communication skills, excellent presentation skills, interpersonal skills, fast learner; in addition adapt quickly to new technologies wif ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000
• Web Services 2005/2003
• MS-Word
• MS-Excel
• MS-Access
• Outlook
• PowerPoint
• SQL Profiler
• SQL Query Analyzer
• Enterprise Manager
• SQL Server Management Studio
• Business Intelligence Development Studio (BIDS)
• SQL Agent
• OLAP
• Data Transformation Services (DTS)
• SQL Server Integration Services (SSIS)
• Import/Export Data
• Bulk Insert
• BCP
• VB.Net
• Sharepoint
• C++
• Python
• SQL Server Reporting Services (SSRS)
• CSV
• PDF
• Microsoft Visio
• Windows 7
• Windows Vista
• Windows 2000
• Windows XP
• Windows 2003 Server
• Microsoft Office Professional 2010
• Team Foundation Server (TFS).

PROFESSIONAL EXPERIENCE

Confidential, Wayne, NJ

Business Intelligence, ETL Developer

Responsibilities:

• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and tan load intoDimension and Fact tables in Data Warehouse using SSIS.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Developed SSIS packages using for each loop inControl Flow to process all excel files wifin folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Involved in dealing wif off short team
• Created and modified Stored Procedures, Functions, and Indexes
• Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best practices to maintain optimal performance.
• Optimizing query performance wif the help of Execution Plan and SQL Profiler.
• Created and scheduled Jobs using SQL Server Agent
• Used Event Handlers for Exception Handling in SSIS packages

Environment: MS SQL Server 2012/2008R2/2008/2005, Oracle 11g, SQL Server Integration Services (SSIS), Share Point, TDE, SharePoint, C#.Net, ASP.Net, SQL Server Reporting Services (SSRS), Graphical User Interface, DTS, SQL Profiler, DTA.

Confidential, Rockville, MD

MS SQL Server/SSIS /SSRS/SSAS Developer

Responsibilities:

• Installed and configured MS SQL Server tools SSIS, SSAS, and SSRS 2008R2.
• Converting historical reports dat were designed in Actuate Reports to Microsoft SSRS 2008R2.
• Involved in extracting data from heterogeneous sources.
• Designing and developing parameterized, cascading parameterized, drill down, and drill through reports dat included extensive sorting using SSRS.
• Deploying and subscribing reports using SQL Server Reporting Services and Share point
• Involved in dealing wif off short team.
• Created and modified Stored Procedures, Functions, and Indexes.
• Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best practices to maintain optimal performance.
• Created SQL Server Configurations.
• Optimizing query performance wif the help of SQL Profiler.
• Created and scheduled Jobs using SQL Server Agent.
• Used Event Handlers for Exception Handling in SSIS packages
• Generated Production reports, Parameterized reports, and Regular reports using SSRS tools.
• Created Parameterized reports and Ad-hoc reports for higher level managers.

Environment: MS SQL Server 2008R2/2008/2005, Oracle 11g, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Share Point, SQL Server Analysis Services (SSAS), and SQL Profiler, Actuate Report.

Confidential, Irving, TX

MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in Planning, Defining, and Designing data based on business requirements and provided documentation.
• Used SSIS and T-SQL Stored Procedures to transfer data from different sources to staging area and finally transfer into production server.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Developed and deployed Data Transfer Packages to the appropriate destinations using SSIS.
• Created SQL Server ConfigurationsforSSISpackages.
• Responsible for creating reports based on the requirements using SSRS 2008R2.
• Identified the database tables for defining queries to generate reports for analysis of data.
• Defined the report layout and identified Datasets for the report generation.
• Created different type of reports including Cross-tab, Conditional, Drill-down, and parameterized reports.
• Converting DTS to SSIS.
• Designed and created Report Templates, Bar Graphs, and Pie Charts based on the financial data.
• Scheduled the Monthly, Weekly, and Daily reports to run automatically.
• Developed, implemented, and maintained various database objects, such as Stored Procedures, Triggers, Functions, Indexes, and Views.
• Developed and implemented procedures to ensure the quality, usability, and accuracy of reports.

Environment: MS SQL Server 2008R 2/2008/2005/2000 , SQL Server Reporting Services 2008, SQL Analysis Server 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Oracle 11g.

Confidential, Cleveland, OH

MS SQL Server Developer

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2008.
• Created the database for the reporting team for data migration from Oracle Database and flat files into SQL Server 2008.
• Used the Cache Object to stored frequently used items in the server memory for quick retrieval.
• Solved T-SQL performance issues using Query Analyzer and Optimized SQL Queries for improved performance and availability.
• Created and managed schema objects, such as Tables, Views, Indexes, Procedures, and Triggers.
• Created backup and restore operations for migrating database from one server to another.
• Created Database Triggers to implement business requirements.
• Created complex Stored Procedures and Functions to support the front-end application.
• Ensured data recovery, maintenance, and space requirements for physical database.
• Reorganize database structures as needed and automate procedures at regular intervals.
• Optimized long running Stored Procedures & Queries for TEMPeffective data retrieval.
• Extensively used SQL Profiler to identify and repair database lockups, deadlocks, and other issues.

Environment: MS SQL Server 2008, Query Analyzer, Enterprise Manager, DTS Designer, SQL Server Profiler, Index Tuning Wizard, Windows XP, MS Access, MS Word, MS Excel, Visual studio 2005.

Confidential, Addis Ababa, Ethiopia

MS SQL Server /SSRS/SSIS Developer

Responsibilities:

• Involved in logical & physical design, development, and testing of the system.
• Developed complex T-SQL code for the application and implemented constraints on tables.
• Migration of databases from SQL Server 2005 to SQL Server 2008.
• Worked as a developer in creating Stored Procedures, SSIS packages, Triggers, Cursors, Tables, and Views.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Created SSIS packages to extract data from heterogeneous into SQL Server 2008.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Generated reports using MS Reporting services.
• Wrote Parameterized Queries for generating reports using Global variables, Expressions, Data, Defining Data sources and Subtotals for the reports using SSRS.
• Involved in performance tuning using Database Tuning Advisor.

Environment: MS SQL Server 2005/2000, SSIS, SSAS, SSRS, MS Access, Query Analyzer, BCP, SQL Profiler