Rimpa Budhiraja

Technologies Used: SQL Server, PostgreSQL,

Project: IEMP, Asset Recommendation, MyConcerto, Solution Finder, Application Reinvention Console and Generative AI

Client: Accenture

Responsibilities:

Currently working with a team as a python developer that would include integrating the queries (Sp-arql queries the queries that are generated using the Stardog data visualization tool into the code. And the major responsibilities would include integrating the AI and the python framework working in AI refinery and Agentic AI framework.

Working as a Scrum Functional lead Where the main profile corresponds to gathering requirements from the Client and documenting them so as to reach out to the developers and testing teams.

Maintaining the Azure dashboard and tracking progress of the work items in the respective sprints.

• Company Overview: SWG is an investor-owned utility based in Las Vegas, Nevada, United States. The company provides natural gas service to over 2 million residential, commercial, and industrial customers in parts of Arizona, Nevada, and California.
• Technologies Used: SQL Server 2008/2008 R2/ 2012/2014/2016 , GIT, Power Shell Scripting, Power BI Reporting
• Platform: Windows XP/10
• Project: SWG
• Client: SWG
• Description:
• Worked on a project for the client SWG (South West Gas)
• Responsibilities:
• Primarily responsible for designing the complex SQL Queries , optimising the queries and tuning performance.
• Working on the development and the implementation phase. It involves creating functions and procs in the Postgre
• Creating jobs in Talend Big data tool that would be feasible for the transformation of data
• Using various data tools like Robo 3T for Mongo database and table plus for Cassandra as the different data sources are being used for different modules.
• Creating jobs for insertion and deletion in the tables using Talend.

• Technologies Used: SQL Server 2008/2008 R2/ 2012/2014/2016 , GIT, Power Shell Scripting, Power BI Reporting
• Windows Platform: Windows XP/10
• Project: PFM
• Client: Multiple Airports
• Description:
• Working as a senior SQL developer at SITA. Currently Allocated to a project called PFM.
• Passenger Flow Monitoring (PFM) is a solution offered by SITA that provides end-to-end situational awareness of passengers through data visualization and reporting tools. These tools allow customers to optimize data collection and utilization.
• PFM enables the collection of passenger onsite check-in and boarding data as well as boarding pass scan events at designated screening checkpoints. PFM uses that data to reduce or eliminate fraudulent use of boarding passes. PFM also provides scanning and tracking of passenger information to help increase efficiency of operations and improve the overall level of customer service and satisfaction.
• Responsibilities:
• Primarily responsible for designing the complex SQL Queries , optimising the queries and tuning performance.
• Designing Reports and dashboards using PowerBI in the project called Common User Analyser
• Designing and creating new Adhoc reports onto the Webtop (Front UI of the PFM)
• Involved in running the SQL jobs that are scheduled to be run on daily and weekly basis.
• Actively involved in the Canadian Project Mexia (Mexia is a Canadian based company taken over by SITA)
• The Mexian Project is basically evolved out of Cloud Database.The Major responsibilities include designing the queries for multiple airports , scheduling jobs for the activities at the airports and the deployment of the code on the cloud.
• Project works on the Agile methodology and we mainly use GIT for the code development and deployment.

• Worked as a Associate Lead in Nagarro Softwares Gurgaon.
• Allinged to project for very small tenure for the Saxo Bank which included the creating reports in SSRS and modifying the queries using the SQL database.

• Technologies Used: SSRS, SSIS, SSAS and SQL Server 2008/2008 R2/ 2012/2016
• Windows Platform: Windows XP/10
• Project: Greater Insight
• Client: Multiple
• Experience in SQL : 6 years , SSRS : 6 Years , SSIS : 3 Years , Power Bi : 1 Year
• Description:
• Primarily was engaged in a project named Greater Insight which manages several financial benefits of employees of our client. This web tool have multiple modules which allows end user to manage employees benefits and help vendors to bid.
• Responsibilities:
• Involved in Data processing and reporting using SSRS,SSIS and MS SQL Server 2012.
• Responsible for working directly with business to identify their client needs, rules and application user requirements.
• Responsible for Requirement gathering, Requirement clarification on Mail/Call/Chat, suggesting change in requirement if needed from technical point of view, analysis, estimation and Documenting Technical Specifications.
• Working for more than 7 country’s business units (U.K., France, Australia, Germany, Netherlands, China & few gulf countries) of Aon, having multiple clients.
• Created complex reports for the business user delivery purpose.
• Reports Subscriptions, Report language rule, Matrix Reports, Sub Reports, Dynamic query Reports, Standard Reports.
• According to the requirements of client we have to supply various types of graph, table & matrix reports using data warehousing concepts.
• I have trained 2 people of my organization on SSRS and architecture of our database
• Using various tasks of SSIS, Extracting and Transforming the Data.
• Processing data from Excel files, CSV files, and Text files as per business logics.
• Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, sort and execute SQL Task to load data into Data Warehouse.
• Handling all kind of ad-hoc queries in form of New Report Request, Enhancement Request, Rush Request, Managing Test Track & managing flow of request with 2 peer members.
• Analyzing impact on database and existing reports for various change requests raised by business team.
• Involved with DBA (Database Administrator) & Greater Insight Application Management Team.
• Prepared various documentation for training, database structure, Rules defined by team for maintaining development standard, Quality Checks etc.
• Created Event Handlers to Handling Errors and Debugging for the Packages.
• Performance Optimization and devising new Stored Procedures, Functions & Query.
• Project: Automation
• Client: AON
• Description:
• Previously engaged in a project named Automation which involves Automation Testing i.e automating the processes that are currently used by the Operations Team within the Organisation.
• Responsibilities:
• Involved in automation of tools like MainFrame, TBA, Excel , Outlook.