Kamlesh Kumar Singh

- Kamlesh Kumar Singh linkedin.com/in/kamlesh-singh-b-/ In - New Delhi, 110071 Summary Detail-oriented and results-driven Data Analyst with hands-on experience in collecting, cleaning, and analyzing large datasets from diverse sources including databases, Salesforce CRM, and external datasets. Skilled in transforming complex data into actionable insights through reports, dashboards, and visualizations using Power BI, SQL, and Microsoft Excel. Proven ability to support strategic decision-making through analysis of business performance metrics, connectivity ratios, and data quality. Adept at stakeholder communication, delivering tailored reports, and ensuring data accuracy and integrity within CRM systems. Proficient in data transformation tools like Power Query and DAX, and advanced Excel functions to support efficient reporting and data processing. Experience ConnectAndSell Inc. (Payroll on PCITS Ltd.) Process Lead Feb 2014 - Nov 2024               Collected data from various sources, including databases, Salesforce, and external datasets. Cleaned, transformed, and analyzed large datasets; presented insights through reports, dashboards, and visualizations. Conducted analysis on average connectivity, Dials-to-Connect (D2C) growth ratio, business performance decline, and data quality to increase business growth and support strategic decision-making. Shared the findings to management and customer, explaining the implications and providing recommendations. Analyzed Free Trials (ITDs) data and presented actionable insights to customers, demonstrating how our services could boost their performance by up to 10x. Created and delivered ad hoc, daily, weekly, and monthly reports tailored to customer and executive requirements, ensuring timely insights and data-driven decision-making. Proficient in Microsoft Excel functions including VLOOKUP, HLOOKUP, INDEX-MATCH, SUMIF, and FILTER for efficient data processing and reporting. Designed, developed, and maintained Power BI dashboards; utilized Power Query for data transformation and DAX for custom measures and KPIs. Wrote and executed SQL queries for data extraction and analysis using SELECT, JOIN, ORDER BY, WHERE, GROUP BY, HAVING, RANK, DENSE_RANK, ROW_NUMBER, LEAD, and LAG functions. Collaborate with other teams to interpret data and translate business requirements into analytical solutions. Used Python libraries like pandas and matplotlib for data analysis and visualization. Manage the customer data into CRM and ensure data integrity through regular contract audits and duplicate checks. Export data from CRM (Salesforce) for reporting purpose and audits the contract per the set process. Upload data into CRM using data loader and merge the duplicate leads, contacts and accounts. Nomea Strategic Consultants Pvt. Ltd. Research Analyst Apr 2013 - Jan 2014  Automated repetitive tasks using VBA (Macros) in Excel, including creating new macros, recording, and modifying existing ones to meet evolving business needs.  Prepared ad hoc reports on a daily, weekly, monthly, quarterly, and yearly basis, including:  o Management Reports: Comprehensive summaries of all customer-related activities. o Executive Briefings: Detailed analytics covering agent performance and outbound calling metrics. Performed end-to-end data cleaning processes to ensure accuracy, consistency, and usability of client-provided datasets, eliminating discrepancies and formatting issues. .  Conducted rigorous data validation against client-defined procedures, prototypes, and standards to ensure data quality and compliance.  Implemented validated datasets for session-based reporting, generating tailored insights and dashboards based on specific client requirements. Skills Data Analysis | Excel | SQL | Power BI | Python |CRM (Salesforce) | Google Sheet | VBA | MS Word | MS Power Point Certifications Salesforce Admin Certification - ADM 201 Education Sikkim Manipal University MCA - 2012 Sikkim Manipal University BCA - 2010 B.I.E.C. Board XII - 2007 B.S.E.B X - 2005 Language English - Proficient | Hindi - Proficient