PROFESSIONAL SUMMARY:

• Accomplished Data warehouse analyst/Architect with 15+ years of experience in all phases of the SDLC, driving design, implementation, testing, Integration, deployment and maintenance of data warehouse systems
• Comprehensive experience in Analysis, design, development, implementation, and support of software applications in Data Warehousing.
• Experience on Cloud migration projects.
• Experience in Dimensional Modeling, ER Modeling, Star Schema/ Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• 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.
• Management skills include Team Management, Project Planning, Monitoring, and self - starter with good communication skills and ability to work independently and as part of a 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
• SQL
• Informatica PowerCenter
• Hadoop
• Data Profiling, Data Quality and Data Modeling
• Erwin

PROFESSIONAL EXPERIENCE:

SR.DATA ANALYST

Confidential

Responsibilities:

• 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
• Building and supporting of User maintained tables for data corrections to maintain data quality.
• Provided reusable data quality framework
• Reviewing Design and ETL Solutions and guiding the team to complete their tasks.
• Working with closely with PO’s to identify the business problems and providing solutions and resolving.
• Helping Business users and PO’s to provide data quality solutions and respond to any data related issues.
• High involved in any production related issues and providing solutions quickly to meet SLA’s.
• 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.

Data ANALYST

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