Meenakshi Singh

Meenakshi Singh

$30/hr
Data analysis and reporting. Advanced Excel, VBA, Tableau, Python, R, and SQL, ArcGIS 10.
Reply rate:
-
Availability:
Full-time (40 hrs/wk)
Age:
33 years old
Location:
Sion, Valais, Switzerland
Experience:
10 years
MEENAKSHI SINGH Email:-| Mob: - | LinkedIn: Meenakshi | Rue St. Guerin, 36, Sion, Switzerland ABOUT ME 10 years of professional experience in banking and telecom sector with a strong foundation in data analysis and reporting. Skilled at transforming complex data into actionable insights for senior management, leveraging analytical expertise and keen attention to detail to deliver high-quality reports that drive strategic decisions. Passionate about harnessing technology to enhance operational efficiency and optimize performance. A keen learner with a flair for adopting emerging trends and addressing industry requirements to achieve organizational objectives and goals. EXPERIENCE SUMMARY • Expertise in Advanced Excel, including Pivot Tables, Pivot Reporting, and Data Validation. • Automated manual processes using VBA, reducing inefficiencies and improving productivity. • Proficient in SQL, with experience in querying, updating, and managing databases. • Streamlined data collection and optimized weekly, monthly, and quarterly reporting. • Strong data interpretation skills, providing insights for managerial decision-making and strategy. • Developed interactive dashboards using Tableau and Power BI for data analysis and visualization. • Proposed system enhancement solutions to improve efficiency and reduce costs. • Improved reporting accuracy and efficiency through automation and process optimization. PROFESSIONAL EXPERIENCE Standard Chartered GBS | Manager | February 2022 - Present • • • • • • • • • Managed daily BAU operations to ensure seamless operations, including VBC packs, TRF, OEF, Remote booking report, EDR, CIBRC doc, frameworks, and regional business packs across Taiwan, America, GCNA, HK, and Singapore markets, covering FX, Rates, Commodities, and Treasury asset classes. Analyzed reserve/IPV (independent price verification) product abnormalities, like reconciliation breaks, and automated the reconciliation process. Developed Power BI dashboards for trend analysis of Reserves & IPV, enhancing visibility and decision-making. Collaborated with cross-functional teams to coordinate Reserves & IPV activities, resolve operational issues, and ensure alignment with business goals. Led product team in process redesigning and streamlining daily/monthly front-to-back processes, identifying root causes of inefficiencies, and implementing controls to prevent such issues from recurring by coordinating with stakeholders. Optimized existing workflows, reducing turnaround time by 50% while improving report accuracy. Proactively identified operational challenges, implementing solutions to support informed decision-making and operational excellence. Perform UAT testing and identify bugs and gaps Supported audit and regulatory reviews, ensuring compliance and designing efficient reporting processes. Key Projects Completed: • EDR (External Data Reporting): Automated and streamlined EDR using Power BI & SQL, ensuring accurate external disclosure of reserve numbers across business categories, reducing the overall process time by 90%. • Monthly Dashboard Development: Created a Power BI dashboard to visualize monthly reserve and IPV figures, including MoM (month-on-month) trend analysis improving the process efficiency by 90%. • Process Automation: Led initiatives to automate recurring tasks, increasing efficiency and reducing manual effort. Ericsson India Global Pvt. Ltd. | Sr. Data Analyst | August 2018 – January 2022 • • • • Developed and delivered analytical reports, dashboards, and ad-hoc reports to senior management, supporting datadriven decision-making. Collaborated with onshore teams to ensure secure and confidential work environment for handling highly sensitive data. Designed and implemented Tableau dashboards to track headcount trends (weekly/monthly/quarterly) and analyze employment types. Created a TTF (Time-to-Fill) dashboard to monitor recruitment timelines at various stages. • Extracted and updated data from the ITM portal using SAP & SQL, ensuring accuracy and efficiency in workforce planning. Key Automation & Process Enhancements: • BTEB Macro: Transformed raw data into meaningful insights for dashboards, reducing data processing time by 95% • GLT Macro: Open and closed positions details for different regions improving process efficiency by 80% • ARP Clean-Up Macro: Improved workforce planning accuracy and reporting quality, enabling leadership to make informed decisions by ensuring 100% accuracy in the processed data • Auto Mailer Macro: Automated notifications to hiring managers, enhancing transparency in recruitment processes. (STUDY BREAK - From January 2017 to July 2018, refer to section Trainings and Seminars ) Bechtel Corporation Pvt. Ltd. | Data Analyst | September 2015 – December 2016 • • • • • • • Extracted and analyzed large volumes of structured and unstructured GIS data using SQL and Excel, transforming raw data into actionable insights. Performed data mining, cleaning, and validation to ensure accuracy and completeness in network datasets. Developed actionable templates for the Network Planning and Operations Department, enabling preventive maintenance and strategic decision-making. Utilized available data sources to troubleshoot performance issues, enhancing network efficiency. Implemented dynamic VBA coding to compile multi-sheet data across workbooks, streamlining reporting. Developed preventive analytics for network health maintenance, minimizing downtime, improving uptime, and preventing customer churn. Supported the Procurement Department by automating BOM (Bill of Materials) and BOQ (Bill of Quantities) reports using Advanced Excel & VBA, enhancing operational efficiency. Bechtel Corporation Pvt. Ltd. | GIS Executive | September 2014 - September 2015 • Worked with GIS tools such as Google Earth, AutoCAD, and other geospatial software for network planning and design. • Geo-planning and design for FTTH (Fiber-to-the-Home) networks and drafting in GIS, ensuring optimal infrastructure layout • Planned and optimized FTTX feeder & distribution networks, including BOM, BOQ, and OLT/S2/S1 placements. • Developed preliminary and detailed designs for fiber access and distribution networks, ensuring scalability and efficiency • Performed network migration using NE (Network Engineer) software and conducted quality control (QC) of design diagrams in 3GIS. SKILLS AND EXPERTISE • Power BI, Tableau, Python, Advance Excel, SharePoint, VBA, SQL, SAP, ITM, MS Office • Data Mining, Pattern and Trend Identification, Quantitative Methods, Experimental Design and Analysis, Data Warehousing, Quality control (QC) and Quality assurance (QA) EDUCATION MBA, Master of Business Administration | Business Analytics University: BITS Pilani Website: https://www.bits-pilani.ac.in/ B.Tech, Bachelor of Technology | Electrical and Electronics Engineering University: IILM, UPTU Website: https://iilm.edu/ August 2020 – July 2022 August 2010 - July 2014 TRAININGS & SEMINARS • 1.5 years online/offline interactive training program on SAS, Python, and R Language from Simplilearn, including predictive modeling, Data visualization, Regression, and Clustering • Six weeks of training on VBA & SQL from Gyansetu, Gurugram • Two weeks training on Advance Excel & Tableau from Infotech media, New Delhi
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.