Summary:

• 12 years of sound experience in designing, developing, testing, packaging and deploying Databases & Applications on Microsoft platform
• The experience includes my association with a wide range of clients including PFIZER, MONSANTO, BAYER, JOHNSON & JOHNSON, TATA AIG INSURANCE, REFRIGERATED TRANSPORT TECHNOLOGY, MERRILL LYNCH, CITI Group
• Experience in business of ordering and managinginventory, planning for production and sales, supplying inventory to different location, formatting and printing different documents for the transactions.
• Experience in finance business for Equity trading, settlements, reconciliation, pricing of stock and performance.
• Extensive experience in working with Visual Basic,Active Server Pages (Classic ASP), VB.NET, C#, ADO.NET, ASP.NET, Web Services, XML, VB Script, Java Script, HTML, Database programming, and Active Server Pages, Component Object Model (COM).
• Experience in development and maintenance for Internet and Intranet environment.
• Experience in designing and implementing business objects and creating reusable assemblies.
• Experience in migrating and converting standard applications into .Net Applications
• Experience in Graphical User Interface (GUI) Design and GUI Modeling.
• Expertise in developing and supporting in WIN Forms and Web Forms
• Expertise in working with and designing RDBMS, SQL Server 2000/2005/2008, SQL Reporting, Oracle 10G, MS Access, Sybase databases
• Reporting Tool Business ObjectsX1 Release 2.
• Knowledge of various software development life cycles (water fall model, incremental mode)
• Knowledge and experience of Business Process Management(BPM) for effective and efficient development.
• Sound understanding of Release Management.
• Experience in Technical Writing: Functional and Technical Specifications and other relevant documentation.
• Has good understanding of Technical Trends, Architectures and highly motivated to know more about current events, new software and products within the market
• Good understanding of Object Oriented Concepts
• Worked on Investment Management, Wealth Management and Asset Management in financial domain.
• Experience of different Structured Products like Asset-backed Securities (ABS) and Collateralized Debt Obligation (CDO), Mortgage-Backed Securities (MBS), Bonds.
• Knowledge of Common Application Block of Microsoft Enterprise Library.
• Knowledge and experience on Test Driven and Design Driven Development & NUnit Testing.
• Sound analytical ability with excellent troubleshooting skills.
• A fast learner curious to know, learn and implement new things

Technical Expertise:

Internet Technologies: Classic ASP, ASP.NET, ADO.NET, VB.NET, C#, ASP.Net MVC 2, XML, XSL, XSLT, XPATH, VBScript, HTML, JavaScript, Web Form, WPF, XAML, Web Service, SOAP, WCF, Generics, JavaScript, AJAX, JSON, CSS, Flex 3.0, MXML, ActionScript 3.0, Resharper 5.1
Languages : C, C++, C#, VB, T-SQL, PL/SQL, Powerbuilder, AS/400 - RPG, RLU, CL .
Databases/Tools: DB2, MS-Access, SQL-Server 2000/2003/2005/2008, Oracle 7/8i/10G, Sybase, SQL Advantage, TOAD, SQL Query Analyzer, Oracle Sql Developer 1.2.1.
Operating Systems: Windows NT/95/98/2000, Unix, Shell Scripting, Linux and MS-DOS.
Configuration Mgt. Tools: Team Management System (TFS), Visual Source Safe (VSS), PVCS, Rational Clear Quest, Rally
Web Servers: Microsoft IIS.
Tools: Visual Studio.NET 1.1/2.0/3.5, Visual Studio 2000/2003/2005/2008, Visual Interdev, Crystal Reports, Microsoft SQL Reporting Services, Infragistics
Other Applications: MS-Office

Education:

• Master's Degree in Computer Science (Masters in Computer Application)
• Post Graduate Diploma in Computer Applications (PGDCA)
• Bachelor of Commerce

Professional Experience:

Confidential, New Jersey Sept'11 - Till Date

Senior .Net Consultant

Description: Development of products in finance risk and compliance area. Actively involved in product analysis, Designing and Development. This product is used to reconcile OFAC sanction party information with client system. Product creates report stating differences between latest OFAC list and client OFAC database. Product creates alerts to notify banks on specific suspicious activities.
Bank Participate in automated money transfer process as Originator's Bank, Beneficiary's Bank or Intermediary Bank in other transaction. As intermediary bank, they are supposed to keep information for all previous parties who participated in transfer. Travel Rule product validates electronic information received for each transfer, rejects the transaction if info. is not satisfactory. Provides UI and service to take care this functionality

Responsibilities:

• Provide technical leadership in software development as per project needs
• Coordinate with business analyst and end users for new requirements
• Develop Technical requirements and relevant documentation
• Track technical requirements and facilitate technical resources to ensure project meets with required deadlines
• Develop codes in accordance with technical requirements
• Work on Front End, Middle Tier and Back End code. Create installable setup for the product which can be used at any vendor location.
• Vendor specific enhancement in the product.
• Responsible for working with various testing teams (business, QA ) to develop various testing scenarios
• Coordinate and perform system Integration and Testing
• Perform Production support activities

Environment: C#, ASP.Net MVC 3.0, WCF, XML, HTML, CSS, Jquery, IIS, Visual Studio 2010, SQL Server 2008, T-SQL, Visual Source Safe

Confidential, New Jersey Dec '10 - Aug 11

Technical Lead

Description: Confidential, web sites, is developed for the customers to access banking account and perform transaction online. It allows all users to access their different accounts individually or in group. This allows to customer to access their securities, assets, Credits, check images for deposits and returns, deposit slips images. Also provide various customer friendly facilities and information for effective use of website.

Responsibilities:

• Provide effective onsite-offshorecoordination to meet with project requirements
• Provide technical leadership to the offshore teams for software development as per project needs
• Coordinate with Customer Experience teams and Line of Business for new requirements
• Coordinate with various technical groups for the project development.
• Develop Technical requirements and relevant documentation as per customer needs
• Track technical requirements and facilitate technical resources to ensure project meets with required deadlines
• Develop codes in accordance with customer's technical requirements
• Ensure proper configuration management of codes developed
• Use of Mocking and Moq library for unit test
• Dependency Injection with structuremap
• Work with Dev. Team & other teams like Framework, Middle tier, UI Consolidation to perform effective scheduling of the project tasks considering dependencies/constraints
• Responsible for working with various testing teams (business, QA ) to develop various testing scenarios
• Coordinate and perform system Integration and Testing
• Perform Production support activities

Environment: C#, ASP.Net MVC 2.0/3.0, HTML, IIS, Visual Studio 2008, Resharper 5.1, SQL Server 2008, T-SQL, Quality Center, JavaScript, Ajax, JQuery, CSS

Confidential, (Merrill Lynch, New Jersey) May '10 - Dec 10

Sr.Net Developer

Description: Confidential, is developed for bank and call center to handle service requests effectively with BPM system. Smarts deal with different business areas like Account Opening, Account Maintenance, Account Closure, ATM, CD IRA, Checks, Commercial Loans, Credit Card, Indirect Loans, Line of Credit, Mortgage Loans, Wire Transfer etc.
It helps to create and maintain requests of customers for above mentioned businesses. Get updates of requests via data sync from BPM process.

Responsibilities:

• Agile methodology followed for development. Rally tool was used to track User Stories and Development progress.
• Maintaining status of User Stories and Task in every day scrum call.
• Developed user Interfaces using Web Form as per system requirement.
• Created business entities, business logic, Data Contract, Service Contract in service layer.
• Store procedure call are made using ADO.Net.
• Used Data Caching to put lookup values and redundant used data in cache, which gets refreshed periodically.
• Used caching on the page whenever required in the system.
• Implemented service level validation which allows other system to access services and enter valid data.
• Maintaining business objects and assemblies.
• Development web form using master page, Update Panel, Script Manager in .Net 3.5
• Implemented Form and role basedsecurity and authorization in systems.
• Participated in creation and consumption of WCF Services which contains Data Contract, Service Contract.
• Cascading Style Sheets (CSS), Theme used for consistent look of the site.
• Unit Test created for UI and Services for all use case.
• Unit testing and integratedtesting of development.

Environment: C#, ASP.Net 3.5, ADO.Net, SQL Server 2008, T-SQL, Web Form, Windows Communication
Foundation (WCF), HTML, CSS, IIS, Ajax, JavaScript, Jquery, Linq, Stored Procedure, Visual Studio 2008, Team Foundation System (TFS), Rally (Requirement and Task tracking), Resharper 5.1, Quality Center

Confidential, New Jersey Oct '09 - March 10

Sr.Net Developer and off-shore coordinator May '08 - Sep '08

Description: Project Tracking System Workspace (PTS-W) is project management tool for internal city projects, which contains Initiative, Program, Project modules containing finance and document details for each module. This system also contains Time Reporting Module (TRS) for tracking number of hours worked by employee for each project. This also allows creating Work Order for new employees/consultants.
Critical Initiative Review (CIR) Milestone is system developed to maintain Initiatives taken by organization. Under each initiative there could be multiple programs and each program can have multiple projects to achieve initiated goal. Each program has certain start and end date, which is based on start, and end dates of all the projects in it and status of program changes as it completion progresses.
SDLC (Software Development Life Cycle) is system maintain to keep complete information about Projects and its lifecycle documents. This system keeps global Citi Project information. There are multiple users with different rights for each project like Business Program Manager, Technology Program Manager, and Technology Program Administrator etc
Budget system is developed to manage estimated and incurred expense on each Initiative-Program-Project level. Many times Program budget is shared by multiple departments/organization (or P & L A/C) in certain percentage ratio. This system helps to plan and implement budget for each program-project. System handles budgeting and forecasting for Citi internal projects which comprise accounting, billing, and reconciliation.
Participated in enhancement if CIR Milestone system and development of Budget system. Handled enhancement and change request for systems
Data warehouse contains data from different systems that is used for reporting. Detailed and summary reports are generated based on old and current data for analysis and decision-making on different business issues. Some Reports are generated periodically and distributed to concern group of people.
Worked for Citi Markets and Banking Technology organization and GCOT department

Responsibilities:

• Participated in requirement discussion with client/end user for system enhancements
• Updating Business Requirement Document (BRD) andFunctional Requirement Document (FRD)
• Agile methodology followed for development. Rally tool was used to track User Stories and Development progress.
• Maintaining status of User Stories and Task in every day scrum call.
• Participated in GUI Design and GUI Modeling.
• Developed user Interfaces using Web Form as per system requirement.
• All the user interface layers, web pages are created and integrated to maintain the performance of data flow and data integrity using ASP.NET, Web Server Controls and ADO.NET.
• Maintaining business objects and assemblies.
• Used Ajaxtoolkit controls for client side operations like Calenar Extender, Confirm Button Extender, and AsynFileUpload etc.
• Development web form using Update Panel, Script Manager in .Net 3.5
• Created and updated master page.
• Implemented Form and role basedsecurity and authorization in systems.
• Created web service, WCF to communicate with other systems.
• Participated in creation and consumption of web services, WCF Services.
• Cascading Style Sheets (CSS) was used for consistent look of the site.
• Transforms an XML file to XHTML on the server using XSLT Style sheet.
• Writing Store Procedure, Functions and triggers in SQL Server.
• Created month end process procedures and conversion scripts in SQL Server.
• Used Inner Joins, Outer Joins, Pivot, temporary tables and variables, exception handling in SQL Server.
• Unit testing and integratedtesting of development.
• Co-coordinating with Quality Assurance team for system functionality and performance.
• Co-coordinating with client/end user for changes approvals
• Participated in development promotion in different environments like QA, UAT, Production
• Co-coordinating maintaining versions of the programs.
• Supporting Classic ASP legacy system.
• Used Asp.Net MVC & Linq to create site.
• Supporting client for production data issues and/or human errors.
• Conducted Manual Month-end process for system
• Coordinating for requirement of Reports from Data warehouse in Oracle
• Created and updated Data warehouse reports as per business requirement. Report output is generated on Excel sheet.
• Created and Updated store procedure, functions and package for data transfer from SQL Server to Oracle Data Warehouse.
• Testing Reports output against data warehouse data.
• Followed Business Processes for successful output.
• Production Implementation using standard corporate release management methods.

Environment: C#, ASP.Net 3.5, ADO.Net, SQL Server 2008, T-SQL, JavaScript, AJAX, Web Form, Web Service, HTML, CSS, ASP.NET MVC, Linq, Classic ASP, XML, XSL, XSLT, XPATH, IIS, Sybase, SQL Advantage, ORACLE 10G, TOAD, Oracle SQL Developer 1.2.1, Stored Procedure, Visual Studio 2005/2008, PVCS, Rally (Requirement and Task tracking), Excel.

Confidential, New Jersey Sep '07 - Feb'08

Sr. Developer and off-shore coordinator

Description: Worked on projects for Investment, Wealth Management and Asset Management. Merrill maintains different sites for Finance Advisor (FA), for Administrator (Admin), for Investment Manager (IM) and legacy systems for various business purposes. FA site contains functionality for different products. It allows to request for New Account Enrollment, Manger Change, Title change (new title, new account), or Termination of account etc. Administrator approves/rejects account in different queue based on available info about account. It contains queue like Enrollment/AnQ Queue, Fund Queue, Legal Queue & portfolio approval etc. IM has to approve account in various stages like new enrollment, manager change, Termination etc.
System contains details of equity trading that is buying and selling of stocks. It keeps track of stocks available for buying and selling by customers, also fund queue and approval queue.
System maintained Investment Management and Asset Management details to meet specific goal of the investors and organization. System contains different operations like settlements, reconciliation, pricing of stock and performance. Handled independently enhancement and change request for C#.Net and ASP systems. Worked for Investment and Wealth Management Technology (I & WMT) group

Responsibilities:

• Developed user Interfaces using Web Form as per system requirement (GUI Design).
• Agile Methodology followed for User requirement and development.
• Designing and implementing business objects as well as reusable assemblies.
• Designed different components using C# language for enterprise-level web applications. Built on 3-tier architecture with extensive use of Object Oriented Programming Techniques like inheritance.
• All the user interface layers, web pages are created and integrated to maintain the performance of data flow and data integrity using ASP.NET User Controls, Web Server Controls and ADO.NET.
• Implemented windows and role based security and authorization in systems.
• Used caching on the page whenever required in the system.
• Created and Implemented Stored Procedures & Triggers in SQL Server 2000 and Sybase at the backend level.
• Writing Store Procedure, Functions and triggers in SQL Server.
• Used Inner Joins, Outer Joins, Pivot, temporary tables and variables, exception handling in SQL Server.
• Used JavaScript and Ajax Toolkit Controls for client side validation and operations.
• Cascading Style Sheets (CSS) was used for consistent look of the site.
• Used Web Services to provide data to the other system.
• Transforms an XML file to XHTML on the server using XSLT Style sheets.
• Creating console exe for processing and auto-execution.
• Supporting change request for legacy system developed in ClassicASP
• Participated in system migration & enhancement to CAI (Core Application and Integration) using SCM (Software Configuration Management) standards
• Unit testing of development.
• Maintained system in Internet and Intranet environment.
• Co-coordinating with offshore team for change request development.
• Co-coordinating with Quality Assurance team for system functionality and performance.
• Co-coordinating with client/end user for system changes approvals
• Creating and Updating Business Requirement Specification (BRS)
• Creating and Updating System Implementation and packaging documents.
• Co-coordinating with systemadministration and packagingteam for new system & change request implementation.
• Supporting client for production data issues and/or human errors.
• Managed Business Processes for effective output.
• Production Implementation using corporate release management methods with related documentation.

Environment: C#, ASP.Net, ADO.Net, SQL Server 2005, T-SQL, Sybase, JavaScript, AJAX, XSD, XML, XSL, XSLT, Web Form, HTML, CSS, Classic ASP, IIS, Sybase, SQL Advantage, Stored Procedure, Triggers, Visual Studio 2005, Visual Source Safe, PVCS, Rational Clear Quest.

Confidential, New Jersey Jan '07 - Aug '07

Sr.Net Developer

Description: 'Terminal Operating System' is developed to manage port Terminal operations contain Import,
Export, Vessel, Gate, Yard and Demurrage, Master and Admin Module. Import contains details for Bill of Landing and related functionality, Export contains details of Booking operations, Vessel deals with ship schedule, loading and discharging of containers from ship, Yard deals with spotting of container and chassis in stack, wheel slot, Demurrage deals with Import, Export and storage demurrage, Gate deals with Receive and Delivery of Loaded, Empty containers. Also receive and delivery of bare chassis transactions.

Responsibilities:

• Developed automated reports generation tool using Web Form.
• Developed user Interfaces using Win Form as per system requirement.
• Creating and Using Web Services (WSDL)
• Creating XSD Schemas, creating and reading xml files.
• Implemented Windows and role based security and authorization in the system.
• Designed different components using C# language for enterprise-level web applications. Built on 3-tier architecture with extensive use of Object Oriented Programming Techniques like inheritance, interfaces etc.
• All the user interface layers, web pages are created and integrated to maintain the performance of data flow and data integrity using ASP.NET User Controls, Web Server Controls and ADO.NET.
• Implemented Web services to retrieve information.
• Implemented Stored Procedures & Triggers, Joins and Views in SQL Server 2005 at the backend level.
• Involved in Creating Storedprocedures and providing security using T-Sql.
• Cascading Style Sheets was used for consistent look of the site.
• Used Ajax for client side operations.
• Creating and Updating System Requirement Specification
• Unit Testing

Environment: C#, ASP.Net, ADO.Net, SQL Server 2005, T-SQL, JavaScript, AJAX, Web Services (WSDL), XSD, XML, Web Form, Win Form, HTML, CSS, IIS, Stored Procedure, Triggers, Visual Studio 2003, Visual Source Safe, Team Management System (TFS),

Confidential, New Jersey Jun '05 - Dec 06

Sr. .Net Developer, Off-shore coordinator

Description: Confidential, system is developed to manage in-transit cargo (perishable/nonperishable goods). It maintains information about work orders, units traveling and relevant route/locations. It helps manage instantaneous details of moving cargo container inspections carried out at multiple locations. System also tracks payments to the agents & service providers as well as Invoicing to the customers. It generates reports that helps track cargo Units traveling from Origin to the Destination.

Responsibilities:

• Design & development for system enhancements using Win Form and Web Form.
• Developed user interfaces for data entry and processing using Win Form for local users.
• Used Infragistics Grids on user screens.
• Developed user interfaces for remote user using Web Form.
• Change request resolution, creating system Build, conduct UAT & release new versions to Production.
• Interacting with EDI service partners, providing real time solutions for EDI.
• Implemented form and role based security and authorization in the system.
• Designing/implementing business objects and creating reusable assemblies.
• Designed different components for enterprise-level web applications. Built on 3-tier architecture with extensive use of Object Oriented Programming Techniques like inheritance, interfaces etc.
• All the user interface layers, web pages are created and integrated to maintain the performance of data flow and data integrity using ASP.NET User Controls, JavaScript, Web Server Controls and ADO.NET.
• Created Component Object Model(COM) object.
• Used Multi-Threading for auto executable EDI programs
• Involved in the design of security module that gives access to users based on the roles.
• Configured ASP.NET Web.Config file for the entire web application
• Implemented Web services (WSDL) to retrieve information.
• Implemented Stored Procedures, & TriggersJoins and Views in SQL Server 2000 at the backend level.
• Involved in Creating Storedprocedures and providing security using T-Sql.
• Cascading Style Sheets was used for consistent look of the site.
• Release code into production using standard release management techniques.
• Used SMTP mail class of .NET for the users to send mail

Environment: ASP.NET, VB.Net, C#, ADO.Net, SQL Server 2000, T-SQL, VB Script, JavaScript, AJAX, Web Services (WSDL), Multi-Threading, XML, XSD, Stored Procedure, Triggers, Win Form, Web Form, Classic ASP, CSS, HTML, IIS, Text Files, Infragistics Grids, Visual Studio 2003, Visual Source Safe

Confidential, India Jan'05 - May'05

Project coordinator and Sr. Developer

Description:Confidential, developed to manage different products of company. Agent and customer details are entered in the system. Managing investment portfolio of customers.
'Training Department' at Tata AIG conducts various programs all over India in different locations. This system keeps track of all the scheduled programs, enrolments of each program, arrangement and costing. After completion of program faculty and program evaluation based on participants' feedback is maintained using the system. System also keeps track of enrollment, inventory, fees deduction, grade and all other details of the employees appearing for different national and international insurance exams. This system helps 'Training department' to do all process easily, faster and accurate.

Responsibilities:

• Taking requirements from the target group. Design and complete System Requirement Study (SRS), Take requirement approval from user.
• Development of Web interfaces using Active Server Pages (Web Forms) while usingcollection object, Datasets for managing data.
• Enhancement and Change request of legacy system in Classic ASP.
• Coding done for form and role based security and authorization in the system.
• Creating SQL Stored Procedures & Triggers for data manipulations in SQL Server 2000 database
• Creating Unit/integration Test Plans and unit/integration testing
• Participate in UAT and user management
• Provide post-implementation support
• Coordinate the project effectively
• Configured ASP.NET Web.Config file for the entire web application.
• Involved in Creating Storedprocedures and providing security using T-Sql.
• Cascading Style Sheets was used for consistent look of the site.
• Creating Unit/integration Test Plans and unit/integration testing
• Developed and maintained project in Internet and Intranet environments

Environment: ASP.NET, Classic ASP, VB.NET, ADO.Net, SQL Server 2000, T-SQL, Sybase, VB Script, JavaScript, HTML, IIS, Stored Procedure, Triggers, Web Form, HTML, XSD, Visual Studio 2003

Confidential, Mumbai, India Jan'04 - Dec'04

Role: Technical Lead

Description: 'Sales Consolidation' system is developed to keep track of sales details from company to farmers, as cottonseed is a product. This system captures sales detail from distribution channel. As a statutory obligation company gives certain sale and land cultivation information (seed product) to government agencies and also it needs sales information for its internal MIS purpose. Company sells \'Bollgard\' seeds to its distributors and dealers. They in turn sell to Dealers and growers. To gather complete sales information at one place from other system via excel file and from different areas in the form of \'Forms\' above system has been developed.

Responsibilities:

• Project Management
• Involved in requirement gathering, design and writing Functional Specification and getting approval from user
• Designed different components for enterprise-level web applications. Built on 3-tier architecture with extensive use of Object Oriented Programming Techniques like inheritance
• Development of user interfaces as per specifications using Win Form
• Generated reports using Crystal Reports.
• Writing T-SQL queries and Business logic in Stored Procedures & Triggers for back end
• Unit Testing and Integration testing
• Implementation and UAT
• Implement project in intranet environment.
• User Training

Environment: VB.NET, VB Script, ADO.Net, Crystal Report, SQL Server 2000, T-SQL, Stored Procedure, Triggers, Win Form, XSD, Excel, Web Services (WSDL), Visual Studio 2003

Conference Room Booking Application:
Description: This is an intranet- based system. This system enables member of the organization to make booking for the conference room available to them. Member can make booking two ways - Individual days and Bulk Booking. In individual booking member choose required conference room, date and time slot. If it is available he can book the same. In bulk booking particular conference room can be booked for long duration for a fixed time slot, if it is available.

Responsibilities:

• Involved in design and writing FunctionalSpecification
• Development of user interfaces using Web Form as per specification.
• Configured ASP.NET Web.Config file for the entire web application.
• Coding done for form and role based security and authorization in the system.
• Involved in Creating Storedprocedures & Triggers and providing security using T-Sql.
• Cascading Style Sheets was used for consistent look of the site.
• Unit Testing and Integration testing
• Implementation in Internet and Intranet environments
• Writing User Documentation.

Environment: ASP.NET, VB.NET, ADO.Net, SQL Server 2000, T-SQL, VB Script, JavaScript, HTML, IIS, Stored Procedure, Triggers, Web Form, HTML, XSD, Visual Studio 2003

Profitability System (Financial System):
Description: This system is developed to keep track of profitability of each product of the company. For calculating actual profit of the product different factors are considered. This system also takes care of Accounting, billing, reconciliation details. This system takes data from BPCS system also

Responsibilities:

• Development of data entry screens using RPG and reports using RLU.
• Process programs using CL
• Unit Testing and Integration testing
• Functionalspecification and userDocumentation
• Implementation
• User Training

Environment: AS/400, RPG, RLU, CL, OS/400 Bayer Healthcare, Mumbai, India Jun'03 - Dec'03

Programmer Analyst

Description: This system is developed to automate pay-slip and other payroll calculation process and to get quick information about employees' pay-slip details. This system collects information like employees' attendance, investments, loans and other details. Based on this pay-slip is calculated which includes Professional Tax, Provident Fund, ESIC, Tax and Loan payment etc. Different types of statutory and other reports are generated.

Responsibilities:

• Involved in re-design and Writing Specification
• Developed GUI screens as per specifications using Windows Form
• Unit and integrated testing script
• Used Crystal Report for reporting.

Environment: VB 6.0, Crystal Report, SQL Server 2000, T-SQL, EXCEL, Stored Procedure, Triggers, Win Form

Confidential, Mumbai, India Dec'02 - May'03

Role: Programmer Analyst

Description: 'Distribution Requirement Planning' system creates monthly distribution plan for the products. This system takes various information for making plan like location sales plan, stock status at warehouses and locations, Goods In Transit (GIT) from warehouse to location and location to location, pending orders and delivery schedule, if any

Responsibilities:

• Involved in design and development of application architecture using Microsoft technology
• Developed user interfaces using VB 6.0 Form
• Designed and developed database using SQL Server 7
• Created Report using Excel Application
• Responsible for developing GUI Screens for gathering and storing the information from other legacysystems
• User interaction and Training

Environment: VB 6.0, SQL Server 7, T-SQL, EXCEL, Stored Procedure, Triggers, Win Form

Confidential, July'02 - Nov'02

Programmer Analyst

Description: This application is developed to register new vendors, updating the existing vendors for supply of mechanical equipment, parts and material for automobile industries. It maintains all required information corresponds to the vendors directly, material requirements, automobile parts and specifications of various items and equipment. It helps in short listing the vendors and finalizing the quotations. This system also keeps track of the Parts inventory and obsolete items, etc.

Responsibilities:

• Requirement study, database design,
• Designed and developed the data entry screen using RPG
• Developed Reports using RLU and CL
• Debugged and tested all screens.
• Documentation coding of screens completed
• Implemented and trained end users.

Environment: AS/400, RPG, RLU, CL, OS/400

Confidential, Mumbai, India Dec'01 - Jun'02

Programmer Analyst

Description: 'Export Management' system is developed for 'Export Department' to automate export documentation process and to get quick information about the transactions. Company exports its own manufactured goods as well as purchased goods from other suppliers. This system keeps track of all transactions like orders, purchase, sales, payments, different documentation required for export process, reports etc.

Responsibilities:

• Active member of the professional team participated in all the phases of systems development life cycle.
• Involved in Screen Designing and Document ting same
• Developed User interface screens as per requirement
• Participated in unit testing plan and system testing for the application.
• Developed reports generation screens for the management purposes.
• Implementation of system and take user approval
• Provided user training and documentation to the concerned staff.

Environment: PowerBuilder, SQL Server 7, T-SQL, Store Procedure, Triggers, Windows NT.

Confidential, Jan'00 - Nov'01

Programmer Analyst

Stores (Inventory) Management

Description: This system is developed for the 'Stores Department' to keep track of receipt and issues of different materials (Inventory). Stores Department makes indent for materials, it receives material from supplier, it issues material to the departments of different locations. This system keeps track of current available stock of all materials in the stores and also in which rack it is kept. It prints many documents, reports require for the transactions.

Responsibilities:

• Requirement study, database design,
• Developed User interface screens as per requirement using form
• Test Cases and Unit testing of all screens.
• System Implemented and trained end users.

Environment: Visual Basic 6, SQL Server 7, T-SQL, Store Procedure

Inventory Management System
Description: This system is developed for 'Purchase' and 'Stores' departments. This system handles all inventory transactions of the company. Purchase department makes entry for all purchase contracts between suppliers and company, creates indents etc. Stores department receives goods, issues it to the departments, it makes the issue and receipt entry for different production processes, data transfer from other locations to the head office etc. and many documents, reports required for the transactions.

Responsibilities:

• Development and Maintenance of user interfaces screens.
• Unit testing and Integration testing of each screen and Module respectively.
• User Interaction, Training and Support.

Environment: PowerBuilder, SQL Server 7, T-SQL, Store Procedure