Biplab Kumar Ghosh Email & Phone Number

Columbus, OH, US

North Brunswick, New Jersey, US

Designed ETL pipeline to migrate data from multiple databases to Snowflake using Task and StreamExperience with Snowflake Multi-Cluster Warehouse and Cloud TechnologyBuilt and maintained data pipelines using AWS Glue, transforming raw data into structured formats for further analysis.Automate data processing and deployment using AWS Lambda and other.

Zurich, Zurich, CH

Designed and implemented scalable big data architecture that increased data processing capacity by 50%Incorporated Spark Framework into existing ETL (Informatica) model for better and accurate transactional data flow from multiple sources to target DBDeveloped Spark applications using Spark sql in Databricks for extraction, transformation and aggregation.

North Brunswick, New Jersey, US

• Contributed to a data migration project from Oracle to Snowflake
• Analyzed Metadata to identify surviving tables.
• Re-designed Cognos reports in Tableau and gained an understanding of underlying source-to-target mappings.
• Identified source-to-target mapping for Cognos reports by analyzing different layers in Cognos Framework Manager.
• Parsed XML report files using Python scripts to extract different fields and components to determine Oracle source schema/table name
• Identified and extracted different transformation logics used in reports and Framework Manager using Python scripts

Dublin, OH, US

• Prepared and analyzed data to ensure it is structured for accurate financial reporting
• Developed financial models for disbursement and adjustment of financial transactions and incorporated changes in the existing functionalities based on new features and requirements
• Used SQL to extract and sort data from the banks data base to create control groups for our statistical analysis and modeling of the investment and ROI patterns on different insurance products
• Analyzed potential transactions and investments, including economic benefits, risks, and strategic and financial impacts
• Collaborated with ETL developers to source data into centralized Datawarehouse by providing the required documentation
• Participated in standup, Iteration Planning and Product Backlog meetings, estimate work for upcoming iteration and decided feature priority with product owners (business). Also, retro to reflect on past iterations.

Bensalem, Pennsylvania, US

• Created customer segments implementing ‘k-means’ algorithm in R into product marketing strategy and ultimately into sales management
• Conducted consumer research and in-market studies
• Developed predictive models to improve customer reach and product placement
• Utilized diverse sources of data to predict demand, risk and price elasticity using excel and R
• Created models in R incorporating social media data into customer analytics
• Applied regression algorithms in R to determine the impact of different demographic attributes and otherfactors on sales/revenue growth

Bensalem, Pennsylvania, US

• Streamlined algorithm to process data, saving 40 hours of manual work for every project
• Worked autonomously within a team of Analysts, to analyze and ensure accuracy of customer data up to 98%
• Developed market forecast model and visual report based on customer survey data using Tableau
• Designed (data models), developed and implemented/deployed end-to-end project solution for betterinteraction between business and customer
• Design and research algorithms related to project and implemented solutions through software application development.

- Extracted data for Data modeling, Data integration, Data migration and ETL process.- Identified data problems and implemented strategies for dealing with missing or incorrect data; reduced processing time by at least 10% for various accounts.- Specialized in manipulating, cleansing and processing raw data using Excel, Access and PL/SQL.- Worked.

Pune, Maharashtra, IN

- Re-designed and developed the front-end interface for communication between customer and client in Java Web Applications using JSP and Servlets. The setup time was reduced by 15% and significantly reduced human error.- Developed and deployed various JAVA/J2EE applications on WebSphere Application Server and Tomcat.- Created Stored procedures using PL-SQL.

Master'S Degree, Information Systems

Bachelor Of Technology - Btech, Information Technology