Abhishek Jaiswal Email & Phone Number

Personal Summary:Senior Software Engineer-DWH having 4+ years of professional software development experience with in-depth knowledge in BI Tools like SSIS, SSAS and SQL server , Power BI along with work experience of DWH and BI concepts like OLTP, OLAP, Dimensional Modelling, star schema, snowflake schema, dimension table, fact tables etc. Always Energetic and Excited to build things and ready to learn something new.Key Highlights: • Experience in designing databases and creating database objects including tables, relationships, stored procedures, user-defined functions, views, clustered and non-clustered indexes, triggers, derived tables and CTEs.• Experience in T-SQL programming for writing numerous ordinary to complex queries involving multi-table joins, union, correlated subqueries, CTE's and views for diverse business requirements.• Involved in troubleshooting, resolving data integrity, and monitoring performance issues.• Having working experience on scheduling SSIS Packages using SQL server agent and having experience on scheduling jobs triggering emails etc.• Expertise in creating SSIS Packages to extract, transfer and load existing data into SQL Server from different environments by using various Transformations.• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).• Experience In building Power BI Reports using M-language, DAX, and Data modelling.• Ability to work individually as well as in the Group and provided solutions that meet business objectives.

Listed skills include Microsoft Office, Java, Web Development, Iot, and 4 others.

• 

  United College Of Engineering And Research, Allahabad

  Computer Science And Engineering