We provide IT Staff Augmentation Services!

Lead Developer And Sr. Data Analyst Resume

Maclean, VA

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 teh 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 teh ETL tool Data Stage and Micro Strategy.
  • Good analytical and problem solving skill by working wif 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 wif complex formulas, charts and Pivot tables
  • Excellent hands on experience in teh 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 wif Microsoft Visual Basic programming wif 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 wif a committed attitude.
  • Ability to manage multitasks and works under tight and demanding schedules.

TECHNICAL SKILLS

Client Tools: VB 6.0, VB.NET, Win Forms 3.5, 4.0

Database: MS SQL Server 7.0/ 2005/2008 , DB2, Oracle 11g,Sybase 12.5/15.0

Internet Development: HTML, XML, XSLT

Development Tools: MS Visual Studio 6.0, VBA,VSTO, (MS Excel, MS Access and Outlook) MS Visual Studio.NET 2010/2008

Middleware: COM/COM+/DCOM

Others: ADO.NET, IBM Clear case, HPQC, IBM DOORS, MS Visio, Adobe Document Server, Visual Source Safe, IBM ETL tool Data Stage and Micro Strategy.

Scripting Languages: HTML/DHTML

OS: Windows XP, Windows 7

Packages: MS Office 2010 and 2007 (Word, Excel, Power Point)

PROFESSIONAL EXPERIENCE

Lead Developer and Sr. Data Analyst

Confidential, Maclean, VA

Responsibilities:

  • As a member of core MF application production support team, taking care teh 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.
  • Project -: Multifamily Legacy application remediation project

Environment: VB .net,ADO.net, VB 6.0, MS Access 2007/2010, VBA and VSTO Programing, Sybase 12.5, Sybase 15.0, IBM Rational ClearCase

Confidential

Responsibilities:

  • Involved in teh 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 teh enhancements
  • Requirements gathering, use cases, functional specification and design document preparation
  • Application support activities during teh warrant period
  • Involved in teh remediation effort of all teh 21 MPS legacy applications which includes:
  • Remediated teh legacy VB4.0/5.0 to VB 6.0 and finally to VB.net for teh selected applications.
  • Replacement of all 16 bit controls to 32 bit controls which is compactable to Win 7
  • Modified teh existing COM,DCOM,ActiveX Exe and Dll as per teh 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 teh 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 teh SQL injection/leakage checking.
  • All SDLC activities of teh project

Technical Lead/Lead Developer

Confidential, Maclean, VA

Responsibilities:

  • Involved in teh 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 teh existing COM,DCOM,ActiveX Exe and ActiveX Dll fro teh new enhancement
  • Database design and modification of existing SP for teh enhancements
  • Requirements gathering use cases, functional specification and design document preparation and Dev integration and unit test activities.
  • Application production support activities during teh warrant period

.Net Development / Lead

Confidential, Dallas TX

Responsibilities:

  • Construction for all enhancements using VB 6.0 and Oracle 11g as teh 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 teh Data using ADo.Net and Oracle Server
  • Developed VB 6.0 applications for teh Business Logic and Data Access layers tiers of teh 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 teh end user using MS Access (user interface, VBA and reporting tool) in basic to large complexity for teh data.
  • Generated various user access tool using MS excel 2007 and excel 2010 for teh end-user using teh VBA coding.
  • Involved in teh functional and technical understanding as well as presentation of teh knowledge acquired.
  • Actively participated in teh transition activities between teh SMEs (SWA) and business support team. Exposure to knowledge transition, acquisition (shadow and reverse shadowing).

Confidential

Responsibilities:

  • Developed wif VB6.0 as well as wif VB.net
  • Involved in teh 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 teh 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 teh analysis, design and development of teh 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 teh presentation and preparation of Functional, Technical and Operational Guidelines wif teh SMEs and Aircraft Operation Maintenance Group.

Sr. Software Developer / Project Lead

Confidential

Responsibilities:

  • Developed teh Trading module using VB.net, Crystal Report 10.0.
  • Worked wif Product owners to understand requirements, backlogs and defects.
  • Working on implementing new functionality and defect fixing using VB.net
  • 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 teh project development
  • Participated in assisting users during teh acceptance testing to fully implement teh 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 teh client details on need basis.
  • In-charge of designing/creating/modifying table structures, creating queries/views and stored procedures/triggers to manage teh MS Access database.
  • Responsible for database documentation and user manual.
  • Worked wif 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
  • Used enterprise library for logging and data access.
  • Responsible for code migration, refactoring, customization and writing unit test cases for each module, used 3rd party tools for code refactoring.
  • Involved in code and design review sessions and provides time estimates for individual module and team task
  • Wrote VB.net code to handle server side functionality
  • Worked as a part of Scrum process to meet teh 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 teh database. Using a variety of tools and techniques, which include SQL Server Profiler, Query Analyzer, index tuning etc.

Application Developer

Confidential

Responsibilities:

  • Analyzes and evaluates existing or proposed systems.
  • Design and code implementation of enterprise application using VB.net for GUI part and Linq to Sql and Ado.Net for data access Layer
  • Implemented multithreading to handle UI operations and to load heavy data to user controls, generate reports.
  • 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 teh application.
  • Designing normalized data schemas using MS SQL Server 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 teh 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 teh retail trading system using Visual Basic 6.0 for teh 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 teh company and provide implementation support on local client locations.
  • Assists in teh unit testing of each team’s module, review codes, provides analysis if it has met teh desired requirement and verifies/reviews test scripts before implementation.
  • Developed and integration of server side COM+ components
  • Extensively used teh Object Oriented Concepts in building teh Application design.
  • Involved in Code Review, Unit testing, Debugging and Integration Testing of teh application.
  • Involved in teh functional testing of teh application and actively took part in teh production fix of teh application.

Hire Now