Priyanka Yeole Email & Phone Number

Pune, Maharashtra, India

Pune, Maharashtra, India

Implement and Configure Fiserv's AML and Fraud Compliance products for various customers which includes :- Complete installation of the application- Building configuration- Troubleshoot challenges- Advise customers on best usage of the application, etc. This application consists of KYC, Scenarios, Alert and Case handling, Watchlist Matching, Workflow Configuration, Fraud Alerting, Reporting, Profiling, Customer behavior monitoring, AML Alerting etc. Specialties : Fiserv AML Software, MS SQL 2012/2014/2016, IIS, Crystal Reports, XML, Business Requirement Analysis, Database Design

Pune, Maharashtra, India

Pune, Maharashtra, India

• A logical, analytical thinker possesses 2+ years of experience in IT having experience in Database Design, Development & Support of MS SQL Server 2012, Oracle 10G (OLTP, SOR, DWH).• Proficient in Relational Database Management Systems (RDBMS).• Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization and De-normalization of the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.• Experience in implementing business logic using Triggers, Indexes, Views, Stored procedures, Functions, Virtual tables.• Extensive Knowledge of advance query concepts (e.g. group by, having clause etc).• Proficient in Tuning T-SQL queries to improve the database performance and availability.• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.• Transformation of data from one server to other servers using tools like BCP, data transformation services, data conversions from legacy systems to SQL server.• Worked on the disaster recovery procedures and policies for backup and recovery of Databases.• Create Linked Server to work with data from multiple sources so that distributed queries can be run against one server, and queries can join tables from more than one data source• Analyzed the performance, tuned and optimized, supported database objects to migrate to production level, executed stored procedures, index sizing.• Generate various monthly financial & end user reports and send them to the traders and end users. Also generate reports in different formats such as csv, dat, sig, txt etc.• Review existing business procedures and recommend and implement the changes.• Created ETL Jobs on OLTP, SOR, DWH databases using SQL Server Agent and shared results in tabular format in mail using HTML Database Mail.• Automated a weekly report Log Shipping status from OLTP, SOR, DWH databases using system tables and procedures, Database Mail, HTML and share with DB team.

Bachelor Of Engineering - Be, Electrical, Electronics And Communications Engineering, First Class With Distinction

11Th 12Th, Science