SUMMARY

• Highly Experience in leading Data Warehouse Projects including Platform Migrations, SOA Models, Data Modeling, Big Data Architecture, design through implementation of large/complex data ware house/ integration projects for various Clients
• Highly Experienced in handling end - to-end implementation of Data ware House projects including defining the scope, planning, requirement gathering, blueprint creation, roadmap and Architecture.
• Very good noledge and understanding of Hadoop Architecture and Hadoop Ecosystems HDFS, Hive, Sqoop, HCatalog, OoZie, Spark and Impala
• Implemented large-scale DW projects for Prudential Insurance, UK, Zurich North America, Confidential, Nationwide Insurance, T-Mobile and Frontier Communications.
• Hands on Experience in Project Management.
• Highly experienced in handling onshore and offshore Teams.
• Excellent problem solving skills wif strong technical background and good interpersonal and communication skills.
• Expert noledge and hands-on experience wif ETL Tools like Informatica, SSIS, and Data Stage.
• Hands on Experience using Data Modeling tools like Erwin, ER Studio, Power Designer, Oracle Data Modeler and other modeling tools.
• Demonstrate ability to lead multiple projects of varying degrees of complexity.
• Hands on experience in Data Modeling Physical and Logical Data Modeling.
• Expert in designing solutions for multiple largescale projects EDM, Enterprise Data Warehouse, Data Marts and Relational Database wif a good understanding of cluster and parallelarchitectureas well as high-scale and distributed RDBMS
• Hands on experience wif Teradata 14.0,Netezza Appliance, Oracle 12x, SQL Server 2014, DB2 10.1.
• Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies and Meta data management
• Hands on Experience in Designing star schema, Snow Flake Schema and other dimensional data models

TECHNICAL SKILLS:

RDBMS: Teradata14.10,Oracle 12.x and lower versions (SQL, PL/SQL, Stored Procedures),, DB2 10.1, Netezza (Appliance), SQL Server 12.0

ETL Tools: Informatica Power Center 10.1.1 HF1, B2B 10.1.1 HF2, Informatica DIH 10.1.1 HF1 and lower versions, Power Exchange, MDM-XU-DB2. Informatica Data Quality 9.5.1 Hotfix 4,SSIS, Data Stage

Operating Systems: UNIX (Sun Solaris, HP Unix, LINUX), Windows NT/98/95, WIN 2000

Data Modeling: CA Erwin 9.1/7.3/4.1/4.0/3.5.5, ER/studio 9.1.1, Visio and Oracle Designer

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Cobol and C

Other Tools: Query Man 5.0,Toad 9.5,AQT, Cognos 8,Teradata SQL Assist

Functional Areas: Insurance, Finance, Banking, Healthcare, Retail and Telecomm

Hadoop & Ecosystems: HDFS, Hive, OoZie, Impala, Sqoop and Spark

PROFESSIONAL EXPERIENCE

Sr.Enterprise/Integration Architect

Confidential, Baton Rogue, LA

Responsibilities include:

• Led Cloud fitness strategy and performed several POC’s including use case identification, conceptual architectures, 3- 5 year TCO’s and product evaluations for both AWS and Azure
• Solution Architecture Blueprint Preparation for Core Foundation including server Architecture, capacity, error handling, security, Claim Status, Payments, Enrollment and Eligibility Web services etc.
• Responsible for Designing and Development of Data Acquisition and Information Delivery to support enterprise data warehouse and other downstream systems.
• Designing the strategic architecture and the road map for current and future systems to build the next generation Data Warehouse.
• Led POC and Product Evaluation for Data Strategy, Data Excellence program dat is aimed to optimize Teradata and establish future state using DataLake for data consumption.
• Creation and Implementation of Logical, Physical Data Models
• Source to Target Mappings creation for ETL Development.
• Define the data governance, security & access and back up & recovery strategy.
• Implementation of Information security controls for mapping, protecting, and auditing access to stored data
• Creation of Data marts for downstream applications for reporting needs.

Technologies Used: ERWin 9.1, Teradata 14.1, Informatica 10.1.1 HF1, Teradata SQL Assist. Informatica B2B10.1.1 HF1, Informatica BDM 10.1.1 HF1, Informatica DIH 10.1.1 HF2, FACETS, Unix, Business Objects.

Sr. Data Warehouse Architect

Confidential, Richardson, TX

Responsibilities include:

• Source system analysis, Data Quality analysis
• Understand and define the requirements post discussions wif the business/Subject matter experts (SMEs) for the EDW
• Interact wif Business users and project stakeholders and translate the requirements into functional and tan technical specifications
• Data Profiling.
• Source to Target Mapping Document Preparation
• Work wif Subject Matter Experts (SMEs) to come up wif a Conceptual and Logical data model dat considers all the features required for the current functional requirements.
• Implementation of Information security controls for mapping, protecting, and auditing access to stored data
• Creation of Logical, Physical data Model, Source to Target Mapping
• ETL Development.
• Implementation of Physical Data Model into Teradata database and make sure all the default values, UPI,PI and Indexes and comments are created.

Technologies Used: Teradata 14.1, Informatica 9.6.1HF2, UNIX, ERWin 9.1, SQL Developer, Teradata SQL Assist. Informatica Data Quality 9.5 Hotfix 4,DB2 10.1, Informatica Power Exchange for CDC data, Informatica BDM 10.1.1

Sr. Solution Architect

Confidential, Seattle, WA

Responsibilities include:

• Source system analysis, Data Quality analysis
• Understand and define the requirements post discussions wif the business/Subject matter experts (SMEs) for the EDW
• Interact wif Business users and project stakeholders and translate the requirements into functional and tan technical specifications
• Data Profiling.
• Source to Target Mapping Document Preparation
• Work wif Subject Matter Experts (SMEs) to come up wif a Conceptual and Logical data model dat considers all the features required for the current functional requirements.
• Converting the logical data model into physical data models and make the required changes as part of physical data model
• Implementation of Physical Data Model into Teradata database and make sure all the default values, AK’s, PK’s and Indexes and comments are created.

Technologies Used: ER/Studio Data Architect, Informatica 9.5.1,Oracle 11.6,Teradata 13.0,Unix, HDFS, Informatica BDM, Kofka, Python.

Sr. Architect

Confidential, Chicago, IL

Responsibilities include:

• Data Profiling.
• Data Migration strategy
• Solution Architecture for technology enhancement.
• Performance Tuning.
• Onsite and offshore Coordination
• Offshore team mentoring,

Technologies Used: Informatica 9.0.1,Oracle 11.6,Netezza TF24,Unix, Erwin, ginity Workbench for Netezza

Lead Data Architect

Confidential, Buffalo, NY

Responsibilities include:

• Source system analysis, Data Quality analysis
• Gather Business requirements
• Design a dimensional model using Dimensional Modeling techniques
• LDM,PDM and S2TM Preparation
• Works closely wif the user community, technical staff and team members to develop reporting and analysis specifications
• Create the ETL Design document
• Assists the Systems Architecture and DBA teams in developing approaches to maintaining optimized Data Warehouse solutions, including strategies for aggregation and other derived structures
• Works closely wif Reporting/Analysis teams to educate end-users on the proper usage of Data Marts
• Provide input and recommendations on design/technical issues to project manager/senior managers

Technologies Used: Informatica 9.0.1,Oracle 11.6, TOAD for Oracle 11.6,Unix,Power Designer

Sr. Architect

Confidential, Boise, ID

Responsibilities include:

• Source system analysis, Data Quality analysis
• Gather Business requirements
• Design a dimensional model using Dimensional Modeling techniques
• LDM,PDM and S2TM Preparation
• Works closely wif the user community, technical staff and team members to develop reporting and analysis specifications
• Create the ETL Design document
• Assists the Systems Architecture and DBA teams in developing approaches to maintaining optimized Data Warehouse solutions, including strategies for aggregation and other derived structures

Technologies Used:Informatica 9.0.1,Oracle 11.6,SQL Server, TOAD 4.7, Unix, SAP Client,DB2, Informatica Power Exchange.

Lead Architect

Confidential, Los Angeles, CA

Responsibilities include:

• Defining Scope, Planning and Estimation.
• High Level Design Preparation
• Technical solution and mentoring the team.
• Delivery and Implementation.
• Traceability from Business Requirements to the System Requirements.

Technologies Used: Informatica 9.0.1,DB2,TOAD 4.7,Unix,Teradata 13x

Lead Data Warehouse Architect

Confidential, Schaumburg, IL

Responsibilities include:

• Source system analysis, Data Quality analysis
• Defining Scope, Planning and Estimation.
• Creation Logical, Physical Data Model, Source to Target Mapping
• Creation of Data Marts for Downstream Application for reporting needs
• ETL Development.
• Technical solution and mentoring the team.
• Delivery and Implementation.
• Work wif Offshore and Onsite Tech Leads, Sr. Developers and mentor them.

Technologies Used: Informatica 8.6.1, Netezza, AQT, Unix, Erwin, DB2,Autosys

Sr. Solution Architect

Confidential, Columbus, OH

Responsibilities include:

• Defining Scope, Planning and Estimation.
• Defining Technical Architecture
• High Level Design Preparation
• Technical solution and mentoring the team.
• Delivery and Implementation.
• Traceability from Business Requirements to the System Requirements.

Technologies Used: Informatica 8.6.1,Teradata,Teradata SQL Assist, Unix

Sr. EDW Architect

Confidential

Responsibilities include:

• Source system analysis, Data Quality analysis
• High Level Design Preparation
• Low Level Design Preparation
• Mapping Development.
• Test case Preparation
• System testing, Regression testing and UAT Support.
• Performance Tuning.
• Traceability from Business Requirements to the System Requirements.