Summary

• 11 years of experience in System and Data analysis, design, Development, Testing and Implementation of various Windows Client / Server applications.
• Extensive work experience in the area of application development, system and business analysis, database Administration, testing, application support and documentation.
• Working Experience on different Business domains areas such as Investment Banking, retail business, Airline and Finance domain.
• Well versed at coding program using different databases as back-end and other Languages for user interface and reporting tool, Visual Basic 6.0/ VBA, Macros using MS Excel and MS Access/SQL Server, ORACLE for back-end for a new system development or system modification for a new change request.
• Good working experience on managing large amount of Market data and Financial data using the ETL tool Data Stage and Micro Strategy.
• Good analytical and problem solving skill by working with large amount of row data.
• Experienced in all aspects of Software Development Life-Cycle SDLC from inception to delivery including requirements gathering, use cases, functional specification, design, estimation, implementation and debugging, documentation and maintenance.
• Excellent Skills in Application Development using VB.6,VB.net,COM,DCOM,ActiveX Exe and ActiveX Dll, MS Access, MS Excel, VBA and VSTO
• Excellent working knowledge in MS Excel and MS Access with complex formulas, charts and Pivot tables
• Excellent hands on experience in the automation of Microsoft product MS Excel, Access and MS Outlook using VBA and VSTO.
• Strong experience in Database Design, Development and Programming using MS SQL Server 2005/2008 and MS Access backend. Extensively used PL/SQL, Stored Procedures, Referential integrity, Functions and Triggers in Microsoft SQL Server.
• Hands on experience in MS SQL Server database access and development used along with Microsoft Visual Basic programming with emphasis on design, development, enhancement, automation and optimizing databases for high Availability, Performance and Security. Writing SQL statements for stored procedures, functions, table structure and triggers.
• In-depth knowledge of T-SQL and SQL Statements.
• Exposure to different databases like Oracle, SYBASE, MS Access, SQL Server, and DB2,IBM DOORS, HP QC, ALM and UFT tool
• Reputation for excellent interpersonal and analytical skills and excellent written and verbal communication skills in a fast-paced environment and result oriented with a committed attitude.
• Ability to manage multitasks and works under tight and demanding schedules.

Technical Skills:

Professional Experience:

Confidential

Responsibilities:

• As a member of core MF application production support team, taking care the full responsibility of application functioning, data accuracy, data analysis and various report generation tasks.
• Worked in different areas of FM MS business area:
• MF Cash Management Team
• Servicer and investor reporting team.
• MF Finance and accounting team
• Capital Market security group.
• Assessment and Risk analysis team
• Analyzed and developed Rick analytical report and Borrower wire, Property wire and wire pending report in various formats.

Confidential

Responsibilities:

• Involved in the major enhancement project of CMS Cash Management System application which includes :
• Enhancement activities on wire Instruction wire approval, exception process and report generation modules.
• Database design and modification of existing SP for the enhancements
• Requirements gathering, use cases, functional specification and design document preparation
• Application support activities during the warrant period
• Involved in the remediation effort of all the 21 MPS legacy applications which includes :
• Remediated the legacy VB4.0/5.0 to VB 6.0 and finally to VB.net for the selected applications.
• Replacement of all 16 bit controls to 32 bit controls which is compactable to Win 7
• Modified the existing COM,DCOM,ActiveX Exe and Dll as per the new environments
• Replacement of 3rd party driver eg:SQL Sambro to RDO/ADO/ADO.net
• Conversion of Sybase 12.5 to Sybase 15.0
• Conversion of MPS to Win7 platform through Citrix environment.
• QA activities of all the legacy migration activities using HPQC tool
• Requirements gathering, functional specification and design document preparation and Dev integration and unit test activities.
• Fortify scan process of all MPS activities for the SQL injection/leakage checking.
• All SDLC activities of the project

Confidential

Responsibilities:

• Involved in the major enhancement project of CMS Cash Management System application which includes :
• Enhancement activities on wire Instruction wire approval, exception process and report generation modules.
• Development activities of 6 levels of segregation of approval process on a Wire entry.
• Modified the existing COM,DCOM,ActiveX Exe and ActiveX Dll fro the new enhancement
• Database design and modification of existing SP for the enhancements
• Requirements gathering use cases, functional specification and design document preparation and Dev integration and unit test activities.
• Application production support activities during the warrant period

.Net Development / Lead

Confidential

Responsibilities:

• Construction for all enhancements using VB 6.0 and Oracle 11g as the back end
• Involved in designing Front-end User Interface screens in VB.Net. Designed tables in back end database in Oracle 11g
• Developed and Modified User Interface using VB.Net
• Developed a Data Layer to populate the Data using ADo.Net and Oracle Server
• Developed VB 6.0 applications for the Business Logic and Data Access layers tiers of the 3-tier architecture
• Creating design documents/Technical specifications for all enhancements and new developments.
• Business Analysis, Understanding and Development/Maintenance of in-house business critical applications needed in airline operations.
• Developed user friendly reports for the end user using MS Access user interface, VBA and reporting tool in basic to large complexity for the data.
• Generated various user access tool using MS excel 2007 and excel 2010 for the end-user using the VBA coding.

• Involved in the functional and technical understanding as well as presentation of the knowledge acquired.
• Actively participated in the transition activities between the SMEs SWA and business support team. Exposure to knowledge transition, acquisition shadow and reverse shadowing .

Confidential

Responsibilities:

• Developed with VB6.0 as well as with VB.net
• Involved in the enhancement activities of existing COM/DCOM ActiveX EXE and DLL components
• Generated various reports using MS excel and VBA coding.
• Developed a generic Authentication web service in VB.NET consumed by various vendors hosting Application websites.
• Maintenance and production support of the current airline applications on line awarding, bid entry applications, Leave and Training Application system and handling of airline's application on cashless handheld devices
• Used ADO.Net objects such as Data Reader, Data Adapter and Data Set to object data source fetch and handle user data. Involved in the analysis, design and development of the CMBA Application.
• Involved in integration and regression testing.
• Involved in designing, normalizing databases, created tables, indexes, Stored Procedures, Triggers and Views of MS SQL Server. Performed routine maintenance, tuning, recovery and backup activities of MS SQL Server. Support.
• Intensive functional requirement discussion and writing of Functional, Technical Specifications and Operational Guidelines Documentations. Active involvement on the presentation and preparation of Functional, Technical and Operational Guidelines with the SMEs and Aircraft Operation Maintenance Group.

Sr. Software Developer / Project Lead

Confidential

project.

• Working on implementing new functionality and defect fixing using VB.net
• Worked with Product owners to understand requirements, backlogs and defects.
• Developed the Trading module using VB.net, Crystal Report 10.0.
• Developed different control templates, data templates, Item templates.
• Validated user input using Client side as well as Server side validations using validation controls of VB.Net.
• Wrote code and design review sessions and provides time estimates for individual module and team task
• Participated in integration testing and regression testing and debugging codes related to fixes for the project development
• Participated in assisting users during the acceptance testing to fully implement the system

Software Engineer/Application Developer

Confidential

Responsibilities:

• Main task is to code and design applications in VB 6.0 and VB.net, MS ACCESS to accommodate entries of clients information to automate file handling record keeping of accounting and payment details, certificates and experiences for company's references. Application also includes record keeping of company's clients' records and details.
• Special presentations on excel, word and power point handlings are done in VBA development
• Generates requested reports for the client details on need basis.
• In-charge of designing/creating/modifying table structures, creating queries/views and stored procedures/triggers to manage the MS Access database.
• Responsible for database documentation and user manual.
• Involved in code and design review sessions and provides time estimates for individual module and team task
• Responsible for code migration, refactoring, customization and writing unit test cases for each module, used 3rd party tools for code refactoring.
• Used enterprise library for logging and data access.
• Worked with business analyst to understand requirements , creating application process flow diagrams , creating Class diagram and sequence diagram , development of middle tier business objects and database processes , testing , implementation and maintence of all business systems
• Wrote VB.net code to handle server side functionality
• Worked as a part of Scrum process to meet the critical deadlines.
• Written complex T-SQL queries involved in creating triggers and constrains to provide data integrity
• Creating stored procedures, user defined functions and special software roles, which restrict access to data from the database. Using a variety of tools and techniques, which include SQL Server Profiler, Query Analyzer, index tuning etc.

Application Developer

Confidential

Responsibilities:

• Implemented multithreading to handle UI operations and to load heavy data to user controls, generate reports.
• Design and code implementation of enterprise application using VB.net for GUI part and Linq to Sql and Ado.Net for data access Layer
• Analyzes and evaluates existing or proposed systems.
• Involved in development of server side parser using Custom code and calls to WCF Web Service.
• Involved in unit testing using NUnit Framework.
• Used Datagrid to display, manipulate all financial data related to Market Data.
• Used Click Once Deployment method for deploying the application.
• Designing normalized data schemas using MS SQL Server 2005 / 2000 - Enterprise Manager.
• Written complex T-SQL queries involved in creating triggers and constrains to provide data integrity
• Creating stored procedures, user defined functions and special software roles, which restrict access to data from the database. Using a variety of tools and techniques, which include SQL Server Profiler, Query Analyzer, index tuning etc.

Application Developer

Confidential

Responsibilities:

• Codes and designs new requested functionalities for the retail trading system using Visual Basic 6.0 for the windows-based application and MS Access as back-end database.
• Application modules on windows-based applications using VB 6 are customer information facility, accounting module and inventory modules.
• Assigned in different clients of the company and provide implementation support on local client locations.
• Assists in the unit testing of each team's module, review codes, provides analysis if it has met the desired requirement and verifies/reviews test scripts before implementation.
• Developed and integration of server side COM components
• Extensively used the Object Oriented Concepts in building the Application design.
• Involved in Code Review, Unit testing, Debugging and Integration Testing of the application.
• Involved in the functional testing of the application and actively took part in the production fix of the application.