Sailu G

Over 10+ years of experience in BI Developer, MS SQL Server Design, Power BI, Development, and Testing working on large-scale enterprise and performance-critical applications. Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts, and Complex Queries in MS SQL Server, Postgres, Oracle, Sybase, and DB2. Experienced with C#, VB.NET 1.1, 3.0 3.5, and ADO.NET, Python.

Gather, cleanse, and validate data from diverse sources to ensure accuracy, consistency, and reliability. Conduct data analysis to uncover trends, patterns, and actionable insights that drive strategic business decisions. Design, build, and maintain interactive dashboards and reports using tools such as Tableau, Power BI, or equivalent visualization platforms.

Collaborate with cross-functional stakeholders to gather data requirements and translate them into effective technical solutions. Document data workflows, methodologies, and analytics processes for transparency and future reference. Perform exploratory data analysis (EDA) to identify opportunities for business growth and optimization.

Support the design and implementation of efficient data models and database structures to enhance analytical performance. Involved in the Logical Design of the Database, transforming it into Physical Design.

Performed Data

Modeling using Visio. Experienced in supporting a team of application developers for their .NET database application. Transformed data from various data sources using OLE DB and ODBC connections. By using COZYROC, we connected Salesforce through SSIS.

Experienced in SQL Development in the .NET environment, especially with CLR Stored Procedures. I am experienced with DTS, BCP, and Jobs for MS SQL SERVER. We used all SSIS configurations, including XML configuration files, environment variables, registry entries, parent package variables, and SQL Server tables.

Experience with batch, database, real-time, flat-file, Oracle, XML files, CSV files data load, and dynamic data migration methodologies. Exceptional programming skills in VB6 VB.NET, C#, Python, Azure Synapse Analytics. Excellent knowledge of development in reports in SSRS, Tableau, and Power BI.

Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures. Worked extensively on system analysis, design, development, testing, and implementation of various projects. Excellent verbal and written communication skills with a strong focus on customer-facing interaction, customer service, and presentation.

Self-motivated and possesses the ability to think critically and analyze, as well as good interpersonal and communication skills. Technically motivated and creative. User-oriented with a desire to learn the client's business requirements.

Expertise in MS Office functionality, especially Excel (Macros, VBA, Pivot Tables, Lookups) Worked with data visualization and reporting tools like Tableau. Worked with data transfer methods (SFTP, FileZilla, HTTP, TCP). Worked with the mos

BI Developer, SQL Developer - Carson Tahoe Health - Carson City, NV (Remote)

(2023-07)

Carson Tahoe Health is a not-for-profit healthcare system in Nevada that includes hospitals and physician clinics. Affiliated with the University of Utah Health. Worked on Epic Clarity and caboodle files.

• Receive flat files from UTH (University of Utah), which are uploaded via SFTP. Worked on Epic Caboodle/Clarity, Infor, and financial files.
• Load flat files into the staging environment, clean, and load into the EDW tables, followed by the generation of final reports.
• Create fact, dimension, and bridge tables in Postgres using flat file sources. By using an E-R diagram, join and merge the sorting grouping of the data.
• Create views, stored procedures, and function triggers, indexes, and keys according to requirements.
• Build a structured, scalable BI environment and data pipelines (ETL/ELT) from the ground up, ensuring a single source of truth.
• Design and build a data warehouse integrating data from Salesforce, DB2, and other systems into a unified environment.
• Create interactive Power BI reports with bookmarks, selection panes, drill-through filters, and custom R-based visualizations for enhanced storytelling.
• Implement RLS (row level security) depending on Hierarchy of jobs.
• Develop analytical dashboards in Power BI to enable quick, actionable insights for business users.
• Manage Power BI workspaces, schedule data refreshes, and maintain related apps and workbooks.
• Use DAX to create measures and calculated fields, apply Power Query for data transformation.
• Migrate Boulder Tables from Excel to Power BI with advanced visualizations to drive business improvements.
• Collect and integrate plant data from various global regions to analyze profit and loss metrics in Power BI.
• Translate data requirements into data pipelines and create data maps and canonical models.
• Identify supply chain challenges and opportunities to enhance service, reduce costs, and optimize inventory turns.
• Perform ETL on data from DB2, PostgreSQL, and other legacy systems for integration into a central data warehouse.
• Develop and maintain Salesforce Apps and Reports for customer issue tracking and CRM process improvements.
• Publish and maintain Power BI Service workspaces, schedule data refreshes and enable role-based access to dashboards for business users.
• Create custom visualizations and use storytelling techniques in Power BI (e.g., bookmarks, drill-through filters) to illustrate business KPIs tied to DB2 and Salesforce data.
• Translate data requirements from stakeholders into actionable insights, including data maps, canonical models, and source-to-target mapping.
• Integrate data from various sources into Power BI/Fabric for centralized reporting.
• Apply hands-on experience with forecasting techniques for time series data, applied to business KPIs like sales, inventory, and service performance.
• Develop data models using star/snowflake schemas, and optimize data warehousing strategies in Azure Synapse, SQL Server, and PostgreSQL.
• Demonstrate strong understanding of data normalization, fact/dimension design, and performance tuning of BI environments.
• Perform advanced scripting and automation using Python, R, and VBA for data wrangling, forecasting, and reporting.

BI/SQL Developer - United Way of Greater Rochester - Rochester, NY (Remote)

(2021-07 - 2023-06)

The United Way of Greater Rochester and the Finger Lakes is a nonprofit organization dedicated to mobilizing community resources and goodwill to ensure everyone in the region can thrive. Serving six counties—Genesee, Livingston, Monroe, Ontario, Wayne, and Wyoming—the organization collaborates with over 50,000 donors, 1,300 workplaces, 1,000 nonprofit partners, and thousands of volunteers to address the area's most pressing human service challenges.

• Collect source data from Andar, FIMS, Salesforce (SF), and other platforms, such as Volunteer United and Galaxy.
• Develop stored procedures and functions using BDM and STTM documents to ingest data into the staging area.
• Cleanse and load data into the Enterprise Data Warehouse (EDW).
• Process historical loads every Sunday and run incremental loads daily, then send an email to the concerned development team.
• Create views and triggers on top of the EDW database using EDW data and views as the foundation for Tableau reports, refreshed daily.
• Fix bugs depending on priority and create maintenance and support documents.
• Work on Tableau reports on a daily, monthly, and yearly basis.
• Develop interactive Tableau dashboards.