NEERAJ PATANE
DATA ANALYST
Pune,MH
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
Copenhagen, Denmark
10.2019 - 01.2020
- 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
Pune
01.2016 - 01.2019
- 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
Pune
01.2013 - 01.2016
- 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
PUNE 07.2009 - 05.2013
Skills
Power BI
undefinedTimeline
DATA ANALYST
Nordea Bank
10.2019 - 01.2020
Senior Software Engineer
HSBC
01.2016 - 01.2019
QA ANALYST
Inautix Technologies
01.2013 - 01.2016
Bachelor of Engineering - Information Technology
MMIT
07.2009 - 05.2013
Similar Profiles
Sarvani AnantharajuSarvani Anantharaju
DataStage Developer at Nordea bankDataStage Developer at Nordea bank
Merve Miskin CakmakMerve Miskin Cakmak
Group Compliance Monitoring and Testing Officer at Nordea BankGroup Compliance Monitoring and Testing Officer at Nordea Bank
Leon SzneiderLeon Szneider
Process Officer at Nordea BankProcess Officer at Nordea Bank