Integration Specialist Ii
Current• Working as an Implementation consultant mainly looks for Integration of Apex Portal with SAP, Oracle, Workday, Peoplesoft, and many other ERP systems.• Presented technical overview of apex portal and technical requirements to our Partners (EY/Deloitte/PwC) and clients when planning implementations and upgrades.• Assisted clients in designing and developing interfaces between their ERP systems and apexportal and lead the testing of ERP integrations which includes reconciling data… Show more • Working as an Implementation consultant mainly looks for Integration of Apex Portal with SAP, Oracle, Workday, Peoplesoft, and many other ERP systems.• Presented technical overview of apex portal and technical requirements to our Partners (EY/Deloitte/PwC) and clients when planning implementations and upgrades.• Assisted clients in designing and developing interfaces between their ERP systems and apexportal and lead the testing of ERP integrations which includes reconciling data between client’s ERP system(s) and apexportal.• Developed and unit test different baseline modules of apexportal Solutions product.• Provided information and recommendations to leadership on both regular and ad-hoc basis. Prepared regular reports for management.• Experience in all phases of software development life cycle i.e. Project Planning, Requirement gatherings (Functional and non - functional), Project Designing, Project Development, Quality Control, Project Deployment, Project Maintenance• Reviewed business requirements with project teams to propose and produce technical documentation on data architecture, data modeling, metadata creation, source to target mapping with transformation rules, ETL data flow design, and test cases.• Ability to communicate and shape complex analytical information into actionable business recommendations.• Experience in creating and maintaining complex T-SQL queries for dimensional data models.• SQL Jobs, including creating, scheduling, and troubleshooting jobs using SQL Agent• Conducted data profiling and data quality check on Historic data load from client ERP like Oracle, SAP, etc.• Experienced working on TFS stack to prioritize, organize and change tasks priority based on SDLC.• Hands-on experience with REST and SOAP API• Knowledge of FTP, secure FTP, and PGP to securely transfer the files. Show less