Teja Alluru Email & Phone Number

Redmond, WA, US

Austin, Texas, United States

Collaborated with clients to understand their business requirements and objectives.Designed and implemented end-to-end Power BI solutions, including data modeling, ETL processes, and interactive dashboards.Conducted workshops and training sessions to educate end-users on Power BI functionality and best practices.Optimized performance and efficiency of.

Bellevue, Washington, United States

• Designed and built ETL pipelines in Azure data factory to extract data from source systems, maintain operational integrity and performance of internal SQL database.
• Developed and maintained dashboards and reports in PowerBI and Tableau for management review. Implemented new and efficient BI reporting process thereby converting tableau dashboards to PowerBI for efficient reporting.
• Built operational training procedure and documentation for business systems in BI domain.
• Provided governance, guidance, and determined best practices for all items related to BI like reporting systems, reports access and maintaining master data.
• Heavily involved in business system change and the impact of migrating to advanced systems like Saleforce, NetSuite & Marketo for the BI Datawarehouse team.
• Implemented data integration solutions using Azure Data Lake Storage and Azure Data Factory/Synapse to streamline data flow across the organization.

Tacoma, Washington, United States

Chaired the student committee responsible for allocating student technology fees,Presented the student technology fee committee's proposals for the allocation of student technology fees to the Executive Board and the board of regents,Negotiated on behalf of ASUWT with the Regents of the University and their designees to come to an agreement on student.

Tacoma, Washington, United States

With help of the Officers of the AI Club(INFORMS Chapter), AI Club had volunteered on several pro bono analytics projects in Tacoma and US community. The club worked IBM to test and create a use case study for the AIF360 toolkit to address bias & fairness in datasets. Under my supervision the club was able to achieve Magna Cum laude award from INFORMS for.

Seattle, Washington, United States

• Designed and built ETL script in SSIS to extract customer churn related data from different excel files and loaded into MS SQL database. Preformed diagnostic and descriptive analysis by processing 190GB of data to.
• Designed and built ETL script in SSIS to extract data from source systems.
• Collaborated with data scientists to deploy machine learning models in Azure, integrating predictive, diagnostic and descriptive analytics into data pipelines to identify the trends and correlation.
• Developed dashboards and classification model with 98% accuracy and 82% precision in predicting the customer churn in Azure ML studio.

Seattle (Remote)

Built course on AI fairness (AIF360 toolkit) to identify bias and mitigate bias in datasets for IBM/ Linux Foundation. Reduced bias disparate impact from 1.8 to under 1.2.Testing of IBM AI software toolkits.

• Tech Stack: Python, R, SQL, SAP, SSIS, Tableau, Microsoft Excel, PowerPoint, Word.
• Built ETL in SSIS to extract manufacturing defects from SAP to work on data science projects without effecting main manufacturing SAP line. Created and tested manufacturing defects clustering and prediction model using.
• Built ETL scripts in SSIS to extract manufacturing defects from SAP to work on data science projects without effecting main manufacturing SAP line.
• Explored, studied and documented Azure environment feasibility for migrating in-house data warehouse.
• Created manufacturing defects clustering and prediction model using R/Python to improve task turnaround time by 70% for MRO defects for A350 and A320 Aircrafts.
• Built tableau dashboards on frequent task turnaround times from past data to improve operational efficiency in clearing MRO tasks by 10% for A350XWB and A320 aircrafts.

Hyderabad Area, India

• Tech Stack: R, SSIS, SQL, SSIS, Mathcad, SAP, Microsoft Excel, Power point, Outlook, Agile process, FAA & EASA Documentation.
• Used SSIS to connect the data sources from SAP to SQL server and perform ETL to consume data for further data science projects. Formulated mathematical/statistical models to develop, evaluate or modify design in.
• Created dashboards in Tableau for estimating project costs and identifying optimal schedules for each job function resulting in 100% resource utilization.
• Led a team of engineers in providing engineering solutions to various clients and market sectors in data science domain through prediction and classification using R, which helped in bagging additional projects work.

• Tech Stack: SAP, Mathcad, Matlab, Microsoft Excel, PowerPoint, Word, Nastran, Patran, Mathcad, Aircraft stress analysis.
• Analyze defects data from SAP and built mathematical models in Mathcad to certify defects which helped in reduction of time to process oversize defects in real-time assembly line by 85%.
• Developed training modules for junior engineers and new hires to reduce department on-boarding time from 15 to 10 days
• Designed and tracked employee KPIs through graphical representation in Excel for implemented in auto-tracking to improve performance by 12%.

United Kingdom

• Tech Stack: SAP, Nastran, Patran, Catia, Ansys Microsoft Excel, PowerPoint, Word, Mathcad
• Liaised between Europe and Asian supplier plants to get manufacturing defects addressed on time in SAP to avoid impact on the final assembly line. Maintained 100% runtime.
• Analyzed aircraft component data for stress and to certify them for safety as per EASA and FAA standards.
• Formulated conceptual design through research of aeronautical or aerospace products to meet customer requirements. Certified new design for wing transportation for A350 Aircraft. Designed and tracked employee KPIs.

Seattle, Washington, United States

> Event management and organizing different cultural events and trips.>Attending planning meetings and facilitating events.

Greater Seattle Area

RESPONSIBILITY SUMMARY: >Helping professor in preparation of the class notes and distributing material to class students by email communication.>Grading homework, midterms, and finals.>Conducting office hours for students and helping students with assignments and class topics.

Greater Seattle Area

Responsible for identifying and discussing issues affecting the graduate and professional student body at the University of Washington.Get input from students in your department.Relay information from the Senate to students in your department.The Senate elects four officers and all internal GPSS committees, approves the annual budget, votes on resolutions.

Greater Seattle Area

• Oversees and approves the annual GPSS Budget
• Allocated funding for the Special Allocation Fund (special projects funding for Registered Student Organizations)
• Allocated funding for the Department Allocation Fund (special funding to build student communities in the UW’s various departments)

Hyderabad Area, India

RESPONSIBILITY SUMMARY: >Performing basic stress analysis using well-defined analysis tools to develop the structural program. Preparing stress reports/documentation for the aircraft tasks executed as per the EASA standards.>Executing technical tasks as per the standard methodology as per customer standards(AIRBUS)ACCOMPLISHMENTS:>Best team contributor.

Chennai Area, India

RESPONSIBILITY SUMMARY: >To perform R& D project estimating parasitic loss reduction in AL engine family by tweaking different variations of the engine cowling and fan blade configurations and thereby suggesting an optimum solution.ACCOMPLISHMENTS:>New engine fan cowl design has led to a reduction in engine load by 2.3%. This design has improved the engine.

Master Of Science - Ms, Business Analytics

Post Graduate Certification In Big Data Analytics & Optimization, Bid Data & Optimization

Certification, International Business

Activities and Societies: ASUW Senate, GPSS Senate, GPSS Budget and Finance .International business and business law

Bachelor Of Engineering (Beng), Mechanical Engineering

Activities and Societies: Aero Modelling Club, Technical Presentations ComitteeAero-modelling,

Master Of Engineering (Meng), Aerospace, Aeronautical And Astronautical Engineering

Activities and Societies: GPSS Senate, ASUW SenateGraduate senate Member, Under graduate student liaison,