Vishal
Senior Software Engineer
Summary
Adaptable Senior Software Engineer talented at providing customized and optimized solutions for all needs. Thrives within tight deadlines by applying agile development strategies. Comfortable overseeing large-scale development teams or independently coding complex projects.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
Work History
Senior Software Engineer
NUCLEUS SOFTWARE EXPORTS LTD
Noida
02.2019 - Current
- Designed/Coded PL/SQL packages/procedures or functions as per the Requirement.
- Modified existing packages/procedures/functions as per the Requirement.
- Performance Tuning - Tuned existing SQL Queries or PL/SQL code for better performance (mostly in projects with both development & support )
- Unit Testing Code Migration to higher environments.
Involved in the continuous enhancements and fixing of production issues. - Participated in analysis, design, coding, testing, implementation and documentation of the development or the change requests.
- Coordinating with client for requirement gathering , clarification and providing solutions for several problems.
- Creating Cognos Reports for end users analysis Gathered and analyzed business requirements from users and business community.
- Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
- Supported Business Users in generating AdHoc Reports using Query Studio.
- Understanding existing business model and customer requirements Created Complex Reports using Lists, Crosstabs, charts, graphs and Images.
- Scheduled Reports through Jobs to get the Daily, Weekly, Bi-Monthly and Monthly output of reports.
Cloud Consultant
Worksys
Bangalore
12.2017 - 02.2019
- Researched and understood emerging technologies and end-user needs.
- Designed database tables and structures
- Created views, functions and stored procedures
- Optimized SQL queries for integration with other applications
- Creating database triggers for use in automation
- Maintaining data quality and overseeing database security
- Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Developed PL/SQL triggers and master tables for automatic creation of primary keys.
- Created PL/SQL stored procedures, functions and packages.
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using power pivot, power query, power view.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
- Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.
- Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries.
- Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.
- Experience in custom visuals and groups creation in Power BI .
Education
Bachelor of Engineering - Computer Science
K S Institute of Technology
Bangalore 07.2013 - 07.2017
Skills
Oracle PL Sql
SQL
Power BI
Cognos
Business Process
ETL
Query Optimization
Performance Tunig
Report
Oracle D2k
Dashboards
Accomplishments
- Received SPOT Award twice for performance
- Received 'Great Start Award' after 6 months of work.
- 3 Bonuses in a year for extraordinary performance.
Hobbies
- Reading
- Writing
- Travelling
- Cooking
Timeline
Senior Software Engineer
NUCLEUS SOFTWARE EXPORTS LTD
02.2019 - Current
Cloud Consultant
Worksys
12.2017 - 02.2019
Bachelor of Engineering - Computer Science
K S Institute of Technology
07.2013 - 07.2017