SUMMARY:

• I am a cloud solution architect with specialization in designing, migrating, supporting, troubleshooting and maintaining different BI tools, Databases and ETL tools in AWS cloud or on - premises.
• Have a strong infrastructure and database experience. I have used majority of the installation, migration, monitoring, and automation related AWS services to provision new environments for phased migration of Teradata and BI projects and applications to AWS Cloud primarily to Redshift clusters.
• Has experience in scripting and automating deployments, installation and configuration using DevOps mythology to bring agility in Infrastructure provisioning, in multiple environments (Dev/QA/Prod), Disaster Recovery and High Availability.
• Has exposure to multiple tools, technologies and methodologies, to define best practices, roadmap, blueprint the migration strategy.
• I have strong interpersonal skills also can work in collaboration with distributed team members with different skillsets.
• Other responsibilities included fork lifting applications and data from on premise to AWS Cloud, designing hybrid cloud model, architecting brand new data centric development in the AWS eco system leveraging services provided by AWS.
• Has delivered secured, cost effective and scalable Data Pipeline (ETL) Data Lake, Data Warehouse and BI application migration to Cloud based infrastructure.
• Strong understanding of the entire AWS Product and Service suite primarily EC2, S3, VPC, Lambda, Redshift, Spectrum, Athena, EMR(Hadoop) and other monitoring service of products and their applicable use cases, best practices and implementation, and support considerations.
• Designing highly available, elastic and performable cloud infrastructure, planning and testing new solutions, executing quick POC to test out new functionalities and features.
• Experience in migrating existing databases from on premise to AWS Redshift using various AWS services
• Worked on various automation tools like GIT, Terraform, Ansible.
• Built auto-scaling solutions including multi-region deployments and/or hybrid cloud solutions (connectivity points to on-premises technologies)
• Instantiated, created, and maintained CI/CD (continuous integration & deployment) pipelines and apply automation to environments and applications.
• As an Architect, I was involved in multiple initiatives for cloud based applications working closely with various development teams and team members.
• Strong knowledge in Hadoop/EMR Ecosystem.
• Have knowledge in processing data using Pig scripts and Hive queries.
• Strong knowledge of Data Warehousing implementation concept in Hive and Redshift. Has done a POC with Matillion and Redshift for DW implementation.
• Excellent interpersonal and communication skills.
• Have strong Database and ETL background.

TECHNICAL SKILLS SUMMARY:

Redshift, AWS services, DevOps, Ansible, Big data, Hadoop, Cloudera Manager, HDFS, Hive, Informatica, Matillion, ETL, Linux, Oracle, Tidal, Python Scripting, Shell Scripting, GIT and Terraform.

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

AWS Cloud Architect/Engineer

Responsibilities:

• Used different AWS Data Migration Services and Schema Conversion Tool along with Matillion ETL tool.
• Designed tables and columns in Redshift for data distribution across data nodes in the cluster keeping columnar database design considerations.
• Used different custom housekeeping utilities and monitoring services to have the cluster running efficiently.
• Wrote Redshift UDFs and Lambda functions using Python for custom data transformation and ETL.
• Used AWS Redshift, S3, Spectrum and Athena services to query large amount data stored on S3 to create a Virtual Data Lake without having to go through ETL process.
• Provided seamless connectivity between BI tools like Tableau and Qlik to Redshift endpoints.
• Manage IAM roles and console access for EC2, RDS and ELB services.
• Monitor and create alarms for CPU, memory, disk space, using Cloud Watch
• Automated the code deployment and EC2 provisioning using Ansible and Terrafoam.
• Have done POC on Redshift spectrum to create external tables by using S3 files.
• Have done POC on AWS Athena service

Confidential, Mountain View, CA

AWS Cloud Architect/Engineer

Responsibilities:

• Played key role in migrating the existing on premise Cloudera Hadoop Data Lake to AWS EMR.
• Responsible for configuration and management, logical access control, data encryption, network configuration and management and security logging and monitoring.
• Responsible for creating Well-Architected Application on AWS using Auto scaling, SQS, SNS, ELB, Caching and database layer as necessary.
• Created an AWS Identity and Access Management role for specific privileged user with cross-account access to resources in AWS Account.
• Working closely with PMO, Developers and QA team from building the infrastructure and application troubleshooting.
• Design high availability applications on AWS across availability zones and availability regions
• Design applications on AWS taking advantage of disaster recovery design guidelines
• Technical point of contact to plan, debug and navigate the operational challenges of cloud computing.
• Setup of Cloud Watch alarms, setting up CloudTrail, creating cloud formation templates, creating S3 buckets.
• Setup Cloud Formation template to launch EC2 instance with and w/o other layers like auto scaling, ELB and EMR
• Setting up RedShift cluster and manage the access.
• Involved in AWS Data Migration Services and Schema Conversion Tool along with Talend ETL tool.
• Designed tables and columns in Redshift for data distribution across data nodes in the cluster keeping columnar database design considerations.
• Working on Data Encryption (Client-Side and Server-Side) and Key management securing data at rest and in transit for data in S3, EBS, ERM and Redshift etc.
• Understanding Storage types and Instance type for the application deployments.
• Diagnose and drive problems and issues to resolution.

Confidential

Informatica/Infrastructure Architect

Responsibilities:

• Product SME: Have and maintain deep understanding of Informatica PowerCenter (from both Designer and Administration sides) and a good overall knowledge of the complete Informatica Product Stack to guide existing & prospective projects;
• Shared Service Management: Manage the global Informatica Shared Service; Oversee all architectural changes to the shared platform; Manage the relationship with the operations support team.
• Involved in Informatica issue resolution, folder migration and administration and served as the second line of support internally for any Informatica issues escalated by project teams.
• Involved in folders migration between environments to follow SDLC.
• Involved in any POC to explore more feature provided by Informatica.
• Installed, configured, administered, upgraded and managed the Informatica 8.6.1/9.1/9.5 multi node grid environment with High Availability.
• Involved in Resource management. Monitor and manage resources associated with the Informatica environment
• Interface with the support team for enterprise scheduler in order to schedule and monitor Informatica production jobs

Confidential

Informatica Lead Developer

Responsibilities:

• Managed customer deliverables and project timelines for all 4 different environments.
• Involved in folders, user and group management and assigning permissions and privileges
• Involved in Informatica issue resolution, folder migration and administration and served as the second line of support internally for any Informatica issues escalated by project teams.
• Involved in Resource management. Monitor and manage resources associated with the Informatica environment
• Involved in Security administration. Managed Informatica users and roles in order to enforce data security, while making sure all users have the necessary access to perform their tasks.
• Interface with the support team for enterprise scheduler in order to schedule and monitor Informatica production jobs
• Provided solutions to problems or challenges quickly and efficiently both in Informatica and Composite.
• Involved in Production Support of Informatica as well as Composite resolving issues and help maintain the entire environment.
• Share the Weekly status Report, Monthly Review program Deck to Customer.

Confidential

ETL Developer

Responsibilities:

• Designing and documenting the process flow.
• Preparing the documents like Analysis and design Document, Unit tests Plan, Deployment Checklist etc.
• Designed the traceability matrix for data lineage as data moved from different sources to target systems in data warehouse and the data mart to trace back the source of the existing data.
• Performed and documented unit/integration/system testing of the entire data flow.

Confidential

Data warehouse developer

Responsibilities:

• Involved in requirement analysis and based on that designed data marts.
• Took part in the ETL design for both the Staging area as well as the dimensional area.
• Created the reusable Mapplet to in corporate the similar transformation logic.
• Partitioned the long running sessions based on the SQL override range.
• Performed SQL Query optimization for the long running queries.
• Devised the Indexing and Partitioning Scheme for the Data Warehouse.

Confidential

Data warehouse developer

Responsibilities:

• Involved in requirement analysis and based on that designed data marts.
• Took part in the ETL design for both the Staging area as well as the dimensional area.
• Created the reusable Mapplet to in corporate the similar transformation logic.
• Optimized session performance by eliminating performance bottlenecks (Mapping bottleneck).
• Documented Confidential