Soumya Yenkanchi
Summary
SUMMARY
Aspire for a responsible and challenging career in a reputed organization environment being a proficient professional where I can contribute to the progressive development of the organization and to expand knowledge.
- 9 Years of globally experienced professional in Data Analytics . Experienced in analyzing the data for insights and effective use of ETL, Data Visualization and Data management tools to advance business operations and to process the engagements.
- Have worked with various competencies at diverse industry-specific Data Analytics, Information Management, quality enrichment, Product ownership and Business Intelligence
- Technically strong and having experience in multiple software's like MS SQL, Power BI and Alteryx.
- Good understanding of Auditing concepts, financial data, Developing and Delivery of the reports to auditors.
- Focused on team management and data extraction processes.
Eager to contribute to the team's success through hard work. Looking forward to widening ability to work well with people and get exposure to new ideas that stimulates personal and professional growth.
Dedicated to learning new skills and languages including Dutch.
Overview
9
9
years of professional experience
Work History
Senior Data Analytics Specialist
KPMG Netherland
10.2021 - Current
- As senior specialist worked on critical clients extracted data using SQL scripts from different ERP systems and analyzed extracted data using Alteryx to generate Journal entry analysis audit report.
- Took complete ownership of data extraction tool for online ERP system for AFAS and Exact online and worked closely with development team as Product Owner.
- Led project for data extractions from different on premises ERP systems that made process of extraction and further analysis faster.
- Developed strong client relationships through consistent communication and attentive service.
- Leading team of 6 members by managing client work and analyzing financial data from various clients to provide insights and troubleshoot issues in SQL server and Alteryx.
- Collaborated with cross-functional teams to achieve project goals on time and within budget.
- Assisted with auditors training where provided them knowledge on how to use journal entry analysis dashboards and other insights.
- Created and managed project plans, timelines and budgets.
- Improved customer satisfaction rates through proactive problem-solving and efficient complaint resolution.
Consultant (Data & Analytics)
KPMG Global Services
10.2019 - 09.2021
- Taking complete ownership of major critical clients and working as Technical lead by handling team of 5 members.
- Preparing extraction scripts to extract financial and General IT control data from different ERP systems like SAP, Oracle, MS dynamics ,Coda etc.
- Analyzing extracted General Ledger, Revenue and Payables data using KAAP specific SQL Stored procedures, SSAS & Power Bi to create audit reports for various audited entities at KPMG.
- Successfully performed pattern and trend identification for analysis of general ledger using Power BI visualization for Journal entry posting over period.
- Successfully interpreted Data in order to perform General ledger analysis, Revenue three way match for SAP ERP system.
Associate Consultant (Data & Analytics)
KPMG UK
10.2018 - 04.2019
- Planning with Audit team on extraction approach, delivery deadlines and implementation of new D&A processes to enhance the audit quality and methodology.
- Visit client site to implement extraction tool, send data to offshore for processing and create various audit procedure reports like General Ledger Analysis, Revenue 3WM, CRDT, Revenue Accounts Analysis etc.
- Review work done by offshore team in order to match quality standards and share reports with audit teams.
- Discuss with audit teams along with walk-through of reports and finding high risk criteria's.
Audit Associate (Data & Analytics)
KPMG Global Services
07.2017 - 09.2018
- Attended intensive KAAP training in Watford UK, during September 2017 on KPMG internal tool used for financial Audit.
- Sanitizing and preparing data completeness check using SQL and SSIS.
- Loading sanitized data in KPMG internal tool to generate files used by audit team in order to access high risk criteria, Trial balance, completeness , Revenue analysis and various other procedures.
- Successfully created stored procedure to generate summary of each analysis completed along with details of specific modifications done, this could be used to track down analysis. Worked on visualization project to re-create Dashboard from Qlick view to Power BI.
Sr Associate 2
Dell international Services
04.2015 - 06.2017
- Worked for Project of Lease administration and real estate JLL application and gained experience in enhancements based on client request to site using SQL server 2014.
- Involved in few sharepoint activities such as adding ASP forms site, workflow modifications, list creations and other minor activities.
- Worked specifically for User Management team and worked in night shift to provide support to JLL application clients.
Education
Bachelor of Engineering Technology - Automation & Robotics
BVB College of Engineering And Technology
06.2014
Skills
- MS SQL
- Alteryx
- Power BI , Microsoft Excel
- Python ( intermediate)
- Azure data fundamentals & Databricks SQL( beginner)
- SSIS and SSAS
- Audit Reporting
- Data Extraction for various ERP systems, like SAP , MS Dynamics , JD edwards, CODA etc
- Technical and non Technical problem solving ability
- Client Interaction, Project Management and Product ownership
- Data visualization, Business need analysis
- Audit and Finance Domain knowledge
Languages
Hindi
Native language
English
Proficient
C2
Dutch
Beginner
A1
Kannada
Proficient
C2
Timeline
Senior Data Analytics Specialist
KPMG Netherland
10.2021 - Current
Consultant (Data & Analytics)
KPMG Global Services
10.2019 - 09.2021
Associate Consultant (Data & Analytics)
KPMG UK
10.2018 - 04.2019
Audit Associate (Data & Analytics)
KPMG Global Services
07.2017 - 09.2018
Sr Associate 2
Dell international Services
04.2015 - 06.2017
Bachelor of Engineering Technology - Automation & Robotics
BVB College of Engineering And Technology
Similar Profiles
Altynay MoinakovaAltynay Moinakova
English as a Second Language Teacher at Embassy Of The Netherland in KazakhstanEnglish as a Second Language Teacher at Embassy Of The Netherland in Kazakhstan
Ashlee CohenAshlee Cohen
PBX Hotel Operator at Hilton Netherland PlazaPBX Hotel Operator at Hilton Netherland Plaza
Anela BehricAnela Behric
Hotel Front Desk Clerk at Hilton Cincinnati Netherland PlazaHotel Front Desk Clerk at Hilton Cincinnati Netherland Plaza
Niranjan AppajiNiranjan Appaji
Senior Data Analytics Specialist at United Overseas Bank (UOB)Senior Data Analytics Specialist at United Overseas Bank (UOB)
Maurice Q. De VeraMaurice Q. De Vera
SENIOR DATA SPECIALIST – DATA ANALYTICS AND VISUALIZATION at PWC ACCELERATION CENTER MANILASENIOR DATA SPECIALIST – DATA ANALYTICS AND VISUALIZATION at PWC ACCELERATION CENTER MANILA