✅ ♛ TOP-RATED ✅ 100% Job Success
With over 15 years of experience in IT, I have a strong background in database programming, software design, and development.
I have extensive experience in the field of software and database design, development, and testing, spanning projects of various sizes. With my years of expertise, I can assist clients in enhancing and implementing system features across all levels. I am a collaborative team member who delivers top-notch quality results at a reasonable price.
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
---------------
- Web scraping and data mining
- Data conversion (PDF to Word, Excel, XML, etc. Vice Versa).
- De-Duping and Merging data using fuzzy matching and DB scripts, Excel functions and Macros
- Data Entry