PROFESSIONAL SUMMARY:

• Around 10 years of experience in IT industry working on Data Warehouse applications.
• Experience working on all phases of software development. Requirements gathering, Analysis, Design, Development, User Training and Production Support.
• Good exposure to data modeling, data warehousing & business intelligence and master data management (MDM) concepts.
• Hands on experience in design and development of Informatica 9.1, 8.x, Service Oriented (SOA) applications using Oracle 10g SOA Suite (ESB,BPEL,WSM,BAM), Sun JCAPS Middleware Suite (eGate, eInsight, eXchange) and reconciliation/validation tools like n - Tier, Informatica Data Validation tool(DVO)
• Knowledge of IBM WebSphere Process Server, SAP XI and TIBCO
• Experience in design and development of message oriented middleware tools like JMS, AQ and MQ.
• Experience in implementing complex business rules using Informatica transformations. Used re-usable transformations, Joiner, Union, Sorter, Aggregator, Rank, Normalizer, Filter, Router and Update Strategy), and developed complex Mappings & Mapplets
• Experience in integration of various data definitions like Flat Files, SQL Server, Oracle, DB2 and ODBC connectors.
• Experience working to identify and resolve Production issues.
• Experience working on relational databases such as Oracle 8i/9i, DB2, SQL Server
• Strong skills in SQL, PL/SQL packages, functions, stored procedures & triggers
• Hands on experience in UNIX shell scripting and scheduling tools(CA scheduler - Autosys version and Cisco Tidal)
• Team Player with good Interpersonal skills, Ability to work effectively with multiple people.

TECHNICAL SKILLS:

Data warehouse: Informatica 9.1, 8.x, Oracle SOA Suite 10.1.3 (ESB, BPEL,BAM), Oracle EDA, Sun JCAPS 5.1 & 6.0, Sun Seebeyond, Composite Information Server, JMS, Knowledge of: IBM WebSphere Message Broker 6.0, WebSphere Process Server, MQ

Databases: Oracle, DB2, SQL Server, Teradata, MS Access

Database Tools: Embarcadero DBArtisan, TOAD

Schedulers: Autosys and Cisco Tidal

Programming Languages: Core Java, ASP, Java Script, VB Script, HTML

Development Environments: Eclipse, JDeveloper

Data Specifications: EDIFACT • X12 • AS2 • HL7

PROFESSIONAL EXPERIENCE:

Confidential, JERSEY CITY, NJ

Senior Lead Integration Consultant

Responsibilities:

• Designed and developed n-Tier Reconciliation flows for Securities (Products) and Collateral information.
• Analyze Informatica implementation required to design and create reconciliation process.
• Developed UNIX scripts to run recon flows.
• Created database views so reporting layer (OBI) could extract processed data.
• Scheduling and monitoring of n-Tier jobs through TIDAL Scheduler.

Environment: Files processing, Database: Oracle, DB2 UDB, Scheduler: TIDAL, Development Tools: Informatica, n-Tier, Unix (AIX), Oracle Business Intelligence (OBI)

Confidential

Responsibilities:

• Designed and developed ETL Informatica workflows/sessions/mappings for Credit Control and AML products, these run everyday processing data from OVS to US based DWH systems.
• Validation and Reconciliation of processed data using Informatica Data Validation (DVO) and n-Tier tools.
• Scheduling and monitoring of ETL and n-Tier jobs through TIDAL Scheduler.
• Worked with data analysis group, DBAs, data base modelers and reporting resources to understand the needs for proper implementation.
• Designed and deployed reporting views from EDW & EDM exposed to BI reporting to meet differing client needs.

Environment: Files processing: Text and Excel Documents, Database: DDB2 UDB, Oracle 10g, Teradata Development Tools: Informatica 9.1, n-Tier, Unix (AIX), Oracle Business Intelligence (OBI) Scheduler: TIDAL

Confidential, NJ, NY

Senior Lead Integration Consultant

Responsibilities:

• Performed analysis, requirements so it could documented to technical specifications
• Designed and developed ETL Informatica workflows to extract data from source and load to APB data mart
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading
• Involved in DB2 PL/SQL query optimization to reduce the overall run time of stored procedures
• Created UNIX shell scripts for file moves, archive and for FTP processing of file to downstream systems.
• Involved in unit testing of various objects (Informatica workflows/DB2 stored procedures/UNIX scripts)
• Supported various testing cycles during the SIT & UAT phases.
• Supported the daily/monthly ETL batches in the Production environment

Environment: Development tools: Informatica 8.6, Composite Information Server (CIS), Java, JBOSS, Weblogic, DB2, DBArtisan, UNIX, Database: DB2, Teradata Scheduler: CA Autosys

Confidential

Senior Integration Consultant, Beaverton, Oregon

Responsibilities:

• Capture the requirements of integration and suggest design approaches for Integration module in this Agile methodology project
• Analyze the requirements and subsequently development integration modules.
• Design and Development of interfaces linking SAP MDM to different Databases (i.e. DB2 and Oracle) using JCAPS
• Preparation of Low Level and High Level Technical Design Documentations
• Developed BPEL processes that contain exception handling to capture the Remote and Binding faults.
• Enhanced and provided support of interfaces connecting SAP MDM API service using Java and EJB
• Performed Data Validation and Data Flow guidance as per the Business requirements
• Implemented JUnit test cases for black box testing of these interfaces to adhere to the business needs

Environment: Development tools: Oracle SOA Suite, JCAPS, J2EE, SAP MDM, JMS, JDeveloper, Web Services, SQL, XML, XSD, TOAD, UNIX, Oracle Application Server and WebLogic Server

Confidential

Integration Consultant

Environment: Sun Seebeyond, TIBCO, SIEBEL CRM, SAP ERP, UNIX, Oracle, IDOC and X12 message formats.

Confidential

Integration Consultant

Environment: Sun Seebeyond, Oracle Apps (ERP), UNIX, Oracle, X12 message formats.

Confidential

Middleware Developer

Responsibilities:

• Design and develop PointToPoint(A2A) and Extenal(B2B) interfaces
• Used eGate eWays to connect to external systems like FTP, IBM MQ, EDIFACT AS2 compliant trading partner, Batch local file system, Oracle
• Analyzed previous code(monk) version to create new JavaCodeUnit(JCD) based interfaces for ICAN 5.0.5.
• Implemented B2B protocol and configured B2B host to enable seamless communication between Confidential system and B2B trading partners
• Configure trading partner profiles using ePartner exchange console and Configuration of private and public certificates needed for secured transaction
• Developed interfaces for transforming flat file messages in to MQ based delimited text message, flat file messages to EDIFACT message and EDIFACT message to flat file message
• Design and develop health check component to check the connectivity of all the external system status and their liveliness
• Developed certificate management tool to manage the certificates of thousands of suppliers and notify to a particular supplier automatically when the certificate gets expired
• Design and develop Auditing and error monitoring component to track the status of all messages flowing in the system

Environment: Development Tools: Sun JCAPS, ICAN, Seebeyond, Java, Oracle, TOAD, EDI, XSLT, XML

Confidential

Junior Developer

Responsibilities:

• Designed XML schema definitions and stylesheets for the identified interfaces
• Involved in implementation of End-to-End Logging framework.
• Developed ‘Manage Customer’ capability categorized under ‘Transfers & Moves’.

Environment: Visual Basic, Java, Oracle, TOAD, XML, XSLT