Pooja Bylaplar Jayanna

Senior Analyst| Data Integration Specialist

Enstoa•  March 2024 - Present•  New Jersey, USA

Led a server migration project, optimizing server configurations and collaborating with clients, third parties, and cross-functional teams; achieved a 30% reduction in server costs. Designed and implemented a scalable ETL pipeline using Adapters, enabling efficient extraction of data from eBuilder and SFTP, followed by transformation and loading into the SSMS data warehouse. Developed robust SQL stored procedures to parse JSON and XML data and efficiently upsert transformed data into the historical tables, improving data processing accuracy. Created dynamic Power BI dashboards to provide actionable insights on project schedules, budgets, processes, and funding for business leadership. Leveraged DAX queries for custom calculations and developed SQL report views tailored to business requirements for seamless data integration. Monitored daily integrations report and resolved errors, achieving 99% success rate in integration processes.

Lead Business Integration Analyst

Collins Aerospace•  July 2021 - August 2022•  Bangalore, India

Led a team of 3, delegated tasks and provided knowledge transfer on various business processes to bridge gaps. Ensured timely resolution and delivery of ServiceNow tickets within SLA timeframes. Performed exploratory data analysis (EDA) on airplane customer survey data using Python, resulting in actionable insights that increased customer satisfaction rate by 20%. Published dashboards onto Tableau Server, displaying part level enterprise sales data of 25,000 customers for further analysis by the Aftermarket Sales Operations team. Outlined, designed, and optimized SQL queries in Databricks, reducing query execution and data retrieval times by 50%.

Application Development Analyst

Accenture•  December 2019 - June 2021•  Bangalore, India

Constructed complex SQL queries in Snowflake to analyze promotion campaigns led by the marketing team and visualized results in Tableau. The campaign resulted in a 2.3% daily increase in sales and improved customer retention. Designed interactive Tableau dashboards to track monthly, quarterly, and yearly sales trends, facilitating real-time monitoring and strategic decision-making. Calculated customer churn rate and employed clustering algorithm to identify customer segments, targeting each segment differently that reduced churn rate from 22% to 18%. Extracted data from multiple sources and formulated pivot tables, macros, and VBA code in Excel to address business needs. Forecasted and planned seasonal product promotions using Python for statistical calculations, ensuring an optimal supply-to-demand ratio.

Application Development Associate

Accenture•  January 2018 - November 2019•  Bangalore, India

Gathered business requirements through continuous engagement with stakeholders, generated configuration Specification Documents(CSD) and Functional Specification Documents(FSD) for different continental regions. Delivered 6+ end to end project deliverables by collaborating with SAP cross functional and technical teams, in SAP ECC. Conducted multiple levels of testing including functional, integration and resolved defects raised by users during UAT and performance testing, thereby improving system performance by 80%.