Ravi Telekicherla
Frisco,TX
Summary
Sr. Business Analyst with experience working in the Information Technology sectors and adept in dealing with large-scale development and business process improvement solutions in diverse environments.
Experienced business systems professional with strong focus on optimizing processes and enhancing system efficiency. Known for fostering team collaboration and delivering tangible results in dynamic environments. Expertise in business analysis, data modeling, and project management. Adaptable and dependable, consistently meeting evolving organizational needs while ensuring successful outcomes.
Overview
16
16
years of professional experience
Work History
Sr. BUSINESS SYSTEM ANALYST
T-Mobile
Bellevue, WA
11.2014 - Current
- Experience working in Agile methodology and managing sprints to achieve business goals.
- Created ETL processes to process data from different sources into Delta lake using Azure.
- Created parameterized processes to extract data from parquet and json files into Azure data warehouse and Azure data lake storage using databricks notebooks using python and spark sql.
- Responsible to handle large sets of data from multiple sources for compensation calculations.
- Created processes for Intraday reporting to predict daily sales and Power BI reports for management.
- Writing SQL reports and developing complex queries across multiple servers, databases, and tables for the purpose of data consolidation, normalization, processing, validation and reporting.
- Created SSIS packages to automate processes eliminating manual intervention and effort.
- Experience in understanding business requirements and translating them into functional documents for the solutions architects and developer team. Understanding the technical aspects of the project helps me communicate effectively between the business team and the technical team.
- Identified and documented Issues, risks and gaps and their descriptions and impact, and provided recommendations and alternatives.
- Experience working with teams to help ensure projects are meeting deadlines and within the budget.
- Create user stories, maintain backlogs and perform retrospectives to understand any process improvements and identify bottlenecks.
Technical Lead/Sr.Developer
Intel Corp
Aloha, OR
02.2012 - 11.2014
- Expertise in Agile methodology, project management and handling large teams for projects.
- Worked with Business users to understand the business requirements.
- Created Analysis and Design documents as per the business requirements.
- Created test cases for a process to test the quality and performance of the process.
- Designed and developed SQL SSIS Packages to extract data from various data sources such as Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
- Writing SQL reports and developing complex queries across multiple servers, databases, and tables for the purpose of data consolidation, normalization, processing, validation and reporting.
- Sustaining and implementing solutions for deployed software systems through collaboration with members of project management, business, and develop teams leveraging multiple system development lifecycle (SDLC) approaches, including Waterfall, DevOps, and Agile for the purpose of ensuring a relevant and useful system lifecycle for the end users.
- Performed quality control testing using HP Quality Center and filing tickets using ticketing systems like MS Team Foundation Server, Remedy and salesforce to drive tracking and timely resolution of issues.
- Created and when required, modified already existing stored procedures, triggers, views, indexes.
- Resolved ADO Dot net issues for user acceptance testing.
- Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
- Experience in creating SQL scripts, stored procedures and views for manual processes and automations.
- Build and maintain SQL scripts and complex queries for data analysis and extraction.
- Creating weekly sales report and data visualization report (e.g. pie charts, bar graphs) for senior leadership team.
- Created data visualization reports, charts and bar graphs for the Senior leadership team to help understand the growth of the products and help drive key business solutions.
Admin/Programmer Analyst
Constellation Brands
Victor, NY
02.2010 - 12.2011
- Maintained Hyperion, Oracle and On-prem servers to track and monitor successful completion of daily jobs.
- Debugging server issues to remove bottlenecks and monitor traffic across multiple systems.
- Created Analysis and Design documents as per the business requirements from heterogeneous information sources.
- Extracting data from data warehouse solutions from Teradata using Teradata SQL Assistant.
- Consolidated business rules for system enhancements.
- Created a streamlined process for our Finance partners in setting up processes and workflows for various ledger accounts.
- Created and maintained standard operating procedures governing system functions and features.Involved in creating the Functional Specification Documents and Business Required Documentation for Business Development.
- Analyzed data and implemented encryption for financial data thus maintaining enhanced security while dealing with finance data.
- Create and maintain the Sprint tickets for the team and track the progress using JIRA.
- Extracting data from Data warehouse including MS SQL Server for statistical and regression analysis.
- Responsible for gathering requirements, design data flow processes from subject matter experts for current and future state procedures.
- Developed prototype of new information processing application. Facilitated collection of functional requirements from system users.
- Identified and documented Issues, risks and gaps and their descriptions and impact, and provided recommendations and alternatives.
- Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
Education
Bachelor's - computer science
MVGR College of Engineering
IndiaMaster's - computer science
Northwestern Polytechnic University
Fremont, CASkills
- Research and analysis
- Azure
- Databricks
- Finance operations
- Commissions payment
- Requirements gathering
- Data migration
- Agile expertise
- Report preparation
- Competitive analysis
- Predictive modeling
- Workflow analysis
- Business planning
Timeline
Sr. BUSINESS SYSTEM ANALYST
T-Mobile
11.2014 - Current
Technical Lead/Sr.Developer
Intel Corp
02.2012 - 11.2014
Admin/Programmer Analyst
Constellation Brands
02.2010 - 12.2011
Bachelor's - computer science
MVGR College of Engineering
Master's - computer science
Northwestern Polytechnic University