Summary
Overview
Work History
Education
Skills
Timeline
Generic

Priya Vangeepuram

Scarsdale,NY

Summary

Highly focused on Reports and Database development. Adept at working in all stages of software development including requirements definition, design, development, testing and support. Ability to handle multiple tasks, be adaptable and self-motivated, team player with strong problem solving and analytical skills Technical skills MS SQL, MY Sql, Postgres SQL, SSIS, SSRS, Crystal Reports, DB2, Oracle, Hadoop, Impala, Hive, Eagle Investment System, Longview Trading, MS Access, Excel VBA Core Qualifications Strong SQL Query experience. Strong expertise in Reports development using SSRS, Crystal Report, Eagle Pace & Longview Trading. Good knowledge with ETL process using SSIS. Ability to function independently with little to no Supervision.

Overview

16
16
years of professional experience

Work History

Key developer

  • Responsible for providing full support of application – CaseAware
  • Responsible for design and development of reports based on adhoc requests raised by business users
  • Implemented several built-in excel functions and formulas
  • Developed and maintained Access Application for data retrieval
  • Previous method was taking Excel workbooks, translating to MS Access database, then exporting to SQL database
  • Collaborate with all levels of management users to elicit requirements and translate to technical specifications used by reports development team.

Data & Reporting Analyst SQL

Charter Communication
Stamford, CT
01.2022 - Current
  • Developed advanced sql queries and stored procedures to generate reports
  • Enhanced the Specialty Accounts audit process, by ingesting the data from Business Intelligence, and Billing System data in Oracle and DB2
  • Pulled data across multiple database servers (Oracle, DB2), Linked database objects (linked server, db links)
  • Built extract, transform and load from multiple types of data source (SQL Server, Oracle, DB2,Excel & Flat File) to destination database server
  • Rebuilding Indexes and Tables as part of Performance Tuning Exercise
  • Created, maintained stored procedures, SSIS package, Agent job setting to ensure they are applied with new rules.

Database developer

JIRA | Atria Wealth
New York, NY
08.2020 - 11.2021
  • Provide database coding to support UNIO
  • Build and maintain SQL scripts, for data analysis and extraction
  • Developed VBA code and using macros and formulas to speed processes and maximize accuracy
  • Assist client managers with development of client work orders
  • Involved in DATA validation by writing SQL queries and Involved in back-end testing

Database Developer

Leopold Associates
Armonk, NY
02.2017 - 04.2020

Consultant, SQL/SSRS

W.R.Berkley Corp
Stamford, CT
01.2016 - 10.2016
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets
  • Migrated SSRS reports from Informix to SQL Server
  • Prepared complete data mapping and report definitions for the project.

Database developer, SQL/SSRS/Crystal Reports Developer

Geneva | Shenkman Capital
Stamford, CT
04.2014 - 10.2015
  • Created and Deployed Trades and Positions report to EPIC
  • Created Ad-Hoc Reports, Linked, Unlinked, Summary Reports, Drill-down and Drill through using SSRS
  • Developed Chart, Matrix report and Tabular Formatting report in SSRS
  • Created Multi Parametrized Queries for generating allowing users the ability to make selections before executing reports; thus making them user friendly.

Associate, SQL

Eagle PACE/Longview | Trilogy Global Advisors
New York, NY
10.2007 - 01.2014
  • As an associate at Trilogy, I was responsible for specification, design and implementation of firm wide and client facing trading and Risk reports using SSRS, Eagle PACE, Access platforms as well as the categorization of Trilogy's report library
  • Worked extensively on Risk Management, Commissions, Trades, Cash activity and Positions reports
  • Implemented complex reports by moving SQL statements to stored procedures and use of temp tables for aggregation Performed unit and functional testing of the reports and stored procedure related changes
  • Diligently worked on outstanding support tickets and delivered results thereby gaining positive feedback from clients and end users.

Education

Bachelor of Science - Statistics

Madras University

Skills

SQL integration

undefined

Timeline

Data & Reporting Analyst SQL

Charter Communication
01.2022 - Current

Database developer

JIRA | Atria Wealth
08.2020 - 11.2021

Database Developer

Leopold Associates
02.2017 - 04.2020

Consultant, SQL/SSRS

W.R.Berkley Corp
01.2016 - 10.2016

Database developer, SQL/SSRS/Crystal Reports Developer

Geneva | Shenkman Capital
04.2014 - 10.2015

Associate, SQL

Eagle PACE/Longview | Trilogy Global Advisors
10.2007 - 01.2014

Key developer

Bachelor of Science - Statistics

Madras University

Similar Profiles

CREATE PROFILE
Priya Vangeepuram