Project Manager Data

RITU PALOD

Irvine, CA 857-***-**** ****.*****@*****.*** www.linkedin.com/in/ritupalod/

Information Systems masters from Northeastern University with prior 6 years of extensive experience generating BI reports while working as Senior Business Intelligence Analyst. Proficient in statistical data analysis to comprehend trends for business solutions. Looking to leverage my knowledge and experience into a responsible role in an organization.

WORK EXPERIENCE

Intern-Business and Reporting Analyst, Dassault Systemes, MA, USA Jan 2017 – Jul 2017

Developed the project plan and created process flow diagrams for automating data tracking and reporting system.

Designed and developed Data Visualization 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, queried and stored it in spreadsheets for further analysis.

Performed troubleshooting and implemented necessary changes in existing reports.

Created dynamic dashboards (evaluating success/failure rate of reaching targets, skill assessment) using Tableau Desktop.

Compiled and distributed ad-hoc data requests to business owners and customers using Google Analytics.

Project Manager, TCS, INDIA Oct 2012 – Mar 2014

Managed a team of 6 members & achieved 12.5% cost reduction by performing SWOT analysis for a healthcare company.

Developed project scope and worked with business stakeholders to gather the requirements, determine the product desired, and steps to achieve it following SDLC.

Prepared budget, journal entries, profit and loss statements, balance sheets, expense and revenue sheets in MS Excel.

Performed break-even analysis supporting business by providing detailed analysis (highlighting KPIs) to the management.

Facilitated daily scrum meetings discussing individual tasks and resolving issues if any arise to achieve it.

Monitored and tracked project progress & key milestones using burndown charts while reviewing and revising the existing sprint as and when required.

Developed plans to mitigate risks and deviations for timely deliveries and resolved conflicts if any.

Scheduled sprint retrospective to identify opportunities for improvement, discuss tasks pending and ways to achieve it.

Senior Business Intelligence and Data Analyst, TCS, INDIA Dec 2008 – Sep 2012

Lead a team of 5 members and using Agile methodology accomplished data migration in MSSQL of 1446 bank branches through PeopleSoft CRM to CBS (Core Banking Solutions).

Developed functional specifications and ER Diagrams for the business processes & designed workflows for same.

Performed data cleansing for ETL deployment by Talend, and used the transformed data for further 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.

EDUCATION

Northeastern University, Boston, MA

Master of Science in Information Systems

GPA - 3.5

Sep 2015 - Dec 2017

PT. Ravi Shankar Shukla University, INDIA

Bachelor of Engineering in Computer Science

GPA - 3.3

Aug 2004 - Jul 2008

TECHNICAL SKILLS

Database language

PL/SQL, MySQL, MSSQL

Data Modeler

Toad, MySQL workbench, ER/Studio

Data Integration Tools

Talend, SSIS

Data Reporting & Analytical Tools

SSRS, SSAS

BI and Visualization Tools

Tableau, Qlik Sense, Qlik View, Power Pivot, Power BI, Power Query, Power Map

Statistical Computing Languages

R, Python

Accounting Tools

QuickBooks, MS Project, MS Excel

Web Designing Languages

Java, JavaScript, HTML5, CSS3, PHP, Bootstrap 3, jQuery

Contact this candidate