SUMMARY

• 4 years of experience in Application Software development using webMethods, Workday, Oracle 10g/11g.
• Worked on Workday Integration, EIB, Custom Reports
• Extensively worked on webMethods run time components namely Integration Server, Broker, and Trading Networks, Workflow and e - Standards module
• Worked on various webMethods Adapters such as JDBC adapter, DB Adapter
• Experience in creating and consuming Webservices using webMethods Integration Server and webMethods Designer/Developer.
• Experience inObject Oriented Analysis (OOA)andObject Oriented Design (OOD)usingUMLand designer tools likeRational Rose, Rational Unified Process
• Experience in designingUML diagrams(Class, Sequence and Collaboration diagrams using UML).
• Experience increating, validating and parsing XML documents.
• SQL and PL/SQL programming experience including stored procedures, functions, triggers, indexes and exception handling.
• Created database objects like tables, views, sequences, indexes using Oracle tools like SQL*Plus, SQL Developer, Toad.
• Strong working knowledge of Loading Data using SQL* Loader and PL/SQL.
• Strong understanding and implementation of quality processes and key process areas.
• Knowledge in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses using Informatica Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Created mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, Unconnected lookup transformations.
• Have knowledge about reporting tools like Crystal Reports, IBM Cognos, Oracle Reports.
• Assisted QA team in preparing unit test cases, conduct unit testing, assembly testing, system integration testing and providing support to business acceptance testing and post implementation support.
• Have knowledge about fast paced AGILE environment.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with team, client and customers.

TECHNICAL SKILLS

Languages & Technologies: Oracle SQL, PL/SQL, C, C++, HTML, Javascript, XML, XSLT, WSDL

Operating Systems: Unix,Windows 8/7/XP/NT/Vista

Databases: Oracle 11g/10g/9i/8i, SQL Server 2005/2008 MS Access

Integration Tools: webMethods IS/TN 7.x/8.x/9.x, webMethods Designer/Developer,Broker,MWS, Informatica Power Center 9.1/9.01/8.6.1

Reporting Tools: IBM Cognos, Crystal Reports, Visual Studio 2012, Erwin Data Modeler

Cloud Technologies: Workday HCM, Integration EIB, Cloud Connection,Workday Studio

Other Tools & Utilities: SQL Developer, SQL* Plus, TOAD, SQL Loader, HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential

Workday Consultant

Responsibilities:

• Created design document and mapping document.
• Designed and developed Custom Reports using Workday
• Created Integration System using EIB and CCW
• Written XSLT Transformations for EIB

Environment: Worday 23, EIB, XSLT, Calculated Field, CCW

Confidential, CA

Integration Consultant

Responsibilities:

• Responsible for Planning, Analysis, Design, Development and Support of the applications
• Worked with various data/file transfer methods like FTP, SFTP, http, https
• Involved in documenting the interface specification and mapping specification for all the interfaces.
• Developed Flow services using the pub-sub model to handle the incoming data.
• Worked with various java services for conversions and manipulations of data while mapping.
• Create XSLT Tranformation for inbound and outbound transactions.
• Performed the unit testing and documented the results for all the integrations.
• Involved in the integration testing and resolved issues that arise during the testing.
• Worked on major critical projects like the implementation of automating the Global Recruiting and Hiring process with external vendor Kenexa and FNX to Reval Corporate Treasury.
• Actively participated in HR Data Access webServices project.
• Provided 24x7 Production Support for highly time-critical FI, HR interfaces carrying sensitive data (like credit card, personal data) and made sure client's service level agreements.

Environment: webMethods IS, Broker,Trading Networks, MWS Oracle, XML, EDI, Win 2008, UNIX, SOAPUI, Citrix, Service Manager

Confidential, Florida

Developer (webMethods/Oracle)

Responsibilities:

• Designed and developed flow services to publish/subscribe, performed simple and complex mapping, applied business logic, transformations for both A2A and B2B interfaces
• Experience with RosettaNet(PIPs),EDI,webServices and Connection Issues.
• Configured Broker settings, processing criteria, thresholds, timeouts, serial and concurrent processing as required and broker performance tuning.
• Trading network development and configuration, partner profiles, processing rules, docTypes, public queues.
• Created high level and detailed designs, canonicals, message patterns.
• Worked with flow and java services with necessary Mappings, Validations and Business Rules
• Developed Customer Error Handling Routines

Environment: webMethods, Oracle, Java, XML, webServices, XSLT, SOAP, WSDL, XML, XSD, Eclipse

Confidential, NewYork

PL/SQL Developer

Responsibilities:

• Designing the control file to load data from flat files obtained from various interfaces using SQL*Loader.
• Generating PL/SQL scripts for data manipulation and validation and created tables, views, stored procedures, triggers, queries in the application using SQL Developer.
• Creating indexes on the tables for faster retrieval of the data to enhance database performance.
• Performing SQL and PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN and SQL*TRACE.
• Supported AdvancePL/SQL using Cursor, REF Cursor.
• Creating of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL* plus.
• Using the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data in the data warehouse.
• Created mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, Unconnected lookup transformations.
• Involved in Debugging and Troubleshooting Informatica mappings.
• Working on the changes in the Informatica Mappings and testing them for Analyze and Fix gaps in Daily Jobs
• Participating in the continuous enhancements and fixing of production problems.

Environment: Oracle 11g/10g, PL/SQL, SQL Developer, Toad, Autosys, SQL* Loader, SQL* Plus