SUMMARY:

• MS in Information Technology and BS in Computer Science.
• Extensive of experience in Data Analysis, Database Design, and Development with SQL Server (2005, 2008, 2012, 214): 8 years.
• Experienced in Business Intelligence (BI) solution with SQL Server includes SSIS, SSAS, and SSRS: 3 years.
• Expert in T - SQL programming as store procedure, function, view, triggers, curser, CTEs, indexes: 8 years
• Good knowledge in implementing ETL process using SSIS packages(SQL server 2012, 2014): 3 years
• Experienced in SSAS (SQL server 2012, 2014) to design, implement Date warehouse, Data Marts, and Multidimensional Cubes: 3 years.
• Practical Experience in Design, Deploy analytical Reports in SSRS (SQL server 2012, 2014): 3 years.
• Practical Experience in Analyzing, Designing, Implementing of OLAP Cubes with SSAS(SQL server 2012, 2014) and calculation of queries with MDX, DAX: 2 years.
• Experienced in using reporting tools for BI: Power view, Excel which exploit power pivot, DAX: 3 years
• Experienced in DBA installing, configuring, backup and restore strategy, build/rebuild indexes in SQL Server: 5 years.
• Good knowledge in .Net development programming WPF, MVC with c#: 2 years
• Highly experienced in using SQL Server Data Tools (SSDT) 2012, 2013 for SSIS, SSAS, and SSRS: 3 years.
• Expert in software analysis, design and problem solving with using RUP methodology and agile methodology SCRUM: 10 years

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Developer/SSAS/SSRS/SSIS

• Generated variety of business reports using SQL Server (2012, 2014) SSRS including drill-down, Dashboard with charts, Tabular Reports; built reports from SSAS cube using MDX.
• Involved in designing and developing high efficient architecture and structure for relational data warehouse system as a foundation of OLAP and BI.
• Developed and deployed SSIS packages using effective DTS components as Lookup, Derived Columns, Condition split, etc. to load data from OLTP to Data Warehouse system.
• Effective analyzed, designed, implemented OLAP (Multi-Dimensional) Model in SSAS based on Business Requirements to gain Analytical reports in terms of increasing productivity.
• Created SSIS package to import Data from the OLTP system to Data Warehouse and Data marts which are source of OLAP system.
• Created OLAP cubes using SSAS to analyze the status of sales, calculation of queries with MDX.
• Scheduled jobs for executing the SSIS packages which were developed to update Data Warehouse/Data marts on daily basis using SQL server Agent.
• Created a variety of Reports as Drill-Down reports, ad-hoc reports, Tabular reports, and Matrix reports by using SSRS to increase efficiency and flexibility of Analytical Reports.
• Generated variety of practical and complicated business reports from SSAS with using MDX to evaluate cost/benefits and cost value.
• Highly involved in automating Reports generated weekly and monthly basis as client requirements.
• Designed and created high efficiency Dash board management reports with implementing KPI (Key Performance Indicator) and other practical objects in SSAS.
• Used ETL to implement the SCD (slowly changing Dimension) transformation to maintain historical data in data warehouse. As well as designed and created SSIS packages to other data transformation like aggregate, sort, multicasting, derived columns and etc.
• Designed ETL packages using DTS with different data sources (SQL server, CSV, Flat Files, XML) and loaded the data into data destination by using SSIS.

Confidential

SQL Server Developer

• Efficiently involved in ERP team to establish and deploy ERP modules for all Departments (Management, Sales, Financial, Accounting, and Warehouse).
• Created Store Procedure, Views, Functions, Triggers with writing complex SQL queries using joins, sub queries, correlated sub queries to retrieve data from the data base (OLTP) based on business requirements as well as to optimize of existing T-SQL queries and views.
• Maintained and optimized existing reports with creating/rebuilding indexes to increase the performance of system.
• Designed and created complex reports as power users requirements of sales and marketing department to precise analyze of status quo, as well as scheduled plan for annually budget.
• Created ETL packages using DTS to extract data from other sources such as Excel, Access, and flat file into OLTP database for ERP system.
• Highly involved in creating practical report with accurate data for Top managements to evaluate the situation of whole business, analyze KPI, Cost accounting, etc. to make strategic plan.
• Maintained high efficacy of Data Base System with creating practical Indexes as well as rebuilding indexes to achieve better performance.
• Created Scheduled Jobs for migration data using SQL Agent.
• Designed and implemented a backup and recovery solution with efficient schedule for Full, Differential,

Confidential

SQL Server Developer/Data Base Developer/ETL Developer

• Highly involved in ERP project team to define, design, analyze Business requirement to establish ERP system as RUP methodology.
• Designed Data Base structure based on ERD as business requirements, as well as developed and created Data Base objects such as Tables, views, Store procedures, Functions to map data into Data Base (OLTP) and retrieve data from Data Base in SQL Server2008.
• Managed Database performance by creating indexes, triggers, and views.
• Designed and developed a variety of reports for all departments ( Sales, Marketing, Financial, Accounting) in crystal report by writing complex T-SQL queries with using joins, sub queries and correlated sub queries to retrieve data, as well as using Database objects as views, Store Procedures, Functions to optimize Reports and make them more efficient.
• Created ETL packages to validate, extract, Transform and Load Data from different data sources (SQL server, CSV, Flat Files) into new database structure in ERP system by using SSIS.
• Highly involved in Construction and Transaction phase particularly in integration test done by power users and end users with real data to implement all modules.
• Created SQL Server Instances, Installation Configuration, Managing Server and Security for Construction phase of ERP project.
• Experience in maintaining security policies in both server level and database level security by creating logins, users, configuring permissions and assigning different roles to users based on business requirements.
• Migrated data from different data sources and loaded data into target tables using DTS.
• Managed Logins, Users, Configured permissions and assigning roles to users.
• Wrote complex Queries, Views, Stored Procedures, Triggers and Functions.
• Performed optimization of existing SQL Queries, Indexes, Stored Procedures, Function and Views.
• Schedule package using SQL Server jobs.
• Scheduled reports monthly and weekly based on employee’s requirements.

Confidential

SQL Server Developer/Web Developer

• Created SQL server instances, installation configuration for three isolated software applications (Financial, Procurement, Human resources).
• Provided functional Reports based on T-SQL Queries with using store procedures, views to meet business’ requirements.
• Maintained and managed security policy by creating users, and assigning appropriate permissions to users.
• Created database backup automated scheduling jobs to enhance reliability.
• Created indexes and rebuild them to increase performance and efficiency of database system.
• Created Scheduled Jobs using SQL Agent.

Confidential

Software Analyzer & Designer/Asp.Net Developer

• Gathering user’s requirements, analyzed, and designed software solution and database for Human Resource, Procurement, and Warehouse system includes Business Modeling, Business workflows Class diagrams using UML.
• Designed, implemented web base software application for Human Resource, warehouse and Procurement system with Delphi, Asp, Asp.Net, C#.
• Designed and developed database system in SQL Server 2000 using ER diagrams, Normalization and relational database concept.
• Involved in creating tables, views and functions, store procedures based on business requirements.

TECHNICAL SKILLS:

Databases: SQL Server 2005,2008, 2012,2014

BI Solution: SSIS, SSAS, SSRS (SQL Server 2012, SQL Server 2014)

ETL, SSIS, SSAS Tools: SQL Server Data Tools( 2012, 2013,2014)

Languages: T-SQL, MDX,C#.Net, HTML, CSS

Environment: Visual Studio 2012, Visual Studio 2013

Reporting tools: Power view, Excel

Software analysis methodology: RUP, Scrum