 Data Processing: Built ETL pipelines to handle trade data from various upstream systems. Extracted, transformed and validated data using Bob Jobs and SQL stored procedures. Data was loaded in Data Marts for downstream systems to send out Intraday financial statements and internal analytical purposes.  Business Intelligence: Collected, cleaned and transformed Financial data (Securities, bonds and derivative data) from disparate sources for data analytics for internal users using SQL queries and stored procedures.from disparate sources for data analytics for internal users using SQL queries and stored procedures.

 Data Pipeline: Built Data Warehouse to support analytical needs of Open Location Platform Project using batch data processing. Extracted and loaded data from MongoDB to AWS Redshift using Apache Airflow, used for various Dashboards. Used SQL queries to transform loaded data into analytics denormalised tables. Data Quality: Designed, developed, and maintained ETL for anomaly detection using Apache Airflow and PySpark to ensure production data quality for Regression Tests for various teams. Data Coverage: Developed a tool to make acceptance testing faster for teams across Core Map Engineering Group by providing the smallest set of tile data possible which contains all the uniqueness of production data. Implemented using PySpark, Pandas and Numpy python packages. Data Analytics: Developed metrics collector tool using Python, Docker and Amazon RDS(PostgresSQL). Created Metrics Dashboard for DevOps Team using Tableau. Test-Driven Development: Developed several Property Based Tests using Hypothesis for Data Science and Development Teams for client sensitive applications. These tests included both Stateful Testing and Value Generator Cases. Helped in increasing unit and line coverage for applications.

 Smart Sampling: Created a tool by using statistical data sampling technique on Python, which provides smart samples for software testing. Smart samples made regression-testing process faster without losing accuracy. Machine learning algorithm used such as Isolation Forest, K-Means Clustering. Data Querying: Wrote Ad-hoc Queries for moving data from HDFS to HIVE and analyzing the data using HIVE QL for business requests.

SAP Basis and Security Consultant• Used Business Objects Data Integrator to perform Extract, clean, validate and load data into oracle data warehouse. Automated client-specific scheduled activities in PL/SQL to reduce effort for Audit activities by 40%.• Production Support - Worked on SAP security tickets to meet client metrics and reported on security tracking codes and cause codes. Supported one of the largest SAP Landscape( R/3, BW, EBP, CRM) by provisioning/ de-provisioning user access and authorizations• Provided SAP security consultations to Chemical and Natural resources client to mitigate risks in SAP and SAP business processes by performing SAP business process risk assessment, ITGC control assessment and business process overview• Led a team to recommended best practice solution to implement IT general controls for 6 business modules.• Led SAP internal audit for automated business process controls for a CNR client.• Used SAP GRC 10 and Compliance Calibrator for identifying and resolving critical Segregation of Duties (SOD) conflicts within SAP implementation for audit and SOX Compliance

SAP Security and Basis Consultant