Data Developer

Zegeye Haile

703-***-**** **********@*****.***

Professional Summary:

●MS SQL Server Developer with around 7 years of strong experience in various domains like Financial, Healthcare, Retail and Insurance with expertise in MS SQL Server 2012/2008R2/2008/2005/2000 and SSIS, SSRS and SSAS.

●Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.

●Proficient in installing, configuring, managing, monitoring and troubleshooting MS SQL Server 2012/2008/200R2/2005.

●Developed Logical and physical data model using ERWIN, ER Studio and mapped the data into database objects.

●Strong MS SQL Server 2012/2008/2008R2/2005 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.

●Expert in Microsoft Business Intelligent Studio 2010/2008 (SSIS/SSRS/SSAS).

●In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL).

●Extensive experience in Migration of data from DB2, Oracle, and Sybase to MS SQL Server.

●Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.

●Affluent in Web Technologies like HTML, CSS, XML, JavaScript, JSP, core Java etc.

●Sound knowledge of SQL Server Analysis Services (SSAS), SharePoint 2010 development and Performance Point Services (PPS), SQL Server Reporting Services (SSRS), Power Pivot (Excel 2010).

●Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).

●Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.

●Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

●Mastery 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.

●Expertise in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS).

●Good understanding in Database Backup, Recovery and highly experienced in investigating and applying necessary MS SQL Server database Service packs, hot fixes and Security Patches.

●Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

●Expert in Microsoft Business Intelligence Studio 2010/2008 (SSIS/SSRS/SSAS).

●Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.

●Affluent in PostgreSQL development environment with Greenplum DB.

●Defined and administered database standards, controls, procedures and documented the same.

●Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.

Professional Skills:

SQL Server Tools: SSMS, BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools: SSIS, SSRS, SSAS, BIDS, DTS, Power BI, Business Objects,

Informatica 7.1.3 /8. X/9.1

Databases: SQL Server 2000/2005/2008/2008R2/2012, MS Access, Oracle

Languages: T-SQL, PL/SQL

Operating System: Windows Server 2003/2008/2008 R2, Windows XP/Vista/7

Tools: Erwin, ER Studio, Visual Studio 2010/2008/2005 and Report Builder 2.0/3.0

Professional Experience:

USPTO, Alexandria, VA September 2018 – Present

Sr SQL Server developer/Data Modeler/ SSAS/SSIS

Responsibilities:

●Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

●Developed Logical and physical data model using ER Studio and mapped the data into database objects.

●Occupied in Logical, Physical design and Development of the Reporting Data Model for the Database and using ER Studio.

●Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.

●Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.

●Successfully implemented indexes on tables for optimum performance.

●Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.

●Worked extensively on query optimization and performance Tuning.

●Migrated data from Oracle 10g environment to SQL Server 2012 with SQL Server Integrated Services (SSIS).

●Created complex stored procedures to generate Auditing reports.

●Created various views to be used for different visualizations by spot fire.

●Developed SSAS Cubes and export them out as pivot tables in Excel for data analysis.

●Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded into the audit table.

●Used Configuration files for changing variables and setting the priority levels for those transcripts based on the level of urgency / requirement.

●Created OLAP models based on Dimensions and Facts for efficient loads of data.

●Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.

●Developed MDX Queries in order to perform drilldown reports and for calculating measures and dimensions.

●Used PowerShell to monitor database information and made modifications.

●Used SharePoint-PerformancePoint Services to create rich dashboards, aggregating content from multiple sources and displaying it in a web browser.

●Implemented perspectives and KPI using calculated measures based on requirements.

●Identified and defined the datasets for Report generation.

●Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using Reporting Services.

●Supported ASP.NET team to build a credit card payment system prototype for a private bank.

Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), SharePoint 2013, Business Intelligence Development Studio (BIDS), MS Excel.

Freddie Mac, Mclean, Virginia August 2016– July 2018

SQL Server T-SQL/SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

●Developed Visual reports, Dashboards and KPI Scorecards using Power BI Desktop

●Connected to different data sources, imported data and transformed data for Business Intelligence.

●Translated data into informative visuals and reports.

●Implemented row level security on data.

●Made DAX queries in Power BI desktop.

●Published and Scheduled Power BI reports as per the Business requirements.

●Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.

●Developed Logical and physical data model using ER Studio and mapped the data into database objects.

●Worked with Oracle Server to extract, load information of Customers.

●Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.

●Wrote complex stored procedures for different visualization of the report.

●Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.

●Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

●Accountable for Backup and Recovery Strategy and Planning.

●Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.

●Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.

●Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.

●Used Packages by testing and cleaning the Standardized Data by using tools in Data.

●Data flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing and new packages.

●Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.

●Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.

●Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.

●Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.

●Generated Daily, Weekly and Monthly reports for the managers.

●Used sub reports functionality for complex report calculations.

●Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.

●Responsible for database tuning using normalization and application tuning.

●Documentation for all kinds of reports and SSIS packages.

Environment: MS SQL Server 2008R2, T-SQL, SQL server Integration service 2008R2, SQL server

Reporting service 2008R2, Power BI, Erwin7.3, Query Analyzer, Index Tuning wizard, SQL Profiler Windows server 2003.

Sanofi Aventis Pharma, Bridgewater, NJ January 2015 – July 2016

MS SQL Developer/ SSRS, SSIS, SSAS

Responsibilities:

●Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period.

●Involved in scheduling reports to run Weekly, Monthly and Quarterly based on the data to be reviewed by the manager.

●Generated Sub-Reports, Cross-tab, Conditional, drill down reports, Drill through reports and Parameterized reports using SSRS 2008.

●Created reports using Global Variables, Expressions and Functions using SSRS 2008.

●Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.

●Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.

●Wrote T-SQL queries, created dynamic Stored Procedures by using input values.

●Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.

●Applied monthly patches and hot fixes.

●Created Alerts for successful and unsuccessful completion of Scheduled Jobs.

●Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.

●Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.

●Designed and implemented Stored Procedures and Triggers for automating tasks.

●Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.

●Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

●Ensured best practices are applied and integrity of data is maintained through security and documentation.

●Using ETL to build the required data mart.

●Generated Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

●Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Environment: MS SQL server 2008, SSRS, SQL Profiler and T-SQL, Windows 2003 server, and Visual Studio 2005, Microsoft Office, MS PowerPoint, MS Access, Index Tuning Wizard, Query Analyzer, SQL profiler.

Bentley Systems, Exton, PA June 2013 – November 2014

SQL Developer

Responsibilities:

●Mostly involved in gathering business Requirement and Online System Specification and building up a solution to implement in CAIS.

●Implemented batch processing for approval process by creating a wrapper driver which used ISQL conducting various BCP, select out and select into commands.

●Wrote complex stored procedures to process prospective customer information and balanced the processing load between front end and back end.

●Enhanced the old logical and physical database design to fit new business requirement and implemented new design into SQL Server 2008.

●Successfully migrated old data from legacy systems (FoxPro) and external system including DB2 and excel into SQL Server 2008 using SSIS, BCP and ActiveX scripts.

●Monitored query using query analyzer and tuned queries and procedures to boost database performance.

●Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios.

●Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.

●Assisted in designing and creating user Interface.

Environment: SQL Server 2005/08, SSRS, SSAS, Oracle 10g, Visual Studio, MsVisio2003/2007, MS Project

Education

BahirDar University /Ethiopia/ 2008-2012

Business Management BA

MS SQL Server Development Certificate

MS SQL DBA Certificate

Contact this candidate