EOX Vantageis a global provider of remote staffingservices,
software products andconsulting services. TheirInternal product, Business Operating System (BOS) – EOS – enables organizations to gain visibility, control,and business intelligence to achieve Operational Excellence. Actionable dashboards and Red/Yellow/Green (RYG) color-coded data visualization within OX Zion give business leaders all the information they need to run their company, rightat their fingertips.
Key Result Areas
- Performed analysis, reviewand estimation of client request;prepared and reviewed business requirements and client documentation.
- Responsible for Developing a 360 businessdashboard with multiplepanels and parameters.
- Interactedwith Client manager/team members on weeklybasis.
- Created Dashboards with interactive views,trends and drill downs along with user level security.
- Created Test Cases for Reports, Framework Models and StoredProcedures.
- Documented functional specifications and participated inweekly meetings with developers and business units to discussoutstanding technical issuesand deadlines that had to be met.
- Created and maintained documentation on workflow processand data flow diagrams.
- Coordinated with Product owneron a regular basis to discuss the business requirements.
- Wrote complexSQL queries to take data from varioussources and integrated it with Talend. Automated excel reporting processes.
- Developed ETL process to load flat file data to MySQL database using different Talend components like tMap, tFileInputExcel, tFileOutputdelimited, tUniqRow,tMSSqlInput, tMySqlinput, tFileList, tPop, tEmailSend etc.
- Generated batch file and scheduled Talend ETL jobs using Windows Task scheduler on daily, weeklyand monthly basis.
- Created and maintained excel master sheets for differentclients which was used for data uploads.
- Used Open Refine and Data watch tools for data cleanupprocess and data transformation purpose.
- Maintained documentation related to difficulties, complexities, and anomalies that may arise during the ETL process.
Environment: Microsoft power tools, Talend Open Studio, OX Zion, Excel, File Zilla,Ui path, A-pdf Converter, Xampp,MySQL, SQL Server, Amazon Work Space, Outlook, SharePoint, SQL , DBviever. PowerAutomate
