We provide IT Staff Augmentation Services!

.net/hana/bo Team Lead Resume Profile

5.00/5 (Submit Your Rating)

Summary:

  • Ten 15 yrs IT experience: design, development, and implementation of S/Ws
  • 10 Yrs Exp. in WinForm/WPF /Web Apps using C ,VB.NET/ASP.NET4 to 1.1
  • 8 Yrs exp. Business Intelligence reports, dashboard in Crystal Rpt XI, BO 4.x Ent.
  • 8 Yrs Experience in Developing Web Services,Restful,Json,XML, MTS/COM DNA /n-tier /Client/Server on VB6
  • Microsoft Certified Professional Developer MCPD
  • ORACLE Certified: OCP- Oracle 10g /11g
  • SAP HANA in-memory Database Certified.
  • 10 yrs exp. Analytical and database designing skill for OLTP, Data warehouse.
  • Batch processing in Oracle8i/9i PL/SQL, SQL Server 2000, T-SQL.

SKILLS:

.NET

Visual Studio 2013, .Net 4.0,3.5-2.0,C , VB.NET, ASP.NET, MVC4/5

WPF, WFC/WSE, Restful, Microsoft Enterprise Library, IIS

Web Scripts

JQuery, Knockout, igniteUI, CSS, JavaScript/ DOM, XML/ XSL

BI Tools

Crystal Reports XI-5.0, Business Objects 4

RDBMS

Oracle 10g/11g, SAP HANA, PL/SQL, SQL Server 2005/2008 SSIS, T-SQL

VB6/COM

Visual Basic 6.0, COM/DCOM, MTS, COM

Others

OOPS, UML/Rational Rose 2000, Erwin4.0, Visio 2003

Experience:

Gulfstream

.Net/HANA/BO Team Lead

Confidential is MVC5 based web app on top of Confidential to support Flight Test Engineers and Confidential certification/regulation. Business Intelligence Reports and dashboards are developed using BO 4.1 suites.

  • Developed MVVM Single Page Application SPA using Mvc5, igniteUI JQuery UI ,Knockout.
  • Designed and Architected Row based HANA database for n-tier Mvc application and Columnar HANA tables for Business Intelligence.
  • Developed Crystal Reports and published on BO Enterprise.
  • Converting SSRS reports to BO/Crystal Reports.
  • Team Leading for HANA Information views, CEScript.
  • Designing Reports and dashboards using Crystal reports/BO Universe,Webi.
  • Designing database schemas with star/snowflake and OLAP/DW
  • Developed Test Driven Development TDD for Unit test for BAL and DAL.

Environment: C , HANA sp07, BO 4.1, Mvc5,JQuery, Ignite UI Infragistics , Net4.5, Windows 2008, Suse 11, TFS 2012, Agile, SCRUM.

Confidential

.Net Team Lead

Confidential is in-house ETL to support Coach's Global Merchandise Planning. This system Extra the data from Netezza, Dataware house, apply business rules to transform the data. This transformed data are loaded into Oracle RPAS Retail Predictive Application Server system for production planning.

  • Leading Team of Developers offshore and inhouse for Release 2 of PETL.
  • Developing WinForm App to configure batches pages using C ,NET,SQL server.
  • Designing middle-tier components using Design pattern and Re-engineering VB6 business objects into .net assembly.
  • Team Leading for PL/SQL Packages, Stored Procedures, Triggers
  • Designing Reports and dashboards using Crystal reports/BO Universe,Webi.
  • Designing database schemas with star/snowflake and OLAP/DW
  • Cleaning up and Debugging the code and performance tuning in Release 1 of PETL.
  • Supporting Production issue on Day to day need in Release 1.
  • Develop SSIS packages to ETL Data transformation Support SSRS reports
  • Developing Test Driven Module for Unit test for Assemblies.
  • Developed Data Validation app in MVC3/4 for x-checking Transformed data.

Environment: C , Design Patterns, Oracle10g/RAC, RPAS, Netezza, .Net 3.5.Net4, asp.net, MVC3/4,ADO.NET/ODP.net, Infragistic, Windows 2003, Sql Server 2008, SSIS,SSRS, SSAS,IIS, Sun-Solaris, Rational ClearCase,TFS, Toad/PLSQL Developer. Visio 2007

Confidential

.Net Lead

Confidential Lending Solution is used by UBS Wealth Management for Capital call and Account Distribution. This system is featured with dashboard to monitor Lending Alerts and Monitors, Cash in out flows, Activity Monitoring, Data capture, distributions, and Quarterly Private equity Valuations.

  • Leading Team of Developers.
  • Developing ASP.NET pages using C ,.NET, XSL, CSS, JavaScript, and Ajax,
  • Designed Dashboard pages with Graphs and Charts with Infragistic
  • Developing Multi-threaded ASPX pages with AJAX AJAX Extensions toolkit.
  • Developing WCF services.
  • Team Leading for PL/SQL Packages, Stored Procedures, Triggers
  • Using PL/SQL Stored Procedures in Crystal Reports
  • Designing Report using Crystal reports/Business Object and integrated with application.
  • Publishing and Authoring Reports in Business Objects Enterprise.
  • Leading team for Stored Procedures, Views, Tables, and Index in Oracle 10g.
  • Supporting Other Production applications.
  • Writing Test Plan for ASPX pages, Assemblies/Component, PL/SQL packages.

Environment: C , ASP.NET, WCF, Design Patterns, Oracle10g/RAC, .Net 3.5.Net4, ADO.NET/ODP.net, Windows Services, Infragistic,Component1,Windows 2003, IIS, Sun-Solaris, DHTML, CSS/JavaScript, XML, XSL, Crystal Report XI, Business Objects Enterprise, Visual Source Safe, Toad/PLSQL Developer, AJAX Extensions, AJAX Control Toolkit. Visio 2007, Infragistic, Component 1.

Confidential

.Net Lead

Confidential ETL tool, which extract data from multiple legacy system and other data source. This tool applies the business rules and validates the data and transforms the valid data into XML. The XML files are imported in to Capital Planning System.

  • Leading Team of Developers.
  • Developing WPF application using C to find early Exception in ETL Application.
  • Re-engineering VB6 import utility into WPF XAML frond end.
  • Developing Multi-threaded WPF pages and Assemblies.
  • Developing WCF services.
  • Leading team for Stored Procedures, Views, Tables, and Index in Oracle 10g.
  • Using PL/SQL Stored Procedures in SSRS
  • Developing ETL packages with SSIS and Reporting Pages using SSRS
  • Writing Test Plan for WPF pages, Assemblies/Component, PL/SQL packages.

Environment: C , WPF, XAML, WCF, Design Patterns, HANA, Oracle10g/RAC, .Net 3.5,.Net 4.0 ADO.NET/ODP.net, SSIS,SSRS, Windows 2003, IIS, HP-UNIX, , PVCS, Team Foundation server, PLSQL Developer, Visio 2007, Infragistic

Confidential

.Net Lead

Confidential

Oracle PL/SQL Server Pages

web application portal between MOL and Vendors and Suppliers of MOL for Maintenance and Repair of MOL Shipping containers. This legacy PSP Oracle PL/SQL Server Pages system is Re-engineered into N-tier C Intranet/ internet application using Visual Studio 2005/2008 in ASP.NET/C /Oracle 10g/Crystal Report XI

  • Architecting the project for re-engineered in new .NET technologies from PSP pages.
  • Leading Team of Developers.
  • Developing ASP.NET pages using C , XSL, CSS, JavaScript, DHTML and Ajax, Silverlight
  • Designing .Net Assemblies using Design Patterns.
  • Developing Multi-threaded applications
  • Developing Multi-threaded ASPX pages with AJAX AJAX Extensions toolkit.
  • Developing and Consuming WCF Web services.
  • Implementing Oracle 10g New feature Database Change notification to Multi-user client app.
  • Team Leading for PL/SQL Packages, Stored Procedures, Triggers
  • Using PL/SQL Stored Procedures in Crystal Reports
  • Designing Report Pages using Crystal reports.
  • Leading team for Stored Procedures, Views, Tables, and Index in Oracle 10g.
  • Developing .Net Assemblies and Web Services.
  • Using Primavera for project schedules.
  • Writing Test Plan for ASPX pages, Assemblies/Component, PL/SQL packages.

Environment: C , ASP.NET, WCF, Design Patterns, Oracle10g/RAC, .Net 4.0/.Net 3.5, .Net 2.0, ADO.NET/ODP.net, Microsoft Enterprise Library, Windows 2003, IIS, HP-UNIX, DHTML, CSS/JavaScript, XML, XSL, Crystal Report XI/ RAS, PVCS, PLSQL Developer, AJAX Extensions, AJAX Control Toolkit., Visio 2007, Primavera ,Infragistic,

Confidential

.Net Lead

Compensation Management System is used effectively administrating and planning for issuance of bonuses and other forms of year-end compensation for JNJ employees. This on going project needs year-to-year modification for effective policy based planning for CIM needs. Administration, Planning, Reports and Downloads are the four major module incorporated in this project.

  • Developing WinForm using VB.NET,
  • Leading team for PL/SQL Stored Procedures for Crystal Reports
  • Designing reports using Business Objects/Crystal Report XI and publish on Crystal Enterprise XI
  • Maintaining Role based security on Crystal Enterprise XI
  • Implementing/Deploying Crystal Enterprise XI reporting server.
  • Leading team of Stored Procedures, Views, Tables, and Index in Oracle 9i.
  • Developed Views for Downloading XML data.

Environment: VB.NET, ADO.NET, Windows 2003, IIS, Oracle9i,HP-UNIX, Crystal Report XI, Crystal Enterprise XI, PVCS, SQL Navigator, Infragistic

Confidential

Team size: 4

Designing and Developing Web-based NET Intranet Application to manage Grants and Finances Special Education data using Visual Studio.NET/C / ASP.NET/ ADO.NET/WebServices. Designing reports in Crystal Reports 10.x/9.x and MS Sql Server Reports 2005 for Grants and Data Management deploying the reports over Crystal Enterprise 10.x/9.x

  • Developing ASP.NET pages using C , XML, XSL, JavaScript, DHTML.
  • Re-Engineered VB6 applications to ASp.net application.
  • Design .NET Components using C .
  • Design Web Services using C .
  • Calling Web Services/ SOAP/XML in ASP.NET pages using Ajax..
  • Architecting database and Middle tier components using Visio 2003.
  • Implementing Role based Security in ASP.NET pages.
  • Leading team for Financial Reports and MIS reports using Crystal Report 10.x/9.x/8.5 and MS SQL Server Report 2005.
  • Implementing/Deploying Crystal Enterprise 10.x/9.x/8.5 Reporting server.
  • Leading team for Stored Procedures, Views, Tables, and Index in SQL Server 2000/2005

Environment: C , VB.NET, ASP.NET, Visual Studio 2003/2005, WebServices / Components, ADO.NET, Windows 2000 server, IIS, SQL Server2000/2005 T-SQL, DHTML, CSS/JavaScript, Ajax, XML, XSL, Crystal Report 10.x/9.x, Crystal Enterprise 10.x/9.x, MS SQL Server Report 2005 SOAP, WSE, Visual Source Safe, Visio.

Confidential

Re-engineering COBOL/VMS legacy system into N-tier intranet application using ASP/COM /VB6.0/ASP2.0/Visual InterDev 6.0/Oracle 8i/Crystal Report 8.5/Crystal Enterprise 8.0/Business Objects 5.x. Leading and Designing Middle tier COM AND Crystal Report 8.5 developers 5 member Team.

  • Design of web based front end using Visual InterDev 6.0/ASP 2./DHTML, JS, CSS
  • Developing and deployment of MTS/COM /DNA architecture components in VB6
  • Leading team and developing PL/SQL Batch processing modules in Oracle 8i back end.
  • Leading team and Designing Crystal Report 8.5 developers 5 member Team.
  • Designing and modifying Universe and reports in Business Objects 5.x
  • Implementing Crystal reports in Crystal Enterprise 8.0
  • Leading team for ASP UI to interface ASP and Crystal report.
  • Converting COBOL batch processing code into PL/SQL Batch processing modules.
  • Logical and Physical tuning of Tables and Index in Oracle8i.
  • Leading team for Performance Tuning PL/SQL-Batches, Views, and Stored procedures.
  • Documenting the COM Components and Oracle tables, packages and views.

Environment: Visual InterDev 6.0/ASP 3.0/IIS 5.0, Visual Basic 6.0, Windows 2000 server, HTML/DHTML, JavaScript, ActiveX/COM, MTS/COM , Oracle8I/PL/QL, AIX RS/6000, Crystal Report 8.5, Crystal Enterprise 8.0, Business Objects 5.x, Application Center 2000. SQL Navigator 3.x, VMS/COBOL, IE 5.x, Visual Source Safe 6.0, Team Manager / Member 97,ADO/OLEDB.

Confidential

  • Design of web front end using InterDev 6.0/ASP 2.0/HTML, VBScript, JavaScript, CSS
  • Developing and deployment of MTS/COM /DNA architecture components in VB6
  • Designing database tables, views, stored procedures and triggers in SQL Server 7.0/2000
  • Developed COM based Exporting tools, which read the data from RDBS and exporting into QuickBooks format
  • Used Rational Rose 2000 for designing Class and Component diagram.

Environment: Visual InterDev 6.0/ASP 2.0, Visual Basic 6.0,SQL Server 7/2000/T-SQL, Windows 2000 server/IIS 5.0, HTML/DHTML, VBScript, JavaScript, ACTIVEX/COM, MTS/COM , XML, Rational Rose 2000/UML, Erwin4.0, ADO/OLEDB.

SysNET Consulting

Re-engineered 2-tier application Access97 into Web based 3-tier architecture

  • Designed Web based Front end using Visual InterDev 6.0/ASP 2.0/IIS 4.0/HTML
  • Developed ACTIVEX/COM Based middle tier components using Visual Basic 6.0.
  • Importing data from EXCEL spread sheet to SQL Server.
  • Synchronizing ACT 2000 databases using Windows Server side Scripting.

Environment: Visual InterDev 6.0, HTML, VBScript, Visual Basic 6.0, VBA, COM/ActiveX, NT 4, SQL Server 6.5/T-SQL, Access 97, ADO/OLEDB, ACT 2000, VBScript

Confidential

Marketing Related Information

Team size: 3

  • Developed ACTIVEX/COM middle tier components using Visual Basic 5.0
  • Outlook 97 look and feel interface was designed using Sheridan suite and VBA.
  • Designed sophisticated Menu and Tool Bar using ActiveTool bar of Sheridan tools
  • Designed report using Crystal report 5.0
  • Developed ACTIVEX/COM middle tier components.

Environment: Visual Basic 5.0, Crystal Report 5.0, Oracle 7.1/PL/SQL, Windows NT 4.0 server , Windows 95, Outlook 97, VBA.

Team size: 3

  • Designed Front end GUI using Visual Basic 5.0/4.0 and database table in Oracle 7.2/7.1
  • Used PDQ Comm control 3.0 to capture data from RS-232 serial port.
  • Developed generalized GUI user interactive module to generate SQL and Record Selection formulas for plotting graphs and generating reports based on user interaction
  • Designed sophisticated GUI Sheridan development tools
  • Designed MIS report using Crystal report 5.0 and graphs Pinnacle Graphic server
  • Developed ACTIVEX/COM middle tier components using Visual Basic 5.0

Environment: Visual Basic 5.0, Oracle 7.2/7.1, Windows NT 4.0 server, Windows 95, Crystal report 5.0, Pinnacle Graphic Server, Sheridan grid/True DB Grid .

We'd love your feedback!