Sritulasi Kilaru
Summary
Senior Data Analyst with 8+ years of expertise in BI reporting, analytics and data engineering practices. Skilled in creating dashboards using Power BI, Tableau and experience in querying and leveraging scalable data warehousing platforms like Amazon Redshift and Snowflake for advanced analytics and reporting. Proficient in SQL, PL/SQL, SSRS reporting and ETL processes. Utilizing tools like SQL Server, PL/SQL Developer and Dbeaver to ensure data integrity and performance. Ability to stay ahead of emerging data technologies and implement industry best practices to deliver efficient and scalable solutions.
Overview
11
11
years of professional experience
Work History
Reporting Analyst| Data Engineer
University of Phoenix
09.2018 - Current
- Perform all phases of report development, including intake from a request queue, transformation or acquisition of data, report creation, and documentation of processes
- Translate business requests into well-defined data solutions, acquire data from multiple sources, and develop reports to address the immediate needs while anticipating future inquiries
- Developed visually appealing Power BI dashboards using advanced visualizations, DAX calculations, and KPIs to provide actionable insights and real-time performance monitoring for leadership teams
- Ensured data accuracy and security by validating Power BI datasets and implementing Row-Level Security for confidentiality and compliance with organizational standards
- Led UAT and deployed Power BI and SSRS reports, configuring scheduled refreshes, workspaces, and ensure seamless user access and report availability
- Provided training to end-users on how to navigate and extract insights from Power BI reports and dashboards and getting started with AWS Redshift, offering ongoing support
- Facilitated the migration of SSRS reports from legacy system to AWS Redshift for improved scalability and performance
- Designed, developed, and delivered comprehensive reporting solutions using SSRS, including parameterized reports, display key metrics, trends, automated subscriptions, and tailored dashboards to ensure timely and accurate insights for various departments
- Design, build and deploy SSIS packages, data extraction, transformations, and loading across diverse sources, ensuring data quality data integrity and error resolution
- Experience in Snowflake data modeling and ETL using snowflake SQL implementing complex stored procedures and best practices with data warehouse and ETL concepts
- Created stored procedures, joins, views, subqueries, and CTEs across multiple tables and databases, with hands-on experience in Redshift, SQL Server, and Oracle for complex query execution and data transformation using T-SQL, PL/SQL and PostgreSQL
- Worked with diverse tools and applications, including Amazon S3, HVR, Kafka, MremoteNG, Informatica, and Apache Airflow, gaining knowledge and hands-on exposure
- Familiar with querying structured and semi-structured data using Databricks SQL for generating actionable insights
- Collaborated with cross-functional teams to create Python driven reports that combine data from multiple sources, offering deeper insights into key performance indicators and business trends
- Utilized SourceTree, Bitbucket to create branches, clone repositories, and commit changes to ensure version control and smooth deployment processes
- Familiar with mathematical and statistical software like R for data analysis and predictive modeling
- Peer-reviewed code for Legal and Regulatory reporting thorough reviews of code from various departments to ensure accuracy, compliance, and adherence to reporting standards
- Used JIRA to facilitate daily stand-up meetings, manage sprint planning, and track customer support requests through effective ticket management
- Environment: Visual Studio, SQL Server Management Studio, Oracle, Redshift, Dbeaver, SQL Server Integaration Services, SQL Server Reporting Services, T-SQL, PL/SQL, Power BI, Source Tree, Bitbucket, Jira, Snowflake DataBricks
Data Analyst
United Health Group
01.2017 - 09.2018
- Gathered user requirements to develop business logic, analyze data needs, and define business requirements for reporting and analytics
- Created custom reports, sub reports, drill-down and data-driven reports in SSRS, utilizing multiple datasets, complex expressions, and parameterized queries to provide accurate and actionable insights to business stakeholders
- Created and formatted daily, weekly, and monthly reports while ensuring high-quality code
- Developed Power BI dashboards and reports by transforming data from SQL Server and Oracle into actionable visualizations, enabling real-time decision-making with scheduled data refresh
- Created and deployed SSIS packages for ETL processes, extracting data from diverse sources (SQL Server, Flat Files, Excel) and transforming it into warehouse-ready formats
- Designed and developed interactive dashboards in Tableau and used advanced features such as calculated fields, data blending, and dynamic filters to create insightful reports and visualizations from multiple data sources
- Familiar with Python for handling large datasets, performing data wrangling, and generating insights for business users
- Understanding of Snowflake data warehousing concepts
- Leveraged Snowflake for data transformation and secure sharing across business units and external partners, enhancing collaboration
- Knowledge on Azure SQL Database and Azure Cosmos DB for scalable data storage solutions
- Created database objects (tables, views, and indexes) in SQL Server and Oracle to optimize query performance and meet application requirements
- Used TFS for source control, data collection, project tracking purposes and deployment
- Maintained existing reports and participated in functional meetings to design data models
- Participated in functional meetings to understand various source systems and was involved in design of data model for Warehouse
- Environment: T-SQL, SSIS, SSRS, Power BI, SQL Server, PL/SQL Developer, Power BI, Tableau, TFS, Python
BI Analyst|SQL Developer
Xoomsys Technologies
01.2014 - 12.2014
- Actively participated in requirement gathering, design, and development of applications, ensuring alignment with business needs
- Created and deployed basic SSRS reports, including designing layouts, defining data sources, and aggregating data to meet business requirements
- Designed, developed, and optimized ETL processes using SSIS and Informatica, integrating data from multiple sources and ensuring data quality
- T-SQL for optimizing and writing queries like joins, sub-queries
- Knowledge on data warehouse schemas, implementing dimensional modeling and OLAP concepts for high-speed querying and analysis
- Worked closely with stakeholders to identify and define business requirements for data warehousing and analytics solutions
- Environment: SQL, SQL Server, SSIS, SSRS
Education
Master of Science - Electrical and Computer Engineering
New York Institute of Technology
01.2016
Bachelor’s in technology - Electrical and Electronics Engineering
Jawaharlal Nehru Technology University
01.2014
Skills
- SQL Server
- Oracle
- Redshift
- Power BI
- Tableau
- SSRS
- SSIS
- Amazon Redshift
- Snowflake
- Databricks
- Git
- GitHub
- Bitbucket
- SourceTree
- SQL
- T-SQL
- PostgreSQL
- Python
Timeline
Reporting Analyst| Data Engineer
University of Phoenix
09.2018 - Current
Data Analyst
United Health Group
01.2017 - 09.2018
BI Analyst|SQL Developer
Xoomsys Technologies
01.2014 - 12.2014
Master of Science - Electrical and Computer Engineering
New York Institute of Technology
Bachelor’s in technology - Electrical and Electronics Engineering
Jawaharlal Nehru Technology University
Similar Profiles
Matthew CapizziMatthew Capizzi
Lead Data Reporting Specialist – StAS Compliance at University of PhoenixLead Data Reporting Specialist – StAS Compliance at University of Phoenix
Nyra TannerNyra Tanner
Senior Academic Counselor at University of PhoenixSenior Academic Counselor at University of Phoenix
Sai KiranSai Kiran
Sr. DevOps & AWS Engineer at University of PhoenixSr. DevOps & AWS Engineer at University of Phoenix