![Profile](https://weekday-user-pictures.s3.ap-south-1.amazonaws.com/profile-images/aliasger-bhanpurawala.jpg)
Aliasger Bhanpurawala
Senior Software Engineer at Wells Fargo
11.3
Years of Experience
Education
vmv commerce jmt arts jjp science college wardhaman nagar, hislop college
Companies
wells fargo, wells fargo, wells fargo, synechron, synechron, 3i infotech, netbusiness solutions i ltd
Reach out to Aliasger Bhanpurawala via Email, InMail and SMS drip
by installing Chrome extension
Aliasger's contact details
Email (Verified)
aliXXXXXXXXXXXXXXXXXXXXom
Mobile Number
+91XXXXXXXX52
Experience
2023 - Present
wells fargo
Lead Software Engineer
2022 - 2023
wells fargo
Senior Software Engineer
2018 - 2022
wells fargo
Senior Data Specialist
These dashboards were for consumer banking leader and Completely based on Login user hierarchy. Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team. Created data model for loading data from staging to data mart Created the semantic layer for tableau Included Logging, Error handling by using Event Handlers, and Custom Logging for SSIS Packages. Designing and scheduling complex SSIS Packages for transferring data from Multiple data sources to SQL server. Created complex SP View and Triggers to assist efficient data manipulation and data consistency. Build all business/function logic in SQL SERVER using T-SQL Used Transaction for loading data mart Cleansing the data and created exception logs for records which Not satisfying the business rules. Develop new reports and delegate tasks to team members Development of packages according to the ETL specifications for the staging area And data loading using SQL Server Integration Services & SQL Server 2012 and oracle 11g. Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse. Maintained log information in SQL table to tracking Errors and recording package execution status. Created Configurations to change the package properties dynamically. Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio. Use customer requirements to improve functionality (speed, performance / usability). Worked on Exception Handling with @@error and with Try/catch and resolving locking/deadlocks. Documented the technical architecture of the data warehouse, including the physical components, their functionality, source data and ability to integrate with existing system architecture.
2018 - 2018
synechron
Tech Lead
2016 - 2018
synechron
Senior Software Engineer
Working on ETL Process using SQL Server Integration Services (SSIS) and creating various kinds of Reports using SQL Server Reporting and analytical reports using Cubes and hands on creation of cubes with SQL server Analysis services (SSAS).
2014 - 2016
3i infotech
Senior Software Engineer
I have acquired knowledge and understanding of subjects like - SQL SERVER - SSIS - SSRS - SSAS - MDX - ASP.NET - C# - Angularjs - MVC - MVC 4.0 - ADO.NET - Oops concept - JQUERY - Web Services, WCF etc Following are few highlights of my experience that strongly matches with the objectives you are seeking: - Responsible for developing SSIS packages. - Developing and scheduling SQL jobs. - Fixing exchange related development issues arises. - Responsible developing and maintaining the applications by utilizing ASP.NET,C# and SQL along with javascript, jquery etc. - Responsible for the fixing the bugs, Manual reviewing the application, Unit testing and troubleshooting the technical problems. - Liable for modifying applications according to the user’s requirements. - Work with development teams to create sound architecture designs and implement best practices. - Co-ordinate with Software Development Teams on producing highly optimized, highly scalable and high performing code. - Guide and mentor junior developers. - Experience in Multi-browser compatible web development. - Experience in Requirement gathering like client interaction.
2013 - 2014
netbusiness solutions i ltd
Software Engineer
Following are few highlights of my experience that strongly matches with the objectives you are seeking: - Responsible for developing SSIS packages. - Developing and scheduling SQL jobs. - Fixing exchange related development issues arises. - Responsible developing and maintaining the applications by utilizing ASP.NET,C# and SQL along with javascript, jquery etc. - Responsible for the fixing the bugs, Manual reviewing the application, Unit testing and troubleshooting the technical problems. - Liable for modifying applications according to the user’s requirements. - Work with development teams to create sound architecture designs and implement best practices. - Co-ordinate with Software Development Teams on producing highly optimized, highly scalable and high performing code. - Guide and mentor junior developers. - Experience in Multi-browser compatible web development. - Experience in Requirement gathering like client interaction.
Experience
84 Skills
.NET Framework
Agile Methodologies
ALM
analytics
Apache Hive
Apache Pig
architecture
ASP
ASP.NET
ASP.NET MVC
aspDotNet
Autosys
Azure Data Factory
Azure Data Lake
Azure Databricks
banking
business intelligence
Business Intelligence (BI)
Business Intelligence (BI)
Business Intelligence Tools
C#
C#
Dashboard
Data Analysis
Data Analysis
Data Architecture
Data Integration
Data Modeling
Data Modeling
Data Transformation Services (DTS)
Data Visualization
Data Warehouse
Data Warehouse Architecture
Data Warehousing
Data Warehousing
Database Design
Databases
DAX
Design
Dimensional Modeling
Extract, Transform, Load (ETL)
Extract, Transform, Load (ETL)
Hadoop
Hadoop
HBase
HBase
hdfs
HDFS
Hive
Hive
Integration
Internet Information Services (IIS)
JIRA
Jira
Logic and Reasoning
Logical Data Modeling
Microsoft Power BI
Microsoft SQL Server
MSBI
MultiDimensional eXpressions (MDX)
NoSQL
OLAP
Oracle
Oracle Database
Physical Data Modeling
Relational Data Modeling
Senior Software Engineer
Software Engineer
SQL
SQL
SQL Azure
sql server
SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
SQL Server Reporting Services (SSRS)
SSAS 2008
SSIS
T-SQL
Tableau
Tableau
Transact-SQL (T-SQL)
Transact-SQL (T-SQL)
Web Services
Education
2009 - 2012
vmv commerce jmt arts jjp science college wardhaman nagar
Master of Computer Applications (M.C.A.)
Computer Science
2006 - 2009
hislop college
Bachelor of computer Application
Computer Science