خلاصہ

•        6+ Years’ Experience in Enterprise Application Systems Development & Business intelligence Developer. 


•        Experienced in writing (DDL, DML and DCL), developing/ Creating new database objects such as tables, views Materialized views, Indexes, Complex store procedures, Packages, functions, Cursors, triggers & Libraries.


•        Data Validation, Data Analysis and Management.


•        Expert in Development & deployment of different modules like Supply Chain Management, Advance Warehouse Management, Inventory Management, Human Resource Management, Performance Management, Quality Management System (Audit Module for Production), Production, Piece Rater Management, procure to Pay, Financials & Management Modules.


•        Excellent Knowledge of Oracle Forms, Reports and database development.


•        Design and develop different work flows in work flow builder for different modules.


•        Design & Developed System relevant documentation (Flow Charts, ERD etc).


•        Design and developed different reports in OBIEE according to business need that helps to understand business trends.


•        Used Forms Data Loader (FDL) for loading of data from legacy data into Oracle E-Business Suite.


•        Expertise in development of Power BI’s Visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line charts, Cards, Slicers, Matrix Reports etc. Also, using different transformation inside edit query into clean-up the data.


•        Connecting data sources, importing data, and transforming data for Business intelligence purpose.


•        Expert in using advanced-level calculations on the data set using SQL functions & DAX. 


•        Documentation of Developed Reports & Dashboards.


•        Manage workspaces on cloud & assign them according to different user role.


•        Installing and configuring standard gate way, connecting to different data sources.


•        Creating different power Bi reports utilizing the desktop and the online service and schedule refresh.   


•        Good understanding of Star schema, Snowflake schema and Dimensional Data Modeling.


•        Excellent skills in Analytical thinking for translating data into informative reports and visuals. 


•        Qlik Sense report, presentation development Knowledge.


•        Competent knowledge and skills in Object Oriented Design and Programming. 


•        Ability to Plan, Test, Integrate, Troubleshoot and Implement solutions.


•        Ability to Analyze Develop, Deploy & Support a Software System.


•        Excellent analytical and logical programming skills with a good understanding at the conceptual level.


•        Ability to work in a dynamic environment and under pressure situations.


•        Worked on different databases and have expertise in complex SQL query writing. 

پراجیکٹس

Pension System

تجربہ

کمپنی کا لوگو
EBS Technical consultant Oracle Bi Consultant
SSC pvt. Ltd
مارچ ۲۰۲۲ - دسمبر ۲۰۲۲ | Lahore, Pakistan

• Gather user requirements, Analyze them, and develop solutions according to business needs.
• Extract data from different sources (Microsoft Dynamics, Oracle) transform & load this data into Power BI.
• Create different schedule jobs on MSSQL Server to load data into warehousing tables.
• Create Different Visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line charts, Cards, Slicers, Matrix Reports etc. Also, using different transformations inside the edit query into clean up the data.
• Perform query optimization techniques on different queries and create indexes on different tables for improvement of performance.
• Perform advanced-level calculations on different data using DAX and SQL functions.
• Manage workspaces and assign reports and workspaces to users according to their roles.
• Installation and configuration of gateway and data sources.
• Documentation of Developed Reports, Dashboards & their relevant objects.
• Designed and developed XML Reports using the query, Store procedures, or packages for Oracle EBS and Oracle OBIEE. 
Write Complex queries related to any required data by senior management (Sales, Inventory, accounts, supply chain, etc.)
• Performed data loads and routine updates on an ongoing basis.
• Developed database application forms, and reports using Oracle Form & Report builder in coordination with SQL tables, stored procedures, functions, Triggers, packages, and constraints.
• Manage multiple projects at one time (Power BI, Oracle Business Enterprise Edition).
• Worked on optimization of Queries of the production environment.
• Worked on automation of advanced Ware Housing (Customization in Standard modules), inventory, and supply chain management System.
• Worked as an Application Developer in Oracle EBS R12. 

کمپنی کا لوگو
Oracle EBS Technical Assistant Manager I.T
Us Apparel & Textile Pvt. ltd
نومبر ۲۰۲۰ - فروری ۲۰۲۲ | Lahore, Pakistan

• Work with business analyst groups to ascertain their database reporting needs.
• Take the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports.
• Perform data loads and routine updates on an ongoing basis.
• Develop database application forms using Oracle Forms in coordination with SQL tables and stored procedures.
• Manage multiple projects at one time.
• Work on optimization of Queries
• Worked on automation of inventory definition (Customization in Standard modules), Order Management System
• Worked as an Application Developer in Oracle EBS R12. 

کمپنی کا لوگو
Software Engineer
Style Textile (Pvt) Ltd.
جنوری ۲۰۲۰ - اکتوبر ۲۰۲۰ | Lahore, Pakistan

• Providing reports for multiple data analyzation
• Creating Libraries, Packages, Functions, Procedures, Views, Table Structure, PL/SQL Queries
• Developing Forms and reports on Business Requirements.
• Designing & creating database objects as per Business Requirements.
• Query optimization for performance tuning. 
• Designed & Developed oracle report, forms.

کمپنی کا لوگو
Oracle Developer
Fast Cables Limited
جنوری ۲۰۲۰ - جون ۲۰۲۰ | Lahore, Pakistan


کمپنی کا لوگو
DBA/Developer
Wilshire labs Pvt.Ltd
اپریل ۲۰۱۷ - جنوری ۲۰۲۰ | Lahore, Pakistan

تعلیم

Superior University Lahore
ماسٹرز, ماسٹرز ان سائنس, Masters in Information Technology‎
Web Development, Database Management System, Software engineering
CGPA /4
2017

پیشہ ورانہ مہارتیں

متوسط Communications Development
متوسط CV Screening Skills
متوسط ERP Implementations
متوسط ERP Oracle
متوسط Oracle
متوسط Oracle Bi
متوسط Oracle Forms
متوسط Oracle Reports
متوسط PL and SQL
متوسط Query Language
متوسط SQL PL
متوسط SQL Queries Handling
متوسط Warranty Quality Assurance Process

زبانیں

متوسط پنجابی
متوسط اردو
متوسط انگریزی

آپ کن کمپنیز کی پیروی کر رہے ہیں