• Senior Business Intelligence consultant with 10+ years of experience in identifying and implementing process improvements, resulting in a 10% reduction in project delivery time. • Revolutionized data analytics in the banking, CPG and Healthcare sectors by implementing Tableau dashboards, enhancing decision-making efficiency, contributing to a 15% increase in revenue over 12 months and reducing data discrepancies by 40%, which enhanced operational efficiency significantly.• Skilled in developing and executing comprehensive testing plans, resulting in a 95% success rate and a 10% increase in revenue. • Proven track record in managing projects to implement new systems, resulting in significant cost savings and increased client satisfaction (NPS score).• Experienced Business Analyst with a strong background in data engineering and business intelligence (BI) space.• Collaborated with Stakeholders, End Users, Business Owners, Product Owners, Project Managers, Scrum Masters, Tech Leads, UI Experts, Developers, QA/Testers, Product Managers & SMEs at various levels.• Experience in using the JIRA tool for writing and managing User Stories and Tasks in Scrum environment, track issues, Defect Lifecycle Management.• Experienced in using SQL queries (DDL, DML, DRL) including joins, unions, group by and aggregate function.• Facilitated a 20% increase in team productivity by implementing clear communication protocols, detailed documentation practices, and fostering strong interpersonal relationships among team members in a high-pressure environment.• Experienced in assessing, analyzing, and taking trade-off decisions to maintain a balance between the triple constraints such as scope, budget & schedule, and maintain quality by employing appropriate project communication plan.• Proficient experience in collaborating with Stakeholders and End Users to gather requirements by using Elicitation Techniques like Joint Application Development (JAD), Brainstorming, Interview, Questionnaire/Surveys, Prototyping, Document Analysis, Reversed Engineering, and Interface Analysis.• Excellent understanding and working experience with on-premises applications and various cloud-based services SaaS (Software as a Service), PaaS (Platform as a Service), cloud integration tools for effective integration in real time basis.
-
ManagerKpmg IndiaMumbai, Mh, In -
Senior Business Intelligence AnalystLtimindtree Sep 2021 - PresentPupri, Bihar, IndiaI am currently providing consultation and business intelligence solutions for our client AMEX credit Fraud Risk department (CFR). We have eventually reduced the credit fraud by 4% over a period of 1 Yr by designing Customer Lending Scorecard for US market and many other reports in Tableau. -
Technical LeadLtimindtree Sep 2021 - PresentPune, Maharashtra, IndiaHelping our client Amex in evaluating the credit & fraud risk while issuing a credit to the prospect by developing BI solutions using analytical skills & tools like Tableau. In last 1.5 years We have helped multiple cross functional teams to reduce their monthly Excel based manual reporting effort by 35% by designing more than 25 dashboards.
-
Business Intelligence ConsultantFractal Jul 2020 - Sep 2021Goregaon, Maharashtra, India• Responsible for creating and reviewing business requirements, functional specifications documentation.• Responsible for identifying and documenting business rules, creating detailed User Cases and conducted User Acceptance Testing. • Used Tableau to create customized dashboards, showing reports that satisfied business needs.• Developed and implemented Tableau as BI tool over QlikView that increased efficiency by 25%.• Collaborated with cross-functional teams to identify and implement process improvements, resulting in a 10% reduction in project delivery time.• Involved in scrum ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.)• Designed Vendor management dashboard keeping the Quality of material as well as on time delivery as key parameters, resulting in 15% increase in operational efficiency and a 12% increase in Revenue.• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.• Used SQL scripts/queries extensively for data verification over ‘Hue’ portal as per the requirements of the mapping document.• Provide business intelligence to General Mills by developing dashboards and reporting.With the help of our reporting skills, we automated 4 days of manual effort/Region/month, reducing the effort of analyzing the Sales data for their Business Review Meetings. -
Senior Associate ConsultantInfrasoft Technologies Ltd / Client : Bnp Paribas India Solution Dec 2019 - Jul 2020Mumbai Area, India• Involved in the complete dashboard Development Lifecycle using Tableau as a major BI tool. • Created the Business Requirement document (BRD) and Design documents to increase collaboration.• Prepared wireframes in Excel/PowerPoint to help the stakeholders visualize the final product.• Generated KPIs and Visualizations packaged in interactive Dashboards to improve the Data Quality of client contacts every week.• Developed an intuitive Tableau dashboard for CRM and supported User Acceptance Testing (UAT). • Improved customer contact Data quality by 23% in 3 months for the complete US market clients.• Managed a project to implement a new CRM system, resulting in a 20% increase in sales and a 15% increase in customer satisfaction.• Coordinated meetings between test team and development team to review defects and track them to closure.• Designed and documented Test Plans, Test Scenarios, Test Cases based on business requirements, design documents & logged defects in HP ALM.• With our consistent effort we have improved the Customer's Contact Data quality by 23% in 3 months. -
Data AnalystRandstad India / Client : Johnson & Johnson Pvt Ltd Jun 2018 - Dec 2019Mumbai• Developed and implemented a Lifesaving Tableau-based reporting system (SIA), resulting in a 35% increase in data accuracy and a 25% reduction in reporting time by migrating Excel reports on to Tableau dashboard.• Collaborated with cross-functional teams to identify and implement process improvements to provide a single source of truth, resulting in a 25% reduction in project delivery time.• With this effort we have saved 5 days of monthly work which was required to prepare multiple Reports for Business Review Meetings with the Leadership Team.• Developed Inventory management reporting system which helped reduce the inventory from more than 100 days to 45 days across the country.• Designed and developed Expiry management reporting systems led to an increase in monthly Revenue of 5%.• Trained & mentored the ASMs, DMs & Product owners on the Tableau reporting tool to achieve operational efficiency and customer delight.• Working as a Data Analyst at Head Office J&J. We have automated the Excel reports using Tableau Dashboards & shifted all the Data to Data Lake which was hosted on Amazon Redshift.With this effort, we have saved 5 days of monthly work which was required to prepare multiple Reports for Business Review Meetings with the Leadership Team. We have designed a Daily Sales Reporting tool [DSR] for Sales managers so, they can keep track of their sales target without missing their Incentives for 1 or 2 % of sales. -
Assistant ProfessorVidyalankar Institute Of Technology Jun 2017 - Apr 2018Mumbai, Maharashtra, IndiaI have worked as Assistant Professor for Information Technology [ IT ] department. I was teaching Mathematics & Statistics to 1st & 2nd yr Engg. students. -
Software EngineerTata Consultancy Services Dec 2012 - Oct 2015Mumbai Area, IndiaProject Title: National Pension System (NPS)Description:• NPS is a project under State Bank of India (SBI) initiated by PFRDA (Gov. of India).• Managing database and Production server at SBI Mumbai main Branch, FORT.• Sweeping all the transactions happened across India using Oracle PLSQL database on daily basis. • Providing report (Excel) to SBI Manager for the Registration and Contribution amount brought to SBI Mumbai main branch BGL Account on daily basis.• Installation of NPS software (e-PACT) across all new SBI branches remotely. • Managing a team to work cohesively for achieving a common goal i.e customer satisfaction.
Rajan Singh Education Details
-
Business, Management, Marketing, And Related Support Services -
First Class With Distinction ( Cgpa: 8.8 ) -
Terna Engineering College, Nerul, Navi MumbaiFirst Class With Distinction (Marks: 71%) -
C.M Science College, DarbhangaFirst Class (Marks: 60%)
-
L.M.H.S PupriFirst Class With Distinction
-
Accounting And Finance
Frequently Asked Questions about Rajan Singh
What company does Rajan Singh work for?
Rajan Singh works for Kpmg India
What is Rajan Singh's role at the current company?
Rajan Singh's current role is Manager.
What schools did Rajan Singh attend?
Rajan Singh attended S P Jain School Of Global Management, Bhartiya Vidya Bhavans Sardar Patel Institute Of Technology Munshi Nagar Andheri Mumbai, Terna Engineering College, Nerul, Navi Mumbai, C.m Science College, Darbhanga, L.m.h.s Pupri, S P Jain School Of Global Management.
Not the Rajan Singh you were looking for?
-
Rajan Singh
Pune -
Rajan Singh
Founder & Ceo@Stafison™ | Hr Consultant | Niche Talent Acquisition | Mba | End To End Recruitment | Us Recruiter | C2C | C2H | Rpo |Noida -
Rajan Singh
Trivandrum3gmail.com, conceptowl.com, coursebrew.com2 +919930XXXXXX
-
Rajan Singh
Talent Management, I Hrbp I Adc I Talent Development I Organisational Culture I Organisational Development I Employee Engagements I Total Rewards I Mental Health First AiderHaryana, India3apollotyres.com, gmail.com, gmail.com -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial