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
