TECHNICAL SKILLS:

Languages:: Python, Scala, JavaScript, SAS, SQL, C++

Analytic Tools:: Spark, SAS

Databases:: MySQL, PostgreSQL, Amazon Redshift, MongoDB

Scripting:: Velocity Template Language

BI Reporting Tools:: Tableau, SAS Visual Analytics

Servers/OS Management:: RedHat, Ubuntu, Windows Server 2008/2012/2016, Amazon Web ServicesCertification: SAS Certified Base Programmer for SAS 9

PROFESSIONAL EXPERIENCE:

Confidential - Barrington, IL

• Developed Scala scripts, using both Data frames/Spark-SQL and RDD in Spark for Data Aggregation, queries and reading/writing data.
• Developed Spark, Greenplum and Redshift routines to perform data profiling.
• Implemented reading and writing to Big Data tools such as HDFS, Greenplum, Redshift, and S3.
• Managed Amazon redshift clusters such as launching the cluster by specifying the nodes and performing the data analysis queries.
• Designed the metadata and developed data transformations.
• Developed interfaces to design and store business rules into hive managed tables in JSON format.
• Manage the Java based web services to integrate the underlying technologies and the user interface.
• Involved in creating data pipelines and aggregations using python libraries such as pandas, NumPy, Scikit-learn.
• Designing the solution functionalities around data extraction, transformation, classification, clustering and linear, logistic regression models.
• Designing solutions which run on Apache Spark (machine learning libraries) using Scala.
• Working with Spark libraries such as MLlib, Knowledge in writing SparkSQL scripts, Spark & Java API's.
• Developed Spark scripts by using Scala shell commands as per the requirement.
• Used Spark SQL to create structured data by using data frame and querying from other data sources.
• Integrating D3JS to Visualize data.

Platform Architect and Senior Developer Consultant

Confidential

• Designed and built the architecture for Amazon cloud-based solution for their IIoT platform for corrosion, vibration and temperature sensors.
• Developed automated testing system for benchmarking performance of message parsing and data streaming ETL applications.
• Architected and developed Spark Streaming applications to process large amounts of continuously arriving data and make it available for end users in real time
• Created aggregation pipelines on timeseries data stored in MongoDB using JavaScript.
• Leveraged Sqoop to efficiently process and transfer sensor data from Hadoop to relational databases for user consumption.

SAS Administration

• Provided basic systems administration, operational support and problem resolution for client systems.
• Experienced in using SAS Management Console to Create Users/groups/Roles/Folders, deploying and scheduling jobs.
• Experienced in defining libraries, setting permissions and access controls, creating metadata folder structure.
• Assisted SAS Development team with SAS Programming and ETL needs.
• Performed tasks related to SAS platform security, performance, server design, cross-platform architecture, system backup, recovery and storage administration.

Amazon Web Services Administration

• Provided production support with AWS environment, including EC2, RDS, S3, IAM, Auto Scaling, Glacier, Lifecycle rules for storage, VPC, Volume and Snapshot management.
• Monitored and created alarms for CPU, memory, EBS volumes, using Cloud Watch.
• Ensured backup of all EBS Volumes in preparation for quick recovery of EC2 instances.
• Designed and deployed MongoDB clusters, in multiple AWS environments, including development, test, performance testing, pre-production, and production.
• Involved in designing and distribution of Data across all the nodes and Clusters on different availability zones in AWS Redshift.
• Estimated AWS usage cost and identifying operation cost control mechanism.
• Performed configuration, deployment and support of cloud services including Amazon Web Services and Automating infrastructure in AWS and Configuring EC2 Instances, VPC, Route 53, ELB, Subnets

System Engineer

Confidential - Hagerstown, MD

• Configured virtual/physical servers. (Windows 2003/2008/2012, RedHat Linux Servers)
• Provided detail technical specifications for the project and comply with internal standards.
• Handled online/offline-monitoring requirements Integration of tools such as NCM, Syslog collectors.
• Reported the findings from the server analysis to the business users and conducted meetings for error resolution.
• Actived Directory/Group Policy administration.
• Performed environment tuning of Linux Servers to achieve better performance.
• Unit tested virtual Linux and windows servers and fix the defects if any and document the findings.
• Troubleshot systems architecture, capacity, security, stability and data flow issues.
• Administrate and performed code upgrades and server migrations between environments and to final production release.
• Post production support to resolve issues and tickets.

System Administrator

Confidential - New York, NY

• Supported the Confidential (500 + users) on workstation and connectivity issues by phone, desk side and remote access.
• Provided accurate and timely support for school staff and teachers utilizing the Service Desk Manager software to update, escalate and resolve tickets.
• Resolved issues with Active Directory accounts (Windows Server 2008).
• Remotely resolved PC software and configuration issues via Active Directory/Group policy.
• Guided users through fixing common hardware issues remotely and on-site.
• Supported and configured Blackberry, Android Phones, tablets, iPhones, and iPads.
• Installed software in PC’s and Laptops running on windows and Mac Environment.