SUMMARY

• 13 years of experience in Design, Development, Testing, Data analysis and Implementation of various Windows Client / Server applications.
• Excellent Skills in Application Development using VB.6,VB.net,COM,DCOM,ActiveX Exe and ActiveX Dll, MS Access, MS Excel, VBA
• Excellent experience on Database Design, Database Re - Engineering, Debugging and Analyzing code, Database Performance Tuning, Reports and Graphs using VBA MS Access and MS Excel.
• Excellent experience in the automation of Microsoft product (MS Excel, Access and MS Outlook) with complex formulas, charts and Pivot tables using VBA and VB6.
• Excellent working knowledge in analysis and development experience in data visualization tool Tableau 9 and 9.3.
• Good Tableau working knowledge in creation of metrics, attributes, dashboards, advanced chart types, visualization and complex calculations to manipulate the data
• Excellent hands on experience on different databases tools like ORACLE, SYBASE, SQL Server and testing tools like JIRA,IBM DOORS, HP QC/ALM
• Well versed sql programing scripting back-end and other Languages for user interface and reporting tool SQL Server, ORACLE, Sybase and DB2.
• Designed, developed and supported BI solution using Tableau, involved in debugging and monitoring and troubleshooting issues and Remedy Tickets.
• Experience with Mortgage Servicing system (MSP/Black Knight), Monarch and CenBase (Internal System).
• 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 such as Finance, Mortgage industry, Investment Banking, Retail business and Airline’s.
• Good analytical and problem solving skill and working knowledge with large amount of data set.
• 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.
• Extensively used PL/SQL, Stored Procedures, Referential integrity, Functions and Triggers.
• Reputation for excellent interpersonal and analytical skills with good written and verbal communication skills in a fast-paced result-oriented environment.
• Have a strong committed attitude ability to manage multiple task and works under tight and demanding schedules.

TECHNICAL SKILLS

Client Tools: VB 6.0, VB.NET, VBA MS ACCESS

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

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

Middleware: COM/COM+/DCOM

Others: ADO.NET, IBM Clear case, HPQC, JIRA, IBM DOORS, MS Visio, Adobe Document Server, Visual Source Safe, TOAD

Scripting Languages: HTML/XML

OS: Windows XP, Windows 7/8,Windows 10

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

PROFESSIONAL EXPERIENCE

Senior BI Developer IV

Confidential, Ewing, NJ

Environment: VB 6.0, MS Access 2013, VBA, Tableau 9.3

Responsibilities:

• Developed SLA Metrics tracking and reporting system for different clients using MS Access & VBA.
• Implemented major development and enhancements of CLIENT SATISFACTION dashboard for Servicing & Reporting.
• Involved in the enhancement of different MS Access and MS excel applications and reports which includes:
• Loss mitigation Database, Bankruptcy Database, Disaster Report, Executive Daily Dashboard, CFPB Dashboard, Accenture Managerial Database etc,
• Created new module for Disaster Reporting in the existing DB and generated the different clients reports in excels and generated auto sending email and SharePoint update option.
• Involved in the functional design for the Dashboard KPI’s and provide multiple layouts for the design approvals.
• Built ad-hoc reporting and tools and data retrieval services using MS Access VBA.
• Managed all data related aspects of multiple directory projects through various stages of production.

Application Development Analyst IV

Confidential, Herndon, VA

Environment: VB 6.0, MS Access 2013, VBA, VB .net,ADO.net, Tableau 9.3, Oracle 12.5, IBM Rational ClearCase.

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.
• Created different dashboard using Tableau for the cash management team and involved in the activities of placing the reports in the centralized locations.
• 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 warranty period
• Involved in the remediation effort of all the 21 MPS legacy applications which includes:
• Remediated the legacy MS ACCESS to VB 6.0 and finally to VB.net for the selected applications.
• 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
• Project -: Integrated Planning, O&T Strategy and Planning Team

Environment: VB 6.0, MS Access 2010, VBA, VB .net, Tableau 9.3, Sybase 12.5, IBM Rational Clear Case.

Application Development Analyst IV

Confidential, Herndon, VA

Responsibilities:

• Developed Simplify Dashboard tool in MS Access/VBA for reporting and visualization of Simplify ideas and generated custom reports for Idea officers.
• Involved in Development and enhancement activities of Model 1 and Model 2 reporting tools which is generating different levels of data visualization using EPPM, CMDB, Fieldglass, MyService and Remedy using VB 6 and VBA
• Involved in the complete development activities of Spotfire to Tableau report migration project.
• Created QREP Dashboard using Tableau 9.0 and generated KPI report for data quality team.
• Works with the Tableau admin team to setup the auto refresh of the data source & publish the data source and reports in Tableau server and share point portal.
• As a member of O&T Strategy and Planning Team, I am responsible for generating different dashboards and visualize the data using Microsoft technologies and Tableau 9.3
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Lead Application Developer

Confidential, Maclean, VA

Environment: VB .net,ADO.net, VB 6.0, MS Access 2007, VBA Programing, Sybase 12.5, Sybase 15.0m, HPQC

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:
• Servicer and Investor reporting team.
• Report generation in Tableau and VBA( MS access and excel)
• 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.
• 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
• Project -: Enhancement and Remediation Project

Environment: VB .net,ADO.net, VB 6.0, MS Access 2007, VBA Programing, Sybase 12.5, Sybase 15.0m, IBM Rational ClearCase, HPQC

Confidential

Responsibilities:

• Involved in the enhancement project of major Finance applications in Multi Family which includes:
• Development activities of 6 levels of segregation of approval process on a Wire entry.
• Modified the existing COM,DCOM,ActiveX Exe and ActiveX Dll for 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

Lead Developer

Confidential, Dallas TX 

Environment: VB 6.0, Window Service, Visual Studio .Net, Agile Scrum process, XML, IIS, Oracle 11G

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

Environment: VB.net, Window Service, Visual Studio .Net 2005,Crystal Report, SQL Server 2005, VBA using MS Access and MS Excel.

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.