SUMMARY:

• Over 8+ years IT experience in Database Design, Development and Implementation of SQL SERVER 2012/2008R2/2005 and providing ETL/Business Intelligence applications using Microsoft components.
• Effectively involved in all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects.
• Extensive SQL Development experience in a Banking & Healthcare environment with a strong understanding of data & analytics.
• Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS and SSIS with MS SQL 2012/2008R 2/2008/2005/.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Expert in using SQL Server Agent to Schedule and monitor Jobs.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMF’s and Query Execution Plans.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
• Extensively worked on developing and deploying applications using SQL Server 2012/2008R2/2008 Microsoft office, VBA and macros.
• Expertise in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.
• Expertise in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports.
• Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms.
• Strong Experience in Unit, Integration and System Testing.
• Good Knowledge in designing Database Models using UML, MS Visio and Erwin.
• Developed Reports using Telerik Reporting.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS:

Languages: C#, T-SQL, Java.

Web Technologies: HTML, DHTML, ASP.Net, XML, Java Script and VB Script, VBA.

RDBMS: SQL SERVER 2012/2008 R2 R 2/2005 / 2000 / 7.0, MS-Access.

Front End: MS Visual Basic 6.0OLAP Tools: MS OLAP Services ManagerVersion Control Tools: Visual Source SafeWeb Server Technologies: IIS 5.1/6.0/7.0/8.0Reporting Tools: Crystal Reports 8,9,10Microsoft Reporting services: 2008/2005/2000SharePoint: WSS 2003/MOSS 2007/O14Modeling Tool: Microsoft Visio, Erwin.

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

SQL BI SSIS /SSRS/SSAS Developer

Responsibilities:

• Worked as a database developer on databases like MS SQL Server 2008R2 using T-SQL, stored procedures and views to get data from Data warehouse.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Created Excel including pivot tables, macros, and lookup functions to format a data set from the various SQL sources.
• Communicated with various data sources by using VBA code Macros.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Updated functional specification and technical design documents.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Created SSIS packages to automate maintenance, database backup and restoration, update statistics, re-build indexes as well as create error log for event during data load.
• Create data filter function and data manipulation functions to extrapolate data.
• Generated daily, weekly and monthly reports using SSRS 2008.
• Served as a SSRS 2000 Reports Developer and SQL Server Developer in support of Service Management System.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Experience in Creation and data visualization including dashboards and reports leveraging charts (Pivot tables), gauges and drill-through.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS using Visual Studio 2010.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Tools: & Technologies: SSIS, SSRS, MS SQL Server 2012, 2008, 2008R2/2005, C#, VBA, SharePoint, Visual studio 2008/2010, MS Access, MS Excel, Excel Pivot Tables, MS Office Access 2007, Telerik RAD Controls.

SQL BI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed logical and physical database (using ER-win, Normalization, Dimension Modeling and Enterprise Manager).
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Made sure that standards and best practices in database development were followed and maintained.
• Defined and designed the data sourcing and data flows, data quality analysis
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for creating batch file to deploy various database objects such as tables, stored procedures, indexes in various environment using SSIS.
• Used SQL Server Agent to automate the SSIS 2008 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005/2008 and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
• Tested and managed the SSIS 2005 and SSIS 2008 packages and was responsible for its security.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Tools: & Technologies: SQL Server 2008R2, SSIS, SSRS, SSAS, Windows2008R2/ 2012, Visual Studio2010, C#, VBA, MS SQL Server 2005/2008, MS Access 2000, Erwin v7.0, T-SQL, MS-Excel, MS-Access, SQL Server Management Studio, MS SQL Profiler

SQL/ETL/ SSIS/SSRS/SSAS Developer

Responsibilities:

• Maintained databases, performed software installations and monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Studied detail changes that need to be made to each business process that is performed by all the systems impacted.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Implemented automated backup and database maintenance / cleanup jobs.
• Generated Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through SQL Server Agent.
• Designed SSIS packages for loading data from ODS to Data mart.
• Created SSIS packages for synchronizing the data between two different servers.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Generated Ad-hoc reports and cascading reports for historical data using SSRS.
• Involved in the implementation of Performance Point Server (PPS).

Tools: & Technologies: SQL Server 2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), Windows 2000/XP, ProClarity, SharePoint services, Erwin, VBA.

Confidential, Addis Ababa, Ethiopia

SQL Server Database 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.
• 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 2005.
• 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.

Tools: & Technologies: MS SQL Server 2005/2000, SSIS, SSAS, SSRS, MS Access, Query Analyzer, SQL Profiler.