Aman Saxena

Worked on 4 projects focused in Marketing Analytics, database migration testing and database cleaning while supporting service request from clients. Implemented 12+ batch data & ETL/ELT data pipelines with up-time 99.8% to process structured data from different data sources using Tableau prep. Implemented 12+ automated jobs to run at desired intervals to refresh data warehouse saving 4hrs of manpower per day. Managed 3 database layers (Stage, Core & Reporting) within a data warehouse. Created a combination of 400+ SQL ETL scripts, stored procedures, UDF(s), views, CTE, nested CTE/queries to clean and transform the data as required, thereby creating logics to create new parameters, markers and datasets for dashboards. Documented 15+ data pipeline processes, data transformations and database diagrams. Communicated analytical insights through analysis, synthesis and packaging of results (including PPT slides, charts, spreadsheets & Dashboards). Also provided KT sessions to clients/team.

Ensured the performance, quality and responsiveness of 4 applications using Asp.NET Core, Asp.NET MVC, C#, Web APIs, jQuery/JavaScript, HTML and CSS writing structured, tested, readable and maintainable code. Created and modified over 300+ PL/SQL SPs, functions, views, triggers, error handling and CRUD queries along with supporting service request from clients to fetch customer specific data from database. Identified and corrected over 100+ bottlenecks and bugs fixes in front-end, back-end and database environments. Maintained the CI/CD pipelines on Azure DevOps and performed deployments on testing environments to validate the features before production deployment. Monitored website performance using App Dynamics and HTTP GET/POST request flows and used GIT for version control. Completed analysis, design, and testing phases of software development life cycle.