Sql Server Project Manager

HARA SAHANI [pic]

*** ***** **, **, ************, NJ . ph: 435-***-**** .

****.******@*****.*** . ****@******.***

EXPERIENCE SUMMARY:

. Eight years of IT experience includes Business requirement analysis,

Designing, Coding, Testing and Deploying in various environments like

webMethods Integration Platform, Data warehousing tools, Java, VB, and

Oracle.

. Over four years of experience in Design and Development for EAI,

Enterprise Integration (A2A) and Business Integration (B2B) using

webMethods Product Suite.

. Exposure to complete Integration solutions using webMethods

6.5/6.0.1/4.6 Suite

. Designed business processes using webMethods Modeler and webMethods

Designer 7.1

. Extensive experience in supporting Informatica applications.

. Experience with Integration Scenarios between different Database's

Oracle, SQL Server, PeopleSoft and Oracle Applications.

. Knowledge in administering Integration server, Broker, Sizing,

backup/recovery, managing and controlling log information

. Around two and half years of expertise in Client/Server Applications

using JAVA, JDBC, Oracle, PL/SQL and etc.

. Worked on JDBC, People Soft, Oracle Apps, SAP and Siebel Adapters.

. Experience in developing queries, stored procedures, PL/SQL, and

triggers using Oracle 8/9i and MS SQL Server 7.x/2000, SQL Server 2005

. Excellent communication skills, ability to grasp new concepts and

capable of working in a team environment as well as independently.

TECHNICAL SKILLS:

Operating Systems : UNIX (Sun Solaris, IBM AIX, HP-UNIX)

and Windows'95/NT/2000/XP

Programming Languages : JAVA (JDBC, Servlets, JSPs), C ++, VB and

UML.

Internet Technologies : XML, HTML and JavaScript.

RDBMS : Oracle 7.x/8.0/8i/9i, MS SQLServer 2005 and MS-

Access.

WebMethods Suite : webMethods Integration Server 4.6/6.0,

Webmethods Enterprise Server

Webmethods Enterprise Integrator, JDBC Adapter,

Enterprise One Adapter,

Web Servers : Weblogic and Netscape ipanet WebServer

Document Standards : EDI (ANSI x.12, UN/EDIFACT), HIPPA, and

XML.

EDUCATION:

Masters in Computer Science

Utah State University, Utah, USA

Bachelors of Science

National Institute of Science and Technology, India

PROFESSIONAL EXPERIENCE:

PRD, Johnson & Johnson, NJ

May'08- Present

Lead Webmethods Developer/Architect

Responsibilities:

. Architected, Designed and developed Business processes Model (BPM)

that generates runtime elements to execute business processes using

webMethods Modeler and webMethods Designer 7.1.

. Architected, Designed and developed various validated and non-

validated business process models and error handling units using

Webmethods Designer for Clinical Trial Management System(CTMS)

. Developed and tested custom webMethods interfaces using webMethods

Developer 7.1.2

. Supervised the upgrade process and upgraded several interfaces and

Business process models from webMethods 6.5 environment to webMethods

7.1

. Preparation of requirement and design specifications

. Developed and designed the Data mapping and the Data Transformations

using webMethods Developer 7.1

. Developed test cases, involved in unit testing and migration of code

from various environments for different business process models

. Architected and implemented various interfaces for CTMS - Clinical

Trial Management System.

. Created KPI rules Event and Threshold rules using webMethods Optimize.

. Designed daily synchronization jobs that would take data from OPX2,

apply some data modification and write it into the Siebel system.

. Monitored business system components and process models using My

webMethods Server and Optimize

. Designed various real-time interfaces that extract data from Sieble

CRM and update Oracle database and vice versa

. Installation and configuration of webMethods 6.5 servers.

Wyndham Vacation Owners, FL Nov'07-

May'08

Lead Webmethods Developer

Wyndham Vacation Ownership, a subsidiary of Wyndham Worldwide, is the

world's largest vacation ownership business, as measured by the number of

vacation ownership resorts, vacation ownership units and vacation ownership

interests. Wyndham Vacation Ownership includes marketing and sales of

vacation ownership interests, consumer financing in conjunction with the

purchase of vacation ownership interests, property management services to

property owners' associations, development and acquisition of vacation

ownership resorts.

Project: Online Status of Referrals and PCI compliance.

Responsibilities:

. Installation and configuration of webMethods

. Created Integration Server Broker connection settings.

. Preparation of requirement and design specifications

. Designed and developed SOAP based web service clients for data

gathering from the online referral portal and post it to the Oracle

database.

. Designed web services to store and retrieve credit card information in

a data vault using base 64 smart key concepts.

. Designed a business process model that creates the base 64 smart key

using Modeler.

. Involved in the development and testing of custom XSD and flat file

schemas for data transfer.

. Used Webmethods BAM and Optimize.

. Implemented integration of WVR consumer portal with Oracle Database

. Designed daily synchronization jobs that would take data from a

external system, generate smart key and post it onto data vault.

. Implemented a reverse synchronization job, which extracts data from

Oracle database and updates eternal resources

. Designed various real-time interfaces that extract data from CRM and

update Oracle database and vice versa

. Installation and configuration of webMethods 6.5 servers.

Alcatel-Lucent, IL

July'07- Nov'07

Project Manager for Webmethods team

Alcatel-Lucent is the first truly global communications solutions provider,

with the most complete end-to-end portfolio of solutions and services in

the industry. Project: Reverse engineering of EDI interfaces.

Responsibilities:

. Installation and configuration of webMethods 6.1

. Set Migration of code packages from one environment to

another.

. Worked on creating EDI and EDIINT mapping documents

. Managed offshore and onsite resources

. Preparation of requirement and design specifications

. Provided leadership for projects related to business process

integration

. Preparation of Test Plans and User Training Documents.

. Mapping of EDI documents received from the trading partners with the

existing Lucent applications

Electrolux, Augusta, GA Dec'06-

June'07

Webmethods Consultant

Electrolux Home Products is the North American marketing and distribution

arm of Sweden-based appliance maker - AB Electrolux. Electrolux is also a

top brand in US markets. The division sells home appliances such as air

conditioners, refrigerators, microwave ovens, stoves, electric and gas cook

tops, dishwashers, washers, dryers etc.

This project involves the installation and configuration of webMethods

servers and development of a common connectivity framework that allows

Electrolux applications to extract data form a CRM system and update the

data into SQL server 2005 database on a daily scheduled basis and vice

versa. The project also involved implementation of several real-time

interfaces that will enable the communication between the CRM system and

SQL server database.

Responsibilities:

. Installation and configuration of webMethods

. Created Integration Server Broker connection settings.

. Created and managed SAP Adapter Connections.

. Generated document types for IDOC

. Worked on routing messages through SAP adapter, routing IDOCs through

SAP adapter.

. Preparation of Test Plans and User Training Documents.

. Coordinated UAT and QA activities for the developed Integrations.

. Designed and developed EJBs and SOAP based web service clients for

data gathering

. Involved in the development and testing of routines for the conversion

of XML to flat files.

. Implemented integration of CRM system with SQL server 2005 Database

. Created and Scheduled daily synchronization jobs that would take data

from a CRM system and update the SQL server database.

. Created web connectors and adapters to extract data from the CRM

system.

. Implemented a reverse synchronization job, which extracts data from

SQL server database and updates CRM data

. Implemented various real-time interfaces that extract data from CRM

and update SQL server database and vice versa

. Added and configured HTTP/S, FTP/S, File Polling Ports to the

Integration Server

. Developed various Utilities using Flow services.

. Worked with various custom Flat Files received from Mainframe system,

translated into documents.

. Developed test cases involved in unit testing and migrated code from

various environments.

. Converted all documents in 4.6 to 6.1 using migration services.

. Designed Model Business processes that generate runtime elements to

execute business processes using Webmethods Modeler.

Environment: webMethods Integration Server 4.6/6.1, Trading Networks

4.6/6.1 webMethods Modeler 6.1,Document Tracker, SQL Server, Java 1.3.0,

Windows 2000.

Ethicon, Somerville, New Jersey July'04

- Nov'06

webMethods Developer

ETHICON Inc, is a global medical device company, has been a leader in

surgical sutures (stitches) for more than 100 years. Ethicon has four

business units that operate separately under the ETHICON umbrella, wound

management, women's health, and cardiovascular surgery.

Responsibilities:

. Requirement gathering, Gap Analysis, Client & User interaction for

design.

. Install and configure the WebMethods Platform 4.6 (for Production,

Development and testing)

. Develop and enable a user interface to display and gather data using

Webmethods Workflow.

. Architect, Design, development, Integration of Applications.

. Created Integration Server Brokers.

. Extensive experience in supporting Informatica applications.

. Used Webmethods Broker Administrator tool to administer Webmethods

Brokers.

. Configured Integration Server with Oracle 9i and SQL Sever 2000

databases.

. Created project and defined source content of a project using

Webmethods Deployer.

. Translated business requirements into Informatica mappings/workflows

.

. Mapped a built project to target system using Webmethods Deployer.

. Developed and designed the Data mapping and the Data Transformations.

. Created and Monitored Informatica Workflows using Workflow Manager and

Workflow Monitor

. Designed the services that do the transformations using transformation

rules.

. Involved in the design of Java Services.

. Configure HTTP/FTP, File Polling Ports

. Extensively used Load and Query Services, String variables, FTP, HTTP

and Email services.

. Working in Production Support team to fix issues and to do the code

reviews plus improving the performance of the building applications.

. Migrating existing applications from webmethods 4.6 to webmethods 6.1.

. Installation and configuration of the WebMethods server and Adapters

like JDBC Adapter, SAP Adapter, websphere MQ Adapter, and Mainframe

Integration Server.

. Developed Java services, DSP and OUTPUT Templates to maintain the

business partner Profile in xml file.

Environment: webMethods 4.6/6.1 (Integration Server, MIS Server, JDBC

Adapter, Trading Networks), EDI, Modeler (Business Integrator), XML, JDK

1.3/1.4, J2EE, FTP Client, FTP Server, MQ Series 5.1, Visual Basic 6.0,

COM, ASP, Unix Shell scripting, Oracle 9i, Windows NT, AIX 5.1 and Solaris

2.7.

OSG Inc., UT, USA May'03

- July'04

Software Developer(Part time)

Development of an Enterprise Resource Planning/Manufacturing Comprehensive

and real-time Execution System that supports multi-country, multi-facility,

multi-currency and multi-language business environments using Java in the

Windows environment according to need of customers.

Responsibilities:

. Working with seasoned professionals in the development of a very

comprehensive client-server, graphical, object oriented ERP package,

written in Java.

. Involved in the development, modification and debugging of the

software modules using Java.

. System Administrator Applications: User Group and User Access

Privileges, System Configuration Details.

. Sales and Marketing Applications: Contact/Prospect Management,

RFQs/Quotation /Estimation, Forecasting, Customer Order Processing,

Customer Order Tracking, Sales Commissions, Credit Card Acceptance,

Return Authorization Processing, Competitor Tracking.

. Inventory and Warehouse Applications: Stock Reorder Planning,

Warehouse/Distribution Control, Receiving/Issuing and Shipping,

Packaging, Vendor Certification/Performance, Incoming Material

Inspection, Cycle-Count Planning.

. Engineering and Manufacturing Applications: Bill Of Material, Virtual

Work Centers, Manufacturing Planning, Product Data Management, Shop

Floor Control, Quality Assurance, Engineering Change Orders, Tool

Management, Capacity/Material Requirements Planning (CMRP), Activity

Based Scheduling.

. Financial Accounting Applications: Multiple Currency Capability,

Currency Exchange Rates, Numeric/Currency/Unit Cost and Date Formats,

Tax Structure Management, Account Receivable, Accounts Payable,

General Ledger, Fixed Assets, Time and Attendance, Payroll.

. Designed and delivered operational systems for a new consolidated

billing service, reducing the customer's accounts payable cycle time

by 25% by providing enhanced audit capabilities and minimizing

paperwork.

. Improved efficiency of billing process and customer integration by

600% with Oracle Financials Integration and Streamline billing

projects.

. The GUI is connected to database. Fetch the data according to an

action performed and displayed it into the GUI.

. Performance and stress testing.

Environment: Java & J2EE, JDBC, Oracle, Informix, Sybase, Microsoft SQL

Server, Oracle, and Windows-NT 4.0.

Space Dynamics Lab, UT.

Aug'01- Apr'02

UNIX Admin(Part time)

Responsibilities:

. Performed all software upgrades, file system maintenance, network

printer maintenance and shell scripting.

. Performed daily, weekly, quarterly, and yearly

. Performed all daily administrative functions on HP-UX systems and Sun

Solaris servers such as adding & deleting users, system performance

monitoring, and printer administration.

. Managed and performed daily incremental and weekly full backups on

UNIX servers and Windows NT mail servers.

Environment: UNIX, HP-UX, Sun Solaris, Sun OS, sql, JAVA, WindowsNT/2000.

NGCS, Hyderabad, India Mar'99 -

Aug'01

Software Developer

Designing and implementing a sales management system for a

distribution agency that deals in the distribution of Indian oils (Servo

Lubricants). This system keeps track of the different products and their

available types like drums, barrels, cans, etc., and also keeps track of

the transactions like customer details, Quantity ordered, invoice entries,

receipts, etc., This system generates monthly statement of stock based on

the quantities sold and quantities received from Indian Oil Corporation.

This system also generates bills for the quantity sold and quantity

received.

Responsibilities:

. Involved in Development of the Application from different stages of

designing of the software keeping in view the End-user requirement.

. Developed Screens in the front-end of the application and coded

various Data input validations and security conditions.

. Developed tables for storage of data in the backend and Easy

retrieval when prompted.

Environment: VB 5.0, Oracle, SQL, PL/SQL

Tata Motors, Jamshedpur, India

July'98 - Mar'99

Software Developer

This software is developed on windows platform using client/server

technology. This project contains 3 modules: Purchase, Receive, and Issue

sections. The module activities are raising indents, enervating purchase

orders, receiving goods from vendors and issuing goods to various

departments. Each module provides various features like purchase orders,

stock reports etc.

Responsibilities:

. Created Database using Oracle7.1.

. Prepared Software Requirements Specifications and Design

Documentation.

. Maintained an on-line system for the information about the

Consumer items and related order.

. Generated reports like ordering file, Date of delivery, and

quantity or items.

. Prepared the information like Date-wise index, Item-wise index

and Consumer name-wise index.

Environment: Oracle 7.1, Developer 2000, Crystal Reports

Contact this candidate