SUMMARY:

• Over 8+ years’ experience as an EAI/MDM consultant and ORACLE developer.
• Experience in ESB design methodology and Best Practices.
• Experience in MDM design methodology and Best Practices.
• Experience leading a Team.
• Developed solution using AGILE methodology, and comfortable working using AGILE process.
• Over 1 year experience as a DBA/ Data Analyst.
• Experience in developing database Packages, Stored Procedures, and Triggers.
• Experience and exposure to Oracle features like Materialized views, Indexes, sqlldr.
• Optimized PL/SQL code using advanced database features to improve performance.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC)
• Capable of managing challenging projects with remarkable deadline sensitivity without compromising code quality.
• Adept in end - to-end Software development from requirement analysis, designing, developing, testing, documentation, implementation and deployment using TIBCO Products

TECHNICAL SKILLS:

Operating Systems: Windows, Linux.Databases: Oracle, SQL Server

TIBCO Product: TIBCO Administrator, TIBCO BW 5.x, TIBCO MDM, TIBCO EMS, TIBCO BUSINESS STUDIO

Tools: Oracle enterprise manager, TOAD,SQL Developer

Languages: JAVA, PL/SQL, C, UNIX Shell Programming, C++

Web Programs: HTML, DHTML, JavaScript, CSS, XML

PROFESSIONAL EXPERIENCE:

Assistant Manager (Analyst TIBCO MDM DQ Management)

Confidential

Responsibilities:

• Understanding and analyzing business requirements.
• Investigate and validate the DQs raised by customers and take the action accordingly.
• All small works incl. both Root Cause Analysis and Dev to Deployment on DQs.
• Responsible for monitoring and data trending in all the presentation layer population jobs / Data.
• Providing the support and resolving production issuess
• Worked on Logging and Event Handlers to capture the errors during the process.
• Creating stored procedures, functions, CTE’s, Temporary tables and SQL Scripts.
• Analysis problem and Resolved in AB Initio.
• Analysis problem and Resolved in TIBCO MDM.
• Development of data model using Tibco Business Studio.
• Debugging and Designing Business workflows.
• Designing and Importing MDM metadata into MDM Studio.
• Attended meetings with Business Analyst and Senior Architects to identify datasource and workflow requirements and re-engineered those using TIBCO MDM features.

Deputy Manager

Confidential

Responsibilities:

• MDM Production Support
• Managing MDM team of 4 members.
• Managing MDM data from backend.
• DataUpload Using Filewatcher, Import and DBLoader Utility.
• Extracting MDM data dump and helped other system like SAP for data reconciliation.
• Tuned MDM related parameter in BW SOAP call for faster data load.
• Experience in tuning MDM configuration parameter.
• Working with architect to understand MDM and Integration requirements.
• Requirement Analysis, preparation of Functional and Technical specification documents.
• Development of data model using Tibco Business Studio.
• Designing SQL queries to work with data stored in MDM internal tables.
• Rectify MDM data model.
• Designed MDM level constraint to filter data based on various criteria.
• Debugging and Designing Business workflows
• Designing and Importing MDM metadata into MDM Studio
• Worked on MDM BULK DATA load option to upload data in a faster way in MDM.
• Experience in TIBCO BW integration with TIBCO MDM
• Create PL/SQL procedure for faster retrieval of data instead of using MDM SOAP call wherever required.

Consultant

Confidential

Responsibilities:

• Involved in developing the High Level Design into Low level Design of various features.
• Worked on Agile and SCRUM methodologies for delivering the artifacts of the project.
• Attended meetings with Business Analyst and Senior Architects to identify datasource and workflow requirements and re-engineered those using TIBCO MDM features.
• Analyzed business analysis and system design efforts & documentation with business and technical teams.
• Working closely with the Product Owners in writing the Stories and Tasks using Agile and SCRUM methodology concepts.
• Working on TIBCO MDM( Workflow, Rulebase, Catalog Validation, FileWatcher, Export/Import, Classification Schema)
• Working on TIBCO BW & MDM
• Working on Confidential Retailer Project.
• Create Confidential Automation using Selenium, SOAP UI and BW.
• Generating WEBSERVICE request/response as per client WSDL and SCHEMA.
• Write complex SQL Queries and tune SQL queries that were taking long times. Created database objects like tables, views and triggers. Analyze the database for indexes, constraints etc. Worked on SQL tuning. Created and Developed Stored Procedures, function to support data activity.
• Providing the support and resolving production issues

PL/SQL Developer

Confidential

Responsibilities:

• Generating XML payload document using xml API provided by ORACLE.
• Generating WEBSERVICE request/response as per client WSDL and SCHEMA.
• Write complex SQL Queries and tune SQL queries that were taking long times. Created database objects like tables, views and triggers. Created E-R diagrams and analyze the database for indexes, constraints etc.
• Maintaining and replicating development environment (Deployment of EAR file, database export import, Physical backup of database)
• Worked on SQL tuning
• Created and Developed Stored Procedures, function, packages to support data activity.
• Providing the support and resolving production issues.

Software Engineer-Trainee

Confidential

Responsibilities:

• Write complex SQL Queries and tune SQL queries that were taking long times. Created database objects like tables, views and triggers. Created E-R diagrams and analyze the database for indexes, constraints etc.
• Maintaining and replicating development environment (database export import, Physical backup of database)
• Worked on SQL tuning
• Created and Developed Stored Procedures, function, packages to support data activity.
• Providing the support and resolving production issues.