Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

ANUP NARKHEDE

Kitchener,ON

Summary

Dynamic and results-driven Sr Solution Architect with over 19 years of experience developing innovative and effective IT solutions. Expertise in designing and implementing complex systems that drive business growth and enhance operational efficiency. Proven track record in leading cross-functional teams to deliver scalable data architectures, with a focus on innovation and strategic data utilization. Expertise in Data Architecture, Stakeholder Management, Cloud Computing, and Data Analysis. Seeking a challenging role where I can utilize my skills to drive success and deliver value to clients.

Overview

19
19
years of professional experience

Work History

Sr Solution Architect

Verisk Analytics
11.2017 - Current
  • Orchestrated comprehensive migration of existing system to AWS Cloud, significantly enhancing scalability and performance
  • Conceptualized and executed ETL data pipeline for on-premises PnC data warehouse, streamlining data integration and accessibility
  • Innovated and deployed statistical reporting and analytics solution, deriving actionable insights from PnC Data Warehouse
  • As Solution Architect, meticulously evaluated spectrum of cloud technologies to craft robust cloud migration strategy
  • Engineered seamless end-to-end system workflow, accommodating over 5 million transactions monthly with continuous influx of new data
  • Pioneered development efforts to transform architectural designs into operational reality
  • Developed and implemented bespoke DWH reporting solution, catering to client-specific data analysis needs
  • Formulated strategic data management approach, aligning data mappings with intricate business requirements
  • Facilitated cross-functional meetings with stakeholders to delineate, refine, and document precise requirements and specifications
  • Authored and instituted standardized templates, processes, and best practices, guiding team towards operational excellence
  • Managed geographically dispersed team, delegating tasks and fostering culture of continuous learning and development
  • Regularly mentored and educated team members in both business and technical domains, ensuring high levels of engagement and productivity.

Associate Manager (BI Development Lead)

Duck Creek Technologies / Accenture Services LLP
07.2015 - 11.2017
  • Conceptualized, developed, and implemented Operational Data Store (ODS) model for PnC insurance claim system
  • Designed entire Financial Data Mart process from inception to completion, ensuring comprehensive data solution
  • Directed comprehensive ETL development project using SQL Server Integration Services (SSIS), overseeing data migration from diverse sources to data warehouse
  • This included implementation of business rules, data cleansing, and application of numerous transformations
  • Employed both snowflake and star schema methodologies to optimize data structure and retrieval
  • Crafted specialized data marts using SQL Server Analysis Services (SSAS) tabular models to meet unique client reporting needs
  • Developed reporting solutions with SQL Server Reporting Services (SSRS), ensuring alignment with client requirements
  • Leveraged Power BI and Data Analysis Expressions (DAX) to design and implement advanced visualizations atop SSAS tabular models
  • Architected and instituted robust framework for logging and error handling, bolstering system reliability
  • Created templates, patterns, and processes to facilitate development of reusable objects, enhancing team efficiency.

Systems Specialist (Team Lead)

Accenture Services Pvt. Ltd.
07.2007 - 07.2015
  • Worked as Data Architect to design PnC insurance relational data model (Losses, policy & party)
  • Leveraged SSIS to design complete ETL pipeline for data migration between different servers
  • Lead development efforts to achieve successful implementation
  • Designed and developed various tools to improve automation process which intern contributed towards significant increase in performance with fewer efforts
  • Designed and implemented Database Change Request System to streamline various client & stakeholder requests
  • Developed various complex T-SQL scripts and Store-procs to achieve distinct objectives
  • Used ERwin data modeler to design and maintain data models for various PnC operational components
  • Created maintenance plan which included database backup schedules, index maintenance and reporting
  • Designed functional and technical documents.

Software Engineer

Pictureal Pvt. Ltd
08.2005 - 07.2007
  • Worked on ASP.Net to develop various websites
  • Worked on image rendering to create dynamic faces for web adds for Super Bowl commercials
  • Involved in Data Modeling, Physical and Logical design of database
  • Participated in requirement gathering discussions
  • Created various database objects as tables, indexes, constraints, triggers and procedures.

Education

Bachelor's - Computer Engineering

Mumbai

Skills

  • Data Architecture
  • Data Warehousing
  • Strategic planning
  • Client relationship building
  • Technical expertise
  • Strong leadership
  • Multitasking Skills
  • Problem-solving skills
  • Data Integration Strategies

Languages

English
Hindi

Timeline

Sr Solution Architect

Verisk Analytics
11.2017 - Current

Associate Manager (BI Development Lead)

Duck Creek Technologies / Accenture Services LLP
07.2015 - 11.2017

Systems Specialist (Team Lead)

Accenture Services Pvt. Ltd.
07.2007 - 07.2015

Software Engineer

Pictureal Pvt. Ltd
08.2005 - 07.2007

Bachelor's - Computer Engineering

Mumbai

Similar Profiles

CREATE PROFILE
ANUP NARKHEDE