AHMED ABUBAKAR
Contact #.: +923**-*******
Email: ac7rp8@r.postjobfree.com
Career Objective: A Database/BI with newly acquired skills, an insatiable intellectual curiosity, and the ability to mine hidden gems located within large sets of structured, semi-structured and unstructured data. Able to leverage a heavy dose of mathematics and applied statistics with visualization and a healthy sense of exploration.
Work Experience:
IBEX CX.
Designation: Senior Software Engineer (Lead BI & Databases) Duration: Sep 2012 to Present.
Company Description: TRG iSKY is a market research; analytics and consulting firm that specializes in helping its clients manage their customer relationships and promote their brand equity. Job Description: Major Responsibilities Includes Business and Technical Support to client operations. Besides this, following are my job responsibilities.
Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server for the SSAS cubes.
Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
Extensively worked on OLAP cubes using SSAS.
Created and Managed OLAP Cubes using SSAS.
Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
Used SQL Profiler to optimize queries and enhance the performance of database servers.
Coordinate with QA for bug free release.
Requirement analysis/gathering for new modules.
Resource mentoring.
Code reviews of the database scripts.
Coordinating with DBAs for the smooth functioning of Product databases.
Presentation of DB architecture in meetings.
Writing Summarization (aggregation of stats and scores) of surveys for Organizations on geographical hierarchy basis.
Presentation of DB architecture in meetings.
Data analysis.
Clients: Toyota Motors Europe (Production Team Lead),Honda NA (Lead Developer), Bentley UK (Lead Developer), William Hill (Lead Developer)
Net sol Technologies Inc.
Designation: Software Engineer (Database Developer) Duration: Apr 2011 to Sep 2012.
Company Description: Net Sol Technologies Inc. (NASDAQ:NTWK) is a US -based, worldwide provider of IT services and enterprise solutions for leasing and finance, health care technology, insurance, and e- Procurement.
Net Sols' commitment to quality is demonstrated by its achievement of the ISO 9001, ISO 27001, and SEI CMMI Maturity Level 5 assessments, a distinction shared by fewer than 140 companies worldwide. Net Sol Financial Suite (NFS), the company's flagship set of credit and finance tools, offers solutions for credit application management, finance contract accounting and portfolio management, wholesale floor planning, and fleet management. Net Sol Financial Suite – a comprehensive lending solution that satisfies the wide and varied needs of multi finance organizations. Job Description: Worked on Contract Management System of NFS Suite, Major Responsibilities Includes Client Database Production Support, Development of Enhancement, Modifications, Unit Testing, RS/FS Documentation, Databases Optimization and Refactoring, Release Management, Fault Fixing, Maintenance of Project, Data Modeling and DB server Maintenance. Clients: Volvo China, Toyota China
Environment: MS SQL Server, Oracle, Power Builder,SVN Technical Skills:
1. Data Analysis Skills and Tools
Hadoop Ecosystem (Cloudera)
Data Pipelines (Spark,kafka,Sqoop,pig)
Python 2.5.1
Apache Spark
2. Programming Languages:
C/C++
C#.Net
Java
Power Builder
3. Databases / DB Tools:
Oracle 9i/10G/11G,
PL/SQL Developer
Quest Toad
MS SQL Server 2005/2008
Query Optimization
Database Optimization
Data Modeling
DB server Maintenance
SSIS (Sql Server Integration Services)
SSAS (Sql Server Analysis Services)
Denodo
Informatica
Trainings:
SQL Server 2008: SQL Basics Training
Software Configuration Management
Power Builder
Conduct In-house training on Informatica 9.5.
Academic Qualifications
2006 – 2010
2. Level: FSc (Pre-Engineering)
Major: Physics & Mathematics
Location: Lahore, Pakistan Year: 2004– 2006
Name of Institution: Punjab College of Science
1. Level:
Location:
BSc (Hons) Computer Sciences
Lahore, Pakistan Year:
Name of Institution: Punjab University College of Information Technology