SUMMARY:

• Experience leading, managing, architecting, designing, building and implementing enterprise technical solutions.
• 7+ years of experience designing and implementing clickstream/ Web Analytics solutions
• Analytical, Results Focused solution delivery with extensive technical exposure to managing large databases.
• Established best practices for Data Management of a major DataWarehousing project implementation
• Planned and implemented high availability disaster recovery schemes, integrated system evaluations, technology assessments, quality assurance/ performance testing and software/ hardware configuration scenarios.
• Implemented Systems & tools to support Data Management, Business Intelligence, Data Quality Metrics and IT Metrics that helped senior management in their decision making.
• Collaborated and partnered with cross - organizational teams to promote highly optimized quality solutions and setting long term strategic direction.

STRENGTHS:

• Data warehouse Analysis and Architecture
• Data Management & Support
• Data Conversion for CRM, Billing & Legacy Systems.
• Data Services System & Tools
• Functional & Technical Analysis
• Software Development Manager
• Custom Application Development
• Technology Implementation
• Solution Architect
• Production Operations Mgmt
• Software Developer
• Application Metrics
• Data Metrics

KEY INDUSTRY EXPERIENCE:

Clickstream: Adobe Analytics, WebTrends

Data Science: Python, Azure ML

Datawarehouse: Teradata, Snowflake

Databases: Vertica, Oracle, Ingres, SQL-Server

Business Intelligence: PowerBI, Business Objects, Cognos, SSAS

Application Development Tools: Rational ClearCase, SQL Navigator, Erwin, Visio

ETL: Informatica, SSIS

Tools: AgileCraft (JIRA Align), JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Scientist/ Architect

Responsibilities:

• Responsible for designing data mapping strategies for online, retail and customer care activities of a customer to generate a holistic view of customer.
• Instrumental in clickstream DataWarehouse migration from Teradata to Snowflake Responsible for creation and implementation of data model for Snowflake
• Acted as a liaison between business and technology teams to provide architectural and design direction using Agile methodologies.
• Involved in discussion with enterprise datawarehouse team to generate feeds for corporate dashboards ensuring data synchronization with multiple data sources.
• Designed and calendarized A/B and multivariate test strategies to measure effectiveness of a digital campaign, feature, product or offering
• Created a predictive model to forecast customers click-through rates on promotions using Python. This helped in improving Sales by 15% by appropriate targeting of promotions.
• Used clustering based anomaly detection to identify outliers for online traffic volumes. Provide insight and analysis of KPIs using trends analysis, fall-out and traffic reports leveraging Adobe Analytics.
• Built a propensity model to recognize high-end customers for call centers to direct customers to special concierge services
• Built a churn model to identify high-risk customers using Python
• Was actively involed in major effort to convert analytics platform from Webtrends to Adobe Analytics. This required ensuring the data consistency and accuracy between the two.

Confidential

Sr. Data Architect

Responsibilities:

• Captured business requirements during the planning sessions with clients, business analysts and team members.
• Created Bubble chart and BUS matrix for requirements and design of the Data mart.
• Help designed and deployed a CRM Online Compensation reporting Data mart
• Responsible for completion of functional & technical design and obtaining business approval
• Contributed to creating datamart design, establishing data standards and architecture of the data flow from source to the datamart.
• Used multiple systems as sources for Datamart creation including MSSales.
• Performed gap analysis between UI features and reporting requirements.
• Captured reporting requirements from the client. Reports were delivered using SSRS, SSAS and SharePoint Silverlight plug-in.
• Participated in development, testing effort and deployment of the pilot deliverable and subsequent Change Requests.
• Worked on various phases of SDLC for Business Intelligence e.g. inception, elaboration, construction and transition and provided weekly status for cross team impact and visibility.
• Currently working on understanding the impact of a new source system and hence design & implement changes to the existing datamart.

Confidential

Data Warehouse Architect

Responsibilities:

• Delivered a Network Utilization Data Mart for Network Services Team
• Managed sponsors’ expectations and escalations.
• Led brainstorming sessions with the key stakeholders to understand requirements. Used the Kimball Dimension Modeling methodology for analysis, design, delivered Bubble chart and BUS matrix.
• Responsible for completion of functional & technical design and obtaining business approval
• Gathered reporting requirements from the end users and contributed to creation of OLAP cubes using SQL-Server Analysis Services (SSAS)
• Reviewed all change requests for completeness and accuracy
• Identified and defined a frame work for capturing critical Data Quality Metrics. Extensively used ClickStream Methodology and Analyzed the data to understand the Confidential Network usage all over the world. This enabled the Networking services to deploy optimum load balancing techniques and re-define the Network data flow to cater to high noise locations.

Confidential

Technical Project Manager

Responsibilities:

• Managed 5 environments including production, Development and Testing which include a total of 29 servers with Oracle 11i databases and 7 source applications
• Created Project Plans for environment refresh and partnered with SA/ Oracle DBA and storage teams to ensure Synchronization of all applications
• Created and managed the storage requirements for the servers.
• Interfaced with the development and Analyst teams for cross-functional project tasks and participated in the code review sessions with the Development team
• Created standards and established guidelines for project deliverables
• Ensured timely delivery of the mock releases that happened every two week. Reviewed results of the Integration test before every mock release.
• Provided production operations support for all the environments
• Coordinated with the Source(Siebel) and Target (Amdocs) teams for upstream-downstream data flows
• Provided Project Status updates to the PMO team.

Confidential

Sr. Data Warehouse Analyst

Responsibilities:

• Worked as a Lead Data Warehouse Analyst. Developed an understanding of the architecture, specifications, issues/ problems. Contributed to the completion of technical design, development, testing effort and deployment of the pilot deliverable.
• Established an Operational Data Store (ODS) 4 TB in size, defined and developed solution to support loading of data from critical production systems into ODS for cross system analysis. The ODS further provided data to various Datamarts cross system production data to a number of teams for critical analysis and reporting using Business Objects
• Understood deployment of Data changes for major ODS Releases and post deployment support. This required working with cross-organizational teams, managing dependencies and priorities to meet quality and schedule constraints.
• Contributed to creating detailed work break down and This involved interacting with various teams, vendors and various systems.
• Established a good network with the key players in Application support, Database Support and Production support, worked collaboratively and developed the trust with production operation teams.
• Identified and defined a frame work for capturing critical Data Quality Metrics. This enabled the business to get a better understanding of the overall data quality and helped prioritize production changes.
• Provided strategic architectural approach for data from Legacy Billing Systems to ODS and the Data marts. This involved working with source system teams to provide direction on strategy, functional, systems and infrastructure.

Confidential

Data Architect

Responsibilities:

• Proposed High Level Architecture and process flows enabling the strategic technical direction for the implementation of the project.
• Responsible for defining source data formats, data transfer, data scrubbing and data load strategies.
• Provided Static & ad-hoc Reports, dashboard and score cards functionality over web for reporting and analysis Customer Call Patterns. This functionality provided visibility to CTI application Quality, helped management take timely decisions and helped root cause analysis.
• Owned the development and production environments and provided post deployment support.
• Provided support for critical reporting needs for Senior IT Management.
• Identified tool requirements, defined strategy for tool evaluations and evaluated third-party tools.
• Performed full system development life cycle for Business Intelligence solution implementation using Informatica and Cognos as the 3rd party tools.
• Mentored and coached the developers and analysts on tools and technology.
• Managed daily incidents and escalations including bugs, hot fixes, work items and change requests.
• Managed software and hardware installation in Data Center and integration into the support processes.
• Managed transitioning the production operations to Data Center Operations.

Confidential, Redmond, WA

Data Architect/ Database Administrator

Responsibilities:

• Implemented CTI Reporting Data Mart (600 GB) that provided Business Intelligence for Customer call patterns.
• Responsible for providing hardware/ software requirements for the datamart and Web interface including database sizing and tool selection.
• Identified Metrics for measuring end to end transaction response for customer experience on the IVRs to analyze application performance, availability and scalability.
• Saved Millions of dollars for Confidential & Confidential by redesigning the Customer Treatment Service database and hence, enhancing the usage of the IVRs by the customer resulting in increased customer satisfaction and maintaining market advantage.
• Increased productivity of the application by providing the ability to do end-to-end transaction tracking.
• Responsible for designing backup and recovery strategies including setting up the databases in Hot standby mode.
• Responsible for setting up simulation environment for Y2K testing of CTI applications.
• Developed and gathered Business and System requirements.
• Designed a dimensional model using Star schema methodology.
• Provided Reports and OLAP over web for reporting and analysis.
• Managed issues, escalations and provided details on the issue to the management.
• Responsible for transitioning the production operation to Data Center Operations.