PROFILE:

• 9+Years of total IT experience.
• 4+Years of Data Architecture and Data Governance Experience
• Proficient knowledge of Databases, Data Modeling and Data Integration Technologies
• Extensive Experience with Data Governance, Data Quality and Reporting

SUMMARY:

• Sound proficiency in analyzing and creating Conceptual, Logical Data models, Data & Business flow diagrams using MS Visio.
• Well experienced on Data Architecture, Data Life cycle, Data modeling, Business Intelligence, Data warehousing and Data Quality
• Expertise in ER modeling(OLTP) and dimension modeling(OLAP)
• Expertise on Distributed Data Integration Techniques using Kafka, Oracle Golden Gate etc
• Expertise in Data Integration using ODI, Informatica, Nifi, Flink, Spark etc
• Expertise in Data Quality Management and Stakeholder Management, Cutover Management and managing development teams in multiple geographic locations.
• Architecture Design and Implementation of Data Integration, Data Quality Framework and Reports.
• Reduced Cost of maintenance (50%) by introducing machine learning in Application Support Management
• Experience in Dimensional Modeling (Erwin), Star / Snowflake Schema, Fact / Dimension Tables, Business Process Analysis, Production support, Data cleansing, Data analysis and Performance tuning of sources, targets, mappings sessions and SQL’s.
• Excellent Working knowledge of Agile and Scrum methodologies.
• Highly skilled in structured planning methods for project evaluation including Gap Analysis, SWOT Analysis, Feasibility analysis and Risk analysis.
• Understanding of Compliance Standards like PCI DSS, PII, Encryption and Tokenization
• Experience on Requirement Gathering and analysis for Data warehouse, Data Quality and Reports
• Design, Implementation and performance tuning of ETL for Data warehouse and OLTP systems.
• Clear understanding of Relational Database concepts, Expertise on Oracle 10g, 11g, Exadata, SQL Server
• Well versed in source code management and automating code deployment.
• Experience in working on Agile Methodology. Conducts "Scrum" meetings, daily stand - ups, reviews and retrospectives. Responsible for keeping "Sprints" on track.
• Experienced with Informatica Power Exchange and Oracle Data Integrator for Loading / Retrieving data from mainframe systems and other Enterprise level Data for reduced and cost-effective bulk loading mechanism.
• ETL Repository Setup and performance monitoring and tuning.
• Self-motivated professional, keen interest working with new technologies and solving challenging business problem

TECHNICAL SKILLS:

Data Modeling, Data Architecture: Erwin 3.x/4.x, ER Studio, Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Dimensional Data Modeling, Star Schema, Snow-Flake, Fact and Dimensions Tables.

Data Integration: Oracle Data Integrator, Informatica, Apache KAFKA, Nifi, Flink, Spark

Databases: Oracle, SQL Server, GreenPlum, PostgreSQL, Big Data(HDFS), Graph Databases

Reporting: OBIEE, Tableau, Apache Superset

Scripting: SQL, Oracle PL/SQL, Unix Shell Scripting

Languages: Python, R, Scala

Machine learning: Batch Performance Prediction

Source Code Versioning: SVN, Git

Management: Cutover and Stakeholder Management, Delivery Management, Microsoft Project.

SDLC Methodologies: Waterfall, Agile Scrum/ Kanban

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Data Architect

Responsibilities:

• Design and Review of Data Flow Architecture, Defining data standards.
• Integration of real time data and Machine Learning to predict the batch performance.
• Implement Frame works for reporting operational KPIs.
• Produce systems architecture documents and diagrams.
• Define conceptual, Logical and Physical Model of Data, Data modeling
• Implementation of Data warehouse and Operational Data Store.
• Data Model, Design and Implementation of CUBEs for Reporting.
• Design and implement reusable ODI components
• Define Data Quality Standards and implement custom data quality framework.
• Setting up ODI repository, Define Security Roles and User settings
• Implementation of dimensions, Slowly Changing Dimensions, Fact and aggregates.
• BusinessRequirement gathering, Analysis, Data Profiling and Data Quality Management.
• Lead the development team of 20 members.

Environment: Data Architecture, Data Governance, Oracle Exadata, Real time data, Machine Learning, Data modeling, Oracle Data Integrator(ODI), Machine Learning, Python, Data warehouse, Team Management.

Confidential

Data Architect

Responsibilities:

• Drive data architecture teamto define data rules
• Profiling Financial data for anomalies
• Architecture Design and implementation of Data Quality framework
• Preparing Data Quality Dashboards
• Led development team
• Performed extraction, transformation and loading of data from Mainframe tables, Flat Files, SQLinto Oraclein accordance with requirements and specifications.
• Understanding business needs and implement the same into a functional database design.
• Managed the Cutover and Change Management.
• Report Data Quality and Project Summary to top level management.
• Performance tuning of ETL code and implementingmultithreading and parallel processing for ETL jobs.

Environment: Data Architecture, Data Governance, Data Quality,Oracle Data Integrator, Informatica, Oracle, Oracle Store Inventory Management, Unix.

Confidential

Data Quality Architect

Responsibilities:

• Analyze JD Edwards systems for Identifying Data Entities and Data Rules.
• Architecture Setup for Data Quality Environment
• Interact with Business Stake holders to identify and formulate data quality rules
• Design and implementation of Data Loading and Reporting Package
• Development of Data Quality Rules and Configuring Data Quality Repository.
• Reporting Project and Data Quality status to Top Level Management
• Lead the pilot team to implementation with2 developers

Environment: Data Governance, Data Architecture, MS SQL Server, SSIS, SAP Information Steward, Team Management, Infrastructure Setup, Database Administration.

Confidential

Data Integration Lead

Responsibilities:

• Working in Data Architecture team for systems integration design.
• Prepare Architecture and detailed Design forData Quality Framework.
• Preparing Functional and Technical Design for Data Integration.
• Lead the Oracle Retail Data Implementation Team.
• Responsible for performance tuning of the ETL process and upgrading the ETL best practices document.
• Effectively worked with tuning SQL queries and Procedures to improve the performance of the jobs.
• Analyzed, Designed and Implemented the ETL architecture.
• Worked with OWB and ODI ETL and Data Integration tools to Pre-built modules for CDC, bulk loading etc.
• Identifying and monitoring critical data issues on Prices, Promotions and financial values.
• Designed and builtCode deployment and migration framework using Unix Shell scripting SVN and SQL/ PLSQL
• Created and Configured Dimensions, Attributes and Hierarchies.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence Generators and Stored Procedure
• Prepare DQ Dashboard with Tableau, Report data alignment issues to stakeholders in Top Level Management and tracking it down to closure.

Environment: Oracle, Oracle Retail Merchandising system, OWB, ODI, Informatica, Data Quality,Tableau, Unix System Integration, Financial Data Profiling and Reporting.

Confidential

Data Modeler

Responsibilities:

• Create Data model for the OLTP application.
• Migrating foundation Data using Stored Procedures and SQL.
• Defining rules for standardizing the business data
• Define process to ensure the data quality and implement validation framework
• Work to front end developers optimize data retrieval performance by tuning SQL
• Report customer usage patterns from the Log files.

Environment: Data Modeling, Data Migration, OLTP application, SQL tuning, Oracle, MySql, data quality.