SHARMA PANDYARAM

adwfrj@r.postjobfree.com

770-***-****

https://www.linkedin.com/in/sharma-pandyaram-3218b71a/

PROFESSIONAL SUMMARY

A Highly Experienced Solution/Technology/Infra Architect with over 17+ years of Technical Excellence and Experience in the Financial, Payment Processing/Banking/CRM/RETAIL/Fashion/AUTO and Fintech Industry segments.

Extensive experience and expertise in Cloud Migration projects needing in-depth knowledge in Architecting and implementing robust solutions enterprise wide, with Implementation of TOGAF AND DEVOPS.

Experienced Postgres DBA with working experience migrating Postgres in an AWS environment.

Experienced in Lambda, S3, DynamoDB, NoSQL, Relational Database Service (RDS), Amazon EMR and Amazon Redshift.

Moving applications from Oracle on premise to AWS Aurora and oracle 19C and Oracle Cloud software.

Configuring Databases Migration Services [DMS] Endpoints Using Aurora.

Experience in working with large teams with emphasis in collaboration on distributed solutions and systems worldwide using snowflake solution.

Solid Experience in Data Governance, Data Science, Business Analytics and Cloud (AWS, Azure & Google Cloud) solutions needed for organizations.

Knowledge of Agile delivery, SDLC, technical architectures, AI/Client processes with data-oriented lifecycles.

In depth understanding of relational and big data platforms, BI and in Cloud data warehousing. Security PCI /CISP policies for data governance, Good understanding of 21 CFR compliance access, and Security and OSI model layers.

Implementation of GDPR &CCPA, SOC1, SOC2, SOC3 across Europe.

Core Competencies include Data architecture, Application architecture, and large-scale data system development experience in conceptualizing, designing and implementing large data & analytics solutions Using GCP platform.

Experience on Migrating various database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse.

Extensive Experience with IaaS, PaaS, VM Migrations, VNet, Traffic Manager, Azure Cloud Services, SQL Azure, Active Directory, Data Factory, Data Lake, HDInsight, ExpressRoute, PowerShell, OMS & Security Center.

Deep understanding of Blockchain Technology cryptocurrencies and underlying working on blockchain technology with multiple bitcoin and its network.

Knowledge in distributed ledger and Hyperledger. Worked on proof of Concept on Ethereum, solidity, smart contracts, multichain, bitcoin mining, cryptocurrency.

Experience in designing a terraform and deploying it in the google cloud platform.

Set up GCP firewall rules to in order to allow or deny traffic.

Worked on SAP SUCCESS FACTOR Software for Onboarding customers and multiple activities. Along with all IAM products of all 7 cloud providers.

Experience in collecting data from different sources of SAP and migrating to Data Lakes. Identify appropriate Public Cloud Platform

Experience in Migrating Oracle, SAP databases from On-Premises to cloud.

Scrum Master for most of the Cloud and Architect Positions.

Involved in various stages of Migrating databases from on-premise to Cassandra and Mongo DB.

Administration of the above databases along with Postgres Databases.

Excellent Knowledge in the Architecture of Cassandra, Mongo DB, and knowledge of CQL.

Experienced in building clusters in both databases including Data Sharding.

Experienced with writing processes including Mem- Tables SSTables and Commit log.

Migration of Data into AWS/Postgres/Aurora.

Used Terraform for automation.

Worked with Kubernetes, and Deploy Lambda using Terraform.

Experienced in Consumer-Packaged Goods (CPG) work with tools like Buzzer for different analyses.

Optimize supplier network, Control costs Forecast demand more accurately, Gain a fuller view of supply chains Management inventory, supplier relationships and risk more effectively.

Implementation with Presidio’s Cloud Migration Framework which includes applications, infrastructure, and data platforms.

Implementation of the sales force in US BANK.

Experience with Snowflake and Oracle.

Experience working with C-level executives and an ability to quickly establish credibility with senior leadership.

TECHNICAL SKILLS

Databases: Oracle RDBMS Releases 10g, 11g, 12, 18C, & 19C, SYBASE 4.2., 4.9.10,12.5, 18/Replication 11, 11.5,12, Exposure to Teradata, Unify, Informix-XPS, Mapper, Accell-4gl Tool, UDB, DB2, POSTGRES, Cassandra, Hadoop, MongoDB, Azure Services, & Dynamo.

Languages/OS/Software: IBM UNIX AIX v5.x/6.x, Red Hat Linux 5.0, Sun Solaris 8/9/10, HP-UX 11, Windows Server 2003-8/NT 4.x/XP/2000, Novell, UNIX Shell Scripting, Transact SQL/PL SQL/Informatica, Erwin/S-Designer – CASE – Database Architecting, Sybase Central/DB Artisan – Database Management, Oracle Enterprise Manager, Navigational Server, Data Stage, Imperva, Point of Recovery by EMC/SRDF, Change Manager, Tivoli, BMC-Patrol, SQL Backtrack, Harvest, Autosys, & Enterprise Manager of (MS – Server).

Database Architect: Physical Database Design, Capacity/Performance Planning, Sybase, Oracle Replication, Oracle Data Warehousing Design, Physical Resource Allocation/Maintenance, Security Definition/Maintenance, Backup/Recovery Planning/RMAN Implementation, Regular Database Maintenance, & Housekeeping/Database Optimization.

Other: Moving Data to cloud AWS, Sales Force, Snowflake, Support Tableau, Maintain/Migrate Data to On-Premises, Maintain Hybrid Cloud Environments, Client SW Connectivity/Related Maintenance/Troubleshooting, Warm Standby Replication Administration/Standby Database/Active/Passive/Data Guard, Replication Design/Administration for Data Mart/Warehouse Applications Using/Sybase/Oracle, Security – Database Auditing/PCI Compliance, Solution Architecture AWS-AZURE-Google, Sybase ASE/11.5/12/Sybase Replication Server 12.1/12.5, HW/OS – Sun Enterprise Systems/Solaris, FESCO DB – ABB, FORD, BP, Oracle (8.1.7.4), Control M, DB2 UDB, Database Maintenance, Replication Administration, Performance Tuning, Writing UNIX Shell Scripts, Testing, Full Development Lifecycle Sybase/Oracle Database Administration, SCHEMA Maintenance, SQL Anywhere, Erwin/S-Designer, NT SYBASE ASA, ORACLE 8, Query Performance Enhancement, Beta Test Centers, NT Platforms, Stored Procedure/Triggers/Logical/Physical Design, Database Tools, System Integration, PL/SQL, TSQL, Global Physical Architectures, Sybase ASE 4.9.2/11.03/11.5.1 Replication 11.03/NCR, Teradata, Informix-XPS/Bank Master, RDBMS Design, CTIX O/S, UNIX/ BTRIEVE, Cloud Computing/Migration, & Proficiency with Go Lang.

PROFESSIONAL EXPERIENCE

AT&T, GA November 2021 – Jan2023

Infra/Data/Cloud Solution Architect

Worked with AT&T on a Software Infrastructure Project which involved the migration of the Product k2 View to the Azure Cloud using Apache Cassandra.

Responsibilities include regular maintenance, overlooking operations on terraforms, and docker management.

Setup JIRA for Project Management, Bug Tracking, Helpdesk Tickets, and integrated JIRA with Bitbucket to track all code changes.

Additional responsibilities included the transformation of existing legacy systems consisting of structured, semi-structured, and unstructured data to be moved into the Azure cloud.

Participated in the design and realization of tools for a DevOps-inspired back end management and monitoring system.

Coordinated with several teams in establishing and applying appropriate branching, Designing and implementing fully automated servers Using DevOps with CI/CD and CM tools like Ansible, chef, Jenkins, Docker, Git & GitHub

The project involved taking care of cloud security and compliance.

Followed Agile Methodologies (Scrum), involved in daily stand-up meetings and used Jira to track the bugs, Git, and GitHub as a source code management tool.

Designed the CI-CD DevOps pipeline, ensure that business solutions met project specifications.

The project involved supporting and implementing existing services and firewalls, load balancers, hypervisors, storage, and identity management.

Hands-on experience in test automation and continuous delivery of web applications, client-server applications, and web services/REST APIs, and SOAP API.

Lead Architect/DBA/AWS/Postgres/Aurora/AZURE/GCP

Configured Docker containers TDM, ADI, and LDAP for testing on non-production and deployed on a production environment using AWS and GCP.

Created Build Jobs and Deployments in Jenkins and Implemented a CD pipeline with Docker, Jenkins, GitHub, Terraform and GCP API's.

Upgraded the Docker container version from 5.x to 6.1.3 and maintained the infrastructure.

Configured the FABRIC automation tool to allow local as well as remote automation and deployments.

Upgrade the FABRIC tool from 6.1 to the 6.1.1 version and modified the config parameters for better performance.

Configured and maintained Apache Kafka & Zookeeper for both real-time and batch data processing and for operational monitoring data.

Maintain application users by implementing security hardening and assigning restricted roles.

Worked with requirement management tools like Jira, Source Control Management using Git

Configured k2view application (K2studio, k2admin, & fabric studio), DVN, and Cassandra on windows servers.

Build VMs/Servers using Azure Cloud: importing volumes, launching VMs, creating security groups, auto-scaling, and load balancers.

Designed and maintained databases using python and developed python-based API (Restful web service) using Django, Alchemy and PostgreSQL.

Master runs the API for the entire cluster, nodes, physical or virtual machines within the cluster

Involved in Continuous Delivery, Continuous Deployment (CI/CD), DevOps toolchain, and DevOps processes for Agile projects.

Experience in IaaS and PaaS in a hybrid cloud environment working with private and public cloud service providers.

Configured monitoring tools like PROMETHEUS, GRAFANA, and NODE_EXPORTER tools on Linux servers.

Involved in the deployment and testing of code in QA/E2E/PERF environment, thereby releasing in production.

Moving data from Postgres to Aurora.

Moving data from Mongo DB.

Architected serverless solutions using AWS Lambda and Amazon API Gateway in event driven patterns to power scalable and secure serverless applications.

The cloud provides advantages of speed and flexibility, minimized costs, performance, and reliability.

AT&T organizations need to continue to run on-premises data centers in response to cloud migration barriers and Azure provides a hybrid cloud strategy that builds bridges between on-premises data centers and the azure cloud to backup and protect on-premises resources/analytics to gain insights on-premise workloads.

Done Poc on data fabric tools like Talend and K2view which is in production.

Work towards Blockchain methodology.

WHARTON BUSINESS SCHOOL November 2020 – November 2021

Infra/EA/DATA Cloud Solution Architect

Worked for a fashion conglomerate association in Barcelona/Milan/Paris.

Responsible for the detailed analysis and the creation of data analytics for a large multinational organization with an emphasis on transportation and logistics.

Developed multiple AWS services that have API’s available for use. Implemented the functionality of EC2 API’s and NoSQL DynamoDB API’s in depth through AWS CLI.

Azure DevOps end of life: Develop POC’s to move from Azure DevOps to GitHub Actions, assist teams to migrate 5 applications.

Configured and set up JBOSS Server for deployment and used JIRA for tracking bugs and Jenkins for continuous integration. Also used Apache Maven build tool to automate the build process.

Developed an AWS/Azure Cloud Based POC for a firm in the fashion industry with a global footprint.

Worked on a research project on the need for installing EV Charges across the country with an emphasis on ROI.

The study also included the installation of Hydrogen Fuel Cell filling stations.

Responsible for creating the framework for cloud security, cloud infrastructure, cloud auditing, compliance, and DBA operations for both the Fashion and Auto industries.

Lead for designing, developing, implementing, and tuning cloud data structures used within modern BI systems and platforms using GCP and AWS.

Merge multiple Fashion Illustrator software into Adobe Cloud/AWS.

SAP Fashion-Business warehouse Migration to Snowflake/AWS Cloud.

Brand management for the top perfume industry & CPG.

Adhering to standards thru TOGAF Guidelines.

Moving data from Premise to Aurora DB/AWS.

POC on Snowflake Software to upper management for a fashion client.

Installed snowflake virtual servers/URLs.

Experience in Data Migration from Redshift to Snowflake cloud data warehouse.

Deep understanding of relational data stores, methods, and approaches (star and snowflake, dimensional modeling).

Hands-on experience with DBT Core or DBT Cloud, including dev and prod deployment using CI/CD.

Develop and maintain documentation of the data architecture, data flow, and data models of the data warehouse.

Strategic steps towards Blockchain and Digital Transformation.

Worked on Amazon RDS and Dynamo Databases.

Worked as a Architect for Both databases were RDS is Relational and Dynamo is non relational.

ELAVON – US BANK, Atlanta, GA November 2003 – October 2020

Infra/EA/Data/Principal /DATA Cloud Operations/Oracle/Postgres/SAP Production DBA

Responsible for developing enterprise data models for key master data domains, aligning business strategy to data domains, on data architecture, and strategy questions to technology and business leaders.

Implemented Master Data Model using TIBCO MDM and Informatica MDM.

Maintain multiple EDW and maintenance.

Experience in solving manual redundant infrastructure issues by creating Cloud Formation Templates using AWS Server less application model and deploy RESTFUL API’s using API gateway and triggering Lambda Functions

Expertise of performing the Software development Lifecycle (SDLC) using different methodologies including Agile and Waterfall and was also responsible for the project management using tools like JIRA.

Managed to Create team specific Agile process flow in JIRA to move tasks from one activity to another.

Strictly adhering to TOGAF/OSI Standards.

Responsibilities included on Snowflake to Build a Data Architecture, Research Build, and identify models and build specs to automate and hand over to the Development team.

Responsible for data platform architecture, design, data dictionaries, multi-dimensional models, objects, star, and snowflake schemas as well as structures for data lakes, data science, and data warehouses using Snowflake.

Responsibilities also included technical delivery review, resolution of architecture issues, and the migration of the existing on-premises application to the AWS/Azure/GCP Snowflake platform.

Develop, build, & maintain mission-critical centralized data platform using Snowflake.

Diagnose and troubleshoot Snowflake database errors.

Experience in architecting and design DevOps model and platform solutions

Work with multiple internal user groups including analytics and data science.

Implement Snowflake user/query log analysis and alerts with technical audits after migration.

Lead SRE to design and onboard legacy applications to GCP. Design and implemented GKE Clusters with Istio. Worked with DevOps, architects and application team to build fully automated GCP resources creation and application deployment by leveraging Jenkins/Helm/Terraform.

Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, and virtual warehouse.

Done POC on data fabric tools like Tibco, IBM Cloud Spark, Oracle Coherence, and SAP Data Intelligence.

Moving data from Premise to Azure/AWS/Postgres/Aurora/Snowflake.

Implementation of databases and supporting database migration of clients from the Bank of Santander.

The physical implementation of databases in Arklow/Dublin/Madrid/Netherlands/Oslo/Warsaw.

Migrated Bank of Ireland (Euro Conex) FHMS (First Horizon Merchant service) to Elavon/Us Bank.

Work with Data Analyst, Data Modeler, and System Architect to create a standard master data model, architecture, and solution, and develop processes and Protocols.

Extensive experience in the design and implementation of Continuous Integration, Continuous Delivery, Continuous Deployment and DevOps processes for Agile projects.

Responsible for internal/external cloud infrastructure, master data management, data engineering, and infrastructure skills, project management experience.

Develop architectures and enterprise flows across data domains.

Responsible to develop end-to-end view to integrate all data components.

Work with Entire Architected/Systems/Products Engineers to meet and produce the business goals.

Installed security patches and OEM plugins for global database platforms.

Delivered Oracle RAC, Exadata Oracle, database global platforms, Linux Server, and OEM administration.

Utilized Postgres, Cassandra, Sybase, and SQL Server.

Maintained data center migration/administration.

Supported 24 X 7 worldwide platforms.

Managed conversion of databases to 12c and Oracle 18.

Led and managed DBA Managers.

Oversaw ETL management/load.

Completed DR/backup recovery management.

Orchestrated administration of golden gate/integrated with OEM.

Delivered hands-on database support/carried a pager.

Moved data to the cloud and data analytics.

Utilized Snowflake schemas.

Migrated data to the Salesforce cloud.

Installed and configured 11g Active Data guard for several large databases including Postgres.

Wrote scripts for creating and replicating data mimicking a 10g standby database.

Supported multiple databases of more than 30 terabytes on AIX/SUN BOX.

Migrated from SUN to AIX O/S and RAC installations and multiple environments from 9I to 10G to 11g to 19c.

Built Test/QA/Prod/cloned several environments.

Ensured physical and logical database sync issues using Oracle data guard.

Installed and configured one two-node 10gR2 RAC/cluster on Solaris 5.10 for system testing.

Verified clusters were ground up with ASM for high-availability solutions for enterprise databases.

Maintained snapshots/replication/critical database loads/month-end processing.

Monitored/performed/created standards and maintained cold/warm/incremental backup schedules.

Supported data warehouse/data mart.

Directed CISP implementation/security/CPU patch maintenance ongoing activities.

Planned/maintained quarterly/DR/capacity planning.

Tracked PCI implementation for credit card security and database security; installed security patches.

Created new standards for user maintenance.

Maintained multiple Data Marts/participated in active architectural activities.

Wrote several SQL scripts for database and schema creation.

Set up and configured RMAN for several databases.

Installed and configured 11g RDBMS in development/test environment.

ADDITIONAL EXPERIENCE

PUTNAM INVESTMENTS/MARSH-MACLEAN, Andover, MA

Senior/Oracle/Sybase DBA/Trading Floor

FIDELITY INVESTMENTS, Marlborough

Senior/Oracle/Sybase DBA

DOCHARBOR, Boston, MA & Herndon, VA

Senior Sybase/Oracle DBA

KRONOS, Boston, MA

Oracle/SQL DBA

FIDELITY INVESTMENTS, Boston, MA

Sybase/Oracle DBA

W.W GRAINGER, Skokie, IL

Sybase DBA SW – Sybase System 4.9.2/10

EDUCATION

OSMANIA UNIVERSITY

Master of Science in Mathematics

Bachelor of Science in Electronics

UNIVERSITY OF PENNSYLVANIA – WHARTON BUSINESS SCHOOL

Advanced Diploma in Business Analytics

DALE CARNEGIE

Focus in Management Information Systems

https://www.linkedin.com/in/sharma-pandyaram-3218b71a/

Contact this candidate