We provide IT Staff Augmentation Services!

Senior Data Warehouse Developer Resume

TECHNICAL SKILLS:

Data Warehouse:: Design and Implement EDW / Data Marts - Kimball and Inmon methodologies

SSIS ETL: Extract Transform and Load

SSAS: Multiple Dimension and Tabular Model

SSRS: Microsoft Dashboard Reports and Power BI

Exceptional skill in T: SQL Programing

Proficient in: C#, JAVA, VB, JAVASCRIPT, CSS, HTML, SQL, PL/SQL, MDX, XML, JSON

Familiar wif: PERL, CGI, PYTHON, ANGULAR

Database: SQL Server, Oracle, Teradata, Vertica, MongoDB, HADOOP/HIVE

Platforms: Microsoft Window 2008/2012, Linux

Web Server: IIS, Tomcat Apache, NODEJS

Framework/IDE: ASP.NET, GWT, SPRING, NETBEAN, ECLIPSE, TOAD

Microsoft Development: SSMS, Visual Studio 2008/2010/2013/2015/2017

Microsoft BI Stacks: SSIS, SSAS, SSRS, POWER BI

Software Design:: Object Oriented Principals - Inheritance, Encapsulation and Polymorphism

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Warehouse Developer

Responsibilities:

  • Implement new ETL processes loading data from ORACLE/TERADATA/VERTICA/FILE/HIVE
  • Performance Tuning and Troubleshoot existing SSIS packages
  • Writing variety of POWERSHELL/VB scripts for ETL processes
  • Design and Implement Multiple Dimension CUBE and Tabular Model
  • Performance Tuning existing CUBE for better performance
  • Troubleshoot CUBE wif MDX language
  • Design and maintenance variety of SSRS reports and Power BI
  • Troubleshoot SSRS reports and Power BI
  • Design Data Marts, DIM/FACT Tables, Indexes, Partitions in teh System
  • Create Stored Procedures/Functions/Views/Synonyms to support Data Warehouse
  • Analyze and fix complex Stored Procedures/Functions

Confidential

Senior Database and Web Developer

Responsibilities:

  • Implement Tables/Indexes/Functions/Stored Procedure/Views for transactional Database
  • Design and maintain SSIS packages to transfer data from variety of sources
  • Responsible for DEV/TEST environments as DBA
  • Create and maintain websites using JSP wif JAVA, JQUERY, JAVASCRIPT, HTML, XML
  • Create and maintain websites using ASP.NET wif C#, JQUERY,HTML, XML
  • Create Window App for various clients using C# and JAVA SWING
  • Work wif team to design teh GATEWAY software to handle Credit Card payment processing

Confidential

Senior Database Engineer

Responsibilities:

  • Design and Implement new SSIS packages to load data from internal/external sources
  • Performance Tuning and Troubleshoot existing SSIS packages
  • Build and maintain Data Warehouse Architecture wif Kimball and Inmon methodologies
  • Design and Maintain SSAS CUBE for financial reports and Data Mining
  • Writing MDX queries for CUBE troubleshoot/debug and maintaining

Confidential

Database and Web Developer

Responsibilities:

  • Implement Tables/Indexes/Functions/Stored Procedure/Views for transactional Database
  • Performance tuning for Functions/Stored Procedures
  • Responsible for DEV/TEST environments as DBA

Confidential

JAVA and Web development

Responsibilities:

  • Implement JAVA Applet to read PINPAD from payment process device
  • Design and maintain a very busy website for payment processing
  • Writing COM objects and library using across company’s applications

Hire Now