Post Job Free

Resume

Sign in

Data Engineer

Location:
United States
Posted:
June 11, 2015

Contact this candidate

Resume:

HITHIKA CHHAOCHHARIA

E-mail: acp6gm@r.postjobfree.com Phone: 201-***-****

EXPERIENCE

Database Engineer, Standard & Poor’s CapitalIQ, New York Feb 2012-Present

Programming Experience : T-SQL, PL/PGSQL, C#, .Net, Powershell, XML

Worked on Microsoft SQL Server 2008 and gained extensive knowledge in RDBMS concepts and constructs and Database Objects creation such as Tables, Indexes, Stored Procedures, Views, Triggers, data integrity, SQL joins, query writing, User Defined Data Types, and User Defined Functions

Experienced in designing relational database according Normalization Forms along with Entity- model and application oriented design with strong Transact-SQL query writing skills (DDL, DML, and DCL)

Optimized performance existing stored procedures, functions to optimize queries for better performance - reducing run time of existing code by 87.73%, using techniques like index optimization, SQL server profiler and query execution plan

Re-engineered the DB codebase to dramatically improve performance and reduce the number of bugs in the code that greatly enhanced the view that our clients have of the overall quality of our data

Hands on experience in designing, installing, creating, and maintaining of databases, backup and recovery, optimization and setting up replication between data servers.

Leading the Campus Recruiting team in the hiring and training process of college hires

Strong analytical and problem solving skills coupled with interpersonal and leadership skills.

Key Projects and Responsibilities:

BECRS – Business Entity Cross Reference Services

This service links standardized and proprietary IDs for over 2 million entities to the primary key S&P Capital IQ Company ID

The project involved maintaining entity linkages which were iteratively mapped and successive changes handled in a multi-link fashion while ensuring reliability and consistency. Establishing well-defined data ingestion rules, daily data reviews and ongoing metric reports ensured strict data quality governance and controls

My role was to create a dynamic framework for market data ingestion and testing that included ETL workflow and procedures, file management, error control, and auditing of data from vendors like CMA Entity ID, GVKey, Markit RED Code using T-SQL

GICRS – Global Instrument Cross Reference Services

This service constitutes a comprehensive database of security identifiers cross-referencing almost 3 million issues from over 200 exchanges. It is based on a global securities database and covers most types of equity and debt instruments

The project involved consuming data from multiple vendors with different file formats and standardizing the data through our linking logic which gives 360-degree view of security to entity and corporate hierarchy links in markets throughout the world

Interacted with stakeholders to gather out the requirements and transform complex business logic into database design and test products during the SDLC phase

These services are real-time and are utilized by Investment banks, Hedge funds and traders worldwide which makes it critical to ensure efficiency of the processes and maintain data integrity at all times

Software Engineering Intern, Treo Solutions, Troy, New York May 2011 - August 2011

Created test benches in SQL and XML for client data on the Data Quality Assurance Team

Assisted with the warehousing process to sanitize, transform, and catalogue data for data mining, online analytical processing, market research and decision support and to create predictive models for payers and providers in the health-care industry

Developed macros and stored procedures for the central server system which was used to publish results, and generate reports that were stored in a data dictionary

Teaching Assistant, Rensselaer Polytechnic Institute Jan 2011-Dec 2011

Worked as a TA for the Physics and Mathematics Department which gave me an opportunity to think on my feet, stimulate interest, answer questions, and conduct lectures for undergrad students

EDUCATION

Master of Science in Information Technology Aug 2010 - Dec 2011

Rensselaer Polytechnic Institute, Troy, NY

Bachelor of Technology in Instrumentation and Control Engineering Aug 2006- May 2010

Jawaharlal Nehru Technological University, India



Contact this candidate