Etl Data
Resume:
CHARU ADVANI
***************@*****.***
Education, licenses &
certification
● Master of Computer
Applications – Govind Ballabh
Pant Univ. of Agriculture &
Technology, Pantnagar
● Bachelor of Computer
Applications – Panjab
University, Chandigarh
● Advance Diploma in
Entrepreneurship Development
– Panjab University,
Chandigarh
Technical skills
● Sql Server
● ETL, EAI, SAML, YAML,
Punchout
● IDOC SAP Integrations
● REST and SOAP web
services
● SFTP
● SSO
Representative clients
• State of Arizona
• Nayara Energy
• UPL
• IBM Chemonics
• Stryker
• Nexteer
• A1 Telekom
Integration Specialist, Professional Services
Background
A dynamic and result-oriented professional with close to 3 years of experience in all phases of Software Development process including integration interface design, application development, requirement gathering, solution designing and implementation of SOA. As an Integration Specialist, the primary work revolves around integration development using standard or custom approach to solutionize and simplify complex functional or integration needs of the customers for P2P and S2P solutions and building a connectivity with an external ERP system. Professional and industry experience
• Participate in design sessions with the business to understand the requirements of the client from technical perspective.
• Develop a connectivity with the external ERP system for integrating data.
• Works on large amount data migration and conversion, databases conversion, and ETL tool migrations including repository database migration and conversion
• Good hands-on experience with the SQL Server queries for handling REST/SOAP based XML files and Web Service in ETL transformations.
• Extensively works in SAP Integration/Migration Project using ETL and EAI.
• Works on designing and developing REST API and file-based frameworks.
• Works on tool like Snaplogic for middleware transformations during data flow between the 2 ERP systems.
• Involved in catering and managing customer expectations and with higher management to meet project timeline and quality obligations.
• Involved in the Implementation and Deployment of integration and functional changes to the existing applications as per the customer requirements.
• Proven problem-solving skills with excellent analytical, communication and interpersonal skills.
• Prepares standard design documents and Technical Specification documents.
• Design and review the Interface/Conversion ETL code before moving to QA to ensure design standards are met.
• Solves various performance and complex logic related issues with effective and efficient solution in the ETL process (performance tuning) and identified various bottlenecks and critical paths of data transformation in sessions for different Interface. Work History
• Dec 2017 to Dec 2019 – Integration Analyst - Zycus Infotech, Mumbai
• Collaborates closely with functional and technical team to solutionize and simplify complex functional or integration needs of the customers.
• Assists the operations support team with customer implementation by doing root cause analysis for issues and outages.
• Proficient use of XML and JSON data flow process between the ERPs.
Strong analytical and interpersonal skills with excellent communication and work ethics.
• Proficient use of YAML for writing OpenAPI definitions in swagger.
• Dec 2019 to Present - Integration Specialist - iValua, Pune
• Develop an integration mechanism as per client requirements for easy exchange of data between the 2 systems.
• Internal testing of the developed integration mechanism and provide client support during their testing phase.
Contact this candidate