Sr. BI Developer/Architect Resume Dallas, TX - Hire IT People

SUMMARY:

An accomplished, quality - driven IT professional with over 15 years of experience in design, development and implementation of business requirements as a Microsoft SQL Server 2016/2008/2005 Developer/BI Developer/GCP Cloud Developer
Extensive experience in Google Cloud Solutions, Cloud Storage, BigQuery, BigTable, Pub/Sub, DataFlow
Extensive experience in BI Solutions (ETL & Analytics) using SSIS, SSRS, SSAS
Experience in implementing Incremental Data Load from OLTP to Data warehouse using SSIS Patterns
Excellent communication, presentation and interpersonal skills
Utilizing SSIS Framework & Templates, BIDS for ease of dev and maintenance.
Migration of SSIS 2005 & 2008 packages to 2012.
Built a data warehouse architecture using star schema and loading with different patterns
Created packages using transformations - SCD, Lookup, Aggregate, DerivedColumn, Fuzzy Lookup
File handling that involves ftp, sftp, archiving & extraction and dynamically generating SSRS reports.
Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies
Data driven subscriptions, Kerberos deployment, SSAS Reports, CSS for Chrome/Safari compatibility
Implemented Proactive Caching, Usage Based Optimization and Partitioning in SSAS
Convert Distinct Measures to Calculated Measures
Optimizing Hierarchy for faster Processing
Migration on-premise data to cloud big data
Developed python scripts to load files/data into GCP
Created cloud solutions using Big Query, cloud storage, Dataflow
Involved on ITIL process for Change/Incident - Management using tools.

TECHNICAL SKILLS:

Databases: SQL Server 2016/2008/2005

BI Solutions: SSIS, SSRS, SSAS, PowerBI.

Modeling Tools: Embarcadero ER Studio

Source Control Tools: Visual Source Safe, Clear Case, Team Foundation Server, SVN

Cloud Solutions: GCP Cloud Storage, BigQuery, BigTable, Pub/Sub, DataFlow

EMPLOYMENT DETAILS:

Confidential, Dallas, TX

Sr. BI Developer/Architect

Responsibilities:

Develop and Design ETL for SEED Architecture using SSIS and SSAS
Salesforce ETL integration using DB Amp and Identity Connect.
TM1 Migration and Development
Great Plains Collation Migration
General DBA, On Call, Build activities

Confidential, LittleRock, AR

Sr. BI Developer

Responsibilities:

Setting up data ware house for the Insurance domain
Implemented Attunity Tool for Change Data Capture from Oracle and SQL Server
SQL Server partition management for missing partitions
Ad hoc SSIS/SSRS reporting development

Confidential

SSIS/SSAS Developer

Responsibilities:

Imported data from multiple data sources into Excel workbook using SSIS
Created Data-driven Packages in SSIS 2008R2 as part of the automating the process for accommodating DEV/QA/PROD environments.
Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.

Confidential, Seattle, WA

BI Developer

Responsibilities:

Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
Migration of DTS packages to SSIS packages
Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS
Running DTS/DTSX Packages for Failed Jobs
Monitoring using wide range of Quest tools that includes Spotlight, Performance Analysis

Confidential, SanFrancisco, CA

SQL Developer/DBA

Responsibilities:

Responsible for development of stored procedures, triggers and ETL scripts.
Ensure all database environments (Development, Staging, QA and Production) are in sync. Define db scripts versioning system to keep track of database versions for all environments.
Proactively monitor the Production Database and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.
Provides application support for QA and Development groups.

We provide IT Staff Augmentation Services!

Sr. Bi Developer/architect Resume

Dallas, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship