PROFESSIONAL SUMMARY:

• Over 10 years of focused experience in IT being as a developer, support analyst, business analyst, technical lead, part of central technical team (CoE), MDM Lead, MDM architect and MDM specialist.
• Involved in multiple full life cycle implementation of Master Data Management using TIBCO MDM, Data Quality, Trillium DQ, Loqate, TIBCO Patterns (Netrics), TIBCO AS, TIBCO BW, TIBCO EMS, Oracle and SQL server database.
• Expertise in TIBCO MDM development process starting from requirement gather, designing, implementing, coding, production deployment and post - Go live maintenance of the systems.
• Extensive knowledge of Relational Data Modeling, Workflow customization, writing complex rule bases for data validation and business process using TIBCO MDM Studio.
• Extensive experience with SOA Web Services technologies including UDDI, WSDL, XML Schemas, SOAP, XSLT and BPEL (asynchronous Web Services).
• Extensive knowledge of infrastructure setup and management including sizing of environment, creating product version profiles defining set of version patches, hotfixes and plug-in compatible and are supported for TIBCO MDM.
• Excellent knowledge of installation and setting up of TIBCO MDM product and related technologies on various application and web servers including JBOSS, WEBLOGIC. WebSphere and apache tomcat.
• Experience in configuring data flow (Land, stage, load, tokenize, match & merge and consolidate) using TIBCO MDM and TIBCO Patterns Engine.
• Extensive knowledge of Data Quality process for de-duplication using Trillium Data Quality, TIBCO Patterns and creating match and merge rules, setting up trust/relevance score configuration.
• Experience in proactive enterprise monitoring of hardware and software identifying the gaps and putting monitoring in place for better visibility and correlation.
• Extensive database experience working as developer with Relational databases writing SQL Queries as well as using it as backend database for MDM/ELT and data warehouse.
• Experience in development of Stored Procedures, Functions, Packages, triggers, query Optimization, Debugging and Tuning for performance improvement.
• Experience in multiple project tools like Microsoft Visio, Microsoft project plan and ERD for designing architectural diagram, data modelling, landscape diagram and dataflow diagram.
• Experience of multiple clouds for installation and maintenance of MDM and SOA related products including AWS, eCloud (Verizon) and Azure (Microsoft).
• Experience in Creating and configuring TIBCO EMS (Queues & Topics) and WebSphere MQ Queue Manager and Queues for data communication within and with external systems.
• Experience in Developing Applications using Java, Servlet, JSP, JavaBeans, JDBC, XML, XSLT, DTD, HTML, XHTML, XPATH, JavaScript, SQL server 2000 and MS Access.
• Experience with standard Data Pool such as UCCnet, WWRE, EAN.UCC, 1sync and GS1.
• Proficient in handling multiple engagements and juggling multiple projects, mentoring other resources, and navigating through complex work arrangements with multiple vendors.
• Expertise in conducting workshops, documenting business requirements, technical configurations, writing test case, user stories and business users training manuals.
• Strong ability to quickly master new concepts and applications and work under pressure under tight deadlines. Strong analytical and interpersonal communication skill.

SKILL:

Operating System: Windows 98/2000/NT/ XP/2007/window10, Unix 2.4, AIX5.3. Red Hat Linux4.8/5.1

Application Solutions: TIBCO CIM5.7.x,5.9.x,6.0.x,6.1.x,6.2.x,7..x TIBCO MDM (Formerly CIM) 8.1.x,8.2.x,8.3.x,9.x, TIBCO Patterns 4.5.x,5.0.x,5.1.x,5.2.x, 5.3.x TrilliumDQ, TIBCO BW,5.7x,5.11.x,5.12, TIBCO EMS5.x,6.x,7.x,8.x TIBCO Hawk5.x, TIBCO Admin5.8.x, TIBCO AS2.x, TIBCO MDM Plug-in 1.x, 2.x

Database Server: Oracle9i, Oracle10g, Oracle 11g, SQL Server 7.0/2000, 2012

App/Web Server: JBOSS5.x,7.x, WebLogic10.x, WebSphere and Apache tomcat.

Language: SQL, PL/SQL, Java, Shell Scripting, XML, HTML, ANT Script.

Messaging: TIBCO EMS, WebSphere MQ.

XML: XML, XSL, XSLT, DTD, Schema, XSD.

Tools: MyEclipse, Eclipse, EditPlus, XMLSpy, TOAD, DBVisualizer, Sql navigator, SQL Plus, SQL Loader, FileZilla, WinScp, Visio., Notepad ++, TIBCO business Studio, ERWin, TIBCO MDM Studio

Data Pool: UCCnet, WWRE, Transora, EAN.UCC, 1sync and GS1.

Clouds: AWS, eCloud, Azure

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. MDM Lead /Architect

Responsibilities:

• Provide architectural recommendations which includes helping with defining high level over of the system and TIBCO MDM product usage and configuration recommendations.
• Assess the stability, scalability, and performance of the MDM systems during IROP situation and provide guidance and directions for the resolution of ongoing technical challenges encountered around the use of TIBCO MDM and related integration technologies.
• Provide guidance and best practices for establishment of a matured MDM practice by leveraging TIBCO technologies and resources in the best possible ways for future strategic initiative and help in setting up the data governance framework.
• Migrate TIBCO MDM and TIBCO integration infrastructure (SOA) stack and related technologies from eCloud (Verizon) to Azure (Microsoft) cloud.
• Setup proactive Hawk monitoring for issue management and setup data purging strategy for all historical data using out of box solution as well as applying more tradition approach like Operational Data Store ( Confidential ).
• Reviewed the complete MDM implementation including SOA integration which includes heavy customization of the tool and identified the GAP that causing data duplication and other data quality issues.
• Reviewed data cleansing rules in Trillium DQ and created new rules to supplement the existing implementation.
• Created Current-State Assessment document giving background, observations, tactical recommendations as well as strategic recommendations. These recommendations included technical, organizational, architectural, design, and process recommendations.
• Created installation and upgradation procedure to migrate TIBCO MDM8.3.2 from eCloud to Azure and then upgradation to TIBCO MDM9.0.1 including Trillium Data Quality, TIBCO Active Space, and TIBCO Patterns. Installed and configured upper environment and monitored associates on creating lower environment including Dev, QA and INT.
• Created Enterprise Monitoring Overview and Recommendations describing the different areas of monitoring in order to let the client determine whether the objectives for Enterprise Monitoring can be cover.
• Created Hawk rules to monitor complete MDM infrastructure covering hardware as well as software which includes TIBCO MDM servers, TIBCO AS servers, TIBCO Patterns servers, TIBCO BW servers, TIBCO EMS servers and Trillium DQ servers.
• Created logical and physical data model for client’s vacation package site (getaways.com) leveraging relational database principles.
• Wrote multiple Stored Procedure to extract data from MDM for the consumption of down system in sub millisecond SLA response time.
• Played a key role on interviewing, onboarding, mentoring MDM DevOps team members for onsite as well as offshore.

Technologies: TIBCO MDM8.3.2/9.01, TIBCO EMS 7.x,8.x, TIBCO AS2.0/2.1,TIBCO Patters4.x,5.x, TIBCO Hawk, TIBCO BW5.11, SQL Server 2012, UNIX, JBOSS7.1,Sql Server Management Studio

Confidential, NJ

Sr. MDM Lead /Architect

Responsibilities:

• Lead MDM (M-DRIVE) initiative to collaborate multiple federated source system to a single version of truth.
• Design & Architect the MDM solution to cater the need of downstream consuming systems.
• Provide assistance in upgrading MDM products to the latest version and migrating all custom components.
• Worked as Senior ETL/MDM lead Consultant responsible for analysis, design, development, testing and delivering to live system and then supporting them post go-live.
• Played a key role in setting up ELT process to seed data from multiple federated source system into MDM running through the data quality process of de-duplication using Loqate for standardization and TIBCO Patterns for de-duplication.
• Conducted project requirement workshop with stakeholders to gather and understand business requirements and capture AS-IS process and then translate into formal technical design document.
• Involved in designing of MDM architecture diagram, designing the logical and physical data model and presenting it to the stakeholders.
• Provided resolution in multiple dimensions with regards to the performance issues concerning potential slowness of the MDM application with respect ingestion (mastering) as well as extracting of the data.
• Involved in day-to-day working issues with business on regular interval to ensure smooth delivery of the project.
• Involved in upgrading the MDM landscape from TIBCO MDM8.1.x to MDM8.3.x.
• Involved in migration of custom components including workflows, work item page and business rules.
• Automated the data load process by configuring the file watcher to import data in to master repositories.
• Wrote multiple SQL query for data analysis and views for ESB consumption.
• Wrote/fine-tuned validation rules for better performance of the UI response and ESB WS responses.
• Wrote custom java function to meet business needs for data validation/manipulation in Rule base Custom Function file.
• Involved in setting up trust and validation rules for duplication and de-duplication (Matching & Merging) process maintain the data integrity using SAP BODS (Business Object Data Service).
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Involved in data cleansing and standardization process using Loqate cloud services for address validation and data quality.
• Configured TIBCO Patterns for freeform Text search as well as attribute level search optimization and for de-duplication process.
• Involved in preparing functional and Technical Specification Documents.

Technologies: TIBCO MDM8.1.x/8.3.x, TIBCO MDM Studio, Loqate, SQL developer, Oracle 1g /11g, TIBCO EMS7.x, WebLogic, JBOSS7.1 & TIBCO Patterns, SAP BODS.

Confidential, PA

Technical MDM Lead

Responsibilities:

• Conduct a Strategy & Planning workshop to provide an architectural approach for the implementation of the Customer Master and loyalty program solution using TIBCO MDM.
• Participate in sessions with business users to go over the users’ stories and laying out the business processes for mastering of data from multiple sources.
• Participate in Master Data Management, reference data management and integration architecture meetings to discuss various data points and dataflow Patterns and provide recommendations that could benefit the architectural design.
• Contribute to the solution architecture document with respect to MDM product version needs and the dependent SOA technologies.
• Create the Logical and Physical data model for master data as well as reference data.
• Developed MDM strategy and roadmap to integrate with the overall enterprise architecture.
• Conducted workshops with SMEs to capture current process and system of records, business policies and procedures.
• Captured existing business processes (AS-IS) and performed GAP analysis for Customer and Location domains.
• Involved actively in all aspect of the solution discussion including Planning, Scoping, Business Process Flow, High level use cases, integration aspects, data quality aspects which includes duplication and de-duplication (Matching & Merging).
• Conducted meetings with business users to identify the scope of initial and subsequent releases.
• Created proof of concept using with TIBCO MDM to achieve customer vision of data-mastering and customer 360 view for the enterprise.
• Helped Data Governance team design the governance framework and implement processes, standards, KPIs & metrics to help monitor and analyze data quality.
• Prepared TIBCO MDM installation documents including all dependent software like MDM Plug-in, database and EMS.
• Created logical and physical data models for customer and location domain.
• Created Reference data model for all references and look up data from external sources.
• Involved in data mapping between source (Legacy) and target system (TIBCO MDM).

Technologies: TIBCO MDM, TIBCO BW, TIBCO CLE, TIBCO Patterns, TIBCO AS, TIBCO EMS, XML, JBOSS, Oracle 10g/11g, SQL Developer Studio, TIBCO MDM Studio, MS Visio, MS Project Plan.

Confidential

Senior TIBCO MDM Consultant (Support)

Responsibilities:

• Help build a MDM support model for the client for ongoing maintenance of product MDM implementation.
• Lead a team of support consultants onsite and offshore to help mature the client’s MDM implementation.
• Meeting the stakeholders to layout a framework for TIBCO MDM support model.
• Involved in production roll out and handling post product issues including issue identification, trouble shooting, and fixing them in production landscape.
• Helped in identifying and prioritizing issues to ensure the current business process has no and limited impact.
• Analyzed the infrastructure with respective performance improvement to ensure the system is scalable enough to handle progressive increment of data volume.
• Supported the data quality process from cleansing rule to matching and merging.
• Involved in generating system health report regularly for leadership.
• Wrote multiple reports using database views and stored procedure in database.
• Monitored processes/jobs, troubleshoot issues using TIBCO CLE, TIBCO Administrator, and TIBCO MDM Admin.

Technologies: TIBCO MDM8.x, TIBCO BW5.x, TIBCO EMS6.x, TIBCO CLE, XML, TIBCO AS, TIBCO Patterns, JBOSS5.x, Oracle 10g, SQL Developer Studio. TIBCO MDM Studio.

Confidential NJ

Senior TIBCO MDM Developer/ MDM Technical Lead/Architect

Responsibilities:

• Work as TIBCO MDM Lead /Architect providing best practices, design Patterns and standards on the use of TIBCO MDM product for multiple domains/divisions.
• Provide guidance on leveraging TIBCO technologies in expanding the capabilities and handling the future volume requirements for client applications.
• Provide guidance on establishing processes and standards to build consistent and quality MDM infrastructure.
• Provide educational and technical support in the assessment/maintenance of the TIBCO MDM, TIBCO AS, TIBCO EMS and TIBCO Patterns.
• Assess the steps to migrate from TIBCO MDM 6.1.x to the latest version of TIBCO MDM8.3.x across all environments.
• Setup onsite and offshore team, train and mentor them on TIBCO MDM and integration products.
• Play a key role as liaison between cross functional team within the organization and with external vendors.
• Responsible for leading the project team in Deliver new and highly complex solutions to clients in response to varying business requirements.
• Conducted workshops with stakeholders to gather Business requirements on numerous project and provided guidelines to document the requirement specifications into a formal functional specifications.
• Conducted workshops with SME’s to capture current process (AS-IS) and future state process (TO-BE) by understanding the System of Record (SOR), the way it was designed and then provide recommendation per best business policies and practices.
• Played a key role by juggling multiple projects, mentoring other resources, and navigating through complex work arrangements with multiple vendors, also Architected multiple MDM solutions using TIBCO CIM6.1.3, CIM8.2.1 & MDM8.3.1
• Created Project plan using MS Project Plan, MS word, MS Excel and MS Visio to establish a standard on how to document all MDM projects and upgrades.
• Successfully Designed and implemented business solution using TIBCO MDM8.2.1, TIBCO Patterns and other EAI tools and technologies.
• Created Logical and Physical architecture documents describing current needs and any future enhancements for multiple divisions like Human Health, Animal Health, Supply Chain and many more.
• Created a document with initial product version profile defining the target set of product versions, patches and hotfixes that are compatible and supported by TIBCO MDM before initialing the upgrade process.
• Successfully installed and up-gradated the complete MDM infrastructure from CIM6.1.3 to CIM8.2.1 to MDM8.3.1 Single handedly
• Successfully installed TIBCO MDM including all dependent products on AWS Cloud.
• Defined the data quality process, wrote DQ rules for standardization using Trillium Data Quality software.
• Customized core features including custom template, business process rules, workflows, Catalog Validation & rule bases.
• Worked extensively in workflows writing complex workflows for data processing and setting up approval process ensuring data cleanliness.
• Setup a de-duplication process using Trillium Data Quality for data cleansing & standardization and TIBCO Patterns for Matching and Merging through approval process.
• Worked in all aspects of TIBCO MDM including Data Model, workflows, rule bases, input map, output map, custom Java code for customization, Custom GUI for better data management, file watcher for automating data loads, business process rules for setting up business processes.
• Worked extensively on backend database by writing database objects like custom sql, stored procedure, views, and materialized views.
• Implemented data governance framework using TIBCO’s natively provided security framework to ensure data is accessible to the right person at the right time thereby restricted data to unauthorized users.

Technologies: TIBCO CIM6.x/MDM7.x/8.x, TIBCO BW, TIBCO Patterns, Java, XML, TIBCO EMS, TIBCO GI, JBOSS, Oracle 10g/11g, SQL Developer Studio, MS Visio, MS Project Plan.

Confidential

Senior TIBCO CIM Consultant

Responsibilities:

• Work as Lead MDM consultant to design and setup Menu Item Management system using TIBCO MDM tool.
• Install/maintain and migrate the TIBCO CIM infrastructure onto the newest versions of the Products in order to have a stable environment and leverage the latest features available.
• Lead a team of MDM and integration consultant at onsite and offshore.
• Write user stories and train business users for data stewardship role in MDM tool.
• Conducted workshops to gather business requirements with business users and multiple stakeholders and documenting them for their approval.
• Involved in the initial Project planning and MDM roadmap discussion and contributed in laying out the phase out approach as per SDLC.
• Installed/upgraded and maintained the MDM infrastructure single handedly including applying hotfixes and engineering fix to keep the system on to the latest version and stable.
• Customized some of the OOB core features including customer email template, business process rules, workflows, writing custom java rules and then invoking from rule bases.
• Trained and groomed a team of MDM consultant’s onsite as well as lead an integration team offshore.
• Single handedly designed and delivered multiple MDM projects including customizing complex workflows, customizing business process rules, writing java code to meet custom data validation rules, creating input maps and automating the data load processing using file watcher.
• Created complex views with multiple joins using native MDM and business tables to expose the reporting needs. Created Stored Procedure Objects for data validation and data extracted as needed by the downstream systems.
• Setup a process to stream line the code deployment from lower environment (DEV) to the live system (PROD)
• Played a key role is Global roll out of restaurants to Asian countries in setting up servers and helping the business users with needed training to setup menus and their pricing.
• Conducted multiple boot camps with business users to train them on the tool with regards to setting up menu, tier, pricing, region, region per restaurants…..etc.
• Involved with the version control and configuration management.

Technologies: TIBCO CIM6.1.x/6.1.x, TIBCO BW, TIBCO EMS, Java, XML, JBOSS5.x, Oracle 9i, TOAD, Aqua DB Tool