Srajan Jain

Experience

1. Data Analyst

   EY

   Dec 2019 — Present

   Design and develop of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services (SSIS) & SQL Server. Pre-processed raw data using SSIS tool, Python Pandas and performed data cleaning. Performed required operations to connect to AWS using AWS cli and Boto3. Developed containment scripts for data reconciliation using SQL and Python. Used OLTP and OLAP systems for Normalization and De-Normalization. Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers. Writing Stored Procedures, Window Functions, Views, work with history of objects (Time Travel) and recovery area (Fail Safe) in Snowflake. Worked on Core Python Data Structures and libraries like Lists, Tuples, Dictionaries, NumPy & Pandas. Involved in User acceptance testing and fixing bugs Scheduling AWS lambda functions from CloudWatch triggers. Developed an evaluation Model used by Seed stages to find success, time horizon, and optimal price for seed/VC funded startups. Created Lambda event handler scripts to capture events of new data landing in S3 (JSON, CSV files) and send Notification using SNS. Used tree-based learning methods to determine the probability of success using variables like total funding, funding round days. The accuracy of the tree-based model was 86%, highest among the 10 different models. Used Tableau to visualize different startups at varying funding rounds and their probabilities of success and failure. Used numerical and non-linear variables to predict time for a startup to fail/succeed. Developed a multiple linear regression model in Python with R-squared value of 76% i.e. variance within the data. Environment: SSMS, SQL Server 2012, SSIS, Visual Studio, SSRS.Python