
Anurag Soni
Phone: 9555049329
E-mail: anurag.soni4u@gmail.comOBJECTIVE
To secure a responsible and challenging position in an organization of repute with considerable advancement opportunities where I can utilize my knowledge and experience to further explore and enhance my skills to grow with time and build a successful career.
PROFESSIONAL EXPERIENCE
12+ years of overall experience in the IT Industry in the design and development of dot net applications using Dotnet core, MVC, C#, ADO.NET and MS-SQL server 2018/2014/2012/2008 along with Angular, jQuery, Ajax.
SAKSOFT Limited                                                                                                                                   Lead Consultant         
                                                                                                                                                                  (2 March 2022- Present)                                                                                                                                                                                       
                -   Currently working with TransUnion (Third Party)
                -   Understanding the feature requirements and explaining to the team
                -   Analysis of assigned features
-  As a part of the Agile team, being part of the development life cycle, including analysis, development, testing and   builds.
                - Manages two teams simultaneously
Worked on Project:   
                        1-Funnel consolidation
Description: User can check packages according to the retailer and do enrollment in the specific package. After that user will log in on the dashboard and can check his credit service activities here.
2-Data Risk Stages (DRS)
Description: In this, we translated the complete my account section in the French language also implemented the LMS integration.
Mad Men Marketing OPC PVT. LTD.        Sr. Technical Architect   
                   (1 Aug2018– 27 Oct 2021)
Handling the team
Analysis and design of the database acquired from the client’s or application’s requirements.
Creating tables, stored procedures, job, schedulers, cursors and lots of database objects to achieve specific task based on requirement in optimized way.
Writing the code based on Angular, Web API and MVC.  Also, creating services (Web/WIN/WCF services) to accessing and transferring data into multiple applications.
Debugging and problem solving in project.
Worked on IIS Server and Plesk control panel.
Dentsu Webchutney, Gurgaon         Sr. Technical Architect   
                     (Mar 2015–31 July 2018)
Analysis and design of the database acquired from the client’s or application’s requirements.
Creating tables, stored procedures, job, schedulers, cursors and lots of database objects to achieve specific task based on requirement in optimized way.
Writing the code based on Asp.Net and C#. Also, creating services (Web/WIN/WCF services) to accessing and transferring data into multiple applications.
Upgrading the old version code into latest technologies. 
Perform the unit testing or UAT server based testing for all applications. Also, creating the test cases and maintains SRSdocument for every BRD or change request.
Creates SQL jobs and schedulers to perform multiple tasks like processing user logs, user absconding, inserting dump data and user roster dump etc.
Also, a part of application and services deployment and maintenance team.
Providing the applications technical support and database related queries and support for the client through Remedy as well as on mails and calls.
Gurus11, Delhi                            Sr.  Web Developer
(Apr 2012 –Mar 2015)
As part of client’s requirement gathering team so creating and designing the structure of application as well as database objects, their relationship and dependencies on papers.
Directly involved in coding part and writing logics for multiple applications. There are multiple projects are there to handle individually and maintaining servers and load balancing also.
Writing SQL queries, stored procedure, Jobs, cursors and trigger auto mails through mail management within SQL server agent. Also, major the performance of queries.
Cooperate with the construction manager to ensure the design and construction quality.
Review the codes and database designing of juniors. Also, deliver the optimized code and SQL queries and analysis the multi-level dependencies in application and database and server based.
Responsible for all application and database level support. Generates the multiple reports on application level.
Dass Infotech, Delhi                            Software Developer
                                                                            (Jan 2010 – Mar 2012)
Writing SQL queries and providing database and application support.
Monitoring the data and performance, also providing data to client on their requirement and coordinate with them.
EDUCATION
Uttar Pradesh Technical University Lucknow2006- 2009
Master of Computer Application (MCA) from Dr. K.N.M.I.E.T Modinagar (Ghaziabad).
  
Dr. R.M.L. Awadh University                                2002- 2006
B.Sc. from K.N.I.P.S.S, Sultanpur (U.P.)                                                                                                                            
TECHNICAL SKILLS
ASP.Net Using C# 3.5/4.0/4.5,
MVC
Entity Framework
SQL Server 2018/2014/2012/2008, MongoDB
Web API, Web Services, Window Services
Angular, Ajax, JavaScript, jQuery, SignalRIntegration of different type of payment gateway (like PayU, RazorPay, CCavenue, Cashfree, EBS etc.) and shipping service Api 
PROJECT 
http://www.dabur.com/http://daburhonitus.com/https://www.daburshop.com/https://www.dabur.com/odomosprotect/https://www.dabur.com/realfruitpower/https://daburarogya.com/https://preciousplatinumindia.mobi/https://one8select.com/https://www.wonderlandgarden.in/https://dreaminkohler.co.in/https://edge.canon.co.in/canonreuniontrips/https://edge.canon.co.in/photomentor/https://edge.canon.co.in/gettheedge/https://edge.canon.co.in/clubelite/https://edge.canon.co.in/eflenses/https://edge.canon.co.in/photomarathon2019/
https://matrimonypartner.com/index.aspxhttps://www.irsofficersonline.gov.in/https://themstoreindia.com/http://www.unmix2mix.com/http://schoolofdesignmarketing.com/https://paybackgames.in/jumpee/
https://paybackgames.in/supersix/http://epay.apollohospdelhi.com/HYPERLINK "https://www.giftcardspread.com/"https://www.giftcardspread.com/
http://www.pearlsofindia.in/http://indonissin.in/http://sunrise.in/http://sghome.in/http://bookmyparty.co.in/https://www.aashirvaad.com/https://playandwinatpayback.in/https://paybackindianpointsleague.com/https://www.scoopwhoop.com/30yearsofgif(http://www.afaqs.com/news/story/51007_A-look-at-ScoopWhoop-Dentsu-Webchutneys-campaign-for-GIF-a-30-year-old-image-format)
Also I worked for many brands like Canon, Dabur, One8select (Virat Kohli Project ), Pernod Ricard (Imperial Blue, Blenders Pride, Royal Stag), Havells , Suzuki, EXL, DS group, Monster, Aashirvaad, Bacardi, Airtel, Apollo Hospital, Gatsby India, Hitachi, Indonissin, Kohinoor, IndusInd Bank, Market99,Payback  etc. 
LANGUAGES
English
Hindi
PERSONAL DOSSIER
Date of Birth               :- 25 June 1986
Material Status           :- Unmarried
ANURAG SONI
