Ritu Palod
Summary
I am an Information Systems masters from Northeastern University with prior 6 years of extensive experience creating Business Intelligence solutions while working as Senior Business Intelligence Analyst. Proficient in SQL for complex data retrieval and Python/R for statistical data analysis to comprehend trends for business solutions on large datasets.
Education
Northeastern University 
Boston, MA
| Master of Science in Information Systems |
 2015 - 2017 \ 2 yr |
Coursework:
- Data Warehousing and Business Intelligence (Tableau, Qlik Sense, Power BI, Talend)
- Database Management Systems (PL/SQL, MySQL)
- Engineering of Big Data (Hadoop, Hive, Python, Map-Reduce)
- Advance Data Science (R / Python)
- Economic Decision Making
- Engineering Project Management
- Account/Budgets for Engineers
- Application Engineering and Development (Java)
- Web Design/User Experience Engineering (CSS, HTML, PHP, jQuery, AngularJS)
Pt. Ravishankar Shukla University Durg, India
| Bachelor of Engineering in Computer Science and Engineering |
2004 -2008 \ 4 yr |
Work Experience
True Fit Corporation Boston,MA, USA
| Business Intelligence and Data Analyst |
May 2018 - Apr 2020 / 1 yr 11 mos |
*True Fit Corporation is a multinational Fashion technology (IT) service, consulting and business solutions company headquartered in Boston, Massachussetts.
- Designed interactive, responsive and insightful dashboards using Tableau for analytical reporting to C-Level executives.
- Translated business requirements into technical specifications, built KPIs resulting in million-dollar sales increase.
- Strategized user base behavior and provided conversion-rate optimization based on new, returning, and instant users’ profile.
- Conducted sales and returns analysis that reduced returns rate by 55% post True-Fit incorporation on the retailer’s site.
- Performed BI Maintenance tasks, resolve data anomalies and ensure data consistency in existing and new reports.
- Scrum master: Identified opportunities for improvement, discuss pending tasks, resolve conflicts and develop plans to mitigate
risks and deviations to ensure timely deliverables.
- Created a knowledge base BI wiki to document the data warehouse architecture, ongoing reports, and metrics.
- Created data warehouse cleaning routines and actively maintained loading of PostgreSQL tables and views in ETL pipeline.
Dassault Systèmes Waltham, MA, USA
| Business Intelligence and Reporting Analyst Intern |
Jan 2017- July 2017 \ 7 mos |
Dassault Systèmes is a European multinational company headquartered in Vélizy-Villacoublay, France that develops 3D design, 3D digital mock-up, and product lifecycle management (PLM) software used by brands like Boeing, BMW, IBM and Google.
- Developed the project plan and created process flow diagrams for automating data tracking and reporting system.
- Designed and developed BI solutions to extract data from multiple sources, transformed and generated trend analysis reports (charts, graphs and
tables) using Power BI and Tableau measuring project progress through KPIs.
- Migrated data into relational database MySQL, and setup both ad-hoc as well as standard reporting via SSRS.
- Created dynamic dashboards (evaluating success/failure rate of reaching targets, skill assessment) using Tableau Desktop.
Northeastern University Boston, MA, USA
| Graduate Teaching Assistant |
May 2016 - Aug 2016 / 4 mos |
Northeastern University is a private research university in Boston, Massachusetts, established in 1898. It is categorized as an R1 institution (Doctoral Universities: Highest Research Activity) by the Carnegie Classification of Institutions of Higher Education.
- Mentored 40 students in designing SSIS, SSRS and SSAS packages to develop OLAP cubes for analytical reporting.
- Guided students to identify trends using data analysis in python, R and visualize them using Tableau, Power BI, Qlik View.
- Helped students in gathering, analyzing, and determining data requirements in support of the Business Intelligence, including overall coordination of the BI platform, interface, and back-end databases.
- Assisted students in preparing detailed specifications for database/BI proposals to design, code, test, debug, document, and maintain database entities.
Tata Consultancy Services Pune, India
| Business Intelligence and Data Analyst |
Dec 2008 - Sep 2012 / 3 yr 10 mos |
Tata Consultancy Services Limited (TCS) is an Indian multinational information technology (IT) service, consulting and business solutions company headquartered in Mumbai, Maharashtra. It is a subsidiary of the Tata Group and operates in 46 countries.
- Lead a team of 5 members using agile methodology for data migration in MSSQL of 1446 bank branches through PeopleSoft CRM to CBS (Core Banking Solutions).
- Developed functional specifications, ER diagrams and designed workflows for the business processes.
- Performed data cleansing with R for ETL deployment by SSIS, and used the transformed data for forecasting analysis.
- Created complex integration services packages from an OLTP database to generate reports and OLAP cubes using SSDT.
- Performed QA validation in compliance with its functional, performance and system integrity.
- Created monthly, quarterly and yearly reporting metrics, interactive and drill-down dashboards for managers.
- Prepared presentation, documents & training content for the customers and conducted workshops to enable them on it.
Skills
| TECHNOLOGY |
Languages, Software and Frameworks |
| DATABASE |
PL/SQL, MySQL, MSSQL |
| MODELER |
Toad, MySQL Workbench, ER/Studio |
| INTEGRATION |
Talend, SSIS |
| REPORTING & ANALYTICAL |
SSRS, SSAS |
| BI &¬ VISUALIZATION |
Tableau, Qlik Sense, Qlik View, Power Pivot, Power BI, Power Query, Power Map |
| LANGUAGES |
R, Python, JavaScript, Java, Git |
| ACCOUNTING |
QuickBooks, MS Project, MS Visio, MS Excel |
| WEB |
HTML, CSS, PHP, Bootstrap, jQuery, AngularJS, SpringMVC |