Arpita Jain

Data Analyst

PreScouter•  March 2020 - Present

• Collected, cleansed and provided modeling and analysis of structured and unstructured data used for major business initiatives. • Utilized SQL, Tableau and Power BI for data intelligence and analysis. • Collaborate with potential International vendors and understand their product needs and requirements and provide detailed presentation to the client. • Utilized EXCEL functionality to gather, compile and analyze data from PIVOT tables and created graphs/charts. • Administration support and supervision of a team of 3 analysts. • Strong communication and information gathering ability, interpersonal and team building skills. • Able to prioritize, multi-task and make sound decisions in a timely manner.

Business Analyst

Tata Consultancy Services Ltd•  March 2016 - October 2017

• Proficient in eliciting business needs/gathering requirements from stakeholders. • Supervised a team conducting responsibilities from Business Analysis, Development, Design, testing (QA and UAT), Implementation, Risk Assessment, Documentation and Deployment. • Involved in the estimate planning, design discussions, problem analysis and SCRUM meetings(AGILE) for the project. • Improved SQL query writing in order to work with large volumes of data. • Negotiated and liaised between business teams, technology teams, and support teams. • Analyzed customer needs and converted requirements into user stories in JIRA. • Performed discussions with vendor/partner teams to reinforce and document processes for on-going growth or any system impacts. • Collaborated with SMEs, product owners, business stakeholders, solution architects and other cross-functional resources to get desired Business Value.

IT Analyst

Tata Consultancy Services Ltd•  December 2015 - March 2016

• Managed deliverables for team, submitting Estimations and preparing schedule for the same. • Extensive experience attending the Project Review meetings with gathering requirements. • Supported in transitioning the requirements and design to offshore for the build activity. • Developed ETL jobs in OPC scheduler for loading and unloading data into and from the tables. • Responsible for creation of system test plans & logical test cases. • Acted as a change process lead during implementations coordinating with multiple parties. • Administered handling & mentoring team of 8-9 application designers and developers. • Designed the database changes and liaising with DBA for implementation. • Acted as test coordinator during end to end chain tests including cross platforms projects.

Mainframe Developer

Tata Consultancy Services Ltd•  October 2012 - December 2015

• Responsible for translation of technical documents into executable code in COBOL. • Conducted Unit testing, functional, integration and regression testing. • Handled the incidents, problems and change requests. • Performed impact analysis and provide solutions to user’s change requests. • Hands on experience in creating tables and stored procedures. • Maintained COBOL Quality while developing COBOL modules and sharing ideas with the team.