Performed duties of Data Architect/Data Analyst and provided solutions for various retail segments with a strong focus on Master Data Management (MDM), Product Information Management (PIM).Responsible for • Designed graphs, pests and plans to extract, transform and load bulk about of complex data using ETL tool Ab Initio.• Consolidate product-related data(SKU information) from varied sources, clean, validate, transform, and load bulk data to the repository. • Interface with key stakeholders and apply technical proficiency across different stages of the Software Development Life Cycle including Requirement Elicitation, Application Design, and Development.• Provides development estimates and participate in project planning.• Design Tableau dashboards to identify, analyze, and interpret trends or patterns in complex data sets.• Troubleshoot complex data-related issues and assist Production Support team.• Lead various development activities and ensuring high-quality deliveries.• Peer mentoring and code review of team members.

As a Data Architect/ETL Developer built varied applications to support KYC program of CITI BANK US. KYC (Know-Your-Customer) process was responsible to perform due diligence, ensures compliance with KYC regulations, Customer Identification Program Procedures(CIP-P) and other regulatory requirements intended to protect CITI from being used for Money Laundering or terrorist financing activities. • Supported new business acquisition process through data migration activities which included data profiling, modeling, integration, transformation, and loading• Designed Tableau dashboards to identify, analyze, and interpret trends or patterns in complex data sets• Identified trend and patterns for nearly 3.5 M products and prepared statistical reports, analyzed and presented to business users• Accounted to generate ad-hoc excel reports using SQL queries.• Responsible to identify the issue, analyze the cause of the issue and provide possible solutions for continuity of information flow• Accounted to generate ad-hoc excel reports using SQL queries to report missing product information to key business users.• Analyzed, designed, developed, tested, and implemented various ETL processes based on business and end-customer requirements.

Worked for CITI BANK US in retail banking domain and performed below list of duties:-• Interact with client for requirement gathering.• Performed BA kind of role in RA phase.• Prepared designs and recommended possible solutions for complex problems. • Built applications using graphs, plans, psets, and other Ab Initio features to meet end-user requirements.

Capital One US was one of the major clients in banking and finance domain for Wipro. While working for Capital One performed duties of software developer and built ETL applications to transform and load bulk amount of data. Also, provide end to end support at L2 and L3 levels for various Data warehousing applications.