Sonia Chempanezhath

- BI Technical Lead:
• MS Power BI implementation as new strategic BI solution for Emirates NBD - Identifying the strategic BI solution/application right from tool evaluation, architecture finalization, solutioning, capacity planning for organization, delivery plan and lead the implementation to Go Live.
• Conducted POC and identified solution and best practices for advanced reporting solution like NLP and integration of Power BI with Hive and SAP HANA with row level security.
• Strong knowledge in admin, installation & configuration of application and report/dashboard development in MS Power BI.
• Strategic planning and execution of migration of large legacy reporting application (10k reports in Cognos and 200+ dashboards in QlikView) to new enterprise reporting tool (MS Power BI).
• Built a team of 20+ BI engineers - identifying the right candidates, Vendor management, Contract negotiation, On boarding of resources, deploying the resources into various projects and capacity planning.
• Business requirement evaluation and Estimation. Technical Solution for BI projects and managing the timeline for project delivery.

Subject Matter Expert
Role:
• Carried out QlikView application implementation as an enterprise dashboarding tool for the organization from application installation with clustering to Go live as a single member role. Also led all the QlikView dashboard development (40+), administration and support, making sure right information/data reached to the user with proper data reconciliation.
• Developed various portfolio dashboards in QlikView for Retail, HR, OPS and treasury units. The development of Forex dashboard in QlikView led to 50Mn revenue for the bank
• Managed the complete dashboard development in QlikView and acted as a single point of contact for the application ownership
• Strong knowledge in admin, installation & configuration of application and report/dashboard development in MS Power BI, QlikView and Cognos.
• Successfully handled architecture Revamp Project for Cognos and migrated existing Cognos architecture with load balancing & handled from installation to Go Live as single member role.
• Well versed with the concepts of QlikView N Printing, Qlik Sense

•QlikView application SME overviewing all the QlikView implementations and dashboards in Emirates NBD.
•As an SME, gathering the requirements from business and designing the data models and dashboards.
•Project management, costing and vendor management for QlikView projects for various business units with technical support and design.
•Develop code in QlikView, Cognos and informatica, review artifacts, coordination, advice and support to the development, testing and support team for timely delivery of projects and lead the deployment activities.
•Carried out the QlikView implementation in Emirates NBD by playing the role of SME and Interacting with vendor from requirement gathering to Go Live
•Managing architecture revamp project for Cognos and migrated Cognos architecture for load balancing
•Coordinating with:
•ENBD BI Team for Cognos support and handling all daily, weekly & monthly reports in Cognos for various departments
•IT team for Cognos administration and scheduling options for automated reports
•Gathering requirements from business team and preparing the FSD and coordinating with development team, testing team and providing support for UAT and coordinating with production support team for deployment of the codes.
•Involved in DataMart design and implementation using informatica by coordinating with development team.
•Serving as Cognos Frame Work Manager Development and providing self-service package to the business for their better reporting purpose
•Having concepts of Big Data implementation at Emirates NBD. Good knowledge in Hadoop and SAP HANA

Role:
• Holds the distinction of being a key member of MIS Team in Retail Banking for analysis and developing various performance & portfolio reports using excel, SQL queries, SSRS, and Cognos used for various product campaign, cross selling and performance monitoring
• Automation of various manual reports in excel using SQL queries, SSRS and Cognos.
• Interaction with different levels of management people and understand the requirement and translate into BI solution.
•Accountable for automation of MIS reports for retail banking with the help of BI tool Cognos and SSRS based on business requirements & unit testing of the same
•Assisting business users handling Cognos and reports in Cognos
•Serving as a key member in Business Intelligence (BI) Team-IT for performance analysis during merging of Dubai Bank & EIB
•Responsible for requirement gathering from business for report automation and preparing SRS document for the same
•Designing adhoc reports using Cognos, SQL queries and excel based on business requirements
•Coordinating with:
•IT in BI team to support data warehouse and handling the data requirements from business during the migration of Dubai Bank & EIB and IT team for Cognos administration and scheduling options for automated reports
•Business team in order to fulfill the data requirements

Key Assignments:
•Abbott vascular JMP Automation- BI Integration project in Abbott vascular division to integrate Cognos reports and JMP client tool
•Transformer Upgrade Project - Version upgradation project of Power play transformer models to build cube
•Edward Enhancement- Enhancement project for the data warehouse named Edward of well point company
•Strategic Billing - Reporting project in billing area to create various reports in excel, PDF and HTML format
•Pfizer Eucan DW Reporting-Decommissioning UK Phase-3-Creation of cube as a data source for reporting
•Pfizer Eucan DW Reporting- NL Decommission-Creation of dashboard reports for analyzing sales of products in Netherland
Responsibilities:
•Developed dashboards and reports using report studio
•Prepared IQDs and Cubes
•Designed models using Framework Manager and publish the packages
•Responsible for generating test script based on BSD, TSD and Mapping Tracker.
•Created Test Plan and Test Evaluation Summary documents
•Conducted analysis of specifications provided by the client
•Prepared Cognos reports and unit testing of the same; worked on configuration part in order to enable saving the report outputs to external file system
•Responsible for ensuring quality and timeliness of delivery, Manage change request, technology changes, deviations, etc.
•Involved in fixing bugs that are raised by Testing Team