SATISH KUMAR KANTA

Data Engineer with over 10+ years of experience, specializing in developing robust data platforms and solutions.

Proven expertise in SAS and SQL programming, with a strong focus on query optimization and performance tuning.

Adept at designing and implementing data conversion and normalization protocols, contributing to the seamless delivery of timely and accurate data for various business units.

Expertise includes SAS/BASE, SAS/SQL, SAS/MACROS, and SAS/ODS, SAS/STAT, SAS/ACCESS, SAS Enterprise Guide, SAS Web Report Studio, SAS Management Console, IBM DB2, Oracle, UNIX, LINUX, R, Python, Dataiku, Dremio, Tableau, Power BI, QlikView, and Micro Strategy.

Expertise in Dremio, Dataiku, Hive SQL, and DB visualize, SQL, SAS, and Python. Leverage advanced data modeling techniques, incorporating Snowflake SQL and Collibra.

Utilize Business Object for effective data visualization and reporting. Collaborate with cross-functional teams, adapting to new technologies and methodologies. Showcase adaptability and a strong aptitude for learning.

Exhibit excellent customer skills, understanding client requirements and delivering solutions that exceed expectations.

Engage in continuous communication to ensure client satisfaction.

Excellent hands-on experience in SAS Grid Computing, SAS Grid Manager, Distributed Enterprise Scheduling, Workload Balancing, and parallelization of workloads.

Expertise with Platform RTM for SAS to monitor and configure the Grid Environment. Excellent experience in Business Analysis, Design, and Training of Users.

Excellent Stakeholder management skills and effective cross-functional management expertise, seeking a challenging environment that encourages continuous learning and creativity providing exposure to new ideas that helps professional growth.

Knowledge to Developed and maintained MongoDB databases for high-traffic applications. Implemented real-time data aggregation and analysis using MongoDB. Designed and implemented a distributed data processing pipeline using MongoDB. Utilized MongoDB to access and manage unstructured data.

Excellent hands-on experience with RDBMS like Oracle 9i, 10g, Teradata, DB2, MS SQL Server, MS Access, Informix, Sybase, Oracle Clinical & Clinical Trials Databases.

Strong experience in writing complex UNIX Shell Scripting.

Expertise in migrating SAS Platforms, Applications, Data, and Catalogs from older SAS versions. Re-engineered SAS code to leverage the enhanced features of SAS for streamlining complex job streams and processes.

Strong experience in complete Software Development Life Cycle (SDLC), requirements gathering, Data Management Principles, Data Warehouse Design, Data Mapping, Dimensional Modeling, Star Schema, Data Analysis and Design, Data Quality Techniques, Database Development, and Test Plan Development.

Excellent experience in Extraction, Cleansing, Transformation & Loading (ETL) as per business requirements. Strong knowledge in OLTP, Data Warehouse, Data Mining, OLAP & Data Marts applications.

Created and administered several Standard Operating Procedures (SOPs), Technical Operating Procedures (TOPs), and Validation Guidelines.

Strong experience in working with SAS under different platforms such as Mainframe, UNIX, and Windows. Good experience in writing installation Qualifications (IQs), Operational Qualifications (QoS), and Performance Qualifications (PQs) for various Operating Systems and numerous software.

Expertise in loading DB2 tables into Oracle using DB2 gateway, SQL Loader, and PDW (Product Data Warehouse) Server.

Used Bulk load to load SAS Datasets into DB2 tables.

Strong experience in installation, configuration, maintenance, and administration of SAS/EBI tools such as SAS/Data Integration Studio, SAS Information Maps Studio, SAS Management Console, SAS/Campaign Management Studio, SAS/OLAP Cube Studio, SAS Information Delivery Portal, SAS Web Report Studio, SAS Web Report Viewer, SAS Web OLAP Viewer & SAS/Enterprise Guide. Installed several Software including Base SAS, EBI, SAS/Warehouse Administrator, and SAS Forecast Server in multiple instances such as development, staging, QA, Testing, Training, and Production Environments. Written complex shell script, configured run setups, and profiles to execute the instances.

Strong experience in collaborating with stakeholders and working with people across the globe from 24 countries like Hongkong, Singapore, China, Indonesia, Africa, Malaysia, UAE, UK. Deployed complex dashboards and visualizations using different reporting tools - Tableau Qlikview, Power BI & SAS VA. Experienced ETL & data analytics in the field of Data warehouse, data analytics, data profiling, data migration and data visualization.

Advanced skills on data cleaning, manipulation, Data migration and creation of Analytical Data mart with SAS/DI Studio.

Strong experienced in statistical Modeling/Machine Learning and Visualization Tools. Strong exposure of all steps of project life cycle such as original data collection, secondary query, data manipulation and analysis, optimizing, summary of finding develop analysis indications; communicate strategic insights and presentation of results.

Advanced skills to all steps of project life cycle such as original data collections, secondary data query, data manipulation and analysis, optimizing, summary of findings, develops analysis indications; communicate strategic insights and presentation of results.

Experiences on SAS Visual Analytical (VA) and Tableau.

Hands on experience in Azure development, worked on Azure web application, App services, Azure storage, Azure SQL database, Virtual machines, Fabric controller, Azure AD, Azure search, and notification hub. Designed, configured and deployed Microsoft Azure for multitude of applications utilizing the Azure stack(including Compute , Web & Mobile, Blobs, Resource Groups, Azure SQL, and Cloud Services), focusing on high – availability, fault tolerance, and auto-scaling.

Developed methodologies for cloud migration, implemented best practices and helped to develop backup and recovery techniques for applications and database virtualization platform.

Good at Manage hosting plans for Azure infrastructure, implementing & deploying workloads on Azure virtual machines (VMs).

Good understanding of Web Application deployment and maintenance of IIS 5.0 and 7.0, Apache on Amazon Web Service (AWS).

Demonstrated understanding of AWS data migration tools and technologies including Storage Gateway, Database Migration and Import Export services.

Practical Database Engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system.

Managing various aspects of development, design and delivery of database solutions. Tech-savvy and independent professional bringing outstanding communication and organizational abilities.

History of mining, warehousing and analyzing data at the company-wide level.

Knowledgeable about the principles and implementation of machine and deep learning.

Results-oriented and proactive with top-notch skills in project management and communication.

Highly-motivated employee with desire to take on new challenges.

Strong worth ethic, adaptability and exceptional interpersonal skills.

Adept at working effectively unsupervised and quickly mastering new skills. Hardworking employee with customer service, multitasking and time management abilities. Devoted to giving every customer a positive and memorable experience. Committed job seeker with a history of meeting company needs with consistent and organized practices.

Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.

Organized and motivated employee eager to apply time management and organizational skills in various environments.

Seeking entry-level opportunities to expand skills while facilitating company growth.

• SQL Certification
• BASE SAS Certification

• GEM award for an outstanding performance for successful completion of all project assignments at SCB.
• Trained New Joiners in SQL and EXCEL and received best trainee 2015.
• Designed JNTU Kakinada Web site.