Hardware: Windows 2000, Windows NT Server, Windows NT Workstation, Windows 98, AS/400

Software: SQL Server 2000/2005/2008, SSIS, CLR integration, database design, ASP.NET, C# , VB.NET, Web services, WCF,Visual Studio .NET 2003/2005/2008, AJAX, Project 2003, SOAP, XML, XSLT, XMLSpy 3.5, Visio 2000, MSMQ 2.0, COM/DCOM/COM+, MTS, HTML 4.0, Javascript, Dynamic HTML, classic ASP, Visual Source Safe, VB Script, Visual InterDev 6.0, Visual Basic 6.0, IIS 5.0, T-SQL, Oracle 8i, PL/SQL.

I am a technology management professional with over fifteen years of experience and now seeking a new application for my talents. With my experience in managing and leading teams to produce results, I represent an infusion of analytical thinking, creativity and innovation.

• Enhanced ETL processes by reducing the time taken to load data and improved data handling processes is enabling CSC to provide timely, accurate information to customers leading to increased revenue and value.
• Lead and manage a team of eight. Created a new revenue stream for the Dollar Financial Group which grossed six million dollars in 2006.
• Streamline the loan approval process from one day to minutes. This led to efficient and faster processing of customers at the store and reduced wait times.
• Reduced time to gather data from distributors from one month to two days leading to accurate and timely reporting. Saved SCA Hygiene Paper 1.5 million dollars by using the internet as a data distribution channel to the sales force.

Confidential, ) April 2011 - Present
Wilmington, DE

• Metlife is one of the largest life insurer's with a global footprint providing insurance products to individuals as well as corporate customers. The goal of this project is to integrate data streams for various countries into a SQL Server 2008 database, generate insurance models and reports for management. Current database size is about 1 TB. The role involves:
• Actively involved in converting operational data into fact and dimension tables for the insurance data warehouse in SQL Server 2008. Current warehouse size is about 1.5TB and data is stored partitioned by year. Also developed stored procedures in C# to be used in conjunction with MDX queries.
• Building matrix, tabular SSRS reports using SSAS 2008 as a data source. Some of these reports retrieve data from the transactional as well as OLAP databases and can interface with custom C# libraries to meet user requirements.
• Working with the BIDS studio to scrub input text and xml files, creating SSIS packages to load data to the staging environment and interfacing with C# libraries to ensure conformance with existing business rules. Built SQL Agent jobs to run SSIS packages to load changed data from the staging environment to production on a nightly basis.

Confidential, August 2010 - April 2011
Wilmington, DE

• Sallie Mae is a leading provider of student loans and is committed to making education accessible and affordable to all students. The goal of this project is to efficiently track the performance of Sallie Mae's credit card offers. My role is to interact with the business and analysts to gather requirements, document interfaces with third party vendors and build the logical and physical data model using ER/Studio. I have generated and continue to maintain the data dictionary and database scripts to build the database in SQL Server 2008. Support the development team by enforcing standards and building all the stored procedures, triggers for the application and ensuring that performance is within established SLA's. Created data extracts for products, tactics, offers and product features using BIDS to create SSIS packages and FTP them to Sallie Mae's third party vendor using SQL jobs created using SQL Agent. Data validation is performed using C# libraries. Tortoise SVN is used for version control and Visual Studio 2008 is used for application development and we follow the SCRUM methodology with a three week sprint cycle.

Confidential, March 2009 - July 2010
Wilmington, DE

• CSC is a privately held organization that provides corporate compliance and governance services, entity management, UCC and registered agent services to some of the largest corporations in the country. Below is an outline of some of the projects I am actively involved in:
• Databases at CSC are over 3TB in size and part of my role involves acquiring data from various jurisdictions in the form of text or XML files and working with BIDS to write SSIS packages to perform data validation, cleansing and eventually loading it to the staging environment using stored procedures in t-SQL. Some of the data validation is handled by .NET libraries (in C# and VB.NET) which interface with SSIS packages while. In other cases, data validation is handled by stored procedures. Finally, I have built a set of SSIS packages and .NET libraries to validate and transfer data to the corporate data warehouse in Oracle 10g.
• Built stored procedures for SSRS reports and triggers to enforce data integrity within the corporate and UCC environments in SQL Server 2005.
• We follow the SCRUM process for application development with a three week sprint cycle and all of our stories are discussed and approved by the business.

Confidential, May 2008 - March 2009
Malvern, PA

• The IKM (Information and Knowledge Management) group in Siemens is responsible for RIS products targeting radiologists and cardiologists. This product integrates with a PACS(Picture Archiving and Communication System) to deliver high quality images. We are a team of ten involved in building an AJAX based application using the .NET 3.5 framework. My role is to reverse engineer the existing database using ER/Studio and enhance the model for improved performance. Part of my role also involved creating stored procedures for CRUD operations and building SSIS packages to map, validate and load operational data (supplies used, expenses, dollars spent per patient day etc.) from hospitals into SQL Server and creating BI reports. The application is written in VB.NET and the backend is SQL Server 2008. Rational Clearcase is used for version control.

Confidential, Jan 2008 - April 2008
Conshohocken, PA

• Gigamoto is a vendor for iPLEDGE - a risk management program approved by the FDA for prescribing and dispensing Isotretinoin products to patients. As a part of the program, all wholesalers, prescribers, pharmacies, male and female patients need to be registered and the program is designed to create a verifiable link between negative pregnancy test and the dispensing of Isotretinoin products to females of child bearing potential. My role in the application is to streamline the business rules engine and processes as well as review and recommend corresponding database design changes. Part of the changes included tweaking data access components. The backend for the application is SQL Server 2005 and the front end is built in ASP.NET 2003 and business objects are in C#. Visual Source Safe 2005 is used for version control.

Confidential, June 2007 - Dec 2007

West Chester, PA

• TNS is a leading provider of strategic advertising intelligence to advertisers. The application tracked occurrence data and performs analysis on advertising trends on millions of brands across websites in the U.S and Canada. Responsible for assisting in database design to help migrate (and re-engineer) the backend from Sybase to SQL Server 2005 using Visio 2003. Involved in building middle tier components and stored procedures for various application functionality and data access objects to perform transactions in Sybase and SQL Server 2005 using T-SQL. The business objects are built in C# and ASP.NET 2.0 for the front end. Version control tool used is ANKH.

Confidential, Apr 2003 - June 2007
Berwyn, PA

• Lead a team of eight through the implementation of a franchise portal. Helped in designing the framework, webparts, web service and data access elements. Eventually, the portal will be extended to cover the entire organization. The application is designed using Sharepoint Portal Server 2003, C# and Web Services.
• The company has partnered with Ecount and DataWave to provide Visa and MasterCard prepaid cards(stored value cards) to customers in all of their market segments. This initiative has so far fetched about six million dollars in revenue in 2005-2006. Responsible for gathering requirements from users and creating E-R diagrams in Visio 2003 which formed the basis for a physical database design. I was also involved in interacting directly with Ecount and DataWave to interface with their web service to provide a real time business to business interface to handle credit card transactions. This application is currently installed in 1300 stores across the U.S. Transaction validation is performed on a daily basis through a windows service which validates data feeds sent to a secure FTP location by the bank as well as the vendor using DTS packages. The middle tier is a web service using WSE 2.0 in C# to provide an implementation for various card functions. The backend is SQL Server 2000 and stored procedures, triggers were written in T-SQL.
• Migrated loan and prepaid card databases from SQL Server 2000 to SQL Server 2005 using a side by side migration procedure. Converted and enhanced existing DTS packages to SSIS packages. Used the BIDS studio to create new SSIS packages to extract, validate and load sales data from Visa and loan data from the bank. Created a library of validation routines in VB.NET which could be interfaced with SSIS packages and generated reports for sales and marketing using SSRS.
• Lead a team of eight in designing a web portal using ASP.NET 2.0, C# and AJAX to provide an interface to handle inventory, provide real time card and customer information. Security for this application is handled using roles and forms based authentication. My role was to allocate resources, project schedules, manage work for the team and be involved in the development of the portal. The entire application is written using C# in a .NET environment running on a Windows 2000 server and the backend is SQL Server 2005. Project management was done using Project 2003.
• Dollar has interfaced with TransUnion to retrieve credit information. We have installed X.509 certificates on the server for authentication purposes and I have built a web service which can retrieve credit scores. Since the users of this application are primarily classic ASP clients, there is a SOAP interface for these clients to be able to access the web service.

Confidential, Nov 2002 - Mar 2003
King of Prussia, PA

• Fiserv Lemans is actively involved in developing a vehicle leasing application in conjunction with one of their clients. Was involved in the development of the EOT (end of term) module as well as enhancing the security module based on the features available in .NET. Also built ASP.NET web forms as well as business components in VB.NET and wrote the necessary stored procedures in T-SQL. The application is built in a Windows 2000 environment running SQL Server 2000 as the backend.

Confidential, May 2002 - Oct 2002
Philadelphia, PA

• Aramark, a world leader in managed services, was in the process of re-engineering their mainframe based financial organization system (FOS) to a web based intranet application to efficiently track performance of various profit centers and provide accurate information to decision makers in the company. Involved in architecting a solution, meeting with key users to understand the existing application, gathering requirements, building business components in C# and XML to handle transactions. The site was built in a Windows 2000 environment running IIS 5.0 using ASP.NET to build web forms with Oracle 8i at the backend. Visual Source Safe for version management.

Confidential, Aug 2001 - April 2002
Exton, PA

• A HR/Payroll company in the suburbs of Philadelphia is streamlining gathering and processing payroll information from its clients by re-engineering their VB application to the web environment. I am responsible for interacting with users understanding new functionality to be incorporated, gathering specifications from their client/server application, interacting with program managers, developing distributed components to handle payroll transactions, creating XML data models and their corresponding XSLT stylesheets using XMLSpy. The backend is SQL Server 2000 running on Windows 2000 with IIS 5.0 and Visual Basic 6.0 is used to createDLL's. Visual SourceSafe is used for version control and JavaScript and DHTML are used for client side scripting.

Oaks, PA

• Developed an application for a client in Philadelphia use to manage funds and portfolios for their clients. This application resulted in an efficient and convenient process for portfolio and fund management thereby saving the client considerable amount of time. I was responsible for gathering specifications, creating and designing database schemas using Visio 2000, DLL's to handle mutual fund transactions and developing the site using ASP, XML,XSLT in a Windows 2000 environment running IIS 4.0. Visual SourceSafe was used for version control and JavaScript and DHTML were used for client side scripting.

Philadelphia, PA

• A chemical company was involved in an effort to replace EDI transactions with XML. To achieve this, order information is sent from a mainframe and an AS/400 to Oracle 8i database. My role was to create specifications, lead a team of three programmers, define the XML schema/data model and create DLL's in Visual Basic 6.0 in a Windows NT environment running IIS 4.0 to build interfaces to exchange data between the mainframe and AS/400. JavaScript and DHTML were used for client side scripting and Visual SourceSafe for version control.

Confidential, Mar 1993 - Dec 1999
Edgemont, PA

• Gather user requirements, design and development of an n-tier intranet sales force automation application to capture sales, rebate and contract information from distribution and build objects to calculate bonuses and key performance indicators for the business. Responsibilities included designing database schemas and stored procedures for the application using T-SQL in addition to developing DLL's to handle sales and rebate transactions using SQL Server 7.0, Visual InterDev 6.0, JavaScript, ASP, MTS in a Window NT environment running IIS 3.0. Part of my job responsibilities included mapping distribution information, eliminating redundancy in the database and building a data warehousing solution to analyze sales data and provide trend analysis for future forecasting, maintaining production and inventory levels. I was also involved in creating sales, ad hoc and inventory level reports using Crystal Reports.
• Systematics Inc., Scranton, PA Jul 1992 - Feb 1993.
• IBM, Rochester, MN Mar 1992 - Jul 1992.
• Mastech, Pittsburgh, PA Oct 1991 - Feb 1992.
• Tata Consultancy Services, India July 1988 - Oct 1991.

Education

Bachelor of Engineering
Bachelor of Science (Physics)