Ayesha Shabbir

AYESHA SHABBIR (- - LinkedIn PROFESSIONAL SUMMARY Detail-oriented SQL Developer with over 4+ years of experience in designing, developing, and maintaining complex databases. Proven ability to optimize database performance, implement data security measures, and ensure data integrity and having experience on creating SSIS packages for data migration. Seeking to leverage strong SQL skills and analytical mindset to contribute effectively to a dynamic team. Having Google Cloud Professional (GCP) certification for Professional Data Engineer, with strong cloud technology knowledge. A strong software development background and love to work with cutting-edge platforms and technologies. I bring extensive hands-on experience with Google Cloud Big Query and Data Studio. PROFESSIONAL EXPERIENCE ROYAL CYBER PVT. LTD Takamol Holdings Project Karachi, Pakistan 2019 –2024 Riyadh, KSA 2021 –2024 Senior Database Developer • • • • • • Designed and implemented database structures, tables, indexes, and SQL queries to support application development projects. Developed complex SQL queries, stored procedures, triggers, and functions to meet business requirements. Optimized database performance through query optimization, index tuning, and database reorganization. Implemented data security measures such as encryption and access controls to protect sensitive information. Ensured data integrity and performed regular data quality checks and maintenance tasks. Collaborated with cross-functional teams including developers, analysts, and project managers to deliver database solutions on time and within budget. • • • • Provided technical support and troubleshooting assistance to resolve databaserelated issues. Development of high-quality database solutions Analyze existing SQL queries for performance improvements Develop procedures and scripts for data migration. Mattress Firm Project Karachi, Pakistan- Junior SQL Developer • • • • • • • • • • Assisted senior developers in database design and development tasks. Wrote and maintained SQL queries, stored procedures, and scripts. Participated in database performance tuning and optimization efforts. Performs identification of data sources, data profiling, analysis, preparation, cleansing, and enrichment Conducted unit testing and supported integration testing of database components. Develops processes and queries used to extract data from source systems Responds to requests for data by writing queries to run over data warehouse and source systems on Big Query Write queries on big query to extract the data for validation and cleaning Write queries to do apple to apple comparison for historical data Documented database design, processes, and procedures. Finance Project Karachi, Pakistan- Junior BI/SQL Developer • • • • • • • • Designed and developed ETL processes to extract, transform, and load data from various sources into data warehouses. Created and optimized SQL queries, stored procedures, and views to support reporting and analytical applications. Developed interactive dashboards and reports using BI tools such as Power BI, Tableau, or similar. Conducted performance tuning and optimization of databases and queries to improve overall system efficiency. Collaborated with stakeholders to gather requirements, analyze business processes, and translate them into technical solutions. Provided technical support and training to end-users on BI tools and reporting solutions. Gathered and documented business requirements for analytical reports. Successfully delivered BI reports as per client requirement. • • Wrote effective DAX expressions for Power BI reports. Developed finance KPIs to track of metrics like revenue, cost and margin. NED University of Engineering & Technology Karachi, Pakistan 2019 -2019 Research Assistant • • • • Planned, modified and executed research techniques, procedures and tests. Collaborated with leadership team to identify relevant questions and determine best methods of collection. Assist in conducting research including data collection and compilation Flexibility in adjusting to new work-related requirements as they arise. EDUCATION NED University of Engineering & Technology Karachi, Pakistan- Masters of Engineering - Data Engineering and Information Management (DEIM) • • CGPA: 3.57 Coursework: ERP (Enterprise Resource Planning), Big Data Computing, Data Mining, Data Security and Audit, Machine learning, Information System Management, E-Business Management, Data Analytics NED University of Engineering & Technology Karachi, Pakistan- Bachelor of Engineering – Computer Information System (CIS) • • CGPA: 3.00 Coursework: Database System, Operating System, Artificial Intelligence, Parallel & Distributed Computing PROFESSIONAL SKILLS • • • • • • • • DWH/ETL: Google Big Query | MS SQL Server |MySQL Data Modelling: Schema design & good understanding of dimensional modeling SQL: Transact-SQL | Big Query-SQL | DAX queries BI Tools: PowerBI | Tableau | DAX Cloud Services: Good understanding of Cloud Environments specifically Google Cloud Platform Analytics: Elastic Search Big Data: Good theoretical understanding of Hadoop, Map Reduce, Spark. Other Tools: Google Sheet | PyCharm | Visual Studio|Jupyter Editor | Django Framework | SQL Integration Services (SSIS)| office CERTIFICATION • Google Cloud Certified Professional Data Engineer Credentials Information