4+ years of experience as a back-end developer for a variety of ERP systems like Oracle EBS
11i/R12, SAP A1/B1, Customized Solutions.
Specializes in Designing and implementation of BI solutions covering all aspects of
ETL(SSIS, Lantern ETL Tool), Data Warehousing (Oracle, SQL Server, SSAS) and visualization
tools e.g. Power BI and Lantern BI, Microstrategy BI and IBM Cognos.
Over 3 years of experience of interacting with clients for requirements gathering, solution
discussions, onsite implementations and support.
Worked in Oracle technologies Forms 6i/10G/11G, Reports 6i/10G/11G, Web-logic Server,
Oracle 10G/11G, SQL Server and SAP HANA. Proficient in SQL, PL/SQL, Stored Procedures,
Functions, Triggers, Views, Cursors, Packages and Exception handling.
Team player and self-starter with excellent communication and documentation skills,
ability to work independently or as part of a team and capable of picking up new skills
quickly.
Projects:
1. PEL
2. HITECH Lubricants
3. Qarshi Industries
4. AlMoiz Textile
5. Alfalah Insurance
6. Naubahar Bottling Company (Pepsi)
7. Sadaqat Textile Faisalabad
8. Group Multiple
9. IndusHomes Pvt Ltd
10. UBC Convertec
11. Servis Industries
Successfully deployed 6 Oracle Base, 5 SQL Server base and one SAP HANA base projects
starting from requirement gathering to the data warehouse designing and dashboard
development to final deployment of projects.
Gather Business requirements, Analysis, Design, Data Modeling, Data Preparation for
Dashboard Designing, Development of ETL packages/Queries/DWH, Client
Interaction, and Compiling Specifications from client, Modification and Testing.
Prepared reporting requirement, URS, FRS and sign-off documents.
Hands-On of SQL Server, Oracle, MySQL, SAP HANA, Microsft Azure, SSRS Server
Configuration, SSAS and Talend.
Dashboard Designing on Lantern BI, Power BI, Microstrategy BI, IBM Cognos.
Developed and maintained ETL(Data Extraction, Transformation and Loading) mappings
using SSIS to extract the data from multiple source systems that comprise databases like
Oracle 10g/11g, SQL Server 2008/2014, flat files, MS Excel and MS Access to the DataStore
and then to EDW.
Performance tuning of Queries using different techniques to acquire fast data retrieval.
Created various dashboards, scorecards and reports to support business decision making.
Ability to code and implement complex business rules in Oracle SQL, PL/SQL, Triggers and
Stored Procedures.
Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and
parameterized reports to provide visible data for data analysts.
EBS R12 Database 12c.
Modules: Financial & HRMS.
Personalization and customization of forms.
Report Development.
Develop Procedures, Functions, Packages, Views, Cursors and simple /complex query according to the requirement.
Data Uploading through APIs and interface tables.
EBS Framework Personalization.
Modules:Financial and HRMS.
Customization and Personalization of Application.
Development of customize reports (PDF/XML),forms,procedures,functions,packages,cursors..
Customize ERP using Weblogic Server and fusion middleware development tools