SUMMARY

• 10+ years of IT experience in business program management, Business Intelligence Development, ETL Architect, Data warehouse design in marketing, technology, retail and online advertising fields to take data driven decisions, customer segmentation, risk analysis, Web analytics, leveraging analytics and statistical modeling project management, project design, development and deployment, data integration and migration, data warehousing, data ETL, database design and development, data strategy and roadmap development, data quality assurance, application development, data modeling, administrate SQL servers, cross sell/up Sell modeling, churn modeling, customer segmentation, Predictive modeling, Click stream analysis, next logical purchase analysis

TECHNICAL SKILLS

• SQL Server
• SSRS
• SSAS
• SSIS and ETL processes
• Tableau
• R
• Azure ML
• Azure Data Factory
• Confidential Excel/Excel Services and SharePoint
• MS Access
• C#
• Hadoop/Hive
• Object Oriented Design and UML
• MS Project
• Visio
• Excel
• PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Sr. BI Developer/Architect/BPM

Responsibilities:

• Working as part of the Marketing Data team to define the Next Generation enterprise data platform in order to support the company's strong internal data growth and requirement for flexible business practices.
• Responsible for end - to-end vendors and client engagement management, right from requirement gathering to solutions delivery.
• Interact with cross functional business leaders in implementing statistical models and interactive tools to help sales and marketing teams prioritize their customers and develop processes to acquire data ongoing from various input points
• Implement data analysis techniques and generate meaningful insights from the data Identifying opportunities
• Planning and transitioning analytics into a global delivery model through interaction with offshore support teams
• Analyze customer and operational data and produce analytical predictive models which are accurate and can be relied on to a high level of confidence
• Developing strategic initiatives to enhance the data in order to improve marketing campaign effectiveness.
• Defining predictive analytic models design process to improve effectiveness of campaign targeting.
• Acting as a consultant to campaign managers to explain insights from predictive analytics.
• Providing strategic recommendations on how best to expand the Marketing Insights function within the Global Marketing group.
• Design prioritization framework to score proposed initiatives against Business Strategy and Customer Satisfaction impact.
• Work with business partners, project leads and architects to gather, analyze business Analytics requirements and translate them into technical tasks.
• Managed creation and enhancements of customer data self-serve data sets leveraged by sales and marketing programs teams
• Proven experience in building Data Warehouses in SQL Server to perform queries in both relational database and massive unstructured/structured streams of data in Confidential big data environment
• Work closely with Data Scientists to design and maintain data streams for analytic purposes
• Work closely with Platform team, data source providers for data knowledge, data quality issue reporting
• Lead identification, selection, verification and cleansing of internal and external data process and ensure that all relevant data is gathered, recorded correctly and stored in such a way that analysis can be done in the simplest and most time efficient manner
• Proven ability to build relationships with business partners to understand data needs in order to execute with excellence on documented user requirements and prototypes
• Manage Operations and development team and ensure that all identified gaps in information are filled
• Developed analytics platform on cloud to scale analytics and evangelize it across new/potential customers
• Built meta data driven reports so to eliminate manual report building and hosting process and deployed it successfully.
• Built relationships with business partners to understand data needs in order to execute with excellence on documented user requirements and prototypes
• Built robust analytics publisher to support model publishing with APIs that can be used across SMIT to make models scores available on Global Marketing Execution Database(GMED), which is externally managed data platform that enables centralized campaign targeting/execution of the Worldwide Marketing universe.
• Implemented analytical process to refresh model portfolio and data infrastructure to achieve great operational efficiency, automated analytics model refresh process.
• Implemented Analytics Explorer to facilitate analytics model reports search on Analytics Portal.
• Led the design and development, enhancement and refresh process of Partner Account Targeting (PAT) tool using 2000+ data mining models crunching data and turning data into business insights and shares cross-sell/upsell/upgrade propensity.
• Built earlier version on Hadoop on premises using Isotope and later successfully migrated the content and process into Azure HDInsight to process Digital models
• Built Meta data driven reporting platform that can saves time and resources for the GMO Analytics.
• Led migration of analytics modeling platform from on premises SSAS to cloud based Azure ML and ADF.
• Determines marketing data structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
• Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
• Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.

Confidential, Bellevue, WA

ETL Architect

Responsibilities:

• Consultant on Design, development and deployment of Best Practice Campaign management system
• Designed Business intelligent system to consolidate variety of data sources to come up with dashboard to be used by Marketing audiences in the company
• Follow industry best practices, design and develop new ETL processes to support various BI/Analytics reporting and application used by marketing audiences.

Confidential, Redmond, WA

Sr. BI Developer

Responsibilities:

• Create Executive and detailed BI reports based up on client’s requests.
• Defining business requirements into technical spec,
• Define and develop business intelligence solutions, create KPI data to identify trend analysis.
• Manage recurring reporting requests and project deliverables, including ad-hoc reporting requests.
• Create score card systems and dashboard using SSRS and SharePoint to display live data and trends.