Badges
Certifications
Work Experience
Senior Developer
Standard Chartered Bank•  April 2018 - Present
 Coordinated with Business Analyst’s to understand the functional knowledge for required models.  Dealing with the financial/ banking products and related risks (interest rate risk, liquidity risk) and hedging, measurement and monitoring of such risks.  Analyzing, identifying, quantifying and monitoring all market risks for the SCB Global Business.  Dealing with the financial/banking products and related risks (interest rate risk, liquidity risk) and hedging, measurement and monitoring of such risks.  Overseeing and ensuring the integrity of the risk monitoring process.  Designing, reviewing and signing off on scenario results across various portfolios within SCB.  Coordinating projects related to IT development for data analysis, modelling and reporting. Processing and analyzing all risk measures including Limits, Exposures, Economic Risk Capital (ERC) and Risk Based.  Assist in developing and integrating new analytical tools and reports to enhance capital stress testing process.  Developing stress testing.  Understand operating models to design and improve key processes.  Support development, implementation and monitoring of capital stress testing models.  Drive a continuous improvement and change culture.  Formal Project management training Prince2 or equivalent.  Support building and enhancing documentation of models and all analysis.  Data Collected: Collecting the required data by coordinating with data team.  Data Extraction/Preparation: Performed various operations to prepare the data like data ETL operation, Stacking, Transformation, Manipulating, Cleansing & Processing, and converting the variables into the required format.  Data Quality Check: Performed the data quality check operations like DQ1 at input end and DQ2 test at output end.  Model Development: Developed various model’s by implementing the functional knowledge in SAS/DI or SAS/EG or SAS/Base (using Macros).  Reports/Dashboards: Wrote SAS code for different model’s to generate reports/dashboards.  Model Validation: Performed model validation operations to ensure that the generated statistical output is correct.  Code Automation: Wrote SAS code to automate the operations.  Bit bucket: Worked on Dev tools like Bit bucket/Jenkins.  Worked on agile environment.
Database Executive
RainMan Consulting Pvt. Ltd•  December 2015 - April 2018
Interacting with client regarding data requirements and anomalies. ï‚· Data quality checks: Performed the quality checks analysis process for the data received from client. ï‚· Data Preparation: Prepared data by using the tools like SAS/SQL/Excel. ï‚· SAS Macro Writing: Wrote SAS Macros for Data Preparation, Data Stacking, Data Transformation and Data Validation from different sources like Excel/CSV/TXT/MySQL. ï‚· Reports/Dashboards: Prepared Reports/Dashboards using SAS/Base, Tableau, SQL and Excel. ï‚· EDA: Performed the EDA process to get the insights of the data. ï‚· Exporting Reports: Exported Reports in Pdf/txt/HTML/Image format. ï‚· Monthly Competitors Sales Analysis: Compared the market performance for the key brands with competitors in terms of Sales, GRP deployment, SOV, Price, Distribution, etc. and identified general trends and possible competitor strategies. ï‚· Transformation, Manipulating, Cleansing & Processing data using SAS, Python, SQL and Excel.
Website Developer & Designer
Ananta Enter., Dunonu India Pvt. Ltd.•  February 2015 - November 2015
Integrating cross browser compatible applications and secure payment gateways in the website  Developing online marketing and promotional strategies  Monitoring website traffic and generating crystal reports  Developing a live chat module to solve customers’ query.  Build a module to get the location of customer by adding google map API to deliver order in a optimize way.  Distribution - Identify top 20% customers who give 80% sales, study their attributes and do cold calls for similar stores
Database Developer
CREATIVE IT MEDIA•  September 2013 - December 2014
Designed database, tables and views structure for the application. ï‚· Implementing constraints, primary, candidate, unique and foreign, NULL and NOT NULL concepts on the database. ï‚· Complex Query writing in MySQL. ï‚· Worked on web based technology like PHP, jQuery, HTML, CSS & MySQL. ï‚· Performing the responsibilities of implementing and hosting of systems on a web server. ï‚· Develop web services in PHP which will interface with third party APIs ï‚· Developed E-Commerce site with Payment Gateway Integration.
Education
Jabalpur Engineering College,Jabalpur
Information Technology, BE•  August 2007 - June 2011