Power Bi Data Warehouse
Resume:
Hanuma Lokireddy
*******@*****.***
TECHNICAL SKILLS
Skills: Microsoft Azure, AWS, Apache Spark, Hive, Kafka, Data Lake, Azure Data Factory (ADF)
Analytical Tools: Tableau, Power BI, SSAS, Business Objects, KPI’s
Project Management: Team Leadership, Agile Methodologies, JIRA, Confluence, Scrum, Kanban, Waterfall
Programming Languages: Python, Databricks, .Net
Databases: SQL, Snowflake, Azure Synapse, MongoDB, Redshift, Oracle, DB2, Erwin, SQLDBM, ETL, PLSQL, Informatica, SSIS
WORK EXPERIENCE
ABM industries Atlanta, GA
Enterprise Data Architect Jun 2023 - Mar 2024
Designed and developed scalable azure cloud data architecture to process millions of records daily from EV charging and parking stations
Worked with stake holders to gather the requirements, worked with data and BI teams, monitored daily work, mentored and improved team productivity by 30% and turnover by 30% through skill development program helped team members to improve talent and performance in delivering service excellence
Collaborated with senior leadership to define and execute the strategy, roadmap, successfully delivered projects on time, within the budget, with increased performance, and data quality benchmarks helped monetary growth by 25%
Skilled in planning, execution, monitoring, and closing projects effectively, proven ability to lead and inspire teams toward achieving project goals.
Conducted meetings, code reviews and provide feedback to engineers and testers for complex deliverables and oversee deployments in CI/CD pipelines
Strong technical background of database management, development, and migration of data (ETL) from different source systems into data warehouse
Designed and developed Power Bi dashboards for visualizations, KPI’s and for advanced analytics for business and senior leaders
Enhanced customer experience by 50% on Power BI dashboards, created a proof of concept to gain trust with stakeholders
Implemented agile practices to deliver projects within the given timeline, with in the budget
Tools: Microsoft Azure, Synapse, SQL, Python, Data Lake, Cosmos DB, GitHub, Power BI, Azure Databricks, data warehouse
First American Financial Corporation Santa Ana, CA
Senior Data and BI Architect Jun 2022 - May 2023
Worked with stake holders and business teams to gather the requirements, worked with the team, Designed and developed data pipelines to migrate title insurance data from HIVE, Impala to azure data lake storage and Synapse
Completed complex technical data transformations, deployment, and CI/CD pipelines
Expertise in managing and analyzing data, ensuring data quality and governance. experience in building or maintaining analytics solutions.
Implemented data quality management to ensure data integrity, reliability, accuracy of data and continuously monitored and data metrics
Created roadmaps, architectural design, pipelines for loading large volumes of data into snowflake, increased performance by 60%
Collected title closing data from different county websites, cleansing unstructured data, worked with data science teams and loaded synapse data warehouse
Designed Power BI visualization, API’s, Analytics to show counts and revenue by day, week, month improved comparisons by 25% and growth by 30%
Implemented agile practices to deliver projects within the given timeline, budget, increasing the productivity of the data and BI
Tools: Azure, Synapse, Data Lake, Python, GitHub, Power BI, HIVE, Impala, Azure SQL, Stored Procedures
Lennar Homes Miami, FL
Senior Data and BI Architect Mar 2020 - Mar 2022
Designed the architecture to load the data from home builder, mortgage and title divisions into Azure synapse data warehouse
Understanding of construction-specific processes, data, and challenges, experience working with a construction company
Designed pipelines, data flows from SQL, Oracle to data lake storage in Azure and migrated to data warehouse
Designed and developed dashboards, KPIs and Analytics to support all three divisions to make sure they are in sync with property closings
Participated in a 24/7 relation to support customers across the global regions, effectively resolved issues, including those for VIP customers
Successfully completed the Projects using agile practices to produce desired outcomes within the budgeted time that increased the home sales, mortgage and title closings by 90% on time
Worked with MDM and data governance teams, implemented multidomain Master Data Management
Achieved 30% cost reduction by implementing a smart capacity monitoring system, resulting in monthly savings by $100K
Ensured and controlled the health, resilience, and performance of data platforms, pipelines, data governance and master data management
Tools: Azure SQL, Synapse, Python, Power BI, ADF, Stored Procedures, SQL, oracle
Magic Leap Plantation, FL
BI Architect/ Sr. Consultant Oct 2017 – Dec 2019
•Responsible for delivering all kinds of dashboards, data visualizations, KPI’s, data analytics
• Managed cloud data BI platform and Advanced Analytics initiatives
•Provided guidance and support for career development, skill enhancement, and professional growth within the team.
•Developed cross-functional collaboration with analytics, and business teams to ensure data platform initiatives are aligned with organizational goals.
•Created data strategy to build an Enterprise data warehouse from scratch by working with regional and enterprise business teams
•Skilled in system and tool selection for data warehousing, ETL, BI, and data governance
•Enhanced customer support service by 100%, improved operational efficiencies and cost savings by $100K per month, managing teams, data architecture, modeling, and ETL design with a focus on performance, data quality and security
•Strong ability to work with 12 -14 members of the team, designed and developed pipelines, advanced visualizations
•Worked with management teams to provide technical solutions, data visualizations based on the requirements
Tools: AWS, Redshift, SQL, Snowflake, Snow pipe, Python, Google cloud, oracle, Tableau, Salesforce
ADT Security Boca Raton, FL
Sr. Consultant Jun 2016 - Aug 2017
•Responsible for BI and data warehouse projects design Architecture, data integration of ADT and protection one data into enterprise data warehouse
•Responsible for Visualization of the scorecard dashboards, advanced Analytics design and development, high availability, disaster recovery, administration, KPIs and support for over 15,000 users
•worked with business leaders, stakeholders, developed Dashboards for Future Recurring Monthly Revenue, predictive analytics, site counts by Region, Area and Branch
Tools: Azure, data lake storage, SQL, Power Bi
Banyan Health Systems Miami, FL
Director of IT- Data Warehouse & BI Mar 2015 - Mar 2016
•Designed enterprise data warehouse architecture from scratch
•Managed a team of 14-16 employees consisting of Data Engineers, BI developers, and analysts
•Established cross-functional relationships for requirements gathering and advanced reporting
•Worked with stakeholders, interface team, claims and payments teams
•Managed $8 M budget for cloud data platform and Advanced Analytics initiatives
•Improved team efficiency through standardization of processes and reusable templates
•Designed ETL process to minimize redundancy and improve performance and data accuracy from multiple clinical systems
•Developed policies, procedures, processes for the Business Intelligence team, DW and Database teams
Tools: Microsoft Azure, Synapse, Azure SQL, Power Bi, HL7, oracle
Imperial Tobacco- Altadis Fort Lauderdale, FL
Lead Consultant Jan 2013 – Feb 2015
•Responsible for designing the ETL process from different source systems and flat files into staging, merging the data into current DW and Data mart to increase the performance of the ETL process. Design changes to the existing operations finance data marts, cubes by adding new calculated measures and dimensions to improve processing time from 16 hours to 3 hours
•Responsible for designing the 2 Terabyte database for staging, integration, migration into data warehouse
•Premium Hyperion Project- Validated the servers analyzed the conditions to improve the system performance
•Led stakeholder’s meetings, migrated the databases, involved in the performance tuning of the databases
Tools: SSIS, SQL, SSAS, Business Objects, Crystal Reports, Power Bi
Baptist Health South Florida Miami, FL
Senior Developer / Lead Jan 2008 – Dec 2012
•Developed Total Rewards statements for 24,000 employees using data from different sources, SQL and .NET
•Designed ETL’s for multiple data platforms, worked as a Manager for Physician Performance Review project, and designed the reports and dashboards for the hospital’s executives, improved their efficiency by 50%
•Worked with clinical data, HL7 interface, pharmacy and life sciences data in healthcare environment, used FHIR to create mobile health apps
•Worked with Electronic Data interchange (EDI) with 837 and 835 for payment claims and created ABC analysis reports based on top n items
•Developed ETL processes for clinical systems like Centricity, Pathway’s healthcare system, T System, and SMS for clinical data analysis, dashboards
•Designed roadmap for data warehouse, reporting, analytics, and dashboards for entire organization, and led Lawson employee and RN retention data warehouse project with functional design and end-user assistance
Tools: Informatica, SSIS, SSAS, .NET, HL7, EDI, FHIR, Java, SQL, Oracle, DB2, Hyperion, Teradata
EDUCATION
Master’s Degree - Sri Venkateshwara University, India
CERTIFICATES
Post Graduate Diploma in Computer Science (PGDCS)
Microsoft Certified Solutions Developer in Visual Basic/.NET, SQL, Server, and Windows Architecture
Contact this candidate