Lalit Singh

Experience

• 

  Tranistics Data Technologies Pvt. Ltd.

  May 2015 - May 2018

  Analyst

  ● Performed daily data queries and prepared reports on daily, weekly, monthly and quarterly basis. ● Used Tableau and advanced excel to visualize the data according to the requirements. ● Acquire data from primary or secondary data sources and maintain databases/data systems.● Data extraction using tools like MS Excel and SQL.● Maintained the research database, renew and improve it from time to time and make sure safe storage of data● Arranged analysis reports and be accountable to answer any queries, complaints or proposal. ● Maintain excellent relationships with customers and carriers, providing timely and concise information of reports. ● Partner with Logistics Coordinators and Carriers to resolve any rating discrepancies or customer service problems while providing timely submission of invoices to Accounts Payable.● Calculate the specified problem, examine for solutions using data analysis practices and arrange analysis reports.● Develop new reports and delegated task to team members.● Submit daily report to global audit manager and CSR. Show less

• 

  Paisabazaar

  Jun 2018 - Dec 2018

  Data Analyst

  ● Perform Credit Card Data queries and prepared reports on daily, weekly and monthly basis on the Credit Card Data.● Used Tableau and advanced excel to visualize the data according to the requirements and with revenue generation on daily weekly and monthly basis.● Analyzed internal data sources to determine factors affecting the generations and to enhance the process with the different factors.● Identify, analyze, and interpret trends or patterns in complex data sets.● Financial data extraction using various tools like MS Excel, SQL and from CRM.● Automation by using R Server to present hourly reports and the trackers and also used for the statistical analysis.● Using packages in R server are dplyr, dbconnect, htmltable, XLSX, mailr, data.table, stats etc. and ggplot for the visualization.● Data importing in R.● Integrated R and SQL to the tableau for the report presentations. Show less

• 

  Power2SME

  Dec 2018 - Jan 2021

  Business Intelligence Analyst

  ● Execute work by Business Intelligence and Analysis, Designing, Testing, Migration, Production support and Implementation of dashboards.● Work on data visualization tool Tableau Desktop Business Intelligence/Business Analytics software and other Tableau Products● Create Effective and High performance dashboard using Tableau and published them to Server.● Designing complex dashboards taking advantage of all tableau functions including data blending, joins, actions, filters parameters, etc.● Suggest and follow standard methodologies for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel.● Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.● Involving in admin activities like publishing, adding users, creation of subscriptions and deployment.● Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.● Design Dashboards using Filters, Parameters and Action Filters● Extracting the data from multiple data source.● Restricted data for particular users using Row level security and User filters.● Overseeing the production operations for Tableau platforms.● Interacting with business partner's and customer's for reporting needs and requirements.● Interpret written business requirements and technical specification documents.● Establish a good understanding of Tableau user and group security configuration.● Administer user, user groups, and scheduled instances for reports in Tableau.● Provided 24/7-production support for Tableau users.● Making Trackers require by the management and worked with the google sheets and advance excel techniques to create them. Show less

• 

  EXL

  Jan 2021 - now

  • Analytics Manager

    Feb 2024 - now

  • Lead Assistant Manager

    Jan 2021 - Feb 2024