Lokesh Babu
Lead Business Intelligence Analyst at CRMIT Solutions- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Srinivas Pathi
Lokesh is a one of my good friends from childhood. Very calm, descent and dedicated to work. Very very good to have a friend like him..
Srinivas Pathi
Lokesh is a one of my good friends from childhood. Very calm, descent and dedicated to work. Very very good to have a friend like him..
Srinivas Pathi
Lokesh is a one of my good friends from childhood. Very calm, descent and dedicated to work. Very very good to have a friend like him..
Srinivas Pathi
Lokesh is a one of my good friends from childhood. Very calm, descent and dedicated to work. Very very good to have a friend like him..
Credentials
-
Tableau Desktop Qualified Associate Certification
Tableau SoftwareJul, 2021- Sep, 2024 -
Tableau Desktop Specialist
Tableau SoftwareMar, 2020- Sep, 2024 -
Qlik Sense Data Architect (June 2018)
QlikJan, 2018- Sep, 2024 -
Salesforce Certified Administrator (SU18)
SalesForce.comJan, 2018- Sep, 2024 -
Oracle Business Intelligence Cloud Service Specialist
OUNov, 2015- Sep, 2024 -
Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist
OUSep, 2013- Sep, 2024 -
Oracle Business Intelligence Foundation 10 Certified Implementation Specialist
O UJul, 2013- Sep, 2024 -
Oracle RightNow CX Cloud Service 2012 Certified Implementation Specialist
OUOct, 2015- Sep, 2024
Experience
-
CRMIT Solutions
-
United States
-
Software Development
-
200 - 300 Employee
-
Lead Business Intelligence Analyst
-
Dec 2017 - Present
• Supporting offshore team in delivering Einstein Analytics solutions for various business use cases • Leading Tableau practice to deliver analytical solution for largest health care division • Supported IT team to establish Tableau On-Premise Server and Tableau Online Server. • Was part of core design and architecture team in developing an Enterprise Data Warehouse using Microsoft Azure platform as centralized database storing data from all 3 regional data sources in Microsoft Azure SQL Database Managed Instance (Cloud) as multi database solution. • Configured Azure Data Factory data connections, Integration runtime, Azure Files connections, developed pipeline to extract data from source system and push data into Azure SQL Managed Instance 4 Databases ODS_Temp tables. • Developed SSIS ETL packages to move data into ODS, STG and DWH layers. Developing Data model that is compatible to existing QlikSense model without any impact to existing QlikSense Applications in Production. • Have experience in deploying code into GitHub repositories and developed continuous integration and continuous deployment (CI/CD) build and release pipelines using MS DevOps into Azure MI SQL DB. • Was part of Global BI team for a Leading Manufacturing company, Integrate CRM system data (Oracle CRM OnDemand and Salesforce) into QlikSense Platform, develop combine data model with CRM , JDE data and develop data insights across multiple source systems. • Consolidated data from various sources (Salesforce CRM, JDE, EDW, SAP BW, Marketing data, etc.) of all Regions (Americas, EMEA & APAC) to be a ‘one-stop-shop’ for product and sales performance reporting using Qlik Apps embedded into Salesforce business application for sales teams across 3 regions. • Participate in Global and Regional Business Requirement Discussions with Subject Matter Expertise and Business Team in USA and across other regions. Show less
-
-
-
-
Lead Business Intelligence Analyst
-
Jun 2015 - Dec 2017
• The project was to integrate CRM system data into QlikSense Platform, develop combine data model with CRM and JDE data and develop data insights across multiple systems. • The project was to enhance the QlikView application using Institutional Banking MyClient Application (CRM) extended data tables to develop sales and marketing analytics. • Gathered Business Requirements and Developed Qlik ETL SQL scripts to integrate transactional sales application (OLTP) with Qlikview platform. • Implemented 3 –Tiered data Architecture –Source Data Transformation Data Business Model Data in Reporting & Visualization Applications. • Extracted data from Finance Database (Oracle DB) to retrieve data and create a data model using Qlik transformation logics – Load, Joins, Keep, Concatenate, Resident, Map tables, Aggregate tables, cross tables, bridge tables to build Business Data Model. • Developed reports using chart functions and scripts – set analysis, aggregations, variables, pickmatch, time dimension expressions (YTD, QTD, MTD, rolling months). • Developing Key business requirements – Executive Dashboard, Expense Pool Summary, Incremental Revenue Impact, Client Call Summary, Calls by Client Tier, etc • Developed data security within QVW using Section Access inline script, by Geography, by Product, by Industry. Show less
-
-
-
-
Lead Business Analyst & BI Expert
-
Jan 2014 - Jun 2015
• Prepared detailed design documents for business requirements in multiple projects; coordinated with business to get design Sign-off • Involved in enhancing Institutional Banking MyClient application (CRMOD) user experience to access holistic view of their portfolios and legal customer hierarchy data. • Designed solutioned for Simplified Modern UX, Customized Auto-Save feature, Simplified Product Entry, Custom business flows for handling Delete and Merge actions. • Designed solutions to ease business users in creating and managing their activities, Opportunities & Account Plan data, and reducing no of clicks in saving the data. • Followed Agile methodology to deliver CRM Reports/Dashboards based on business requirements, designed easy access homepage widgets. • Designed user-driven virtual filters options in MyClient CRM application, to help the user to slice and dice reports/dashboards by Geography, by Product, by Industry and by User (My Own/Team/Group). • Coordinated with offshore team to get custom solutions and MyClient CRM application configuration delivery in Test and Staging Environments, support Production migration and implementation activities. • Demonstrated advanced visualization views for Business teams using various BI Tools QlikView 9, Tableau, SpotFire. Show less
-
-
-
-
Senior Business Analyst
-
Aug 2012 - Dec 2013
• Worked as Oracle CRM On Demand Business Analyst and Business Intelligent expert for a Leading Consumer Banking • Understanding Core functionality of Customer Experience Management System. • Understanding CEMS Architecture and data sources. • Coordinating with Business, SAV, ODS teams to gather requirements. • Enabling the changes to respective country requirements in test environments • Involved in designing CRM Jobs process, schedule, frequency and supporting BAU teams • Supporting SIT, UAT, Change Management & UVT phases for each country during production rollout. • Using Remedy ticket management system to address issues/changes raised by business • Designed CRMOD page integrations with Banks in-house CEMS CENTRAL application, Prepare functional specification documents for Development team. • Coordinating with Business to understand OBIEE Reports/Dashboard requirements for SME Teams. • Building Physical, BMMS and Presentation layers according to the Reports/Dashboard Requirements. • Documenting low-level design details. • Designing Reports/Dashboards based on requirements • Coordinating with a various team to in order to successfully roll out the BI solution. • Enhancing security level setting at both repository and webcat level. • Using Remedy ticket management system to address issues/changes raised by business • Completed Oracle Business Intelligence Foundation Suite 10g & 11g Certified Implementation Specialist certification. Show less
-
-
-
-
Senior Business Consultant
-
Jul 2011 - Aug 2012
• Worked as Oracle CRM On Demand Business Analyst and Business Intelligent expert. • Migrated CRMOD Reports and Dashboards into OBIEE10g from External Data Store. • Supported OBIEE Integrating with CRM On Demand. • Supported SIT, UAT & UVT phases. • Handover OBIEE10g reports/dashboards to OBIEE_PSS & Enhancement teams. • Undergone training on Informatica 9, OBIA - SCM, Finance. • Provided internal training on CRM OD Analytics and OBIEE 10g. • Worked as Project Functional Lead for one of Leading Financial Institutions in ASIA, to migrate SFDC system’s Customer Origination and Lending Process build to CRM On Demand system with Data Authorization Process and FlexCube Integrated solution. • Conducted requirement workshops at customer location (Hong Kong) to close all critical design level open items. • Conducted Integration/Data Migration workshop with multiple parties (FlexCube Team, Data Migration Team, BTR team) to prepare CRMOD design documents help Development teams. • Preparing FSD based on the Requirement document and workshops. Show less
-
-
-
-
IT Consultant
-
Dec 2010 - Jul 2011
• Worked as Oracle CRM On Demand Business Analyst and Business Intelligent expert for a leading Wholesale Banking. • Analyzing, elicitation, validation of Business Requirements. • Interaction with clients to understand their requirements. • Migrated Financial Marketing Team existing Excel report requirements into CRM On Demand Oracle BI and help them to improve user adoption and utilization of CRMOD system. • Optimized Bank Service Group’s long running reports and improves the turnaround time of the reports request and execution of CSG reports doesn’t impact overall system performance. • Supported existing and new report requirements/refinements from all Department of CRM Business team (FM,OCC,CSG,CM,CF,RMF) • Supported Data Federation (ETL) Team to provide CRMOD system field level, object structure details in order to push CRM data into external Data store Base Tables. • Prepared BRD documents for the critical set of CRM Reports that are to be migrated into OBIEE 10g. Show less
-
-
-
CRM Solution Pvt Ltd
-
India
-
Outsourcing and Offshoring Consulting
-
1 - 100 Employee
-
Business Consultant
-
Dec 2007 - Dec 2010
• Worked as Oracle CRM On Demand Business Analyst and CRMOD BI expert. • Worked on a Project to migrated Financial Marketing Team’s existing excel report requirements into CRM On Demand Oracle BI which help improve user adoption and utilisation of CRMOD system • Worked on a project to enhance bank’s existing Mortgage System with Telesales Management. Provided complete solution with Telemarketing, Customer Origination Process Integrated with Mortgage Process., for One of the leading Financial Institutions for Retail in Vietnam. • Worked on a project to automate and integrate Order Management system for the company’s healthcare products sales in the Asian region, for Leading Healthcare Devices Manufacturing Company in Hong Kong. • Worked on a project to enhance existing Client Management System with Event Management application, Reports to track and manage interactions with their Clients, for Leading Independent Insurance Ratings Company in the USA. • Implemented CRM On Demand project to migrate market research company’s existing manual data mining operations into a CRMOD system and to process Pre-Sales, Data Origination and Project Management operations, for Leading Market Research Solution Providers In Asia. o Involved in requirement workshop at Customer’s place. o Configured CRMOD system based on the business requirements. o Developed Reports and Dashboard based on the requirements. o Coordinated with Development team on custom development activities. o Conducted UAT Workshops with Client and Prepared User Manuals for the Client • Migrated North American and European Data into CRMOD and Develop ROI reports to make them available directly from CRM On Demand instead of external reporting tools for one of the world's leading Consulting Organisations in Australia. Show less
-
-
Education
-
2003 - 2007
JNTUH College of Engineering Hyderabad
Bachelor of Technology (B.Tech.), Electrical and Electronics Engineering -
Emmaus Swiss High School
B Tech
Community
