Hareesh Reddy Sama

Energy Efficiency:

One of our primary products, Behavioral Energy Efficiency Programs, provides for a significant portion of the income from North American utilities. With the support of hyper-personalized home energy reports and timely reminders, it helps utilities achieve their savings goals by instilling behavioral change in their customer's energy usage habits.

Responsibilities:

• Following the standard overhauls, blockers on numerous assignments through standard scrum calls with group based out in India and Making sprint arranging through week after week calls with US group.
• Managed key tasks and resources to achieve cost, schedule, and strategic growth initiatives.
• Increased annual revenue by 15% by recommending improvements in energy efficiency program design.
• Created a framework that helps analysts to create AB groups based on different parameters, resulting in a 70% reduction in work hours.
• Researched and compiled tailored monthly analytics and reports for senior management using matplotlib, seaborn, and G-suite.
• Identified, measured, and recommended improvement strategies for KPIs across business areas.
• Implemented randomized and stratified sampling techniques and statistical tests to design A/B experiments.
• Applied statistical and algebraic techniques to determine the energy savings & AB experiments results.
• Performed root-cause analysis on program performance degradation and recommended corrective measures proactively.
• Created and implemented new forecasting models to forecast energy savings.
• Created a framework that analyzes large amounts of data to identify trends and find patterns, signals, and hidden stories and anomalies within data and improves accuracy and efficiency by 3x.
• Created 30+ interactive dashboards using Looker that helps the product team and CSMs make critical decisions for various line of business.
• Monitoring multiple program performance pro-actively with help of KPIs that are being tracked in custom-built dashboards. This helps CSMs and delivery managers to take project-related critical decisions at early stages of issue identification.
• Automated regular workflows as a part of process optimization using python & shell scripting.
• Created a generic monitoring & notification system that keeps track of various automated jobs and sends important alerts over different channels.
• Coached and mentored data analysts and business analysts on data cleaning and mining techniques, visualization skills, and hypothesis testing.
• Technologies Used: Python, Unix,AWS Redshift, MS SQL, S3, EC2, Looker, Tableau, Git, G-Suite, Postman, SQL Workbench, Anaconda , Anypoint Studio, Jenkins, Red Hat Openshift.

Retail Operations, I-Tunes & I-Care:

Our client is a big electronic consumer goods manufacturer with revenue of around 250 billion USD and well established all over the world. We developed multiple interactive dashboards for each line of business that aid senior stakeholders to make more accurate business-related decisions.

Responsibilities:

• Used Kafka messaging services for real-time streaming of data to support live dashboards during major campaigns.
• Tuned complex queries and views which are used by Tableau dashboards to improve dashboard performance and decrease database resource utilization.
• Analyzed business requirements and created functional requirements specifications to build and deploy solutions.
• Developed tables, views and materialized views using SQL.
• Utilized data visualization tools to effectively communicate business insights.
• Identified, analyzed and interpreted trends or patterns in complex data sets.
• Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
• Worked with business intelligence software and various reports to glean insights into trends and prospects..
• Trained team members in developing worksheets, dashboards, workbooks, and stories using various features in Tableau.
• Technologies Used: Tableau, HP Vertica, Python, Unix, Kafka

EDW & Cross DB FrameWork:

Enterprise Data Warehouse is a ETL project that involves data extraction from different sources and transforming it as per business requirement and load it to the central data warehouse.

Developed a framework that helps cross database migrations and evaluating database object structures (i.e, DDLs) before deployment.

Responsibilities:

• Used Python, Bash/Linux shell scripting to design and update databases and to develop cross DB Framework.
• Improved application performance by 4x using multi-thread and multi-processing features.
• Designed compliance frameworks for multi-site data warehousing.
• Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
• Employed data cleansing methods, significantly Enhanced data quality.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Developed mappings, workflows and tasks using Informatica Power center 9.1x. Mapped data between source systems and warehouses.
• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
• Completed quality reviews for designs, codes, test plans and documentation methods.
• Technologies Used: Python, Unix, Informatica Power center 9.1x, HP Vertica, Teradata, MS SQL and Git.

Py Digital Wallet:

• Py-Wallet is a web application developed using python and Oracle databases and OOPS design concepts.
• Project has various sub-modules like login, ticket booking, bill pay, recharge, split bills, add money, and nearby. Each module is being developed as per business requirement and tested its functionality fully. Code reviews are done to improve performance of app.
• Once after unit testing is completed for all modules. Integrated all modules and deployed it to SIT for testing team to test it. Post SIT phase application has been deployed to UAT for user acceptance testing and then to pre-prod and prod after rigorous testing and fixes.
• Developed and implemented personalized client solutions using programming language expertise
• Technologies Used: Python for client side and server side coding & Oracle for storing application data.