loader
Summary
Overview
Work History
Education
Skills
Timeline
NEERAJ PATANE

NEERAJ PATANE

DATA ANALYST
Pune
Summary

Solutions - oriented Data & Power BI Analyst having 7+ years experience in banking ,actimize, and trade market abuse surveillance domain. Expertise in analysis and testing of business requirements to drive deployment of applications, business processes and system solutions. Highly analytical and detailed with documented track record in full software development life cycle (SDLC) methodologies and Agile techniques.

Overview
4
4
years of post-secondary education
6
6
years of professional experience
Work History

DATA ANALYST

Nordea Bank
2019-10 - 2020-01
  • Perform data analysis, identifying trends and key drivers of metrics to support threshold tuning and calibration for Actimize tool.
  • Design SQL queries to process raw data ,identify missing data , validation and data quality issues.
  • Create Actimize dashboard reports, Actimize model based analyzers,monthly data reports,alert interpretation tools in Power BI
  • Create data dashboard reports to monitor daily and historical data load .
  • Determined root cause of data quality errors and recommended long-term solutions.
  • Design filters ,power prompts ,and complex market trend calculations for analytical reports by integrating SQL with Power BI .
  • Publishing and maintenance of BI reports in production server.
  • Execute testing of requirements in UAT ,report new defects and observations in JIRA tool.
  • Perform ETL testing to validate sourcing of raw data from source to target database in UAT and SIT .
  • Provide UAT support to business users and other stakeholders in UAT .
  • Coordinated statistical data analysis, design, and information flow.
  • Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
  • Collaborated with business analysts and software development team to identify and convert business goals into data requirements.
  • Evaluated large raw datasets for quality and accuracy.
  • Ensuring quality control while respecting predetermined business rules and deadlines.

Senior Software Engineer

HSBC
2016-01 - 2019-01
  • Worked as a QA Analyst in market abuse trade surveillance project.
  • Perform ETL testing to integrate data from different source systems to target system .
  • Validate data to identify data gaps,missing data ,incorrect data and quality issues using SQL and Excel tool .
  • Perform testing of model jobs for data load and Actimize model execution in unix and job scheduler tool.
  • Debugged code and located root causes of problems by reviewing configuration files and logs.
  • Worked on Actimize modeler to run actimize models,perform alert generation and alert validation activities in SIT based on business requirements.
  • Assist UAT users in creation of data for Actimize models and alert generation.
  • Design test scenarios and test cases using Zephyr tool.
  • Worked as a QA Analyst|SME in Surveillance case management project .
  • Perform requirement gathering and mapping of data from surveillance systems such as TradeHub ,Ecomms , Actimize to perform data integration .
  • Perform data modeling and design implementation strategies to integrate surveillance systems with case management system.
  • Creating user scenarios for automated case creation for reporting of alerts from surveillance system.
  • Create user stories in JIRA.
  • Perform data extraction from data feeds ,data analysis,data profiling and interpretation.
  • Work with teams in delivering data projects into production.
  • Developed and executed QA test cases, scripts and procedures for automated software maintenance.
  • Identified and tracked defects with JIRA and supported developers in resolving problems by completing additional tests.
  • Operated under Agile and Scrum frameworks to complete releases within estimated timeframe and well-organized sprints.

QA ANALYST

Inautix Technologies
2013-01 - 2016-01
  • Responsible for user requirement gathering and analysis.
  • Creating user stories and technical requirements for the development team.
  • Creating of flowcharts and requirement mapping in excel.
  • Worked in Agile development model.
  • Perform data transformation,modeling and implementation of users data.
  • Creating data samples for testing ,validation and users.
  • Execution of UAT testing for business users.
  • Debugged code and located root causes of problems by reviewing configuration files and logs.
  • Collaborated with developers and product owners to stay current on product features and intended functionality.
  • Identified and tracked defects with ALM and supported developers in resolving problems by completing additional tests.
Education

Bachelor of Engineering Information Technology

MMIT
2009-07 - 2013-05
Skills

Power BI

SQL

Python

Selenium

SCRUM and Agile

Data analysis

Timeline

DATA ANALYST

Nordea Bank
2019-10 - 2020-01

Senior Software Engineer

HSBC
2016-01 - 2019-01

QA ANALYST

Inautix Technologies
2013-01 - 2016-01

Bachelor of Engineering Information Technology

MMIT
2009-07 - 2013-05