Sameer Inamdar Email & Phone Number

Frankfurt Am Main, Hessen, De

- Design customer segmentation model for a transaction monitoring system. Utilized pandas, SciPy, sklearn for data operations, normality tests, outlier treatment etc. Utilized plotly for model quality visualizations.- Model threshold tuning and optimization utilizing pandas, numpy etc.- Use Hive/Impala to manage warehouse on HDFS and for metrics and reporting.- Manage team to lead tableau dashboard development for displaying metrics related to BSA/AML program.- Built utilities and daily jobs in CDSW (cloudera data science workbench) to automate data operations as well as monitor daily transactions and report any anomaly. Utilize Pyspark/impala to fetch update data from HDFS Hive tables.- Python based utilities for process automation; such as tableau dashboard modification and publishing using tableau server client. Another utility created that would identify efficient frontiers in regards to below the line(BTL) testing.

New York, New York, Us

•Client onboarding – Integrate clients into Citi’s Price Master Central (PMC) system – central repository for securities & pricing information. Perform requirement gathering, elicitation and documentation (BRDs) •Vendor onboarding – Analyze raw data feeds from vendors & create ETL data mapping documents. Interact with ETL team through the build and test phase, thus integrating vendor data into system•Business systems analysis and data governance - Design GUI, business processes to improve system performance & efficiency. Interact with clients to understand issues related to security data flow in system, resolve them by using PL/SQL, MS Excel•Profit/loss impact analysis for clients after onboarding; using SQL & Excel•Interact with financial product controllers & implement the vendor ranking algorithm/hierarchy. •BI & reporting - Create dashboards to monitor vendor-client data feeds using Tableau desktop. Develop KPIs to show vendor data profitability. This helped to optimize ETL infra costs and time. •Team management – Lead global BAU activities.AML/KYC•Business process optimization of CitiKYC Utility focusing on account/product usage profile.•Analyzed Citi AML/KYC risk scoring model, account activity data/process for clients. Analyzed external data feeds, its logic in KYC to achieve data flow optimization.•Created reports of customer segmentation between various risk categories and related processes within KYC. Vendor Management:Analyze notifications from data vendors like Bloomberg/Reuters & assess future impact to our system.Data Analytics:Price Investigation System: Designed, developed price debugging system which was integrated into the reference data mgmt system. This application is used to find system data flow break for a security. Price Analytics: Developed program in R language to find price outliers, correlations among data vendors & generate fact sheet. Correlations helped product controllers get insight on system algorithm performance.

Dublin 2, Ie

• Led team of five resources, identifying & distributing tasks amongst them & coordinated with onsite team.• Worked with senior management in regards to making Accenture’s’ internal processes more efficient. Designed an application using C#.NET, VBA & MSSQL; which would automate part of design phase in the project.• Interacted with client, onshore team to understand the business process & created them in MS Visio. The business processes were campaigns that would be launched for effective marketing communication in pharmacy industry. • Based on the Visio flowchart, created corresponding templates in MS Excel. • Understood Aprimo MRM database design. Designed & developed 2 Windows applications using C#.NET, EXCEL macros that integrated with database. Product defect count reduced to almost zero.• Created 2 project plans using MS project and also maintained the RTM(requirement traceability matrix)

Dublin 2, Ie

• Implemented business workflows in Aprimo marketing software along with business rules & other configurations.• Developed Application User Interface in Aprimo Marketing Resource Management software using C#.NET. Created test scenarios and conditions regarding the same.• Performed data integration, migration and validation using SQL between legacy application and new version.• Designed and developed reports in SAP Crystal reporting application. Deployed reports used Aprimo as UI and SQL server database. Created SQL procedures, functions to populate data in crystal reports.

Master Of Science - Ms - In Progress, Analytics

Master Of Science (Ms), Management Information Systems, General

Bachelor Of Engineering (Beng), Electrical, Electronics And Communications Engineering