SQL Server/Business Intelligence Application Developer Resume Plano,Texas - Hire IT People

SUMMARY:

A 15+ year experience with advanced MS degrees, specializing in design, proof of concept prototyping and implementation by using state - of-the-art IT technologies, possessing both high level design perspective and hands-on detail development/coding capability, with expert knowledge spanning from high availability back-end systems to data warehouse solutions.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, Texas

SQL Server/Business Intelligence Application Developer

Responsibilities:

Working on a custom solution to replace SQL Server Agent job due to corporate security restriction, this enables users to schedule, execute SQL jobs and check for results afterwards.
Involve in all aspect of database development, including stored procedures, triggers, DB table designs, archive and backup strategy etc.
Work closely with Business Analysts on requirement, design data mart, present proposed solutions and provide answers to the management team.
Monitor daily, weekly data feeds from different sources, such as other SQL DB, Oracle, TERADATA, flat files
Develop new and debug existing SSRS reports, SSIS packages

Confidential, Richardson,Texas

Business Intelligence Engineer, SCRUM Master

Responsibilities:

Using Agile methodology to keep track, prioritize tasks in each Sprint, conduct daily standup meeting
Create, modify new or existing SSRS 2012 based matrix and dashboard reports
Perform monthly data loading in OLTP database, OLAP cubes processing, ensure timely execution of deadlines, monitor and debug any ETL issues
Interact with business team to gather and ensure accurate and comprehensive understanding of client’s business requirement, create tickets in JIRA during sprint planning.
Set up MS MDM (Master Data Management) project and Excel spreadsheet plugin for client team and business analysts. This enables BAs to work on dimension data refresh without helps from BI engineers.
Integrated MDM solution with existing ETL (SSIS) package, automated lookup/reference table update process.

Confidential, Carrollton,Texas

Data Warehouse Consultant, Enterprise Data Warehouse Team

Responsibilities:

Designed and Developed SSIS packages, configuration files, gathered requirements
Created data mart entities, fact, dimension tables using STAR schema.
Configured MDS (Master Data Service) and manipulated data using SSIS, TSQL.
Worked from multiple source data, such as Excel, flat file, Postgre, loaded and transformed them to Stage/ODS/DW with ETL tool
Created a system for reporting, capturing data errors, in-depth knowledge of data mapping, process documentation and data modeling.

Confidential, Irving,Texas

Lead Software Developer

Responsibilities:

Bundle Qualification Tool Backend (BQT BE) is a key component of Confidential ’s ordering system. It is used to revalidate orders and promotions given to bundle customers whose order include voice, data or TV product and apply credits accordingly. Act as a main onshore contact, working closely with both business client and offshore team, responsible for release deployment, validation, trouble tickets, IR escalation.

Environment: ASP.NET 2.0, Windows Services, .NET Framework 4.0, C#, ADO.NET, Enterprise Library, XML, XSLT, Oracle PL/SQL, SQL Developer, UNIX, Windows Server 2008 R2

We provide IT Staff Augmentation Services!

Sql Server/business Intelligence Application Developer Resume

Plano, TexaS

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship