Chandra B Email & Phone Number

 Over 6 years of IT Experience in Database and Business Intelligence Technologies with expertise in ETL process and Reporting using SQL Server 2019/2017/2016/2014/2012, SSIS, and SSRS. Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing the latest versions and features. Experience in publishing Power BI Desktop reports to the Power BI service. Deployed Power BI Pro for Business users to view reports on the service and local report server. Had good Experience in publishing and sharing BI objects in Power BI Workspace, designed and maintained Power BI dashboard in Power BI App. Reports to Tableau dashboards connecting to SQL server. Used R & Python, SAS, Tableau, Power BI and SQL for data cleaning, data visualization, risk analysis and predictive analytics. Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer. Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging and Maintenance of Power BI Applications. Expertise in various data visualization tools QlikView, QlikSense, Power BI, ThoughtSpot and Tableau. Extensively involved in design of AWS servers of test and UAT environment and designed the ETL data model based on the existing database table structures. Hands on experience in SQL/Snow SQL of Oracle/SQL Server/Snowflake. Proficient in the Microsoft Business Intelligence (MSBI) stack, including SQL Server 2012/2014/2016,2017/2019 SSIS, SSAS, and SSRS. Excellent in Design of ETL SSIS Packages for integrating data using OLE DB connection from sources like (Excel, CSV, Oracle, flat file,) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all. Efficient ETL specifications for EPIC Clarity and non-Clarity sources based on business requirements through a structure of Land Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing Hands-on Experience in Data Migration from MS SQL Server to Oracle ERP Systems. Very good T-SQL Programming skills. Experience in query optimization & performance tuning used SQL Profiler, Execution Plan, Performance Monitor, and DBCC Commands. Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, Power BI, QlikView) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis.