BINDU LATHA DAMULURI
Sr. BI Developer
Broomfield,CO
Summary
Results-driven BI Developer with over 10 years of experience in crafting comprehensive solutions utilizing Microsoft BI Tools, T-SQL, and Snowflake. Expertise spans the complete BI development lifecycle, from requirements gathering to end-user support, with a strong focus on data architecture and ETL processes. Demonstrated proficiency in designing scalable Power Platform and Power BI solutions for large teams, ensuring effective decision support through robust dimensional modeling. Aiming to leverage analytical skills and technical knowledge to enhance data-driven strategies within a forward-thinking organization.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Senior Power BI Developer/Systems Analyst
Crocs
Broomfield, USA
05.2021 - Current
- Lead the BI development lifecycle from requirements gathering to deployment.
- Collaborate with the Digital, Finance, and Operations teams to define and implement strategic initiatives.
- Create interactive dashboards and reports for the Sales, Marketing, and Inventory teams using advanced DAX functions.
- Work with PowerOn to enhance reporting capabilities and streamline BI solutions.
- Understand the developing process gaps in Operations and Digital, research solutions, and prioritize projects for development.
- Conduct an in-depth analysis of data pipelines, reporting workflows, and business operations.
- Use findings to recommend innovative solutions that enhance accuracy, speed, and overall effectiveness.
- Identify inefficiencies in data and business processes, propose actionable improvements, and communicate these recommendations to leadership.
- Understanding end-to-end system flows and identifying dependencies in support of delivery, release, and change management.
- Working with financial tools and reporting, such as SAP, Business Planning and Consolidation, or other consolidation and planning tools, Power BI, and SAP Business Objects.
- Developed interactive analysis reports and dashboards for Sales, Marketing, and Inventory teams using advanced DAX functions, such as table functions, aggregation functions, and iteration functions.
- Creating row-level security with Power BI and integration with the Power BI service portal.
- Worked on optimizing various Power BI reports by creating aggregate and hybrid tables, and following best practices.
- Streamlined code and document management using JIRA, DevOps, and SharePoint.
- Utilized Snowflake effectively in conjunction with Power BI.
- Train and mentor junior. Developers
Power BI Developer
Sapphire Software Solutions
Virginia, USA
09.2018 - 06.2021
- Write and refine user stories (requirements) for systems, enhancements, data pipelines, reports, and dashboards by gathering information from functional areas.
- Partnered with stakeholders to design scalable data schemas and deliver actionable insights through Power BI.
- Managed sprints by performing independent analysis across multiple project phases.
- Understanding end-to-end system flows and identifying dependencies in support of delivery, release, and change management
- Created dashboards and reports leveraging Power BI and SAP Business Objects.
- Ability to conceptualize, formulate, and succinctly convey complex solutions to a wide audience.
- Participate in Scrum daily standup, monthly review meetings, product backlog, sprint planning, sprint review, and sprint retrospective meetings.
- Published analytical insights to support executive-level decision making.
- Developed interactive analysis reports and dashboards for Sales, Marketing, and Inventory teams using advanced DAX functions, such as table functions, aggregation functions, and iteration functions.
Lead BI Analyst
Aptean
Bangalore, India
08.2009 - 08.2016
- Coordinated with business users to gather requirements.
- Managed projects for U.S. and U.K. manufacturing clients.
- Developed complex stored procedures, and optimized T-SQL queries.
- Generated and maintained analytical reports utilizing SSRS and Power BI.
- Experience with all phases of the SDLC and Agile methodologies.
- Database design and development by writing T-SQL queries, stored procedures, triggers, and views using various DDL and DML commands.
- Managed indexes, statistics, and optimized queries by using the execution plan for tuning the database.
- Responsible for performance tuning and optimization of stored procedures using SQL Profiler and the Database Tuning Wizard.
- Involved in mapping multiple data sources to a single target database by analyzing the business requirements that are specified in the functional documents.
- I have experience in creating source and target table definitions using SSIS.
- Source data was extracted from flat files, SQL Server, and DB2 database.
- Created SQL jobs to schedule SSIS packages.
- Experience in developing SSRS reports using MS SQL Server, Power BI (dashboard reports), and Crystal Reports.
- Created parameterized reports, crosstab reports, and drill-down reports using SSRS.
- Created report snapshots to improve the performance of SSRS.
- Created report models and applied row-level security filters for the report model.
- Configured and deployed packages on both the file system and SQL Server MSDB, and import-export wizard.
- Defined report layouts and identified datasets for report generation.
- Developed reports using complex T-SQL queries, user-defined functions, stored procedures, and views.
- Generated ad-hoc reports in Excel Power Pivot, and shared them using Power BI with the decision makers for strategic planning.
- Utilized Power BI to create various consolidated reports, such as Sales Order information, Purchase Order information, etc.
- Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, and Data Flow and Process diagrams using MS Visio tools.
- Provide technical advice and assist in solving programming problems.
- Train consultants and analysts to create ad-hoc queries that decreased dependency on developers by 90%.
- Mentored a team of six resources to deliver quality projects by adopting Agile methodologies.
- Facilitated Sprint Planning, Release Planning, and Sprint Retrospective meetings.
SQL Developer
RAMCO Systems Pvt. Ltd.
Chennai, India
01.2008 - 08.2009
- Scoping and analyzing the business requirements and documenting the same
- Table Design, Schema Design and T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity
- Interacted with Development Teams and Managers to analyze business needs and developed technical specifications
- Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL
- Experience in SQL joins, sub queries, tracing, and performance tuning for better running of queries
- Generating SQL Scripts to automate repetitive tasks
- Worked on performance issues of the T-SQL queries and stored procedures which were early executing for more than 1 hour
- Designed and optimized various T-SQL database objects like tables (schemas), views, stored procedures, User Defined functions (UDF), indexes and triggers using Management Studio and SQL Profiler
- Defined Check constraints, Business Rules, Indexes, and Views
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
- Helped in integration of the front end with the SQL Server backend
- Developing various MIS reports using Crystal Reports 11 and SQL Server Reporting Services
- Developed complex SQL queries using stored procedures, triggers, temporary table to support Power BI and SSRS reports
- Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and Process diagrams using MS Visio tools
- Performed development support, document reviews, test plan, integration of the system
- Provided continued maintenance and development of bug fixes for the existing and new reports
- Migrated internal reports SSRS reports to Power BI
Education
Post Graduate Diploma - Business Administration (IT)
ICFAI Business School
Hyderabad, India05.2002
Bachelor’s - Computer Ccience
Andhra University
India04.2000
Skills
- SSIS
- SSRS
- SSAS
- Power BI
- Power Query
- Power Pivot
- DAX
- Power Platform
- SQL Server
- Snowflake
- MS Access
- T-SQL
- PL/SQL
- Python
- C
- XML
- Crystal Reports
- Looker
- SQL Profiler
- Power On
Certification
Data Science Certification from MIT
Core Competencies
SSIS, SSRS, SSAS, Power BI (Power Query, Power Pivot, DAX), Power Platform, SQL Server (2008-2016), Snowflake, MS Access, T-SQL, PL/SQL, Python, C, XML, Crystal Reports, Looker, Power BI, SQL Profiler, Execution Plans, Index Tuning Wizard, Agile methodologies, Scrum Master experience, Power On
Timeline
Senior Power BI Developer/Systems Analyst
Crocs
05.2021 - Current
Power BI Developer
Sapphire Software Solutions
09.2018 - 06.2021
Lead BI Analyst
Aptean
08.2009 - 08.2016
SQL Developer
RAMCO Systems Pvt. Ltd.
01.2008 - 08.2009
Post Graduate Diploma - Business Administration (IT)
ICFAI Business School
Bachelor’s - Computer Ccience
Andhra University
Similar Profiles
Jia Xuan ChanJia Xuan Chan
Sales Associate at CrocsSales Associate at Crocs
Tracey PerryTracey Perry
Freight Supervisor at CrocsFreight Supervisor at Crocs
Angela BedellAngela Bedell
Team Lead Manager at CrocsTeam Lead Manager at Crocs