Mayank Khanna Email & Phone Number

New York, Ny, Us

Norwalk, Connecticut, Us

Software Developer/Lead, FactSet Research Systems Inc., NYC Aug ’12 – PresentWorked for DataFeed Engineering• Designed, reviewed, implemented, and optimized data transformation processes using AWS Glue. Python, • Scraped, consolidated, validated, and cleansed data from vast range of sources including applications, databases, files, web services, websites and APIs• Analyzed business needs and collaborated with stakeholders to come up with efficient and optimized data feed solutions leading to significant improvements in data quality and availability• Improved performance of feeds by more than 50% using AWS Glue/ Apache SparkWorked for ETF Analytics Team (https://www.factset.com/analytics/etf_analytics)• Seamlessly handled the multi-million dollar acquisition/ integration of ETF.com backed operation to Factset • Supported FactSet ETF Analytics platform, involving data collection, integration and computation. • Handled all the data ingestion/ Analytics / Customer Feeds for ETF Analytics Team. Worked in Content Collection Services Engineering providing data collection solutions for FactSet Ownership database (https://www.factset.com/data/factset_data/ownership)• Rewrote legacy Visual FoxPro applications into C# desktop applications using WPF with MVVM Light, Log4Net and Entity Framework.• Improved Daily/Full Re-positioning process and reduced running time from 15 Hrs to around 3Hrs.• Worked closely with a wide array of stakeholders in planning and implementing areas of improvement in their workflow and applications to optimize analyst performance by over 30%.• Provided data collection solutions to stakeholders in numerous financial areas.• Lead a team of developers located in NYC, Philippines and India.

Verona, Wi, Us

Developed and maintained features in System Pulse, Epic's web based system monitoring tool designed for IT staff and system administrators’ at large health care providers. My responsibilities include:• Gathering requirements. • Performing technical analysis.• Designing, developing and testing software modules.Project 1: Custom Graph ControlThe main objective of this project was to create a custom chart control to replace existing System Pulse graphing capabilities and to reduce long-term development, testing and maintenance time.• Prepared a design document containing scope of changes, critical issue analysis and initial timelines to highlight how the use of this new control will enhance System Pulse graphing capabilities.• This web control is used to graph Cache Growth Monitor data, which helps health care providers to project the size of file systems and datasets for future time frames based on historical data and rate of growth.Project 2: System Pulse Diagnostic Features.The new System Pulse Diagnostics features were created to help troubleshoot situations where the data is missing from System Pulse and to make the application more robust.• Interacted with different internal teams to gather the requirements and prepared the design document. • Made extensive infrastructural changes at every level (Server code, Node Agent, Web App, Database) and added a user interface to display the information in a meaningful way.

New Brunswick, Nj, Us

Converted Unix Shell scripts to Perl

Bangalore, Karnataka, In

• Participated in the Current System Study for Zurich Financial Services and performed gap analysis.• Built financial reports for a core banking product (Finacle) projecting income statements, cash flows, balance sheets, and financial ratios using VBA. • Developed an application portfolio analysis tool using VC++ used for developing budgets and operating plan.

Mumbai, Maharashtra, In

• Worked with the product team of Network Custodian Services (NCS) for the Bank of New York.• Customized the NCS to handle data sent and received in various file formats (BACS, SWIFT, BNY Inform).• Customized the NCS to handle UK clearing.

Ms, Mathematics

Bachelor Of Science, Computer Science And Engineering

Intermediate, Science