Meena Sharma

SQL Developer with 7 years of progressive experience in Financial domain, databases .Strong experience in Data warehouse concepts, ETL and ER modeling ,Partitioned large Tables.Experience in SQL performance tuning using Cost-Based Optimization (CBO). Good knowledge of key performance related features such as Query Optimizer. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.

Service Mac BDE Imports
Home Point sold the servicing loans portfolio to Service Mac and started getting data from Service Mac.
· Worked with Offshore team to implement Service Mac BDE Imports using Informatica, Python & Snowflake.
· Designed and developed automated solution of importing 135+ files in Snowflake. The whole import gets triggered from File Listener in
snowflake.
· Worked on various imports from Vendor files to Share Point using Informatica and Python.
Technologies: SQL Server, SSIS, Informatica, Snowflake, Service Now, Ops Genie, Microsoft Azure platform, Python

Figure Heloc Import/Exports
Home Point partnered with Figure Lending to provide Heloc loans.
· Designed and developed solution to import Application Event, Funding Report, Loan Officer report from Figure Heloc in Snowflake.
· Created extracts for Broker Compensation, AE Compensation and funding reports.
Technologies: SQL Server, SSIS, Informatica, Snowflake, Service Now, Ops Genie, Microsoft Azure platfor

Salesforce Imports/Exports
· Worked on Informatica ETL Jobs to import data from Salesforce and maintain Type 1/Type 2 tables in Snowflake for various
Salesforce objects (Account, Contact, Opportunity, Case etc).
· Worked on Informatica ETL jobs to update data in Salesforce for Account, Contact and Loan objects.
Technologies: Informatica, Snowflake, Service Now, Ops Genie, Microsoft Azure platform

SQL Server Management
· Worked in provisioning Azure SQL Server environments and migrating On-Prem SQL Servers to Azure cloud.
· Worked in consolidating and removing/downsizing SQL Servers on Microsoft Azure and created elastic pool.
· Worked on database management and user management of various SQL ServersETL Imports/Exports
· Designed and developed various imports/exports using SQL Server, SSIS, Informatica and Snowflake.
· Worked on Daily Lender Live Export to generate XML output and sent to Covius (vendor)
· Designed SQL/Snowflake tables, Stored procedures, Views to facilitate various exports and Business Intelligence capabilities.
· Worked with BI Team and Business stakeholders to understand requirements.
· Worked on TPO Imports (Clients, Applications, Hierarchy) to import data from daily excel file and stored data in Type 1/Type 2
tables.
· Worked on import of Black Knight’s eCDE files into a snowflake schema.
Technologies: SQL Server, SSIS, Informatica, Snowflake, Service Now, Ops Genie, Microsoft Azure platform, Python

MGIC Exports/MSR Reports
· Designed and Developed SQL Server procedure and jobs to extract active loans from Loan Portfolio
· Worked with Operations team and vendor MGIC to automatically schedule this monthly extract to MGIC (Mortgage Guarantee
Insurance Corporation)
· Migrated the solution from SQL Server to Snowflake.
· Worked with Business Stakeholders and developed MSR Loan extract using Informatica from Loan Portfolio.
Technologies: SQL Server, SSIS, Informatica, Snowflake, Service Now