Shohan Alam

Shohan Alam Email and Phone Number

Software Engineer, Data @ Blue Cross Blue Shield Association
New York, NY, US
Shohan Alam's Location
New York, New York, United States, United States
About Shohan Alam

As a highly skilled and experienced data engineer with over 6+ years of experience in Big Data technologies and Cloud Computing, I have a proven track record of designing, developing, and maintaining robust data pipelines and infrastructures. I am proficient in various data processing technologies such as Apache Spark, Python, Pyspark, Kafka, AWS Glue, Hadoop, Hive, Cassandra, and Redshift, as well as skilled in implementing ETL processes, REST APIs, to extract, transform, and load data efficiently. Additionally, I am comfortable in conducting data profiling, quality checks, exploratory data analysis, and performance tuning to ensure that data is accurate, complete, consistent, and efficiently stored and processed. My experience collaborating with business stakeholders, data scientists, and junior data engineers allows me to understand data requirements and maintain data integrity. I am seeking a challenging role as a data engineer to utilize my skills and expertise in developing innovative data solutions that add value to the organization.

Shohan Alam's Current Company Details
Blue Cross Blue Shield Association

Blue Cross Blue Shield Association

View
Software Engineer, Data
New York, NY, US
Website:
bcbs.com
Employees:
4959
Shohan Alam Work Experience Details
  • Blue Cross Blue Shield Association
    Software Engineer, Data
    Blue Cross Blue Shield Association
    New York, Ny, Us
  • Blue Cross Blue Shield Association
    Senior Back End Developer
    Blue Cross Blue Shield Association Aug 2023 - Present
    Chicago, Il, Us
    - Senior Backend developer on a collaborative team that was required to construct a web application catering specifically to BCBSA’s internal user base.- Leveraged Python to architect, design and implement scalable and efficient backend solutions, ensuring optimal performance.- Proficiently utilized various AWS services such as AWS Lambda, API Gateway, Secrets Manager, IAM, and more to orchestrate the deployment and management of Restful APIS. - Utilized SQL queries proficiently to extract and manipulate data from Aurora PostgreSQL, facilitating the retrieval of essential information required for various functionalities within the web application.- Developed data upload mechanisms using AWS Lambda functions to streamline the process of populating specific roles within Aurora database.- Implemented robust unit tests to validate functionality and integrity of APIs developed and worked closely with QA testers to optimize code and address and discrepancies. - Demonstrated adeptness with tools such as Postman for API testing, Jenkins for continuous integration and deployment, JFROG for artifact management, SonarQube for code quality analysis, Github for version control and collaboration, and Jira for project management. - Participated in multiple production calls and was in charge of loading data roles as well as troubleshooting in the time of error using AWS CloudWatch.- Exhibited strong problem-solving skills in diagnosing and resolving issues in code as well as during Jenkins Pipeline failure.
  • Unitedhealth Group
    Data Engineer
    Unitedhealth Group Mar 2022 - Sep 2023
    Us
    · Designed and implemented a data pipeline to determine patient risk for an insurance claims company.· Developed and maintained ETL processes using tools such as Apache Spark, ensuring that data was extracted, transformed, and loaded efficiently.· Utilized Apache Hadoop and Hive to store and manage large volumes of medical data, including patient records, claims data, and billing information.· Migrated data from SQL Databases to Hadoop using Sqoop and used HIVE to create staging tables and then process them to create final output tables in Redshift.· Designed and implemented data models using tools such as Apache Cassandra and Amazon Redshift, ensuring that data was organized and structured for efficient querying and analysis.· Conducted exploratory data analysis using tools such as PySpark to identify patterns and trends in patient data and collaborated with business stakeholders to define data requirements and ensure that data was aligned with business objectives. · Worked closely with data scientists to develop predictive models that could be used to inform underwriting decisions and improve risk management.· Utilized PowerBI to create interactive dashboards and reports that provided insights into patient risk and claims data.· Conducted performance tuning and optimization of Spark Jobs· Used Oozie to orchestrate workflows.
  • Stubhub
    Hadoop Developer
    Stubhub Jan 2020 - Feb 2022
    New York, Ny, Us
    · Worked with a team of data analysts while working on the Hadoop Team to develop and implement a data-driven approach to determine cost and profit based on ticket sales for a major sporting event company.· Conducted a comprehensive analysis of historical sales data using tools such as Python, and SQL to identify trends and patterns in ticket sales.· Developed and maintained data pipelines using PySpark and SQL, ensuring that data was captured, processed, and stored efficiently.· Utilized Power BI in profitability dashboards and reports that provided actionable insights into ticket sales, revenue, and profitability.· Designed and implemented data quality checks and validation procedures to ensure the accuracy and reliability of data used in the analysis.· Developed and presented reports to senior management that provided insights into ticket sales trends, customer behavior, and profitability.· Migrated Data from Mainframe Systems to HDFS using a framework that pulls data to SFTP server then exports those files to HDFS using the naming convention of files.· Converted files into Parquet and ORC based off of where the files were designated to.· Conducted market research and analyzed competitor data to identify opportunities for growth and expansion.
  • Srtech
    Hadoop Developer
    Srtech Jan 2018 - Dec 2019
    · Joined as an Intern to gain experience in DBMS and Cloud Computing. · Helped build and maintain small volume pipelines for Small Buisnesses· Took part in individual client meetings to understand and integrate requirements/asks.· Wrote Spark Scala Jobs to process data.· Configured and installed Hadoop Ecosystem Components.· Utilized Power BI in dashboards and reports that provided insight for business sales/closings.· Maintained and wrote code for REST API’s that would provide accurate pricing dependent on companies.

Shohan Alam Education Details

  • University At Buffalo
    University At Buffalo
    Computer Science
  • Brooklyn Technical High School
    Brooklyn Technical High School
    Computer Science

Frequently Asked Questions about Shohan Alam

What company does Shohan Alam work for?

Shohan Alam works for Blue Cross Blue Shield Association

What is Shohan Alam's role at the current company?

Shohan Alam's current role is Software Engineer, Data.

What schools did Shohan Alam attend?

Shohan Alam attended University At Buffalo, Brooklyn Technical High School.

Who are Shohan Alam's colleagues?

Shohan Alam's colleagues are Jonna S., Bonnie Weber, Erica Moskovitz, Inger Saphire-Bernstein, Regina Mcwaine, Acs, Amanda Drebitko, Meredith Kelvington.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.