sai sandeep

Filtered and cleansed bad data using complex T-SQL statements in staging area and implemented various constraints for data consistency.
Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Developed SSIS packages from a variety of data sources, using PL/SQL queries.
Created Different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting services.
Created cubes and generated named calculations and named queries.
Developed SSIS packages based on business needs and migrated data to multiple database levels.
Participated in the creation of Data Marts and Data Warehouses utilizing the star and snowflake schemas.
Created facts and dimension tables in SSAS, as well as specified the link between facts and dimensions using the Star and Snowflake Schemas.
Conducting thorough Unit Testing and Integration Testing.
Generated and consolidated monthly reports and budget analysis to drive Personal loans, Mortgage Loans and Business loans with SQL report services (SSRS).
Good knowledge of Power BI, including how to import, shape, and convert data for business intelligence (BI), visualize data, produce reports, schedule automated refresh of reports, and create and distribute dashboards.
Collaborated with the IT team to integrate Power BI with existing systems and databases.
Conducted performance tuning and optimization to enhance report loading times.

• Filtered and cleansed bad data using complex T-SQL statements in staging area and implemented various constraints for data consistency.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS). Developed SSIS packages from a variety of data sources, using PL/SQL queries.
• Created Different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting services.
• Created cubes and generated named calculations and named queries. Developed SSIS packages based on business needs and migrated data to multiple database levels.
• Participated in the creation of Data Marts and Data Warehouses utilizing the star and snowflake schemas.
• Created facts and dimension tables in SSAS, as well as specified the link between facts and dimensions using the Star and Snowflake Schemas.
• Conducting thorough Unit Testing and Integration Testing.
• Generated and consolidated monthly reports and budget analysis to drive Personal loans, Mortgage Loans and Business loans with SQL report services (SSRS).
• Good knowledge of Power BI, including how to import, shape, and convert data for business intelligence (BI), visualize data, produce reports, schedule automated refresh of reports, and create and distribute dashboards.
• Collaborated with the IT team to integrate Power BI with existing systems and databases.
• Conducted performance tuning and optimization to enhance report loading times.

Designed and developed SSIS packages to migrate data from Old System Meditech Client Server to new health system called as Meditech Expanse
Worked closely with business analysts and gathered functional requirements.
Designed technical design documents for ETL process
Assist database back-ups and proactive maintenance.
Responsible for ensuring space availability, monitoring activity, disaster recovery, and documenting problems, changes, and solutions.
Worked on controlling user privileges, monitoring the security and audit issues.
Also administering security by setting up Groups and then logins for each roles or user for maintenance of databases at database level, server level and windows level.
Design robust views, complex queries, functions, stored procedures, clustered and non-clustered indexes and triggers.
Ensure consistency and integration with existing data warehouse
Used to perform incremental load using change tracking and worked on to build high level SSIS packages using various transformations
Create, Schedule and run jobs for the developed SSIS packages for every 5 minutes interval
Designed and developed databases, tables, views and stored procedures.
Created Extended Events to track the usage of reporting tables in client server(Old System)
Gathering requirements and designing and fine-tuning of databases as per requirements of clients and maintain complete documentation of created groups, roles and users and assigned access privileges to the user.
Continuously interacted with Business Analysts and end users to gather business requirements.
Designed and developed a database to house data from various data sources for all reporting needs.
Created SSIS packages to extract, transfer and load data into the data warehouse on daily basis.
Created SSIS Packages to import and export data from Excel Spreadsheets, Text files, CSV files and various direct other relational sources.
Analyzed, reverse engineered the data sources to build new subject area in the data warehouse.
Created and scheduled SQL jobs to run SSIS packages on daily basis.
Hands on experience in using different transformations like data conversions, lookups, derived column transformations etc.
Performed data cleansing operations in ETL workflows to remove unnecessary columns, eliminate redundant data, inconsistent data and replace them with appropriate placeholders to keep them consistent.
Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views as per the requirements.
Generated Reports using Global Variables, Expressions and Functions.
Developed Stored Procedures and Views to be used to supply the data to the Reports.
Complex formulas were used to show derived fields and to format the data based on specific conditions.
Maintenance and provide support to the users for the deployed reports.
Created Ad-Hoc reporting to quickly serve business users by extracting data they needed for time being into excel spreadsheets to make quick analysis and decisions.
Involved in Azure Cloud Analytics platform setup and lead team to implement proof of concept.
Build TSQL in Synapse to load data to Synapse DWH.

Designed and develop SSIS packages to Extract transform and load data from various data sources including flat files into SQL server.
Automated SSIS packages using SQL Server agent.
Created custom logging in ETL workflows for auditing purposes.
Performed data profiling and cleansed data to fix data quality issues.
Created Various Reports Using SSRS for various department across the organization.
Developed SSIS packages to automate different FTP’s files and emailing to different clients as per requirements.
Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Adhoc reports, Drill down reports as well as interactive reports according to business requirements in timely manner.
Creating several Complex Reports (sub reports, dynamic parameter driven, formulas, and conditional formatting) using SSRS.
Troubleshooted slow running queries by implementing various performance tuning techniques and updated stored procedure & reports.
Generated and delivered quality reports with high accuracy to business users and performed quality assurance checks on ETL’s & reports.
Coordinated with the project management team in establishing business analytics systems that ensured timely and orderly completion of reports.
Collaborated with users to produce streamline business reports.
Developed Power Bi reports and dashboards from multiple data sources and deployed them on server using Power BI
Designed Power BI data visualization utilizing maps, scalar plots, pie bar and density charts.