PROFESSIONAL SUMMARY:

Sr. Microsoft Developer/Architect with over 12 years’ experience developing custom solutions on the Microsoft platform, automated, enterprise level applications with particular expertise in Business Intelligence in SQL Server (SQL/SSRS/SSIS/SSAS). Power BI, SharePoint, C# (Sharp), VB Programming, Web Apps Development, TSQL, SQL Server & Oracle Databases. IT professional with written, listening, and verbal communication skills - able to interact very well with technical and non-technical client personnel. Self motivated posses superior troubleshooting and debugging skills.

SKILL:

Database: application Development 12 Years

Proficient in: Microsoft SQL Server 2014/2012/008 in backend

BI: ( Business Intelligence) 10 Years--SQL, SSIS, SSAS, SSRS, Integration, Analysis, Reporting and Database

Advanced query writing skills: Cursors, correlated sub-queries, Common Table Expressions (CTEs), views, Functions, system Confidential, triggersAdministrative Duties: Database design, backup, query optimization, performance tuning, index management, account creation, role assignments, replication

Proficient in: Microsoft Visual Studio 2017/2012/2010/2008/2005/2003 , SharePoint Designer MS Office2013, 2010/2007, Team Foundation Server (TFS), Visual SourceSafe

Crystal Reports: - 2008, SAP-Business Objects, SharePoint Administration, Content management, Design, Web parts-- 3 Years

Proficient in: C-Sharp (C# .Net), Visual Basic.NET, T-SQL, JavaScript, VBScript, VBA 5 Years

Framework: Dot NET 2.0, 3.5,4.0, Object oriented Technologies 5 Years

IIS6, 7: (Internet Information Services), Web Server Configurations, Deployment --5 Yrs.

EXPERIENCE:

Senior Business Intelligence Developer

Confidential, Houston, TX

Technologies: SQL Server 2012/2008, T-SQL, SSRS, SSAS and SSIS

Responsibilities:

• Developed and maintained custom data driven applications using SQL Server, Reporting, Analysis and Integration Services to track and automate Finance KPI’s such Investor Reporting, Payment System
• Developed SSRS reports from back end 2008, 2012 SQL Server and ORACLE Databases using Confidential
• Responsible for design and development of OLAP data cubes using SSAS 2008
• Responsible for design and development of SSIS packages using 2008
• Process Automation using ETL processes using SSIS
• Developed CRYSTAL reports and scheduled in SAP Business Objects

SQL /SSRS / SSAS/SSIS/ Dot NET Applications Developer

Confidential, Houston, TX

Technologies: SQL Server 2008/2005/2000 , T-SQL, SSRS, SSAS and SSIS, OLAP, T-SQL TFS, MOSS 2007, SharePoint Services, Performance Point

Responsibilities:

• Responsible for design and development of OLAP data cubes using SSAS 2005/2008
• Developed ETL process using SSIS packages to pull data from database to FTP
• Developed and automated SSIS packages to pull sales data from different sources and provided instant feedback
• Developed Payroll system in Web Application using C#. Net
• Responsible for query optimization; reduced a query that took 10+ minutes to just milliseconds and responsible for data replication between servers
• Developed 2008 SSRS reports and automated to generate dashboard drill down different business KPIs metrics to enable business make decision i.e. Sales, Ticket Average, Profit and Budget forecast
• Automated tasks using job schedulers, optimized Transact-SQL code, performed SQL query performance analysis and tuning on a regular basis
• Developed Applications to brand and track performances and generate daily SQL server reports for departments such as (Warehouse and Store Inventory Need), Ticket Changes to ERP system, Commission, Dashboard and Payroll Statement
• Developed applications to track huge volume of data from CUBE using SSAS (Analysis services) and tracked Sales performance Departments synchronize daily
• Developed Ticker (Kroger Comp Report) to track sales performance of sales associates
• Coordinated fellows’ developers to set standards to IT department documentation

SSRS / SQL/Dot Net Developer

Confidential, Houston, TX

Responsibilities:

• Developed application named RBA (Role Based Access) for Upstream and Downstream Oil Drilling using SQL
• Developed backed database Confidential application for resources planning and daily Transactions using SSRS
• Developed back end 2005 SQL Server Database using Confidential, Triggers, Transact SQL, Views and Queries

SSRS / SQL Developer

Confidential, Houston, TX

Responsibilities:

• Developed SSRS reports used for purchases and sales tracking using back end processes in SQL which replaced manual process (Paper System)
• And saved company money by 50%
• Developed back end 2005 SQL Server Database using Triggers, Transact SQL, Views and Queries

SQL Database and BI Developer

Continental, Houston, TX

Responsibilities:

• Developed SSRS reports in application named IPCS, (Integrated Production Control System) used for building and maintaining Aircraft
• Coordinated fellows’ developers in Aircraft Maintenance Department to manage project
• Worked as with team of developers and to make decision on the project
• Designed and developed SEARCH ENGINE for all Integrated data from Different Departments stored in 2005 SQL Database as well as work flow Of the planes in GUI (Graphical User Interfaces) for web and window Applications using C#
• Developed ALERT system (Automated alert) from Production Controller from SSRS daily routine and non-routine activities using SQL Confidential
• Developed Flow Task, Automated tracking of labor hours, active links to maintenance Manuals, Records department integration as well as generating

Applications Developer

Confidential, Houston, TX

Responsibilities:

• Developed Car Dealership Application using Dot Net
• Direct and focus the efforts of technical project teams and draw appropriate resources together to address technical issues.
• Developed backend data structures using 2005 SQL Databases
• Managed and provided supervision and guidance to Systems Analysts and Developers
• Ensures that all project lifecycle standards are adhered to by the IT team
• Develop weekly status-at-a-glance for IT Management