Senior SQL BI Developer at Orange County Public Schools (OCPS) (2019-06 – Present)
Evaluate, design and maintain database objects according to business requirements and participate in gathering requirements and understand the business rules, source system, target system, operational data and deployment process.
- Partnered with business users to gather requirements and deliver enterprise BI solutions using SQL Server, SSIS, SSRS, and Power BI.
- Design and create new databases and schema objects including tables, indexes, stored procedures, functions and triggers.
- Create SSIS packages to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, flat file, Excel, OLE DB, using SQL Server Integration Services (SSIS) and deploying and executing the packages in both the environments (Development and Production).
- Utilizing several transformations in data flow and control flow including script, slowly changing dimension, and data conversion, conditional-split, look up, derived column and many more for implementing the transformation logic in the packages and load the date into tables.
- Designed and optimized end-to-end ETL pipelines for ODS, staging, and data warehouse layers.
- Design and develop different types of student reports including tabular, Drill through reports, Sub reports, drill down reports, Parameterized Report Models, and Ad-hoc reports based on business requirements using SSRS.
- Built Power BI dashboards with optimized DAX calculations, KPIs, and interactive visuals.
- Integrated Power BI with Azure SQL and ADLS, improving refresh performance and scalability.
- Plans, design and execution of processes are needed to ensure Year End Processing (YEP) is completed, and data is available for the next school year.
- Develop processes to aid in the reporting of SMS data to the Department of Education (DOE).
- Responsible for scheduling jobs on various stored procedures and packages and create alerts for successful or unsuccessful completion of scheduled jobs and setup log files and email notifications to monitor jobs in production and staging environments.
- Support and troubleshoot daily work requests from different groups requesting modifications in the existing system and creating a new procedure (production support).
- Documenting the project work and process.
- Actively participated in Agile ceremonies, including sprint planning, grooming, reviews, and retrospectives.
T-SQL Developer / SSRS Report Developer at Conduent (2018-12 – 2019-05)
- Designed and developed SSRS reports across SQL Server 2012–2017 environments.
- Built and maintained SSIS ETL workflows integrating data from Excel, Oracle, MS Access, and flat files.
- Created complex T-SQL logic including stored procedures, functions, and performance-optimized queries.
- Scheduled and monitored SSIS executions using SQL Server Agent.
- Managed source control using TFS and collaborated with cross-functional teams.
SQL BI / SSIS / SSRS / SSAS Developer at Nationwide (2017-01 – 2018-11)
- Designed and implemented enterprise data warehouse solutions using SSIS and SQL Server.
- Built multidimensional SSAS cubes and optimized performance using star and snowflake schemas.
- Developed OLAP cubes, dimensions, measures, and MDX queries.
- Performed SQL Server DBA tasks including backup, recovery, security, and performance tuning.
- Created advanced SSRS reports and managed report deployments.
- Implemented error handling and logging frameworks in SSIS packages.
- Participated in functional, regression, and system integration testing.
SQL Server Developer at Walmart (2016-08 – 2016-12)
- Designed data warehouse models using star and snowflake schemas.
- Developed complex T-SQL queries, stored procedures, and triggers.
- Created SSRS reports including dashboards, charts, drill-down, and ad-hoc reports.
- Implemented SSAS cubes with dimensions, measures, and MDX queries.
- Tuned SQL Server performance using indexing and monitoring tools.
SQL Developer at Bharat Heavy Electrical Limited (BHEL) (2014-01 – 2015-12)
- Designed and maintained SQL Server databases, schemas, and objects.
- Performed SQL Server upgrades and migrations (2005/2008 → 2014).
- Developed stored procedures, triggers, views, and indexes.
- Supported reporting solutions using SSRS and Crystal Reports.
- Created technical documentation and collaborated with business stakeholders.
