REBECCA SHAREW

Dallas, TX. Cell 469-***-****. ad16h0@r.postjobfree.com

5+ years of experience

PROFESSIONAL SUMMARY

Extensive experienced in Database Design and development of applications with Business Intelligence using SQL Server 2014/2012/2008 (T-SQL), Integration Services (SSIS), and Reporting Services 2014/2012/2008 (SSRS).

Enthusiastic IT professional in Database Design Development, ETL Implementation, and support of OLAP/OLTP/ Data warehouse systems. Utilizing Microsoft SQL Server 2016/2014/2012/2008 across various SDLC environments.

Expert in Data Extraction and Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) in MS SQL Server to import/export data.

In-depth experienced with data warehousing, data architecture, data quality processes, table structure, fact and dimension tables, logical and physical database design, data modeling, and reporting.

Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export wizard, Troubleshooting, and Database Objects authorization.

Strong analytical and problem solving and communication skills. Ability to work to deadlines, result oriented, flexible, and adaptable.

Technical Skills

DBMS

SQL Server 2016,2014,2012 and 2008, Tableau Desktop, Tableau Server, Power BI

Languages

SQL, C#

Operating Systems

Windows server 2003/XP/NT6.0/98/Vista,7,8,10

Development Methodology

Agile/SCRUM

Reporting Tools

SQL server Reporting Services (SSRS) 2016/2014/2012/2008

ETL Tools

SQL server Integration Services (SSIS) 2016/2014/2012/2008

Data Modeling

Microsoft Visual Studio 2008,2010, SSAS

Office Tools

MS Word, PowerPoint, Excel, Visio, one note, MS Operations Manager, Share point

Education

AS: In Science Brookhaven college

BS: Management Information System Unity University

Certifications

SQL Server 2012/2014, Business Intelligence Development and Maintenance

Work History

Carrington Mortgage Company

SQL Server BI/SSIS/SSRS Developer, (client)

05/2017 to current

Interacted with users extensively in gathering the requirements and analyzing the needs of the end users.

Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults, and complex SQL statement.

Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels. Monitoring logs to ensure the completeness of batch processes and scripts.

Created complex SSIS packages using various tasks including Sequence Containers, For loop Container, For Each Loop Container, Script Task, Execute SQL/Package, Send Mail, File System and more. Used Transformations such as Conditional Split, Data Conversion, Derived Column, Lookup, and Merge Join. Worked with flat file source, Excel source, Xml source, Access source, and more.

Created CDC (Change Data Capture) to track the records of the changes made to the database and table.

Designed, developed and deployed SSRS reports. Which include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, and Sub Reports.

Environment: SQL Server 2008R2/ 2012/ 2014,2016 TSQL, SSIS, SSRS, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard & MS Visio

NOVEDEA .

Tableau / BI Developer, (client)

11/2015 to 05/17

Worked extensively in Tableau Calculations, Parameters, Background images, and Maps.

Used Trend Lines Statistics and Groups hierarchies, sets to create detail level summary report, and Dashboard using KPIs using Tableau.

Published various kinds of live interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau servers.

Generated Tableau Dashboards with quick/context/global filters, parameters, and calculated fields on Tableau reports.

Scheduled data to refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the change in data accurately.

Knowledge in C# script task and component in SSIS packages.

Created various Stored Procedures to validate the data from the source and update/insert the records into target tables.

Work closely with report analysts and operation staff for support in problem resolution, and root cause analysis.

Participated in AGILE iterative development methodology.

Environment: SQL Server 2008R2/ 2012/ 2014, TSQL, SSIS, SSRS, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard & MS Visio

T-Mobile,

BI Developer, (client)

09/2014 to 10/2015

Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying, and dynamic configuring of SSIS packages.

Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.

Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, aggregate, multicasting, conditional split, and derived column.

Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.

Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.

Scheduled and monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio to automate manual tasks.

Designed, developed data warehouse, data marts, and business intelligence using multi-dimensional models such as star schema and snow flake schema.

Understand the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies, and adding the Aggregations to the Cube.

Environment: MS SQL Server 2008 R2/2012/2014, Business Intelligence Development studio (SSIS/SSAS), MS Office Access 2007/2010 and Visual Studio 2010

Contact this candidate