Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ajay Reddy

McKinney,TX

Summary

Proactive Sr. Technical Program Manager and Lead Analyst with extensive experience in business analytics, data warehousing, and BI development. Proven success in developing training programs, strategic planning, and agile methodologies. Strong skills in SQL, data visualization, ETL processes, and stakeholder collaboration to drive informed decision-making and optimize performance. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Sr. Technical Program Manager/Lead Analyst

Microsoft
03.2022 - Current
  • Created training program that enabled employees to maintain and improve skills in various types of software packages.
  • Collaborated with leadership staff to determine appropriate budgets.
  • Assessed expected technical challenges and developed proactive solutions.
  • Contributed to the development of long-term strategic plans through comprehensive industry trend analysis and forecasting models.
  • Collaborated with stakeholders to develop actionable insights from complex datasets, driving informed strategic decisions.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Created dashboards to monitor and track key performance indicators.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Performed risk management assessments on projects.
  • Developed and implemented curriculum and training materials appropriate for use at all skill levels.
  • Worked closely with other departments to better understand product features and develop appropriate training materials.
  • Enhanced product development for streamlined processes through implementation of agile methodologies.

Sr. Business Analytics Specialist/Technical Lead

Microsoft
12.2017 - 02.2022
  • Collected, arranged, and input information into database system.
  • Optimized customer experience by delivering superior services and effectively troubleshooting issues.
  • Maintained database systems to track and analyze operational data.
  • Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
  • Proved successful working within tight deadlines and a fast-paced environment.
  • Led a team of developers to successfully deliver high-quality software projects on time and within budget constraints.
  • Coordinated with cross-department teams like QA, DevOps, and Support to ensure seamless end-to-end software delivery process.
  • Teamed on development of technology roadmap spanning [Number] years.
  • Coordinated with stakeholders to define project requirements, ensuring alignment with business goals and customer needs.
  • Enhanced team productivity by implementing agile methodologies and promoting continuous integration and deployment practices.
  • Led development of new software architecture, significantly reducing system downtime and improving user experience.
  • Built databases and table structures for web applications.
  • Conducted data modeling, performance and integration testing.
  • Gathered, organized and input information into digital database.

Senior Data Analyst/BI Consultant

Inviso Corporation
07.2015 - 11.2017
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
  • Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
  • Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
  • Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
  • Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
  • Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
  • Led team in adoption of new data visualization tools, which improved stakeholder understanding of complex information.
  • Provided technical support for troubleshooting analytics and reporting issues.

BI Consultant/SQL BI Developer

Aditi Technologies
07.2013 - 06.2015
  • Collaborated with cross-functional teams to ensure successful BI project delivery within deadlines.
  • Managed the full lifecycle of BI projects from requirement gathering to final implementation and post-launch support.
  • Developed automated reporting solutions to save time and reduce manual effort in generating reports.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
  • Streamlined database performance by optimizing SQL queries and implementing indexing strategies.
  • Developed complex ETL processes, ensuring accurate and timely data movement between source and target systems.
  • Designed and implemented TSQL queries for reporting and complex solution development.

SQL BI Developer/Data Warehouse Analyst

SVIT INC
12.2011 - 06.2013
  • Developed custom database objects, stored procedures and delivered application support.
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Performed regular database backups to prevent information loss.
  • Reduced query response time with database optimization strategies and indexing techniques.
  • Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.
  • Mapped data between source systems and warehouses.

Education

Master of Science - Engineering

Lamar University
Beaumont, TX
12.2010

Bachelor of Science - Engineering

JNT University
Hyderabad, Telangana, INDIA
03.2008

Skills

  • Agile project management
  • Client Relationships
  • Technical architecture
  • Training and mentoring
  • Project Leadership
  • Business Analysis
  • Agile Methodologies
  • Software Development Lifecycle
  • Gathering requirements
  • Technical Writing
  • Problem-solving skills
  • Strong analytical skills
  • Trends Analysis
  • Team Collaboration

Certification

  • Certified [Job Title], [Company Name] - [Timeframe]

Timeline

Sr. Technical Program Manager/Lead Analyst

Microsoft
03.2022 - Current

Sr. Business Analytics Specialist/Technical Lead

Microsoft
12.2017 - 02.2022

Senior Data Analyst/BI Consultant

Inviso Corporation
07.2015 - 11.2017

BI Consultant/SQL BI Developer

Aditi Technologies
07.2013 - 06.2015

SQL BI Developer/Data Warehouse Analyst

SVIT INC
12.2011 - 06.2013

Master of Science - Engineering

Lamar University

Bachelor of Science - Engineering

JNT University
  • Certified [Job Title], [Company Name] - [Timeframe]
Ajay Reddy