Data Developer

Shewa Nida

*********@*****.***

202-***-****

Silver Spring, MD

PROFESSIONAL SUMMARY

Microsoft Certified Database Professional with over six years of experience in IT as SQL Server

/Business Intelligence Developer and SQL Server DBA. Experienced in requirements gathering, development, design, testing, deployment, and maintenance of SQL Server technologies. Developed and supported enterprise BI solutions, data visualization and data warehouse. Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.

Education and Certifications

• MA in Data Analytics, University of Maryland University College, 2019-Present

• MBA from Maharishi University of Management, Fairfield, IA – 2013

• BA in Management Information Systems from Addis Ababa University – 2005

• Certified in Analyzing and Visualizing Data with Microsoft Power BI

• Certified in Querying Microsoft SQL Server 2012/2014 Databases

• Certified in Administering Microsoft SQL Server 2012/2014 Databases Tools and Technologies:

• Database Management Systems: MS SQL Server 2016/2014/2012/2008, Oracle 11g, MySQL, MS Access, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Informatica PowerCenter.

• Programming language and environment: Java, C#, C, Visual Studio 2017/2015/2013/2012

• Data Visualization: Power BI and Tableau.

• Operating Systems: Windows server 2008R2/2012/2016.

• Data modeling tool: Erwin Data Modeling and RedGate. Professional Experience:

Sr. BI Developer/SQL Server Developer

Donnelley Financial Solutions – Rockville, MD August 2017 – Present

• Designing build and deploying effective ETL solutions using Microsoft SQL Server Integration Services

(SSIS)

• Extracting data from MS-SQL, Oracle, MySQL, Excel, MS Access and Flat files and transforming data for ODS, Staging, and Data Warehousing.

• Designing and developing data models, database objects, tables, stored procedures, views, and triggers.

• Troubleshooting and optimizing the performance of packages and SQL queries.

• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.

• Importing data from SQL Server DB and Azure SQL DB to Power BI to generate reports.

• Developing calculated columns and Measures using Data Analysis Expression Language (DAX).

• Installing and Configuring Enterprise and Personal Gateway in Power Bi Services.

• Developing, testing and deploying SSRS reports to production environments.

• Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the Tabular, OLAP and Operational data.

• Responsible for Requirement Gathering, Analysis and End User Meetings.

• Preparing Documentation of ETL and data warehouse processes and flows and Technical document of mappings for future reference.

BI Developer/SQL Server

RR Donnelley – Rockville, MD February 2014 – July 2017

• Created various SSIS packages to transfer data from OLTP (Tabular) databases to the staging area and then into the data warehouse.

• Maintained Stored Procedures, Views, User-defined Functions and Triggers.

• Involved in Optimizing Performance.

• Developed Tableau desktop/ server reports and dashboards

• Created Tableau data extracts

• Consult with business and technology partners on data visualization options and best practices

• Troubleshoot Tableau related issues and queries

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

• Designed and implemented cubes across multiple data marts using OLAP methods.

• Gather business requirements and translate them into technical documents. Database Administrator

EDGAR Online Inc. - Bethesda, MD November 2012 – January 2014

• Install, configure, and managed SQL Server 2008\2012 in development, test, and production environment.

• Maintained Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to carry out business rules.

• Configured and maintained database replication.

• Configured and managed Log Shipping including standby database for reporting purposes.

• Monitor server activity, error logs, space usage, and solved problems when they occurred.

• Control privilege and permission for access to the instances and databases.

• Responsible for the implementation and maintenance of database backup and recovery processes.

• Setup automated jobs for different purposes including backup, monitoring database health, disk space, and backup verification.

Contact this candidate