Sql Server Data
Resume:
Yeshialem B. Aynalem
PROFESSIONAL SUMMARY:
Over 7+ years of extensive experience in database design, development and administration with MS SQL Server versions 2016/2014/2012/2008/2005/2000/7.0 using SSIS, SSAS, SSRS (BI Tools) in, Retail, Pharmaceuticals, Real Estate / Property Management and Banking industries.
Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally. Designed, reviewed, and created primary objects such as Views, Indexes based on logical design models, user requirements and physical constraints.
Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.
Design and build reliable SSIS packages with detailed error handling and notification techniques to maintain integrity and notify responsible parties in the event of an error.
Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
Created SSRS report projects in BI Visual studio and created, modified and managed various report models with multiple objects, source fields and expressions.
Report parameters also consist of different parameter types like hidden, internal, default (queried and non- queried parameters) to minimize the report execution time and to limit the no of records required.
Designing enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.
Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Worked with Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
Created stored procedures, triggers, user-defined functions, views handling business logic and functionality of various modules.
Supported in creation of user logins with appropriate roles, locking the logins, monitoring user accounts and granting privileges to users.
Establishing referential integrity, data consistency, and indexing and data cleanup procedures to maintain high quality data that can be used for reporting.
EDUCATION / CERTIFICATIONS
Addis Ababa University College of Commerce, Associate Degree in Secretarial Science and Office Management.
Microsoft BI Certification (MCTS) Specialist Certification: SQL Server 2012/2014
Business Intelligence Implementation and Maintenance. School of Data Analytics: Certified BI/EDW Developer
TECHNICAL COMPETENCIES
Operating Systems ---Windows 98/2000/2003/XP/NT/Vista/7, Windows Server 2003/2003 R2/2008/2008 R2
Database Tools--- SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard
GUI Tools ---SQL Server Business Intelligence Development Studio, Visual Studio 2005/2008/2010
Languages --T-SQL
OLAP Tools ---SSAS, SSRS
Source Control Tools ---Visual Source Safe 2005, Team Foundation Server 2010
ETL Tools ---SSIS, DTS, Import/Export Wizard
COMMUNICATION SKILLS
Click on the link below to view a couple of my videos related to this position.
PROFESSIONAL EXPERIENCE
Fresenius Medical Care - Dallas, TX
SQL SERVER SSIS/SSRS ETL Developer June 2014- Present
Fresenius Medical Care is the world’s leading provider of products and services for people with chronic kidney failure. Around 3 million patients with this disease worldwide regularly undergo dialysis treatment. Dialysis is a vital blood cleansing procedure that substitutes the function of the kidney in case of kidney failure. Fresenius Medical Care is the top dialysis company caring for more than 119,000 patients in own dialysis centers worldwide. With a production output of more than 50 million dialyzers per year Fresenius Medical Care sets a new record.
Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
Database Administrative skills including, backups, recovery, database maintenance.
Experience in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform
Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements
Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, Enterprise Data Warehouse, Data marts, OLAP analysis and Reporting tools.
Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
Worked with development teams in the design of physical databases and in modification.
Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2008 R2 Reports Services (SSRS).
Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
Proficient in SSIS process design architecting the flow of data from various sources to target.
DELOITTE & TOUCHE
SQL SERVER SSIS/SSRS/ETL Developer SEPT 2012- June 2014
Deloitte Touche Tohmatsu Limited commonly referred to as Deloitte.
Deloitte is the second largest professional services network in the world by revenue and has 193,000 employees in more than 150 countries providing audit, tax, consulting, enterprise risk and financial advisory services. The foremost responsibilities involved a lot of ETL activities through extracting data from various sources and creation of OLAP structures for analysis purposes and reporting purposes.
Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008 R2.
Designed ETL packages dealing with different data sources (SQL Server, Flat Files, XML) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008R2
Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Involved in writing queries for stored procedures, clustered and non-clustered indexes.
Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
Provided 24/7 production support for the production database and also to the code deployed into the production environment
Hardware/Software
SQL Server 2005/2008/2008 R2, Windows 2008, MS Excel 2007, Text Pad text editor, SSRS, SSIS, BIDS, VISUAL STUDIO, Notepad++, XML
CA TECHNOLOGIES, PLANO, TX
SQL SERVER SSIS/SSRS/ETL Developer August 2011- SEPT 2012
CA Technologies, Inc., formerly CA, Inc. and Computer Associates International, Inc. The company creates systems software that runs in mainframe, distributed computing, virtual machine and cloud computing environments. The project was to use integration services to create packages and generate parameterized reports from the database containing information of customers.
Designed ETL packages to load data from different data ware houses and migrated it to text files.
Used various data flow and control flow items for the ETL.
Wrote highly complicated and optimized stored procedures which were used for main extraction.
Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
Analyzed the Extracted data is according to the requirement.
Wrote and discussed Analysis reports with Clients.
Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
Responsible for Configuring, tuning, and optimizing SQL Server 2008.
Hardware/Software
SQL Server 2005/2008/2008 R2, Windows 2008, MS Excel 2007, Text Pad text editor, SSRS, SSIS, BIDS, VISUAL STUDIO, Notepad++, XML
Wal-Mart Inc – Memphis, TN
SQL SERVER SSIS/SSRS ETL Developer December 2011- June 2012
Installation of MS SQL enterprise servers on test and development boxes.
Designed and Created databases, tables, views, stored procedures and triggers.
Created groups, roles, users and assigning access privileges to users.
Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
Monitored and scheduled existing/new jobs on production environment.
Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
Tested backup and recovery strategies in a test environment before and after moved to production environment.
Extensive use of Stored Procedures. Created new stored procedures and modifying existing ones.
Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
Developed ETL process using SSIS to transfer data from heterogeneous data sources.
Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
Responsible for gathering business requirements to create business user reports.
Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
Designed OLAP cubes with star schema and multiple partitions using SSAS.
Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Quick Trip Corp. – Tulsa, OK
SQL SERVER SSIS/SSRS ETL Developer January 2010- December 2011
Gathered business requirements, definition and design of data source and data flows.
Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
Created logical and physical data models using Erwin 4.2 to design new database after discussion with technical team and application.
Analyzed data quality, by working in conjunction with the data warehouse architect on the development of logical data models.
Designed and developed SSIS packages to move data from production environment to different environments within the organization.
Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
Migrated database from MS SQL Server 2000 to MS SQL Server 2005 using SSIS packages.
Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP sources like MS SQL Server 2000, Oracle, Text Files, Excel and Access to OLAP with the help of MS SSIS.
Used SSIS to manually transfer DTS packages 2000 to SSIS packages 2005 using MS SSIS 2005
Developed and maintained a combined data store for reporting purposes.
Generated reports using Global Variables, Expressions and Functions using SSRS 2005.
Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
Generated daily, weekly and monthly reports for the managers.
Contact this candidate