Sql Server Business .Net Software Project Engineer
Resume:
Apt. *** 201-***-****
Jersey City, Cell:
NJ 07305 862-***-****
Rizahmed1@gmail.c
om
Rizwan Ahmed
Career Summary
. Team Lead with over 6 years of in-depth experience with ASP.NET apps,
SQL Server and Business Objects Crystal reports.
. Posses expertise in Object-Oriented Analysis/Design and ASP.NET C# /
VB.NET Development, skilled at progressing from problem statement to
well documented designs
. Managed high budgeted projects involving both onshore and offshore
development and achieved scheduled goals.
. Leader in managing cross company teams efforts through effective and
motivating mentoring strategies.
. Analytical thinker that continuously resolves ongoing issues and bugs,
often called upon to consult on problems that have eluded resolution
by others.
Technical Experience
Certification Microsoft Certified Professional (MCP)
Languages C#, VB.NET, C++, SQL, Dynamic SQL, JavaScript, XML, XQUERY,
XHTML, XPATH, XSLT, HTML, DHTML, CSS, VB Script
Technical Skills .NET 3.5, .NET 2.0, .NET 1.1, ASP.NET Applications, Web
Services, IIS, LINQ, WCF, WPF, Web Services, AJAX, Active
Directory, Business Objects Crystal reports 2008, SQL
Server Reporting Services (SSRS), SQL Stored Procedures,
SQL SSIS Packages, SQL DTS Packages, SQL Query Optimization
Databases MS SQL Server 2005, MS SQL Server 2000, MS Access, Oracle 9i
Operating Systems All versions of Window, Mac OS X, UNIX (Red Hat,
Ubuntu)
Software / Tools MS Visual Studio (2003, 2005, 2008), Team Foundation
Server 2008 and 2005, SQL Server Management Studio (SSMS),
SQL Server Business Intelligence Development Studio,
Business Objects Crystal Reports (XI, 2008), Documentum,
Macromedia Flash, Macromedia Dreamweaver, MS Office 2007,
Chuckwalla SDK, MS Web Application Stress Tool
Professional Experience
CBS, New York, NY
Senior Software Engineer / Analyst Jan 2006 -
Present
Project: Digital Catalog
Digital Catalog is an online application which is used to display specific
titles for sale. It is compatible with all major web browsers.
Clients/Accounts can view the titles in the Catalog, add them to their cart
and place orders. Users have the ability to create Catalogs dynamically and
every piece of information that is displayed on the site is editable by the
users who create catalogs.
Environment / Software
Visual Studio 2008, C#, ASP.NET, NET 3.5, SQL Server 2005, Crystal Reports
2008, SQL Business Intelligence Development Studio
Responsibilities
. Team Lead. Responsible for coordinating with developers and ensuring the
timely delivery of the project.
. Designed the backend database
. Used WCF to access the database from application
. Engineered all the dynamic features of the Catalog creation process
. Created front end screens for the system using C#, Java Script, CSS and
Ajax
. Database server is on DMZ and I am responsible for daily XML feeds and
database updates using SSIS packages.
. Designed import files for POS systems, so that the accounts can import
the information into their systems
. This application is designed for thousands of concurrent hits. Monitored
stress testing using MS Web Application Stress Tool and then analyzed the
results and made recommendations on the Web Farm and database
configuration.
. Created Dynamic HTML window so display data on user screens so that it is
compatible on all the web browsers.
Project: Feeds for the .com site
Automated various daily feeds to the company's .com site and other feeds to
Amazon.com. It included both the data (XML) and the digital assets (files).
Environment / Software
Visual Studio 2008, C#, ASP.NET, NET 3.5, SQL Server 2005, Crystal Reports
2008, SQL Business Intelligence Development Studio
Responsibilities
. Secure delivery of digital assets to Amazon's S3 file system.
. Developed web services that would deliver the Digital Assets on demand.
. Created the database for detailed logging for each asset
. Designed Crystal Reports that would give detailed analysis of all the
assets that were sent / failed.
. Engineered C# Windows and Console Applications and scheduled them to
create the delivery system for the assets.
. Worked with .com's digital team and EngineYard to ensure the delivery of
assets and metadata to .com site is as per their requirements.
Project: Digital Assets System
The system allows users to store and retrieve digital assets and tag them
with certain attributes / metadata. User can also transform the assets and
export as per the required resolution. System is used by all the
international arms of the company for their daily Digital Assets Bank's
transactions.
Environment / Software
Visual Studio 2008, C#, NET, ASP.NET 3.5, SQL Server 2005, Crystal Reports
2008, SQL Business Intelligence Development Studio
Responsibilities
. Met employees in different divisions of the company to come up with a
list consolidated requirements that servers the purpose for all.
. Used Chuckwalla SDK to import and export assets out of DAB.
. Developed the database to store metadata about the assets.
. Engineered front end screens for the system using C#, Java Script, CSS
and Ajax.
. Improved the response time for the asset retrieval process by fine tuning
the database for this Application. Analyzed Query execution plans and
created indexes on database tables.
. Created detailed reports about all the Digital Assets in Crystal Reports.
. Created exception reports that are scheduled to run every weekday to
inform the business user about any anomalies.
. Created SSIS packages to synchronize data from DAB database to the
applications database on daily basis.
Project: Editorial System
Editorial system is used to acquire a book, when the company is negotiating
with the author/agent. It contains all the information and the forms that
need to be filled in order to sign a contract with the author/agent.
Environment / Software
Visual Studio 2005, C#, ASP.NET, SQL Server 2005, Crystal Reports XI
Responsibilities
. Upgraded the editorial system from .NET 1.1 framework to .NET 2.0
framework and made some enhancements.
. Requirements gathering: to meet the users and get their input on the new
forms/screens to be added to the system.
. Replacing the existing code which was using the Page Pre render event
implemented in a template with the .NET 2.0 Master Pages.
. Introduced new features in the system according to the user's
requirements.
. Creating Tables, Writing Database queries and stored procedures (in T-SQL
and Dynamic T-SQL) for MS SQL Server 2005
. Using AJAX during the search to make sure the whole page is not posted
back and to make the application more efficient.
. Creating reports using Business Objects Crystal Reports XI
Project: Marketing System
Completely redesigned the existing Marketing system of the company
according to the new business requirements, which replaced the legacy
Marketing System. The old system was developed in Power Builder. Database
was re created to optimize the performance of the system and avoid the
existing anomalies. The old marketing system was running off Oracle and all
the data was imported to SQL Server 2005 in the new tables.
Environment / Software
Visual Studio 2005, C#, ASP.NET, SQL Server 2005, SQL Business Intelligence
Development Studio
Responsibilities:
. Meeting the Users from different departments of the company and getting
their input for the suggested changes
. Made a detailed feasibility report as to what functional changes must be
made in order to better assist the users.
. Front-end designed with UI components using Grid View and sorting the ASP
Grid View without the view state.
. Using AJAX during the title search to make sure the whole page is not
posted back and to make the application more efficient.
. Writing Database queries and stored procedures
. Creating reports using SQL Business Intelligence Development Studio which
would show all the marketing budget (i.e. details of all the expenses
incurred) and other Marketing Status Reports.
Project: Title Card System
Engineered a web based 'Title Card System' in C#, ASP.NET and MS SQL Server
2005 at the backend. The system generates the Publishing Titles for a given
season and a set of other selectors. It is an upgrade from the previous
version of the Title Card System which was developed in MS Access. It
allows sales representative to log in remotely and generate the reports
according the customer's needs. Sales Representatives can also add comments
for a specific title, which would be included in the final report. The
project involved numerous reports, each of which had a unique format
according to the client's (i.e. Top Book Selling Stores in US)
requirements. The reports were generated either as excel reports or in pdf
format using Crystal Reports XI. The excel reports were developed
painstakingly as they were a direct input to the client's databases.
Environment / Software
Visual Studio 2005, C#, ASP.NET, SQL Server 2005, Crystal Reports XI
Responsibilities:
. Designing and developing the application using Visual Studio.NET and
ASP.NET.
. Performed structured Exception handling using try, catch and finally
block.
. Front-end designed with UI components using list controls, data grid
controls validation controls provided by ASP.NET
. Developed security model in .NET framework for the administration module.
. Writing Database queries and stored procedures (in T-SQL) for MS SQL
Server 2005
. Created XML Web Services for calculating shipping charges and delivery
dates and automatically monitoring the inventory and placing orders.
. Creating reports in pdf and excel formats using Business Objects Crystal
Reports XI
. Importing XML files into Crystal template using ADO.net and exported data
in word, PDF and excel spread sheet.
Agile Technologies
Jr. Software Engineer June 2003 - December
2004
Project: SMARTILL (Inventory Control and EPOS)
An integrated retail store software system with a powerful EPOS system and
was built for the most demanding retail needs like cash, accounts,
inventory management and Barcode printing.
Environment / Software
Visual Studio 2003, C#, Win Forms, Oracle
Responsibilities:
. Analyze, design, develop and maintain shared software components with
standardized interfaces, including complex user interface design and UI
architecture.
. Used Install shield to create Installer for deployments.
. Design the database schema along with other team members.
Project: Management Information System
An Information System and Decision Support System for a manufacturing
company, also includes sales management, accounting, inventory and
production control modules.
Environment / Software
Visual Studio 2003, C#, Win Forms, SQL Server 2000
Responsibilities:
. Designing, documentation, Software requirement specifications and ER-
Model of the project.
. Coding of the application by amending flow charts and developing detailed
programming logic.
. Writing new code according to the specifications and testing these
modifications
Education
M.S. Computer Science
City College of New York GPA 4.0 / 4.0
B.S. Computer Science (Suma Cum-Laude)
William Paterson University of New Jersey GPA 3.87 / 4.0
Contact this candidate