SUMMARY:

• Highly motivated professional with more than 11+ years of experience of DW Sr. Principal Architect, Solution Delivery, Technical Project Management expertise on Business Intelligence (BI), Data Warehouse (DW) and Data Marts(DM), Master data Management (MDM), Data Integration and ETL process, Data Profiling(IDQ), OLTP,ODS,OLAP design.
• Experience with Teradata Solutions, BI Dashboards, Informatica power Center ETL Framework, Agile Scrum project management methodologies.
• Execute 600+ M Data Information, BI Reporting, Dashboard projects "end to end" from planning to delivery.
• Worked with Veritas/Symantec business owners to collect, gather new or enhancements requirements and designed data warehouse "Star", "Snowflake" Schema model on Teradata, Oracle, Informatica (ETL/ELT ),Data Quality, MDM.
• Done "Proof of concept" for new initiative, technologies platforms like Oracle could integration with Data warehouse, Customer Registry/Master (MDM) - Evaluate different MDM product, publish kick-off meeting with business and purchased MDM product & execute, stabilized in Production.
• Build Semantic layer on DWH for high performance for Reporting / Dashboard layer Lead DW/BI applications enchantments on Finance, Booking, Order subject area in Data warehouse within-budget on schedule.
• Developed complex Informatica Mapping SCD type 1/2/3, Incremental & History data load Developed BTEQ/MLOAD/FLOAD/TPT on Teradata to improve the daily load performance.
• Provided near real time 10-Mins ELT design to incremental data refresh for CIO / CEO Management Booking Dashboards so that executive team can gauge global Order/revenue number effectively.
• Worked on various projects, determine necessary steps to execute and present realistic timelines to business /users.
• Worked on Hadoop /Cassandra "NO SQL Database'' Proof of concepts.
• Build Data Lake on Hadoop (HDFC, Hive, Sqoop) with behavioral, sentimental product "unstructured" data and provide the data discovery access to Data Science Team for "Product feedback" tagging analysis and Sales Team to Perform "Cross-Sell/Up-Sell" opportunities.

TECHNICAL SKILLS:

Data warehousing: Dimensional Modeling Star, Snowflake, Fact Table, Dimension Table, Slowly Changing Dimension, Metrics, KPIs, OLAP (Worked on Both Kimball and Inmon Approach).

Domain Expertise: Manufacturing, Management Booking, Financial Analysis, OIC Analysis, Sales & Renewal Analysis, Product & Appliance Analysis, Discount Analysis, and Customer Analytics).

Languages: C++, VC++, SQL, T-SQL, PL/SQL, XML, XSLT.

ETL Tools: Informatica Power Center 5x 6x 7x, 8x, 9x, Informatica Data Quality, Oracle Data Integration.

Informatica Cloud: SAP, ORACLE, SFCD integration

Big Data: Hadoop Architecture, HDFS, Hive, MapReduce, Scoop

Application Server: WebLogic 6.0, 6.1 SP3, 8.1. Data Modeling

Tool: Erwin

Databases: Teradata V2r5, V2r6, v2r12, v2r13, v2r14, Oracle 8.x/9.x/10g, SQL Server 2000

Project Management: MS Office Suite, MS Project, MS Visio 2003

Reporting, Analytical Tool: Business Objects, OBIEE, QickView.

Master Data Management Products: Informatica MDM 9.x.

PROFESSIONAL EXPERIENCE:

DW Sr. Principal Architect

Confidential, Mountain View, CA

• Conducted knowledge sharing sessions with business stake owners per to capture "Lessons Learned" and streamlined MDM, BI Applications & Report, Dashboard improvements and enhancements.
• Well versed with Agile methodology, participated in sprint meeting as BI Solution / ETL Architect.
• Engaged with key SME to collect information on DW Subject area, processes and craft the first blue print of functional requirements.
• Analyzed key aspects of the business to evaluate the factors driving results and summarized results into presentations.
• Worked with Data modelers to come up with physical data model, provided the logical/physical relationship of each entities, finalize mapping docs for the development.
• Managed and mentored team to deliver multiple projects like (Master Data Management, BI Applications i.e. managed booking, product & appliance) Analyzed issues with ongoing projects, recommended action and implemented the same to streamline the delivery process and improve the quality of deliverable.
• Prepared EDW/BI transformation road-map (with recommended EDW landscape) and later collaborated with local lead in proposal/follow up and engaged customer to start preparatory work for BI Re-engineering.

DW / ETL Architect

Confidential, Scotts Valley, CA

• Participated in DW/ETL Architecture solution approach & introduced a reusable feature in model, defining & designing data dictionaries, and participated in the creation of the metadata repositories as well.
• Developed ETL data mapping, transformation definitions, as well as validating model performance using SQL, and, at the same time have very high exposure and degree of interaction with the business community.

BI Teradata Application Lead

Confidential, CA

• Conducted meetings and discussion sessions with different Apple stake owners for planned projects & Echancements - Prepared business requirement & functional specification, got signoff by super business users.
• Re-designed many business critical application like BuySell, SMART, PDCA application architecture & successfully cleared the history backlog of data 10+ billion of records into production, complete application able to customize data load based on the number of files receiving from sources to GBI - EDW.
• Worked on Buy & Sell Project Reporting.
• Designed real time interfaces for 10/min refresh from SAP /ODS to EDW-used advance feature of Teradata-Utilities FLOAD/MLOAD & Pushdown feature of Informatica.
• Created technical specification document for data source translation. Defined data mapping between data sources for ETL-Informatica.

BI Application Developer / Lead

Confidential

• Requirement gathering and research and gap analysis on source and target systems. Understood the complete upstream data flow for the existing data model. Analyzed the impact of migration of existing application to NCR Tera-data V2R13.
• Analyzed Functional Specification and converted to Technical Specification, designed for enhancements to the lower level apps.
• Developed ETL Specifications & ETL Design Documents & Developed ETL map-pings for loading data into different layers.
• Provided new approaches to the development, Unit & System Testing & Support User Acceptance testing phase. Prepared Unit-Test Cases and Audits for data validation.
• Took sign-off from 3rd party testing team for the developed code and de-ployed into the production.
• Supported application in production for first few weeks and handed over support /KT/issue track doc to L3 support team.
• Updated project status to the PM including Risks & Mitigation, accommodated any feature/change requests from the client.