MANSOOR SUFDER
2204 Howell Farm Point NE
Acworth GA 30101
Ph:404-934-6838
Email [Send email using form at bottom]
Georgia Pacific Atlanta, Georgia
July2002-Current
Contractor Architect/ Senior Systems Analyst/Project Manager
Project Manager eSolutions Marketing.
My current responsibilities include supporting the Building Products Marketing
needs and their campaigns with marketing agencies. I am also responsible for the
Building Products website.
Technologies used: ASP .NET /Visual Basic .Net, ASP, SQL Server 2000, MS
Virtual Earth, ,JavaScript, Sql Server 2000(TSQL, Stored procedures), HTML,
DHTML, Content Management System, Google Appliance etc.
Astute PowerCenter Support (Consumer CRM)
I am currently providing support to the Astute PowerCenter for GP Consumer
Products Consumer Response Center Call Center (Retail, Dixie) with their Call
Center needs.
Customer Management CRM
I have been involved in development of custom developed Sales CRM system for the
GP Sales force to help them manage their Account, Opportunities, Contacts and
Leads much efficiently. I developed data and reporting and Cube model for Sales
Force Automation including Pipeline Analysis, Usage Analysis, Account Management,
Opportunity Management, Contacts and Leads Management.
Technologies used: ASP .NET /Visual Basic .Net, 6/ Web Services(XML, XPath,
SOAP) / SQL Server 2000, Cognos BI Suite, /Visual Studio .Net /JavaScript / Sql
Server 2000(TSQL, Stored procedures), HTML, DHTML, Active Reports, Outlook
automation
Cognos Report Studio Implementation
I have been involved in setup of Cognos BI suite architecture and
infrastructure.
Technologies used: Cognos ReportNET, PowerPlay, Impromptu, IWR. Microsoft .NET,
Cognos and Microsoft scripting technologies
CLIP (Corporate Level Information Project)
I have been involved in development of enterprise wide financial
repository(Financial Data warehouse) where key decision makers/providers of
information have capability to have a more robust common enterprise planning and
Corporate Level Reporting Systems utilizing the Cognos BI(Report NET, Cognos
Analyst, Power Play) and Microsoft BI suite and of tools.
The business drivers include the following:
1) To achieve improved information flow across business with uniform
consistency
2) Make information flow more efficient
3) To provide a single source for the truth - eliminate reporting
inconsistencies
Technologies used: ASP .NET ,Visual Basic .Net, 6, Web Services(XML XSL, XPath,
SOAP) , SQL Server 2000, MS Analysis Services 2000, Microsoft DTS, Cognos BI
Suite(Report NET 1/1.1, Power Play)
Olaris (Online Analytical Reporting System)
I have developed and supported Olaris System (Web-based financial reporting and
consolidation system) for Corporate and different business unit for GP including
CPG, Structural Panel and Lumber, Industrial Wood products, Gypsum. This system
is use by Corporate and Divisional Financial Reporting for consolidation and
reporting across Georgia Pacific’s different Business units.
OLARIS supported the following functions:
• Maintain master chart of accounts
• Receive financial data from approximately 200 division ledgers
• Validation and verification of data for update of centralized database
• Consolidation of total corporation financial data
• Automated financial report generation (Income Statement, Balance Sheet, Cash
flow etc) for internal and external customers
• On-line inquiry to view and drill down on data through three-dimensional
analysis cube
• Controlled access to financial data
• Dynamic historical database which allows for accurate restatement of data due
to organizational realignments
Technologies used: ASP .NET, C#, Visual Basic .Net, 6, Active Reports, Web
Services(XML XSL, XPath, SOAP), SQL Server 2000, MS Analysis Services 2000(Cube
Design and Development), ETL, Sql Server 2000(TSQL, heavy stored procedures
development), MS Reporting, Cognos BI Suite, JavaScript , HTML, DHTML, Active
Reports, Threading, Custom Serialization and others
EIS (Executive Dashboard)
Worked on the Financial Dashboard project to measure different Financial
measures, Key Performance Indicators (EBIT, Cash Flow, RONA, Accounts Payable,
Account Receivable, Inventory, General Ledger, S & D, G & A, Capital Expenditure
) for different Business units (Consumer Products, Building Products) for GP. The
system allowed upper management to visually keep track of the performance of your
overall company’s performance including
• Set performance goals at each level.
• Track key performance indicators.
• Establish measures and criteria for monitoring progress.
• Identify, track, trend and correct problems.
• Design and print key performance indicator reports.
• Understand your organization's financial health.
• Meet regulatory requirements.
Technologies used: ASP .NET /Visual Basic .Net, 6,C#, Web Services(XML XSL,
XPath, SOAP), Active Reports, SQL Server 2000, MS Analysis Services 2000(Cube
Design and development), ETL using Microsoft DTS
Executive Working Capital Project
I lead the development of the enterprise wide Working Capital project. The
project allowed upper management to clean Vendor Master terms and negotiate
better terms with the vendors very effectively and providing enhance analysis AP
and AR performance monitoring tools. WC system gave upper management analysis on
different key performance indicators, more than 12 multidimensional cubes. These
metrics and reports helped in analysis, answering a variety of business
questions:
• Accounts Payable
What is the current balance for a vendor account?
Which vendors are problematic? Why?
What is the cost to pay vendors, including errors, method of payment, and
adjustments?
How has account distribution across analysts changed as business has increased?
What was the total cost/savings for being in variance as related to payment
terms?
What is the average/weighted average days past due?
• Accounts Receivable
What is the average collection period?
What are the days of sales outstanding (DSOs)?
What percentage of A/R is past due?
How does a customer's aging schedule compare with our norm?
What is the customer's average days to pay?
Does the customer take advantage of discounts offered?
Technologies used: Active Reports, MS SQL Server 2000(heavy stored procedure
development), MS Analysis Services 2000(Cube Design and development), ETL using
Microsoft DTS
Sales Speech Application
Developed a speech recognition application prototype for Sales force for GP IT
Innovation Center
Technologies used: Microsoft Speech Server, Microsoft Speech Apis. ASP.NET
GRXML
Training
Financial Excellence
Cognos Training (ReportNet, Power Play, Planning)
Architecting Data warehouse
.NET
Recognition
2003 IT Eagle Award
Southern Company/ Georgia Power/CCC INC Atlanta, Georgia
Aug2000-July2002
Senior Architect /Team Lead
I lead the team of 8 developers. I designed and built the web sites using ASP,
ASP.NET, Visual Basic, Visual Basic .NET, C# .NET, ATL/COM Visual C++,
MTS/COM/DCOM, HTML, DHTML, VB Script, Java Script and much more using Oracle 8i,
SQL Server and DB2 as back end databases, using Site Server automation for
advanced Content deployment for Human Resources, Customer Services, Content
Management, Energy applications. I have built web application to automate the MS
Site Server Administration/ Secure File Access web applications to highly secure
(Applying Encryption to Files/Directories) the content for financial
department/Survey Application/Online Training Application/Online Employee
Portal/Applications that Interface with Microsoft System Management Tool/ Energy
Direct Web Application/Proposal Information Tool and much more.
Projects
Interwoven Development for Content deployment
HR 360 Survey Application
IR 360 Survey Application
Secure Web File Sharing system for Sensitive Documents
Content Deployment System for HR
HR PeopleSoft Migration
Human Resources Portal
IT Auditing Application
DTR (Distribution Trouble Reporting Application)
EReq (Material Requisition Web Application)
Technologies used: Visual Studio .NET, C# .NET, VB.NET, Visual C++, Visual Basic
5,6,ASP,Interdev,MTS, MS Visio, MS Project IIS, VbScript ,Java Script, SOAP, XML,
XSL, JavaScript , Oracle, Sql Server, PL SQL, Active Directory, LDAP, MS Office,
Interwoven , PVCS, HTML, DHTML
NC STATE/CCC INC Raleigh NC Nov99-Aug2000
Senior Architect
I have built the web site using ASP, Visual Basic, MTS/COM/DCOM, HTML, DHTML, VB
Script, Java Script, Access and Site Server for NC State Department of Public
Instruction to submit all North Carolina public school information, Prototypes,
Blueprints files through the upload interface of web site. Wrote Admin interfaces
to automate many other web site procedures
Technical Skills:
Visual Basic 5/6, ASP, Visual Interdev, COM. COM+, VbScript, JavaScript,
Access, HTML, DHTML
CARQUEST Management Raleigh NC June99-Oct99
Senior Architect /Team Lead
I have lead the Team of 3 developers, Developed ETL packages to do Payroll
conversions from ADP and other payroll systems to Oracle Financials. Developed
ETL packages to migrate HR data from SQL Server and mainframe application to
Oracle Human Resources. I migrated payroll system for different sales location to
Oracle Financials Payroll Application. Supported Company’s stock application.
Created the companies Intranet and bringing Oracle Applications online. Created
the Java Applications, DB Applets , Web interfaces Using the JDBC connections by
using Oracle JDeveloper 2.0 Suite. Created and Customized Oracle Applications
reports and forms using Oracle Developer 2000. I worked on ETL processes to
extract the Information from Oracle Financial Applications.
Created Visual Basic COM objects Interface to extract information from Oracle.
Automated standard Oracle Applications and custom procedures. Created and
maintained the project website using Visual Interdev, Visual Basic and Visual J++
Active Server Pages, VBScript. COM+, MTS and MSMQ.
Applications
Payroll Conversion from ADP to Oracle Financial
Stock Application support and enhancements
Oracle Account Payable conversions/enhancements
Oracle Account Receivable conversions/enhancements
Technologies used: ASP, Visual Basic 5/6, Oracle 7.3/7(PL SQL), Developer 2000
, Designer 2000/ Oracle Financials/ Oracle Human Resources/ Visual
Interdev/ASP/Access/Java , ETL
CP&L, Raleigh, NC MAR99-June 99
Access Developer
Developed Databases Energy applications in Access 97, Doing data conversions
from FoxPro 2.6,3.0 databases to DB2 Passport Application by creating MS Access
Interface to run different validations and conversions.
Technologies used: Foxpro 2.5/3, MS Access 97, VBA, Indus Passport
Conseco, Carmal, IN Jan98-MAR-99
Developer
I have developed applications for insurance and inventory systems, Performed
insurance applications conversion from Mainframe to Access 2.0. Developed VB 5
interface to keep track of mainframe jobs for inventory and system support
purpose. Developed Annuity System in Access 97 and VB5. Migrated Old Paradox
3.5,4.0 applications into Microsoft Access 97 database. Developed Front-end
applications for Oracle databases using Oracle Developer 2000, Designer 2000.
Developed and managed oracle database. Creating forms, Reports and graphics with
Oracle developer 2000, designer 2000 managed oracle databases on web through
Oracle web technologies. Developed Internet and intranet e-commerce and Database
backed web applications using ASP, HTML, Visual Interdev 1.0/6.0, MS FrontPage
98, ADO, RDO, DAO in Visual Interdev 1.0/6.0, Internet Information Server 4.0 and
Microsoft Site Server Commerce Edition using Oracle, Access and FoxPro databases
as backend databases. I used Visual Basic 6.0 and Access 97 to develop the
application for SQL 7.0 using SQL Server DMO Library and project files for Access
97.
Y2K Team: I have modified and tested applications written in Paradox, FoxPro,
Dbase, C/C++, Qbasic, Visual Basic for Y2k compliance. I have also tested
mainframe jobs and JCL’s for Y2K compliance using Venture 2000 etc.
Technologies used: ASP, Visual Basic, Oracle, Access, Interdev, Visual FoxPro
Midwest Textiles, Indianapolis, IN Apr96-Jan-98
Web Programmer Network Support
Developed in house applications for sales, inventory using MS Visual Basic 5 and
Access 2/95/97. Maintain and supported Network. Install and configure hardware
and software. Maintain Intranet sites
Technologies used: Visual Basic, Access
T E C H N I C A L S K I L L S
Skill Area Years
Visual Studio .NET 2002/2003, VB.NET, ASP.NET, C#, Visual C++ .Net (using it
since 1999 when first beta came out) 6 Years
Microsoft .NET 2005/SQL Server 2005 since beta 1.5 Years
SQL Server 6.5-2000 DBA/Developer Level exp 5 Years
Oracle 7.3x-Oracle 10G (Developer level experience) 8 years
Web Services/SOAP(WSE 1,2) 4 Years
Visual Basic 4/5/6 10 Years
Microsoft Speech Server 2004/ SALT/ Voice XML(Speech Applications) 2 years
XML/XSL 4 years
ASP Classic(Vb Script/Java Script) 8 Years
COM/COM+DCOM/MTS 7+ Years
Visual C++ 5/6 ATL/COM 2 Years
Cognos Report NET/ Power Play/Metrics Manager/Transformer 1.5 Years
Microsoft Analysis Services 3 Years
HTML/DHTML 8 years
Java(J2EE, JSP, Servelets, Web services) 1.5 years
FoxPro/Dbase/FoxBASE/Paradox 3+ Years
MS Office 95/97/2000/XP/2003 VBA 8+ Years
Client/Server system development 5+ Years
Full Life Cycle Development 8+ Years
Crystal Reports + 2 Years
Active Directory/ADSI/LDAP 2 Years
MS IIS 4/5/6 6 Years
Microsoft Site Server Commerce Edition 2 Years
MS Access 2 /97/2000/2002/2003 10 Years
DB2 1 Year
MS ETL Technologies 3 Years
Oracle Developer /Designer /Discoverer 2000 3 Years
Data Warehouses 3 Years
Power Builder 5.0 1 Years
Microsoft Visio 3 Years
Rational Rose 1 Years
Microsoft Site Server 3
Interwoven Content Management .5
Visual SourceSafe 5 years
PVCS Version Management 1.5
EDUCATION
AIU Online
BS in Computer Information Sciences
Indiana University Purdue University at Indianapolis, Indianapolis, IN
BS in Computer Information Sciences, Minor in Business
Pike High School, Indianapolis, IN
High School Diploma, GPA 3.7
|
