Designing, creating, and implementing Power BI solutions for Oman Insurance in all verticals (Medical, Motor, General Insurance, and Operations)Evaluating, repairing, and improving current BI systems.Translating business goals into technical specificationsCreating interactive visual reports using Power BI toolsCollaborating with teams and managers to help businesses develop.Finding correlations in data to discover meaningful insights and outliers.Finding fraudulent claims and providers using various analytics techniques.Identifying key performance indicators (KPI) to help companies adjust and fulfill objectives

Studied in-house requirements for the Data warehouse to be developed.Conducted one-on-one sessions with business users to gather data warehouse requirements.Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.Developed a Conceptual model based on requirements analysis.Developed normalized Logical and Physical database models to design OLTP system for Analytics applications.Created a dimensional model for the reporting system by identifying required dimensions and facts.Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.Worked with Database Administrators, Business Analysts, and Content Developers to conduct design reviews and validate the developed models.Identified, formulated, and documented detailed business rules and Use Cases based on requirements analysis.Facilitated development, testing, and maintenance of quality guidelines and procedures along with necessary documentation.Responsible for defining the naming standards for the data warehouse.Generated ad-hoc SQL queries using joins, database connections, and transformation rules to fetch data from legacy DB2 and SQL Server database systems.Exhaustively collected business and technical metadata and maintained naming standards.Used Informatica Designer, Workflow Manager, and Repository Manager to create source and target definition, design mappings, create repositories, and establish users, groups, and their privileges.Facilitated in developing testing procedures, test cases, and User Acceptance Testing (UAT)Integrated the work tasks with relevant teams for a smooth transition from testing to implementation.

Develop and introduce efficient workflow management solutions to simplify processes and procedures.Create dashboard(s) to provide an insight into all project issues, KPIs, and checks.Develop automated solutions that will reduce/retire manual activity overhead for the Portfolio Management team.Review and validate customer data as it is collected.Oversee the deployment of data to the data warehouse.Develop policies and procedures for the collection and analysis of data.Create or discover new data procurement and processing programs.Monitor analytics and metrics results.Implement new data analysis methodologies.Review customer files to ensure the integrity of data collection and utilization.Perform data profiling to identify and understand anomalies.

Administered all business marketing operations and advertisement campaigns that eventually generated a 5% increase in web traffic in 4 months.Primarily responsible for leading the build of BI solutions, managing the team roadmap and backlog, and delivering actionable data insights to sales, product, marketing, and senior leadership.Lead BI development with an emphasis on easily consumable, drillable dashboard designs powered by BI Tools.Collected and delivered business requirements to engineering to ensure reporting & BI needs were met in the development of both a new data warehouse and proper implementation of Google Analytics across all products.Drove communications on project proposals, survey design, and budget allocation across internal teams, customers, and vendors facilitating on-time delivery and 100% customer satisfaction.Supervised a 10-member global cross-functional team to simultaneously manage 12 large multi-phase research projects (including primary (qualitative and quantitative), secondary research, and predictive analytics) from inception to execution.Created and managed a central repository of best-in-class research reports.Designed, analyzed and presented a landscape analysis study for an acne product among teens, utilizing complex predictive analytics and multiple large data sets.Increased client's consumer brand awareness and retention rates by 20% using innovative research methodologies and translating data into key insights and actionable brand recommendations.Created and managed a vendor of excellence list, identifying best research partners consistently meeting and exceeding expectations.Led quarterly team activities and volunteer efforts to build employee morale.Contributed thought leadership in uncovering meaningful customer behavior and customer profitability.Led team building, including hiring, development, and management.Built internal client relationships.Oversaw branding strategy, research, and analysis.

Managing pre-P3 activities such as Salary Budgeting, Bonus Modelling, Shares Buy out, IM Cost review, Benefit review, Compensation rate code exercise, Review and work with Champs to get sign-off on P3 letter template and P3 online system UAT testing. Support the cost PMC discussions by reviewing the cost of operations for PRB administration to manage cost efficiency via developing and presenting the PRB PMC and PRB PGC dashboards.Support the development of a technology road map for PRB and identify the opportunities to increase the efficiency of PRB. These may be achieved through technology enhancement, migrations, and process improvements. Manage and support to maintain PRB Audit, Group PRB risk registers, Country PRB risk registers every month.Market Data and job matching exercise for Senior Executives for Towers Watson survey submission.Provide recommendations to update current MIS to improve reporting efficiency and consistency and providing strong reporting and analytical information to support PRB.Analytics support is provided for the global processes through Human Capital Analytics to support People forums, Strategic People Agenda (SPA), and other special projects.Working closely with Group HR to support business to sustain the employee engagement level by conducting 360-degree feedback, Q12 scores across the Bank.Manage efficient turnaround time and day-to-day PRB operations. Ensure manpower utilization effectively.Initiated and handled the Business call, Country Champions calls,s and monthly stakeholder calls.Analysed data requirements, application and processing architectures, data dictionaries, and database schemas while designing, developing, amending, optimizing, and certifying database designs to satisfy client needs.

Managed Talent Acquisition Analytics and HR Process Automation team for US and India.Developed rich interactive graphics and data visualizations of large, structured data in Talent Acquisition. Participated in the development of new tools, methods, and procedures that streamlined data analysis improved the design of BI tools and reporting, and assisted in the governance and management of master data. Eventually took the lead role on several projects involving data visualization and a full-time role as a data visualization specialist.Developed many dashboards which showed the aging, TAT, pending, VOC by various filters and anomalies at Region, Unit, Business Function, and Department levels for US and India.Managed the design and development of HR Process Automation projects.Handled the FTE utilization, Appraisal, and performance review process for the TA and HR Automation team.

This position is responsible for leading a team that specializes in HR business process and change management, planning and conducting initial training and quality testing of applications. Position will liaison among stakeholders in order to elicit, analyze, communicate and validate requirements for changes to business processes, policies and information systems. Position is responsible for project planning and estimating, status reporting, employee mentoring, performance management, development process and contribution to strategic direction.

Managed “Adhoc & Standard HR MIS team” (18 team members include 2 team leaders, 1 senior Analyst) supporting 91 business units globally which is a high-end analytics team that provides dependable MI and Research Analytics across HR products.Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget, and with the desired results.Mitigated risk factors through careful analysis of financial and statistical data. Anticipated and managed change effectively in rapidly evolving global business environments.Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules, and work breakdown structures.

> Workflow Management for the International Account Services Team (Corporate Clients of Citibank).> Account documents review, account opening, all maintenance & closure, cheque queries, signature verification, foreign exchange transfers.> Queue & Escalation Management.> Account services MIS and analysis for business decision-making.

People Management: >= 10People soft and Learning and Talent Development Analytics.People Soft & Saba: UAT testingAutomation : All Manual reports and DashboardGap analysis and customization for various HR modules Email Distribution List

Mutual Fund MIS : CAMS,Karvy,Franklin Templeton IndiaDocuments Review & Maintenance : Saving Accounts/Corporate AccountsDocuments Archival & Retrievals: Crown Vendor.MFISCD Database Management.Daily NAV UploadGeneration of various customer oriented MF reports.Calculated customer wise AuM and sales person wise AuM for the customer database.Liaised with Fund Houses for follow up of commission’s receivable calculation of pass backs for selected customers.