Arpit  Data Analyst

SKILLS

• Google cloud Platform, Excel Skills, Informatica, Python, Statistical Analysis, Data Analysis, ETL, data science

EXPERIENCE

Senior Consultant                                                                                                                                                                                              Sep 2019 - Present

Confidential

 

Developed an automated interim billing solution for a telecom giant, streamlining inter-company billing for 42,000+ towers based on localized billing logic from Master Service Agreements. This initiative reduced billing errors and shortened the billing cycle by 30%. Leveraged Google Cloud Platform's services like BigQuery, Storage, Composer, and Airflow.

Implemented dynamic data visualization reports using Tableau, resulting in an increase in data-driven decision-making among stakeholders.

Implemented a Multi-Channel Attribution project for a Jewelry Giant, constructing a data pipeline and implementing a GCP-hosted Machine Learning model. This model, utilizing services like BigQuery, Vertex AI, Cloud Function, and Storage, empowered the client to evaluate marketing channel ROI effectively, leading to a 25% improvement in marketing efficiency. Additionally, informative dashboards were implemented, facilitating informed decisions by business users.

Orchestrated the integration of a data warehouse for one of the largest Investment Banks in Japan. Focused on migrating the current Client Relationship Management (CRM) from Dealmaker to Salesforce, providing enhanced capabilities to Bankers and the CAO for client management. Utilized Informatica to implement the data warehouse solution, resulting in a 40% improvement in data accessibility and reporting efficiency.

Software Development Engineer (Backend)                                                                                                                                            Sep 2018 - Sep 2019

Confidential

Transformed end user requirements into functional specifications and project plans.

Created ETL mappings and transformations using Informatica PowerCenter, increasing data processing efficiency. Implemented source and target definitions in PowerCenter-Designer, streamlining data flows and reducing data transfer time. Optimized mapping performance through expression editor enhancements and source data filtering.

Estimated effort for new business requirements, resulting in a reduction in project overruns.

Assisted cross-functional teams in system development, leading to a increase in overall business productivity. Conducted rigorous testing with SQL scripts, ensuring data integrity and reducing error rates by 40%.

Improved ETL performance, cutting loading times by through design optimizations.