About
I am a data professional with a strong educational background and over seven years of
experience in the field. In May 2023, I graduated from the University of Connecticut, where I honed my
skills in data engineering, analytics, and machine learning through a combination of rigorous coursework and
hands-on projects. Throughout my career, I have excelled in leveraging cloud technologies to streamline ETL
processes and optimize data processing for seamless deployment, consistently delivering production-ready
projects on time. My expertise extends to database schema modeling and design, encompassing both relational
databases such as Oracle, SQL Server, and PostgreSQL, as well as NoSQL databases like MongoDB and Cassandra.
I am proficient in implementing ETL processes using tools like AWS services, SSIS and Apache Airflow and
Snowflake services.
Python is my go-to language for backend configurations, data manipulations/transformations and workflow
automation, supported by libraries such as Pandas, NumPy, Matplotlib, TensorFlow, and scikit-learn, as well
as Plotly for data visualization. I have successfully managed projects using industry-standard tools like
Jira, Terraform, GitLab, and Confluence, fostering seamless collaboration. My skills also extend to data
streaming using PySpark, Kafka, and Apache Airflow, as well as a demonstrated proficiency in big data
technologies like Hadoop, Hive, and Sqoop. I take pride in my ability in managing my team and mentor them,
promote continuous learning, and uphold high standards in data engineering practices. Additionally, I excel
in data migration, cleansing, and profiling, ensuring data accuracy and quality throughout the data
warehousing process. While my primary expertise lies in AWS, I have also briefly worked with Azure services
such as Azure VMs, Blob Storage, Azure Functions, Azure Synapse, Azure Data Factory, and Data Lakes, adding
versatility to my skill set.
Multifaceted Data Professional: Bridging Data Science & Data Engineering
I specialize in seamlessly bridging the worlds of Data Science and Data Engineering, leveraging my expertise to transform complex data into actionable insights and efficient data solutions.
- Birthday: Jan 10, 1996
- Mobile: +1 (860) 218-7219
- City: Hartford, Connecticut
- Personal-email: akshayraj.pallerla@gmail.com
- Highest Education: Master's Degree
- University: University of Connecticut
- Specialization: MS in Analytics & Project Management
- School-email: akshay_raj.pallerla@uconn.edu
Data professional with 7 years of experience, passionate to continue my career with an organization to utilize my experience and expertise in data-driven decision-making to benefit mutual growth and success. Versatile in Data Engineering, Analytics and Data Science.
Skills
With a diverse skill set encompassing Data Engineering, Analytics and Data Science, I am well-equipped to tackle complex data challenges and drive data-centric solutions. Proficient in Python, Tableau, SQL, and AWS, I excel in data manipulation, statistical analysis, and building scalable data pipelines. Additionally, my expertise extends to Machine Learning algorithms, NLP, and Data Visualization, enabling me to extract valuable insights and present compelling data-driven stories. Alongside having worked in an Agile Scrum environment, I possess strong analytical reasoning, problem-solving, and project management skills, allowing me to deliver impactful results and contribute to the success of any data-driven project.
Resume
I am delighted to present a collection of my professional journey, showcasing my expertise in the Data world.
Summary
Akshay Raj Pallerla
With a Master's degree in Analytics and Project Management, having had hands-on experience in Python, SQL, and a wide array of data tools, I am committed to delivering data-centric solutions that drive business growth and success. My expertise working in Agile-Scrum environment further enables me to adapt seamlessly to dynamic project requirements, collaborate effectively with cross-functional teams, and deliver high-quality results with iterative efficiency.
- 250 Main St, Apt #330, Hartford, CT 06106
- (860) 218-7219
- akshay_raj.pallerla@uconn.edu
Education & Experience
Master of Science in Analytics & Project Management
Jan 2022 - May 2023
University of Connecticut - School of Business
- GPA: 3.9/4.0
- Relevant Coursework: Predictive Modeling, Data Science using Python, Visual Analytics, Big Data Analytics with Cloud Computing, Data Management & Business Process Modeling, Data Mining & Business Intelligence, Web Analytics, Statistics in Business Analytics, Intro and Adv Project Management, Project Risk Management, Project Leadership Communications, Advance Business Analytics Capstone, Business Decision Modeling, Technical Communications
GRADUATE ASSISTANT DATA STEWARD
Feb 2022 - Apr 2023
University of Connecticut, Hartford, CT
- Streamlined data integration processes by implementing automated ETL workflows, reducing data processing time by 40% and improving data accuracy by 25%.
- Developed and maintained financial data models and databases, enabling efficient storage and retrieval of financial data for budgeting, forecasting, and financial analysis purposes.
- Collaborated with cross-functional teams, including finance analysts and administrators, to gather data requirements and designed and implemented robust data pipelines for data availability in financial reporting.
- Led the implementation of a data governance framework for financial data, ensuring compliance with regulatory requirements and improving data security and privacy controls.
- Created interactive financial dashboards and reports using data visualization tools, such as Tableau, enabling finance stakeholders to gain actionable insights from financial data, resulting in a 15% improvement in data-driven decision-making.
- Enhanced financial data quality assurance processes, implementing data validation checks and anomaly detection mechanisms, resulting reduction in data errors.
Data Analyst
Jun 2016 - Apr 2017
MyVerkoper, Hyderabad, India
- Produced monthly performance reports using sales and marketing data, with automated email delivery for authorized users. Monitored KPIs: sales revenue, customer satisfaction, acquisition costs.
- Spearheaded efforts to enhance data accuracy and accessibility, resulting in a notable 30% reduction in manual data processing. Achieved this by streamlining the ETL process into Power BI dashboards.
- Pioneered the development of a real-time Power BI dashboard, that saved 10 hours per week in manual reporting tasks. This empowered effortless identification and analysis of company KPIs.
- Improved data retrieval efficiency by 25% through optimized procedures, mastering complex SQL queries (CTE, indexing, no locks, joins) for historical data analysis from data warehouses.
- Executed the creation of SSRS reports derived from SQL Server Analysis Services (SSAS) cubes. Leveraged DAX scripts to effectively query data from OLAP cubes.
- Collaborated with cross-functional teams to design data integration solutions that met the organization's needs by understanding business requirements and identifying data sources.
Professional Experience
Senior Data Engineer
Dec 2018 - Sep 2021
Accenture (Client: Charter Communications)
- Orchestrated and developed ETL pipelines using AWS Glue for automated data cataloging, and Python in the backend for data loads in downstream, reducing 10% the DOJ call-in rate for field technicians in the last quarter.
- Applied transformations like harmonization, deduplication, Change data capture using Python and lambda functions on usage data extracted from Athena ensuring accurate dataloads to AWS S3 buckets and AWS redshift.
- Implemented tech-mobile project re-architecture, providing guidance to the team throughout the process in creating intermediate tables for ad-hoc analysis with good scalability to allow stakeholders to query historic data based on a UID.
- Developed 9+ Tableau reports for digital platform insights analyzing call rates, work-order volumes, and other Tableau dashboards such as Techmobile score card for analyzing metrics on quantified issues and activation attempts.
- Utilized Prism to perform statistical analysis, identifying trend patterns, and API tagging based on event actions and API definitions used in data products while defining metrics for performance reports of ad campaigns through collaboration with cross-functional teams
- Delivered recurring production reports and Tableau dashboards on viewer metrics, engagement metrics, region-wise content performance, and financial analytics for Connectivity Insights product and collaborated with the team for feature enhancements deployed on a 30 million internet customer base.
- Automated infrastructure configurations using Terraform for the Data Science team to handle tech-Mobile application data and support workforce planning initiatives.
- Trouble-shooted data issues through monitoring, log analysis, data exploration, and analysis on large volumes for Techmobile and digital-ad insertion product lines using Elastic search in the Kibana tool.
- Supervised a team of 7 ETL developers in an Agile-scrum setup and engaged with stakeholders for supporting 5 product lines (IP video, tech-mobile app, set-top box, digital ad insertion, spectrum news)
- Leveraged technical expertise to support data-related aspects of the ad-insertion process in Business Intelligence applications by integrating the data from different sources before the ETL process.
Data Engineer
Jun 2017 - Nov 2018
Accenture (Client: Volkswagen: VW Credit, Inc)
- Developed stored procedures, functions, and views in SQL Server to perform complex calculations for banking applications like ROA/ROE, Loan to Deposit Ratio (LDR), Net-Interest Margins, Cost of Funds.
- Improved ETL solutions in SSIS, reducing the execution time for over 30 data products by 17% with optimized data retrieval & processing using transformations such as merge/anti joins, Derived Columns.
- Plunged dashboard refresh time by 12% through customer data unification by revamping older Tableau dashboards and optimizing SQL queries using CTE, indexing, ingestion scripts, and user-defined functions to track KPIs, ensuring uptime to stakeholders.
- Streamlined repetitive data collection, processing, & analysis through data pipelines to intermediate S3 buckets using AWS Lambda & Python scripts, resulting in a 30% reduction in processing time.
- Leveraged PySpark's distributed computing and DBFS for efficient file storage, effectively managing scalable Spark clusters with Databricks to drive significant, large-scale data transformations.
- Implemented self-service EMR clusters for trigger ETL jobs in a test environment using git hooks, saving 5 hours of manual efforts for testing data products.
- Maintained Snowflake databases, schemas, tables, views, and stored procedures, ensuring data consistency and accuracy throughout the data pipeline.
Extra Curricular Activities
- Program ambassador for the UCONN MS-BAPM program at Hartford, Connecticut. (2022-2023)
- Selected for the prestigious Accelerate UConn program - UConn's National Science Foundation (NSF) Innovation Corps (I-Corps) taught by professionals from the Massachusetts Institute of Technology along with an additional scholarship of $1000
- One of the members in the diverse team of MBA and MS-BAPM students selected to conduct research on macroeconomic factors and their impact on consumer sales, successfully establishing meaningful relationships to address LEGO's US sales forecasting challenges.
Projects
In my portfolio, you will find a diverse array of projects showcasing my expertise in data engineering, analytics, visualization and data science. From crafting predictive models and leveraging machine learning algorithms to creating interactive and insightful visualizations, each project exemplifies my commitment to extracting valuable insights from data and effectively communicating complex information through compelling visual representations.
- All
- Data Engineering
- Data Analytics
- Data Science and EDA
- Project Management
Endorsements
In my journey, I'm grateful to have received endorsements and recognition from colleagues, mentors, and industry professionals. These endorsements serve as a testament to my skills, dedication, and contributions in the fields of data engineering and analytics. I deeply value the trust and confidence others have placed in my abilities, and I am committed to continuing to deliver exceptional results in my endeavors.