SUMMARY

• An accomplished result - oriented AWS Solution Architect and Enterprise BI Analyst with about 16 yrs. of demonstrated experience in driving end to end implementation and timely delivery of high revenue projects of worth $1M-3M across domains.
• Predominantly worked on AWS and Azure cloud Projects (Migrating and BI Implementation).
• Having around 10+ years of experience on Big Data/Hadoop ETL components, Spark, Hive, snowflake,JAVA/J2EE, Python, Scala, AWS, DMS, glue, Lambda, ELK, oozie, Kafka, Map Reduce, Pig, Sqoop, PowerBI, Tableau, EMR,AWS and Microsoft Azure .
• Having 7+ years working experience of big data processing pipeline or data engineering software platforms and large-scale data infrastructures.
• 5+ years of data analytics experience in projecting insights related to Supply chain management projecting Customer Sales and invoicing details.
• 3+ Years of Implementation of AWS Data Lake using AWS S3 and Migration of Enterprise Oracle EDW to AWS Redshift (PostgreSQL).
• 4+ years of experience in architecture, design and implementation of On-Prem, Off-Prem and Hybrid Cloud solutions utilizing AWS and Azure
• 6+ years’ experience with DB Migration Databases (MS SQL, Oracle DB, PostgreSQL) to AWS Cloud RDS Solution with Visualization on BI tools (MS Power BI, AWS Quick Sight, OBIEE, Oracle BI Reports).
• 6+ Years Managed ERP Implementation / Rollouts / Upgrade projects, BI Projects on premise and Cloud Based Solutions.
• Experience architecting/operating solutions built on AWS
• Experience migrating or transforming legacy customer solutions to the cloud
• A proven Technology manager with expertise in cross-functional ERP implementations, delivery of high-impact data-driven business analytics integrated solution, product design, cyber security risk reporting, master data management, data cleansing & SOA Integrations.
• Requirements gathering / Solution workshops, driving Sprint planning meetings, prioritizing product backlog & daily stand-ups.
• Design and perform analytics that lead to strategy recommendation and corporate profitability measures.
• Exec reporting based on analyzing trends across a specific area; predicting future trends and their business impacts; identifying potential business opportunities based on analysis and findings.
• Technical Leadership, governance & decision making for development teams and cross-functional collaboration
• Large scale resource Management spanning geographical locations
• Implementation of Versioning tools (CVS/RCS/Perforce/Tortoise SVN and PVCS)
• A passionate coach and corporate trainer for Oracle Application Technical Stack and AWS Cloud.

TECHNICAL SKILLS

AWS Cloud Service: AWS EC2, Storage S3, GLUE ETL, Crawler, RDS Oracle & SQL Server, Server less Lambda, Data Migration Services, Schema Conversion Tool, Redshift (Data warehouse Solution), SQS, AWS Quick sight, Athena, Cloud watch, Cloud trail, Bit bucket, Git hub, Cloud formation Basics and IAAS using Terraform

AZURE Cloud Service: Networks, Sub Net, Firewalls, App Gateway, Load Balancer etc VMs, VM Scale Sets, Azure SQL, SQL MI, Synapse, Azure data Factory (ADF), Data Bricks.

Trained on AZ: 303, DP-200 and AZ-400

ERP Modules: - Functional and Technical

SCM& MFG: OM, Pricing, PO, Receiving, BOM, WIP and Inventory.Oracle Financials (AP/AR/GL) Reporting and Tax ware.

CRM: Service Contracts, Depot Repair and Install Base.

Reporting and Visualization applications: AWS Quick sight, Microsoft Power BI, Tableau, Oracle OBIEE, Oracle Reports. XML/BI Publisher, Discoverer.

Application Development and DB’s: Oracle Forms 6i/10g, OAF/ADF / Oracle 11g / MS SQL/ Postgresql / AWS Athena.

Integration and Transformations: SOA, OSB and BPM - Transformations and AWS Glue ETL

Management Applications: HPPM, JIRA, Service now and Fluid.

Method and Models: Waterfall Model, Agile Scrum, Applications Implementation Methodology (AIM), Six - Sigma Process Knowledge

PROFESSIONAL EXPERIENCE

AWS data Architect

Environment: AWS

Confidential

Responsibilities:

• AWS Lake formation, Snowflake, Glue studio ETL, Crawler, Lambda, SNS, S3, Athena and Cloud watch.
• Assessment of Genomics data.
• Data Modeling and analysis of dependencies.
• Define schemas
• S3 events to trigger the GLUE job using SNS and Lambda.
• Processed data backup using S3.
• Validating schema and Data migration using validation mechanisms.
• Documenting Process and standards.
• Working with testing and reporting team to sort and change the.

AWS Solution Architect and Enterprise BI Analyst

Environment: AWS

Confidential

Responsibilities:

• Assessment of Heterogeneous DW for Compatibility.
• Defining Redshift Standards and Data warehouse Migration Assessment.
• Evaluating Data Modeling and analysis of dependencies.
• Validating schema and Data migration using validation mechanisms.
• Descriptive analyticson Customer invoices and receipts providing the defaults from the customer based on the key performance indicators (KPIs)
• Documenting Process and standards.
• AWS Services Used Schema Conversion tool, Data Migration Service, EC2, Redshift, S3, Infra Using Cloud Formation, Aginity and SQL Workbench to Connect Redshift and Toad to connect to Oracle EDW.

AWS DataLake Implementation Architect

Environment: AWS

Confidential

Responsibilities:

• Project Manager handling BI Data lake implementation on AWS Cloud and On Premises.
• Solution workshops to design Data lake architecture.
• BRD’s to capture Requirements and Visuals.
• Understanding of Cyber Security risk reporting on Estate Management.
• Mitigating risk coordinating with Remediation team focusing on to get number elevated.
• Migration to UAT and PROD, Service Now for Issue Reporting, Enhancement and Access.
• Presented Data analytics for Effective Infra tracking, saving on Licensing cost, risk reduction, Application evaluation for the correctness, Effective Remediation, Infra visibility and Controls reach.
• Using Cloud to reduce Infra procurement cost.

AWS DB Migration Lead - Oracle DB

Environment: Oracle 11g, AWS, EC2 & RDS LINUX, Python, WINDOWS

Confidential

Responsibilities:

• Provided guidance and implemented Oracle 11g database solution in AWS Using EC2 & RDS environments.
• Configured EC2 CentOS database servers for hosting Oracle 11g databases and monitoring software.
• Migrated Oracle11g and MS SQL databases from on-premises to AWS RDS.
• Evaluating Data Modeling and analysis of dependencies.

Database Architect and AWS DB Cloud Migration Assessment

Environment: Oracle DB designing & Data Modeling.

Confidential

Responsibilities:

• Application Database replatforming or Refactoring experience (Commercial to Open Source Engines) handling migrating of premise SQL/Oracle databases to AWS Cloud database .
• AWS services like IAM, S3, Athena, Glue, Data migration services
• Involved in Data Modeling, SQL queries optimization and Performance tuning.
• Extensively involved in Analysis, Design, Development and Testing of Data Models for Major applications.
• DB Migration Assessment.
• Ability to work on multiple high priority tasks, and adjust to changes on priorities & deadlines

Azure Application Migration and BI Lead

Environment: Azure

Confidential

Responsibilities:

• Handling team of 40 members including Architects, Data Engineers, DevOps Engineers/QA Team Members.
• On-Prem Application assessment and Application Migration to Azure Cloud.
• Application assessment, Design and Mapping to target state cloud architecture.
• Demonstrated application of end-to-end architecture strategies, standards, processes, and tools in their solution designs
• Design and implement Data Ingestion from multiple sources to Azure Data Storage services.
• Working on Azure compute services Data Factory, Data Lake Store, and SQL Data warehouse to transform and stage transformed data.

Application Database Architect - Oracle

Environment: Oracle DB & LINUX.

Confidential

Responsibilities:

• Extensively involved in Analysis, Design, Development and Testing of Data Models for Major applications. se cases and Business Rules and involved in the development of Design Document.
• Developed Unit and Integration Test Cases.

Master Data Management and Enterprise Reporting Lead

Environment: Oracle MDM and Oracle ERP.

Confidential

Responsibilities:

• Master data migration and Data Cleansing, Cut over Planning for Production Migration.
• Prepared test cases, for the functional testing in different Environments.

Enterprise Architect

Environment: Multiple Enterprise applications

Confidential

Responsibilities:

• IOMS Product Design, Replacing ERP Order Management attributing 100+ SOA Integrations
• Designing IOMS Architecture - OMNI channel application
• Capability to Tacks Order details till it’s delivered, with Return management capabilities.
• Analytical Solution using EDW OBIEE to show case the Order and Revenue trends.

Environment: Oracle Apps, Forms and Reports, Oracle Database

Confidential

Responsibilities:

• Requirements review, preparing configuration specs and configuring the same
• Detailed Design, developing PL/SQL rules/packages for several customizations, unit testing
• Ownership of Open Enrollment of different end-clients every year. Deep-dive workshops with end-clients for requirements, harmonization.
• Planned and supported multiple Upgrades: Oracle Applications 11i to R12, Oracle Database 9 to 10g.