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 requiremen
Work Terms
I am available most of the time. best way to reach me is through private messages on the platform, and I will reply back shortly.
I am willing to relocate for full time opportunity, as well to discuss my rate for 12+ months contracts.
Please reach out to me if you have any questions, I am sure that we can come up to solution that would work best for both sides.