Vanika Rattan

Professionally skilled Software engineer with 3+ years of work experience.
Proficient at executing a deep dive to gather actionable insights to benefit key stakeholders and facilitate sound decision-making while generating an error-free report. I can efficiently work on an ad hoc basis to understand the needs of business leaders and effectively deliver the data products that address those needs at scale.

Senior Associate Data Analyst 
• Developed Innovative dashboard using Quick sight and Salesforce for better visibility for key 
operational metrices. 
• Used salesforce with SQL to build a dashboard.
• Integrated dynamic dashboards allowing managers to have immediate insights of current operation 
status.
• Improving the efficiency of the process using the SQL queries.
• Used SQL and Big data queries to get Quick data of an Employee from the payroll central.
• Used MYSQL with amazon quick sight for the ETL process which helped easy dashboard building
and adding less calculated fields.

Tools Used: AWS tools such as Quick sight, AWS analytics services, PeopleSoft, Payroll central, ADP, Kronos Workforce, Salesforce ERP, Amazon A to Z.

Working With AWS tools such as Quick sight, AWS analytics services, PeopleSoft, Payroll central, ADP, Kronos Workforce, Salesforce ERP, Amazon A to Z. Have developed innovative Dashboards solution which is enabling real time visibility into Key operational metrics at all levels of the organization. I have integrated dynamic dashboards allowing managers have immediate insights into current operations status without having need of additional training or resources. I have improved the efficiency of the process. Worked with HR Policies and Procedures of Amazon.
Efficiently Handling Employee relations matters, such as handling employee inquiries, resolving conflicts, and providing general support. Assisting with performance management processes, including tracking performance evaluations and ensuring timely completion.
Improving operations and processes with various stakeholders.Working With AWS tools such as Quick sight, AWS analytics services, PeopleSoft, Payroll central, ADP, Kronos Workforce, Salesforce ERP, Amazon A to Z. Have developed innovative Dashboards solution which is enabling real time visibility into Key operational metrics at all levels of the organization. I have integrated dynamic dashboards allowing managers have immediate insights into current operations status without having need of additional training or resources. I have improved the efficiency of the process. Worked with HR Policies and Procedures of Amazon. Efficiently Handling Employee relations matters, such as handling employee inquiries, resolving conflicts, and providing general support. Assisting with performance management processes, including tracking performance evaluations and ensuring timely completion. Improving operations and processes with various stakeholders.

Skills: Business Administration · Human Resources Information Systems (HRIS) · Lean Six Sigma · Scripting · HR Management · Amazon Web Services (AWS) · Data Analysis · Data visulaization · Oracle Database · ADP Payroll

With a strong sense of ownership and a growth mindset, I have taken on 
various responsibilities that demonstrate my collaborative skills. I have 
leveraged JSON scripting and JavaScript to efficiently extract web data. 
Furthermore, my ability to design complex SQL queries has enabled me to 
extract valuable data from databases. Going beyond traditional methods, I 
have delivered insightful analyses of social media data using a combination 
of Excel and Python, providing valuable insights to inform decision-making. 

I have worked with MySQL Workbench, JSON Scripts, JIRA, GitHub, Zendesk. In developing queries for the testing of Datasets and large Datasets.With a strong sense of ownership and a growth mindset, I have taken on various responsibilities that demonstrate my collaborative skills. I have leveraged JSON scripting and JavaScript to efficiently extract web data. Furthermore, my ability to design complex SQL queries has enabled me to extract valuable data from databases. Going beyond traditional methods, I have delivered insightful analyses of social media data using a combination of Excel and Python, providing valuable insights to inform decision-making. I have worked with MySQL Workbench, JSON Scripts, JIRA, GitHub, Zendesk. In developing queries for the testing of Datasets and large Datasets.

Skills: Jira · JSON · HTML Scripting · JavaScript · SQL · MySQL · Oracle SQL Developer