Sr. Technology Solutions Lead - BI, Analytics Resume Example
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 CurrentKPMG LLP, 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/2018AMC Networks Inc., 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/2014Disney ABC Televison Group, 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/2007Dresser-Rand, 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.
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.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Completeness
- Word choice
- Measurable results
- Strong summary
- Typos
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
