Posted Dec 03, 2019 17 views
- Develop simple to complex database solutions for OLAP (Online Analytical Processing) environments. This experience utilizing SQL/PLSQL within an enterprise-class Relational Database Management System (RDBMS) with Strong working knowledge of Oracle and Microsoft SQL.
- Strong knowledge of and experience with OBI EE, Reporting packages (Business Objects etc.), databases (SQL etc.), programming (XML, JavaScript, or ETL frameworks).
- Analyze & functional specifications & transform OLTP datasets into analytical structures.
- Develop complex PL/SQL scripts to perform various database related
- Under the complex Business Processes to find the required dimensions for data analysis.
- Design DWH architecture and Cube Processing.
- Estimate storage requirements for an application.
- Establish an application's security requirements during development.
- Works with technical team to define conceptual, logical and physical data models
- Recommends and takes action to solve database or business intelligence related problems.
- Develops designs and scripts for the extraction, transformation, and loading of data from external sources.
- Presentation of result oriented data analysis for decision purpose to the decision makers with the help of tools like Oracle Business Intelligence (BI) and Microsoft Power BI, SPSS and MS Excel including data models and Charts etc.
- Monitors project progress by tracking activity; resolving problems; publishing progress reports; recommending actions.
- Prepares technical reports by collecting, analyzing, and summarizing information and trends.
- Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats.
TECHINCAL SKILLS:
- Proficient in Oracle / MS SQL (Functions, Procedures, Packages, SPSS, SAS etc.)
- Proven Development Experience in Oracle Business Intelligence Suite.
- Experience working with tools like OBIEE, MS Power BI/ Cognos etc.
- Enforced data integrity and Knowledge of processes for Data Governance using integrity constraints, DHW concepts and Kimball’s concepts.
- Experience working with tools like Visio/ ERWIN etc.
- Technical expertise with statistical tools and concepts like SPSS Statistics, MATLAB etc.
- Usage of several formulae such as Index, Match, VLookup, conditional and logical formulae etc.
- Technical expertise regarding data models, database design development, data mining and segmentation techniques.
- Use of Warehouse techniques Star Schema, Snow Flake Schema, Dimension and Fact table.
- Use of Cubes & Rollups for making cross-tabular reports.
- Expertise in handling errors using Exceptions.
- Experience in working high-transacted OLTP systems.
- Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.
- Have worked in fast-paced AGILE environment.
- Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
- Strong problem identification and analytical skills.
- Creativity with an eye to develop new and innovative solutions.
- Excellent analytical and logical skills, including the proven ability to adapt to a dynamic project environment and manage multiple concurrent projects.
Job Details
Pakistan Revenue Automation (Pvt) Ltd
Pakistan Revenue Automation (Pvt.) Ltd. (acronym – PRAL) has extensive experience of working with federal and provincial tax and revenue agencies to provide wide variety of tax and revenue collection solutions. Since its incorporation in June, 1994, PRAL has been involved in the development of wide array of tax and revenue related solutions pertaining to Income Tax, General Sales Tax, Federal Excise, Customs, Capital Value Tax, Provincial Sales Tax & Services. etc. Over more than two decades of services, PRAL has gained valuable experience of increasing efficiency and efficacy of tax and revenue agencies through use of latest Information and Communication Technologies with Business Process Improvement / Re-engineering. PRAL has also proven its expertise in the areas of software development, project management, technical advisory and consulting services, managing data centers, large databases management, network administration, software implementations, trainings and data entry services. This wide spectrum of services offered by PRAL facilitates our valued customers looking for One-Stop Shop solutions from conceptualization to post-implementation operations. The essence of PRAL’s business strategy is to develop sustainable partnerships with its customers thus acting as a catalyst in transforming and adapting its IT solutions and integrating these to the “New Wave of Technological Innovations” to meet the global requirements of tax and revenue agencies.
What is your Competitive Advantage?
Similar Job Titles
Ali Aziz
CEO
Shopistan
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Aqib Irshad
Head of HR, Training & OD
FINCA
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Muzammil Baig
Digital Marketing Manager
IT Services Group
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
