Jan 2023 – Present · 3 yrs 5 mos · Noida, Uttar Pradesh, India · Hybrid

• IndianLaw.ai is a AI based website that provide Law solutions by running an AI predictive model on existing Indian Constitution and provides right ruling recommendations to the end clients who are seeking expert legal advice.

Aug 2019 – Mar 2021 · 1 yr 7 mos · Gurgaon, Haryana, India

• Working in technologies like Python,
• Pandas, Numpy, Open refine, D3.js, Pig, Hive, Scala, Hadoop, etc.
• Topology Design: high availability, horizontal scaling, fault tolerance, disaster recovery
• Performance: performance analysis, benchmarking, database tuning, system tuning
• Data Conversion/migration
• Data Modeling: denormalization, normalization, atomicity of operations, document growth, embedding, references (one-to-one, one-to-many, and many-to-many), vertical and horizontal scalability, GridFS
• Indexing: single field, compound, multikey, geospatial, text, hashed, TTL, unique, sparse, index creation, index intersection, multikey index bounds
• Ǫuery Design: performance analysis, query optimization, query plans, distributed queries, two-phase commits, update concurrency control, auto-incrementing sequences, geospatial queries, text search queries
• Analytics: aggregation pipelines, map-reduce, single-purpose aggregation operators
• Replication: requirements analysis, deployment architecture, high availability, elections, replica set read and write semantics, oplog, data synchronization
• Sharding: requirements analysis, architecture, configuration, data partitioning, tag-aware sharding, locale-aware sharding, shard key selection, balancing
• Security: authentication, role-based access control, auditing, redaction, encryption
• Operations: monitoring, backups, capacity planning, diagnostics, maintenance
• Cloud Manager / Ops Manager: capacity planning, deployment design, installation, administration,
• Atlas: instance sizing, deployment design, migration strategy, live migration of data.

Feb 2019 – Aug 2019 · 6 mos · Gurgaon, Haryana, India

• ● Created a TC Scales Utility for showing insights for personality assessment test using C#, SQL Server 2016.
• ● Performance optimization of various reporting procedures.
• ● Created ETL’s for Leader Edge project from scratch.

Dec 2016 – Jul 2018 · 1 yr 7 mos · Bengaluru Area, India

• Worked real-time bidding platform for ad-serving platforms in order to ensure relative and contextual ads with best bid are rendered.
• Optimized reporting queries using appropriate indexing, partition switching, cube aggregations and replication in RDBMS.

Jul 2015 – Nov 2016 · 1 yr 4 mos · Hyderabad Area, India

• Worked on various technologies like SSMS, SSIS,Transact-SQL, Java Script, Angular JS, HTML,C# ,CSS ,R, Python.
• Worked in 2 BI projects as a full stack developer using the technologies above and gained immense knowledge to handle projects end to end.
• Migrated entire projects data for last 6 years from RDBMS to COSMOS(MSN Big Data Platform)
• Developed a C# library having various SQL functionalities implemented to be compatible with Scope script of COSMOS.
• Created various charts in C# needed for effective business decisions
• Developed a C# utility to check data type compatibility across servers before ETL runs.
• Optimized reporting queries in less than a second by using Query Optimization Techniques.
• Created web reports using Power BI, HTML, CSS, Angular JS, Jquery, Java Script, Bootstrap.
• Implemented an ML algorithm in R and Python for predictive business analysis.
• Created cubes, indexes fro reducing query processing time.
• Created processes and coding standards for better understanding and maintainability of code.
• Created and managed ETL jobs.
• Created Packages in SSIS.
• Created Stored Procedures, Functions and complex business logic related queries in T-SQL using SQL Server Management Studio 2014.
• Implemented Retry logic and also gained insights in uses of Power BI.
• Implemented various features and delivered them on time with resource management.
• Managed Code in visual studio online both in git and team foundation server. Also learnt to use Release Management online to handle various releases and builds.
• Broadened my knowledge in Database and Data warehousing.
• Broadened my knowledge in Algorithms.

Jul 2014 – Mar 2015 · 8 mos · Pune Area, India

• Worked as a Project intern in TCS:TRDDC
• Project on Effectiveness of soundness in static analysis (TCS: TRDDC)
• As part of our fourth year final project my team got sponsorship from TATA Research and development center. In this project we worked on bug detection tools like Find Bugs (unsound bug detection tool) and NPE Detector (sound bug detection tool). This was a research project in which we analyzed the number and kind of null pointer dereferences found by both the tools. By comparing analysis of both the tools we concluded that soundness is crucial in bug detection tools used for real time applications but if ignored it may lead to unavoidable situations or even hazards.

Jul 2014 – Mar 2015 · 8 mos · Pune Area, India

• Created 3 minor and 1 major projects in java and oracle db as part of ESD program.
• Learnt to create projects in core java and utilized the knowledge in the projects created.
• Learnt Advance java concepts like jsp, servlets and created various jsp pages.
• Created a vendor availabilty website using java and oracle database.
• Learnt to use Dream Weaver, Oracle 11g, My SQL and eclipse IDE.

May 2012 – Jul 2012 · 2 mos · New Delhi Area, India

• I worked in developing object-oriented API for a complaint system for the organization and provided effective modules in Java and Oracle 10g in creating complaint notification system for the project.
• The project involved logging of issues coming in various DRDO labs and allotment of these issues to the concerned department engineers based on their availability.
• The notification system focused on fixing a slot for an engineer to fix the issue and a notification to be sent to the Scientist who raised the issue and to the engineer's department manger.