I completed my Masters in Management Information Systems from Texas A&M University - Class of 2020 (My Greatest Moment!!)
Fast forward a few years, I am currently working as a Business Intelligence Data Engineer at Behavioral Health Group - BHG, a leading provider of opioid addiction treatment services. I have a passion for data engineering and analytics, and I am skilled in analyzing, integrating complex systems and ensuring high data quality for real-time reporting.
My objective is to leverage my skills to deliver a competitive edge to the organization, add value by enabling analytical decision making to drive top and bottom line growth Furthermore, I believe and enjoy making decisions based on the facts rather than on instincts and if the facts are unavailable then on probability
Working as a Data & BI Analyst at Strategic Materials, Inc. not only helped me to gain valuable experience but also made me realize I enjoy working on the end-to-end process from ETLing data to building out dynamic and insightful reports for the team. Other than applying my classroom-earned knowledge, I also received multiple perspectives towards data analysis, data warehousing (ETL), data visualization and most importantly a valuable experience working with employees on top of the organization chart
SQL, Python, DAX
PowerBI, Looker, ETL, Dimensional Data Modeling, SSMS, SSIS, SSAS, SSRS
RDBMS - SQL Server, PostgreSQL, Azure SQL DB, AWS - S3, Redshift, Athena, Glue, RDS, GCP, BigQuery
Airflow, Git, Statistical Modeling, Predictive Analytics, Neo4J
My work helped the employees to communicate effectively with the customers and help improve business with the organization # Key Contribution: Developed and automated dashboards, reports for internal departments such as financial, commercial, operations and supply using Targit BI, SQL and maintained Targit Data Warehouse (ETL in-memory tool)
Joined the data team to streamline reporting and optimize operational insights, and building actionable analytics. # Key Contributions: Cross-Department collaboration: Partnered with HR and Marketing teams to gather requirements, identify painpoints and define metrics for reporting ETL development: Expanded into creating ETL pipelines using Alteryx, a tool very heavily used at BHG to satisfy ETL requirements beyond SQL capabilities Executive-ready dashboards: Developed interactive Power BI dashboards to support strategic decisions Process improvement: Reduced ETL run time by 80% by replacing normal functionality to In-DB process in Alteryx
Promoted to BI Data Engineer based on strong business impact. Took on ownership of high-priority projects and began mentoring interns # Key Contributions: Technical leadership: Mentored Data Analyst interns—guiding them from translating business requirements to deploying data-driven solutions Executive collaboration: Partnered daily with C-suite leaders (CEO, CFO, COO, CMO, and VPs) to deliver insights that inform critical business decisions End-to-end data ownership: Designed and maintained ETL pipelines using Python, SQL, and Alteryx, loading transformed data into Azure SQL DB for analytics consumption Strategic impact analysis: Utilized SQL to evaluate % discounts within specific readmission windows (≤180 days, 181–275 days) is profitable. The goal is to identify the break-even point and optimal discounting strategy for acquisition decisions.
"I had the privilege of working with Arpita in the summer of 2019 where she was an intern on my IT team. She was FANTASTIC! She was brought in to help us get our BI initiative off the ground, and I would have been happy with a couple of dashboards or reports. Instead, her efforts allowed us to complete our BI project several months early. She enthusiastically jumped in and took the initiative to engage with key stakeholders up and down the org chart. She worked collaboratively with users from hourly operations staff to the COO and CFO with equal ability. Her combination of intellectual curiosity, pleasant personality and top shelf technical skills will serve her well as she starts her career. She will be an asset to whichever organization is lucky enough to employ her."
"I had the pleasure of working with Arpita for two years, collaborating on a couple of projects. Arpita is proactive and a tireless contributor who would make a great addition to any team. In participation with National level Hackathon'2018 competition, our program was crashing due to a few logical fallacies and all of the team members had to sit and wait as we sorted the problem out. While Arpita impressed all of us by transforming the ensuing awkward silence into a lively icebreaker discussion among everyone. Throughout these years , Arpita completed the projects on time and never failed to add a creative touch when appropriate. I would highly recommend her for any position, as she naturally rises to the occasion when presented with something she is passionate about."
"Arpita is a self motivated and independent girl who likes to take up on challenges and successfully tackles them. Academics is her forte and she is technically extremely sound. Ability to analyse the problem makes her stand out. Data analysis is something she excels in since I have known her in the capacity of instructor for database class. She is a great team player and knows the best how to take all team members along. She thrives for perfection. Being a solid coder, makes her and in turn everyone's life easy. She is an asset for any team working with her."
"I supervised Arpita as part of MIT Pune's technical festival MIT Texephyr during her sophomore year as part of the Core Committee for Design. Arpita was a very proactive member of the committee who completed her tasks diligently and with high level of competence. Apart from this, Arpita managed to maintain her excellent grades while working with us, a feat that only very few people have managed to do. Arpita also displayed great management and leadership skills when she overtook more responsibility during subsequent years. It gives me deep honor to recommend her for her endeavors."