Parul Jain

Data Analyst

Capital One•  January 2019 - Present

• Create a Python script to fetch metadata related to 600+ retail bank tables from Redshift and register it on Nebula platform. • Manage and update a Tableau-based dashboard for examining the health and quality of all retail bank tables every day. • Work alongside technical teams and bank users to resolve and aid in data-based issues and bugs on Jira. • Involved in data validation on large datasets to improve the data quality using SQL in Snowflake warehouse. • Provide assistance in properly tokenizing all sensitive personally identifiable user data.

IT Analyst

George Washington University•  October 2016 - December 2018

• Created reports on social projects under the Institute of Corporate Responsibility using advanced Microsoft Excel features like Vlookup and Pivot Tables. • Cleaned raw user data and processed it resulting in formatted and usable data using relational databases. • Developed, managed, and updated various websites and blogs under the Real Estate department. • Fixed bugs from existing websites; implemented enhancements and tracked all tasks to ensure a timely completion resulting in a cleaner look.

Business Analyst intern

Ignyte group•  August 2017 - May 2018

• Involved in creation of surveys and interviews for clients leading to functional and technical requirements gathering. • Assisted in writing business proposals to present to prospective clients resulting in 1 new federal client. • Performed research to improve digital marketing and Search Engine Optimization (SEO) for Ignyte website and Healthcare client CareClix. • Translated business requirements to technical/system requirements and communicated it to teams while adhering to an established timeline. • Provided a consultative approach with business users, asking questions to understand the business need and deriving analysis based on those needs.

Data Analyst

Centene Corporation•  May 2017 - August 2017

• Provided business insights by interpreting and analyzing large data sets through creation and development of conceptual, logical and physical data models. • Performed data mining for the application team and design team to assist with creation of an application. • Analysed and wrote SQL queries in the database environment to build bi-weekly reports. • Used R and Python to interpret relationships inside healthcare data and created visualizations to present to management. • Received fundamental understanding of Amazon Web services such as S3 and EC2. • Created various UML diagrams including Activity diagrams, Class diagrams, Object diagrams and Use cases etc.

Software Engineering Analyst

accenture•  June 2012 - June 2016

• Served as an analyst to create fully integrated user experiences with AT&T and Dell clients by providing digital and mobility strategies. • Led a team of 5 for the launch of iPhone 6 for AT&T by shortening the ecommerce buying process resulting in increased sales within 2 months. Received ‘Stellar performance’ award from client. • Directly collaborated with clients by giving periodic demos and showcasing solutions throughout all phases of SDLC while ensuring quality at every stage. • Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's) and QA teams. • Performed analysis, design, development and project testing with Unit Testing, Integration Testing and User Acceptance Testing. • Involved in drafting requirement documentations and aligning them with business, functional and technical requirements. • Interacted with project stakeholders to discover, define and categorize user flows, use cases and acceptance criteria thereby reducing post-launch bugs by 30%. • Created documentations for various products to be used for future training and delivery reference.