Head of Data Engineering
Ecofy
Total years of experience :5 years, 11 Months
• Working as a Data analyst in Internal audit and Business Control Department.
• Working as a Team Leader and providing Support to our on-site team at France by Daily Interaction.
• Using different Data analysis & Data Mining tools like IDEA, Win-shuttle, CSI tools for data extractions and analysis.
• Perform in depth analysis on data to find potential risks and frauds.
• Extract data from SAP using T-codes and other SAP basics.
• Working on standard Audit methodology for Finance, Sales and Purchase.
• Mostly working in Journal Entries Audit and IT Audit Support for SAP system of more than 40 different Entities of a Saint-Gobain Group.
• Working in VB scripts to get desired outputs.
• Using Advanced excel for data preparation and data analysis.
• Making Data analysis and audit reports with particular comments and Results which helps in Business Control.
• Have visited on-site Location of Paris for a Business Work and Training & to understand the requirement.
Highlights:
• Functioned as a Team Leader in an effective manner
• Efficiently worked in US Student Loan Market for process of securitization
• Played a stellar role in establishing the guidelines for receipt and appropriate format of underlying asset-level collateral that supported bond payments, as well as research and resolved any data accuracy issues
• Monitored Cash Flow analysis, Bond analysis, data mapping, data validations and standardizing data of more than 50 different issuers
• Played a stellar role in creating the cash flow models of bond analysis by standardizing parameters.
• Carried out:
o MIS reporting, VBA programming and software support activities like System testing
o Ad hoc/special projects which support process improvement and the implementation of technology initiatives.
• Essayed a key role in providing training to Junior Analysts on Advanced Excel, database, report creation, structure, systems, collateral and validation processes.
• Handled 6 members and streamlined he company processes with the help of the MD
• Doing Project analysis with ‘Waterfall’ Methodology.
• Involved in the Prototyping of a cash flow modeling and created VB based macro code for Data Validation with Statistical Calculations and to get alerts for data.
• Successfully handled the company processes for smooth and easy time-saving working.
• Validated and checked the major pool of data of their servicing reports and prospectuses of over 50 issuers.
• Supported the Black-box testing activity for developing our in-house tool called "Excel Loader" made in Silverlight.
• Executing SQL queries and Retrieve the Data for Data analysis.
• Managed and developing the working of new future project in Options Trading for prototyping a model in VBA Macro and Strategy Testing.
• Data Analysis with “Tableau” Tool
• Carried out:
o ISO 2009:1 Certification Audit Work
o Account receivables & payable of more than 1 Crore INR and MIS report generation on fortnightly basis
o Procurement activities for packing and raw materials
o Business system plan for company new system development
o Product costing of more than 40 different products to find out loss making and profit making product differentiation for review of top level management and simultaneously made profitability reports on monthly basis
o Managerial 80-20 rule for Inventory Management for Strategic View
o Tally ERP 9.0 inventory modules for better and smooth working
• Holds the distinction of developing a company’s new website (www.kisangroup.in) and accordingly maintained factory books and daily production reports
• Efficiently did project financing documentation work for company’s working capital requirements
URL removed due to policy violation. Please contact support for further information.