SUMMARY

• Over 9 years of experience in the areas of Data management, Data Warehouse and Analytics working on projects for Industry leaders like Confidential, Confidential, Confidential, Confidential and Confidential Bank.
• 9 Years of experience in data domain working for industry leaders like Confidential, Confidential, Confidential, and Confidential in various roles such as Data Engineer, Developer, Data/ Business Analyst/Risk Analyst, Data Modeler, Data Architect and Business enabler.
• 7 years of experience working in Confidential consumer banking data warehouse considered to be the biggest Teradata warehouse in the financial domain.
• Experience working with various RDBMS system such as Teradata, Oracle, RedShift and MySQL.
• Worked in many project that involve Hadoop conversion and new Hadoop based solutions.
• Experience in areas like Risk Management, Anti Money Laundering (AML) and Risk Data Aggregation (RDA)
• Named as one of the inventor in the pending patent application for an innovative solution built for the security and privacy of the customer data stored in the bank data warehouse.
• Well experienced in creating deliverables such as Business Requirement Document (BRD), Requirement Traceability document, High level Design Document (HLD), Test cases etc.
• Six Sigma greenbelt certified - Responsible for number process improvement activities within and outside the team.
• Experience in working with data from different sources and in a heterogeneous environment with technologies such as SAS, Oracle and Teradata.
• Exceptional track record of working in every stage of Software Development Life Cycle (SDLC) using both waterfall and agile methodologies.
• Highly dependable Data Analyst, successful at profiling and interpreting data. Supportive and enthusiastic team player dedicated to streamlining processes and efficiently reconciling data issues.
• Experienced in creating User Stories and Use Cases as part of translating business requirements.
• Having good experience in SIT, UAT phases, production support and customer interaction.
• Experienced in source data quality analysis, defining of quality criteria and data governance.
• IIBA certified in business analysis with Diploma certificate in Banking and Finance Specialization

TECHNICAL SKILLS

Reporting: Teradata, Oracle, Redshift, MySQL, Microsoft Excel, Tableau, Micro strategy, SAS

ETL Tools: Teradata, Hadoop, Informatica

Legacy Systems: Mainframe

RDBMS/Database: SQL, Microsoft Access, Teradata, Oracle, Redshift, SQL Server

Hadoop/Big Data: Hadoop, Hive, Impala

Data Modeling: ERWIN,MySQL workbench, ER Studio

Methodologies/Tools: Quality Center, SharePoint, Hue

PROFESSIONAL EXPERIENCE

Confidential

Business/Data analyst

Responsibilities:

• Serves as a business liaison/intermediary between ITS and business end users.
• Translate business requirements and user expectations to Business requirement document
• Develops and manages business and user requirement specifications; leads analysis and verification to ensure consistency, traceability, feasibility and completeness; recommends and implements process improvement
• Working on the raw data for data profiling and analysis
• Conversion of source to target mapping from Teradata and Oracle based architecture to Hadoop based system for conversion projects.
• Create Adhoc report for business using Teradata, Impla and Tableau
• Analyzes, validates and develops business and technical process solutions; develops system requirements, and leads implementation efforts.
• Design and validate ETL specifications by analyzing requirements; constructing workflow charts and diagrams
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and other ETL solutions
• Create various documents such as Business requirement document, High Level Design and Test Strategy document.

Environment: SQL, Teradata, Tableau, Hadoop, Impala, Hive, Oracle

Confidential

Business/Data analyst

Responsibilities:

• Translate business requirements and user expectations to business requirement documentations
• Helping business partners from various lines of business by creating adhoc reports for answering critical business needs.
• Working on the raw data for data profiling and analysis
• Creation of metadata upload documents for new elements such as column names, tables, views, code values, new applications and source systems.
• Analyzes, validates and develops business and technical process solutions; develops system requirements, and leads implementation efforts.
• Serves as a business liaison/intermediary between ITS and business end users.
• Develops and manages business and user requirement specifications; leads analysis and verification to ensure consistency, traceability, feasibility and completeness; recommends and implements process improvement
• Design and validate ETL file specifications by analyzing requirements; constructing workflow charts and diagrams
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and other ETL solutions
• Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.

Environment: SQL, Teradata, Erwin, Mainframe

Confidential

Data Engineer

Responsibilities:

• Work with data scientists and research analysts to provide data needed for building automated decision making systems used in Confidential seller performance management and transaction management
• Develop, and maintain scalable, automated, user-friendly systems that will support our analytical and business needs
• Develop Business Intelligence (BI) Data Warehousing and Reporting solutions to address the growing business reporting, analytics and data requirements
• Designed and built the required data sets for seller reputation score. This system ranks the performance of sellers and allows them to visualize the metrics that matter most to their performance on Confidential .
• Regulate and refine the Seller Performance metrics by building de-normalized tables containing all the required components of Perfect order Percentage (POP score) metrics.
• Data mining and aggregation for reducing the customer complain rate (CCR) and improving the product quality for Confidential marketplace.
• Support engagement activities to analyze business environments, gather business requirements and create data visualizations in support of work product
• Convert risk score models from SAS and Python to Oracle based SQL codes
• Work closely with ETL and data science teams to vet and understand changes to key company-level metrics and implications for the various reporting

Environment: SQL, Oracle, SAS, RedShift, Teradata, Erwin, ER Studio, Hadoop

Confidential

Data Engineer

Responsibilities:

• Performing Transaction loss, Fraud and Credit risk related analysis. Support Confidential Risk users or data scientists for their data exploration, analysis and research, Risk assessment and Risk decisioning.
• Successfully translating business requirements and user expectations to user stories.
• Helping business partners from various lines of business by creating adhoc reports for answering critical business needs.
• Work with data architects and engineers to create offline data products - data-warehouse or Hadoop based solutions.
• The typical process for creating offline data products starts with initial ideation and includes analysis/research, prototyping, requirement documentation, design, development, QA, deployment and UAT.
• Capture business requirement and produce technical requirement for backend data processing and delivery.
• Generate Risk analysis reports based on seller segment for management review using Tableau and micro strategy.

Environment: Teradata, Tableau, MySQL Workbench, MS Visio, MS Outlook, MS Office Suite, Hadoop

Confidential

Senior Business/Data Analyst

Responsibilities:

• Conducting requirement gathering sessions in person and over virtual meetings to create business requirement document and obtaining sign off from the stakeholders.
• Successfully translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) and tools like ERWIN and MySQL Workbench.
• Helping business partners from various lines of business by creating adhoc reports for answering critical business needs using Teradata and Tableau.
• As Data analyst responsible for the understanding the business data requirements, ETL and subsequently creating testing of data in reports.
• Interacting with the project coordinator and users, Understanding the data issues and resolving it in a specified time frame, Interact with Client when and where required.
• Verifying the Business requirement document and Technical design document against requirements.
• Validating data in various stages, obtaining user acceptance in UAT and post production data validation.
• Worked closely with ETL developers to provide Load Specifications and Data Mapping Documents as well to remove knowledge gaps.
• Extensively worked on data profiling and scanning to de-duplicate records in the staging area before data gets processed.
• Worked with the test team to provide insights into the data scenarios and test cases
• Involve in peer review of Test cases written by testing and development teams.
• Worked on addressing various production issues by providing data validation and clarifications for the business logics.
• Creating estimates for various type of projects and adhoc activities.
• Facilitating Proof of Concept (POC) in evaluating new technologies and tools such as Hadoop, DM Express.
• Worked in some of the biggest conversion projects such as Confidential Lynch, Confidential and Confidential .
• Creation of metadata uploads documents for new elements such as column names, tables, views, code values, new applications and source systems.
• Documentation of existing and new business application with the help of extensive research and analysis.
• Providing training to the new business analyst joining the team on enterprise project procedures, data warehouse application and Metadata on all perspectives.
• Conducting business knowledge sessions for the developer teams in onshore and offshore on data warehouse applications, banking and finance.

Environment: Teradata, Tableau, Mainframe, ERWIN, MySQL Workbench, MS Visio, HP Quality Centre, MS Outlook, MS Office Suite,Hadoop

Confidential

ETL Developer

Responsibilities:

• Review Business requirements documents test team to provide insights into the data scenarios and test cases.
• Analyzing and understanding the Business requirements and Verifying the Business requirement document and Technical design document against requirements.
• Experience in Extract, Transform, and Load (ETL) Design, development and Testing.
• Experience in utilizing Teradata utilities FastLoad, MultiLoad, BTEQ scripting and FastExport.
• Worked in developing privacy application as tool to make the data warehouse complaint to the customer data privacy rules implemented by the Gramm - Leach - Bliley Act
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in mainframe/Teradata.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Written several complex SQL queries for validating Reports.
• Experienced working with Customer Information Data Mart for business reporting.
• Debugging the SQL-Statements and stored procedures for business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• Verifying the Business requirement document and Technical design document against requirements.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Created and validated the test data environment for Staging area, loading the Staging area with data from multiple sources.
• Created ETL test data for all transformation rules and covered all the scenarios required for implementing business logic.
• Developed and tested various stored procedure as part of process automation in Teradata.
• Checking the data integrity and referential integrity as part of data validation

Environment: Teradata, Tableau, Mainframe, ERWIN, MySQL Workbench, MS Visio, HP Quality Centre, MS Outlook, MS Office Suite,Hadoop