Priyanka Manchanda Manchanda

• Provided support during internal audits by promptly supplying requested information as needed.
• Optimized company-wide reporting processes by identifying inefficiencies and suggesting improvements.
• Participated in regular training sessions for Life cycle of trade, Equities, Hedge and FID to stay current on industry trends, improving personal expertise and job performance.

Key Projects:

• Use of Modern Technology: Data migration from DB2 servers to Snowflake

Demonstrated strong technical and analytical skills by mapping business and logical layer of Order Flow data from DB2 to Snowflake. This included use of SAP technologies: Information Design Tool to rewrite universe and BOXI to change the underlying queries of the reports using the universe. Created server links and optimized SQL queries on Snowflake to improve data retrieval speed. The project assisted with data optimization and cost efficiency across reporting teams and business.

• Upgrade Corporate Coverage Systems from Ant to Gradle

Analyzed and implemented system upgrades to Gradle which facilitates time sensitive report delivery to clients summarizing the purchase and sells by end of day. The system is based on GITHUB, JAVA8 and WEBFARM to support the GUI build which operation teams use to generate reports on adhoc basis, enhancing self service experience.

• Managed the collection and synthesis of large datasets from various sources, ensuring accuracy in subsequent analyses performed.
• Delivered actionable insights to clients with comprehensive reports, leading to improved business strategies.
• Improved internal knowledge sharing practices, documenting project methodologies and lessons learned for future reference.

Key Projects:

Reconciliation between Front Office and Trade Completion office

Analyzing data between 2 different sources of market data for NY region and identifying reason using data models in VISIO to ensure the correct number reported by organization to exchange. This exercise assisted Business Users to report correct numbers for different kind of stocks like equities, swaps and hedge.

Creating Reports using SAP Tool BOXI

Provided reporting for analysis about the active clients trading for various accommodates and year-end analysis for each client to correctly report allocation data for audit purposes.