Experience

Data Age Business Systems Inc.

• United States
• Software Development
• 1 - 100 Employee

• Senior Business Intelligence Developer

  • Jul 2022 - Present

  Clearwater, Florida, United States



Blue Cross NC

• United States
• Insurance
• 700 & Above Employee

• Senior Business Intelligence Developer

  • Nov 2019 - Jan 2022

  Fargo, North Dakota, United States Client Blue Cross Blue Shield of North Dakota



Fred's Inc.

• United States
• Retail
• 1 - 100 Employee

• Senior SQL/SSIS/SSAS/SSRS/Tableau Developer

  • Dec 2016 - Nov 2019

  Greater Memphis Area - Actively involved in gathering System Specification Requirements for the project. - Created databases, tables, Views, Indexes, Stored Procedures, Triggers and Constraints using TSQL. - Developed multiple OLAP Cubes such as Sales Cube and Inventory Cube to provide users with rapid analysis and searchable access to any data points. - Involved in an ERP Project (Enterprise resource planning) and Created, and optimized ETL packages with error handling for Storing cleaned data into Azure… Show more - Actively involved in gathering System Specification Requirements for the project. - Created databases, tables, Views, Indexes, Stored Procedures, Triggers and Constraints using TSQL. - Developed multiple OLAP Cubes such as Sales Cube and Inventory Cube to provide users with rapid analysis and searchable access to any data points. - Involved in an ERP Project (Enterprise resource planning) and Created, and optimized ETL packages with error handling for Storing cleaned data into Azure Dynamics 365 using SSIS. - Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. - Managed Extracts in Tableau server to make sure the Data is up-to-Date and created subscriptions to notify users on a daily basis. Show less



Tomra North America, Inc.

• BI/SQL Server Developer

  • Apr 2015 - Aug 2016

  Connecticut - Gathered business requirements in Joint Application Development (JAD) sessions to facilitate the planning and implementation phase of a data warehouse. - Wrote TSQL scripts and complex Stored Procedures to implement the business needs and to support the front end applications. - Designed an advanced OLAP tool to provide timely assistance for any problems arising in the business application. - Worked on database management activities such as data cleansing, indexing and table… Show more - Gathered business requirements in Joint Application Development (JAD) sessions to facilitate the planning and implementation phase of a data warehouse. - Wrote TSQL scripts and complex Stored Procedures to implement the business needs and to support the front end applications. - Designed an advanced OLAP tool to provide timely assistance for any problems arising in the business application. - Worked on database management activities such as data cleansing, indexing and table creation. - Created complex ETL (SSIS) packages to pull data from XML/EXCEL files, and load them to SQL server. - Created packages with different SSIS transformations like Merge, Merge Join, Union, and Union All along with complex string matching algorithm like Fuzzy Grouping and Fuzzy Look Up. - Improved the functionality of SSIS packages by implementing advanced SSIS features like transactions, checkpoints, loggings, configurations, error-handling etc. - Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size. - Designed different types of reports such as Drill Down, drill through, sub and linked reports using the SSRS. - Scheduled the delivery of reports in different formats such as PDF, Excel, using standard and data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports including current status. - Generated reports using SSRS and Power pivots and deployed them on SharePoint Server - Improved the performance of reports by optimizing data sets, making use of report caching and snapshots along with taking into consideration networking aspects. - Involved in installation of Tableau 8.2, Tableau software application software - Creating users, groups, projects, Data connections, setting as Tableau administrator. - Created Tableau dashboards for getting insight to claims processing, memberships and products across Timelines, regions etc. Show less



Centerlight Health System

• United States
• Hospitals and Health Care
• 400 - 500 Employee

• SQL/SSIS/SSAS/SSRS/Tableau Developer

  • May 2014 - Apr 2015

  Bronx, NY - Worked with Business Analysts and end users for gathering detailed requirements and specifications. - Created views to facilitate easy user interface implementation, and triggers on them to assist consistent data entry into the database. - Performed Index analysis on tables and came up with more efficient solutions to use between different kind of indexes such as Clustered, Non-Clustered and Covering Indexes. - Created Triggers that Audit the data that is being… Show more - Worked with Business Analysts and end users for gathering detailed requirements and specifications. - Created views to facilitate easy user interface implementation, and triggers on them to assist consistent data entry into the database. - Performed Index analysis on tables and came up with more efficient solutions to use between different kind of indexes such as Clustered, Non-Clustered and Covering Indexes. - Created Triggers that Audit the data that is being inserted/updated/deleted from heterogeneous sources. - Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like defragmentation, re-indexing, and recompiling. - Developed complex ETL Packages using SQL Server 2008R2 Integration Services to load data from various sources like Oracle/SQL Server/DB2 to Staging Database and then to Data Warehouse. - Creating and deployed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate and Derived Column Transformations. - Implemented transactions in SSIS by appropriately setting Transaction Option property to Supported, Not-Supported and required based on the type of strategy being implemented. - Created Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps Gantt charts using show me functionality. - Published the developed dashboards, reports on Tableau server so that the end users having access to the server can view the Data. - Effectively handled data errors during the modification of existing reports and creation of new reports. Show less