PROFESSIONAL SUMMARY:

• Innovative business professional with 7+ years of experience in implementing a globalized MDM solution and extensive experience in Data warehouse and Data Integration Technology and in analyzing business requirements and transforming them into technical solutions.
• Extensive experience in Installing, Configuring, Tuning and troubleshooting of WebLogic Server in various environments and technical understanding of the applications, identify opportunities for improvements to processes and applications, and work on the full development life cycle.
• Understanding of the logical flow of information between applications, databases, and third party (client/vendor) systems fordataand reporting and communicating with the business owners, stakeholders and other executives involved in enhancing business processes.
• Experience in building business plans and project initiatives, knowledge about software testing, process testing and quality control, good Knowledge on IBM Master Data Management (MDM) Advance Edition.
• Experienced in setup tasks like IBM MDM installation, troubleshooting errors while deployment and installation followed by upgrading the tool and working knowledge on IBM initiate based on Suspect Duplicate Processing implementation.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing & Data Verification and in designing, Installing and Configuring core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling.
• Experience in defining and configuring Landing tables, Staging tables, Base Objects, Hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
• Experience in working on Service Access Manager (SAM) module for defining roles and providing relevant access to those roles. Also, creating users inMDMHub and providing access to those users.
• Expertise in OLTP/OLAP system study, E-R modeling and developing database schemas like Star Schema and Snowflake schema, working with tools like TOAD, SQL Developer and SQL plus for development and customization, Informatica Power Center tools such as Source Analyzer, Mapping and Designer.
• Experience with Incorporated Cleanse functions and User Exits for Validation, Back End Processing ofDataand Error Handling and experience in design of Multi-Dimensional modeling concepts like Star-Snowflakes schema utilizing Fact & Dimensional tables.
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers, Views, Joins, Sub-Queries and Packages to implement business rules and validations, deep knowledge in DWH ETL framework.
• Experience in Tableau and QlikView Dashboards in latest Design and Presentation, used the Tableau Online sync application to schedule automatic refresh tasks for extracts of data and to maintain on local network. Created cascading filters to filter the data.
• Proficient in creating visualization like Stack Bar, Bar Graphs, scattered plots, Bars, Bump, Funnel, Lines, Bubble and Pie charts, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, Box plots, Tree maps, Word clouds and Highlight tables, Pareto Charts, Bollinger Bands and Waterfall charts in Tableau.
• Skilled in eliciting, analyzing and documenting functional and technical requirements utilizing Agile or Waterfall SDLC methodologies and UML modeling techniques, creating Business Requirement Documents (BRD) and System Requirement Documents (SRD) utilizing use cases & wireframes.
• Leveraged knowledge and experience to deliver end-to-end methodologies within ServiceNow, which includes architecting technical implementation of IT Infrastructure Library (ITIL) processes, organizing and prioritizing development effort, interfacing with vendors and management, and coordinating effort of administrators.
• Expertise in doing the RCA (Root Cause Analysis) and resolving performance bottlenecks and enhance for optimization of the mappings, sessions and workflows, deploying the applications on multiple WebLogic Servers and maintaining Load balancing, High availability and Failover.
• Conducted analysis for finding risk mitigation strategies and developing business solutions, created sets and used them in the calculated fields to retrieve the specific data by combining multiple sets. Setup and configuration of Tableau Server Experience in using SQL for tableau and in writing queries for generating tabular reports, formatting report layout and expressions.

PROFESSIONAL EXPERIENCE:

Sr. Informatica MDM Consultant

Confidential - Hartford, CT

Responsibilities:

• Worked with business analysts to gather business requirements and implementing the same into a functional data warehouse design, prepared Business Requirement Documents (BRD's) referring to the Functional Requirements provided by System Users that described the scope of work for technical team to develop prototype and overall system.
• Published Tableau dashboard on Tableau Server and embedded them into portal and Build, published, customized interactive reports and dashboards, report scheduling using Tableau server. Created Business requirement documents for creating dashboards.
• Setup trusted authentication in Tableau server and pass requests from Web server and Strong experience in customizing the form design and form layout for various on the ITIL Process Configuration like Incident, Problem management inServiceNow.
• Designed business processes using BPMN and BPEL and customized the IBM MDM search framework with various search configurations as needed, installed and configured IBM Infosphere MDM Server with RSA and utilized SQL to extract datafrom Oracle and prepared datafor analysis, used different ActiveVOS functionalities like Reports, ActiveVOS Screen flow, ActiveVOS Forms and Human Tasks etc.
• Involved in greater insights which are made possible by combining data from multiple payers and increasing the number of claims to detect new patterns and establish correlations with strong statistical validity.
• Combined data from multiple payers and creating a consistent provider identifier across those claims streams can highlight problems that might not be obvious from just one health plan.
• Wrote multiple SQL queries to analyze the dataand presented the results using EXCEL, Access, CrystalReports and SQL Server SSRS as reporting tools and worked on various Healthcare payers, including the Centers for Medicaid and Medicare Services (CMS), are banking on informed, engaged consumers to play an increasingly key role in driving down healthcare costs.
• Worked on an Agile SDLC model to deploy our product and customer data, data modeling, baseline the data model to accommodate all business specific requirements and configured InformaticaMDMHub Server, Lookup Adapter, Cleanse Server, Cleanse Adaptor and Resource Kit.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment and involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management ofMDMdata.
• Worked on integrating Hierarchies created inMDMHub Console and IDD and implemented Post Landing, Pre-Staging, Save Handler User Exits using Eclipse Mars and integrated those user exits withMDMHub Console using User Object Registry module.
• Performed analysis, design, development and maintenance activities associated with the database and data in support of multiple applications (including following standards/procedures to achieve integration of systems through database design) and responsible for updating refresh packs, fix packs and interim fix packs to Web Sphere and manage Monitoring tools like SPLUNK and GIT installing INFA MDM Server.

Informatica MDM Consultant/Data Analyst

Confidential - Bellevue, WA

Responsibilities:

• Participated in the BRD Sessions, giving insightful perspective of the MDM Hub and its environment (Customer, Vendor and Item Domain), Co-ordinated efforts and resources, gave orders and instructions, configured and Installed Informatica MDM Hub, (Server, Cleanse, Resource Kit, Active VOS) in Sandbox for doing a POC in Windows/Linux environment.
• ConductedMDMtechnical interviews with candidates forMDMpositions for the project and involved in implementing and maintaining theServiceNowplatform to meet the Business processes and support ITIL.
• Improved performance and usability rating of the IBM MDM Application within multiple team, designed Import and Export from MDM PIM to SOA middleware, designed XML schema for exporting Product data. Evaluated IBM MDM PIM web service integration.
• Expertise in creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau, defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Experience with the design and development ofTableauvisualization solutions and created extracts, published data sources totableauserver, refreshed extract inTableauserver fromTableauDesktop.
• Published Workbooks and Dashboards to theTableauserver, created groups and users inTableauserver and usedTableauand Google Analytics to analyze web traffic and make business decisions on the traffic coming from various locations.
• Participated in planning and design review meetings with technical leads and project managers to determine schedules, review technical problems, and assign tasks and resources. (Customer, Vendor and Item Domain).
• Configured and Installed InformaticaMDMHub, MRM Server, MRM Cleanse, MRM Resource Kit in Sandbox for doing a POC in Windows environment.
• Led effort for gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management, evaluated and reported the progress of data quality improvement to the management and provided data quality and consulting services to Business and IT members in the organization.
• Collected and analyzeddataand identifying areas and methods for improvement and Verified thedatacollected from various sources and taking judgment on their usage, entered and secured information into thedatasystems with passwords and worked on Active VOS Error, Fault handing and Event Handling.
• Good development experience in Informatica Data Quality (IDQ) tool and was involved in implementing the Land Process of loading the customer data set into InformaticaMDM Hub that was coming from various source systems, also took development decisions by working with business users and enterprise architects to understand enterprise vision and direction and hands on executingMDMhub Batch Jobs (Stage, Load, Tokenize and Match Processes) and Batch Groups.
• Designed SQL Queries to pull out the data which should be Matched & Merged coming from all the source systems according to match & merge rules setup (to make sure consolidation process configured) and configured Match and Merge Rules in improving the data quality by match analysis, analysis of theMDMsystem performance and tuning the performance by changing the existing cleanse function, match rules etc.
• Designed, configured and tested Informatica Data Director (IDD) interfaces and led ETL team towards designing and development of extraction mappings for inbound source toMDMand then outboundMDMto consuming systems.

Data Analyst/MDM Consultant

Confidential - Durham, NC

Responsibilities:

• Initial requirement was to set up an environment supportingMDMand ensuring its compatibility with the insurance domain so my primary responsibility was to create a collaborative master database which would be reliable and would comply withMDMand client standards.
• Interpreted business requirements to technical specification and create a design to frame ETL and analyzed data modelling for subject areas like Trials, Study and Checklist and suggested enhancements and worked on creating database objects viz, Schemas, tables, views, synonyms, Stored Procedures and sequences and worked closely with DBA to create required database objects, layers, access and grants to distinct roles.
• Worked on Informatica Power Centre tool - Designer, Manager and Repository and on Informatica Web services, stored procedure transformations and XML transformations., generated Dashboards in Tableau with Quick filters, Parameters and sets to handle views more efficiently, expert in ITSM, ITOM, CMDB and discovery, configuration management, cloud infrastructure and automation and created bump charts, Heat maps and Bullet charts using Tableau.
• Prepared user stories to create compelling dashboards to deliver actionable insights and created action filters, parameters and calculated fields for preparing dashboards and worksheets inTableauand worked extensively with Advance Analysis Actions, effectively interacted with Business Analysts and Data Modelers and undertook gap analysis. Reevaluated the underlying tables/view/stored procedure structures to see if they will be a best fit forTableau.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time and was responsible for leading software testing, troubleshooting, and implementation, supported end-users, company-wide to resolve database and software issues utilizing remote desktop tools and knowledge sharing with the end users and documented the design, development process and the schedule of each mappings/jobs.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment and was involved withDataSteward Team for designing, documenting and configuring InformaticaData Director for supporting management ofMDMdata.
• Responsible for creating user groups, privileges and roles to the users using Security Access Manager and worked on integrating Hierarchies created inMDMHub Console and IDD.
• Prominent level review of SAM - discussed use of Roles, creation of users and assignment of user to Role, implemented Search feature, Add/Update feature and Task Assignment feature in IDD for Admin user.
• Implemented Post Landing, Pre-Staging, Save Handler User Exits using Eclipse Mars and integrated those user exits withMDMHub Console using User Object Registry module.
• Performed analysis, design, development and maintenance activities associated with the database anddatain support of multiple applications (including following standards/procedures to achieve integration of systems through database design).

Business Analyst

Confidential - Bronx, NY

Responsibilities:

• Interacted with Business users and designed ETL architecture, assisted infrastructure team to setup environments like Development, QA, UAT, and Production, served as technical lead for projects, enhancements, and production. Provide direction, leadership, and mentorship to Data Warehouse and Master Data Management to ensure quality of deliverables.
• Used the graphical BPMN notation to design business process using a service oriented process automation platform called Active VOS and analyzed multiple data marts, and migrated the ETL processes (SSIS to Talend) and BI (SSRS to Tableau) into Data Warehouse.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in workschedules and possess effective communication skills, collaborated with Data Architect, domain experts, business users, and management to achieve results.
• Created ETL Mappings to loaddatausing transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy and evaluated system performance and optimized via changes to Database and ETL mappings, monitored performance and optimized SQL queries for maximum efficiency.
• Designed SSIS Packages to import and exportdatafrom MS Excel, SQL Server and flat file and analyzed existing ETL mappings from source systems to the DW tables to get an estimate on time and resources for code changing efforts to prepare Landing tables forMDMHub.
• Used Debugger to test the mappings and fixed the bugs and created Functions, Packages, Stored procedures, triggers using PL/SQL and helped QA team in creation of test cases for regression testing and created Staging tables &MDMMappings in InformaticaMDMHUB to loaddatafrom landing table into staging tables.
• Created SQL Scripts for benchmarking Database I/O performance on various sets ofData and was involved in Unit testing of Audit process & prepared design document.
• Wrote SQL queries to perform data analysis and prepared Business Requirement Documents (BRD), Mapping Document based on the gathered requirements.
• Developed Test Cases, Facilitated UAT, compiled results, reviewed and discussed with Business Owners to provide signoff for the Clarity Reports and worked on stored procedures that are used in mapping pipeline.
• Worked under the guidance in the creation, enhancement and maintenance of new Business Intelligence solutions and attend meetings in which we helped stakeholders to interpret and understand data in Business Intelligence reports
• Documented Requirement Traceability Matrix (RTM) in Requisite Pro through test cases and gathered requirements, Data and Use Case Analysis along with PDLC, SDLC and QA life cycle.
• Responsible for writing documents Functional Requirements/ Business Requirements that implement the functional changes to the Integration systems, as defined by requirement analysis and interacted with Business Affairs and provide better solutions for increasing productivity and creating efficient review process by conducting GAP analysis, budget forecasting and financial planning.
• Analyzed existing processes through Business Process Modeling (BPM) and followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Worked under the guidance of Senior Business Analyst in writing Functional Specifications Document(FSD) and User Requirement Specification (URS) and provided clear and concise documentation regarding requirements management plans, Functional Requirements, Test Plans and Test Cases.