| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address EMAIL AVAILABLE PHONE NUMBER AVAILABLE LinkedIn GitHub EDUCATIONNortheastern University, Boston, MA, USA Sep 2019 Aug 2021 Master of Science in Engineering Management GPA: 3.57 Relevant courses: Data Warehousing & Business Intelligence, Data Mining & Machine Learning, Database Design & Management, Computation & Visualization for Analytics, Probability and Statistics Jaypee Institute of Information Technology, UP, India May 2015 Jun 2019 Bachelor of Technology in Electronics and Communications Engineering TECHNICAL SKILLSProgramming Languages: Python, SQL, R, SOQL, PySpark, BASH (Linux) Software & Tools: Tableau, Power BI, DOMO, AWS (Redshift, DynamoDB, S3, Athena, Kinesis, EMR, Lambda, EC2), Celigo, NetSuite ERP, Salesforce, Alteryx, Informatica, DataWrapper, Oracle BI, JIRA, Confluence, Docker, Git Big Data: Hadoop, Hive, MapReduce, HDFS, HBASE, YARN, HIVE QL, Apache Spark SQL, Apache Airflow, Superset, Sqoop Database Tools: MySQL, PostgreSQL Talend, SSIS, SSRS, SSAS, Azure Data Studio, Toad Data Modeler, ER Studio Packages: NumPy, Pandas, SQLAlchemy, Scikit-Learn, Plotly, Streamlit, ggplot, Statsmodels, Matplotlib, Seaborn, MLxtend Certifications: AWS Cloud Practitioner, Tableau Desktop Specialist, Predictive Analysis using Python, Lean Six Sigma EXPERIENCEBarton Associates, Peabody, MA, USA Oct 2023 Present Business Intelligence Developer Executed strategic data migration and integration initiatives, empowering company-wide self-service dashboards for KPI analysis. Designed DOMO dashboards analyzing 10 years of finance data using ETL SQL, resulting in a 15% efficiency increase and informing strategic decisions on underperforming locations. Developed Salesforce CRM and NetSuite ERP integration using Celigo, achieving a 70% reduction in manual record creation and saving over 20 hours per week in Finance operations. Implemented daily automation converting 100+ timesheet PDFs, loading data into SQL Server and integrating it with Salesforce using Lambda functions resulting in 40% increase in data accuracy. Extracted data from Marketo API to perform user engagement, market campaign, and traffic analysis using Python, to support targeted marketing for clinicians. Participated in Agile methodologies, translating business requirements into technical specifications within cross-functional teams. ImmuneID Inc, Waltham, MA, USA July 2022 Oct 2023 Data Engineer II Spearheaded development of a comprehensive conceptual, logical, and physical relational data model to support LIMS. Designed efficient data pipelines using AWS Glue to ingest and streamline EMR data from multiple vendors by storing harmonized data in AWS RDS, resulting in a responsive and dependable system for end users. Extracted data from Neo4j NoSQL database using Cypher query language to analyze protein & gene information with precision. Engineered AWS Lambda functions for automating daily data transfer between Benchling API and AWS RDS, led to 80% reduction in manual effort for data extraction and transformation. Utilized Docker and ECR to package Lambda function code, dependencies, and runtime, streamlining deployment processes. Executed data migration process for 1TB+ data, from on-premises servers to AWS S3, optimizing resource utilization. Implemented ML pipeline to flag abnormal pipetting events in real time, preventing scientific experiment failures. Developed and deployed multi-page R Shiny applications for scientists and lab personnel, enabling efficient lab data capture. MultiPlan Inc, Naperville, IL, USA Oct 2021 July 2022 Software Quality Assurance Analyst II Responsible for testing Data Warehouse, ETL and Health Claims solutions using agile software development processes. Validated healthcare data of 90M+ rows by testing database from source to target in Oracle via SQL queries (utilized window functions, CTEs and complex subqueries). Maintained historical data of 20M rows in dimensional and fact tables using Slowly Changing Dimension type1, 2. Provided ad-hoc analysis solutions using Azure Data Lake Analytics and Hive QL to support end-to-end database testing. Created and maintained detailed, accurate, reusable test scripts and files to expedite regression testing. Logged and reported defects using JIRA; collaborated with developers to resolve issues so that delivered product performed as expected. Created Requirement Traceability Matrix, test plans, detailed defect reports outlining major requirements, which increased product quality and expedited product release. |
