15 years of experience as Data Engineer, Database Architecture Design, Development and Administration (SQL Server, Oracle, MySQL, Postgresql, Snowflake), ETL (SSIS, Stich Data, Azure Databricks (Scala), Azure Data Factory), Amazon Athena, Amazon EMR, Amazon Redshift, Amazon Kinesis, Amazon Elasticsearch Service, Amazon Quicksight.
● Application Architecture Design
● Client Communication
● Develop ETL Pipeline
Snowflake Database, Scala, Data Stitch
A project of Smart Energy meter is started by Pakistani Government with the help of US Aid from American People. PITC is the institution which is established by the Government to devise processes and give requirements to the Smart Energy Meter Manufactures in Pakistan in-order to develop Cloud Service for Smart Energy Meters. There are total 8 meter manufacturers in Pakistan, most of which are developing their MDC Server from china, while VERTEX with the help of me has established their Software Department which will not develop MDC Cloud for VERTEX Energy Meters but a world wide cloud service for Smart Energy Meters.
Job Profile:
● Team forming and Management
● Budget management
● Application Architecture Design
● SCRUM Management
● Code Reviews
● Team performance Evaluation
● Client Communication
● Develop ETL in Oracle Data Integrator and SSIS
● Development of RPD in OBIEE
● Development of Dashboards in OBIEE
● Development of web portal to upload raw files to data warehouse
● Addition of new data elements in the data mart
● Bug fixing for client data loading
● Coordination with the QA and analytics team
● React JS Application Design, Code Reviews and Coding
Achievement:
● Successful delivery of AMI (Automatic Metering Infrastructure) to Vertex Electronics Pvt. Ltd, within defined time, cost and up to quality. Which opened new horizons of business development for Vertex Electronics Pvt. Ltd.
● Client satisfaction.
DWH requirement gathering
DWH Analysis design and development
- OBIEE repository development
- Dashboards and reports development
Sales Data warehouse development
● Involved in evaluation, design & development of data warehouse, OBIEE repository, dashboards & reports as well as healthcare data warehouse
● Interact with clients for collating/ evaluating requirements to align with project deliverable
● Involved in development of Web based applications using Laravel and Android Applications as well.
Achievement:
● Client satisfaction, delivery of work within time, cost and up to quality.
I worked on Healthcare Application. I was responsible to Design and develop Database of the application, to migrate the data of legacy system to new system, to optimize reports and develop new reports, to assist issues of live application. To develop and maintain Data warehouse.
Projects I worked on:
Sequelmed EPM:
Billing Application for Healthcare.
Seuqlemed EMR:
Patient management system.
- OBIEE repository development
- Dashboards and reports development
Core responsibilities were:
Database architecture design and PLSQL development for complex processes of LeaseSoft (the flagship product of NetSol)
The project on which I worked was LeaseSoft-CMS that provides the solution to manage the whole span of a leasing contract. My core participation has been in implementation of payments through different interfaces e.g; Direct Debit, Post Dated Cheques, Bill Payment and generating the Tax Invoices.
Core responsibilities were:
Database architecture design and development for complex processes of FastCash.
Database Administration(backup and recovery, replication)
Worked on FastCash which is the electronic transaction processing system which provides facility for online pin/card purchase, utility bill payment and credit transfer. It provides Web, POS and IVR interfaces.