EXPERIENCE SUMMARY

Motivated Intern with good knowledge in T-SQL, Python and Microsoft Office. Eager

to apply learned competencies in practical, business setting. Passionate volunteer

prepared to contribute to organizational success while developing new skills.

Excellent communication and interpersonal skills.

Strong analytical knowledge in terms of analyzing data

Expertise in developing complex SQL queries to validate ETL processes

Good knowledge in REST/SOAP API Testing

Experience in writing SQL queries for databases like SQL Server(T-SQL)

Good knowledge in SQL Server Integration and Reporting Services using SQL Server 2012/2017.

Experience in Transforming data using SSIS Transformations like Conditional Split, Merge.

Experience in creating Jobs and Scheduled SSIS Packages.

TECHINCAL SKILLS

Testing Tools

Postman, SOAP UI, HP ALM, Microsoft TFS, JIRA

Reporting Tools

MS SQL Server Reporting Services 2014/17

ETL Tools

MS SQL Server Integration Services (SSIS)

Database

MS SQL Server, MySQL

DB Tools

SQL Server Management Studio, Microsoft Visual Studio, TOAD, SQLite, SQL Developer

Programming Language

Python

Methodology and Tools

Agile, Waterfall, Iterative, JIRA

EDUCATIONAL QUALIFICATION and ACHIEVEMENTS

Master in Science in Physics, Sambalpur University, 2009

TRAINING:

Python coding bootcamp by iNeurons

PROFFESSIONAL EXPERIENCE:

DD Foundation, Minneapolis Sept 2020 – Feb 2021

Business Analyst, Intern

As an intern for DD Foundation, I had a unique opportunity to work on a diversified skill set and roles

●Worked with client requirements to specify business plans and goals.

●Demonstrated skills in interviewing business and technical leaders to gather and clarify business requirements.

●Created test cases under the guidance of senior analyst.

●Worked closely with the web development team in monitoring the execution of the client needs.

●Prioritized the project roadmap using MS Excel for the team.

●Assisted in hosting the web portal in AWS.

Tools Used: MS Excel, MS Word, MS Powerpoint, Wordpress

STEM Builder LLC, Minneapolis Jun 2018 – Dec 2019

Technical Associate

As a Technical Associate for STEM BUILDER’s Learning Management System (LMS), I had a unique opportunity to work on a diversified skill set and role -

Technical Specification Analysis

Test cases/scenarios creation and execute using Postman, SOAP UI, HP ALM

Test data creation

Test Execution for both data load and data transfer jobs

Defect logging and tracking using HP ALM, Microsoft TFS, JIRA

Manual System & Unit Testing

REST API Testing using Postman

Regression Testing

Participate in Software Engineering process and methodologies like Agile, Waterfall

Data Analysis of Enrollment, Revenue, Churn

Data Extraction, Transformation, Load to LMS from various sources through CSV

Data Migration and profiling from various internal databases to the centralized LMS database

Tools Used: Postman, MS SQL Studio, T-SQL, SSIS, SSRS, SQL, Tableau

Bootcamp Capstone Projects

Project 1:

Summary: Data Analysis of a meal delivery app, SpeedySpoon

Responsibility:

•Analyzing the business usecase and writing SQL queries for

•Daily Count of orders placed

•Daily Sum Conclusion -money SpeedySpoon made from orders each day

•Product Sum Conclusion

•Product Grouping Conclusion

Technology Used: SQL and SQLite

Project 2:

Summary: KPI (Key Performance Indicator) Analysis of a Video Game company, MineBlock

Responsibility:

Report generation based on KPIs like

Daily Revenue,

Daily Active Users,

ARPU,

Retention

Technology Used: SQL and SQLite

Project 3: Quarterly Statement Frequency

Summary: Improved the existing process of account statement generation by reducing it from

monthly to quarterly. The main aim was to achieve sustainability goals of the bank by reducing the use of

papers for statement printing by digitalizing it as much as possible.

Responsibility:

•Analyzed 1 million savings customers data by extracting data from relational database.

•Proper EDA, Data Cleansing, Visualization

•Savings estimation of about 2 million euros per year

Technology Used: Python 3, Pandas, NumPy, Matplotlib, Seaborn Excel

Project 4: COVID-19 Data Analysis

Summary: Ongoing project part of VIRTUAL COVID 19 Open-Source Community Collaboration

Challenge https://www.meetup.com/applied_ai/events/269502562/

Technology Used: Tableau

Volunteering Activities:

Hindu Society of Minnesota

Assistant manager

●Assisting the manager in organizing, planning and implementing strategy.

●Coordinating temple operations.

●Ensuring temple schedules and objectives are met by employees.

●Monitoring and maintaining the inventory.

●Create reports, analyze and interpret data, like revenues, expenses and other miscellaneous expenditures.

●Maintaining paychecks and evaluating employee performances.

SEWA AIFW, Minneapolis

Volunteer

●Helping with their annual and monthly welfare programs.

●Actively participated in the vaccination drive by SEWA in association with Minnesota Department of Health and Hennepin County Health Department.

●Participated in many family and senior living assistance programs.

OSA Health and Wellness Group,USA

COVID Volunteer

●Recently joined the OSA HW, USA group to research the needs of the people in India, on the ground and assure timely reach of the urgent life-saving needs.

●Assisting in creating fundraisers, migrant assistance, Oxygen shelters and arranging Doctor consultations.

Contact this candidate