Krithi Rai

Over 2.8 years of professional experience in the field of Software System Design, Development, deployment, Project Management Practices and BI solutions architecture. Involved in implementing full life cycle of BI Projects which includes Data warehouse/ETL, Data Modeling, design, development and in BI solutions architecture using Industry leading BI Tools for Modeling/ETL/Reporting/Administration

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.

BACHELOR