umer akram, Senior Business Intelligence/Data Warehouse Developer

umer akram

Senior Business Intelligence/Data Warehouse Developer

Strategic Systems International

Location
Pakistan - Lahore
Education
Bachelor's degree, BCS Honors
Experience
18 years, 2 Months

Share My Profile

Block User


Work Experience

Total years of experience :18 years, 2 Months

Senior Business Intelligence/Data Warehouse Developer at Strategic Systems International
  • Pakistan - Lahore
  • My current job since March 2013

Designing databases for new and revamped products.
Data analysis and data standardizing for creating a master data for a client.
Design data warehouses and ETL design for processing raw data for analytics related application for new clients.
Analyze and integrate data provided by different GPOs like SCA, UMMC, FMOL, UCSD and Beaumont for multiple products.
Analyzed and developed various change requests and used performance optimization techniques for multiple products.
Developing, troubleshooting and Configuration of SSIS packages for ETL module in ROI product.
Trained new employees as a member of training program set by company.
Communication with Clients.
Co-ordination with Higher Management.

Principal Software Engineer at Netsol Technologies
  • Pakistan - Lahore
  • November 2010 to March 2013

Gather Requirements for Gap analysis and new functionality to embed into the existing application.
Analyzed client’s requirements designed flow diagrams, reviewed and wrote functionality points in the FS before sending to client for the approval on key processes changes or enhancements.
Worked as technical lead to monitor development of leasing/financing application and allocating team members on different task on their ability to perform.
Manage team members’ work matrix in order to for seek their availability for the upcoming and pending tasks. Performed code review on code written by team members in order to check if all the functionality points and standards are met. Fill outs evaluation sheets for team members based on their quarterly, half yearly and yearly performances.
Responsibilities included quick respond to trouble tickets, prioritizing users request and resolving complex issues.
Trained new employees as a member of training program set by company.
Communication with Clients.
Co-ordination with Higher Management.
Ensure the implementation of processes as per CMMi-5 recommendations within the team.

Senior Software Engineer at Sublime Technologies
  • Pakistan - Lahore
  • December 2007 to November 2010

Served as the initial point of contact for resolution of problems related with application.
Gather Requirements for Gap analysis and new functionality to embed into the existing application
Requirements Analysis
Software Development & Code Reviews
Coordination with team and clients.
Parallel Software Development in multiple technologies in various products.
Co-ordination with Higher Management.
Communication with Clients.

Assistant Programmer at Master Textile Mills (PVT) LTD
  • Pakistan - Lahore
  • March 2006 to November 2007

Software Development and Requirements Analysis in various business domains.
Develop analysis reports for various applications on request of difference HOD of multiple units of company.
Co-ordination with Higher Management.
Troubleshoot, diagnosed and resolved technical problems.

Education

Bachelor's degree, BCS Honors
  • at University of Central Punjab
  • March 2006

Specialties & Skills

Business Intelligence
Databases
SQL Server
Postgres
SQL SERVER
Power Builder
Business Intelligence
Apache Airflow
Apache Spark
AWS RDS
Apache Hive
AWS Redshift
Data pipeline
Apache Tez
AWS Lambda
Datawarehouse

Languages

English
Expert

Training and Certifications

Essential Management Skills for Aspiring Team Leaders (Training)
Training Institute:
People Excellence
Date Attended:
January 2016
Duration:
10 hours
Communication 101 (Certificate)
Date Attended:
September 2012
Valid Until:
January 9999

Hobbies

  • Jogging
  • Badminton
    1st running up in Company badminton tournament