ASHISH JOHN
Noida,UP
Summary
Highly action-oriented individual with strong analytical and problem-solving ability, offering extensive experience as an SSIS developer. Proven track record in designing, implementing, and maintaining ETL processes. Adept at efficiently translating complex business requirements into effective data solutions. Skilled in collaborating with internal teams and vendors to ensure seamless data flow across diverse databases. Expertise includes analyzing business needs and delivering innovative design solutions. Seeking opportunities to contribute problem-solving skills to drive informed decision-making within a dynamic organizational environment.
Overview
3
3
years of professional experience
1
1
Certification
Work History
System Analyst
Ujjivan Small Finance Bank
06.2022 - Current
- Using Agile methodology to design and implement end to end data pipelines using SQL Server Integration Services (SSIS) to automate data extraction, transformation, and loading (ETL/ELT) processes
- Creating SQL Procedures, functions for data extraction and report generation
- Monitoring data loads to ensure timely delivery of data to stakeholders and applications
- Collaborated with cross-functional teams to gather requirements and deliver data solutions that enhanced reporting and analytics capabilities
- Providing data requirements to internal teams to meet organizational goals
- Created Dashboards using PowerBI
- Documented processes and provided training to team members
- ETL Projects Implemented: Anti-Money Laundering(AML), CKYC, APPLICATION FOR CREDIT DISBURSEMENT, AUTOMATED DATA FLOW
- Important Reports Implemented: Report for Micro Banking, BASIC STATISTICS REPORTS 1 (BSR1), BASIC STATISTICS REPORTS 2 (BSR2)
Education
Master of Technology - CSE - Big data Analytics
Vellore Institute of Technology
Skills
- SQL
- SSIS
- SSRS
- Oracle SQL Developer
- Power BI/DAX query
- EXCEL
- Python
Certification
- Python Bootcamp, Udemy
- Google Associate Cloud Engineer, Google
- Beginner to pro in Excel: Financial Modelling and Valuation, Udemy
Extra-Curricular Activities
Cambridge English Certificate in ESOL International (Business Vintage), Cambridge English Language Assessment Volunteer for National Service Scheme, 08/01/14 to 06/01/15
Timeline
System Analyst
Ujjivan Small Finance Bank
06.2022 - Current
Master of Technology - CSE - Big data Analytics
Vellore Institute of Technology
Similar Profiles
PRAVEEN MOTEBENNURPRAVEEN MOTEBENNUR
Regional HR - Head, South (SVP) at Ujjivan Small Finance BankRegional HR - Head, South (SVP) at Ujjivan Small Finance Bank
Prabu NPrabu N
Area Manager – Agriculture Banking (AVP) at Ujjivan Small Finance BankArea Manager – Agriculture Banking (AVP) at Ujjivan Small Finance Bank
Ranjeet RaoRanjeet Rao
Branch Sales Manager at Ujjivan Small Finance BankBranch Sales Manager at Ujjivan Small Finance Bank
Pradip ChaudhariPradip Chaudhari
Branch Operations Manager at Ujjivan Small Finance BankBranch Operations Manager at Ujjivan Small Finance Bank
Vishesh BhadauriaVishesh Bhadauria
Cloud Consultant at CloudkeeperCloud Consultant at Cloudkeeper