Swapnil Shimpi

Domain: Payments | Anti-Money Laundering - Worked on Descriptive and diagnostic analysis to prevent AML activities for Debit and Credit card transactions. - Loading and transforming data in MS SQL server using data pipeline. Creating views for reporting layer. - Worked on re-creating data sources, enhancing with new logic, enhancing performance, pushing calculations to views - Worked on enhancing existing dashboards, design, layout, incorporating new fields

Domain: Operational Risk management, Governance risk compliance (GRC) - Worked on Descriptive analysis for operational risk assessment,monthly, quarterly and yearly dashboards - Created Analytical and informational dashboards ,excel reports which helped for decision making. - Constructed data sources, extracts, model, dashboards(tableau),improving dashboard performance, data accuracy and quality

Domain: Manufacturing and marketing in chemicals, telecom, IT - Developed reports using tableau, business objects and SQL. - Implemented data staging layer using PLSQL and informatica - Migrated etl packages, procedures from Oracle to Hana - Single-handed replaced the old defect tracking system and reduced the defect count by more than 70%. Saved client expenses by 35%.

• Responsible for design, developing, unit testing, functional testing, defect fixing and deployment of code. • Created procedures, packages, functions, triggers, collections, Analytical reports. Performance tuning with help of explain plan, statpacks reports. • Database admin activities like logical (expdp/impdp) and cold backup of database, database/Schema creation for Dev. environment, Database cloning with help of cold backup"

• Responsible for End to End deployment of modules which includes requirement gathering, analysis ,developing, unit testing ,functional testing and Deployment of code. • Created procedures, packages, functions, triggers for ERP and data ware house applications . • Worked on ETL Informatica power center,junior DBA handing DB/Schema creation for Dev and testing environment, database cloning, Performance improvement for OLTP and OLAP Applications with help of AWR, ASH reports, Explain plan.

• As part of Development team, involved database migration from 8i to 10g. • As part of testing team, involved in test planning, test case preparation and execution, Performance testing and functional testing, defect tracking. • Keeping track of project activities like weekly project deliveries, assigning and maintaining status for jobs on daily basis, reviewing JCDs etc.

Computer engineering, SQL,JAVA,SOFTWARE DEVELOPEMENT