Richa Sharma

• As Software Engineer:
• Development of an Advanced Safety System Software for Threat Detection and Analysis
• Led the backend development of the company's flagship product, implementing scalable cloud infrastructure that supported a 10x increase in user base within six months.
• Developed and integrated AI-based threat detection and response algorithms, enhancing product efficacy by 25%.
• Instituted Agile project management methodologies, shortening the product development lifecycle by 20% and increasing cross-functional team collaboration.
• Led the design and implementation of a safety system software integrating audio transcription and NLP analysis from diverse sources including home
  cameras, police body cams, security guard safety devices and personal safety devices
• Created Embeddings and implemented
  RetrivalAugmentedGeneration(RAG) by utilizing Vector Database for Q&A
• Engineered a scalable API for real-time audio to text transcription using OpenAI's speech recognition technology, enhancing system responsiveness and accuracy
• Implemented Prompt Engineering techniques for the automated generation of incident summaries and reports, facilitating quick and informed decision making by security personnel
• Collaborated with cross-functional teams to ensure the system's adherence to stringent privacy and security standards, leveraging encryption and secure data handling practices
• Developed API in Python FASTAPI
• Developed Dashboards in Streamlit.
• As Co-Founder:
• Spearheaded the development of the Nirbhay Safety Glove, leading to a 40% reduction in production costs and a 50% increase in market penetration within the first year.
• Secured funding of over 3M INR from venture capital and angel investors, establishing strategic partnerships that expanded the product line.
• Cultivated a company culture focused on innovation and user-centric design

● Design, implement and maintain database objects (tables, views, indexes, etc.)

● Collaborate with the Data Architect to recommend optimal data models for data ingestion.

● Designed, Implemented and Performed Unit testing.

● In this team, I'm in charge of ensuring that all Referral Dashboard Development needs are met.

● I'm in charge of building the data pipelines and rich graphic visualizations

● Created extensive custom joins for blending data from several different data sources.

Extensively used SQL to analyze the data.

• Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
• Resolved complex business challenges by leveraging statistical modeling techniques and machine learning algorithms.
• Developed complex dashboard and reporting tools to track business performance metrics.
• Evaluated the effectiveness of marketing campaigns using A/B testing methodologies, optimizing strategies for higher ROI.
• Safeguarded user experience by validating functional requirements through comprehensive usability testing efforts.
• Documented testing procedures for developers and future testing use.
• Tested functional and compatibility of new programs or updates in comparison to existing applications.
• Strengthened customer confidence in product quality, providing thorough and transparent documentation of testing activities for stakeholder review.
• Reduced manual testing efforts with the development of reusable automated test scripts.
• Developed and executed comprehensive test plans to validate data integrity and accuracy, leveraging SQL for database testing
• Implemented automated testing scripts to verify report functionalities and data visualizations, ensuring high-quality deliverables and adherence to Agile methodologies
• Communicate with project managers and analysts on day-today basis about data pipelines that drove efficiency

● In this project, we were responsible for gathering the required sets of data from N number of Markets.

● We had done a thorough impact analysis on given scattered data from different Markets.

● Working on bringing the raw and scattered data to the enterprise data warehouse during the requirement gathering phase.

● Major challenge was bringing all the data from different markets into the acquisition layer to the data warehouse layer.

● Created Systematic layer from the data warehouse and used it to create a semantic view(BTEQ Query).

● Fixing up issues if there are any in the existing process.

● Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, and networks

● Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques

● Participate in component and data architecture design, technology planning, product evaluation, and advanced testing processes

● Design, code, test, and support application software that is delivered on time and within budget.

● Created Tableau Dashboard from different data sources by applying aggregations that were required by Business rules.

● Enhancing the functionality of existing reports and working on improving the performance.

● Requirement gathering and analysis of technical specification.

● Fixing up issues if there are any in the existing process.

● Review reports at my end and share it to clients.

● Unit Testing on the code develop.

● Migration of code to a higher environment using Python scripts.

● Using GIT repository for keeping the code and running through Jenkins for unit testing.

● Using the CICD process.

● Performed extensive GAP analysis in the project as there were numerous 'As-Is' and To-Be' conditions.

● Involved in creating database objects like Materialized Views,Semantic Views,ESP Jobs triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

● Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

● Restricted data for particular users using Row level security and User filters.

● Developed Tableau visualizations and dashboards using Tableau Desktop.

● Developed Tableau workbooks from multiple data sources using Data Blending.

● Sound understanding of Github,Fitnesse and Jenkins(Perform Automation Testing).

● Developing/Modifying Business needs according to Clients requirement.

● Design and create dashboard reports which illustrate the data in tabular format and well formatted charts.

● Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.

● Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.

● Used the OBIEE Admin Tool to develop the three layers in the Repository.

● Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.

● Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.

● Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.

Worked extensively on OBIEE Answers to create the reports as per the client requirements.

● Developing/Modifying of business needs according to Clients Requirements

● Involved in requirement gathering from client and analyzing their needs

● Involved in all phases of development and delivery.