SUMMARY:

• Around 9+ years of experience in Information Technology Industry as Sr. Data Analyst.
• Experience in Data Warehousing/ETL Architecture designing and Data Modeling (Star & Snowflake Schema and LDM & PDM) for large and complex data warehousing projects and also experience in leading technical teams.
• Experience in designing of on - line transactional processing (OLTP), operational data store (ODS) and decision support system (DSS) (e.g., Data Warehouse) databases, utilizing Data vault (hub and spoke), dimensional and normalized data designs as appropriate for enterprise-wide solutions
• Experience in Inmon and Kimball data warehouse design and implementation methodologies
• Experienced in data analysis, data modeling, Conceptual logical modeling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Designed and developed Logical and Physical data models using Erwin Modelling tool.
• Strong working experience using ETL tools: InformaticaPowerCenter 9.x, Oracle Database, Teradata, and Power Exchange CDC Express 9.6.1.,ODI, DataStage Enterprise Edition 7.x and Data Stage Server Edition
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experienced with medium to large-scale enterprise software projects and well versed with the various phases of the software development life cycle and Application Value Management Life cycle
• Experienced working with Data Migration from Legacy systems to advanced relational databases, Data Conversion, Data Archiving into Central Repository/Informatica Servers
• Having good knowledge and experience of RDBMS concepts
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
• Experienced in phases of the Data Warehouse Development Lifecycle (Design, Development Testingand Issue Resolution).
• Experienced in creating Test Cases, Test Plan, and Test Data. Performed User Acceptance Testing (UAT) working with team members.
• Experienced in the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Informatica Power Center.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Tableau
• Hands on experience on Oracle, Teradata as part of Data Warehouse project.

TECHNICAL SKILLS:

Operating System: Windows XP, AIX V5.3, Sun Solaris 8.0

Environment: Client/Server

Database: Oracle 11g/12c, Teradata

Modelling Tools: ERwin 9.5.2/7.3, MS - Visio 2007, Power Designer 15.2

Languages: SQL,PL/SQL,C,C++

ETL: Informatica Power Center 9.6.1,InformaticaPowerExchange CDC Express9.6.1, ODI, TeradataDataStage Enterprise Edition 7.x and Data Stage Server Edition

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Understand and translate business needs into data models supporting long - term solutions, created logical and physical data models using best practices to ensure high data quality and reduced redundancy and also embedded data dictionary into data model
• Optimized and update logical and physical data models to support new and existing re-design requirement.
• Responsible for Metadata Management, keeping up to date centralized metadata repositories using Modeling tools, preparation of business glossaries
• Used Data Vault as a data integration architecture and achieved many advantages of Data Vault approach some of them are simplified the data ingestion process, removed the cleansing requirement of a star schema and easily allowed for the addition of new data sources without disruption to existing schema
• Data Vault used in both a data technique and methodology which accommodates historical data, auditing, and tracking of data.
• Data governance functional and practical implementation and also responsible for designing common Data governance frameworks
• Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tool like (Tableau)
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Strong working experience in the Data Analysis, Data Profile, Data Quality, Design, Development, Implementation and Testing of Business Intelligence applications using ETL and ELT methodology.
• Experienced in Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance.
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Involved in Performance Measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• Prepared Source-to-Target mapping documents and Involved in Fine-tuning of sources, targets, mappings and sessions for Performance tuning and optimization.
• Actively involved in Source Driven Testing, Target Driven Testing, Business Cycle Testing, Business Scenario Testing and Data Integration Testing.
• Worked on creating SQL queries and performance tuning of queries
• Worked closely with Architects and developers to deliver the database components for large scale, complex web based applications.
• Worked on Tableau for BI analytics.
• Assisted developers and customers with ad hoc retrieval of information
• Worked on data manipulation and analysis & accessed raw data in varied formats with different methods and analyzing and processing data
• Performed data modeling and data analysis as required.
• Responsible for researching data quality issues (inaccuracies in data), worked with business owners/stakeholders to assess business and risk impact, provided solution to business owners
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.

Environment: Erwin tool 9.x, PL/SQL, Informatica PC 9.6,Informatica CDC Express 9.6, Oracle 11G/12C, ERWIN data modeler, UNIX, TIBCO,Maximo,Tableau

Confidential

Responsibilities:

• Understand and translate business needs into data models supporting long - term solutions, created logical and physical data models using best practices to ensure high data quality and reduced redundancy and also embedded data dictionary into data model
• Optimized and update logical and physical data models to support new and existing re-design requirement.
• Responsible for Metadata Management, keeping up to date centralized metadata repositories using Modeling tools, preparation of business glossaries
• Used Data Vault as a data integration architecture and achieved many advantages of Data Vault approach some of them are simplified the data ingestion process, removed the cleansing requirement of a star schema and easily allowed for the addition of new data sources without disruption to existing schema
• Data Vault used in both a data technique and methodology which accommodates historical data, auditing, and tracking of data.
• Data governance functional and practical implementation and also responsible for designing common Data governance frameworks
• Wrote functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, and Maps etc.
• Gathered business requirements from users and developed the Data Model to be used to develop Tableau dashboards.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL Server.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality.
• Prepared test Data sets and performed data testing using the PL/SQL scripts.
• Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system
• Conducted workflow, process diagram and GAP analyses to derive requirements for existing system enhancements
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Created Source to target Data Mapping documents identifying key data elements and prepared Data Flow Diagrams
• Created a new risk and regulatory reporting system to deliver accurate and timely reports through a central data warehouse.
• Facilitated with Data Governance effort and assert best practices.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system
• Provided test data to all the testers including UAT Business Edge team and UI testing team
• Analysis and Design of Migration Procedures for the DB Migration between Relational and Extended ERP Data Sources. Performed Database Migration from sources to the Data Warehousing database. Worked closely with Oracle DBA for migration support..
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)

Environment: Erwin tool 7.x PL/SQL, Data stage, Oracle 10G, ERWIN data modeler, UNIX,Tableau

Confidential, El Segundo, CA

Responsibilities:

• Involved in SQR analysis, analysis of the gaps between MIDW and EDW.
• Involved in the ETL and database design of the data mart and enhancements of EDW required for integration.
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in Informatica and creating ETL jobs in Informatica.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Converted various PL/SQL statements into Informatica logic.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Developed business requirement specification documents as well as high-level project plan.
• Worked with the software architects / developers to ensure that the applications conform to customer requirements.
• Supported business areas and database platforms to ensure logical data model and database design, creation, and generation follows enterprise standards, processes, and procedures
• Designed database solution for applications, including all required database design components and artifacts
• Provided input into database systems optimization for performance efficiency and worked on full lifecycle of data modeling (logical - physical - deployment)
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• An excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

Environment: Erwin tool 7.x, InformaticaPowerCenter 8.6.1, Oracle 10g, UNIX, Cognos

Confidential

Responsibilities:

• Used the Informatica to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Wrote SQL queries using Teradata for data manipulations.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system
• Responsible for sitting down with business users to analyze dashboards and analytical reporting requirements using Tableau.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system
• Provided test data to all the testers including UAT Business Edge team and UI testing team
• Analysis and Design of Migration Procedures for the DB Migration between Relational and Extended ERP Data Sources. Performed Database Migration from sources to the Data Warehousing database. Worked closely with Oracle DBA for migration support.
• ETL process design, implementation and performance tuning (SQL, Teradata macros and stored procedures).
• Designed the ETL processes using Informatica tool to load data into Target Teradata Database.
• Writing Technical specification documents.
• Involved in to fix the defects.
• Optimized session performance by eliminating performance bottlenecks

Environment: Informatica 7.1, Teradata, Oracle and UNIX

Confidential

Responsibilities:

• Extensively involved in Data Extraction, Transformation and Loading (ETL Process) from Source to target systems using Sunopsis ELT tool.
• Involvement in UTC, IT, ST, Peer to Peer review and Regression Testing.
• Involvement in to prepare the deployment plan, PT and tuning of query and logic in ETL level as well as Database level.
• Involve in to prepare the MoM and documentation work.
• Understanding requirements as per the Client.

Environment: Sunopsis ELT tool, Oracle, Cognos, UNIX

Confidential

Responsibilities:

• Involvement in UTC, IT, ST, Peer to Peer review and Regression Testing.
• Involvement in to prepare the deployment plan, PT and tuning of query and logic in PL\SQL level as well as Database level.
• Involve in to prepare the MoM and documentation work.
• Understanding requirements as per the Client.

Environment: Java, JSP, Servlet, Oracle 9i