Highly motivated professional with more than 11 years of experience of Solution Architect, Solution Delivery, Technical Project Management expertise on Business Intelligence (BI), Data Warehouse (DW) and Data Marts, Master data Management (MDM) , Data Integration and ETL process, OLAP design. Experience with Teradata Solutions, BI Dashboards, Informatica ETL Framework, Agile Scrum project management methodologies.
Project # 1 Big Data Project on Symantec Cloud Platform Engineering : Currently working on customer analytics project which involve preparing Data Lake with behavioral, sentimental for symantec product data which will fulfill marketing business needs.
Overall objective is to know who our customers really are,predict buyer trends , their feedback on each products and exceed in below marketing goals: 1.Product feedback tagging analysis.
2.Perform cross-sell/up-sell opportunities.
Project Flow - The raw data is coming from various sources and dumped directly into Hadoop file system through Sqoop (data extracting tool used to extract data from RDBMS (Oracle, Db2, Teradata, etc.)).
Then, data is processed (like un-normalization, partitioning, bucketing, etc.) using hive queries and is updated (using customized and optimized queries) into hive so that ad-hoc queries can be run to get any form of data.
Project # 2 Master Data Management : Worked on Informatica MDM , H/W procurement , S/W installation of application servers.
Integrated with Middleware i.e Tibco , Informatica Data Quality , Informatica Power Center.
Developed Mappings which perform De duplicate , Match & Merge , prepared/build Trust Rules.
Informatica IDQ : Developed Interfaces / web services to clean customer data on realtime.
Data Enrichment - Integrated customer data with D&B data for cross & up sell on MDM customer registry.
Data warehousing: Dimensional
Modeling Star, Snowflake, Fact Table,
Dimension Table, Slowly Changing
Dimension, Metrics, KPIs, OLAP (
Worked on Both Kimball and Inmon
Project Management: MS Office Suite,
MS Project, MS Visio 2003Reporting
Analytical Tool: Business Objects XI
Business Objects, OBIEE , QickView.
Master Data Management Products:
Informatica MDM 9.x.
Technical Solution ManagerMar 2013 to Current Symantec Corporation － 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 Lead / ETL ArchitectSep 2012 to Mar 2013 Seagate Technology LLC － Scotts Valley, CA
Participated in 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.
Supported all pre-data modeling activities, 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.
Involved with most aspects of design, development, delivery, maintenance, optimization and expansion of Data Warehouse/ Data Marts projects.
Operated with development team, had exposure to the entire development lifecycle, and performed tasks that will cross the functional and technical aspects of the project.
BI Teradata Application LeadJan 2010 to Sep 2012 Apple Inc － Cupertino, United States, 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 LeadJan 2009 to Dec 2009 Dell Inc － Round Rock, TX
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.
BI Application DeveloperJun 2005 to Jan 2009 Cisco Systems － San Jose, CA
Cisco has Enterprise Data Warehouse (EDW) developed in 18 + Terabyte Oracle, which stores the historical and operational data of all the measures like bookings, revenue, expense, of Cisco Systems, Inc.
but as the data increases the performance of the data warehouse decreases so now CISCO wants to migrate the database from ORACLE to NCR- Teradata which has the capability to handle large amount of data.
As part of development Team, I participated in all type of role like Logical and physical data-modeling, Developing incremental , historical ETL data loads for critical application like Cisco Booking.