Yyyyyy x. yyyyyy

MS SQL Server Developer

Data Integration (SSIS) ● Analytics (SSAS) ● Business Intelligence (SSRS) ● Data Modeling

ETL ~ Data Migration & Warehousing ~ Dashboard Reporting ~ Data Marts ~ OLPA and OLTP

         Significant expertise throughout full-scope software development life cycle (SDLC) including analysis, design, programming, testing, and documentation.

         Advanced talents in configuring, managing, and troubleshooting SQL Server 2012/2008/2008R2/2005.

         Possess strong QNXT experience including front and backend support, and excel at creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).

         Adeptness across ETL, data warehousing, performance tuning, query optimization, client/server connectivity, database consistency and security, and ensuring rigorous data integrity.

         Consummate strengths in extracting and transforming transactional information using DTS Import/Export Wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS packages from SQL Server.

Client: Hotchalk, Campbell, CA, Jul 2016 Present

SQL Server / SSRS / SSIS Developer

         Spearhead enterprise report development for Finance, Sales, Commercial Operations, Customer Service and Laboratory business units, and actively contribute to data warehouse modeling & design, and ETL development.

         Optimize SQL queries, collaborate with project managers in planning and scheduling development of database module, and submit regular analytical reports to management regarding spend per time, area, and price.

         Document detailed reports for customers, prepare SSIS packages, and perform well-timed ETL operations.

         Construct tables, triggers, macros, views, stored procedures, functions, packages, joins, and hash indexes in Teradata database.

         Select, export, and load data to and from different source systems including flat files.

         Proficiently perform database transfer, integrity verification, data cleansing, analysis, and interpretation.

         Analyze and automate maintenance jobs, locks and indexes configurations.

Client: Pacific Life Insurance, Omaha, NE, Sep 2015 Jun 2016

SQL Server T-SQL Developer /SSRS / DBA

         Played an instrumental role in analyzing and efficiently improving client s operational databases.

         Generated sub-reports, cross-tab, conditional, drilldown reports, drill-through reports, and parameterized reports.

         Wrote T-SQL queries, created dynamic stored procedures, and optimized queries.

         Designed and implemented stored procedures and triggers to streamline and automate tasks, significantly increasing organizational productivity.

         Fashioned dashboard reports and automated associated process for critical information retrieval.

Client: CITI Bank, Warren, NJ, Jun 2013 Jul 2015

SQL ETL BI Developer

         Performed data warehouse reporting using SSRS 2012 and designed ETL for uploading of changes into custom-built analytical MDM solution.

         Structured multiple complex stored procedures and functions to generate reports during development process.

         Assembled SSIS package to load data from XML files and SQL Server via Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and SCD.

         Used ADO.Net Entity Framework to connect, retrieve, and manipulate data with database operation.

         Tested SSIS packages to validate functionality of each component and applied modifications as applicable.

Continued ►

Professional Experience continued Yyyyyy x. yyyyyy Page 2 of 2

Client: Ethiopian Insurance Corporation, Ethiopia, Feb 2011 Oct 2012

SQL Server T-SQL Developer /SSRS / DBA

         Analyzed and improved client s existing operational databases, generated weekly reports to track specific sales data, and wrote T-SQL queries.

         Employed complex query statements such as sub queries, correlated queries, derived tables, CASE functions to insert data depending on criteria.

         Extensively used BCP and BULK INSERT to import and export data, coded stored procedures and triggers for automating tasks, devised and automated dashboard reports, and optimized queries.

Client: Ethiopian Commodity Exchange (ECX), Ethiopia, Jan 2010 Dec 2010

SQL Server/ SSRS/SSIS Developer

         Contributed to data warehouse modeling and design, as well as ETL development.

         Optimized SQL queries via Query Analyzer, tested procedures and triggers to be used in production, and joined forces with project managers in planning and scheduling database module development.

         Methodically prepared reports for customers illustrating demographic information in extensive detail.

         Established tables, triggers, macros, views, stored procedures, and functions in Teradata database.

         Authored reports for managers to demonstrate spend analysis measures such as time, area, and price range.

         Facilitated ETL operations via SSIS Import/Export Wizard and developed and implemented SSIS packages.

Client: Ethiopian Document Authentication and Registration Agency, Oct 2008 Nov 2010

SQL ETL BI Developer

         Participated in data warehouse project by performing data warehouse reporting using SSRS 2012 and ETL architecture design during initial phase, and process design for loading dimension tables and fact table.

         Proficiently utilized advanced features of T-SQL to efficiently design and tune T-SQL to interface database and other applications.

         Engineered high-level stored procedures/functions, used SSIS to create ETL packages, and built ETL for mass uploading of product attribute changes into custom-built analytical MDM solution.

         Created, tested, and modified SSIS packages to meet broad-based changes specified by end users.

         Effectively compiled sub-reports, cross-tab, conditional, drilldown reports, drill-through reports, and parameterized reports in SSRS 2012.

Client: Custor Computing Plc., Ethiopia, Jun 2007 Nov 2008

SQL Server TSQL/SSIS/SSRS Developer

         Performed requirements gathering, design, development, integration, and maintenance of advanced technology systems, products, and services.

         Leveraged T-SQL and SSIS to seamlessly extract and migrate data through staging into reporting layer, and produced reports based on business requirements.

         Resourcefully used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance performance of databases.

         Expertly employed a wide range of data transformations including Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, and Derived Columns.

         Held accountability for backup and recovery strategy and planning, data quality, database/application tuning, and report compilation for managers.

MS SQL Server 2012/2008R2/2008, Visual Studio 2013/2010/2008 (SSAS/SSIS/SSRS), MS Access, MS Excel (incl. pivot tables), OLAP and OLTP, MS Outlook, MS SQL Profiler, SQL Server Query, T-SQL, SQL Server Integration Service 2012, SQL Server Reporting Service 2012, C#. Net, VB.Net. / SharePoint, ASP.Net, Erwin7.3, Query Analyzer, Index Tuning Wizard, Windows O/S, MDM, MS Office 2007/2010, CADIS 8.1, Crystal Reports, ProClarity, Teradata V2R13

Bachelor of Science Degree

Microsoft Certified Professional Developer