PROFESSIONAL SUMMARY:

• Results - driven and senior analytical IT professional with a wealth of experience in data warehousing, ETL, data modeling, data marts and data solutions. Skilled in Teradata, Informatica, ETL, SQL, Google Cloud, project management, transitioning data from legacy systems into relational database management systems.
• Building ETL Pipelines, designing data marts and Reporting required Metrics which can help measure performance and customer experience. Following are the recent s completed.
• Comprehensive experience in Analysis, design, development, implementation, and support of software applications in Data Warehousing.
• Experienced in working on GCP migration’s project like data migration’s from on premise Teradata and Hadoop to GCP GCS and Big query, worked on migrating the on premise ETL Informatica application to IICS.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in Dimensional Modeling, ER Modeling, Star Schema/ Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Have exposure in Hadoop ecosystem like creating/transforming/loading/implement partitioning/Query/Analytics in HIVE for data from heterogeneous source systems using HiveQL
• Strong Experience in Business Process Management, Gathering Requirements from users to determine the Functional and Technical Design and creating design process and scheduling of tasks to the team.
• Excellent interpersonal and communication skills, and experienced in working with senior level managers, businesspeople, Product Owners and developers across multiple disciplines.

TECHNICAL SKILLS:

• Teradata
• Snowflake
• Oracle
• SQL
• Informatica PowerCenter
• Hadoop,Hive,Imapla
• Data Profiling, Data Quality and Data Modeling
• Erwin
• Google Cloud Platform
• Bigquery

EXPERIENCE:

Sr.DATA ANALYST/engineer

Confidential

Responsibilities:

• Responsible for analyzing the business requirements, architect, design, develop and implement highly efficient and scalable ETL process.
• Architected scalable, reliable ETL/ELT solutions with ETL Tools (Informatica), SQL
• Migrated data team to migrate data from Teradata to Google cloud GCS and Bigquery as part of cloud migration.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
• Provide Technical Consultation and issue resolution to application users and cross functional teams.
• Provide Monthly report of incidents and their root causes, provide categorizations for all the incidents raised during the month and propose permanent fix through problem tickets.
• Understand and translate business needs into data models supporting long-term solutions
• Responsible for end-to-end data life cycle from requirement gathering to production deployment to Postproduction activities.
• Analyzing data-related system integration challenges and propose appropriate solutions.
• Providing technical expertise on data storage structures, data mining, and data cleansing.
• Supports business users answering complex business questions via ad-hoc SQL queries
• Provided reusable data quality framework
• Reviewing Design and ETL Solutions and guiding the team to complete their tasks.
• Helping Business users and PO’s to provide data quality solutions and respond to any data related issues.

Data Architect

Confidential

Responsibilities:

• Produced conceptual, logical, and physical models from gathered requirements to re-architect the existing data warehouse
• Designed reporting ODS, staging area and data marts for each Line of Business to deliver Enterprise Data Warehouse (EDW)
• Determined database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems
• Engaged in data analysis, technical design, documenting, coding, unit testing, deployment and maintenance of various data load modules.
• Provided technical design overviews for the DW setup, and participated in technical reviews for IT related implementations.

Technical lead

Confidential

Responsibilities:

• Preparation of Data model, which includes conceptual, logical and physical model in Erwin.
• Involved in requirements analysis and design and source system analysis to derive the business logic, validation of data mappings.
• Refines data warehouse standards and participates in the global definition of architecture principles, policies, and industry best practices.
• Engages with database administration functions to assess performance management concerns and recommend sound improvement methods
• Involved and interacted with Business SME’s on requirement gathering, understanding the business and functional requirements.
• Hands on impact Analysis for the changes made in source system and providing necessary solution approaches required for changes in target DW environment
• Involved in the Performance Tuning & and resolving if any issues in reporting sql’s.
• Preparing the Solution design document and application architecture design documents.
• Review ETL Code (Informatica, Bteq and Sql’s) prepared by team members
• Created reports for the BI team using Sqoop to export data into HDFS and Hive.
• Data analysis and data profiling on source system
• Writing SQL to generate custom reports for Business users
• Data validation in production environment
• Preparing source to target mapping document

Data analyst

Confidential

Responsibilities:

• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimized and update logical and physical data models to support new and existing projects.
• Maintained conceptual, logical and physical data models along with corresponding metadata.
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Evaluated data models and physical databases for variances and discrepancies.
• Validated business data objects for accuracy and completeness.
• Analyzed data-related system integration challenges and propose appropriate solutions.
• Developed data models according to company standards.
• Identify/anticipate data requirements and proactively initiate source systems analysis to explore source data
• Worked closely with DBA and given solutions in various areas like performance tuning, space Issues

Teradata developer

Confidential

Responsibilities:

• Developed Bteq scripts to load data from Teradata Staging tables into Teradata Target tables.
• Worked with Teradata DBA team to build Database components, resolve access and performance issues.
• Worked on fixing data quality issues.
• Responsible for ensuring the quality, coding standards and creating required documentations.
• Created ETL Mappings for existing Sources/Feeds to Data warehouse fields.
• Created unit test cases and executed.
• Involved in integrated and system Testing.
• Involved in doing peer reviews.