OBJECTIVE:
Seeking for a challenging and rewarding position as an TIBCO Developer

KEYWORDS:

• Information Technology Professional with 6 years of experience in Application development and Production support of Energy/Telecom Industry.
• Comprehensive knowledge of Software development life cycle including analysis, Physical and Logical design, Resource Planning, code development, testing, implanting and maintenance with good understanding of Project Methodologies.
• Experienced in reviewing and analyzing functional specifications and project specifications and develop solutions to user problems.
• Extensive experience in Enterprise Application Integration (EAI) using tools from TIBCO Suite-TIBCO Business works, TIBCO Administrator, TIBCO EMS, TIBCO Designer, and TIBCO Hawk.
• Extensive experience in implementing SOA concepts by designing and developing Web Services using SOAP/HTTP and SOAP/JMS with TIBCO Business Works.
• Successfully installed, configured, developed, tested, deployed and administered a integration projects using TIBCO Business Works integration platform and TIBCO Administrator.
• Extensively used TIBCO Administrator to administer the Business process, written custom hawk rule bases, Shell scripts to automate the process restarts and exception handling.
• Extensive experience in designing and developing Common Services Framework (CSF) at an enterprise level which will be reusable
• Experienced in Design, Development, Testing and Implementation and Deployment of EAI systems.
• Extensive experience in writing PL/SQL packages, stored procedures, functions and database triggers using Oracle latest features.
• Experienced in performance tuning database optimization and query optimization of SQL statements.
• Involved in DBA activities as Backup/Recovery, Export/Import, Performance Tuning, Creating users and granting role/privileges.
• Integrated Shell Script, PL/SQL and used CRON to schedule batch jobs. Experienced in Data loading using UNIX Shell scripts, SQL*Loader.
• Hands on experience in Core JAVA, J2EE and JDBC.
• Educational knowledge of C/C++, JAVA programming skills. Knowledge of OOP Principles and design patterns.
• Good knowledge of XML related technologies like XML, XSLT, X-path, XML Schemas and HTML.
• Technical documentation of different lifecycle deliverables, design and system specifications and user manuals.
• Worked on 24*7 environments to provide production support.
• Experienced in Version Control Tool like CVS, Perforce, Tortoise SVN, Visual Studio.
• Good team spirit and organized working habits with a willingness to learn new concepts.
• Excellent communication and presentation skills along with time management.
• Self- Starter, motivated and eager to learn new things and comfortable in high intensity and challenging work environment.
• Ability to readily grasp complex architectural environments, work from general guidelines under strict deadlines and quickly adapt to new environment.

EDUCATION: Master of Science in Electrical Engineering

SKILL SET:

UNIX, Sun Solaris v.2.8, Linux9.2 , Windows XP/VISTA/7

Languages:

C, C++, Java, HTML, PL/SQL

RDBMS:

Oracle 8i/9i/10g/11g

Query Tools:

TOAD, SQL Developer, SQL Plus, PL/SQL Developer

Reporting Tool:

Oracle Forms 9i/10g, Oracle Reports 9i/10g

TIBCO Messaging:

Rendezvous 7.x/8.x, Enterprise Messaging Service 4.x/5.x.

TIBCO Integration:

TIBCO Business Works 1.x/5.x, TIBCO TRA 5.x, TIBCO Administrator 5.x,TIBCO Hawk 4.x

Web Services:

SOAP/JMS,SOAP/HTTP, WSDL, XML, XSLT, XPATH

Web Technologies:

HTML, XML

Version Control Tool:

CVS, Perforce, Tortoise SVN, Microsoft Visual Studio 10

Other Tools:

Eclipse, MS Viso, Erwin, JDK 1.6, Informatica 7.0, LISA 4.0
Spring

WORK EXPERIENCE:

Confidential, June 2011-Till Date
Houston, Tx
EAI-Application Management Solution Designer
Responsibilities:

• Developed XSD as per data model for process enrollment service and Logging and Exception service.
• Developed enterprise wide Web services for processing contracts, providing Logging and Exception service. Implemented Web services using SOAP/HTTP and SOAP/JMS protocols and communicated with .NET framework on the front end.
• Configured common framework services like Notification service, FTP service.
• Developed Tibco Business Works processes to call various services like Pricing service, Credit check service, Contract generation service across different interface.
• Implemented common logging and error handling service for all Interfaces.
• Extensively worked on XML, XSLT, XSD and XPATH and tested interface for functionality and performance.
• Created design time libraries for sharing common services and shared resources for different projects.
• Configured EMS transport and transport objects like Queues, Topics and Bridges and worked in access level control for creating users, groups.
• Involved in the creation of Hawk rules for monitoring and managing the developed processes.
• Interacted with third party vendors to standardize and agree upon XML schemas that would be implemented over HTTP.
• Coordinated with offshore team and involved in project planning and status meetings
• Involved in the design & code reviews for the interfaces with the development team
• Created mapping documents for Pricing, Credit Check and Document Generation Interfaces.
• Maintained Source code of the applications for various releases using Microsoft Visual Studio 10.
• Involved in the deployment of the project into various environment by using TIBCO Administrator and App Manage Utility. Solely maintained the deployments of Test environments.
• Worked for production support team to fix production bugs and implement the code changes. Provided 24/7 production support for several key TIBCO interfaces.
• Prepared documentation for the interfaces developed.
• Created deployment documents and followed release management steps for Business releases.
• Participated in application performance tuning, fine tuned interfaces to increase system throughput.
• Developed Database application to meet business need using Oracle PL/SQL features. Created Packages, Procedures, Functions and Triggers.
• Created Database objects like tables, synonyms, sequences, views during development. Enforced database integrity using primary keys and foreign keys.
• Developed code as per business needs to perform archive and cleanup of data across different interfaces.
• Implemented XPath and XQuery expressions. Generated XML instance as per XML Schema required to call different services. Loaded data into relational tables using XML payload.
• Tuned slow running queries. Generated Explain Plan. Asked DBA to generate the trace file. Ran TKPROF and used for tuning. Created indexes, modified query to use index.
• Used hints, perfomed index rebuilt as required.
• Developed Test cases and Test scenarios for each interface.
• Performed happy path testing and Exception testing for each Test case. Ensured all business scenarios were covered.
• Used soapUI to perform happy path testing and TIBCO BW to perform Exception testing. Created business data and test processes with different possible error scenarios during Exception testing. Ensured all exception data got logged in correct database. Made sure email notification was being sent to correct business users.
• Actively involved in Performance Testing for different interfaces. Made sure service can handle requests as per business need. Modified code and deployed correspondingly adjusting parameters like MaxJobs, Flow limit, Activiation Limit for each process starters.
• Modified BW code to release memory after extracting clob as part of performance testing.

Environment: TIBCO EMS 4.6, TIBCO Rendezvous 7.x, Active Matrix Business Works 5.3, TIBCO Business Works 5.x, TIBCO Administrator 5.3, TIBCO HAWK 4.6, Oracle 11g, TOAD, PL/SQL Developer, SQL Developer, SQL*Plus, Microsoft Visual Studio, FileZilla, Stylus Studio, soapUI 4.5

Confidential, March 2008-June 2011
Taylor, Tx
Application Developer II
Responsibilities:

• Actively participated in gathering requirements, analysis and understanding the business functionality.
• Designed various approaches for very complex interface.
• Involved in creation of High-Level and detailed Design documents.
• Created detailed end to end mapping document and technical design document for each interface.
• Configured common frameworks like Generic DB Processor, Common Error Handling and Logging, Notification service.
• Designed and developed TIBCO Business Works processes to manage transactions and integrate with Oracle Applications.
• Developed TIBCO BW notification processes to notify business user with database and application errors.
• Developed web services in TIBCO BW using Service activity which implements multiple operations using HTTP and JMS as end point transports.
• Created various XSD schema files containing definitions for Notification, Error logging, Database Transactions.
• Developed various XPath transformations to transform input data.
• Involved in ADB adapter configuration.
• Followed Tibco Business Works best practices while designing and developing the solution for the above real-time interfaces.
• Involved in writing of various shell scripts for automation some of the processes.
• Created the unit test plan and Integration test modules for the developed processes.
• Used various Business Works activities in developing re-usable business processes.
• Created Queues Topic on EMS Server. Configured Durable JMS Topic Subscriber.
• Developed custom Java functions to perform necessary transformation, parse xml documents.
• Responsible for writing logic to trigger business events, created TIBCO configuration files for all events across different Interfaces.
• Wrote scripts and created configuration files for House Cleaning, Notification and Archive Agents.
• Added extra Process Agent/Business event to the existing Framework as per business need and deployed and tested in different environment.
• Involved in deployment of project into various environments using TIBCO Administrator. Performed application testing in different environments.
• Provided administration support to maintain deployed applications and troubleshoot any problems that arise.
• Configured the TIBCO HAWK Rule bases for monitoring the applications and set up and managed Alert emails for providing 24*7 supports.
• Tuned the performance of Business Works Engine and EMS for load and memory optimization.
• Implemented business logic by creating PL/SQL Stored Procedures, Packages, Functions and Triggers to compute Day Ahead Market and Real Time Market CMM Integration Layer Calculations. It involved pulling Hourly, Fifteen Minutes and Five Minutes data from different markets and performing necessary calculations to get the estimated and actual volumes and price for each Market Participant on Hourly and Daily basis.
• Wrote PL/SQL procedures to move data across different Interfaces. Performed necessary data transformation and validation. Extensively used Dynamic SQL, REF Cursors, Bulk binding/Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.
• Automated Shell scripts to run batch jobs which pulls and loads data from higher environment into data staging area for business reporting.
• Implemented XPath and XQuery expressions like Extract, ExtractValue, ExistsNode, FLOWR, XMLQUEY(), XMLTABLE().
• Involved in bug fixing of one of the services of CMM application implementing spring, EJB, JDBC, Oracle.
• Developed Data Access Object and added Services for Data Movement across the added interface.
• Used Ant build to run the application and monitored the maintenance releases.
• Added logging and debugging capabilities using Log4j.
• Continuous support in higher environment with bug fixes and data validation.
• Extensively worked with QA team for their end to end testing. Supported System and User Acceptance Testing.
• Wrote automated LISA test script to validate data against different Calculations. Created test scripts for doing black box testing. Script performs calculation pulling data from source systems and validates data against the sink system.
• Tested job orchestration using TIBCO, validated job triggering logic for each job and generated report using LISA.
• Wrote Complex SQL queries implementing SQL Analytics to generate customized reports.
• Created Test cases for Long day Short day scenarios. Ensured calculation being done correctly.
• Involved in Exception testing and Performance Testing.
• Performed test deployment activity for every major release, documented complete deployment procedure.
• Responsible for Maintaining CSI/CMM Calculation document (CMMWORKFLOW) and CSI/Non-CMM loader document (CMM-NON-CSI-INTERFACES).

Environment: TIBCO Business Works 5.2/5.1, TIBCO EMS 4.x, TIBCO Administrator 5.2, TIBCO Hawk 4.2, XML, XSD, LISA, XML, Web Services, Eclipse, JDK 1.5, EJB, Spring, JBoss, Unix Shell Scripting, CVS, Oracle 10g, TOAD, PL/SQL Developer, SQL*Plus, CVS, Core JAVA, JDBC

Confidential, Jun 2007- Mar 2008
Overland Park, Kansas
Oracle Developer II
Responsibilities:

• Modified existing materialized views doing complete refresh to do incremental refresh. Used Oracle hash value to find the changes. Scheduled job using Oracle DBMS_SCHEDULER to run daily at Six o'clock. Analyzed materialized views refresh and rewrite capabilities.
• Developed scripts to create multi-schema including master and child schema specific to each business market. Granted rights based on the business requirement. Tested to ensure existing applications work in multi-schema environment.
• Implemented Oracle Advanced queuing to setup queues to transfer messages to business users and Tech Support team. Incorporated messaging system in existing applications, logged and sent messages of each jobs status.
• Maintained row level security in specific tables as per business need using Oracle DBMS_RLS package. Implemented and tested script in multiple markets to ensure the concerned user gets necessary DML operation access.
• Involved in ETL processes to load data from Flat files into the target Oracle database using Pipelined Table Function. Wrote verification script to ensure proper data loading to maintain the data integrity between source and the target database.
• Gathered statistics on regular basis for the accurate results. Rebuilt tables, indexes to move to different tablespaces.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views. Used EXPLAIN PLAN, OPTIMIZER HINTS, SQLTRACE and TKPROF utilities.
• Created Database objects like tables, synonyms, sequences, views and triggers during development. Enforced database integrity using primary keys and foreign keys.
• Proactively worked with DBA to come up with solutions to issues in different environments, performed query tuning and Database tuning, participated in meetings regarding system or application failover.
• Developed backfill script to populate missing intervals. Created back out scripts to rollback transaction as per business need.
• Wrote scripts to generate data during FAT testing. Used Oracle Export/Import, SQLLOADER utility to export and load data from higher environment into development environment during bug fixes and testing.
• Developed code as per business needs to perform archive and cleanup of data across multi-schema.
• Actively involved in production support. Wrote ad hoc queries to perform tasks like schema comparison, data transformation and tuning existing application. Modified queries of existing application for issues seen after migration to 11g environment.
• Interacted with business user, DBA and other team members to meet deadlines. Conveyed foreseen risks to concerned team members.
• Worked on table partitioning (Range, Hash and List) and deployed Bitmap indexes on Partitioned and non-partitioned tables to increase performance.
• Used SQL*Loader and UTL_FILE Packages for data interfaces. Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner Transformation.
• Automated Shell scripts to pull and load data from operational resources into Data Staging Area and Data Warehouse for business intelligence reporting.
• Developed, tested, and implemented shell scripts using 'vi' editor for back ups, refresh of DBs, data loads from/to external systems, and automated thru Crontab.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in preparing functional specifications, release notes and other documentation.
• Participated in Code and Design Reviews for the backend data population and reporting system.
• Participated in status meeting and walkthroughs. Participated in System test case preparation and execution.
• Worked with QA team to develop test data for the validation of process and performed unit testing.

Environment: Oracle 10g, MS Access, TOAD, SQL Developer,SQL*Plus, Perforce, Putty, Sun Solaris 10, Informatica Power Center 7.0, Unix Shell scripting, Golden Gate

Confidential, Sept 04-Nov 05
Kathmandu, Nepal
Software Engineer
Responsibilities:

• Functioned as an analyst for planning, analysis, design and development phases of the application.
• Responsible for Normalization, Data Modeling, Designed and Built Databases.
• Designed various approaches for very complex interface.
• Created detailed end - end mapping document and TIBCO Technical design document.
• Developed various XPath transformation to transform Input data to output.
• Involved in writing of various shell scripts for automation some of the processes.
• Designed and developed various Business Works processes to achieve the integration.
• Used various Business Works activities in developing re-usable business processes.
• Developed high volume interface and delivered on given deadlines.
• Involved in the deployment of the project into various environment by using TIBCO Administrator and using build scripts and have given support for the interfaces in production.
• Building archive file and deployed by using automation deployment tool for various Environments (DEV, IT, LTE).
• Prepared Artifacts for various environments (DEV, IT, LTE).
• Reviewing various test scenarios and test cases for their validity.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements
• Involved in development of custom stored procedures, functions, packages, triggers, SQL and PL/SQL scripts.
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes.
• Developed various stored procedures for staging and cleaning the data.
• Created Java Stored procedures to meet various business needs.
• Object-Oriented Analysis and Design (OOAD)
• Used Ant build tool to run the application and monitored the maintenance releases.
• Developed Data Access Objects (DAOs), which are java classes those encapsulate all database specific, code using JDBC API.
• Extensively involved in unit testing, worked with QA team for Systems testing.
• Developed the end-user documentation and performed periodic updates of the design documents.

Environment:AIX UNIX, Windows 2000, Oracle, Business Works 5.2/5.1, TIB/EMS 4.x, TIBCO Administrator 5.2, TIBCO Hawk 4.2, XML, XSD, Clear Case, TOAD, Oracle 9i, Visio and Clear Case.,JDK 1.4, J2EE 1.4, Enterprise Java Beans (EJB), Eclipse, Core JAVA, JDBC, Putty.