Sr.Database/Bi Developer

AMBRITHA R

Denver, CO, USA 980-***-**** ***********@*****.***

Summary

Detail-oriented BI Developer skilled in report generation and SQL optimisation. Creates dynamic reports and dashboards, enhancing decision-making capabilities for stakeholders. Implements robust data validation processes, ensuring accuracy and reliability in reporting.

Experience

SR.DATABASE/BI DEVELOPER 03/2025 - Current

Comcast

Created detailed low level design documents covering business requirements and specifications.

Designed logical and physical data models for master and transactional datasets.

Prepared source to target mapping documents applying business rules.

Supported and maintained monthly metric reports for line of business analysis.

Designed and developed an audit control process for PL/SQL jobs execution tracking.

Prepared balance and reconciliation reports for ongoing data validation.

Developed ETL workflows in Python for data processing into HDFS and HBase via Flume.

Developed PL/SQL programs to load and validate data into staging.

Tuned legacy operations and automated analysis report generation.

Developed Tableau reports for monthly line of business analysis requirements.

Implemented ETL for report flow and created dynamic Tableau data types.

Implemented data aggregation in Tableau for monthly analysis views.

Reviewed Tableau performance considerations for calculation logic and dashboard design.

Created and managed sites and access control within Tableau Server.

Queried data in S3 using Athena for large S3 bucket datasets.

Automated daily Outlook email reports delivering Tableau display outputs.

Built OBIEE dashboards and migrated OBIEE reports to Tableau.

Adapted workflows to meet evolving business needs.

BI DEVELOPER 07/2023 - 02/2025

PRUDENTIAL FINANCIAL - Scranton, PA

Developed stored procedures to transform warehouse data into SQL Server efficiently.

Designed, coded, and tested new applications following established software best practices.

Adapted workflow to reflect changing business needs and priorities.

Assisted in transferring data between Excel, Access, and SQL Server via SSIS.

Supported report creation using transferred data through SSRS reporting services.

Converted Crystal Reports into clearer, detailed SSRS reports for users.

Optimised table design and index partitioning to improve database performance.

Optimised T-SQL scripts to reduce report execution times for stakeholders.

Generated comprehensive SSRS reports for primary vendor clients and managers.

Implemented stored procedures and triggers to automate recurring workflow tasks.

Developed trend-indicating reports tracking changes across categories in dashboards.

Assisted with parameterised drill-through rolling linked and sub-reports using KPIs.

Assisted with writing stored procedures, triggers, views, and reporting queries.

Supported report layouts to improve visual presentation and readability.

Supported index creation constraints and rules for database objects.

Supported rolling and drill-down indicators across reporting cycles.

Facilitated day-to-day management of database systems and environments.

DATABASE ANALYST/REPORT DEVELOPER 05/2020 - 06/2023

UNITED NATIONS - NYC, USA

Generated comprehensive reports using Microsoft SQL Server Reporting Services 2005/2008, showcasing proficiency in data management.

Developed a comprehensive, logical and physical database design to meet evolving business requirements.

Developed complex SQL queries to support the generation of SSRS reports.

Assisted with SQL tuning through the utilisation of explain plan hints and indexes.

Optimised database performance through implementation of table and index partitioning strategies, enhancing query efficiency.

Developed test cases and validation scripts in SQL to ensure effective data migration between OLAP data warehouses.

Contributed to team efforts in optimising database performance.

Used Oracle Database to extract, store and verify information.

Maintained complex SQL databases to support business operations and informed decision-making.

Managed database access permissions and privileges, ensuring appropriate levels of data confidentiality and integrity.

Conducted cross-departmental training on database management and data analysis techniques, strengthening team capabilities.

Monitored database systems in real-time, promptly addressing any issues to maintain high availability and performance.

Collaborated with IT teams to design and implement database solutions that enhanced data integrity and security.

Improved and debugged code by testing throughout design stages.

Optimised database performance through meticulous tuning, reducing processing times and improving user experience.

SOLARA ACTIVE PHARAMA SCIENCES 09/2017 - 08/2019

STRIDES SHASUN LTD. - india

Built and maintained data-driven sales forecasting models to raise forecast accuracy by 30%.

Analysed historical data and market trends to improve production efficiency to 95%.

Identified issues, analysed information, and implemented practical solutions to enhance operational efficiency.

Linked operational gaps across India, APAC, and MENA using data analytics initiatives.

Collaborated with senior leadership to model business processes for new product initiatives.

Designed customer success metrics and created KPI dashboards for reporting.

Engaged customers to clarify needs and provide tailored high-quality service.

Supported team by completing additional tasks and responsibilities.

Skills

Data integration

ETL development

SQL Server reporting

SSIS package creation

SQL optimization

Database performance tuning

Power BI expertise

Report writing

Report automation

SSRS development

Data analysis and visualisation

Data modeling

Financial analytics

Market research

AWS services

Azure platform proficiency

Quality assurance

Performance tuning

Risk management and assessment

Strategic planning

Department collaboration

Client management

Problem solving

Decision making

Team leadership

Time management

Time efficiency

Technical troubleshooting

Technical writing

Python programming

Education

Tennessee State University - TN Master of Science

M.S., Information Systems (Business Intelligence ), 2024

PSG Institute of Management - Coimbatore, TN Master's

MBA, 2017

Anna University - Chennai, TN Bachelor of Science

Computer Science / Engineering, 2014

Certifications

Certified Six Sigma Yellow Belt

Certified ScrumMaster by Scrum Alliance

Tableau Desktop Specialist certified by Tableau

Business Analytics & Channel Sales certified by AMCAT (Aspiring Minds)

Negotiation skills certified by the University of Michigan

Projects

Data Analytics - Explored and visualized UN data on country characteristics in Tableau

Data Warehousing - Understanding ETL & implementing BW for the Global Bike Company

Contact this candidate