AMIT KUMAR GUPTA
**********@*******.***
Phone: 310-***-****, 424-***-****
________________________________________
OBJECTIVE
I am seeking an opportunity that will challenge my talents and enable me to make significant contributions. I desire to work in stimulating team environments that promote the inter-change of ideas.
SUMMARY
• Around 7 years of experience in software development life cycle which includes Requirement Study, Analysis, Design, Development, Integration, Re-Engineering, installation, implementation, testing, configuration management, maintenance and production support of various client/server, N-tier and web applications.
• Delivered multiple consulting roles during career including Senior Software Engineer and Programmer/Systems Executive for various mission critical applications.
• Expertise in design and development of Object Oriented n-tier applications using .NET Technologies (VB.NET, C#, ADO.NET and ASP.NET), Web Services, WCF, TFS, SQL Server-2000, Oracle 9i/10g, VB, IIS Web Server, ASP, HTML/DHTML, VB/JavaScript, JQuery, Linq, AJAX, and Crystal Reports etc.
• Experience in working on Single Sign-On, SOAP, WSDL, XML, Web Services and WCF.
• Extensive experience in production support by developing various monitoring tools, production support monitoring scripts, alert escalation, and closely working with customer support teams.
• Strong analytical and conceptual skills in database design, development, writing Stored Procedures, complex SQL, and Triggers with various RDBMS databases.
• Experience in leading project teams onsite / offshore model.
• Extensive experience in Investment Banking, Aviation industry, Transportation, Healthcare and Manufacturing domains.
• Ability to quickly understand business requirement and architecture to help come up with robust solutions and have good experience in Performance Optimization.
• Flexibility to work under various environments and desire to work and learn different Upcoming Technologies.
TECHNICAL SKILLS
Operating Systems Windows NT/2000, XP and Linux
RDBMS Microsoft SQL Server (7.0/2000), Oracle 9i and MS Access
Languages VB.Net, C#, C++, Java, VB. 6.0
Query Languages SQL/PL SQL
Web/App Servers Microsoft IIS 6.0/7.0
Web Technologies HTML, DHTML, DHTML, CSS, VB Script, JavaScript, XML, XSL, DOM, ASP, ASP.NET, Web Services and WCF
Methodology OOPS
Source Control Configuration Management using TFS and Microsoft Visual Source Safe
Databases Connectivity ADO, ADO.NET, ODBC/JDBC
Tools Editors Visual Studio .NET, OpenSSL, AJAX, JQuery, Linq, SQL Plus, TOAD, SQL Developer
Report Writer Business Object, Crystal Report
Domain Knowledge Investment Banking, Legal Advisory, Aviation industry, Transportation, Healthcare and Manufacturing domains etc…
PROFESSIONAL EXPERIENCE
Client: Baker Robbins & Company, Los Angeles, USA Duration: Oct 2011 to till Date
Project: Budget Management Domain: Legal
Description:
A Baker Robbins & Company project, responsible for the design of the “BRCo AFA Suite”. The suite is comprised of a core module that includes matter and portfolio budgeting and project management.
The software will provide the following functionality:
• Matter pricing at the matter, phase and task levels
• Pricing adjustments by various methods (risk/reward, fixed amounts, etc.) at each level
• Pricing at the matter portfolio level
• Pricing for fees, disbursements and external costs
• Budget versions and change tracking
• Dashboard style reporting and monitoring for budgets at the matter, portfolio and client levels
• Data integration with financial systems and other systems
• Ability to create project plans at the matter, phase, task and activity levels
• Task assignment to internal and external resources
• Task completion tracking
• Scope change reports
Responsibilities:
• Understand the Client requirements and documented the technical specifications.
• Involved in the Design Document, SRS, Coding and Debugging.
• Developed production support monitoring scripts, and alert escalation
• Written multiple batch jobs to be scheduled in Active Batch.
• Involved in Preparation of Unit Test Cases and Module Level Test Cases.
• Integration and System Testing.
• Communicating with the team and reporting of daily activities directly to the client.
• Coordinating with Project and Software Quality Assurance (SQA) teams.
• Prepared the SR document for QA and Production deployment.
• Used MS TFS for Source Control and Version Management.
Technologies: C#, ASP.NET, ADO.NET, XML, Linq, JQuery, Ajax, Active Batch and SQL Server 2008.
Client: Cetera Financial Group, Los Angeles, USA Duration: August 2010 to Sep 2011
Project: Folio Dynamix Domain: Financial Services
Description:
The goal of this project is to deliver an integrated web environment to Cetera (Advisors, Assistants and Home Office employees) which provides a rich user experience with the process of allowing user to access multiple Folio Dynamix services with a single login (FDx SSO).
And Folio Dynamix application would merge in an IA3 (Integrated Americas Adaptive Architecture) application frameworks so that Cetera business users may get access to Folio Application as per there role in the system.
As part of this project Cetera business users Hierarchy and access files would send to Folio Dynamix by automated nightly batch process from IA3 application framework; this allows Folio Dynamix to build Reps#, OSJ Office, Sales Branch, Region relationship in there system.
Responsibilities:
• Understand the Client requirements and documented the technical specifications.
• Involved in the Design Document, SRS, Coding and Debugging.
• 24x7 production support.
• Developed production support monitoring scripts, and alert escalation
• Generated the self-sign certificate using OpenSSL.
• Written multiple batch jobs to be scheduled in Active Batch.
• Involved in Preparation of Unit Test Cases and Module Level Test Cases.
• Integration and System Testing.
• Communicating with the team and reporting of daily activities directly to the client.
• Coordinating with Project and Software Quality Assurance (SQA) teams.
• Prepared the SR document for QA and Production deployment.
• Used MS Visual Source Safe for Source Control and Version Management.
Technologies: C#, ASP.NET, ADO.NET, XML, OpenSSL, Active Batch and Oracle 9i.
Client: ING, El Segundo, USA Duration: Jan 2010 to July 2010
Project: Licensing Renewals Domain: Advisory
Description:
Licensing Renewals is an application used by the ING Broker Dealers, Regions, Sales Offices & Reps of ING to Review/Renew their Renewal/Registration every year by paying particular amount based on the states they want to register (or) want to do business with ING. This involves study of their existing applications written in diverse technology platforms like VB, SQL Server and proposing a new architecture and design for the migration and maintenance of these applications to Microsoft.NET and Oracle 9i platform.
Responsibilities:
• Production support and alert escalation.
• Real time production servers monitoring, working with client/management on issues resolution.
• Reviewing of System Requirements for new enhancements.
• Analyzed the existing application code.
• Identifying gaps in the existing application and providing feedback to the client.
• Communicating with the team and reporting of daily activities directly to the client.
• Migration of VB and SQL Server application into .NET and Oracle 9i.
• Responsible for Unit and Integration Testing's of the various components.
• Used MS Visual Source Safe for Source Control and Version Management.
• Was recognized as the Best Performer for the contributions made in this project.
Technologies: C#, ASP.NET, ADO.NET, AJAX, XML and Oracle 9i.
Client: ING, El Segundo, USA Duration: Jan 2008 to Dec 2009
Project: Smartworks (Advisors Networks Division) Domain: Advisory
Description:
The goal of this project is to deliver an integrated web environment for ING AN and IFA Advisors, Assistants, and Home Office employees via enterprise portal technology, a centralized data repository, and enhanced reporting & analysis.
IAN Advisors Network (AN) and Financial Advisors (IFA) are valuable distribution channels for ING sales. Architecture of ING Smart Works application has been developed following IA3 (Integrated Americas Adaptive Architecture). The architecture frameworks helps reusability & faster development time by hiding implementation details for technical components and frequently needed business information.
Responsibilities:
• Analyze the requirements and documented the technical specifications.
• Involved in the Design Document, SRS, Coding and Debugging.
• Involved in Preparation of Unit Test Cases and Module Level Test Cases
• Integration and System Testing.
• Conducting the Peer Reviews.
• Coordinating with Project and Software Quality Assurance (SQA) teams.
Technologies: C#, ASP.NET, ADO.NET, XML and Oracle 9i
Client: ING Vysya, New Delhi, INDIA Duration: Jan 2006 to Dec 2007
Project: DS-IRD (Derivative Solutions) Domain: Investment Management
Description:
This project is being carried out for ING, a Leading Investment Banking and Asset management provider in United States, for its Investment management system. This involves study of their existing applications written in diverse technology platforms like VB, SQL Server and Access and building a new architecture and design for the migration and maintenance of these applications to Microsoft.NET and SQL server platform.
Responsibilities:
• Reviewing of System Requirements for enhancements.
• Analyzed the existing application code.
• Communicating with the team and reporting of daily activities directly to the client.
• Migration of VB and SQL Server application into .NET and Oracle 9i.
• Responsible for Unit and Integration Testing's of the various components.
• Used MS Visual Source Safe for Source Control and Version Management.
Technologies: VB.NET, ADO.NET, XML and SQL Server 2000
Innovative Systems & Computers Ltd., New Delhi, INDIA Apr 2005 – Dec 2005
Client: KLM Royal Dutch Airlines, Netherlands Duration: November 2003 to May 2005
Project: Fare Control System Domain: Aviation Industry
Description:
The Fare Control System is being designed as an important Revenue Integrity Tool for the Airline Industry for overseas Clients.
The system provides the complete set of facilities from the Entry of Deals/Contracts with all their complexities, Import of Sales/Refund information via the import of the BSP HOT files, Matching of Tickets to Deals to Generation of ACM/ADMs for settlement with the Agents.
BSP Import System allows the import of Sales and Refund Tickets data from a standard BSP HOT file format into the system database for analysis.
The System keeps the Sales and Refunds tickets data for multiple countries at the same time. It is possible to change over from one country to another from the menu. It computes the Ticket Prorate amount. Supports extensive MIS Analysis on the BSP Import data.
This system provides following key features:
1 Computerization of “Sales & Order System”
2 Generation of Quotation
3 Generation of Various Reports (Sales & Refund detail/summary, credit card sale, mismatched tickets etc…)
4 Facility to view tickets, view refunds
5 Online “Mismatched Tickets” analysis
6 Generation of ACMs/ADMs
Responsibilities:
• Participated in Analyze the requirements and documented the technical specifications.
• Involved in the application Code development & Unit testing.
• Built Prototype and demonstrated the User Interface to team members.
• Written and executed Stored Procedures on the Back-End using SQL and PL/SQL
• Review and Walkthroughs of Design Artifacts & Code.
• Involved in Preparation of Unit Test Cases and Module Level Test Cases
Technologies: C#, ASP.Net, ADO. NET, Crystal Report and SQL SERVER 2000
S.O.Infotech Pvt Ltd., Noida, INDIA Jan 2004 – Mar 2005
Project: HealthCare Information & Management System (HIMSYS) Duration: July 2004 to Mar 2005
Client: Info Cart Pvt. LTD. Domain: Healthcare
Description:
This System provides the management, medical practitioners and the various other staff of modern facilities linkage with various information for decision making and better communication environment. This system operated via web interfaces and window interfaces. HIMSYS provides electronic medical report, issue tracking and workflow management, together with reporting; it handles both administrative and clinical information.
Responsibilities:
• Analyze the requirements and documented the technical specifications.
• Involved in the Design Document, SRS, Coding and Debugging.
• Involved in Preparation of Unit Test Cases and Module Level Test Cases
• Integration and System Testing.
• Code walks through and Code reviews.
• Coordinating with Project and Software Quality Assurance (SQA) teams.
Technologies: VB.NET, ADO. NET, ASP.NET and SQL Server 2000
Project: Advance Reservation System (www.kmvnres.org) Duration: Jan 2004 to Jun 2004
Client: Kumon Mandal Vikas Nigam Domain: Tourism
Description:
This web site was designed for Kumaon Mandal Vikas Nigam; to publish information about the Mandal owned Guest Houses that may be of use for the tourists. System provides online booking facility also, apart from the currently available information, such as, locations, types of accommodation, facilities available, number of rooms etc. It’s implemented as an n-tiered solution.
Responsibilities:
• Contributed to System analysis & design by creating class and Sequence diagrams.
• Involved in the Design, Development, and Implementation and testing.
• Developed Data Access Objects (DAOs) to access data from the database.
• Built Prototype and demonstrated the User Interface to team members.
• Written and executed Stored Procedures on the Back-End using SQL and PL/SQL
• Review and Walkthroughs of Design Artifacts & Code.
• Involved in Preparation of Unit Test Cases and Module Level Test Cases
Technologies: ASP, VB Scripting, JAVA Scripting and SQL Server 7.0
Academic/Professional Qualification:
1 Two years “Professional Diploma in Software Technology” (DNIIT) from National Institute of Information Technology (NIIT) Delhi in 2002.
2 Post Graduate Diploma in Computer Application (PGDCA) from Indira Gandhi National Open University (IGNOU).
3 Certificate in Computing (CIC) from Indira Gandhi National Open University (IGNOU) in 2000.
4 . NET Certification from (Ducat Info Pvt. Ltd.) in 2004 that covers VB.NET, C#, ADO.NET, ASP.NET, Web services, XML.
5 Graduation in Commerce from C.C.S. University, Meerut in 1997.
Accomplishment
Got the “Production Support recognition award” from client (ING - USA) for extraordinary efforts and contributing beyond the daily responsibility, as a result substantially improving several key metrics for ING business.