Gaithersburg, Maryland 240-***-**** email@example.com
* ***** ** ********** ** Database Design, Development & Administration of MS SQL Server 2005/2008/2012/2014.
Experience in all phases of the Software Development Life Cycle (SDLC).
Proficient in relational database modeling(Conceptual, Logical and Physical Modeling) and normalization
Excellent knowledge in Relational database concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types,
Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers
Designed Data Mapping documents, DDL scripts, Data Dictionary and Meta data of the models
Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity,
SQL joins and Query Writing.
Experienced in SSIS\SSRS\SSAS, building static, dynamic and interactive reports using BIDS and Report Builder.
Experienced in ETL from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.
Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures
Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS.
Experienced in designing Star, Snow flake Schemas and OLAP cubes.
Experienced in migrating data from one SQL Server version to another.
Highly experienced in database server performance tuning and optimization of Complex SQL queries.
Experienced in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring.
Team player who has capability to work with business users, project managers, team leads and architects
Flexible and versatile to adapt to any new environment and work on any project.
Ability to use Geographic Information Systems and applications including but not limited to MapInfo, Google Earth, Microsoft MapPoint and Arc-View
TOOLS AND TECHNOLOGY
RDBMS: SQL Server 2005/ 2008/2008R2/ 2012/2014 and SQL Azure
Database/ETL Tools: SSIS, SSAS, SSRS
Reporting: SQL Server Reporting Services (SSRS)
Languages: VB.NET, C#, C++, T-SQL, E-SQL
MS-Office: Microsoft Office Tools
Operating Systems: Windows Server 2000, 2003, 2005, 2008, 2008R2, 2012
Tools: Lite Speed for SQL Server, Visio, ArcGIS, Power BI
Client: Edge It Solution 01/2018 – Present
Role: MS SQL/BI Developer
Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
Developed SSIS packages using Lookup Transformations, Merge Joins, Union all Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks
Exported and imported data from Flat file, CSV file, Excel to/from SQL Server Database using SSIS.
Utilized power BI to design multiple reports of dashboards, maps, KPIs, waterfalls and charts
Monitored & managed the table spaces and data files growth
Analyzed Tables & Schemas, collecting system statistics and rebuilding indexes
Added report mapping functionality to the reports using MS SQL Reporting Services
Created Drill through, Drill down, Matrix and Sub reports
Worked on formatting SSRS reports using the Global variables and expressions
Developed Stored Procedures, functions and database triggers and maintained integrity and implement complex business logic.
Created complex joins to retrieve data from multiple tables for business analysis.
Monitored performance and optimizing queries for maximum efficiency.
Client: Intelligence Effect 02/2015 – 11/2017
Role: MS SQL/ BI Developer
Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS
Analyzing already existing reports and increasing the performance on these reports.
Worked on Migrating the Reports from SQL Server 2012 environment to 2014 environment.
Developing reports using SQL Server Reporting Services.
Developed Drill down, Drill through, Matrix reports, Parameterized reports, cascading parameterized Reports using SSRS.
Worked on SQL Profiler, Tuning Advisor in SQL 2012 to increase the performance of the reports.
Worked with shared Data source and shared data sets for multiple reports.
Deployed the reports from Team Foundation Server to Development Report Manager.
Worked with report subscriptions in SSRS 2012 to send the weekly run automated reports to end users
Developed SSIS Control Flow items and SSIS Data Flow items in SQL Server 2012 Environment.
Develop SSIS package for implement Slowly Changing Dimension, Fact Load and Dimension Load with Incremental Lookup.
Worked with SSIS Package migrations from SQL Server 2012 environment to SQL Server 2012 Environment.
Worked in Creating Team projects for Reporting and Integration using TFS.
Environment: MSSQL Server 2012 Developer Edition, Visual Studio 2012, SSMS, SSIS, SSRS, Team Foundation Server.
Designed and created accurate geo-databases and models
Provided technical support for the creation and visualization of data layers and map products using Arc-GIS software products
Company: Faffa Food share company
Addis Ababa, Ethiopian 10/2013 - 08/2014
Created, published standard and ad-hoc reports using report designer and report builder.
Designed data source views (DSV) and report models for business users using SSRS.
Deployed, managed and migrated data sources, report models, reports in Report manager and/or Share point/MOSS sites
Designed complicated reports with drill-down, drill-through, cascading parameters, etc.
Designed and Implemented row-level access control for users to access detail reports
Developed various T- SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
Developed Complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
Involved in migrating data from MS SQL server 2008 database to MS SQL server 2008 database.
Wrote MDX queries and created OLAP report sourcing from SSAS cube
Developed assemblies to extend SSRS, SSIS, SSAS features using CLR
Developed web application for reporting portal using .NET, ASP.NET, C#, VSS
Built dashboards from OLAP cubes/views using Performance Point Server/ProClarity
Created and updates cubes (measures, dimensions, hierarchies, relationships), defined calculation (calculated members, named sets), KPIs, perspectives using SSAS and MDX
Developed SSIS package for source to staging and/or staging to DW data mappings
Environment: MS- SQL Server 2005/2008-R2, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SSRS, SSIS, C#, VB.Net.
Microsoft SQL Server 2005, 2008, and 2008R2 /2012
Post-Graduate Certificate – Spatial Business Intelligence (GIS) American College of Commerce & Technology Falls-Church, VA May 2017