PROFILE:

Senior Data Architect with 16 years of hands on experience across Data Warehousing, Data Analytics and Consumer Insights, Modeling, Application Database Designing. A self motivated problem solver with demonstrated record of identifying out of box solution. Client recognized for effective communication and interpersonal skills. Proactive professional with acquired knowledge of Big data seeking to work either in a team or independently to deliver desired results.

PROFESSIONAL SUMMARY:

• Delivery experience with Financial Services, Banking, Credit Card Services, Auto Insurance, Life Insurance, Transportation, DMV, Broadcasting business.
• Data Warehousing: Successfully lead Data Warehousing Projects at fortune 500 companies.
• Relational Data Modeling: Successful delivery of Conceptual, Logical and Physical Data Models for Complex Relational Data base Design.
• Broadcasting - South Africa Broadcasting Air Time Sale and Asset Management. Transportation - PA DMV application, Confidential Fleet Services and KTMB Ticketing
• Dimensional Data Modeling: Star and Snowflake Modeling experience.
• Data Architecture: Delivered Enterprise Application Architecture for group of AIG applications to represent different views using Zachman Architecture.
• Architecting ETL solution for Data Warehouse, Building Dimensional Model and Mapping for Type 1, 2 and 3 Dimensions.
• Business Requirement: Worked with BA and BSA in JAD sessions of requirement gathering, creating wireframes and models to articulate clearly the scope of work.
• Data Analytics: Architected Consumer Insights Solutions at Lincoln to understand consumer psychographic, financial behavioral for cross sell retention and 360 degree view of consumer.
• Management and development of an enterprise tailored taxonomy. Categorized internal and external data collections and ensure users find the information they need with speed and precision.
• Experience on Meta data definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation and data quality.
• Architected flexible and scalable solutions with vision of current and future need of enterprise business with performance tuning considerations.
• Demonstrated application of Six Sigma for Process improvement.
• Experienced in delivering under Waterfall and Agile project management methodologies
• Provide guidance and work leadership to team members.
• Work with senior management, technical and client teams in order to determine data requirements, data security and best practices for advance data manipulation, storage and analysis strategies in a data warehouse environment.

TECHNICAL SKILLS:

Data Architecture & Design

Data Warehousing

Data Modeling

Database Design

Data Integration

Data Quality

Data Profiling

Data Analysis

Data Analytics

Master Data Management

Meta Data Management

Consumer Insights

Predictive Analysis

Business Intelligence

Enterprise Data Management

Data Governance

TOGAF

ZACHMAN Framework

Ralph Kimball Methodology

Relational Modeling

Dimensional Modeling

(Star and Snowflake)

Erwin (8Yr)

Toad Data Modeler (2yr)

MS Visio

SQL Developer Modeler

Relational Software Architect

SQL Server 2008, 2012 (2yr)

Oracle 11g (10yr)

DB2 (6mth)

Ingres (2yr)

Informatica (3yr)

Appworx, Autosys, SOS-Berlin, Control-M, Crontab

SQL & TSQL (15yr)

PL/SQL (10yr)

UNIX (Sun Solaris, HP) (6yr)

LINUX (2yr)

Windows

Tableau

SAP Lumira

Microstrategy

Management Skills

Methodologies

Project Management

Release Management

Configuration Management

Quality Assurance

Waterfall

Agile

MS Project

Excel

TFS

VSS

Sharepoint

OTHER KNOWLEDGE:

Big Data Analytics Hadoop

Six Sigma and Quality Assurance Methodologies

PMP and Agile methodology of Project Management

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Architect

Responsibilities:

• Architected Broker Dealer Warehouse to integrate the data from heterogeneous sources DST, DTCC, NSF, Pershing, Albridge and Caesar and sending homogeneous data to SUNGARD PROSURV application for FINRA compliance reporting and NFS for Streetscape Application.
• Architected Integration Solution of LFD warehouse (LFGD) with NICE wholesaler commission calculation system involving Dimensional Modeling, SOS-Berlin Scheduler, UNIX scripting, Extracts and SQL performance tuning.
• Designed and delivered a generic framework to generate delta extracts for LFGD and NICE integration.
• Architected ETL solution to Support BI need of Consumer Insights using Informatica, SQL Server and Tableau.
• Architected Solution to Integrate Consumer Data from multiple Line of Business and linking it with Merkle and KBMG data for consumer demographic, psychographic and financial profiling for Consumer Insight Data Analytics, visualizations, reports and predictive analysis.
• Delivered Mastering Consumer data by identifying parties across Line of Business based on multiple parameters and degree of identification confidence level.

Confidential

Sr. Data Architect and Modeler

Responsibilities:

• Modeled PAR application for tracking Credit Card Industry compliance with Government regulations.
• Designed Dimensional Model for downstream data warehouse to support monthly compliance reporting.
• Implemented ILM Data Retention Security Compliance Solution.
• Designed a flexible and scalable Letter, Email, Fax and SMS notification application to serve wide range of notification requirements without requiring database modifications.
• Delivered Conceptual, Logical and Physical Data Models for Credit Card administration application (CIF) and Dimensional Data Model for downstream Data Warehouse (CDS) in various projects by applying Enterprise Naming Standards.

Confidential

Database Architect

Responsibilities:

• Implemented Enterprise Data Management strategic vision by establishing Naming Standard, Data Models of DRC Policy Admin Application, Data Flow Diagrams, Data Dictionary, Data Lineage, Data Governance processes.
• Architected eSignature application to capture online signing of documents.
• Implemented Sarbanes-Oxley security compliance by identifying and securing PII data.
• Designed Conceptual and Logical Data Model for New Auto Quote Application.
• Architected Data Integration solution of Confidential and Confidential Data warehouses.

Confidential

Database Architect

Responsibilities:

• Designed Conceptual and Logical Data Model for flexibility and scalability so that Model can be easily customized for other US States Department of Transportation services of Driver License and Vehicle Registration.
• Applied Enterprise and AAMVA industry standard for efficient data exchange between agencies.

Confidential

Database Architect and Oracle 9i DBA

Responsibilities:

• Architected and Designed Logical / Physical Data Model for scalable and flexible broadcasting applications to manage Content Scheduling and Air Time Sale (CSS) and Media Asset Management (MAM).
• Database Administration of CSS and MAM application

Confidential, Weston, FL

Software Consultant

Responsibilities:

• Designed and Developed SDN Change Management Portal and Alerter, using .net and SQL Server for efficient release management of SDN application.
• Release Management of “Service Delivery Platform (SDP)” Application Changes

Confidential, Richmond, VA

Project Leader, Technical Leader, Developer

Responsibilities:

• Spear headed the team for Technical Solution in New Development and Production Support of Complex Issues for its three applications “Oracle Compensation”, “agent database” and “AES” system
• Successfully Reduced the Cost by Reducing Batch cycle time by 20% using Six Sigma Project by applying SQL Performance Tuning, eliminating “re” tasks.
• Managing Geographically distributed Onsite - offshore team.
• Executing project with Disaster Recovery Plan and Backup Contingency Plan rigor for mission critical applications.

Confidential

Team Member, Module Leader

Responsibilities:

• Data Analysis and Application Module’s Interface Design between, Ingres Based Legacy System to Oracle Based Willow system.

Confidential

Team Member, Module Leader

Responsibilities:

• Lead the team through all the phases of development of Change request Enhancements.
• Delivered Production Support and, cost saving solution to eliminate recurring incidents.

OTHER KNOWLEDGE:

• Big Data Analytics Hadoop
• Six Sigma and Quality Assurance Methodologies
• PMP and Agile methodology of Project Management