Sql Server Data

Yared Assefa

*************@*****.*** 909-***-****)

Summary:

5+ years of professional experience with knowledge in Data Modeling, Data Warehouse, ETL, T-SQL development, MS Business Intelligence Tools like (SSIS, SSAS and SSRS) in SQL Server 2012/2008R2/2008/2005.

Worked on accommodating and facilitating Joint Application Development (JAD) sessions, documented, analyzed, and synthesized the results as a part of the business requirements.

Well versed in creating OLTP relational data models and OLAP dimensional models using ER-Win.

Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension Tables, worked with high volume databases with partitioned data.

Proficient in writing T-SQL queries for creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.

Thorough knowledge on working with database maintenance including using Database Management Views, Dynamic Management Functions and DBCC commands to improve table fragmentation and index performance.

Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.

Worked on mapping documents creation as well as development for Data migration, data import, Initial and Incremental load.

Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.

Involved in all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Bulk Insert, and SSIS and creating Master-Child Packages in SSIS using Kimball methodology.

Expertise with data cleansing operations using SSIS transformations and T-SQL scripts to normalize the data and remove and identify potential problem points when moving information into a data warehouse.

Adept in SSIS direct and indirect configuration (XML, SQL Server) set up, SSIS audit and logging, error handling, and performance tuning of SSIS Packages.

Experience optimizing SSAS using the flight recorder to log queries submitted to the Analysis Services Engine and perform usage based optimization to improve the pre-calculated aggregates for reports.

Adept knowledge in creating calculated members and KPI's using basic MDX expressions.

Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).

Well versed in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports and Dashboard Reports using SSRS based on client requirement.

Used expressions to calculate, group, filter, parameterize and format the contents of a report.

Configured snapshot replication for reporting, user acceptance test and development servers.

A well-organized, goal-oriented, highly-motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

Technical Proficiencies:

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

Database Packages: SQL Server 2005/2008/R2/2012, MS Access

BI Tools: BIDS/SSDT, SSMS, SSIS/SSAS/SSRS, SharePoint, TFS, Power Pivot, Power View

Data Modeling: Erwin, MS Visio

SDLC Methodologies: Water Fall Model, Agile, SCRUM

Work Experience:

New Century Health, Brea, CA Mar 2016 - Present

SQL/ETL Developer

Roles and Responsibilities:

Gathered requirements from the client, Perform Gap Analysis, Facilitate JAD Sessions.

Was responsible for analyzing various dimensions and facts that could be included in Data Warehouse design using best suited Star-Schema and created logical and physical model of DW in design software like ER-Win.

Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.

Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.

Was responsible for identifying sources, creating staging database, and data warehouse (Facts and Dimensions).

Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.

Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.

Created complex SSIS packages to pull data from Excel and flat files to SQL server

Implemented various different SSIS features like loggings, transactions, checkpoints, deployment, and configuration on designed end-to-end ETL strategy so that the developed packages could be optimized to the fullest depth.

Implemented the Master Child Package Model for easier maintenance and better performance.

Implemented package configurations on the development, test, and production environments.

Was responsible for securing the entire database with various types of encryption techniques along with the use of certificates.

Implemented appropriate high-availability solution like log-shipping and mirroring which best suited the business needs according to the functionality and the budget requirements.

Created several reports using SSRS such as Drill Through reports, Linked, and sub reports.

Managed very large reports that return a large volume of records and optimized their performance using techniques such as Cascading Parameters and Filters.

Devised dashboards to contain drill-down capabilities to view requested user information through summary reports and trend charts.

Scheduled jobs like backups, restoring of databases using the SQL Server Job Agent.

Tools Used: SQL Server 2008R2/2008, SSIS, SSAS, SSRS, Erwin, Windows Server 2008, Visio

Vichara, Los Angeles, CA Oct 2014 – Feb 2016

SQL/ Data Warehouse Developer/ ETL Developer

Roles and Responsibilities:

●Used Erwin tool for dimensional modeling (Snowflake schema). Forward Engineered Data Model of data mart to SQL 2008 Server.

●Participated in meetings to develop conceptual database design, improve functionality, and achieve optimal performance and development strategy.

●Designed and implemented data warehouse to data-mart using Top-down approach.

●Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.

●Created triggers and audit tables in order to capture the incremental data from OLTP and created complex stored procedures to perform data profiling in the pre-staging database.

●Worked on parent-child architecture on database object including SPs, UDFs and tables with development.

●Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.

●Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling.

●Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

●Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.

●Involved in dimensional data modeling and story boarding ETL processes.

●Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).

●Used SSIS Packages to extract transform and load data from multiple input sources like Excel files, Production SQL Servers (2005/2000) and Oracle into the data mart in optimized way.

●Incorporated Error Redirection during ETL Load in SSIS Packages. Involved in Unit testing and System Testing of ETL Process.

●Generated ad-hoc Reports using SQL 2005/2008 Server Reporting Services to validate the information inserted to the warehouse after refreshing it.

●Performed Functional and Regression Validation on SSRS Reports which implements drill down/drill up, Sub reports and validated the Security on SSRS reports.

●Created Document Map to navigate to the particular section of the report.

●Created many complex stored procedures and used them in Reporting Services directly to generate reports on the fly.

●Created Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.

●Created various data driven subscriptions on a monthly and a quarterly basis for different reports based on requirements.

Tools Used: SQL Server 2008/2005, BIDS, SSIS, SSAS, SSRS, Erwin, Visio, Windows Server, Tivoli, VROP, TADDM

AmeriHealth, Claremont, CA Nov 2013 – Sep 2014

SQL Developer/ ETL Developer

Roles and Responsibilities:

Created ER diagrams and performed normalization on them to ensure faster querying.

Ensured data consistency by creating primary key, foreign keys and appropriate constraints.

Optimized SQL queries using SQL profiler, indexed views and indexes.

Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.

Created DDL and DML triggers to maintain database integrity

Used BCP utility and bulk insert for transferring data between SQL server and flat files.

Created ETL process using SSIS for populating data store in SQL Server 2005.

Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005.

Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.

Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.

Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.

Successfully implemented indexes on tables and views for optimum performance tuning.

Supported some business specific relationships, and advance constraints by embedding triggers on tables.

Set up scheduled Jobs and alerts for updates and backups.

Involved in designing of shift based reports, chart reports (line and column), parameterized reports for performance analysis.

Set up report delivery schedules and report back up schedules by configuring subscriptions and snapshot respectively.

Designed strategies for securing the reports created depending upon the level of sensitivity of information that the report contained.

Tools Used: SQL Server 2005, BIDS, T-SQL, SSIS, SSRS, Erwin, Visio, Flat Files, Excel, Tivoli, VROP, TADDM

Union Bank, Brea, CA October 2012 – October 2013

SSIS/Reports Developer/ ETL Developer

Roles and Responsibilities:

Worked with Business Analysts and end users in gathering detailed requirements and specifications.

Participated in JAD sessions with Business Users to capture and document the BRD and transform the relevant /approved BRD into SRS and FRS.

Involved in designing the physical database models on SQL Server 2008R2/2008 RDBMS.

Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.

Wrote complex stored procedures for Data Profiling, Backup the databases as well as handling the index fragmentation.

Implemented error handling techniques like try catch blocks, error functions in T-SQL scripts and stored procedures to support the applications.

Developed complex Stored Procedures, triggers and User Defined Functions for implementing business logic and process in backend, for data extraction, reports and other client interfaces.

Involved in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.

Created views as required by front end developer for easier implementation on web pages, and wrote instead of triggers on those views to provide efficient data manipulation.

Developed complex mappings using SSIS to transform and load the data from various source systems like Excel, Flat files, Oracle into the SQL 2008 R2 Server target staging database.

Designed the ETL process using SQL Server 2008R2 SSIS Packages in which the data sources include Oracle.

Involved in Full and daily Incremental loads into Staging and ODS areas, troubleshooting process issues and errors using SQL Server Integration Services (SSIS) 2008 R2.

Included transformations like Slowly Changing Dimensions (Type 1 & 2), Look up, Derived Column, Aggregate, Fuzzy Lookup, Multicast, Conditional Split, Data Conversion, etc. in SSIS Packages.

Implemented the Master/Child Package Models to ensure that only the Master Package is scheduled which will in turn fire the other packages.

Created event handlers on every executable in an SSIS package.

Optimized ETL packages by optimizing queries and using proper transformations.

Implemented package configurations on the development and test environments.

Created several ad hoc reports, drill down, drill through, sub, linked, cached and snapshot reports using reporting services.

Involved in Report generation using SSRS and Excel services and deployed them on SharePoint Server.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Formatted and extended interactive SSRS reports by creating parameters within reports, multi-value parameters as well as embedding functions with expressions.

Designed and deployed Parameter-driven reports using parameters tab in the SSRS GUI procedures by Setting up the report-level parameters, along with Building parameter-driven queries and stored and placing them, in the data field.

Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, KPI’s, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.

Actively involved in securing the reports created depending upon the level of sensitivity of information that the report contained.

Supported the logging framework by generating reports to identify the trends and set up the strategy to find bug trends, code changes using Team Foundation Server.

Tools Used: SQL Server 2008R2/2008, SSIS, SSRS, Erwin, Windows Server, Visio, TFS, Power Pivot, MS Visual Studio 2008.

Education:

Institution/University

Degree

California State Polytechnic University-Pomona

Bachelor of Science - Computer Science

Contact this candidate