Genrative AI
M. Abhishek
SQL Developer
Bhopal
Summary
Total Experience of 4 years in Banking, Finance and Insurance domains in the IT Industry. Hand-On Experience in Oracle SQL, MySQL, Microsoft Azure Services, Python, Tableau and JIRA. Worked on End-to-End Development and Functional Tasks throughout the Project Release Cycle and Supporting Live Projects in Production. Analyzing BRD and FRD to develop financial PnL and reconciliation reports using SQL Programming.
Overview
4
4
years of post-secondary education
3
3
Languages
Work History
SQl Developer - Project Engineer
Wipro Ltd
Pune
- 4 yrs in Banking, Finance and Insurance domain in IT Industry
- Hands-On experience in Microsoft Azure Services, Oracle SQL, MySQL, Python, Tableau and JIRA
- Working on End-to-End Development and Functional Tasks throughout the Project Release Cycle and Supporting Live Projects in Production
- Develop and automate Banking reports using SQL programming and delivering break-free reports to stakeholders
- E2E Testing and resolving coding issues in Lower environments and Production
- Responsible for developing code and migrating it from Lower environments to Production
- Responsibilities include Analyzing BRD requirements, Developing code, Debugging, Testing, Troubleshooting and resolving Breaks in Reports
- Good Understanding of unstructured scripting language like XML and SFTP/NDM/OpenSSH protocols used for connectivity between servers
- Client Interaction to capture complete BRD/FRD requirements for developing reports
- Assessed customer needs and goals through communication and system evaluations to modify existing databases for personalized customization
- Assisted clients in understanding and manipulating data to gain value using technical processes
- Created data models and database designs to deliver on project requirements and performance objectives and optimized SQL queries for analysis
- Analyzed existing SQL queries to identify opportunities for improvements.
- Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
- Developed custom database objects, stored procedures and delivered application support.
- Analyzed business reports for prompt communication, follow-up and ongoing support.
- Enhanced existing reports with introduction of new system features.
- Helped plan data extraction and processing tasks, aiding in eventual deployments.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Performed regular database backups to prevent information loss.
- Documented analysis results and provided performance improvement feedback.
Developer and Requirement Analyst
Citi Bank
Bhopal
- Data Analysis aligned to Citi clients to get meaningful data in the form of Subscriptions and Reports.
- These are financial PnL and reconciliation reports delivered to the clients through on daily and monthly basis as per requirement.
- Based on these reports, reconciliation is done at downstream end.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
- Maintained proficiency with latest database technologies.
- Collected data from wide-ranging sources.
- Handled massive quantities of business intelligence data, personally managing as much as 50 terabytes.
- Generated ad-hoc reports to evaluate specific business requirements.
- Provided technical support for troubleshooting analytics and reporting issues.
- Identified patterns and trends in large data sets and provided actionable insights.
- Created data models to support decision-making processes.
- Collaborated with stakeholders to identify business needs and data sources.
- Optimized data access and storage to improve performance of analytics systems.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Generated standard and custom reports to provide insights into business performance.
Sports Analyst
InStat
Bhopal
- Analyzing data from several basketball matches in a year, providing an unrivaled set of video, statistical and tracking solutions to our clients, giving them all the tools to maximize their performance.
- Optimized data sources and processing rules to enhance data quality through design and development phases.
- Tracked and leveraged data trends, aggregate statistics and volume fluctuations to analyze performance metrics.
- Drafted technical documentation for internal business areas and processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
- Improved data collection methods by designing surveys, polls and other instruments.
- Compiled, cleaned and manipulated data for proper handling.
- Developed and maintained courteous and effective working relationships.
- Skilled at working independently and collaboratively in a team environment.
- Worked effectively in fast-paced environments.
Intern
Airport Authority of India
Bhopal
- Developing PCB Patch Antennas for Wireless Communication
- Also developing Working Models of Visitor Counter using IR sensors that can detect the visitors in waiting lobby.
- Visitor Counter Prototype used in crowd management in airport waiting lobby.
- Sorted and organized files, spreadsheets, and reports.
- Completed research, compiled data, updated spreadsheets, and produced timely reports.
- Facilitated successful completion of projects from concept to launch.
- Gained operational knowledge and supported departmental needs.
- Analyzed problems and worked with teams to develop solutions.
Education
Bachelor of Engineering - Electronics And Communications Engineering
Oriental College of Technology Jawaharlal Nehru School
Bhopal , Madhya Pradesh 07.2015 - 07.2019
Skills
Oracle SQL DeveloperAzure Cloud Services
MySQL
XML v11
Tableau Desktop v20223
JIRA Software v82011
Agile Methodology
Python
Accomplishments
- SQL Advanced Certification
- Oracle SQL Advanced Level Certification https://www.hackerrank.com/certi cates/iframe/031d3f9beb
- Microsoft Certified: Azure Data Engineer Associate https://www.credly.com/users/m-abhishek.2c2c7333
- SQL Intermediate Certifications
- Oracle SQL Intermediate Level Certi cation https://www.hackerrank.com/certi cates/iframe/cc8 a27fcdf5a
- Microsoft Certified: Azure Data Fundamentals https://www.credly.com/users/m-abhishek.2c2c7333
- SQL Basic Certification https://www.hackerrank.com/certi cates/iframe/c112ca0e3
- Microsoft Certified: Azure Fundamentals https://www.credly.com/users/m-abhishek.2c2c7333
- Documented and resolved critical production issues which led to customer satisfaction and prevented $10 million fine on the company.
Additional Information
- SPOT Awards 2021, 2022 SPOT award is a recognition given by Wipro Technologies Limited for excellent work in their respective Project.
- National Level Football in High School.
- Represented Oriental College of Engineering at University Football Championships.
- Represented College in Athletics.
- Represented National Cadet Corps Unit at National Level in 200m Rifle Shooting.
- Represented Bhopal in State BasketBall tournament under-14.
Interests
Sports Management and Anaytics
Quantum Physics
Reading
Learning Languages
Hobbies
Cricket, Football, Swimming, Local Meetups, Public Speaking, Exploring Cultures.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Bachelor of Engineering - Electronics And Communications Engineering
Oriental College of Technology Jawaharlal Nehru School
07.2015 - 07.2019
SQl Developer - Project Engineer
Wipro Ltd
Developer and Requirement Analyst
Citi Bank
Sports Analyst
InStat
Intern
Airport Authority of India