BUSINESS INTELLIGENCE CONSULTANT
MIRNAH TECHNOLOGIES SYSTEM
Total years of experience :10 years, 4 Months
From June, 2016 - Till Date
Client : Various FMCGs (Al Rawabi, Arasco, Alghanim Industries, Enhance Group, Pepsi)
Domain : BI Reporting
Project : Route Pro Analytics, Enterprise Analytics
BI Tools : QlikView 11.2, QlikSense 3.1
Project Overview
RPX is Pre-packaged Analytics Framework for Route Accounting built using QlikView’s/Qlik Sense’s in-memory technology. It provides a real time snapshot of your organization’s key metrics that helps in monitoring performance, measuring them against the set standards and identifying gaps if any to resolve problems and eventually help in critical decision making. Using this you can easily analyze your business performance by visualizing comparisons, patterns and trends in sales and inventory related data.
Key Deliverables
• Managed End to End process starting from requirement gathering till delivery of project.
• Developed KPI’s for Sales and Route performance.
• Designed dashboards and reports using QlikView and QlikSense, building data models for adhoc reports, QVD generation and demonstrating same to the customers and got the sign off from the customers.
• Redesigning existing data models and architecture to enhance performance and ensure data quality and governance.
• Design and Configure the QlikView applications, front end calculations (set analysis and aggregations) as per business requirement.
• Verifying change requests and defects; documenting, tracking and communicating test plans, test results and unresolved problems; updating Error Log / Suggestion Log and explaining system bugs to programmers
• Work in partnership with other stake holders concerning the accuracy of data and efficiency of processes.
From December, 2014 - December, 2015
Client : Citizens Bank in USA
Domain : Data warehouse
Project : Advance Development (AD)
BI Tools : Informatica Power Center
Project Overview
The Advance Development (AD) was created as a solution to deliver risk data.AD is centralised management platform containing Customer and Account level data for the purpose of batch data provisioning.
Key Deliverables
• Responsible for Verification, Validations and Data Set-up.
• Building Informatica work flows from Scratch, modification of existing sessions as well.
• Designing and coordinating the implementation and availability of the QA test environments, and ensuring compatibility of QA test.
• Creating test plans, test scenarios, test cases and test scripts/procedures for carrying out GUI, Functional, Regression and Integration Tests at various stages in the SDLC.
• Verifying change requests and defects; documenting, tracking and communicating test plans, test results and unresolved problems; updating Error Log / Suggestion Log and explaining system bugs to programmers
From December, 2013 -November 2014
Client : One of the major banks in USA
Domain : Data warehouse
Project : Risk Data Platform (RDP) Data stage Upgradation
BI Tools : IBM Datastage, QlikView.
Project Overview
All the Datastage jobs in RDP were designed in Datastage 7.5 version. Upgradation Project was intended to migrate all the RDP projects from Datastage 7.5 version to Datastage 8.7 version.
Key Deliverables
• Responsible for Datastage job migration, Validations, Data Set-up, data modeling and data analysis using QlikView.
• Changed the Enterprise stage to Connector stage, configured the Connector properties and checked the connection status from UNIX and database side.
• Designing and coordinating the implementation and availability of the QA test environments, and ensuring compatibility of QA test.
• Creating test plans, test scenarios, test cases and test scripts/procedures for carrying out GUI, Functional and Integration Tests at various stages in the SDLC.
From August, 2013 -November 2013
Client : Infosys Technologies Limited
Domain : Data warehouse
Project : Serve Centrale Project
BI Tools : Microsoft SSIS, Microsoft SSAS, IBM Cognos
Project Overview
Serve Centrale application was built for Infosys employees to log requests/complaints regarding attendance, leave, finance etc. which are internal to Infosys. And the project dealt with the creation of data warehouse, reports & dashboards to verify the complaint raised, resolved, SLA etc., using Microsoft SSIS for ETL part, Microsoft SSAS for analysis and Cognos for reporting.
Pursued Engineering Degree from Cochin University of Science and Technology in Electronics and Communication Engineering Stream with First Class with Distinction Grade.