SANYA KHURANA

**** **** *.******* **** Apt.****, Jersey City, New Jersey 07306

443-***-**** adcu71@r.postjobfree.com www.linkedin.com/in/Sanya-Khurana PROFESSIONAL SUMMARY

Extensive experience in Analysis, Design, Development, and Implementation of Big Data and Business Intelli- gence based applications.

Hands on experience in Data ingestion and curation for Data Lake using Hadoop, HDFS, Hive, Spark SQL, Impala, Drools .

In-depth knowledge of data mapping, warehousing tools like Informatica.

Developed skills through project experience on databases such as Oracle 11G, SQl Server,Teradata.

Practical understanding of the Data modeling (Dimensional and Relational) concepts like Star-Schema, Snow

ake Schema, fact and dimension tables, logical and physical data modeling

Experience of working in Agile framework, involved in Sprint planning and Story writing.

Ability to work collaboratively and understanding of business requirements and system architecture.

Have been mentoring the new hired employees and interns in team to ensure the seamless succession and uninterrupted work

ow.

WORK EXPERIENCE AND PROJECTS

Morgan Stanley (Wealth Management Division) Oct 2018 - Dec 2019 Associate New York City, US

Project: Solium Integration and Reinvestment- Worked on the ingestion, curation and distribution of stock plan data from diverse sources into Hadoop, Teradata and Greenplum. Worked in Agile framework with two week sprints in Wealth Management Data Integration and Data Quality Squad.Also worked on the proof of concepts for data ingestion in HDFS using Kafka. Infosys Limited(Client: Care rst Bluecross Blueshield) September 2017 { Oct 2018 ETL/Informatica Technical Lead Owings Mills, MD, US Project:Broker Hub- In order to provide the functionality of ad hoc and scheduled reporting to CareFirst BlueCross Blue Shield, a centralized Data Mart is built to gather data from di erent systems like TIBCO, MEIDS, SALESFORCE, BPODS, FACETS.Worked as an ETL lead in assisting a large team at o shore and coordinating with the business team for functional requirements. Infosys Limited(Client: DC Health Bene t Exchange) June 2015 { August 2017 Senior Systems Engineer Chandigarh, India

Project:District of Columbia Access System- Created a centralized Data Mart to replace the legacy ACEDS system with a modern,

exible platform for automated eligibility determinations and ongoing case management for DC HealthCare System. Worked as an ETL Developer and involved in complete analysis of IBM CURAM database for preparing the STM documents,data modelling, reporting and performance tuning Infosys Limited(Client: Lexis Nexis) September 2013 { May 2015 Systems Engineer Pune, India

Project:Case Law Modernization- Worked on XML to XML conversions for online display of documents in Lexis Advance format for LexisNexis data warehouse which provides access to billions of searchable caselaw documents through websites lexis.com and Lexis Advance. SKILLS

Programming Language C++, Java

Operating System UNIX,Windows

Databases Oracle, SQL Server,Teradata

Tools and Technologies Hadoop Eco-system (Hive,HDFS,Impala,Spark SQL,Drools), Informatica Power Center 10.2.0,WinSCP,SQL Developer,Microstrategy. EDUCATION

Panjab University Chandigarh, India 2013

Master of Computer Applications GPA 7.91/10

Panjab University Chandigarh, India 2010

Bachelor of Computer Applications GPA 8.13/10

AWARDS

Won First Prize at Morgan Stanley Wealth Management People Engagement Program in 2019.

Infosys Chandigarh DC Champion award 2016 and STAR AWARD 2015 for outstanding performance.

Contact this candidate