SEARCH

Sr. Technology Solutions Lead - BI, Analytics Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
SR. TECHNOLOGY SOLUTIONS LEAD - BI, ANALYTICS
Professional Summary

Experienced and enthusiastic Business Intelligence Architect with over 20 years of experience in Data Warehousing, Machine Learning and Software Development. Proven ability to build company-wide creative solutions through collaboration, attention to detail, and goal orientation. Looking for an opportunity with the Confidence that my strong educational and wide-ranging industry experience will bring a value addition to the company.

Highlights
  • Architected complex data warehouse implementations involving CRM, marketing campaign, TV ratings, ERP, social media data.
  • Enforced industry standards & best practices throughout.
  • Expertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation).
  • Proficient with ETL, SQL Server Integration Services (SSIS), SQL server & other databases, Microsoft Visual Studio, data warehouses, data marts, machine learning (ML) & analytics.
  • Collaborating with stakeholders & business users.
  • Experienced in conducting interviews, building & mentoring teams.
  • In-Depth working knowledge of programming, writing complex SQLs and building data models.
  • Strong understanding of SCDs, Star & snowflake designs, dimensional modeling, Relational databases.
Work History
Sr. Technology Solutions Lead - BI, Analytics , 12/2018 to CurrentCompany Name, City, State
  • Architected & developed marketing campaign activity (CRM) warehouse and data mart that ingested data from various sources like SAP Hana database, raw CSV files with millions of records.
  • Proposed & created an auto-validation, reporting workflow system using Alteryx designer tool.
  • Designed an ML based predictive model that predicted partner revenue for over 1000+ executives a month ahead. Performed statistical analysis, data wrangling, model building, Visualization.
  • Executed change management and release management processes based on business needs.
  • Collaborated with the Qlik team to design seamless, accurate data ingestion for KPIs presentation.
  • Involved with stakeholders & users in understanding requirements, resolving performance issues.
Technlogy Manager - Business Intelligence, 03/2014 to 12/2018Company Name, City, State
  • Founding member of BI & data analytics department of the company. Involved in building several systems from ground-up, evaluated tools, created POCs, helped define team goals.
  • Architected and built dimensional data models to cater Cognos reports, Tableau visualizations, ad-hoc reports, Google Analytics, Heatmaps, KPI dashboards.
  • Identified, conceptualized, and developed several machine learning predictive & prescriptive models to predict TV show viewership, increase audience, improve viewer engagement.
  • Key member of the company-wide digital campaign that involved ingesting millions of records in near real-time data from AWS cloud. Designed & developed the multi-threaded solution.
  • Introduced, architected and developed data warehouse solutions for social media data consumed from Facebook, Twitter, Youtube, Instagram, etc. to feed statistical, ML models.
  • Designed solution to ingest US consumer profile & behavioral data from Experian and Acxiom of over 300M records. Built data marts, classification models to enhance TV viewership.
  • Mentored the off-shore team, documented & presented product ideas to the executive team.
Architect - Technology Solutions, 12/2007 to 02/2014Company Name, City, State
  • Architected & led re-writing of complex SQL/Informatica workflow based BI project in IBM Netezza, which involved complete development cycle of Analysis, Modeling, ETL & reports.
  • Played a key role in creating minute-level TV ratings warehouse and data mart. Staged the raw data varying format and source like CSV, Excel, JSON and web scraped.
  • Involved in creating Data Cleansing, standardization tasks & developed many MDM strategies.
  • Involved in developing a service oriented architecture (SOA) capital project to integrate various systems (sales, broadcast, research) using IBM Websphere. Developed HTTP, Database, flat-file adapters to enable data, message transfer among disparate systems.
  • Reviewed and recommended improvements to existing system architectures and implementations.
  • Architected an ETL workflow developed using SSIS, C# and SQL server tools to ingest overnight TV ratings data that required fast, accurate numbers viewed by executives.
  • Conducted interviews, reviewed code, built POCs & wire diagrams throughout projects.
  • Lead developer, architect of the application framework and methodology upon which many WPF, Silverlight based desktop applications were built across the department.
Sr. Software Developer, System Architect, 05/1999 to 11/2007Company Name, City, State
  • Key member of the data warehouse team that built a custom ERP solution.
  • Single-handedly devised and developed a data replication solution that helped the company to provide faster and redundant data access.
  • Developed a high-performance SQL translator tool using C#, String builder & multi-threading.
  • Handled various responsibilities of coding, work allocation, offshore and on-site work coordination, and extensive client interaction.
  • Created ER diagram for the complex Custom Product Configurator (CPC) data.
  • Lead developer, coordinator for an enterprise scale VB6->.Net migration. Involved in analyzing the existing VB6 app and re-designing, refactoring through the Object-Oriented design, UML.
Education
Master of Science, Computer Science & Engineering
SUNY At Buffalo - City, State
Bachelor of Science, Computer Science & Engineering
SJCIT, Bangalore University - City
Core Skills
  • Data warehousing, Relational DBs
  • ETL, SSIS, SQL, Stored Procs
  • Data Analytics, Machine Learning
  • Dimensional & ER Modeling
  • Alteryx, SPSS, Watson Analytics
  • Strong leadership abilities
  • Enterprise Architecture, Cubes
  • Tableau, Power BI, Cognos
  • Statistics, Predictive modeling
  • C#, Microsoft.Net, Python, VB.Net
  • Technical writing & presentation
  • Social Media, Google Analytics, AWS
Certifications
  • Microsoft Certified Technology Specialist (MCTS)
  • Alteryx Certified Core Designer
  • IBM certified SPSS Designer.
Accomplishments
  • Increased the company's customer base by 20% in-turn bringing additional revenue.
  • Enhanced customer awareness and engagement on company's social media thereby widening the company's footprints.
  • Introduced machine learning based predictive solutions.
  • Provided a cost-effective enterprise solution by re-writing a complex, expensive Informatica workflow based DW solution in SQL/SSIS.
  • Build predictive models to predict TV viewership a month in advance.
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • SUNY At Buffalo
  • SJCIT, Bangalore University

Job Titles Held:

  • Sr. Technology Solutions Lead - BI, Analytics
  • Technlogy Manager - Business Intelligence
  • Architect - Technology Solutions
  • Sr. Software Developer, System Architect

Degrees

  • Master of Science , Computer Science & Engineering
    Bachelor of Science , Computer Science & Engineering

Similar Resumes

View All
Sr.-Technology-Solutions-Lead---BI,-Analytics-resume-sample

Sr. Technology Solutions Lead - BI, Analytics

Edison, New Jersey