SUMMARY

• Strategic IT Leader with nearly 15 years of rich and extensive experience spanning across Small, Mid - size and Large-size firms
• Wide Technical experience in designing & implementing Big Data, DW solutions
• Possess extensive on-site exposure of working in the US for 4.5 years and UK for a span of 1 year
• Keen analyst with excellence in understanding and gathering requirements of Clients / Vendors / Consultants & other multiple stakeholders, followed by provisioning through Data Engineering/Business Intelligence Solutions
• Delivered thought leadership in challenging the status quo to enhance the current services and technologies
• AWS Certified Solution Architect: drove digital transformation programs along with creating POC’s
• Demonstrated expertise in design and developing of cyber security Data Lake/Analytics & Reporting, having built information Security, and Business Continuity Management reports by designing & enforcing policies, processes & controls, providing risk assessments dashboards against several compliance standards, managing remediation programs, security awareness programs for employees, leaders, customers & vendors
• Passion of technology and strong exposure on Big Data & DW tools, Business Intelligence, Master Data Management, Data Modeling,, Spark, Kafka, NoSQL, PLSQL, Informatica, Oracle CRM and other Oracle technologies
• Imbibed best practices for Confidential /DW Implementation, delivering Project Proposals & Scoping, engaged in requirement gathering & analysis, establishing a robust roadmap, Solution Architecture along with Data analysis & Profiling, Data Modeling, Security & Configuration and preparing architectural design documents
• A proficient Solution Consultant with a flair for adapting quickly to dynamic business environments and adopting pragmatic approach in improvising on solutions and resolving complex business issues
• Excels in providing Technical Design and Architectural Leadership to multiple teams and projects to help ensure applications are integrated and adhered to stated architectural and design principles & standards
• Spearheaded end-to-end project management activities for leading banks and investment solution clients across the world comprising of project scoping, estimation, planning, risk management, finalization of technical / functional specifications, resource administration and quality management of product application
• Defined standards & guidelines as per global best-practices for Big Data, Cloud, DWH/ Confidential projects that serve as benchmarks for excellent service delivery; expert at completing projects within time deliverables within preset cost parameters
• Played a key role in design / dimensional modeling for multiple Data warehouse project initiatives
• Energetic leader known for skills to envision & create successful outcomes in complex and multi-cultural environment

Core Competencies

• Big Data
• Data Warehousing/Data Lake
• Solution/Technical Architecture
• Global Stakeholder Management
• Pre-sales Support
• Proof of Concept
• AWS Setup & Architecture
• Agile Methodology
• Logical Data Modeling
• Data Visualization
• Business Intelligence Solutions
• IT Roadmap & Governance
• Data Mining & Analytics
• Data Ingestion
• Dashboard & Reporting
• Technical Leadership

TECHNICAL SKILLS

Primary Skill: Hive, Spark (Spark SQL, Spark Streaming), Kafka

Secondary Skill: Cassandra, Spark MLIB, Scala

Beginner Skills: Python, Apache Nifi

AWS Cloud: AWS Big Data Services, AWS Solution Architect Associate Certified

Confidential /DW: PLSQL, Informatica, OBIEE, Confidential Publisher

Others: Peoplesoft ERP JavaScript, Html, Shell Scripting, WebLogic, REST API, Toad, SQL Developer, Putty, WinSCP, Source Safe, FTP, JIRA, Git

Environment: s: Windows, Unix, AWS, Linux

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead/Principal Solution Consultant / Architect

Responsibilities:

• Facilitated key stakeholders to forecast the quality of stock for optimizing gains & bringing clarity
• Analyzed the proposals as well as delivered valuable suggestions pertaining to best technical solutions to migrate the application to AWS
• Engaged in architecture design & review along with designing Cloud Formation template for successful execution
• Rendered services by delivering Infrastructure solutions to a wide range of clients including end-to-end configuration for AWS Big Data
• Working closely with various teams across the company to identify and solve business challenges utilizing large structured, semi-structured, and unstructured data in a distributed processing environment
• Defining and establishing a data governance process to include enterprise data governance and data conformance to govern policies required to ensure data integrity
• Managing data analysis and processing activities involving analyzing, studying and summarizing data for extracting useful information which would assist in strategic planning
• Establishing a process for the use of data architecture frameworks to include business data management, business intelligence, data quality and data usage
• Establishing and reporting Analytics Performance metrics, Service Level Agreements, and Key Performance Indicators
• Working closely with the clients for requirement gathering, business analysis, governing functional and high-level technical requirements and finalizing technical / functional specifications for the project
• Supporting an Agile team with responsibilities varying from creating and demonstrating Proof of Concepts (PoC); developing reference architectures and coding best practices to performing a variety of architecture analyses, and evaluating leading-edge technologies for use in the enterprise
• Ensuring that the project delivery team structure is adequate and enforces compliance, best practices, approach & direction for the technical aspects of the organization's practice; providing technical leadership
• Defining service standards and guidelines that serve as benchmark for excellent service delivery; adhering to set SLAs for all support processes; tracking metrics to measure the effectiveness of the support processes

Environment: AWS EMR, S3, Kafka Connect, Snowflake, Apache NIFI, IAM, AWS, Power Confidential

Confidential

Principal Solution Consultant

Responsibilities:

• Key role in designing & architecting the data model for Phishing campaigns through big data ingestion and data warehousing
• Data Ingestion into HDFS and create HIVE warehouse of simulated phishing emails dataset and analyze to identify employees training requirements using Apache Spark framework, Spark SQL, Pyspark.
• Responsible for unifying Kafka with Spark Streaming for real-time data processing and Spark MiLB for data fragmentation into Category-based, risk-based to perform Advanced Analytics
• Established a robust Machine Learning model to examine key parameters from datasets encompassing Pen test, security patches, certification End of Life, Vendor Findings, Application Findings, and disaster recovery data for applications & products; designed & developed several Confidential Strategy metrics
• Pivotal role in conducting Sentiment Analysis, KNN, Clustering and Linear Regression
• Delivered valuable recommendations on dividing associate into wave clusters, top ranking phishing attacks, computing risk migration between BU s on Tableau and POC reports on Power Confidential

Environment: Hadoop, Hive, Spark (Spark Streaming, Spark MiLB, Spark SQL), Python, Power Confidential, Tableau, Kafka

Confidential

Principal Solution Consultant / Lead Consultant

Responsibilities:

• Extracted the data from warehouse into on premise Data Lake using Hadoop HDFS using Sqoop, spark and delivered the output data into Cassandra and Greenplum for Advanced Analytics
• Overcame challenges of storing & processing voluminous structured/semi-structured data via BD Hadoop Framework
• Successfully implemented
• Hive & Spark for data processing & Flume to transfer log files from multiple sources to HDFS
• Shell commands to develop Spark scripts as per the client needs
• Managed Data Ingestion from Oracle, SQL*Server (SumTotal), Cloud API (Qualys) and adopted & applied transformation rules using configurable business rules data model
• Developed CI/CD pipeline for steering agile implementation
• Functioned as a Subject Matter Expert in Enterprise Cybersecurity Reporting & Analytics

Environment: Hive, Oracle, Sqoop, Spark, Airflow, HBase, Informatica, PLSQL, Oracle

Confidential

Technology Lead / Agile Engineer

Responsibilities:

• Excelled at creating robust design & templates and substantially eased the integration of 28 controls within 3 days of development turnaround for each control into the existing C&M Dashboard by providing
• Significant role in designing conceptual, logical, and physical model of the database
• Bagged Hive Five Award for delivering the most accurate and visible ISO reports in a short span of time
• Key role in ensuring better Data Visualization on 50+ reports through customized OBI Dashboards & Action links
• Delivered consultancy services in saving red status projects go to green; scaled up the Confidential business by enhancing the offshore team by 15+ members
• Led the automation of 30 NIST Controls and 15 board metric measures in just 6 months

Confidential

Technology Lead

Responsibilities:

• Prepared and presented 4 effective POCs on real time analytics, scoping and masking, dynamic hierarchy and alternative writeback
• Played a key role in minimizing the development effort by 90% using advanced XML code tweaking for OBIEE catalog objects
• Hands-on experience in working on informatica transformations along with establishing PLSQL packages with load, Reload and full recon procedures

Environment: PLSQL, Informatica 9, OBIEE 11g, Unix, Oracle 10g, WSDL, Shell Scripting, Web logic, Putty

Confidential

Sr. Software Engineer

Responsibilities:

• Worked on-site at client location in London, UK for a span of 1 year
• Successfully participated in design, development and supporting Confidential RPD, Logical model, dimensional hierarchies, derived measures, initialization blocks, Dashboards & reports, Agents, ETL & DAC Execution plans, Object and row level security and OBI variables

Environment: Informatica 7.8, OBIEE 10g, DAC, SQL Server, Unix

Confidential

Technology Lead

Responsibilities:

• The team is to meet the Advanced Analytics needs of Fidelity by providing on premise central data lake and ELT to suffice different organization needs.
• The contributions encompasses creating data lake and providing simulated phishing hive warehouse, POCs on ML Algorithms and Tableau reports.

Environment: Hadoop, Hive, Spark (Spark Streaming, Spark MiLB, Spark SQL), Python, Power Confidential, Tableau, Kafka

Confidential

Technology Lead

Responsibilities:

• Successfully managed Migration and re-architecting self-service reporting model for business stakeholders using Tableau and migrating to Hive/Spark from Informatica/Oracle & Click Stream project.

Environment: Hive, Oracle, Sqoop, Spark, Airflow, HBase, Informatica, PLSQL, Oracle

Confidential

Lead Consultant

Responsibilities:

• Reporting and Analytic needs of Enterprise Cybersecurity ( Confidential ) and Confidential by providing accurate and timely information.
• Focus areas included key performance indicators, risk controls and program/project/ operational metrics as well as compliance oversight and governance in Cybersecurity domain. Delivered Security Training notification system In order to enhance the security compliance over the organization.

Environment: OBIEE 12c, 11g, Informatica 10, Oracle 12c, SQL Server, Tableau, PLSQL, Java Script, JIRA, PLSQL, Control - M, Java script, java, HTML, XML, Putty, Unix

Confidential

Lead Consultant

Responsibilities:

• Reporting and Analytic needs of Enterprise Cybersecurity ( Confidential ) and Confidential by providing accurate and timely information.
• The focus areas aimed at key performance indicators, risk controls and program/project/ operational metrics and compliance governance across Cybersecurity domain. Facilitated Security Training notification system to increase security compliance over the organization.

Environment: OBIEE 12c, 11g, Informatica 10, Oracle 12c, SQL Server, Tableau, PLSQL, Java Script, JIRA, PLSQL, Control - M, Java script, java, HTML, XML, Putty, Unix.