Business Data Analyst
CurrentSUMMARYWith over 7 years of experience in the financial services industry, I have worked with the vast majority of the largest U.S. custodian banks and brokerage firms. In my tenure, I have integrated new data into Client's data warehouse, coordinated the development of SQL Server Integration Services (SSIS) and Powershell packages, compiled normalization requirements, and updated existing & created new stored procedures.RESPONSIBILITIES Integrated new data feeds into the client’s data warehouse. Coordinated the development of SQL Server Integration Services (SSIS) package and power-shell with the development team. Providing Full documentation about new development and change in an existing package via BRD to the various department including dev team, ultimate user and Operations team. Compiled normalization requirements and updated existing normalization, also created new stored procedures. To evaluate and analyze Daily Fund Scorecard to check Profit and Loss Performance of financial instruments, classified on a portfolio basis and product basis. Create ETL rules further load of data in the structured format in the Database. Partner with Stakeholders to identify the reporting needs and oversee the entire lifecycle of report development. Develop data integrity reports, catching and addressing anomalous activity before it negatively affects the end-users. Make procedures in SQL server, to track any exceptions as well as to analyze the process ad-hoc requirements. Use of Bloomberg Terminal, Markit WSO as a tool to extract information from vendors to make accounting system normalization. Investigate data discrepancies and position reconciliation breaks.RECOGNITION Recognized by Client in Reducing the time spent on Dashboard Monitoring. Recognized by Client in Building Data Warehousing infrastructure that includes Generic Import, Normalization, Data Integrity report Via SQL Server Procedure and end-user reports.