Dedicated business intelligence analyst and Oracle Techno functional consultant with over 10 years of experience in the IT industry. By using OBIEE and Microsoft Power BI tools to built dashboards to have a graphical view of employer valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital matrices and revelatory findings. Proven track record of deployment of Oracle Campus Solution and Learning Management solution in two leading universities of Pakistan. Provide high level strategic, analytical direction and vision. Also have Vast knowledge of PL/SQL and SQL queries.
Develop and deploy dashboards, visualizations and autonomous and dynamic reporting interfaces to be distributed to stakeholders via the BI reporting platform, web portal.
Work with the Data Management team to provide input on logical and physical database design, data modeling and/or mapping.
Generate large and complex data extracts and queries for the Analytical Leads for data analysis by utilizing various database schema such as Microsoft SQL Server, Oracle.
Create and present project dashboards, status reports, project deliverable that depicts project health including cost and schedule to both internal and external stake holders.
Work with various Team Members, internal departments and third-party agencies on report business requirements, documentation, timelines, testing, and technical delivery.
Providing high level strategic, analytical direction and vision.
Conducts best practices, provide analysis of business processes and workflows with suggestions for improvement.
Identify areas where technology can lead to increased efficiency and productivity.
Researching best practice in data analysis, presentation and management techniques.
Responsible for all phases of PeopleSoft implementations and upgrades, including project planning, fit/gap analysis, design, construction, deployment and maintenance.
Proficient in analyzing Business Requirements Document (BRD), Functional Design Documents and FRD (Functional Requirement Document) to formulate Test Plans, Test Scenarios and Test Cases.
Proficient in requirements gathering, performing fit gap analysis (current and future state), creating functional specification documents, and developing business process flows and charts.
Provided software development, maintenance and analysis for PeopleSoft Campus Solution.
Expertise in PeopleSoft applications, Oracle databases, SQL.
Develop and deploy dashboards, visualizations and autonomous and dynamic reports using Microsoft Power BI and Oracle OBIEE.
Generate data extraction, summarization and ad-hoc query requests as required by the business reporting environment.
Operationalized business intelligence solutions and conducted advanced analytics to identify opportunities and strengths to meet business goals.
Created and maintained data visualizations that educated, informed and engaged business partners on key metrics and performance measures.
Requirement gathering, gap analysis, preparation of use case, activity flow diagrams, BRD/FRD.
Defined the business processes in PeopleSoft, conducted extensive gap analysis, reviewed extensive customizations, led data conversion efforts, led reports development, conducted user training, implementation and post implementation support.
Involved in developing and customizing the reports using the tools PS Query and SQR. Creating complex SQL to retrieve the data from PS.
Worked on Report generation using SQL Server Reporting Services SSRS that could be used to send information to Client.
Responsible for the set-up, data-mapping and configuration in support of out of the box functionality of the Academic Advisement, Campus Self-Service, Financial Aid, Gradebook, Recruiting and Admissions, Student Administration, Student Financials, Student Records and Campus Community modules within the Campus Solutions application suite.
Involved in Milestones conversion from legacy system to PeopleSoft Campus Solutions using App Engine,
Component Interface and Parallel processing.
Provided technical expertise for development of PL-SQL applications, workflow procedures and interfaces.
Converted Project specifications and procedures to detailed logical flow charts for coding.
Installation and configuration of Oracle Application Server.
Assisted in designing and implementation of different components of local ERP systems on basis of company business requirements.
Assisted in development and maintenance of custom built Oracle applications, HR, Procurement, Funds Management, Base Line Survey for Health Project and Finance system.