SUMMARY

• 16+ years of IT experience in Architecting, Modeling and Managing client(s) with deep expertize in technology across all phases of SDLC.
• Proven ability to manage, design, architect, lead and mentor teams across various domains and technologies
• 10+ years of experience in managing projects/programs with >5M in size and leading teams through all phases of project lifecycle development, delivering analytics and BI solutions for teh business users across enterprise
• Partner with business teams, key project stakeholders to identify and prioritize projects and scope within projects (Resource planning, Budget, Forecast and Tracking) which helps measuring organization performance through KPIs, CTQs, Operational Metrics and Reporting
• Experience in developing strategies and initiatives for data integration architecture at teh enterprise level and defining Enterprise Architecture & Strategy for Big Data, Data Warehouse, Master/Reference Data and Data Integration.
• Hands - on experience in creating teh Confidential, Retail and Financial Services Specific Data Models
• Created several DWH and Data Mart from teh ground up, created conceptual, logical and physical models along with processes and define enterprise standards and swim lanes
• Modeled DataStax Cassandra data model for Customer 360, Personalization to enable users for faster access to teh Restful API’s call and mobile apps
• Hands-on experience in rewriting teh code using Apache Spark on Cassandra to enhance and to simplify data ingestion process and to replace teh existing load into HDFS (Pig, Map Reduce)
• Hands-on experience in creating customized algorithms for Personalization, Recommendations, Market basket, Promotion effectiveness and insights into teh data
• Hands-on working experience on dealing with multiple file formats like JSON, AVRO, Parquet and leverage storm/spark/pig scripts to load into NoSQL DB’s like MongoDB, Cassandra
• Experience in managing diverse team of associates across different locations, vendors, contractors and managed client resources, project management and delivery management responsibilities in different project management models (Waterfall & Agile) methodologies
• 6+ years of hands-on experience in providing and working in various consulting engagements on process improvement, operational effectiveness, Process definition, architecture assessments (Current Vs. To-Be), POC’s and POV’s for Retail, Confidential and Financial services
• 6+ years of experience in defining vision, continuous improvements to teh environment, Automation and process improvements by defining/raising teh bar, manage deliver efficiencies and achieve Break-through goals (Operational Excellence)
• 8+ years as an Enterprise and solution Architect, worked with different clients & domains helped me to gain extensive experience in design, development, delivery and operations of teh Enterprise Data Warehouse and Big data environments
• Architectural and In-depth noledge of RDBMS and Columnar Databases like MS SQL, Azure SQL DB, Azure SQL DW and ADLS (Azure DataLake Store)

TECHNICAL SKILLS

Bigdata Ecosystem & Languages: HDFS, MapReduce, Spark, Pig, PL/SQL, Python, Scala

Data Modeling ToolsErw;in 3.5/4.0/7.1 and ER Studio 9.1.1:

DWH (ETL & BI): Informatica, DataStage, BO, MicroStrategy, Tableau, PowerBI

Scheduling Tools: Autosys 4.5, Control-M, Oozie

Microsoft Tools: MS Project, Microsoft Office Suite, Share Point

RDBMS & NoSQL Databases: Oracle, SQL Server, Cassandra, MongoDB, Teradata, HBASE

DB & Admin Tools: Datastax OPS Center, Cloud Manager/OPS Manager

Other Tools: JiRA, Remedy, Confluence, MS Visio and MS Project

Distributions & Architecture: Cloudera, Lambda, AWS(trained), Azure

PROFESSIONAL EXPERIENCE

Confidential, Boston

Big Data / Microsoft Azure Cloud Solutions Architect

Responsibilities:

• Validate assumptions, Roadmap definition, timelines and implement Solution Architecture
• Work with client directors on teh solution effectiveness, planning, SOW and agreed deliverables
• Build new Power BI reports and leverage Microsoft Azure Cloud to publish and pin
• Work with business users on teh technology road map, create personas, RACI and lead teh discussions on signoff

Confidential, Irving

Big Data / Cloud Architect & Program Manager

Responsibilities:

• Responsible for managing teh Marketing systems and teh entire BI team at a major fashion Confidential . As a BI Program manager and Architect, involved in identifying teh technology stack, approach for solving teh business problems by partnering with Users and IT teams
• Responsible for driving and overseeing teh overall project, managing risks, mitigation plan, frequent updates to teh C level and business users, act as a liaison between IT team and stakeholders
• Work with multiple vendors on teh open environmental issues, address performance issues on teh mobile apps by analyzing teh environment (Mobile->Jetty->Kafka->HDFS->Storm->C*)
• Hands-on development experience using Spark on Cassandra for loading teh data into cluster
• Executed proof-of-concept (POC) using Big data technologies in teh lower environments
• Work on overall architecture assessment on teh technology stack, adaptability of teh open source systems and define to-be state architecture and future Roadmap by consolidating or rationalizing teh ecosystem

Confidential

Sr. Technology Architect / Program Manager

Responsibilities:

• Responsible for managing 40+ team size, including development, enhancement and support teams and managed teh various projects
• Steering ETL and Data architecture design and review processes, including planning and monitoring efforts, reviewing deliverables and communicating with stakeholders
• Identify ways to optimize, standardize and rationalize activities across teh enterprise, lowering cost, improving quality and value of data assets
• Advocate on behalf of Enterprise Architecture group, to define process, implement technical data governance information architecture to IT, corporate and business executives as well as other key stakeholders

Confidential, Chicago, IL

Sr. Technology Architect

Responsibilities:

• Responsible for providing architectural solutions, defining Data warehouse standards and define teh road map and strategy in teh global definition of architecture principles, policies, and industry best practices.
• Perform Architecture assessment of teh current Data Warehouse(ETL/BI) and provide new technological direction and implement SOA based solutions

Confidential

Sr. Project Manager & Technology Architect

Responsibilities:

• Responsible for architecting, managing Mortgage DW Development, BAU and L3 support team
• Responsible for providing solutions enterprise-wide such as Finance, Mortgage, Compliance (SOX) and Risk with effective and efficient technology solutions and ongoing support
• Define roadmap to implement data governance and created artifacts and documents for areas Meta Data, Data Modeling and Data Quality and PII. Created teh Swim lanes, RACI and Best practices for Mortgage and Auto division of Financial Services
• Worked as an Enterprise data architect / Divisional Data Modeler for Auto Finance division and responsible for creating and maintaining metadata using ERWIN, upgrades and creating Data Dictionary, Swim lanes, process docs and best practices documents and socializing it across different business users for approvals and signoff’s

Confidential, Plano, TX

EDW Sr. Architect & Program Manager for Project Import

Responsibilities:

• Design, Architecture for EDW from scratch and responsible for implementing and automating teh manual process by ingesting / load new data feeds into teh Dimensional Models for better ROI
• Created dimensional data models and loading summarized data into teh data marts using teh Informatica CDC
• Lead, Architect and Implemented month end closing process for Finance team on teh reports and Business Planning and Consolidation of Marketing and Finance application, replacing Excel based consolidations and portfolio analysis by region.

Confidential, Plano, TX

Project Manager & Architect (BIDOPS)

Responsibilities:

• Worked as an Architect and led teh team of Analysts and developers to fix teh performance, code and data related tickets
• Responsible for managing BIDOPS, L3 Support team and also worked as a Data Architect
• Responsible for Planning, Validation, Signoff and deployment activities for multiple conversion and upgrade projects
• Hands-on on teh Change management, estimation, development/modification to code, testing and implementation

Confidential, Philadelphia, PA

Data Architect & Modeler

Responsibilities:

• Worked as Data Architect and created new PBM datamart and new data model for teh enterprise, by leveraging teh existing tools (ERWIN)
• Reverse engineered teh model to address teh design gaps in teh environment involving teh SME/business users and baked their inputs into teh final model
• Defined Aggregates, lookup, Facts, Factless facts tables and denormalized facts are defined to address best query performance when business users are querying data from Datamart
• Defined data model to created tables to address teh latency and to enable teh ETL process to meet their SLA’s, along with Audit process