Career Objective:
To work as a Software Engineer, Data Analyst, BI Developer in a challenging environment where I can use my skills to deliver value added results by achieving the set objectives.
Career Summary:
• Business Analyst with the experience of Data Warehousing and Data Modeling using MySQL, MS Sql, Oracle Sql , Python & R.
• Create effective Dashboards using different BI Tools (Power BI, Tableau & Oracle Application Express).
• Data Filtration & Cleansing using different ETL Tools (Excel, Power Pivot ,Power Query, Sql).
• Having previously Database/ ERP experience will leads me to understand the business requirement in a mannered & systematic way.
• Applied Data Authorization/ Authentication (Security) to manage the Data Hierarchy.
•Working in a software house (consultancy)/ Organization as Oracle E-Business Suite developer for last 2 year using Oracle Technologies.
• Worked on Various modules of Oracle Enterprise Resource Planning (Payable, Receivables, Inventory, and Human Resource Management).
• Concept of BI, Data Analysis, Data Modeling ,Dashboard creation, Dashboard Maintenance, Product Customization, Data Reconsideration, Reports Creation, Drill down Reports, Parameter Reports, Work flows, Alerts, Bursting Alerts, Data Management and SDLC.
• Working experience on Oracle APEX 5.1.
• Perform task according to the requirement of Client.
• Experienced the environment of Textile, distribution and manufacturing companies.
• Completed Bachelors In Studies In Computer Science From University Of Karachi.
• Enthusiastic about working on Data Sciences, BIG Data, Business Intelligence.
Career Objective:
To work as a Software Engineer, Data Analyst, BI Developer in a challenging environment where I can use my skills to deliver value added results by achieving the set objectives.
Career Summary:
• Business Analyst with the experience of Data Warehousing and Data Modeling using MySQL, MS Sql, Oracle Sql , Python & R.
• Create effective Dashboards using different BI Tools (Power BI, Tableau & Oracle Application Express).
• Data Filtration & Cleansing using different ETL Tools (Excel, Power Pivot ,Power Query, Sql).
• Having previously Database/ ERP experience will leads me to understand the business requirement in a mannered & systematic way.
• Applied Data Authorization/ Authentication (Security) to manage the Data Hierarchy.
•Working in a software house (consultancy)/ Organization as Oracle E-Business Suite developer for last 2 year using Oracle Technologies.
• Worked on Various modules of Oracle Enterprise Resource Planning (Payable, Receivables, Inventory, and Human Resource Management).
• Concept of BI, Data Analysis, Data Modeling ,Dashboard creation, Dashboard Maintenance, Product Customization, Data Reconsideration, Reports Creation, Drill down Reports, Parameter Reports, Work flows, Alerts, Bursting Alerts, Data Management and SDLC.
• Working experience on Oracle APEX 5.1.
• Perform task according to the requirement of Client.
• Experienced the environment of Textile, distribution and manufacturing companies.
• Completed Bachelors In Studies In Computer Science From University Of Karachi.
• Enthusiastic about working on Data Sciences, BIG Data, Business Intelligence.
1- Gathered requirements from user and created analytic solutions Dashboards using Power BI (Microsoft Tool) based on the design.
2- Modeled data in support of ETL processing and reporting systems using advanced SQL, MySQL, MSSql concepts to implement complex ETL logic.
3- Performed Pre and post implementation testing of dashboard.
4- Created stored procedures, views, and triggers and constrains to implement the database consistency and integrity including primary key, foreign key for Data Warehousing.
5- Creation of Views, Materialized views, Aggregate functions, Tables and Query, Sub query, functions under SELECT.
6- Presented weekly and monthly data analysis and statistics using MS Excel, Power Pivot & Power Query and TOAD.
7- Experience of working as a Database Developer on Oracle ERP/EBS system previously to get the knowledge of Normalized ERP Standard System.
8- Design and customization of dashboard containing parameterized reports, Cross-tab reports, Drill down reports and Summarized reports, Bar charts and matrix reports using Oracle APEX tool, Microsoft Power BI, Tableau based on business requirement.
Appointed as a Software Engineer at Shirazi Trading Company (Private) Limited (STC) (An Atlas Group Company). Core responsibilities are :
1-Prepare new Reports using Oracle Tools.
2- Working on Oracle Core HRMS , SCM, OM, AR, AP module (Technical).
3. Development of new modules using Oracle Forms.
4- XML reports.
5- Oracle Alerts Development.
6- XML Bursting Reports.
7- Forms Personalization.
8- End to end forms and Reports Submission on Oracle E-Business Suite using TOAD, WINSCP.
9- Hands on working on Oracle APEX 5.1.
10- Maintain data management on TIS (Time Information System).
11- Form Customization.
12- Control User management using System Administrator Responsibility of Oracle E-Business Suite.
13- Data management along with functional issues.
14- End to end Process of SDLC.
Appointed as an Oracle EBS Developer. Task was to create new reports according to the user Requirement, Changes in the implemented system, Defining/ opening of new Items in inventory.
RESPONSIBILITIES:
✓ Responsible for Oracle form developing.
✓ Oracle reports building.
✓ Create and Developed functions, packages, procedures using plsql.
✓ Working on Oracle alerts.
✓ Create XML reports using BI Publisher
✓ Changes in existing Forms/Reports on Order Management and Inventory Modules of EBS
✓ Managing Barcode and HRMS customized modules
CLIENT OF SB-INFO TECH
It was my first experience in the field of Database As Oracle EBS developer.
Here i worked at Inventory, Vehicle Management System (Customized) and developed Reports using Oracle Report Builder 10g, Create custom LOVs, parameters, triggers . Also Create XML reports using BI publisher add-inn facilities. Registered reports successfully on user end on their responsibilities.
M.N textile is a Textile company (Client Of SB-Info Technologies) located in Landhi, Karachi. Here i worked at AR (Account Receivable), Inventory, AP (Accounts PAyables) and developed arount 25+ Reports using Oracle Report Builder 10g . Also Create XML reports using BI publisher add-inn facilities. Registered reports successfully on user end on their responsibilities.
A part of ATLAS group which manufactures battery for cars, bikes, UPS etc. I did 5 Weeks INTERNSHIP as an ORACLE developer on ORACLE EBS OR as a support Engineer.