Post Job Free

Resume

Sign in

Data Analyst

Location:
Jersey City, NJ
Posted:
December 29, 2023

Contact this candidate

Resume:

SHWETA WAKNIS E-mail : ad2bds@r.postjobfree.com

LinkedIn. : www.linkedin.com/in/shweta-waknis-312b9922a Phone : +1-347-***-****

PROFESSIONAL SUMMARY

Around 8 years of rich experience in Information Technology in Process Audit, Quality Analyst, Scrum Master and Business Analysis and Data Analytics by statistically analysing projects data and evaluating projects performance quantitatively using Metrics Measurement and Process Performance Models.

SKILLS

Data Analysis Data Mining, Data Visualization

Analytical Tools & Programming R, Python, Tableau, Crystal Report Project Life Cycle Methodology SDLC, Agile, Scrum

Version Control VSS, SVN, Git

Cloud Service AWS (s3, Dynamodb,CloudWatch), Snowflake-SQL Microsoft Office MS Excel, MS Word, MS Project, MS Power Point EDUCATION

Rutgers Business School, New Jersey Jan 2020

Master of Information Technology and Analytics

ICFAI University, India Mar 2013

Post Graduation Diploma, Quality Management

S.N.D.T University, India May 2005

B.Tech, Computer Science and Technology

Certification – Certified ScrumMaster (CSM) July 2023 PROFESSIONAL EXPERIENCE

Cognizant, Data Analyst (New Jersey, USA Remote) Jan 2021 – March 2023

• Participate/Conduct daily standup Scrum meetings, retrospective meeting, backlog grooming and provide the project updates on project stories

• Used Azure Devops board to create stories and bugs to track sprint

• Coordinated with Product Owner and Technical Lead for tech debt features and backlog stories

• Facilitated the close out meeting for objects in order to receive sign off from Solution Lead and Technical Lead.

• Coordinated with Quality team and data engineer team for clearing out any backlogs for QA testing.

• Created ETL mapping document for the data pipelines based on requirement received from solution lead in MS Excel.

• Analyzed the business requirement for source to target mapping document for better ETL process and deriving transformation logic

• Translate requirements received in form of mapping documents into technical specification and develop the pipeline for client’s framework.

• Create/update Technical and Functional Specification, Runbook in confluence

• Execute the test scenarios and present the findings to Engineer Manager and Solution Lead.

• Performed in-depth data validation for different objects using test cases and documented the test results in confluence. Performed analysis for failed test cases.

• Written and executed united test cases, integration test cases

• Developed reports to analyse the percentage of data populated for the attributes in each data object.

• Using snowflake queried and identified the grief records, verified the pipeline status, statistics and records present in the objects.

• Worked with data in all 3 environments - DEV, QA and PROD and evaluated the data using Snowflake, AWS cloud watch and MS Excel ( Pivot, Vlookup and other advance features) to analyze the data for documenting final results.

• Implemented CI/CD pipeline using Git code repository and Azure DevOps and monitored the build status of objects

• Worked on Production Data Readiness, Data Completeness to validate that no data is missing from the object, verified the statistics for each pipeline using PLM and snowflake, identified if grief is accounted for or whether it requires bug and raised a bug if discrepancy was found.

• Collected data from multiple sources (Snowflake, MS Excel, AWS) for analysis purpose and did the root cause analysis for grief records and prepared detailed report for same to present the team leads.

Environment: Python 3.7, PyCharm, AWS, Snowflake-SQL, MS Excel, Git, Azure DevOps, SharePoint, Collibra, Atlassian-Confluence, Scrum in Azure Devops, ServiceNow, MS PowerPoint Nomura Securities International, Inc, Intern, New York USA June 2019 – Aug 2019

• Developed sales reports using Crystal reports

• Developed weekly and monthly financial reports in Tableau for the traders to analyze

• Developed Tableau dashboard and prepared ad-Hoc reporting for business users

• Converted existing reports to tableau dashboard for management and users to visualize the data

• Presented findings & recommendations in a simple, clear way to drive action

• Used Pandas, NumPy, SciPy, Matplotlib, Scikit-learn in Python for developing time series model to predict the sales revenue of sales department. Model developed using Time Series Forecasting - ARIMA model was used for predicting the future sales revenue

Environment: Python, Tableau, Crystal Reports, MS Excel, MS Word, Confluence, SQL, MS Powerpoint Polaris Financial Technology Ltd, IT Consultant, Mumbai India Apr 2012 – Nov 2012

• Served as focal point for CMMI Level 5 v1.3 initiatives

• Conducted Process Audits for five different projects to identify Process gaps and worked on creating Performance Model. TCS (formerly CMC Limited (TATA Enterprise)), IT Engineer, Mumbai India Nov 2006 - Apr 2012

• Worked onsite at Bombay Stock Exchange as a business analyst, to support the implemention of the Equity trading application (BOLT) developed by CMC

• Coordinated closely with all management levels to develop various reports

• Conducted Functional testing and supported UAT, also created test cases

• Conducted Quality Control and Quality Assurance activities

• Created Requirements Traceability Matrix(RTM) to map the requirements, design and test cases to the project goals and objectives

• Participated in Causal Analysis & Resolution meeting for identifying defects severity and root cause analysis.

• Worked as an Assessment Team Member (ATM) to implement PCMM(People Capability Maturity Model) Level 3 (v 2.0)

• Worked on SCAMPI B & SCAMPI A implementation CMMI Level 5 v1.2 at organizational level

• Evaluated projects performance quantitatively using Metrics Measurement and Process Performance Models (Scheduled Slippage, Defect Density, Causal Analysis & Resolution)

• Performed Software Quality Assurance testing of softwares before the production implementation

• Analysed and created action plan of Metrics & Customer Satisfaction Index



Contact this candidate