Gulshan_resume
0 likes54 views
- Gulshan Kumar Singh is seeking a position that allows him to continuously improve his technical skills and expertise while providing professional growth. - He has 4 years of experience working with Oracle PL/SQL, Qlikview, and UNIX. He is currently a Project Associate at Cognizant Technology Solutions where he designs technical solutions, codes, communicates with clients, and manages technical issues. - His skills include SQL, PL/SQL, Oracle, SQL Server, QlikView, and tools like TOAD, TFS, and Putty. He is interested in learning Hive, Pig, HDFS, Spark, Scala, Sqoop, and Flume.
![WORK EXPERIENCE :
EMPLOYMENT SUMMARY :
Organization Location Designation Duration
Accenture Services Pvt.
Ltd.
Magarpatta , Pune
Application
Development Analyst/
Software Developer
4th Mar 2015 –
30th May 2018
Cognizant Technology
Solutions
Hinjewadi , Pune Project Associate
31st May 2018 -
Current
PROJECT SUMMARY :
Cognizant Technology Solutions Ltd. [May 2018 to till Date]
Project Undertaken:
? Project Title: Application Management Services (PNM Resources)
Team Size : 3
Clients : Public Service Company of Texas and New Mexico (TNMP Company U.S.)
My Role : PL/SQL Programmer.
Description : This system is designed to handle the entire Meter to cash process of Texas-New
Mexico Power Company (TNMP), a primary power Transmission and Distribution Company
operating in highly de-regulated energy market of North America. The entire system is divided
into two modules as
1. Customer Service
2. EDI (Electronic Data Interchange)
? Role & Responsibilities:
? Being the EDI resource, I was extensively involved in maintenance of EDI
transactions which includes monthly consumption, invoices, and enrollment
of the customers.
? Involved in code design/changes, enhancements, writing the SQL queries and
modifying the oracle objects/ Oracle Forms.
? Unit testing and Integration
? Preparation and Execution of Test cases.
Accenture Services Ltd. [Mar 2014 – May 2018]
? Project Title : BI Managed Services
Description : The project aims to develop database design, ETLs, planning for
enhancements and Regular application support and maintenance. ODS
(Operational Data Store) being a key sub-group for hosting master data
along with data from various business dimension. The said data store caters
to various key reporting and analytical needs.](https://image.slidesharecdn.com/plsqlresume-190513130745/85/Gulshan_resume-2-320.jpg)
Gulshan_resume
- 1. GULSHAN KUMAR SINGH Email :- gulshankumarsingh03@gmail.com Contact no :- +919579017967 CAREER OBJECTIVE: To work continuously towards increasing my technical skills, professional expertise and overall development in a dynamic organization along with providing security and professional growth. PROFESSIONAL SUMMARY : ● An enthusiastic software professional having 4 years of live industrial exposure in the field of Oracle PLSQL, Qlikview and UNIX. ● Currently working in Cognizant Technology Solutions as Project Associate. Responsible to Design Technical solution, Coding, communicate to Client about the Project status, managing technical issues related to the project in accordance to Organization Quality process. ● Primarily I am part of the Database team to develop database design, ETLs, planning for enhancements, regular application support and maintenance. ● An effective communicator with excellent relationship building & interpersonal skills. Having good analytical skill and eager to learn and understand systems concepts. ● Strong believer in team work, building cordial relation with people inside and outside the organization, innovating solutions for difficult programming problems, self and fast learner. ● I Have also got training in Hive, PIG, HDFS, Spark, Scala, Sqoop and Flume. I am interested to work on this. IT Skills : Operating Systems ● Windows XP, 7,8,9X,10 Languages ● SQL , PLSQL Databases ● ORACLE, SQL server Tools ● QlikView, Croncale, Appworx Project Management Tools ● TOAD, TFS, PUTTY, HPSM
- 2. WORK EXPERIENCE : EMPLOYMENT SUMMARY : Organization Location Designation Duration Accenture Services Pvt. Ltd. Magarpatta , Pune Application Development Analyst/ Software Developer 4th Mar 2015 – 30th May 2018 Cognizant Technology Solutions Hinjewadi , Pune Project Associate 31st May 2018 - Current PROJECT SUMMARY : Cognizant Technology Solutions Ltd. [May 2018 to till Date] Project Undertaken: ? Project Title: Application Management Services (PNM Resources) Team Size : 3 Clients : Public Service Company of Texas and New Mexico (TNMP Company U.S.) My Role : PL/SQL Programmer. Description : This system is designed to handle the entire Meter to cash process of Texas-New Mexico Power Company (TNMP), a primary power Transmission and Distribution Company operating in highly de-regulated energy market of North America. The entire system is divided into two modules as 1. Customer Service 2. EDI (Electronic Data Interchange) ? Role & Responsibilities: ? Being the EDI resource, I was extensively involved in maintenance of EDI transactions which includes monthly consumption, invoices, and enrollment of the customers. ? Involved in code design/changes, enhancements, writing the SQL queries and modifying the oracle objects/ Oracle Forms. ? Unit testing and Integration ? Preparation and Execution of Test cases. Accenture Services Ltd. [Mar 2014 – May 2018] ? Project Title : BI Managed Services Description : The project aims to develop database design, ETLs, planning for enhancements and Regular application support and maintenance. ODS (Operational Data Store) being a key sub-group for hosting master data along with data from various business dimension. The said data store caters to various key reporting and analytical needs.
- 3. Tools : Qlikview, TOAD, TFS, PUTTY, CRONACLE, HPSM, WINSCP ? Primarily I am part of the Database team (ODS) to develop database design, ETLs, planning for enhancements and Regular application support and maintenance. ? Developed the Context and Code generation framework for Client which re- utilized for multiple project / enhancement and resulted good cost saving on effort. ? Worked in Complex cases and used PIPE Line function, Bulk Collection, Types , Array for fast processing. ? I have also worked on QlikView for reporting. ROLES AND RESPONSIBILITIES: ? I have worked in the following topics in Oracle - Tables, Views, Materialized Views, Index, LOBs, Packages, Procedures and Functions, DB links, Synonyms, Sequences, Types, Triggers, Analytic Functions, collections. ? My role in this project as Application Development Analyst and Technical Architect. ? I am responsible for the offshore Team management, Oracle Technical expert in analysis of different core functional problems and deal with development team. ? I am responsible for onshore co-ordination for estimation, delivery and planning ? Peer review – code ready for production migration ? Analysis of Problem / Improvement area and drive through implementation. ACADEMIC QUALIFICATIONS : Examination Percentage Year University/Board 1. B.Tech (E&C) 69.5 2010-2014 UPTU 2. HSC 84.2 2006-07 CBSE 3. SSC 79.2 2008-09 CBSE PERSONAL PROFILE: Father’s Name Mr. Chandra Bhushan Singh Mother’s Name Date of birth Mrs Renu Singh 02nd FEB 1992 Gender Male Marital Status Single
- 4. Languages known English, Hindi Passport Yes Hobbies/Interests Travelling and Trekking , Playing Basketball DECLARATION: I hereby declare that the above-mentioned information is correct to the best of my knowledge. Gulshan Kumar Singh