Shakeeb Ali
Tel: 404-***-**** Email: *********@*******.***
OBJECTIVE:
To obtain a position that allows me to leverage my analytical and technical SQL skills to understand client business needs, gather requirements, solve short and long term technical problems through SQL querying, and to operate as a liaison between clients and development teams.
SKILLS:
Advanced in Microsoft SQL Server, Oracle PL/SQL and T-SQL Scripting
Keen ability to translate Business User Needs to Technical Software teams and vice versa via SQL Scripting
Ability to Digest Complex issues into simpler problems and solutions by breaking down complex SQL queries into much simpler SQL scripts
Advanced in MS Word, Excel, and PowerPoint 2007, 2010 including Pivot Tables and V-LOOKUPS
Strong sense of Ownership and Accountability
Able to Multi-Task successfully while delivering high quality output
Works well under pressure and with tight Time Constraints
Excellent Organizational Skills
Excellent Communication Skills with Internal and External Clients, Peers, and Executive Management
Zeal to learn and grow as a Technologist
Fluent in Arabic, Urdu and Punjabi
EXPERIENCE:
Nov. 2014 – Current Financial Reporting Supervisor
UPS SCS Int’l Finance & Accounting, Sandy Springs, GA
Conducted variance analysis on Profitability reporting output values
Created tests for data values to ensure proper design, maintenance, and functionality of database reports and output fields
Wrote new SQL code using standard practices to meet departmental objectives
Solved system problems by identifying and applying resolutions to ensure proper system operations
Provide the region with financial variance reporting to obtain explanations and corrective measures through Oracle Database Queries
Provide on-going feedback and Querying support to improve performance of Global Profitability Reporting Team by use of Oracle Business Intelligence, a BIA tool
Researched Oracle SQL code to identify root causes for variances and implement corrective measures by updating Oracle queries in framework
Input approved Business Plan and month end Data into the Financial Planning and Reporting System to create a baseline for new business plans.
Researched Reporting requests by creating dashboards and pivot tables from Oracle Business Intelligence tool and helped explain variance to field
Dec. 2013 – Oct. 2014 Sr. Operations/Finance Analyst, Solutions- Ista North America, Alpharetta, GA
Create daily Operational Performance report used to determine KPI goals for Operations team through Extensive use of Microsoft SQL Server
Create Ad Hoc Reports on demand by Extracting, Manipulating and Proactively finding/fixing Data Anomalies through SQL Queries
Perform Data Cleanups for Clients including but not limited to impacted accounts list, short-term workaround/solution and create ticket for Product Support (long-term solution) using MS SQL Sever
Provide/Review weekly and Month End financial reports to present to Executive Level Management and Finance Department through Dashboards and Pivot Tables in Excel. Report Data is gathered through Complex SQL queries
Create User Stories, Requirement Documents and Acceptance Criterias for Long Term solutions. Test Long Term fix in User Acceptance Environment to ensure ticket is ready for Production Environment. Data gathered for testing purposes are provided through SQL scripts
Subject Matter Expert of Product Management, which is derived from the Joining of multiple tables within Ista’s Database. In sum, Product Management can be written in SQL queries
May 2008 – Apr 2011 Finance manager, Operations/Data Analyst - Jan 2012 – Nov 2013 Atlanta Best Used Cars LLC, Norcross, GA
Review sales/financial analyses (what sold/did not sell; determine which vehicle makes and models have potential to move up in sales; cost/benefit analysis) through the use of Pivot Tables
Predict trends in seasonal/consumer lifestyle; conduct customer focus groups and analyze/synthesize findings. Scan business/industry trends and analyze consumer data
Forecast and interpret sales data based on statistics and procedures used. Provide financial data to general managers to support decision making in purchasing. Provide input on forecast based on knowledge of consumer trends through Graphs, Pivots Tables and Dashboards
Synthesize research findings to derive conclusions from analyses and make oral/written recommendations to Executive management. Execute tasks related to core operations projects and/or process improvements by creating Use Case Diagrams
Clarify and resolve complex business issues by breaking them down into meaningful components to determine root cause and redesigning internal and external business processes
Estimate costs to manage budgets, forecast costs, and provide information to account for the financial impact of decision-making
May 2011 – Dec 2011 District Manager Internship - Dollar General Corp. Goodlettsville, TN
Partner with vendors to develop and implement replenishment strategies that maximize sales and inventory productivity for a given category
Maintain appropriate inventory stock through the use of Telxon software to achieve target in-stock levels. Planned inventory sales in order to allocate inventory in the most effective manner across both stores and SKUs
Forecast and budget orders with merchants, stores, distribution centers and suppliers to maximize sales and reduce overstock
Create accurate SKU forecasts to execute replenishment strategy, reduce shrink, and develop recommendations to improve inventory productivity
Perform data management through a combination of data modeling, data analysis, cost/benefit analysis and/or problem analysis; while executing day to day processes related to district of responsibility
EDUCATION:
July 2012 Bachelor of Business Administration, Managerial Sciences
Georgia State University- Robinson College of Business