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 serverless technologiesExtensive experience on Python programming for data processing and data integration between On-prem and Cloud DB

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 from multiple source to analyze and uncover business insights Prepared data models for disbursement & adjustment of financial transactions to incorporate changes in the existing functionalities based on new features and requirementsDeveloped data pipelines using Python to improve data quality, resulting in a 30% increase in data accuracy.Built and published customized interactive reports and dashboards on specific servers using Tableau for statistical analysis and business insightsLed a cross-functional team to establish data management policies and best practices, resulting in improved data security and compliance

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• Performed Metadata analysis to identify surviving Oracle table/schema for data migration into the snowflake database• Identified required ETL jobs to update production tables on Oracle for Cognos reports• Created Tableau wire-framing to redesign Cognos reports in Tableau desktop/online• Created complex SQL queries to profile and validate data in Oracle• Worked with clients to understand business requirement to create data models for the snowflake database• Created requirement gathering documents to facilitate data migration from Oracle to Snowflake• Documented source-to-target mapping to understand data lineage for Cognos reports to database table/column name• Designed data pipelines for populating data warehouse on Yellowbrick using Python scripts• Analyzed source databases (DB2 and Netezza) to understand business rules and transformation logics.• Worked on creating target database schema on PostgreSQL.• Analyzed perl/shell scripts to map all scheduled job to target database.• Worked on complex SQL queries and transformation logics for better performance.

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. • Used GIT for version control and to deploy and migrate code across different branch• Identify opportunities to improve risk posture, developing solutions for re mediating or mitigating risks and assessing the residual risk also performed focused risks assessments of existing or new services and technologies• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.• Standardized and Cleaned Data to meet the business standards using R and Python by Conditional Split, Data Conversion, and Derived column from different environments• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server also created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

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• Developed and maintained ETL mappings using Talend to extract data from multiple sources like PostgreSQL, SQL server, Excel and flat files to a staging area.• Designed web scrapers to collect raw data from dynamic web pages• Created customized reports and insightful data visualization in Tableau Desktop and Power BI

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 autonomously within a team of Data Analysts, to analyze, review, update, edit, clean, translate, and ensure accuracy of customer data. - Automated weekly and monthly reporting process resulted in 15% manual process time reduction and reduced possibility of manual error by 50%.- Established test plans based on requirements documentation, perform database queries to identify test data, and create test procedures and test cases with expected results.- Developed Use Cases, Test Strategies, managed Change Requests and Functional requirements and created Low Level Designs for business requirements; analyzed test results, including user interface data presentation, output documents, and database field values, for accuracy and consistency.

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 for data modification in Oracle, redesigned data model. Sped up the average performance by a factor of 10.- Analyzed and solved different technical issues for on-going applications running on production server, enabling order-of-magnitude faster for data throughput. - Performed business analysis and created scenarios for new system development; developed the framework for the next generation of the company’s web-applications.

Master'S Degree, Information Systems

Bachelor Of Technology - Btech, Information Technology