Hello There,
Go through the below mentioned resources profiles and let me know if you or any of your colleagues have requirements for below technology resources.
reach me out for resources/consultants details.
Looking forward to hearing from you.
Name: Rakesh,
Technology: SQL/PL Developer- Data Engineer
Visa Status: H1B
Ready to go ONsite
Summary:
• Over 5+ years of Software Life Cycle experience in Design, Development, and Implementation, Maintenance, and Production support of Data Warehouse Applications, SQL, PL/SQL, SSIS, SSRS, Power BI on HealthCare, Insurance & Payments.
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data, and process flow documentation, prepare High level and Low-level design documents.
• Over 5 plus years of programming experience as an Oracle, SQL, PL/SQL developer in analysis, design and implementation of business application and Expertise in client server application development using oracle 11g/10g/9i/8i, PL/SQL
•Worked on Migrating table DDL’s, views and stored procedures from hive to SQL, Netezza to snowflake, Teradata to snowflake. designing and implementing a fully operational production grade large scale data solution on Snowflake Data Warehouse.
• Experience in designing, developing, analyzing, and implementing client-server, web and desktop-based applications using C# language.
• To generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file, MS Access and CSV files to the data warehouse.
• Able to create CLR function in a database object inside an instance of SQL Server that is programmed in an assembly created in the Microsoft .NET Framework common language runtime (CLR).
• Ability to create SSIS Packages using various Transformation like Lookup, Derived Columns, Conditional Split, Data Conversion, Aggregate, Merge Join and Sort.
• Database development for both OLTP and OLAP systems using MSSQL Server.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Experience in Database Backup, Recovery and Disaster Recovery procedures. Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in SQL Server and T- SQL (DDL and DML) and PL/SQL in constructing Tables, Normalization/ De normalization Techniques on database Tables. Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Strong understanding of Release Management process and required applications.
• Experience in UNIX shell scripting, job scheduling and server communication.
• Able Design schema for big query.
• Extensive experience in implementing projects using Agile (Kanban) and waterfall methodologies
Technical skills:
ETL Tools
Informatica 9.6.1 and SQL Server SSIS
Databases
Oracle 11g/10g/9i/8i, MS SQL Server (2008, 2005, 2000, 7.0, 6.5, 6.0), MS Access, SQL Server Assistant, Snowflake and Teradata
Other Tools
SQL Developer, TDM, Power BI and Airflow
Programming Languages
SQL, PL/SQL, UNIX Shell Scripting and Python
Job scheduling
Active Batch and Control M
Environment
MS Windows 2012/2008/2005 and UNIX
DBA Tools
SQL, PL/SQL and T-SQL
Professional Experience
Client: Cigna Health Spring, Nashville, TN June 2022 - Present
Role: Sr. SQL Developer
Responsibilities:
· Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
· Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
· Worked with DBA team on TDM process which is Data Acquisition TDM tool will help rapid development of ETL process which we can copy one or more tables from SQL server or flat files to any TD core system.
· In the TDM Development tool which includes ABC metadata entries, creating tables/views Generation, Active batch development.
· Analyze requirements provided, design and develop integration packages as per the client request and automate them.
Name: Ashok,
Technology: SQL/PL
Visa Status: OPT
Ready to go ONsite
SUMMARY:
· Extensive 7 years of experience in using T-SQL (DML, DDL) in SQL Server 2012/2014/2016 platforms
· In-depth knowledge of the Microsoft Azure framework and Azure Cloud platform
· Experience in Creating API’s using C#
· Experience working with terabyte to petabyte scale data
· Experience in creating Tables, Complex Query, Stored Procedures, Views, Indexes, Triggers, CTE, and ices (SSRS)
· Skilled in creating several reports such as Drill Down reports, Drill through reports, Parameterized reports, Sub reports, Matrix Reports, Chart reports using SQL Server Reporting Services. Worked on Standard and Data-Driven Subscription in SSRS
· Strong understanding of Object Oriented Programming (OOPS) concepts. FX, MVC.
· Experience with Star Schema and Snowflake Schema in Data Warehouse.
· Experience in Backup/Restore, Disaster Recovery.
· Experience in Data Modeling using Erwin, MS Visio.
· Expertise in developing advanced PL/SQL code through various procedures, functions, cursors, triggers, packages and materialized views.
· Experience working with different IDEs like Visual Studio, Eclipse etc.
· Strong understanding of Cloud services like Amazon Web Services (AWS), Derivatives, and Azure.
· Strong time management, analytical and problem-solving acquisitions coupled with excellent written, verbal and interpersonal communication skills.
· Experienced in performing database activities like backup, recovery, installing software, setting permissions to users, deploying SQL code to prod environment and setting up new environment on new servers.
· Proficient in using Extract, Transform and Load (ETL) solutions using SSIS Containers, Data transformations like For Loop, For Each Loop, Execute SQL task, Derived Column, Conditional Split, Sort and Merge Joins, Lookup, Multicast Transformations.
· Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2008/2012 using SSIS tools like Import and Export Wizard
· Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
· Hands on experience in full/diff backup and restore in SQL Server 2012/2014/2016
· A well-organized, goal-oriented, highly motivated and effective team member with excellent analytical, troubleshooting, and problem-solving Skill.
· User Defined Functions in observing Business needs
· Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
· Skilled in Business Intelligence tools like SQL Server 2012/2014/2016, Integration Services (SSIS), Reporting Service
TECHNICAL SKILLS
· Databases: SQL Server 2008/2012/2014/2016, Oracle 12c, HANASIDECAR
· Languages: TSQL, PL/SQL, C#, ASP.Net
· IDE & BI Tools: MS Visual Studio 2015/2019, Red Gate Sql Tools, Erwin
· Tools: Visual Studio 2019, SSIS/SSAS/SSRS, Data Stage, Informatica, Power BI, Microsoft Excel
· OS: Windows/ Unix
PROFESSIONAL EXPERIENCE
Client: Genesis Financial Solutions, Beaverton, OR August 2021 to till date
Role: SQL Developer
· Design and Improve database/SQL centric software products for Sales Department which includes multiple phases of development such as design, coding, testing of technical solutions using SQL Server
· Design/Implemented efficient Database solutions and optimize existing Database architecture to make them more proficient based on technical requirements using T-SQL programming
· Developed SSIS ETL packages to load/process data from multiple sources into SQL Server for analysis.
· Created API services using C#
· Involved in Performance tuning and recommend various options such as Index tuning and SQL query optimization techniques to improve the application throughput by analyzing the query plan
· Act as POC between UI team and other software development teams, assist them by architecting database solutions, and recommend latest Database technologies within the scope of product
· Performing hands on Database Development and design while serving as POC for multiple teams across the organization and handling multiple projects simultaneously
· Created and Maintained different versions of SQL code, Dtsx packages and Report rdl’s in TFS.
Name: Ramvardhan
Technology: DevOps Engineer
Visa Status: OPT
Ready to go ONsite
Professional Summary:
Overview:
DevOps Engineer with overall 6 Years of Hands-on experience and understanding of DevOps methodology and workflow, Continuous Integration/continuous delivery (CICD) oriented Build & Release of code and solution-based IT services for Linux systems, Containerization, Configure Management, Cloud Services, and System Administration.
Expertise:
• Expertly worked on Hudson and Jenkins for all the Build and Deployment Processes for End-To-End automation and Continuous Integration.
• In-depth Knowledge and best practices of Software Development Life Cycle (SDLC) & Software Configuration Management (SCM) in Agile, Scrum & Waterfall methodologies.
• Best experienced in the installation, configuration, and upgrading of RHEL 5.x/6.x/7.x, CentOS 5.x/6.x/7.x, Ubuntu, Debian by the usage of Kick Start server.
• Experienced with implementing monitoring solutions in Ansible, Terraform, Docker, and Jenkins.
• Experienced in using the windows and Linux environments for creating Branches, Rebasing, Reverting, Merging, Tagging and maintaining the versions across the Environments by using SCM tools like GIT.
• Involved in designing and deploying a multitude of cloud services on AWS stack such as EC2, Route53, S3, RDS, DynamoDB, and IAM, while focusing on high availability, fault tolerance, and auto-scaling.
• Expertise in setting up Kubernetes (k8s) clusters for running microservices and deploying them into a Production environment.
• Expertise in Terraform for building, changing, and versioning infrastructure and collaborating on the automation of AWS Infrastructure via Terraform and Jenkins.
• Worked on VAULT, a Secret Manager tool for storing Secrets, Key-Value pairs, and other security parameters.
• Good Knowledge in Querying RDBMS such as Oracle, MY SQL, and SQL Server by using SQL for data integrity.
• Provided expertly in Kafka brokers, zookeepers, KSQL, Kstream and Kafka control center.
• Expertise in setting up Kubernetes (k8s) clusters for running microservices and deploying them into the Production environment.
• Experienced using log monitoring tools like Prometheus, Splunk, Nagios, and ELK (Elasticsearch, Log Stash, and Kibana) to see log information. Monitor & get the health & security notifications from nodes. Created monitors, alarms & notifications for EC2 hosts using CloudWatch. Implemented Kubernetes to deploy scale, load balance, scale and manage Docker containers with multiple names spaced versions.
• Good working experience with DevOps tools such as Vagrant, Virtual Box, Chef, Puppet, Ansible, Maven, ANT, SVN, GIT, Azure, Jenkins, and Docker.
• Expertise in Integration, Tuning, Backup, Disaster Recovery, Upgrades, Patching, Monitoring System Performance, System and Network Security, and troubleshooting of Linux/Unix Servers.
• Hand-On experience in implementing, Building, and Deployment of CI/CD pipelines, managing projects often includes tracking multiple deployments across multiple pipeline stages (Dev, Test/QA staging, and production).
• Ability and experience to meld development and operations to ensure quick delivery of an effective and efficient end product.
• Adapt to new, evolving technologies and implement them in current projects. Good interpersonal skills, quick learning, problem resolving, and meeting technical and business needs.
Technical Skills:
Operating Systems
RHEL/Centos 5.x/6.x/7, Ubuntu/Debian, Sun Solaris 7/8/9/10, Windows Server 2003/2008/2012
Cloud Technologies
AWS EC2, IAM, AMI, Elastic Load Balancer (EBL), DynamoDB, S3, SNS, Cloud formation, Route53, VPC, VPN, Security groups, Cloud watch, EBS, Athena, EWR
Build Tools
ANT, MAVEN
Configuration Management Tools
Puppet, Chef, Ansible
CI Tools
Jenkins/Hudson, Anthill Pro, UDeploy
Scripting:
Python, Bash.
Application Servers:
Apache Tomcat, WebLogic, WebSphere
Languages/Scripts
C, HTML, Shell, Bash, PHP, Python, PHP, Ruby, Perl, Groovy and Power Shell.
Web Server:
Apache, Nginx
SDLC
Agile, Scrum, Waterfall.
RDBMS
Oracle, SQL Server, MS Access, MySQL 5.x, PostgreSQL
Database
MS SQL, ORACLE SQL, MYSQL
Education:
Masters in IT from Wilmington University
Work Experience:
Client: Dell TX March 2021 – Present
Role: DevOps Engineer
Responsibilities:
• Extensively working with Kubernernets to orchestrate the deployment, Scaling, and management of Docker Containers.
• Developed and implemented Software Release Management strategies for various applications as per the agile process.
• Setup of Kubernetes services on AWS with Route53 and worked on encrypting TLS certificates.
• Work in setting up the CI/CD pipelines using Jenkins, GitHub, GitOps, Helm, and AWS.
• Performed AWS Cloud deployments for web applications running on AWS Elastic Beanstalk with monitoring using CloudWatch and VPC to manage network configurations.
• Provided Expertise and hands-on experience on custom connectors using the Kafka core concepts and API.
• Created S3 Buckets in AWS and stored files. Enabled Versioning and security for files stored. Manage AWS EC2 instances utilizing Auto Scaling, Elastic Load Balancing, and Glacier for our QA and UAT environments as well as infrastructure servers for GIT and Chef.
Thanks & Regards
Jyothi
Sales Recruiter
TechSmart Global Inc.
666 Plainsboro Rd, Suite 1116, Plainsboro, NJ 08536.
