✅ ♛ TOP-RATED ✅ 100% Job Success
20+ years of IT Experience in software design, development, and Database Programming.
Designing, developing, and testing software and databases from small scale to large scale. My years of experience in this field will help clients to apply and improve the features of the Client's system at any level.
A good team player and a hardworking professional provide high-standard quality output at an affordable cost.
Database Expertise
-------------------------
Offering professional solutions to complex database design, database maintenance, data analysis, and optimization techniques both On-Premise and cloud.
• MS SQL DB Architect and MS BI Developer/Lead.
• Database architect
• Expert MS SQL Server 2008R2, 2012 to 2016, SQL Azure.
• Expert T-SQL Programmer - Stored Procedures, Views, and Complex queries.
• Query performance tuning and database performance tuning. Worked with 10 clients and fine-tuned various slow-running queries and reduced gained 180% improvement in its execution time.
• BIDS, SSIS, SSAS, SSRS, Experience in developing and Production Support MSBI.
• Azure IaaS virtual machine and SQL Azure - We support database administration on-premises and
• Open Source MYSQL, NoSQL, MongoDB, etc… ANSI-SQL, PL/SQL, T-SQL.
• Data modeling, performance tuning, optimization, DB maintenance plan, etc…
• Data Mining, Data Analysis, Machine Learning
• Power BI, Crystal Reports, MS-Chart, and MS-Report Viewer.
• Log shipping, clustering, and replication for High Availability of SQL Server
• Forward Engineering, Reverse Engineering
• Expert in T-SQL development to write complex queries by joining multiple tables, excellent ability to develop and maintain stored procedures, triggers, and user-defined functions
• Expert in Data Extraction, Transforming, and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Azure Data Factory (ADF)
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services.
Application/ Website Design, Branding/ Reporting Expertise
----------------------------------------------------------------------------
We have extensive experience in functional, technical end-to-end design, development, and maintenance of enterprise, Retail applications, and online websites.
• ASP.NET, C#, VB.NET, Classic ASP.
• VBA Macros/ VB 6.0/ MS Access/ VBA Macro/ MS Excel/ MS Outlook Programming.
• HTML/HTML 5/ XHTML/ CSS, JavaScript/ VB Script, PHP.
• WCF, WPF, Web services (Amazon, REST/ SOAP), LINQ etc.
• Entity Framework, .Net framework.
• Java, Servlets, JSP, Hibernate, XML, Spring, Spring Boot, Websphere Application Server
• JSON/ XML.
• E com - Engaged in the development of Data-Oriented Web Sites and Apps.
• Magento/ Wordpress / WooCommerce.
• Branding/ Logo Design/ Graphics using Adobe Illustrator
• Cloud Engineering Microsoft Azure.
• Remedy (Ticket Tracking System)
Automation
----------------
- SmartSheets to MS SQL Server
- XML to SQL Server SSIS
- Box Cloud Storage Integration
- C# MS Office Add-in
Data Mining
---------------
- Data Entry
- Web scraping
- Web Research and data mining
- Data conversion (pdf to Word, pdf to Excel, pdf to XML, etc... and Vice Versa).
- De-Duping and Merging data using fuzzy matching and DB scripts, Excel Vlookup, Hlookup, Macros

SQL
Stripe
Excel Macros
PostgreSQL
MySQL
Web Scraper
Query Tuning
Data Cleaning
Database Architecture
Lead Generation
Microsoft SQL Server Programming
ETL
SQL Server Integration Services
Database Programming