AMIT GUPTA
Software Development Engineer
Delhi,Delhi
Summary
Career Objective - To work in a company with a professional work driven environment, where I can utilize and apply my knowledge and skills which would graduate to grow while fulfilling organizational goals.
My skills - Power Query, Power Pivot, Power View, Power Map, Power BI Writing Data Analysis Expression (DAX) function in power Bi desktop. Advanced Excel Creating Time Saving Utilities, Functions, Report Automation using VBA (Macros) Active Directory Strong problem solving and analytical skills. Strong verbal and written communication skills. High adaptability to changing work places and requirements.
Overview
9
9
years of professional experience
7
7
years of post-secondary education
Work History
Software Development Engineer
Fiserv
Noida, Uttar Pradesh
09.2019 - Current
- Working as an Oracle developer for a core banking application (DNA – Dot Net Application)
- Code Analysis related to working functionality which also includes new code fixes/Changes for upcoming releases/versions
- Creating debug versions of PLSQL packages, procedures and Structure Query Reports (SQR) for precised root cause analysis
- Responsible for Functional support for DNA application specifically related to oracle database
- Supporting CORE API related issues with precised resolution
- Expertise in dynamic SQL, Cursors, collections and Exceptional handling
- Developed and optimized database structures, stored procedures, Dynamic views, DDL triggers and user-defined functions
- Providing support on multiple releases and managing the same in Teams foundation Server (TFS)
- Writing complex SQL queries using joins, sub queries and correlated sub queries for data correction/Retrieval for timely solution
- Involved in providing Adhoc SQL queries for customized requirement/Data Fixes as per the client’s requirement
- Working exclusively as a pre-triage analyst for assessing potential bug in the code and thereafter code fixes
- Responsible for recreating issues/Scenarios and testing custom enhancement as per the client’s requirement
- Closely involved with client to provide timely and precised resolution (For P1 Cases)
- Actively participating in client call for requirement gathering related to custom enhancements/Requirement of the client.
Application Support Engineer
Wipro Limited (Erstwhile Alight Solutions)
Noida, Uttar Pradesh
10.2016 - 08.2019
- Experience in ETL (Extraction Transformation Loading) process from different sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP
- Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2012
- The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
- Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
- Experience in Developing New tables and queries using PL/SQL
- Developed and optimized database structures, stored procedures, Dynamic views, DDL triggers and user-defined functions
- Extensively used advanced feature of PL/SQL like Records, tables, Object type and Dynamics SQL
- Implemented Table Partitioning, Advanced Error handling and new features like Common Table Expression (CTE)
- Expertise in dynamic SQL, Cursors, collections and Exceptional handling
- Created Packages and procedures in PL/SQL as per the requirement
- Responsible for day-to-day tasks like re-indexing, checking integrity, scheduling backup and database recovery using SQL server Agent jobs
- Database Administration activities like creating functional account for multiple Usage and maintaining access privilege for same
- Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per ISO 27001 Standards
- Management of SQL server application into citrix environment via active directory security groups
- Expertise in generating ad hoc reports using power BI and MS Excel Power View.
Education
Bachelor of Technology - Mechanical Engineering
Sharda University
Greater Noida 08.2010 - 08.2014
Senior Secondary - Science
Central Board of Secondary Education
Delhi 03.2009 - 07.2010
High School - Science
Central Board of Secondary Education
Delhi 04.2008 - 07.2009
ISO 27001 (British Standard Institution) Advanced Excel (Internal) VBA Macro (Internal) - undefined
Skills
undefined
Timeline
Software Development Engineer
Fiserv
09.2019 - Current
Application Support Engineer
Wipro Limited (Erstwhile Alight Solutions)
10.2016 - 08.2019
Bachelor of Technology - Mechanical Engineering
Sharda University
08.2010 - 08.2014
Senior Secondary - Science
Central Board of Secondary Education
03.2009 - 07.2010
High School - Science
Central Board of Secondary Education
04.2008 - 07.2009
ISO 27001 (British Standard Institution) Advanced Excel (Internal) VBA Macro (Internal) - undefined
Similar Profiles
Tabitha GrateTabitha Grate
Terminal Support Specialist at FiservTerminal Support Specialist at Fiserv
Melinda EarleyMelinda Earley
Customer Service Representative at FiservCustomer Service Representative at Fiserv
Stacy EverettStacy Everett
Data Entry at FiservData Entry at Fiserv
Gayathri PrakashGayathri Prakash
Quality Assurance Engineer at FiservQuality Assurance Engineer at Fiserv
SHRESTH ISHSHRESTH ISH
Advisory Intern at Deloitte USIAdvisory Intern at Deloitte USI