Maha Lakshmi
Maha Lakshmi
Maha Lakshmi
Summary:
Having 5+ years of IT experience as Microsoft BI Developer implementing SSIS, SSRS and SSAS using Microsoft
Business Intelligence (MSBI), and Power BI
Highly experienced in Designing, Developing and Deploying various reports like Tabular, Matrix, Chart, Drill
down, List, Parameterized, Cascading and other reports using SSRS.
Thorough knowledge in data warehouse concepts, Relational Database Management Systems (RDBMS),
Normalization, Data Modeling and Documentation.
Expertise in creating OLAP Cubes and Dimensions in SSAS.
Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes
schemas, ETL processes and dimensional modeling.
Experience with advanced Power BI topics such as complex calculations, table calculations, geographic mapping
and performance optimization.
Experience on publishing Power BI reports on dashboards in Power BI server and Power BI Mobile App.
Designed and developed Power BI graphical and visualization solutions based on business requirement.
Develop customized calculated Columns and measure using DAX Formula language in Power BI to satisfy
business needs.
Excellent communication, analytical and interpersonal skills, self-motivated, quick learner and an active team
player and team leader.
Knowledgeable in all Software Development Life Cycle (SDLC) and models like Waterfall & Agile
Have worked and successfully delivered many projects at onsite coordinating with stakeholders and developers,
during various phases of delivery.
Education:
B.Tech (Bachelor’s):- JNTU University, Hyderabad, India. 2006 to 2010.
SKILLS:
Database: MS SQL Server 2012/2014/2016/2017, MS Access, Oracle9i/10g/11g/12c/18c, DB2, PostgreSQL
Programming Languages: T-SQL, PL/SQL, C, HTML, DHTML, XML
ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Service(DTS)
Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder.
Tools: SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer,
Import & Export (DTS)
MSBI Tools: SSIS, SSRS, SSAS, Power BI
Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP &OLTP, Adobe Photoshop, Abode
Flash, Hyper-V Manager
Operating Systems: Windows 10/2008/2007/2003R2, Windows XP, Windows Vista
Methodology: Agile(Scrum) and Waterfall
PROFESSIONAL EXPERIENCE:
Andeavor (Tesoro Corporation) - San Antonio, TX Mar 2021 to Present
Power BI Developer
Responsibilities:
Andeavor is formerly Tesoro, primarily engaged in petroleum exploration and production.
It is an independent refiner and marketer of petroleum products.
The project is about combines data from multiple sources to identify the performance of individual wells and to
determine total production and sales Quantities. To see the production levels and resources sold by county and by
year.
Generated periodic reports for Marketing, Logistics in Tesoro.
Hands-on working on dummy projects with creating solution driven views and dashboards by developing
different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts,
Circle Views, Line Charts, Area Charts, Scatter Plots, and Histograms in Power BI.
Developed Custom Visualization in Power Bi such as Fuel tank, Liquid fill Guage, Charts.
Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as
required in Excel
Pulled the data from SQL to Power BI for Report Generation.
Wrote DAX Expressions, Power Query, Functions in power bi.
Published Power Bi reports to end user via mobile and content packs.
Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize
reports.
Designed Data Model in Power BI such Fact and dimensional tables and relationships.
Generated Monthly ,Yearly, Quarterly and daily reports in power bi
Worked and Joining the query's and merging the tables in power bi
Created the KPI to show the difference between actual, budget and forecast data
Created Several User Roles and Groups to the end -user and provided row level security to them
Created measures , calculated columns, conditional column, custom columns in Power Bi
Created KPI, Guage, Clustered column chart ,Slicers for better understanding of the report
Developed Operational Reports for the Marketing in Tesoro Corporation such as daily reports
Generated monthly and quarterly reports as bar charts for the management using different techniques like data
filtering, adding interactivity, deploying reports to Power Bi Service.
Environment: Power Bi Desktop,MS Excel, txt file, MS SQL Server 2014, SSIS/SSAS/SSRS.