Shringi Rai
Development
Delhi NCR, India
Skills
Data Engineering
SQL
Apache Spark
Hadoop
Hive
AWS (Amazon Web Services)
Big Data
Data Analysis
Azure Databricks
About
Shringi Rai's skills align with Programmers (Information and Communication Technology). Shringi also has skills associated with System Developers and Analysts (Information and Communication Technology). Shringi Rai has 6 years of work experience.
View more
Acomplishments
I was able to automate a report compilation, that used to take around 2 weeks of manual effort at minimum for each iteration and bought its execution time to under 30 mins using PySpark and Excel automation
Implemented an end to end solution for a non technical client who wished to analyse data on their fingertips. With very little knowledge of reporting tools I volunteered for the task of creating a visualization dashboard after understanding the requirements from the client and was able to develop a Power BI dashboard.
Work Experience
Senior Consultant
EXLService
June 2021 - Present
- Analysed the requirements and worked with multiple teams and stakeholders of different business units in order to identify the potential sources for the requirement, compiled the STTM, business logic for the development. Designed and developed the ETL solution using AWS, PySpark and built Power BI Dashboards. Eliminated hard-coding and optimized the logic while integrating the solution. Automated the generation of the final report in its original template within the ETL solution design.
Senior Software Engineer
Wipro Ltd
March 2021 - June 2021
- Insurance Client - Alight Solutions 1. Enhanced the existing ETL logic to accommodate the newer requirements. 2. Developed a complex ETL solution on the Hadoop platform to merge 4 distinct source data to analyse fraud patterns governed by the given business rules. 3. Worked closely with the stakeholders and documented the requirements.
Cloud Security Associate
Accenture
February 2019 - March 2021
- Service provider Client 1. Data Migration from SSMS to Aurora DB for the employee's portal of SailPoint Identity IQ. 2. Imported tables from SSMS to EMR cluster via Sqoop Job. 3. Created Hive tables over the imported data and created new transformed tables. 4. Pushed all the data to another S3 bucket to maintain hot storage while also maintaining a cold storage on AWS glacier. 5. Scheduled the above tasks using Oozie job. 6. Created a Lambda function which is invoked by s3 new file, to load these data files to Aurora DB and on successful completion sends notification via SES. 7. Performed Testing of Dynamic and Static dashboards and Back-end Database (SSMS). 8. Test Data Management: Compiled requirements, analysed breakpoints of the developed code and created data for testing the same. 9. Experience in designing, preparing and executing test cases for Databases and Web Applications using SDLC concepts. 10. Hands on experience in Data requirements gathering, development, analysis, preparing Business Solution documents (Test cases, user interfaces, report specifications, system to system interfaces), workflow design and functional (Application) testing. 11. Experience in Identity Management Solutions, Life-cycle Manager and ID Provisioning in SailPoint Identity IQ. 12. Interaction with S3 Bucket to upload test data for data migration to SailPoint. 13. Experience in Identity Management concepts like identity life cycle, identity provisioning and de-provisioning, and aggregation in SailPoint Identity IQ. 14. Tracking of defects using Azure DevOps.
Analyst Trainee at Vedicsoft solutions
Airline Customer
July 2018 - February 2019
- 1. Performed SailPoint testing. 2. Analysis of business requirements and providing estimates for the related test. 3. Execution of test scenarios, finding defects and tracking them. 4. Updated test scenarios and documentation. 5. Performed Functional, Regression and UAT testing, identified and executed test scenarios for data validation on SailPoint Identity IQ.
Education
