Manasvi Pipariya

• Contributed to internal activities for overall process improvements, efficiencies and ELT innovation.
• Communicated new or updated data requirements to global team.
• Designed and implemented effective database solutions and models to store and retrieve data.
• Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
• Collaborated on ETL / ELT tasks, maintaining data integrity and verifying pipeline stability and data quality.
• Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
• Explained data results and discussed how best to use data to support project objectives.
• Built databases and table structures for web applications and business Intelligence.
• Developed, implemented and maintained data analytics protocols, standards, and documentation and trainings.
• Analyzed large datasets to identify trends and patterns in customer behaviors.
• Optimized data transformation and model processing rules to enhance data quality through design and development phases.
• Drafted technical documentation for internal business areas and processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
• Determined data storage and optimization policies, shaping organization efforts to enhance performance and minimize costs.
• Served as subject matter expert in areas such as MIB , Inventory and other analytical projects.
• Optimized data access and storage to improve performance of analytics systems.
• Created data models to support decision-making processes.
• Collaborated and developed data pipelines to acquire, clean and processed high quality data.
• Collaborated with stakeholders to identify business needs and data sources.
• Analyzed data to identify root causes of problems and recommend corrective actions.
• Generated standard and custom reports and Dashboards on Snowflake and Tableau to provide insights into business performance.
• Deployed predictive analytics models to forecast future trends..
• Identified patterns and trends in large data sets and provided actionable insights.
• Maintain Git repository and supporting teams to collaborate in merging the dbt models with optimization , enforcing data test and code linting to increase code readability.

• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
• Prepared written summaries to accompany results and maintain documentation.
• Monitored incoming data analytics requests and distributed results to support ETL strategies.

• Coordinated with other engineers to evaluate and improve software and hardware interfaces.
• Worked with software development and testing team members to design and develop robust solutions to meet client requirements.

Web Scrapping of Course details through various platforms.

• Web Scrapping- Details and Information of certification courses displayed on the webpage from various online learning platforms provided by client for marketing analysis through API and graphQL using requests lib.
• Storing scraped data into firebase and as a Json file on daily basis.

Telecom Data Sentimental Analysis using Python:

• youtube comments scrapping for Reliance Jio Network using Selenium Google chrome for NPL text processing.
• Scrapping all comments on videos from Reliance Jio’s YouTube channel playlist.
• Cleaning of fetched data for sentimental analysis using beautiful soup, and processed the batch data using Pandas dataframe and JSON for further processing.

Telecom Data Analysis:

Hadoop Developer

• Consumer related and business prospect identification service for Vodafone-Idea.
• Device assessment and customer complaints data which is used for decision making like optimization and booster installation
• Customer profiling based on usage and number of connections using Pig and Hive.
• Customer data which is generated daily must be dumped into customer database. Data is fed with constant data from devices with different parameters daily. After which the resulted data is stored in the clients required location.

Ecommerce Web Data - Online Shopping Portal:

Hadoop Developer

• Worked on Importing RDBMS data using HIVE as SQL like interface to store data into HDFS for zovi.com.
• Used MapReduce tool for processing the data and performing computations.
• For pre-processing of customers and order datasets from HDFS using Apache Pig and clean data is then fed into HIVE .
• Experience in ETL for importing data relational data, used SQOOP to import/export data from DB2.

Client Name- Google

• Performed quality assurance checks on transactions and account actions to assess compliance with state and federal regulations.
• Performed data entry operations to update database with customer responses.
• Offered advice and assistance to customers, paying attention to special needs or wants.
• Responded to customer requests for products, services, and company information for Google.
• Updated account information to maintain customer records.
• Clarified customer issues and determined root cause of problems to resolve product or service complaints.
• Tracked customer service cases and updated service software with customer information.

• Answered constant flow of customer calls with minimal wait times.
• Responded to customer requests for HP and canon printers
• Maintained customer satisfaction with forward-thinking strategies focused on addressing customer needs and resolving concerns.
• Assisted customers in identifying issues and explained solutions to restore service and functionality.
• Identified potential sales and cross-selling opportunities and informed supervisor.