Sheetal Agrawal **** Yorktown St. # **, Houston, TX 77056 t5jb47@r.postjobfree.com

EXECUTIVE SUMMARY

MCTS .Net, Oracle PL/SQL, CCNA and ITIL V3 certified MIS / IT professional with strong educational background and over 3 years of multinational work experience in developing web application following complete Systems Development Life Cycle process.

EDUCATION

Master of Science- Management Information Systems (MS-MIS) (GPA: 3.95 / 4.00)

University of Houston - Clear Lake, Houston, Texas Dec. 2010

(University Merit Scholarship for Women in Business)

Master in Computer Application (MCA)

Banasthali Vidyapith, Rajasthan, India June 2004

Bachelors in Commerce (BS)

Pt. Ravishankar Shukla University, Chattisgarh, India April 2001

PROFESSIONAL CERTIFICATION

CCNA - Cisco Certified Network Associate (640-802) Cisco Certified 2010

MCTS .NET Framework 3.5 ASP.NET Application Development (070-562) Microsoft Certified 2010

ITIL V3 Foundation in IT Service Management EXIN Certified 2010

Oracle PL/SQL Developer Associate Oracle Certified 2010

.NET Framework 2.0 Windows Based Client Development (070-526) Microsoft Certified 2009

DB2 and WSAD/RAD (Websphere Studio Application Developer) IBM Certified 2003

TECHNICAL SKILLS

Operating Systems Windows 98/NT/2000/XP/Vista/7

Languages C, C++, Visual Basic, Java, VB.NET, C#

Web Technologies ASP.Net, ASP, XML, CSS and HTML

Scripting Languages Java Script

Development Tools Visual Studio 6.0

Framework / Web Servers .NET framework / IIS

Database Oracle 8i, SQL, PL/SQL, MS-Access, Advanced DBMS

Others Advanced Networking, Systems Analysis & Design, Clarity Project Management, MS Office, MS Project, MS Visio, Microsoft SharePoint, QTP, System Development Life Cycle (SDLC)

ASSIGNMENTS

Systems Specialist Intern- IT Infrastructure & Operations Services Division 08/2010 - 12/2010

Baker Hughes Inc. (Houston, Texas) Global Oilfield Service Company operating in 90 countries with 35,000 employees

Description Support Project Portfolio Managers (PPM) using MS Project and CA Clarity PPM tool, Closing SAP internal orders, ITIL Service Desk restructuring, Microsoft SharePoint architecture, Survey end users for AT&T transition project

Achievements Designed new SharePoint frontend for Workspace, Evaluated progress status for 151 projects under 13 Project Managers using MS Project & CA Clarity tool, Updated AT&T user information list for 1500+ users in 3 days and surveyed users across USA and Canada, Updated inactive and ageing group status in ITIL Service Desk. Followed up and closed 22 internal orders in SAP.

Systems Engineer 08/2004 - 12/2007

Tata Consultancy Services (India) Asia’s leading IT & Business Solutions Company operating in 47 countries with 108,000 employees

Client: American Express (FL, USA) Leading global payments, network & travel company operating in 130 countries

Project: Integrated sales & servicing system providing unified front-end regardless of the back-end interface. System used by service reps to satisfy customer enquiries regarding account details, activity summary, relationship management and maintenance.

Responsibilities: Requirement gathering and analysis, Sizing, High level & low level design, Coding, Unit and Assembly Testing, Reviews and some project level initiatives, Synchronization among various stakeholder teams across locations and organizations.

Solution Environment / Tools: IIS, ASP.NET, VB.NET, Visual Studio, HTML, XML, CSS, JavaScript, SQL, Web Services

Details of the project worked: A) to E) mentioned below.

Project A): Reactive Underwriting III 2007

Description Reactive Underwriting project is to improve handling of Card-member phone or internet requests for account changes that require a risk assessment. This project is to enable real time decision making of Reactive processes. These real time decisions leverage the risk accessing capabilities of the CAS platform to reduce turn around time and provide increased customer service.

Achievements Developed a filtration system for card member screening. Achieved the following client benefits: a) Enhanced customer experience, b) Less repeat requests for customer service and c) Real time decision making & quick turnaround.

Project B): XPT 3 B Change Control 2006 - 2007

Description Project is about the generation of client’s periodic credit card statement by fetching the information from the Legacy database & the new TRIUMPH database. ‘Balance summary’ demand generates the credit card statement every month grouping them based on the billing dates. For converted accounts, last billed details lie in legacy & thus are not available in Triumph. Indicator maintained in the demand decides whether data is pull from legacy and/or Triumph. Project is to route the profiles to get the data from Legacy database for such converted accounts in such scenario.

Achievements Resolved balance enquiry error in a data retrieval system during migration phase of AMEX credit card accounts from Legacy to TRIUMPH system, through coding in VB.net and XML.

y

Project C): CLP (Customer Level Pricing) Fixed to Variable 2006

Description Project is to implement the functionality of pricing/re-pricing CMs to a lower variable rate and provide them with the flexibility to make different rate type offers. This functionality will allows American Express to re-price Fixed Rate APR to a Variable Rate. The standard purchase calculated APR and DPR information will be included on the CLP reactive disclosure letters sent to successfully re-priced CMs for this project.

Achievements Changed application’s user interface by coding in VB.NET, Javascript and HTML. Previously when a customer requested a lower APR, only a same rate type (fixed to fixed or variable-to-variable) was offered. As per Compliance, all disclosure letters should include standard purchase calculated Annual Percentage Rate (APR) and Daily Periodic Rate (DPR) as mandated by Disclosure Regulations.

Project D): Emerald Savings Accelerator 2005 - 2006

Description Emerald is an Annual Cash Rebate product. This module-involved development of the components required to service the Emerald Card members. It involved 7 hub services to interact with the backend.

Achievements Developed applications in VB.NET, JavaScript, HTML & SQL for generating Emerald Card customer spend report, reward points calculations and card transaction report. Project increased service level for Emerald card members.

Project E): Alero (Mint Credit Card for Teenagers) 2005

Description Amex introduced a new scheme under which a basic cardholder can get credit card (Alero) issued for teenagers in US for a specific amount to be used for specific purpose up to a specified limit. Project is about handling and processing of request received from basic card holders for the issuance of the Alero card based on certain rules and validations.

Achievements Developed from scratch an application tool for the new card. Project is for the business purpose of promoting Increased spending in the American Express network

SUMMER INTERNSHIP PROJECTS (MCA)

Project: Virtual Office Management 2004

Description The project developed an application to enable users working for a company to manage project, communicate and efficient share resources through internet or intranet. The main features provided by the system are:

• Post information/queries which will be viewed by the whole or a part of the group.

• Reserve/Unreserved conference room, cab, canteen, chat rooms etc.

• Access to contacts information of the other employees and to update one’s contact information.

Track project status and task completion status of the individual.

Software/Languages Java Servlet, JavaScript and HTML using Oracle as Database

Project: Request Tracking Tools 2003

Description The project developed an application to manage the Change Request generated from the Client. The application provided facilities to generate, modify, assign and track a Change Request.

Software/Languages JSP, JavaScript and HTML using MS-Access as Database

Project: Banking System 2002

Description The project developed an application that fulfilled the basic objectives of a banking system and provided facilities to open, maintain and close an account and handled transactions by the user.

Software/Languages Visual Basic using MS-Access as Database

Contact this candidate