SUMMARY:

• SSIS - Transferring data from various sources, like FILE, VERTICA, ORACLE
• SSIS - Proficient in Data Flow and Control Flow
• SSIS - Cleaning, Refactor, Transform data from Sources to Data Warehouse
• SSIS - Monitoring ETL processes via various automatically ways
• SSIS - Design Parent-Child design, Design SSIS Framework Patten
• SSIS - Design Parameters and Variables for deployment in different environments
• SSIS - Performance Tuning, Review, Redesign the Package for the best Performance
• SSAS - Design and Maintain CUBE and Tabular Model
• SSAS - Design CUBE Partitions/Aggregation, ROLAP, MOLAP
• SSAS - Performance Tuning CUBE for the best Performance
• SSRS - Design and Maintain varieties of SSRS Reports
• SSRS - Performance Tuning SSRS Reports for the best Performance
• MDX - Writing varieties of MDX Scripts for CUBE development and troubleshoot
• MDX - Writing varieties of MDX Script for SSRS Reports
• Design and Maintain Data Warehouse based on Kimball and Inmon methodologies
• Design and Maintain Dimensional Database Warehouse
• Design and Maintain DATA MARTS to support CUBE and SSRS Reports
• Exceptionally Skill in T-SQL Programing
• Design and Maintain Stored Procedure, Functions using in Database
• Performance Tuning for all Database Objects, make sure the best performance
• Monitoring and Troubleshooting all Blocking, Deadlock in the database system
• Using varieties of DMV to track out what’s going on in the system
• Design TABLE, INDEX, VIEW, TRIGGER, SYNONYMS, SEQUENCE, CLR Function
• Specialize on Internal Architecture, Data Lock Mechanism, Transaction Isolation Level
• Analyze Execution Plan, SQL Server Profiler for the best performance
• Design Transactional Database, Data Warehouse, logically and physically
• Monitoring Database Performance across the system
• Implement User Security at varieties of Level
• Design and setup User Login, User Role, Database Role, Server Role in the system
• Design and implement Replication for Transactional Database
• Implement Object Oriented principle - Inheritance, Encapsulation and Polymorphism
• Strictly follow MVC methodology, Agile and Scrum principle

SOURCE CONTROL: GIT, TFS, Microsoft Visual SourceSafe

LANGUAGES: C#, JAVA, VB, JAVASCRIPT, CSS, HTML, SQL, T-SQL, PL/SQL, MDX, XML, JSON, JQUERY

WEB DEVELOPMENT: Develop Websites with: ASP. NET, NETBEANS, ECLIP, GWT, IIS, LINUX

ADITIONAL SKILLS: ORACLE 9g/10g/11g/12c, HBASE, HIVE, Vertica, MongoDB BIG DATA: HADOOP, SPARK, HBASE, PIG, HIVE, SQOOP

PROFESIONAL EXPERIENCES:

Confidential, Alpharetta, GA

Senior Database Engineer

Responsibilities:

• Design and maintain SSIS packages to transfer data from variety of sources
• Design and Maintain SSAS CUBE for Business Intelligence purposes
• Design Transactional Database, Database Warehouse and Data Mart
• Design Tables, Clustered and Non-Clustered Indexes for the best performance
• Design and tuning Stored Procedures, Functions and all database objects
• Responsible for Database Issue on PRODUCTION
• Create Library of Stored Procedure, Functions to reuse across applications
• Work as Mentor to teach Junior Database Developers on Database Technologies
• Responsible for DEV/TEST environment as DBA
• Design and maintain application for Payment Processing and report websites
• Design and maintain variety of automatically processes

Confidential, Atlanta, GA

Senior Business Intelligence Developer

Responsibilities:

• Design and maintain SSIS packages for variety of ETL/ELT processes
• Design and Maintain SSAS CUBE for financial reports and Data Mining
• Design and Maintain SSRS Reports for different Departments
• Performance Tuning for Stored Procedures, Functions, Views, Triggers and all database objects
• Writing MDX queries for CUBE troubleshoot/debug and SSRS Reports
• Build and maintain Data Warehouse Architecture with Kimball and Inmon methodologies
• Design Tables and Database Object for VERTICA database
• Import/Export data back and ford between VERTICA and SQL SERVER/ORACLE

Confidential, Alpharetta, GA

Senior Database and Web Developer

Responsibilities:

• Design and tuning Stored Procedures, Functions for all applications
• Design Transitional Database for very busy Web Applications
• Design Tables, Clustered and Non-Clustered Indexes for the best performance
• Responsible for Database Issue on PRODUCTION
• Create Library of Stored Procedure, Functions to reuse across applications
• Responsible for DEV/TEST environment as DBA
• Responsible for Replication on DEV/TEST environment
• Design and maintain variety Web Applications, using ASP.NET and JAVA
• Implement COM objects and library using across company’s applications
• Implement Applet to read PINPAD from payment process device

Confidential, Roswell, GA

Web and Database Developer

Responsibilities:

• Design and maintain Tables and Indexes in SQL SERVER and ORACLE
• Design and tuning Stored Procedures, Functions in SQL SERVER and ORACLE
• Design and maintain Payment Processing
• Maintain debug all Web Applications related to Payment Processing reports
• Implement variety of COM objects used in related applications

Confidential, Duluth, GA

Web and Database Developer

Responsibilities:

• Design and maintain Tables and Indexes in SQL SERVER
• Design and tuning Stored Procedures, Functions in SQL SERVER
• Implement internal department website internal department Web Applications, using ASP with VB
• Work with contractors to update and fix bugs for their applications
• Implement variety COM objects used in variety applications