SUMMARY:

• Sixteen years of IT experience in design, develop and administration of data warehouse and business intelligence solutions in different technologies including Microsoft Azure (native & HDInsight), Teradata, SQL Server, Oracle and BigData (Hadoop).
• Data warehouse design and ETL Architecture for large scale data warehouse, database management and reporting solutions. Experience in implementing, ACORD data standard for Insurance clients.
• Extensive experience in working with Agile methodology. Strong knowledge of SDLC including analysis, design, development, maintenance, testing, and design documentation.
• Worked with various stakeholders, senior management, business users, enterprise architects to plan, develop and implement data warehouse strategies for the integration of data from all LOB/upstream systems. Some highlights of my experience are
• Database Design (Conceptual, Logical) and Programming Amazon Redshift, Microsoft Azure, BigData Ecosystem, Oracle PL/SQL, Teradata, ERWin, Power Designer and OLAP on Hadoop using HDInsight (AtScale).
• Hands on experience with MS Azure (USQL, PowerShell, Azure Batch, ADLS, SQLDW, DocumentDB, HDInsight, ARM Templates, ADF), HQL, Spark, Python.
• Extensive experience in Agile methodologies
• Data Modelling (OLTP and Dimensional) and Data Warehousing for various domains including Insurance, Banking & Finance, Healthcare, Energy & Retail.
• Design ETL Architecture to acquire large volume data, transform it and make it usable.
• Business Intelligence implementations to convert data to Information.
• Data Migration and Master Data Management.
• Designing, Developing and Administering Database Systems.

TECHNICAL SKILLS:

Databases: Redshift, HBase, Teradata13, Oracle 9i, 11g, SQL Server 6.5, 7.0, 2000, 2005, 2008&R2, 2012

Languages: VB 6.0, ASP, .NET, PL/SQL, USQL

Scripting Languages: HTML, JavaScript, VBScript, XML

Tools: /Applications Informatica, ERWin, Power Designer, Integration Services, Analysis Services, Visio

Reporting Tools: Crystal Reports, Business Objects, Reporting Services

Environment: Windows, MS Azure (Blob, ADLS, ADLA, ADF, SQL Server, SQL DW)

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

Environment: MS Azure Stack (Blob, ADLS), HDInsight(HQL, Spark, Python), PowerBI.

Responsibilities:

• Design overall architecture work with development team to help them understand new technology and implementation coach.
• Work with Microsoft ADR team to ensure architecture correctness and align with MSFT stack.
• Work with different stake holder to ensure data ingestion to blob storage.
• Work with Data Security team to ensure data security implementation on cloud.
• Automation of entire stack using Visual Studio Online, TeraForm, PowerShell, ADF, ARM templates.

Confidential

Data Architect

Environment: MS Azure Stack (Blob, ADLS, ADLA, ADF, SQL Server, SQL DW), HDInsight and OLAP on Hadoop using AtScale.

Responsibilities:

• Design overall architecture for Confidential Supplier’s to access their daily stock and last 2 year sales history.
• Define data acquisition strategy to cater volume and variety of data formats from internal systems to Azure.
• Design Data model for data to be stored and structured in ADLA, including partitioned strategy.
• Design and develop OLAP on Hadoop solution using AtScale on HDInsight cluster.
• Work with developers to help them understand and work on different technologies on Azure platform including USQL, ADF, Web jobs, Resource Manager etc.

Confidential

Solution Architect

Environment: HIVE, Impala, Spark Stream, Amazon Redshift, EMR, Vertica

Responsibilities:

• Design overall architecture for health analytics product
• Define data acquisition strategy to cater volume and variety of data formats.
• Design the data model to store customer 360 data
• Define process for near real time data ingestion and action.
• Define process for Master Patient & Provider Index (MDM)

Confidential

Information Architect

Environment: Amazon Redshift, EMR, Informatica Cloud, ERWin

Responsibilities:

• Design enterprise data warehouse strategy with enterprise architecture team.
• Create conceptual model for enterprise warehouse.
• Create logical data model for phase1 (sales, marketing) for the warehouse.
• Define ETL(including scaling) strategy for Informatica Cloud
• Work with development to ensure quality deliverables for phase 1.

Confidential

Enterprise Data Architect

Environment: IBM iSeries, DB2, Business Objects, ERWin

Responsibilities:

• Working with Enterprise architects to design ePolicy application for UK business.
• Create conceptual data model for ePolicy application and align it with enterprise roadmap.
• Work with Architects to design, define and implementation plan for data standards (data dictionary MDM etc).

Confidential

Enterprise Data Architect

Environment: BigData Ecosystem, Microsoft SQL Server, MSBI, Integration Services, ERWin, various client ERP systems (SAP, Oracle etc), SpotFire

Responsibilities:

• Working with various Stakeholders to understand Audit processes and different phases and document those.
• Create conceptual model to ensure data consolidations from all different ERP systems into one common model for Auditing.
• Work with Architects to design and define Audit Automation process and architecture.
• Evaluating various options to automate data capture process from different client systems like SAP, ORACLE etc.
• Design data extraction strategies to collect the data from client systems, like SmartExporter to extract data from SAP systems.
• Designed canonical data model to store and perform audit automation
• Evaluate various options to move large volume data from remote client locations to E&Y environment like MoveIT.
• Evaluate options to transform data using automated transformation process ETL tools or BigData / Hadoop for large volume data.

Confidential

Enterprise Data Architect

Environment: Oracle Exadata, ERWin, TOAD

Responsibilities:

• Part of Enterprise data architecture group and driving enterprise data strategies.
• Keep on working for future state data warehouse and data marts.
• Define and design data architecture for application development projects which includes Conceptual Data Model, ETL Design, data retention etc. and related data strategies.
• Working with data modeller to ensure data models for each line of business and application development is align with enterprise roadmap.
• Design data model for critical application and ensure it is aligned with enterprise roadmap
• Working with enterprise architect to ensure all underline projects are going towards enterprise roadmap
• Ensure correct application integration design in PlanningIT and playing role of component architect.

Confidential

Technical Team Lead / Data Modelling / Data Migration / Data Architect

Environment: Teradata, Oracle, SQL Server, Integration Services, Analysis Services, Informatica, Business Objects, Reporting Services, ERWin, Power Designer.

Responsibilities:

• Write detailed functional and technical specifications, provide impact assessments.
• Data modelling, designing strategies, plans, technical, operational architecture for Data ware house.
• Data Warehouse implementation Strategies like Top down vs Bottom up.
• Defining and implementing metadata management structures and processes.
• Prepared Param files, concurrent workflows to automate ETL Informatica process.
• Ensured the production ETL runs within the batch window and improved performance where required.

Confidential

Technical Lead

Environment: SQL Server 2005, ERWin.

Responsibilities:

• Designing and Delivering Database design for OLTP application.
• Review stored procedures created by developers and work with them to optimize wherever required.
• Create Indexes wherever required
• Create database maintenance plan