Software Engineer Sql Server

Mubashera Shafiq

720-***-**** *********@*****.*** linkedin.com/in/mubashera/

Experienced software engineer specializing in the design, optimization, and management of high-performance database environments. Demonstrated success in resolving complex database issues, leading cost-effective cloud migrations, and improving system availability. Focused on delivering innovative, results-driven solutions that enhance operational efficiency and support strategic business goals. Ready to contribute deep technical expertise and advanced problem-solving skills to a dynamic product development team.

Technical Skills

SQL Server (MSSQL, SSIS,SSRS,T-SQL) PL/SQL C++ C Microsoft Power BI SAP HANA Jira Azure Data Factory MongoDB Confluence Bitbucket Jenkins Git ORACLE OIC(Cloud Application of EBS)

Shell Scripting Oracle UIPath PowerBI Kafka Python Azure Bash PowerShell

Core Expertise

Database Architecture/Infrastructure/Design/ETL Cloud Technologies Troubleshooting Business Analytics

Research New Product Development Collaboration Agile Automation Visualizations Performance Improvement

Customer Service Business Analyst Documentation

Professional Experience

Technical Systems Engineer, Cisco Research Triangle Park, NC 08/2022 – PRESENT

Enhanced seller experiences by designing and developing sales and compensation solutions (ORACLE INCENTIVE COMPENSATION), resulting in a 25% improvement in operational efficiency.

Translated business requirements into development tasks, writing optimized code and fine-tuning SQL queries to maximize system throughput.

Designed and implemented ETL processes, leveraging user-defined data structures and staging tables to load large datasets into Oracle databases using SQL*Loader.

Debugged and resolved PL/SQL defects identified in QA testing, improving system reliability and reducing production issues.

Designed and developed an internal AI chatbot for Cisco’s Incentive Compensation Processing (IICP) using Python and large language models (LLMs), enabling real-time query handling and documentation retrieval for operational support teams.

Worked in a 24/7 production support environment for Oracle Incentive Compensation modules.

Monitored and resolved application and database incidents using JIRA/ServiceNow and internal tools.

Automated data entry and streamlined calculations, cutting manual processing time by 40% through enhancements to the Key Sales Objective (KSO) module.

Owned the analysis and optimization of KSO source code, creating a flow diagram to map module interactions, identifying necessary changes for new functionality, and ensuring successful regression testing was completed within a given quarter.

Optimized database performance through advanced SQL tuning, indexing, and query optimization, leading to a 30% improvement in query execution speeds.

Oversaw database migrations and upgrades, ensuring seamless cross-platform data transfers with zero downtime.

Led the redesign of the Incentive Compensation Plan document layout, taking full responsibility for delivering new features and documentation on schedule by leveraging prior experience with similar implementations

Structured and maintained comprehensive technical documentation, diagrams for all the product-related changes.

Leveraged UiPath RPA to automate repetitive user interactions within Oracle EBS forms and reports, including data entry and validation tasks, significantly reducing manual effort and improving accuracy in incentive compensation and financial reconciliation processes.

Application & Database Analyst, Atyeti Inc. Raleigh, NC 05/2021 – 07/2022

Developed and deployed highly available database environments, designing and implementing Microsoft SQL Server and MongoDB for HADR (High Availability and Disaster Recovery) Enterprise setups to ensure business continuity.

Enhanced database throughput and performance by conducting in-depth query optimizations and indexing strategies, resulting in a 30% improvement in system efficiency.

Leveraged cloud expertise by achieving Azure database certification.

Administered and supported Azure SQL databases for automated data workflows across multiple departments.

Provided hands-on support for SQL Server integrations (SSIS), streamlining data flows and ETL processes, improving operational efficiency.

Designed and integrated dashboards using Power BI and Power Automate to enable workflow alerts, reducing manual status checks by 60%.

Created automated flows using Power Automate to process incentive compensation changes from emails to SharePoint entries.

Collaborated on extending Power Platform capabilities using custom connectors, improving cross-system interoperability.

Applied performance tuning, indexing, and query optimization to ensure efficient reporting for legacy and cloud-based environments.

Software Engineer (Oracle HCM), XDuce Edison, NJ 04/2017 – 02/2018

Migrated and converted enterprise data to establish a new company instance on Oracle HCM Cloud using HDL, ensuring seamless integration and minimal downtime.

Developed and optimized BI/OTBI reports within Core HR, Payroll, and Compensation modules, facilitating efficient data conversion and system implementation.

Created advanced cloud-based reports, including a BIP report for the Top 30 TCC-ranked employees, utilizing PL/SQL scripting to enhance reporting accuracy and decision-making.

Designed and maintained BI templates such as e-text, XSL, and RTF, significantly improving data reconciliation and migration processes across multiple enterprise systems.

.

Application and Database Consultant, Srinagar Technology Consultants India /US 05/2014 – 12/2016

Managed SQL Server 2008/2012 databases and created Linux VMs for testing.

Automated system provisioning and maintenance, reducing operational overhead.

Wrote and debugged complex Unix Shell scripts for automated deployment, provisioning, and file transfers in a hybrid data center environment.

Created scripts to monitor and alert on database health across SQL Server and Oracle platforms hosted on Linux VMs.

Used command-line tools (e.g., vi, curl, scp, ssh) to interact with servers and manage backend services.

Support and Solution Engineer - Microsoft SQL Server, Microsoft Bangalore, India 03/2008 – 01/2014

Resolved SQL-related issues for multiple enterprise customers, resulting in a 90% increase in customer satisfaction scores.

Trained junior team members and enterprise customers on SQL best practices, troubleshooting techniques, and query optimization.

Created and updated technical documentation for the internal knowledge base, improving accessibility for both customers and team members.

Collaborated between customers and development teams, implementing feedback that led to product enhancements.

Provided full production support for Microsoft SQL Server Suite (MSSQL SSIS, SSRS), reducing average resolution time by 80%.

Participated in on-call rotation and weekend support for production environments

Implemented preventative measures that minimized recurring issues, improving overall system reliability.

Optimized SQL queries and enhanced database performance, resulting in reduced resource usage and improved system scalability.

Created runbooks and documented standard operating procedures to streamline day-to-day operations and maintain consistent team alignment.

Education & Certification

Bachelor of Engineering in Computer Science, University of Gulbarga

Azure Database Administrator Associate, Microsoft

Azure Data Fundamentals, Microsoft

Azure AI Fundamentals, Microsoft

Microsoft Certified IT Professional (MCITP), Microsoft

Human Capital Management (HCM) Cloud, Oracle

Contact this candidate