Assistant Manager Analytics
Emirates NBD
Total years of experience :14 years, 8 Months
• Analysis of team activities that consume manual effort and identify the MIS’ that could be automated using BI tools to reduce human error and improve data quality
• Delivered business intelligence solutions utilizing the Cognos tool suite that saved several man days of human effort
• Managed project plans, scope, resources, change requests and risks
• Apply policy changes in MIS and reports to ensure adherence to policy
• Project Management, FSD Sign-off, UAT
As Business Intelligence Analyst under Business Systems, involved in the below tasks:
• Development of BI reports using Cognos Report Studio with relational, multi- dimensional OLAP, DMR, transformer cube data sources
• Development of interactive dashboards using Active reports
• Creating and scheduling events through Event Studio
• Analysis of OLAP data through Analysis Studio
• Creating dashboards using Business Insight, Business Insight Advanced
• Exploring and analyzing relational data using Query Studio
• Creating and maintaining Framework models and Query Subjects
• Analyzing and resolving issues raised in Cognos reports
• Cognos Administration tasks including providing access to users, scheduling reports, creating and scheduling jobs, monitoring jobs, analyzing and fixing failed jobs, creating user groups, portals and assigning permissions.
Creating budgeting applications in Cognos Contributor, Setting up the applications, data load and administration of Cognos Contributor
• Administration of Cognos Controller
• Creation and maintenance of Cubes using Transformer
• Maintenance of Metric Packages
• Developing ETL tasks using SSIS
• Report expressions with advanced relational and multidimensional functions
• Developing reports with advanced functionalities including Prompts, Query Joins, Unions, detail & summary filters, slicers
• Developing drill-down, drill-up and drill-through reports
• Active reports using active report controls including \[Data\] Button Bar, \[Data\] Discrete/Continuous Slider, \[Data\] Decks, \[Data\] Radio button/List box/Check box and passing variables across controls
• Drill through active reports
• Basic user support for Microsoft Dynamics CRM 2013
• Creating views, data import/export in MS Dynamics CRM
• Creating views, functions and stored procedures in SQL server2008
• Periodic data loading and report distribution
Have been a part of Business Intelligence and Information department and have a wide exposure to data warehousing in creating and managing data marts and MIS repositories. Have functional knowledge on Finnone CAS, LMS and collections and the backend tables. Have some knowledge on core banking application FINACLE and the cards application Vision plus. Some of the main responsibilities are pointed below:
• Analysis of business requirements
• Build and maintain data marts
• Creating and maintaining MIS repositories
• Business Support
• Creating stored procedures and functions
• Day to day Business Service Requests
• BAU activities
• Creating, loading and updating SQL server tables
• Writing SQL scripts to support ad hoc requests
• Create mapping documents using the business requirements document and also prepare the functional and technical specification documents
• Mentoring juniors both in technical and functional aspects
• Have worked in migration of SQL server to Sybase
Worked as a team lead and handled teams of up to 5 members. Successfully completed a number of enhancements and bug-fixes; also resolved a number of production abends and also maintained the quality standards in all respects. Some of the main responsibilities are pointed below:
• Worked in all phases of SDLC including requirements gathering, analysis, design, coding, testing, UAT support, production deployment and post production support
• Involved in Unit Testing, System Testing, Integration Testing, Support for UAT that involves preparation of test cases and test data, setting up test region, preparing test document, testing and documenting test results.
• Defect analysis and tracking
• Production Support
• Monitoring online and batch processing of GroupFacts application which is an advanced computer application for the administration of Group, individual and association life and health insurance business.
• Estimation of proposed project
• ABEND analysis and fixing.
• Tracking issue status.
• Creating status report.
• Mentoring juniors both in technical and functional aspects
• Customer Specific Activities
• Quality maintenance
• Documentation
Completed B.E in Electronics and Communication Engineering with Fisrt class and distinction.