Over 7 years of IT experience focusing on business intelligence, ETL, and reporting in OLTP and OLAP environments.
Hands-on experience across various professional domains such as healthcare, pharmacy, insurance, banking and information technology.
Strong knowledge of T-SQL development, using DQL, DML and DDL to create complex UDSP, UDF, views, triggers, CTEs, indexes and other ad-hoc T-SQL queries.
Proficiency in data cleansing, migration, troubleshooting, debugging and error handling in SQL Server and related tools, including SSIS and SSRS.
Solid abilities in utilizing execution plan, indexing, SQL profiler, and other performance tuning techniques.
Expertise in ETL (extracting, transforming, and loading) using data tools such as SQL and SSIS (SQL Server Integration Services), migrating data from various sources, including Excel files, flat files, OLEDB, DB2, etc.
Experience with SDLC of SQL Server instance, including requirement gathering, designing, development, testing, deployment as well as maintenance.
Experience in data modeling, dimensional modeling, data mart design and implementation with Star Schema and Snowflake Schema.
Extensive knowledge of cloud computing, including AWS (Amazon Web Services) and Azure (Azure SQL Database, Azure Data Lake, Azure Data Factory).
Advanced knowledge in data visualization and reporting tools including SSRS (SQL Server Reporting Services), Power BI (Power BI Desktop, Power BI Services, Power BI Report Server) and Tableau (Tableau Desktop, Tableau Online, Tableau Server), interacting with T-SQL queries and stored procedures.
Hands-on experience in generating various kinds of reports like drill down reports, drill through reports, sub reports, cached reports and parameterized reports in SSRS.
Extensive knowledge of statistical analytics, data mining, machine learning and predictive modeling using Python, R and SPSS.
Experience in creating and scheduling Jobs, Alerts, SQL Mail Agent, Database Mails and SSIS Packages.
Strong skills with gathering, analyzing, transforming business requirements into system requirements.
Experience in conducting both JRD and JAD sessions with end users, management team, tech team members, and QA teams.
Excellent communication and interpersonal skills, being able to work both collaboratively and independently.