SUMMARY:

• A TOGAF practitioner with 20+ years of global experience in information management, business intelligence, customer analytics, Cloud & Big data analytics comprising strategy, architecture and program/practice management in IT solution consulting / delivery. Sanjeev has effectively managed the s trategic roles in the areas of strategy & roadmap consulting, solution architecture and program delivery management.
• Successfully delivered strategic BI/ DW/ Analytics/ Integration /Cloud (AWS) initiatives covering assessment, strategy & roadmap, solution architecture, integration architecture, data governance & architecture, master data management, data migration, customer analytics, big data analytics & program management to large/strategic programs in the capacity of IM consultant, program manager, portfolio manager, delivery manager & solution architect etc
• In current role as Enterprise Solution Architect (ESA) with Confidential Insurance, Madison, WI (Client), defining strategic information/integration reference architecture & candidate/solution architecture aligned to enterprise architecture direction. Architected BI solution for hybrid and cloud - Amazon Web Services (AWS) deployments. Evaluation (PoC’s) & recommendation of emerging tools & technologies
• Assisted global organizations in defining their future BI architecture by incorporating traditional, virtualize, big data & cloud platform and solutions. Defined Big data strategies and modeled big data analytical use cases / solutions in the area of customer & risk analytics using Hadoop, ecosystem & visualization tools
• Defined data governance, data quality framework, Data integration strategy and process for multiple data centric solutions. Defined solution, Data Architecture and Process for customer domain Master Data Management ( Confidential ) solution &Customer intelligence (campaign management, Cross-sell / up-sell, predictive models) solutions.
• Managed IT Project Portfolio for retention business (loans & card products) with one of the global financial organization (NBFC). Delivered enterprise transformation programs for customers in US, Australia, Europe, South East Asia and India. Managed multimillion dollar enterprise programs / projects with geographically dispersed teams in matrix as well as in project environment.
• Established BI competency center and solution design center of excellence for global financial organization(s). Managed IT Project Portfolio for retention business (loans & card products) with one of the global financial organization (NBFC).
• Outstanding command in project / program management from initiation till closure, Budgeting and planning, scope management, risk analysis to quality management in adherence to CMMI, Six Sigma, ITIL guidelines. Proven ability to build strong relationships at all levels of business and management. Problem solver with a passion for simplifying and streamlining the business processes using technologies transparent to the business

SKILL SUMMARY:

• Delivery / Program / Project management
• Customer relationship management
• Senior management presentations & reporting
• Program / project initiation & planning
• Program budgeting, monitoring & control
• Communications management
• Change management
• Risk and issues management
• Pre-sales/ presentations/ proposals
• Metrics collection and quantitative management
• Solution delivery management
• Information Management
• Business Intelligence / DW
• Big Data, Predictive Analytics and Modeling
• Cloud - Amazon Web Service
• Customer & Risk Intelligence
• Channel and Sentiment Analytics
• Data Management & governance
• Data virtualization
• Master data management
• Marketing automation/ Campaign management
• The Open Group Architecture Framework (TOGAF)
• Big Data (Hadoop)
• Project Management Methodologies (form PMI)
• Structural & Dimensional Data modeling
• SEI/CMM, ISO 9000 & Six Sigma
• Rational Unified Process

TECHNOLOGIES:

Cloud: BI solutions using Amazon web services

Big Data: Hortonworks, Hadoop, HDFS, HIVE, NoSQL, MongoDB, Map Reduce, Functional usage of big data

Data Replication: Oracle Golden Gate, Attunity

ETL / Data Replication: OWB, Informatica, SAS

Data Virtualization: Denodo

Data Visualization: Tableau, Power BI

BI / Reporting: Business Objects, Cognos, SAS EBI

Modeling: Oracle Designer, Erwin, UML, Enterprise architect

Project Management: MS Projects, MS Office

Data bases: Oracle, SQL Server, Greenplum

Programming Languages: SQL, PL/SQL, Java, C, C++ etc.

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Enterprise Solution Architect

Responsibilities:

• Create candidate architecture (CAD) to compare various architectural options, perform SWOT analysis and recommend solution aligned to the strategic information roadmap. Define architecture pattern for data acquisition and integration
• Architected & designed enterprise financial data warehouse using Hybrid cloud architecture (AWS). The overall solution will be implemented in multiple phases. Evaluated various cloud technologies (ex. Informatica Cloud etc.), AWS Services (ex DMS, Aurora etc.) & integration of in premise tools (Business Object, Metacenter, Control M, Infogix etc.) to recommend the technology stack for Hybrid solution.
• Drive data replication strategy aligned to the future Information / BI roadmap. Evaluated various data replication products /solutions available in market like Oracle Golden Gate, IBM CDC, and Attunity Replicate etc. Executed PoC’s to validate across homogeneous and heterogeneous database replication, identified projects / use cases, defined patterns, process &standards to support replication technology rollout within organization.
• Architect solution for integrating Guidewire Policy Center & Guidewire Billing Center applications to existing data warehouse (Oracle, Greenplum) & Hadoop Data Lake (Hortonworks). Perform impact analysis for financial, regulatory and compliance and define architectural solution to ensure the adherence.
• Define solution architecture to support customer retention, product performance, claims & other analytical requirements using MPP database (Greenplum), Reporting (Business Object) & Visualization tool (Tableau)
• Architect Bigdata analytic solution using HDFS, Sqoop, PIG, HIVE, Flume, Map Reduce, Python etc on Hortonworks Data Platform (HDP).
• Define platform architecture & solution architecture for data virtualization tool (Denodo) implementation. Identified projects / use cases, defined pattern, process and standards for larger rollout of the Denodo platform for business and IS.
• Evaluate various emerging Bigdata (Hortonworks) and Cloud technologies (AWS, Azure) for the BI / Analytical solutions. Architected Cloud & Hybrid BI solutions using Amazon Web Service (AWS) platform for deployment.
• Review technical / solution architecture with various technical / management forums.

Confidential

BI/DW Architect

Responsibilities:

• Assessment of existing BI/DW solution capability covering architecture, governance, project delivery & core processes. Define target architecture and roadmap aligned with enterprise strategy.
• Review of various inflight business intelligence project solution architecture to define the integration scope
• Define solution architecture (BI integration) aligned with new Information Management strategy
• Consulted and defined Big data analytical solution strategy and architecture for Customer analytics area

Confidential

Principal Technology Architect (BI/Analytics)

Responsibilities:

• Led BI/Analytics technology & solution consulting for ANZ geography with focus on growing the organization BI footprint in geography as well as bridging gap between sales, delivery & customers.
• Program management & governance to large & strategic BI / DW / Analytics programs. Initiate and define the approach & engagement models for large/strategic IM solution implementations covering detail plan, schedule and effort estimates.
• Strategized roadmap for business intelligence solutions covering BI/DW, Big Data, Data Management, Data Migration, Confidential, Customer insight, Cross-Sell/ Up-Sell, campaign Management, and Predictive Analytics areas
• Reviewed / Analyzed BI architecture and processes to identify the improvement opportunities. Defined target solution architecture / future architecture incorporating Big Data solutions and technologies, aligned with enterprise architecture guideline.
• Elicited functional and software requirements with the help of business and information technology stakeholders. Manage workshops with business and IT teams to define, review and validate requirements and business processes.
• Defined scope, architecture and data architecture for the big data analytical solutions focusing on Customer Insight, Sentiment, Channel & Fraud Analytics using Hadoop, HBase, HIVE, PIG, MongoDB, NoSQL modeling and Visualization tools. Augmented existing analytical marts data models to in corporate the big data analytics.
• Performed Impact assessment & data analysis for the existing applications and processes, Defined / customized and documented the conceptual, logical and physical data model for solutions using Entity relationship and Dimensional modeling technique. Review of data processes and data models with various technology forums for socialization and approval.
• Work with team project managers and team leads for explanation of functional flow, solution design & Data models. Involved in resolving technical issues faced by the team and suggest the optimization and tuning opportunities.
• Program and architecture review with various technology and management forums within customer and internal organization. Point of contact for the solution architecture and design decisions. Take responsibility for ensuring the integrity and quality of systems through overseeing the testing process
• Risk assessment & remediation strategy for bank’s EIM environment
• Strategy & management of multiple DW environment consolidation program for Bank.
• Establish a solution design CoE to uplift EIM team capabilities for a financial organization.
• Data integration strategy for a transformation program for a bank,
• Strategy and solution for GMO reconciliation & reporting program for an institutional Bank
• Assessment & roadmap for technology migration for treasury applications
• Customer insight for a leading insurance organization
• Confidential strategy and approach for insurance organization
• Technical solutions for channel, sentiment and fraud analytics using Big data technologies and more

Confidential

Senior Manager

Responsibilities:

• Manage IT project portfolio of Loans & Card products marketing / retention business. The portfolio includes Confidential, Data warehouse, Reporting, Customer Intelligence solutions and integration to CRM, LMS and other upstream and downstream applications.
• Established BO Center of excellence for India operation and consolidated analytical & operational reporting into one platform.
• Strategized the integrated IT solutions of single customer view across all product line. This played a key role in organization transformation from product to customer focus (CTrans). The solution also enables business with S2S capability.
• Responsible for driving BI programs with the help of multiple vendors, business units, project teams and various cross-functional resources. Also responsible for budgeting, planning & monitoring, risk, resource / vendor management and delivery
• Designed and implemented Customer intelligence solutions (Campaign management, Cross sell/up-sell & retention) and predictive models (Risk & attrition) for retention business of GECW (Loans) & SBI cards.
• Managed design and enhancement of Confidential, enterprise-wide data warehouse, data marts & ETL Architecture (OWB & PL/SQL), Data modeling for reporting (Business Object, MSBI) and analytical solutions
• Solution consulting (DWH / BI & analytical CRM) to US and other geography teams on retention strategies, alignment with global CoE’s and implementation of analytical solutions within organization.
• Audit & review of the project artifacts & solution to ensure organization quality process (aligned to six sigma) adherence within projects
• Collaboration with Senior Management, Vendors, project managers and delivering presentations to various management layers for status, Kick-off, strategies, alignment etc.,

Confidential

Consultant / Project Manager

Responsibilities:

• Instrumental in one of the largest SAS banking solution (BIS) implementation in India from conceptualization till the implementation.
• Responsible for the delivery of BI and analytical solution implantation from planning till closure. Define initial and detail schedule and estimations for the projects.
• Performed Impact / readiness assessment, defined strategy & roadmap for the implementation of BI solutions with the help of IT and business teams. Analysis and redefinition of existing technology landscape and business process.
• Implemented Data Quality, Single customer view & Confidential / Confidential (Customer Domain) solution for multiple financial organizations. Managed implementation of Credit Risk solution for one of the South East Asia based credit cards company
• Consulted and implemented SAS banking solution (BIS) Logical & Physical data model (Detail data Store & Presentation / Analytical data Models), Customer Intelligence (Cross sell, Upsell, Retention, Campaign management, segmentation etc) & Risk intelligence (Risk & propensity models) solutions for one of the largest private bank in India.
• Coordination with business and IT users for understanding & defining the program scope and high level requirements. Perform System analysis and define detail user requirement. Data analysis to validate the requirements and design
• Audit and review of the implementation of software quality process within projects aligned to customer quality standards, SAS quality & project management process
• Engaged in technical presales, proposal, client presentations, solution architecture definitions & program estimations