RAJAT MANGOTRA

Product Development

· Researched and investigated project requirements.

· Following the agile approach broke the work into Jira stories.

· Developed multiple reports for a product, including the pilot in PySpark and integrated them with Power BI based front end using Google Big Query.

· Designed and developed an initial portable configuration set-up module to aid the smooth deployment of the product across multiple clients.

· Used Git for the development and enhancement of the product reports.

· Optimized, Quality Assured and performed cost estimation of the reports for the largest retailer in NAM.

Compliance Report

· ETL unorganized license compliance data from multiple windows machines requiring complex rules implementation to extract meaning information using Python.

· Developed a generic language converter python module to execute PostGre SQL queries from Python interface to be reused outside of the project.

· Crunched the compliance data for KPI's using Python and pushed them to Postgres tables.

· Integrated the Postgres tables with the Power BI-based front end of the compliance report.

· Used NLP to obtain the compliance report insights.

· Automated the entire process from data collection to data crunching to pushing data in PostGre tables using crontab and scheduled it to run every fortnight.

· Created and developed the relevant logics to archive older compliance data.

Subject Matter Expert

• SME for Python, Spark & coding principles.
• Conducted multiple training sessions for the same.

Services

• Researched various business solutions for Category Management used by multiple clients, collated their variations across clients, and came up with the solution's global version.
• Developed codeline's for the global version of the solution in PySpark.
• Compared various outlier techniques like IQR, Local Outlier Factor etc to best fit model parameters for optimising the retailers space in store.