Swapnil Nikam

Role and Responsibilities

· Gathering Requirements from business teams and other stake holders

· Understanding and analyzing the feasibility of requirement and converting them into technical specification.

· Working with Different Stake Owner for Project Proposal and determine the Projects Goals

· Participating in requirement and Architecture briefing to assess the feasibility.

· Providing the Technical and Functional Support to Business in various Projects stages

· API Integrations

· Working with Vendors and Various Internal teams while executing the Projects

· Managed financial operations, overseeing budgeting, forecasting and financial analysis activities.

· Executing the IT Initiatives for Design, Development, and Implementation roll-out & Support Banking systems.

· Handling application audits , VA, CA , AppSec, Governance,Complience.

· Managing the implementation and configurations of new fixes and patches from Vendor’s

· Management and assignment of Team based on Criticality of Projects

· Preparing the test cases and case study.

· Responsible for the integrity of application’s

· Fixing and monitoring the Production issues in timely manner

· Periodically provide updates to Bank’s top Management about status of projects.

· PCIDSS implementation

· Implemented process improvement procedures that resulted in cost savings across the board.

• Developed SSIS(ETL) packages to extract data from various sources and loaded into SQL Server database using SSIS.
• Created stored procedures, views, triggers, functions and other T-SQL code for the implementation of business logic.
• Built complex reports with drill down capabilities using MSBI stack including SSRS.
• Tested the accuracy of data by running validation checks against source systems prior to loading into staging tables or cubes.
• Performed performance tuning on existing T-SQL queries, indexes and cube processing tasks.
• Deployed SSIS packages on production servers after successful testing in development environment.
• Provided technical support to end users in resolving their issues related to reports or dashboards created using MSBI technologies.
• Monitored system resources usage during peak loads and optimized query execution plans accordingly.
• Provided technical support for existing reports, dashboards or other tools.
• Analyzed and tracked data to prepare forecasts and identify trends.