SUMMARY

• A PMI Certified Project Management Professional (PMP) with 25 years’ experience in Information Technology and experienced with Informatica Master Data Management, Informatica Metadata Manager, Informatica Data Quality, Power Center, Ab Initio, Data stage, Oracle, Collibra, Teradata and AWS in industry verticals like Finance, Insurance and Health care.
• Strong Professional experience in designing, implementing, and managing short and long - term projects in the Information Technology industry. Dynamic, energetic, and effective communicator with experience in managing and motivating multi-disciplined teams and comfortable communicating with senior management and systems professionals at all technical levels.
• Extensive Global experience in leading large, complex IT onsite and offshore programs for Fortune companies. Consistent track record of on-time and on-quality delivery.
• Responsible for all activities related to the development, implementation, and support of ETL processes for large-scale data warehouses.
• Strong experience with Informatica MDM hub design, configuration, C360 and implementation.
• Strong experience in developing Informatica MDM User Exits, Trust rules, Match and Merge rules, IDD and Hierarchies in Informatica MDM.
• Expertise in MDM, IDD, ActiveVOS, PC, IDQ and Address doctor software installations.
• Experience with Informatica Metadata Manager and Business Glossary.
• Strong experience in Data Governance and developing rules with Informatica Data Quality(IDQ) tools.
• Extensive experience with ERWIN, Power Designer, data modeling & data analysis using Dimensional Data Modeling and Relational Data Modeling, Star Schema and Snowflake schema modeling, FACT and Dimensions tables, Physical and Logical Data Modeling.
• Database experience using Oracle, Teradata, BTEQ, MultiLoad, FastLoad, SQL, PL/SQL, SQL Loader, Stored Procedures and Functions.
• Project Manager with proven track record for providing on-time project delivery and meeting or exceeding all target goals and objectives.
• Experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience with Teradata’s Financial Services Logical Data Model.
• Experience in providing the architectural solutions and creating the metadata model.
• Experienced in all phases of the Systems Life Cycle, including project definition, analysis, design, coding, testing, implementation and support.
• Expertise in designing Universes from scratch, migrating to different environments, designing Web Intelligence documents and maintaining them on Business Objects XI R2.
• Experience with Agile development - Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums, Sprint Check-In, Sprint Review and Retrospective
• Experience with Big Data Technologies.
• Expertise in UNIX and UNIX shell scripting.
• Designed and deployed well-tuned Ab-Initio graph (Generic and Custom) for ODS and DSS instance both windows and UNIX environments.
• Demonstrated experience in developing and implementing formal project management methodologies and establishing standards.
• Experience in coordination with offshore development team
• Excellent problem solving, communication, team and client management skills.

TECHNICAL SKILLS

Tools: Siperian Informatica MDM 9.1/9.5/9.6/10/10.1/10.3 , Informatica Power Center (8.x, 9.x,10.2), Informatica Designer, Workflow Manager, Workflow Monitor, Informatica Metadata Manager 9.6.1, IDD, AVOS, SIF, IDQ, Informatica Developer 9.6.1/10.2, Informatica Analyst 9.6.1/10.2, Informatica Power Exchange, Data Explorer, Ab Initio, Greenplum, Address doctor, Trillium, Collibra, Oracle MDM and Data stage 7.5/8.0, AWS, BitBucket.

Database Utilities: PL/SQL, Toad 8.0/12.1, Export / Import, SQL Plus and SQL * Loader

Scheduling Tools: Autosys, Maestro, Control -M and UC4

Databases: ORACLE 8/9/10g/11i, MS SQL Server 2000/05, MS Access, Teradata V2R25/12/13, DB2, IMS DB and HBASE

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 3.5/4.0/7.1/9.0/9.5 , Power Designer v16.5/16.6.

Big Data Technologies: Hadoop (HDFS & Map Reduce), PIG, HIVE, HBase, Sqoop, Impala, HiveQL, Kafka, YARN, SCALA, R, SPARK and PYTHON.

Application Server: IBM Websphere 4.2/5.1/6, JBoss 6.4, 7.x

Web Tools: JDBC, JSP, JAV Script, HTML, XML, SOAP, Web Service and VB Script.

Reporting Tools: Business Objects XIR2, 4.0, Crystal Reports, Tableau, Qlikview and Cognos

Defect Tracking Tools: Quality Center/ HP ALM

Operating Systems: Windows XP, MVS ESA, IBM-AIX 4.3.2 and Sun Solaris 2.6/7

Languages: , PERL, SAS, MQ Series, Stored Procedures, Unix shell scripting, C#, Java

Project Process: SDLC, CMMI, RUP and AGILE

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

VP, Master Data Management Technical Lead

Responsibilities:

• Conducted several meetings for consensus building of current state system, future state, process flows, proposed architecture and roadmap with key technology and business stakeholders.
• Provided technical direction and managed the project team members across multiple groups and departments for strategic assessment, current state analysis, target state IT strategy, requirement definitions and program road maps.
• Involved in vendor and Informatica MDM, IDQ and PC product selection
• Worked with 200+ interfacing systems Business IT, System owners and SME's in workshops and various stakeholder meetings and developed roadmap.
• Interacted with the business users to gather the party data elements from various Party data systems and LOBs.
• Reviewed data requirements, business requirements, conceptual, logical, physical data model, functional design document and detail design documents.
• Reviewed code and ensured best practices are followed.
• Reviewed ETL code to load from source systems to pre-landing, MDM landing tables and outbound interface systems.
• Assisted Enterprise Architects for developing the architecture solution diagram.
• Involved in planning, design and build and MDM, RDM, IDD and services code deployment.
• Interacted with QA team during SIT phase deliverables.
• Reviewed match and merge rules, trust, validation rules, queries, packages, hierarchies and IDD.
• Configured the ActiveVOS and Provisioning tool for business entities.
• Configured JMS queue and real time services(SIF APIs) for outbound interfaces
• Conducted POC for Syncsort and Informatica Power exchange to capture real time changes.
• Implemented reference data using Informatica RDM.
• Performed data encryption using Voltage API.
• Mapped KDE's to BIM (Business Information Model) Domains and Sub Domains
• Develop Data Quality framework, created DQ rules using Informatica Data Quality(IDQ).
• Performed data profiling using Informatica developer and analyst, analyzed DQ results, anomalies and created dashboard. Developed address standardization rules.
• Involved in MDM, IDD, ActiveVOS, PC, IDQ and Address doctor software installations and configuration.
• Developed re-conciliation approach document to reconcile the data between multiple hops.
• Created DevOps process for deploying the code.

Software/Tools Used: Informatica MDM 10.3, IDD, SIF services, Informatica Data Quality(IDQ) 10.3,Informatica Power Center v10.2, Informatica Power Exchange, Informatica RDM, Address doctor, JBoss, ERWin 9.8, Syncsort,, Toad, Oracle, SQL, Colibra, Greenplumb, Jira, Bit Bucket and AWS Cloud

Confidential, Mount Laurel, NJ

Senior Solution Architect

Responsibilities:

• Interact with the business users to understand the requirements
• Developed the timeline and tracked the progress.
• Developed project plan, monitor risks and execute risk response plans.
• Negotiated with customers to prioritize the resolution of issues.
• Involved in customer and delivery management.
• Perform problem analysis and issue resolution.
• Create the system design specification(SDS) document for the entire program and review with the management
• Involved in developing the design documents and review the designs.
• Used mapping editor in Power Designer to map between source and target columns
• Created logical, physical data Models and created Business Glossary using Informatica Metadata manager.
• Standardized the data using reference tables.
• Reviewed the data profiling output and identified the data anomalies.
• Developed stored procedures and proto type SQL and HiveQL
• Developed ETL to load the data into MDM Hub and to downstream systems.
• Developed Reference tables using IDQ Analyst tool.
• Created trust, match and merge rules in the MDM Hub.
• Configured the provisioning tool for business entity services
• Developed landing, staging and base object models in MDM hub.
• Create source to target mappings for source to data lake(EDPP) Hadoop ecosystem, from EDPP to pre-stage via using sqoop, pre-stage to stage layer and stage and RRDW layer
• Configured the IDD application for different subject areas.

Software/Tools Used: Informatica Power Center v10, Informatica MDM 10.1, IDQ, IDD, Power Designer 16.6, Oracle, HDFS, HiveQL, Sqoop, TOAD, Tableau, SVN-Sub version, Visio and MS Project.

Confidential, Pleasanton, CA

Sr. Data Architect

Responsibilities:

• Involved in MDM v10.0 installation activities using JBOSS application server and informatica platform.
• Interacted with business users to understand the business need and prepared the requirement document.
• Created the design document to master the data and build hierarchies.
• Created Physical Data Objects and Logical Data Objects in Informatica developer.
• Developed ETL code using Informatica Developer to bring data from different source systems and load into MDM staging tables.
• Created the batch group jobs to load the data from MDM staging tables to Base object tables.
• Configured match and merge rules to create the BVT.
• Developed cleanse functions to standardize the data before loading into staging tables.
• Created the Entity and Relationship data model to build the hierarchies.
• Developed the ETL code using Informatica Developer to load the Entity and Relationship tables from the excel source.
• Built the MDM hierarchy packages and profiles to determine how the data should be displayed in MDM Hierarchy Manager and IDD.
• Built IDD application and configured the subject areas to govern the hierarchical data.
• Built basic and advanced queries to view and modify the hierarchical data through IDD.
• Built IDD user exists to extend the MDM functionality.
• Configured the ActiveVOS to manage tasks, request and reports.
• Performed the data profiling using IDQ tool to identify the data anomalies.
• Analyzed the profile results, score cards and created the rules
• Performed data validation and implemented the DQ rules using mapplet in IDQ
• Created the dashboard with rules assigned to the data quality dimensions
• Developed custom metadata objects and added business glossary in Informatica Metadata Manager.
• Created conceptual, logical and physical data models.
• Copied data to and from Cluster and native OS. Ingesting data into HDFS using Flume and Sqoop.
• Created table and column families in HBase.
• Prepared the project plan and successfully delivered on-time, within scope and budget by monitoring and tracking the progress
• Performed the risk management to minimize project risks.

Software/Tools Used: Informatica MDM v10.0, IDD, Informatica Analyst 9.6.1, Informatica Developer 9.6.1, Power Center 9.6.1, Hive, HDFS, Flume, Red hat Linux, Oracle, Power Designer, JIRA and Visio.

Confidential, Pleasanton, CA

Senior Data Architect

Responsibilities:

• Gather business requirements to migrate Rochade to Informatica Metadata Manager 9.6.1 for 8 regions.
• Involved in design discussion and prepared the technical design document.
• Recommended the architectural solutions and obtained approval from the Management.
• Created source to target mapping and rules for the Teradata source to custom model.
• Developed ETL mappings to create CSV file for metadata from Teradata resources.
• Developed the custom model in Metadata Manager.
• Created custom x-connect and linked custom models and out-of box models.
• Developed the custom resources to load the metadata in Informatica MM warehouse.
• Loaded Rochade clarity metadata in MM warehouse using out of box model.
• Loaded the business glossary in Metadata Manager.
• Used Spark to create RDD on files (local and HDFS).
• Created HiveContext to execute hive query using Spark engine.
• Real Time Data Indexing and Analysis using Kafka.
• Motivated the resources to work as a team and encouraged to ensure high quality of deliverables.
• Responsible for the management of technical project from initiation through implementation, includes: planning, analysis, design development and implementation.
• Provides overall direction for establishing project requirements, priorities and deadlines. Integrates project plans into Program Plans.

Software/Tools Used: Informatica Metadata Manager (MM) 9.6.1, Informatica Power Center 9.6.1, UNIX, Teradata 13, Oracle, Hive, Spark, Scala, Python, Oozie, Impala, Kafka, Avro and SQL developer.

Confidential, Sunnyvale, CA

Senior MDM and Data Integration Architect

Responsibilities:

• Interact with Sales Operations team to gather business requirements and translate to technical requirements.
• Create Project Plan, schedule, priorities the tasks
• Developed the logical and physical data model for Party data model.
• Document and maintain technical requirements, including data flows, data structures, and data definitions.
• Manage technical team on solution implementation.
• Manage technical operations of Master Data Management and Aggregate Spend systems.
• Configured Siperian Informatica MDM, setup Trust rules, match and merge rules.
• Loading the various business applications data into landing, staging and base objects MDM hub console.
• Created the duplicate data report for data stewards to review.
• Used Merge Manager and Data Manager to perform merge and un-merge HCP and HCO data.
• Developed customized user exits and performed address cleaning using IDQ.
• Involved in MDM operations and informatica mappings enhancement to the existing functionalities.
• Performed code migration using MDM metadata manager.
• Support data issues with Veeva sales force application.
• Created profiles, score card and data quality rules.
• Used address doctor to standardize the addresses.
• Define operational procedures and metrics to ensure effective and efficient operations.
• Developed best practices and guidelines for MDM operations.
• Performed data analysis, data fixes and master the data as per the ad-hoc requests.
• Define areas for improvement, and manage implementation of improvements.

Software/Tools Used: Informatica MDM 9.6.1, SIF API, Informatica Power Center 9.5, IDQ, Sales force -Veeva, Oracle, Toad, SQL, Unix, Power Designer,, MS Project.

Confidential, Boston. MA

Data Architect

Responsibilities:

• Build Informatica mappings to use Address doctor for address cleansing.
• Developed Informatica mappings to get data from IDQ database for RSA and SAP data.
• Enhance the existing Informatica mappings to receive the data from 11i for all defined set of attributes to Informatica MDM HUB.
• Data conversion from Informatica HUB to iMAP.
• Created Data Conversation Design document and obtained sign - off from the Client.
• Performed code migration from Dev to Test and Performance environment. Check-in, Check-out and apply label.
• Adhered to the Informatica MDM Architecture to extract the data from the 11i to the LOAD Inbound staging environment for landing load to the Customer MDM HUB. Also Extract the data from customer MDM HUB and load the data to outbound staging environment. Integrated both batch and real time data.
• Reviewed the enterprise conceptual, logical and physical data model for MDM.
• Followed guidelines and best practices for building the data model
• Developed cleansed functions. Setup trust rules, match and merge rules in MDM.
• Developed data quality rules using IDQ.
• Support Functional, System testing and ensure defects are fixed on time.
• Provided status update and issue resolution to the management.
• Coordinated with business, onsite and offshore team.

Software/Tools Used: Informatica MDM 9.5, Informatica IDD, IDQ, Address doctor, Trillium, Informatica PC 9.1, SIF, Oracle, ERwin, SQL Developer, Control-M, UNIX and HP QC.