Management .Net Engineer Business Developer Sql

Sohail Sarwar tahir

***, ***** ******, ********* ****** 321, Rahway, nj 07065

Phone: 732-***-****

email: ********@*****.***/******@***.***

http://homepages.nyu.edu/~sst242/index.html

objective

Seeking a position with a progressive organization leading to new projects and advancements in the field of Information Technology. Looking for a professional working environment where I could make the most of my cogent academic and professional experience.

professional experience

Jun 2006- To Dec 2006 Morgan Stanley (Company IT)

Summer Analyst – CO-op

Strategic Reporting/

COBIT Compliance

PE Plus

Delivering a brand new downstream .NET/C#/Sybase/MS- SQL WinForm application which will provide data analysis, projection and reporting capabilities to financial controllers and investor relations personnel. Development includes but be limited to, server-side DB components (Sybase/Transact-SQL/Stored Procedures), data access layer (C# provider and ADO .NET classes), UI Form classes as well as backend Linux scripting jobs.

Responsibilities:Proposed and configured Eclipse Entitlement Server. Modeled business entities for E3 Server and integrated Entitlement Engine with Strategic Reporting using E3Clinet API in C#.Proposed and implemented Generic Search UI in C#.R&D for data-migration from MS-SQL to Sybase (linked-server, DTS packages (API) and triggers)Implemented DAL and stored procedures.Implemented config xml files to encapsulate database and E3 server connection information. Implemented encryption and decryption of passwords.Proposed and implemented UI changes and bug fixing logged in VI.

Environment: MS-SQL Server, C#, ADO .NET, UNIX, Sybase, SOAP/XML

Worked on COBIT ompliance for some of the following applications; LPRS Admin, LPRS Portal, Venture Complete, Strategic Reporting, Keeper and FAAR. Worked closely with Project owners and ITRS for MS Audit Standards.

Unified Application suit to replace some of the following legacy applications that serve Private Equity; Document Uploader, Mail Merger, Portfolio Management, LPRS Admin, LPRS Portal, FAX Tracker.

Responsibilities:Design and implement Data Access Layer and implement stored procedures.Implement Eclipse Entitlement Server and Entitlement UI for BU.Propose Architecture for application (thin client, BSL, DAL) and implement

Environment: MS-SQL Server, C#, ADO .NET, UNIX, Sybase, SOAP/XML

Feb 2006- To Jun 2006 Data Quality (Professor Arthur Goldberg)

Research Assistant

TDQM (MIT)

Focused on building an enterprise wide environment that ensures data quality. Business cases and quality practices for real life applications that prevent injection of bugs and measurement of data quality of systems.

Oct 2005- To Jan 2006 Information Technology, Stern, NYU.

Web Developer

NYU website/in-house applications

Worked for Stern, IT department as web developer. Following are some of the pages, I have worked on.

http://w4.stern.nyu.edu/advising/

http://w4.stern.nyu.edu/alumni/alumniball/

Responsibilities:Database design and development.

Environment: MySQL, Perl, UNIX, MS-Access.

Jan 2005- Jun 2005 RFM Loyalty Private Ltd.

Sr. Systems Engineer

Merchant Reports/

Customer Reports

MIS

Real time reporting for merchants/customers / UBL, running loyalty campaigns of RFM.

Responsibilities:Resource management, scheduling.Database design and development, T-SQL stored procedures,. Jobs and DTS packages in MS SQL server 2000.Designed the reports using Crystal Reports 9.

Environment: VB .NET, MS SQL Server 2000, Crystal Reports 9, ASP.NET, MDAB

Management Information System has been developed to map Life Style Card business of RFM. It’s a true financial system, with prompt reporting for managers to analyze the statistics of business. Card Management System has been integrated to MIS which gets updateed once data has been entered using MIS. Its data has been made consistent using DTS packages and jobs which imports data from XLS, a system by http://www.welcome-rt.com/

Responsibilities:Resource management, scheduling.Database design and development, T-SQL stored procedures.Developed desktop application using VB.NETReporting using Crystal Reports

Environment: VB .NET, MS SQL Server 2000, Crystal Reports 9, MDAB, Oracle

Jan 2002-March2003 & Catalyst IT Solutions

May 2004-To December 2004

Sr. Software Engineer

Rochell

Vanadium

Client server application that is built to automate the working environment of a hospital. Its underlying model is made generic and thus it has the capacity to serve various clients with minimal enhancements. It mainly provides support for scheduling patient therapy, which can later be tracked. Hospital accounts management is another area that has been targeted. On increasing desire of Clientele, a web module is underway that will support the system on WWW.

Responsibilities:Involved in the development phase to gather requirements from various sources. Co-ordination with team members to discuss the scope of the project.Database design and development, T-SQL stored procedures, triggers and functions.Designed the middle tier to encapsulate business rules and business fa ade.

Environment: VB 6 for UI and COM, MS SQL Server 2000, Crystal Reports, ASP.NET, VB.NET

Library management system that automates major operations and record management of libraries. A separate kiosk application has been developed for library members to automate book searching in the library. Web Interface facilitates members to access library system from their desktop.

Responsibilities:Involved in the development phase to gather requirements from various sources. Co-ordination with team members to discuss the scope of the project.Database design and development, T-SQL stored procedures, triggers and functions.Developed the error handling methodology and data validation for various inputs.Developed Web Interface using ASP.NET Web Forms.Developed database interactions using ADO.NET (Data Adapter, Data Set and Command Objects).

Environment: VB 6 for UI and COM, MS SQL Server 2000, Crystal Reports, C#, ASP.NET, Java Script

April 2003- May 2004 ITIM Associates (Pvt) Ltd.

Software Engineer

Impact Analyzer

BSI

Travel Studio

Making use of Reverse Engineering, this application finds Impacts of one database objects on another. It has the potential to parse database scripts either after downloading from VSS or parsing scripts directly from database server that can run Oracle or MS- SQL server 2000/7. Web based, user friendly UI has been provided to render dependencies over intranet. It has the functionality to map business processes of the system on database objects.

Responsibilities:Developed database parsers each for MS-SQL scripts and for Oracle scripts using ATL.Developed Windows NT service, which schedules and executes parsing.Database design and development, T-SQL stored procedures.Developed web based UI making use of ASP.NET, C# and Java ScriptComplete documentation, including process bible, deployment guide scope document etc.

Environment: VB 6, ATL, MS-SQL Server 2000, Oracle 8, C#, ASP.NET, Java Script, HTML, DHTML, VSS, COM+, Internet Information Server 5.

BSI Inspectorate --- http://www.bsi-global.com/ are world leaders in inspection and laboratory analysis of commodities, it was their need to automate the complete laboratory analysis process, I at ITIM along with my team automated their whole process by providing them a web based solution that BSI runs over LAN.

Responsibilities:Involved in the development phase to gather requirements from various sources. Co-ordination with team members to discuss the scope of the project.Database design and developmentDeveloped web based UI making use of ASP, Java Script and VB Script

Environment: VB 6, MS-Access/MSDE, ASP, Java Script, VB Script HTML, IIS 5, DHTML.

http://www.opendestinations.com/travel_studio.html, Travel studio is intended for medium to large Tour Operators and Destination Management Companies and provides Quotation and Package systems, real-time reservations management tools, inventory control and Internet sales interfaces. All this is backed up with a user definable reporting mechanism to provide the information you need for your business at the touch of a button. http://www.microsoft.com/middleeast/industry/gem/other/43.stm, gives a brief description of overall system.

Responsibilities:Worked on financial reporting moduleSupport to clients, bug tracking and fixingChanged architecture of debugging utility and enhanced its logging functionality. Optimized its performance by reducing network traffic and introducing DCOM architectureDatabase design and development, T-SQL stored procedures and user defined functions

Environment: VB 6, ATL, MS-SQL Server 2000, Crystal Reports, MFC.

Freelance Projects

HMS

Anisa Carpets

Runs business in UK, I developed an application that manage their inventory system, weekly inspections, tracking of goods received and transferred/quarantined to other departments

They need to port their system from MS Access to MS SQL server 2000, I transformed all the queries to stored procedure and changed the DAL.

Education

Year

Certificate / Degree

Institute

GPA/Percentage

2005

MS in Information Systems

Courant Institute of Mathematical Sciences & Stern, New York University.

GPA: 3.6

2003

B.E.(Computer Systems)

NED University of Engg. & Tech.

80.2%

1998

Higher Secondary Certificate

Adamjee Government Science College.

83%

1996

Secondary School Certificate

Habib Public School, Karachi

90.2%

achievements

Among Top Fifty students of Karachi in Intermediate Examination.Awarded scholarship and award of merit for securing 16th position in Board of Secondary Education Karachi.

certifications

Feb 2002 Microsoft Certified Solution Developer

Designing and Implementing Desktop Applications with VC++6.0 Designing and Implementing Distributed Applications with VC++6.0 Designing and Implementing Databases with MS SQL Server 7.0 Analyzing Requirements and Defining Solution ArchitectureDesigning and Implementing Databases with MS SQL Server 2000 Developing and Implementing Windows -based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NETDeveloping XML Web Services and Server Components with Microsoft Visual C# .NET and the Microsoft .NET FrameworkDeveloping and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

August 2002 Sun Certified Java Programmer

Passed Sun Certified Programmer for the Java 2 Platform, with 88% marks

April 2000-April 2004 Brainbench Certified in

C++ Fundamentals, MS SQL server 2000 Programming, OO Concepts, Data Modeling Concepts, .Net Framework, RDBMS Concepts, Software Business Analysis, Project Management (2000), C#

profeSsional affiliations

Member of Pakistan Engineering Council

programming areas and tools

Web & Client/Server Scripting Languages: ASP, ASP.NET, VB.NET, C#, JavaScript, VBScript, Perl/CGI.Database Management Systems (DBMS): SQL Server 7.0/2000, Microsoft Access 97/2000/2002, MSDE,Oracle 8i/9i, SybaseProgramming Languages: Visual C++ 6.0, Java 1.2/1.3, Visual Basic for Applications, Visual Basic 6.0, C, C++, T-SQL, ADA, AWK, Unix Shell scriptingMarkup Languages: XML, XSL, HTML, DHTMLDevelopment Libraries and APIs: Active Template Library (ATL), WinInet API, Microsoft Foundation Class (MFC) Library, DAO/ADO/ADO..NET/ODBC, WinSock APIOther Tools and Standards: MS-Visio, UML, Rational Rose, MS Project 2000, VSS, Crystal Reports 8/9

Academic projects

HDL4PCB Electronic Design Automation Environment: It is a suite of tools that provides the capability to take a structural VHDL or Verilog representation of an electronic design and translate that to a Printed Circuit Board (PCB) system for layout. It provides a path from HDL designs to PCB layout, eliminating problems inherent with graphical representation of large, complex components. On presentation of this software in a nation wide software competition we won accolade of merit.IC Inventory System: Inventory system, assigned for DBMS course, implemented in MFC and SQL server/ Oracle / MS-Access.Internet client application: Assigned for course of Software Engineering, this application creates connection with WWW and downloads file from requested URL. Activities of application are logged, and directory structure of web is shown using tree control.Virtual Instrumentation: A frequency counter that is implemented using the virtual instrumentation principles. It uses a microprocessor based system to control the over all functioning and for the purpose of sample wave form generation. The microprocessor used in this project is 8085-a Intel.8-way traffic controller: It is a fully functional hardwired signal that has the ability to control 8-way traffic.Virtual Doctor: an expert system using Visual Prolog.

personal data

Date of Birth: 15th September 1980.Marital Status: SingleHobbies: Basketball, Music, Reading Books.

Contact this candidate