Consultant Resume
COMPUTING SKILLS:
Technologies: ASP.NET, C#, ASP, Silverlight, AJAX, VB.NET, Visual Studio.NET 2008, T - SQL, PL/SQL, JavaScript/ECMAScript, XML/XSL, Visual Basic 6.0, Visual C++, Java, JSP, Plumtree, Perl, PHP, Dreamweaver, Agile project Management (Scrum/XP)
Databases: SQL Server, Oracle 10g/9i/8i, Sybase 11, DB2 8.4, Access 2000, Raima/Velocis
Software: IIS, MS Office 2007, ERWIN, Apache, Visio, MS Project, Crystal Reports, Visual SourceSafe, Perforce, CVS, Data Junction, Peoplesoft, Silk Runner, Xenu
WORK EXPERIENCE:
Confidential
Consultant
Responsibilities:
- Developed several solutions for the HRIS to be used by Confidential Employees worldwide such as Employee Self Service and Employee Status Management Tools using ASP. NET, C#, JavaScript, ADO.NET. Wrote Stored Procedures and UDF’s in SQL Server.
- Developed website to manage the Equity Allocations to employees for Confidential.
- Envisioned and produced a Content Management tool to be used by the Confidential Internal HR Content Team.
- Responsible for the development of Funnel and Flow Analysis Applications.
- Funnel Analysis Application is written to determine effectiveness of a particular path as well as conversion and abandonment rates for user sessions and visits.
- Flow Analysis determines the top traffic drivers for Confidential properties from other channels such as Confidential, external domains, search engine keywords, etc.
- This also provides the top Entry/Exit pages for Confidential, and most common paths traversed by users within a Confidential Property.
- The application was written in C# and ASP.NET using Visual Studio.NET with the database as Oracle.
- Implemented the wrapper objects in Data Access Layer (DAL) using the Oracle Data Provider objects.
- The data source for this is Confidential ’s Data Warehouse, one of the largest storages in the world.
- Recommended and implemented the strategy for session sharing between ASP and ASP.NET using State-Stitch.
- Agile Project Management (SCRUM) was followed.
Confidential
Development LeadResponsibilities:
- Leading the design and implementation of the global multi-language platform for the products repository of the company.
- The project team consisted of members in US, UK, China and Japan.
- The technologies used in the MVC were ASP.NET 1.1/2.0, C#, .NET Framework, SQL Server 2000.
- Responsibilities included providing the architecture and technical leadership for the project, envisioning and implementation of the technical solutions for the accomplishment of business requirements.
- Wrote Stored procedures and views. Also proposed strategy for saving and retrieving documents using the SQL Server database fields.
- Participated in discussions for utilizing different types of Replication strategy in SQL Server.
- Coordinated the efforts of software engineers including the offshore development resources.
- Developed work estimates, task breakdown structures, and project work plans.
- Provided technical mentorship to the team members and established processes for the source code control, builds and code reviews.
Confidential
Development LeadResponsibilities:
- Responsible for the creation of the build, installation and deployment package for Confidential 's Confidential (Business Planning and Consolidation) Release 7.0 using Installshield.
- The media included projects written in C#, .NET and Visual Basic. Debugged projects written in C# and .NET.
- I was also involved in automating creation of websites and virtual directories as part of the installation.
- Responsible for developing screens for interfacing with the XML based Server Configuration. Interfaced with team member.
- Heavily involved in the design and support of the Champion and Support applications for the presto website, the key repositories for customers and presto customer care representatives to review information about the devices, service, connection information and the account.
- Additionally, supported the 3 customer service centers with these web applications.
Technologies used: ASP.NET, C#, SQL Server
Confidential, Palo Alto, CA
Development Lead
Responsibilities:
- Responsible for the overall Software and Database Architecture and integrity, stability and reliability of the Confidential public facing as well as funder only websites covering more than 261 aspx, asp, JavaScript and xsl pages and 17,000 lines of code, not including the external applications or static content.
- The tools used include .NET Framework, ASP.NET, SQL Server 2000, C#, ASP, ADO .NET, IIS, XML/XSL, HTML, Oracle 9i, and ADO 2.5 and JavaScript. Managed authentication and access control for thousands of users of this website.
- Interfaced with different groups to gather requirements and implemented solutions on the website. Responsible for implementation of the modules and stored procedures on Confidential .com for access control based on users funding export control, licensing to be used on all pages of the site.
- Designed and implemented the Customer Value Repository system for the Sales and Marketing Group.
- This application collects the information about the products and programs and the value that they provide to the customers and provides reporting capability.
- This application got Confidential ’s highest award for the product of the year. The technologies used were ASP.NET and the database was on SQL Server 2000.
- Architected, enhanced and supported the Web Content Management system extensively used by the Software Engineering Team. This was written in ASP, COM, Oracle 9i and SQL Server 2000. The COM Objects dlls were developed in VB 6.0. This used PL-SQL stored procedures extensively. Implemented web services for Confidential ’s Events Registration modules using SOAP.
- Interfaced the website databases with Peoplesoft ERP 8.4 by writing T-SQL stored procedures and DTS packages in SQL Server and also developed Data Junction 7.5.5 scripts to facilitate the import and export of data from DB2 ERP to SQL Server and Oracle, Sybase and Excel.
- Created numerous PL-SQL stored procedures to automate the rollover of the site content and access control for year end. Created XSLT to have the presentation of a Client Deliverables Report to web and excel. Developed module to parse and display the XML returned by the search engine Verity (Infoseek) on the website.
- Created a Perl user interface to get the user’s preferences for personalization and wrote a Java application to check the funders interest list and notify them via email if new products are available in that area. Also provide the capability to download if access control rules allow.
- Administered the SQL Server 2000 databases on 7 servers including the Logical and physical database architecture and version control, performance monitoring/tuning, security issues, problems determination and resolution. Also performed backup and recovery planning and implementation.
- An average database consisted of 110 tables, 160 stored procedures and 75 views
- Responsible for administering the IIS, Configuration Management as well as monitoring and troubleshooting the site.
- Proficient in tools such as IIS Exception Monitor and QSlice. Also recommended strategy for a Web Farm for load balancing after reviewing options such as WLBS and Cisco Local Director.
- Heavily involved in the migration of the web server application to .NET framework and C# including Plumtree Portal interface.
- Developed the Content Tool layer using C# .NET.
- Designed an e-collaboration website to facilitate the exchange and discussion of new techniques, ideas and methodologies. This is a BBS application and also includes chat facility. Features include project tracking, threads and categorization.
Confidential
Development LeadResponsibilities:
- Developed web-based prototype of the Electronic Invoice Presentment System using ASP, ADO, VBScript and IIS 3.0 on NT Server 4.0.
- Developed the process controller and scheduler to spawn multiple processes on remote nodes on an NT network using Remote OLE Automation techniques in VB 5.0 on NT Server 4.0.
- This is part of Confidential ’s EIP and e*pay system.
- Also designed and developed routines to launch and control NT 4.0 Services using Win32 API.
- Designed and implemented the Validation Workstation a critical part of the EIP System on VB 5.0 with back end as SQL Server 6.5.
Confidential
Project LeaderResponsibilities:
- Team leader for the design and implementation of the Work In Process system to keep track of the different equipments and products in the assembly line utilizing Visual Basic 5.0 Enterprise, ADO 2.1, SQL Server 6.5, C++, NT Server 4.0 and MS Access 97/2000.
- Created numerous reports using Crystal Reports 5.0. Also administered the SQL Server and responsible for installation, configuration and maintenance of the server as well as the clients.
- Responsible for interfacing with the end-users for functional specifications and later on for maintenance and support.
- Developed an online time tracking application using JSP and Web Sphere as the Application Server.
- Also imported entire data from a cost accounting package Expandible that uses Data Flex into SQL Server 7.0.
Confidential
Project LeaderResponsibilities:
- Played a central role in porting the VB 3.0 Imaging application to VB 6.0, VC++ and MFC for Confidential Compliance.
- Converted the calls to the DB2 MDI gateway with Intersolv ODBC using ADO 2.1 and Stored Procedures.
- Upgraded the Windows API calls to WIN 32. Implemented ODBC Connection Pooling to enable the application to reuse an existing connection from a pool, so it does not have to go through the complete connection process for any subsequent connection.
- Also responsible for writing code to handle the new object model for the Sheridan Controls.
