Data services engineer Resume Redmond - Hire IT People

PROFESSIONAL SUMMARY:

Total IT experience - 17 years
Business Intelligence, business analysis, ETL architecture and design, data modeling, normalization, and dimensional modeling.
Utilize SSIS, SSRS, and SSAS with SQL Server (since SQL Server 2000 till SQL Server 2014)
OBIEE ( Oracle BI Publisher , Oracle BI Answers )
T-SQL - Database query tuning and procedure/function scripting
DATA WAREHOUSING (DWH)
ETL Development
REPORTING (SQL Server Reporting Services, Confidential Report Builder 3.0)
SQL Server Analysis Services (Multidimensional + Tabular models)
Oracle BI
Power BI (Dashboards, Reports, Datasets)
Confidential BI (Power Pivot, Power View), DAX
AGILE development
SHAREPOINT 2013

EXPERIENCE:

Confidential, Redmond

Data services engineer

Environment: Cloud Computing Platform & Services, Confidential SQL Server 2012-2014, Confidential Visual Studio 2012-2015, SSIS, SSAS, GIT, SharePoint, Visio., MS SQL development, KTBR tasks,Cosmos jobs development, maintenance of structured and unstructured streams, Big Data, Scope scripts.

Confidential, Chicago, IL

Database developer

Environment : Confidential SQL Server 2012, T-SQL, complex queries, stored procedures and functions, dynamic SQL

Confidential, Chicago, IL

DWH architect/ BI Architect

Responsibilities:

Requirement Gathering
Physical Environment Setup
Data Modeling (conceptual data model, logical data model and physical data model)
ETL
OLAP Cube Design
Front End Development
Report Development
Performance Tuning
Query Optimization
Quality Assurance
Rolling out to Production
Production Maintenance
Incremental Enhancements
4 Data warehouses along with data marts (for different clients) was successfully developed
SharePoint portal with 4 subsites was successfully launched and rolled out to production
More than 60 reports were developed
OLAP cubes (MOLAP storage mode)

Confidential

DB Team Leader / DWH (Data Warehouse) Architect

Responsibilities:

Database development section leader (MSSQL DB's + BI architecture, development and maintenance of corporate reporting .) Services: SSIS, SSRS, SSAS.
Planning and managing resources of database development and BI development team
Agile approach
Database Architect
MS SQL Services (SSIS, SSRS, SSAS), T-SQL
Power BI
SSAS Tabular models, DAX programming
Data Warehousing
Relational Database
ETL Development
MIS Reporting
Team Leader of 10 developers (database and BI)
Interacting with the internal departments to understand the business goals and finalize its scope.
Estimation, design and development of various parts of the project.
Bug fixing and maintenance of the product
Mentoring all members in the team
Coordinating with analytical teams working on the same project
Co-ordinating with the testing team for fixing bugs.
Ensuring smooth delivery of the project.

Confidential

MS SQL developer

Responsibilities:

Oracle BI Interactive Dashboards: 3 personalized, highly intuitive, guided and fully interactive access to cockpits of live analyses. End users: Department of accounting, financial analysts, top managers.
Oracle BI Answers: was developed 6 data models for self-service ad hoc capabilities allowing end users to easily create charts, pivot tables, reports, and visually appealing dashboards, all of which are fully interactive and drillable.
Oracle BI Publisher: about 40 reports that are created and published. Was delivered directly or through Interactive Dashboards to end users.
Development and support reporting environment (financial, statistical, management). Confidential Reporting Services and Oracle BI products.
It was database migration from MS SQL 2005 to Oracle 10g. SSIS, t-sql and pl/sql scripting were used for that purposes.
User roles were provided with the different access levels to data in according to their positions and duties.
Database Architect
Database development section leader (MSSQL & Oracle DB's + BI architecture, development and maintenance of corporate reporting .) Services: SSIS, SSRS, SSAS, BI Publisher, BI Answers
Planning and control resource utilization of database development team
Involvement in projects (Agile approach)

Network/ database administrator

Confidential

Responsibilities:

Design, maintenance of the network. Customers (Windows XP SP2), 5 servers (Win 2000 Server SP4) ( domain controller, mail server, database server, Citrix server, video server)
Support, database administration ( Confidential SQL Server),
SQL Query Analyser, SQL Interprise Manager.
IT infrastructure organization, T-SQL programming.
Installation and maintenance of the PBX .
Software updates, IT equipment procurement, office equipment maintenance.
Accompanying inventory control software. .
Cisco Pix Firewall.
VPN channel. Configuring Citrix server.

We provide IT Staff Augmentation Services!

Data Services Engineer Resume

RedmonD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship