SUMMARY

• 7+ Years of extensive work experience in Software Development Life Cycle (SQL server developer, BI Developer, DBA ) and Software Testing Life Cycle (STLC) principles
• Proven experience in SQL Server database design & development and data modeling (conceptual, logical and physical) and strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, Dimensional Modeling (Ralph Kimball and Bill Inmon Methodologies).
• Solid experience and outstanding knowledge of SQL Server high availability solutions, including Log shipping, Mirroring, Replication, Always on.
• 5+ years of experience in writing T SQL, Stored Procedures, user defined functions, advanced query, Complex joins and Trigger.
• Experience in using performance monitoring tools
• Expertise in Query Optimization, Performance Monitoring, Security Administration, Trouble Shooting and identifying and solving concurrency issues.
• Experience working collaboratively using agile and waterfall software development process
• Excellent analytical, co - ordination, interaction skills and an outstanding team player with an aptitude to learn and share new skill. Self-starter highly motivated, a very good problem solving and communication skill. Have worked in industries like Utility, Financial, and Health Environmental across a wide variety of systems and companies from small to large size.

TECHNICAL SKILLS

• BI Tools: SQL Server 2014, 2012/ 2008R2/ 2008/ 2005, SSIS (ETL), SSRS, Tableau
• SSDT, BIDS, Visual Studio, Power BI Desktop, Power View
• Databases: SQL Server (2005, 2008, 2008R2, 2012, 2014), ORACLE, MS Access
• Database Programming: T-SQL, PL/SQL
• Data Access Technology: OLE DB, ODBC, ADO.NET
• Programming Languages: C#, VB.Net
• Platforms: Windows NT/XP/7/8/10, Windows Server 2000/2003/2008 , SharePoint
• 2010, Visual Studio .Net 2010/12/13/15
• Source Controls: Team Foundation Server (TFS), VSO
• Client-side Technology: HTML, CSS, JavaScript
• Data Modeler: Visio, Erwin
• MS-Office: Word, Excel, Access, Power point, Outlook, InfoPath

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• Configuring and maintaining databases
• Created Stored Procedures that inserts, updates, deletes and extracts data from base table
• Create Functions, Tables, Views and SQL Scripts using SQL Server 2012.
• Create triggers that log update, inserted and deleted records in specific log table
• Perform auditing at SQL server and database level
• Perform import and export data using graphical wizard by maintaining required mapping and filtering.
• Perform troubleshooting and resolving concurrency issues
• Perform Server and database auditing
• Write different T-Sql query to extract data
• Populate extracted data into base tables in the database

Technical Environment: SQL Server 2014/2012, SSDT 2014, C#, Visual studio 2013/15, Excel 2013, VSTFS, VSO

Confidential, Bellevue, WA,

Responsibilities:

• Created Stored Procedures, Functions, Tables, Views and SQL Scripts using SQL Server 2014.
• Performing source to destination data conversion, data mapping, designing, reviewing, implementing and optimizing ETL processes.
• Used SQL Server Agent to schedule jobs and to verify successful execution of scheduled tasks that load data from source to destination.
• Created SSIS packages for extracting data from different data sources using ETL techniques.
• Deployed SSIS Packages to SQL Server Integration Service CatLog.
• Designed Data Warehouse, Dimension and Fact tables using Star and Snowflake schemas applying the Kimball approach.
• Used VSTFS for Sprint Planning and to create and manage tasks in agile environment.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Defined and Designed Data Warehouse, Dimension and Fact tables using Star and Snowflake schemas applying the Kimball approach.
• Created SSIS packages for extracting data from different data sources using ETL techniques.

Technical Environment: SQL Server 2014/2012, SSDT 2014, C#, Visual studio 2013/15, Excel 201316, VSTFS, VSO

Technical Environment: SQL Server 2014/2012, SSDT 2014, C#, Visual studio 2013/15, Excel 201316, VSTFS, VSO

Confidential.MD,

Responsibilities:

• Preparing requirement document based on business analysis for conceptual, logical physical data Model.
• Create connection string to DB using Ado.net on IDE
• Created Stored Procedures, Functions, Tables, Views and SQL Scripts using SQL Server 201
• Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.
• Developed UI using C# and ADO.NET for customers to connected to the database
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.

Technical Environment: SQL Server 2012/2008R2, SSRS (2012/2008R2), SSIS (2012/2008R2), C#, Visual studio 2012/10, Excel 2013, TFS

Confidential, Ethiopia,

Responsibilities:

• Preparing requirement document based on business analysis for conceptual, logical physical data Model.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQL code for reports and analysis and backend requirements in OLTP system using SQL Server 2012.
• Inserting and updating data to SQL Server 2012 database.
• Analyzing different data and writing SQL script that helps viewing the analysis.
• Writing advanced level SQL, Views, and optimization SQL query
• Building reports using SSRS and Excel.
• 2NF,3NF (Relational) Logical and Physical Modeling work
• Creating, developing, and managing a SQL Server 2012 databases.
• Used ADO.NET objects such as dataset and data adapter, for consistent access to SQL data source

Technical Environment: SQL Server 2012/2008R2, SSRS (2012/2008R2), SSIS (2012/2008R2), C#, Visual studio 2012/10, Excel 2013, TFS

Confidential,

Responsibilities:

• Write T-SQL scripts for data visualization and analysis.
• Develop Query and Stored Procedure using TSQL in OLTP System.
• Developed business critical financial and executive summary reports using SSRS 2012.
• Worked on Deployment and Subscription of Reports.
• Designed SSIS packages for data Extraction, Transformation and Load (ETL) from source to destination.
• Used Visual Studio 2012 and TFS for code sharing and version control.
• Configuration of Report Manager for subscription and caching.
• Build, tested and deployed SSRS reports in different environments.

Technical Environment: SQL Server 2008R2/2012, SSRS (2012/2008R2), SSIS (2012/2008R2), C#, Visual studio 2010, TFS, MS-Excel