Akhil Agarwal (MCA) E-Mail:
*************@*****.***
*************@*****.**.**
Summary
V 9.5 years experience in the IT Industries.
V 2 years experience in handling team of size 3-6.
V 1.5 years experience for making estimation and initial assessment of the
project.
V 2 years experience for Requirement gathering, creation of all type of
documents (SRS, FRS, HLD, LLD, Installation).
V Have an good experience of Design Patterns.
V 2 years experience in .NET 4.0.
V 2 years of experience in developing WCF application.
V 2 years of experience in programming with .Net Framework 3.0/3.5 using
C#, ASP.NET, Web Services.
V 4.5 years of experience in programming with .Net Framework 1.1/2.0 using
C#, ASP.NET, Web Services, VB.NET, Window Application.
V Have good experience in LINQ, LINQ-SQL.
V Have a good experience in using Log4Net (A tool to log a various debug
level message during development and deployment phase).
V Expose to each of the phases of Software Development Lifecycle (SDLC) and
experience to work as an individual performer under the large development
groups.
V Have a good experience in creating Reports in SSRS 2005/2008.
V Developed projects with incremental process and Water Fall process.
V Have an experience to develop application front-end using ASP.NET, AJAX,
JavaScript, CSS, C#.NET and VB.NET.
V Have a good experience to develop middle tier and data access layers
using C#, Entity Framework, ADO.NET, Web Services, VB.NET, and XML.
V Experience in designing and creating table/views, writing stored
procedures, triggers against SQL SERVER 2005/2008.
V Have an experience to handle web servers IIS 5.1/6.0.
V Have a very good experience on application development tools (IDE) like
Microsoft Visual Studio 2010/2008/2005/2003.
V Used Source Control Tools TFS, VSS, Clear Case and SVN.
V Have an experience of Microsoft VISIO to Design Diagrams.
V Key member of .NET Competency center.
Educational Qualification
MCA from U.P. Tech. Unv. Lucknow, U.P in 2004.
Technical Competencies
Language Skills C#.Net, VB.Net, T-SQL
Web Technologies ASP.Net, HTML, CSS, XML/XSLT
Scripting Language Java Script
RDBMS MS-SQL Server
Reporting Tool SQL Server Reporting Services 2005, High Charts
Knowledge on WorkFlow, WCF, WebServices, AJAX, MS Project 2003
Tools and Technologies VS 2005/2008/2010, VSS, TFS, CC
(ClearCase), CQ (ClearQuest)
Web Server IIS
Career Summary
Working as a Developer Analyst in AON Hewitt, Gurgaon from May
2011 to till date.
Worked as a SSE in IBM India Pvt Ltd., Gurgaon from July 2009 to
May 2011.
Worked as a SSE in Satyam Computers, Bangalore from Nov. 2007 to
July 2009.
Worked as a Project Engineer in Polaris Software Labs Ltd,
Chennai from Dec. 2006 to Nov. 2007.
Worked as a SSE in Aurva InfoTech Pvt Ltd, Bangalore from Sept. 2004
to Dec. 2006.
Projects Undertaken
Project # 1 Risk Analyzer (Tracker and OutLook Application)
Company AON Hewitt, Gurgaon
Duration 34 Months (May'11 - Till date)
Technology used .NET 4.0, Entity Framework, LINQ, C#, ASP.Net,
SQL Server, Telerik, ASPOSE, WCF
Team Size 15
Description Risk Analyzer (RA) is a part of the Global
Retirement application portfolio. Risk Analyzer brings together Pension
Outlook, Online Tracker and the Quarterly Dashboard report into a best-of
breed online web application that not only provides a unified client
experience but was built as a leverage-able, long-term global foundation
that provides for future development and enhancement. Multiple data inputs
from various valuation systems (Pro-Val) are dynamically combined using a
custom calculation engine built into the Risk Analyzer product.
Role Module Lead
Responsibilities
. Coordinate with Onshore Architect and understand the requirement
. Ownership to the Tracker module
. Code Review and ensure standards are followed
. Task allocation and estimation
. Tracking and monitoring the project as per the plan
. Mentoring to new Team Members and giving technical guidance
. Involved in coding and ensure QA verified
Project # 2 EPM (Enterprise Project Management)
Client Bharti Airtel, Gurgaon
Company IBM India Pvt Ltd., Gurgaon
Duration 21 Months (Aug' 09 - May' 11)
Technology used WSS 3.0, Project Server 2007, PWA (Project Web Access),
C#, ASP.Net, SQL Server 2005, SQL Server Reporting
Services 2005
Team Size 14
Description EPM solution for strong team coordination,
standardization in managing projects and programs and centralized resource
management, as well as high-level analysis and reporting. It helps to
organization gain visibility, enhances decision-making, improves alignment
with business strategy, and maximizes resource utilization and increase
operational efficiency.
Role Development, Customization, SharePoint/EPM Developer
Responsibilities
. Development of Web Parts, Features, Scheduler Jobs, Solutions Using
SharePoint Object Model and SQL Server
. Development of Custom utilities and integrating with Product
. Development of SSRS reports and integrated with Portal
. Tracking bugs reported and releasing the fixed code
. Customer interaction and requirement gathering
. Mentoring team members and giving technical guidance
. Involved with multiple Dot NET projects at Bharti
Project # 3 SNOBS
Client Syniverse Germany
Company Satyam Computers, Hyderabad
Duration 10 months (Oct' 08 - July'09)
Technology used C#, ASP.Net, SQL Server 2005
Team Size 2
Description Syniverse provides the Messaging, Roaming, Network &
Database and Business Intelligence Telecom solutions. In roaming solutions,
it simplifies business relationship and bridge technical gaps among world
wide roaming partners while processing operator interactions.
The purpose of this application to maintain the call records between
home and visited operator according to service agreement and finally
generates the reports. This also maintains a powerful pricing service
helping operators maximize revenue by viewing the effects of new roaming
tariff strategies on billing records.
Role Coding, Client Interaction, DB design, UI design
Responsibilities
. Analyzing the requirements document sent by the business
. Development and Maintenance of Web UI Screens and database Objects
. Identify and recommend solutions for the shortcomings of the existing
system
. Tested the Application by Unit Testing
Project # 4 Integrated Digital Media Framework (IDMF)
Client Arvato System, U K
Company Satyam Computers, Bangalore
Duration 9 months (Dec' 07 - Aug' 08)
Technology used C#, ASP.Net, SQL Server 2005, MarkLogic Server
Team Size 12
Description The purpose of this framework is to convert the data in
XML format using MarkLogic server. It provides an interface to communicate
with MarkLogic. Application provides the functionality to upload the data
and assignment to particular editor and finally publish it. We can convert
the data in appropriate format. This framework also implements the digital
rights on data (Text, Rich media and Image).
Role Development, Customization and Support
Responsibilities
Capture Business requirements
. Developing prototype in conjunction with the requirements
. Technical inputs and guidance
. Involvement in the designing phase
. Development of Web UI Screens and database Objects
. Code Review
. Ensure Standards are followed
. Ensure smooth release to the UAT
Project # 5 Material Scout
Client Sidoun, Germany
Duration 7 months (May' 07 - Nov' 07)
Technology used C#, ASP.Net, SQL Server 2005
Team Size 05
Description The purpose of this application is to facilitate the
suppliers and planners. This is a combination of web and window based
application. This has two modes (designer and user). The design mode for
Suppliers and user mode for Planners.
The planners can select right product from right suppliers. There is a
separate windows application for suppliers. The suppliers can upload their
products in the windows design page at run time and can see the preview
display in Internet explorer. The planners select the products from
Material Scout (user mode) and send the relevant information to NetBau.
Role Senior Developer
Responsibilities
. Analyzing the requirements document
. Development of XSD and XML for converting Windows form to Web form
. Development of customize Interface for creating Windows at run time
. Development of Web UI Screens and database Objects
. Used XML to save the supplier-designed page for the project
. Support the testing phase
Project # 6 Project Management Portal
Duration 3 months (Feb' 07 - April' 07)
Technology used SharePoint 2007
Team Size 05
Description The purpose of this portal is to find out the information
about projects and resource utilization. They can see all the information
about the projects like project period, revenue, resource utilization, and
profit from the projects. They can see all the information in the charts.
They are able to see the entire information yearly, monthly or weakly
basis. Using this application they can find out exact proficiency of our
company regarding our project.
Role Developer
Responsibilities
. Implementation of the latest features of SharePoint2007.
Project # 7 Risk Management
Client Blackburn Group, Inc. New York
Duration 11 months (Feb' 06 - Dec' 2006)
Technology used VB.Net, ASP.Net, SQL Server 2000, Crystal Report 10
Team Size 06
Description Risk Management is a web-based business application. This
product is to manage the risk and benefit of various processes in an
organization. There are different types of organization that are using this
product. Some are insurance companies others include utility companies,
electricity companies, shopping centers, automobile insurers and many
other. Using this software these companies can track their risks and assess
their benefits.
Role Senior Developer
Responsibilities
. Developed various front-end screens to facilitate the user to enter
and manipulate data using ASP.NET and VB.NET.
. Developed a user control screen using datagrid control with paging and
implemented the custom style to display the data in datagrid.
. Implemented screens using 3-tier architecture.
. Developed Business Action Classes and Data Access Classes on server
side based on use cases.
. Created Stored Procedures, Triggers and Cursors that are used in the
application using SQL Server 2000.
. Implemented the Exception Handling Mechanism using Microsoft
Application Block. Used text files to store the exception details.
. Tested the Application by Unit Testing.
Project # 8 Help Desk Management
Client Tech Solution, Boston
Duration 8 months (July' 05 - Feb' 06)
Technology used C#, ASP.Net, SQL Server 2000
Team Size 03
Description Help Desk Management is a web-based business application.
This project is to manage the process of manpower assignment to an
organization. This project contains separate module for Administration,
buying hours (Ticket generation) and assignment manpower. This project
deals with trading of man-hours. It gives the easy way to managers who
manage clients, sale hours, recharge hours, assignment manpower and
verifies the tickets.
Role Developer
Responsibilities
. Involved in the analysis and design of the GUI & Functional aspects
of the application using ASP.NET and C#.
. Incorporate changes both at database level and front end
functionality to meet the business requirements
. Involvement in the designing phase
. Complete ownership of modules
. Used ADO.Net Architecture to manipulate and retrieve data from the
database.
. Developed Business Action Classes and Data Access Classes on server
side based on use cases.
. Created Database objects like tables, Stored Procedures and
Triggers in SQL Server.
Project # 9 Lansoft Project
Duration 10 months (Sep' 04 - June' 05)
Technology used VB.Net, ASP.Net, MS - Access
Team Size 04
Description Lansoft is a web-based project that runs on call center
LAN. This project contains separate module for sale, resale, verification
and activation department. This project deals with trading of calling
cards. It gives the easy way to campaign members of call center who sales,
recharge, verifies and activate the calling cards.
Role Developer
Responsibilities
. Involved in the analysis and design of the GUI & Functional aspects
of the application using ASP.NET and VB.NET.
. Implemented the Client Validations using JavaScript.
. Used ADO.Net Architecture to manipulate and retrieve data from the
database.
. Involved in Testing of the application with different sets of
inputs.
Personal:
Current Address : House No 476, 2nd Floor, Sector - 10 A, Gurgaon,
Haryana - 122001
DOB : 30th Aug 1978
Contact No : 991*-***-***
Martial status : Married
Gender : Male
Passport # : F7866823 (Valid up to 14/05/2016)
Email : **********@*****.***, *************@*****.**.**
(Akhil Agarwal)
[pic]