SUMMARY:

• 11+ years of experience in Business Intelligence & Data Warehousing
• Responsible for driving the delivery solutions and cross functional business processes to optimize data integration capabilities for Cisco projects, providing solutions and architectural guidelines for various functions in Confidential data warehouse.
• Extensive experience in business analysis, data architecture, requirement analysis, system analysis, system design, data analysis, implementation and maintenance of data warehouse projects
• Proven track record in planning, building, and managing successful large - scale data warehouse (40+ terabytes size) and decision support systems
• Proven record of accomplishing and delivering complex but stable solutions while managing relationships, risks, innovation, quality and costs.
• Worked extensively on various modules for Logical and Physical data modeling implementations
• Hands-on-Experience in preparing High-Level & Low-Level Design specs, Source system analysis, Performance tuning, System Integration, Unit Test Cases, Deployment docs etc.
• Strong domain knowledge on business functions including XaaS(Software as a Service), Bookings, Sales and Finance and hierarchy data(Sales, Time, Product, Supervisor hierarchies)
• Currently working in big data environment and responsible to coordinate teams and architect cross functional dataflow in Hadoop, Teradata, Hana and Oracle platforms
• Good understanding in writing UNIX shell scripting
• Expert in technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export, Tpump, TPT)
• Have worked as data architect for NRT implementation project in Confidential Enterprise warehouse
• An enthusiastic and project-oriented team leader with solid communication and leadership skills, self-driven and the ability to develop creative solutions for challenging client needs

TECHNICAL SKILLS:

Operating Systems: Windows, Unix, Linux

RDBMS: Teradata v15, Oracle, HANA

ETL: Informatica

Reporting Tools: OBIEE, Tableau, BO

DW Domain Knowledge: XaaS, Bookings, Sales, Finance, Expense (GL, AP, PO) and Hierarchy data

Languages: Hiveql, SQL, PL/SQL, Unix Shell Scripting

Other Tools & Utilities: $Universe (Job schedulingzSA tool), Serena PVCS Version Management tool, Kintana - HP Project and Portfolio Management.

PROFESSIONAL EXPERIENCE:

Confidential, Milpitas, CA

Senior Data Integration and Solutions Lead

Responsibilities:

• Implementation of Enterprise XaaS for Bookings, Revenue in Enterprise warehouse for various monetization models on cloud SaaS including perpetual(own upfront), Subscribe(Prepaid term or SaaS) and Utility(pay as you go models)
• Architected solution for Hadoop datalake and integration implementation to transform business logic needed for application consumption
• SME for Confidential XaaS data, interacting with cross functional team including finance, sales, customer partners etc and providing inputs to data modelers for conceptual, logical and physical implementation.

Confidential, Milpitas, CA

Technical Lead

Responsibilities:

• Implemented a complex solution to bring all the financial measures into balance scorecard and enabled reporting for Confidential key performance indicators with data volume of 300 million
• End to End analysis of Business functions for Cisco’s financial measures: Bookings, Revenue, Plan, forecast, commit and HR data.
• Ensured report rendering for all OBIEE dashboard queries to be within 30 CPU to meet 3 seconds SLA on landing page and 10 seconds on detail page
• Wrote shell script with embedded BTEQs to manage automated data pull from Oracle to capture data changes
• Responsible for managing the entire Onsite team and to ensure timely delivery of all capacities needed by reporting application team
• Coordinated end to end data integration delivery with SMEs, Architects and modelers
• Agile process implementation and Data Lab(SandBox) development for various modules
• Handled cross functional team communication for the various impact analysis done during this tenure
• Made strong business case to migrate the application to TDPROD from Sandbox env which helped reduction in manual efforts by 40%, SLA time reduced 60%

Confidential, Milpitas, CA

Project Lead

Responsibilities:

• Implemented net change logic for bookings measure table with data volume in excess of 177 million records
• Redesigned the Sales Hierarchy module in Enterprise warehouse to ensure Confidential drive toward one sales hierarchy
• Performance tuned all the ETLs to be under 1000 CPU seconds to run in critical CORP refresh window
• Organized LDM and PDM sessions for all the entities under this project
• Managed and coordinated design and build activities for Phoenix Sales Territories and booking measures
• Worked relentlessly for the reversal in the architecture direction to reduce the cost/effort/time for Cisco in maintaining business layers instead of Enterprise warehouse
• Managed DRIVE initiative in parallel, worked with DI leads on the assessment of the ETLs for Fast track conversion and assisted in the planning of this change