Experience

AIB Merchant Services
• Ireland
• Financial Services
• 100 - 200 Employee
• Senior Data Warehouse Developer

  • May 2019 - Present

Global Payments Inc.
• United States
• Financial Services
• 1 - 100 Employee
• Business Intelligence Developer

  • Sep 2017 - May 2019


Software Business Solutions Consulting (SBSC)

• United States
• IT Services and IT Consulting
• 100 - 200 Employee

• Software Engineer

  • Oct 2015 - Mar 2017

  ORGANIZATIONAL PROJECTS Project Title : Cascade Comprehensive Care Project Description: Development of dashboards and visualisations in Tableau, replacing the client’s legacy system comprised of MS-Access and MS Excel for report generation. The development includes data migration from client’s MS-Access Database and Master Database to our MS SQL Server 2012 database, implementing business logic through stored procedures and other database objects to replace forms in MS Access… Show more ORGANIZATIONAL PROJECTS Project Title : Cascade Comprehensive Care Project Description: Development of dashboards and visualisations in Tableau, replacing the client’s legacy system comprised of MS-Access and MS Excel for report generation. The development includes data migration from client’s MS-Access Database and Master Database to our MS SQL Server 2012 database, implementing business logic through stored procedures and other database objects to replace forms in MS Access and Formulas in MS Excel. Roles and Responsibilities: • Gathering client’s requirement and designing solution for the same. • Consult with clients and internal stakeholders to gather requirements and plan delivery in the research, development, and implementation phases of the project lifecycle. • Preparing visualisations using filters, calculations, parameters, graphs, standard text tables etc. in Tableau. • Developing stored procedures, functions, triggers to implement business logic. • Testing of the reports against the clients legacy system excel reports. Project Title : CA Clarity PPM (Walmart) Project Description: SSIS Packages are designed to import data from Clarity Database (Oracle) and MS-Excel Files to our SQL Server Data Warehouse. Clarity is an integrated solution that is used to manage the services, projects, products, people and financials of an organisation. It gives a real-time view into organization’s investments, initiatives and resources, and empowers to deliver controlled and predictable execution of projects and programs. The SQL Server Agents Jobs are scheduled to execute these packages on daily basis and load the data in Data Warehouse. Roles and Responsibilities: • Development of new SSIS packages. • Daily Monitoring of SQL Server Jobs. • Error handling and fixing of the bugs in SSIS Packages. • Implementing the Change Requests submitted by client. • Documentation of RCA of the bugs and their fix. Show less ORGANIZATIONAL PROJECTS Project Title : Cascade Comprehensive Care Project Description: Development of dashboards and visualisations in Tableau, replacing the client’s legacy system comprised of MS-Access and MS Excel for report generation. The development includes data migration from client’s MS-Access Database and Master Database to our MS SQL Server 2012 database, implementing business logic through stored procedures and other database objects to replace forms in MS Access… Show more ORGANIZATIONAL PROJECTS Project Title : Cascade Comprehensive Care Project Description: Development of dashboards and visualisations in Tableau, replacing the client’s legacy system comprised of MS-Access and MS Excel for report generation. The development includes data migration from client’s MS-Access Database and Master Database to our MS SQL Server 2012 database, implementing business logic through stored procedures and other database objects to replace forms in MS Access and Formulas in MS Excel. Roles and Responsibilities: • Gathering client’s requirement and designing solution for the same. • Consult with clients and internal stakeholders to gather requirements and plan delivery in the research, development, and implementation phases of the project lifecycle. • Preparing visualisations using filters, calculations, parameters, graphs, standard text tables etc. in Tableau. • Developing stored procedures, functions, triggers to implement business logic. • Testing of the reports against the clients legacy system excel reports. Project Title : CA Clarity PPM (Walmart) Project Description: SSIS Packages are designed to import data from Clarity Database (Oracle) and MS-Excel Files to our SQL Server Data Warehouse. Clarity is an integrated solution that is used to manage the services, projects, products, people and financials of an organisation. It gives a real-time view into organization’s investments, initiatives and resources, and empowers to deliver controlled and predictable execution of projects and programs. The SQL Server Agents Jobs are scheduled to execute these packages on daily basis and load the data in Data Warehouse. Roles and Responsibilities: • Development of new SSIS packages. • Daily Monitoring of SQL Server Jobs. • Error handling and fixing of the bugs in SSIS Packages. • Implementing the Change Requests submitted by client. • Documentation of RCA of the bugs and their fix. Show less



Dell Services

• Software Dev Analyst

  • Jul 2012 - Oct 2015

  ORGANIZATIONAL PROJECTS Project Title : Acenden Mortgaging Solutions Ltd The team carries out the end to end activities for the Acenden Mortgaging Solutions Ltd of UK. Development, Maintenance & support are carried out by the team to process the day to-day activities of the bank. The Experian Product Tallyman system acts as the solution builder for the Bank customers having Mortgage Loans. The strategies are built using the Decision Analytics Tool (Tallyman) for debt… Show more ORGANIZATIONAL PROJECTS Project Title : Acenden Mortgaging Solutions Ltd The team carries out the end to end activities for the Acenden Mortgaging Solutions Ltd of UK. Development, Maintenance & support are carried out by the team to process the day to-day activities of the bank. The Experian Product Tallyman system acts as the solution builder for the Bank customers having Mortgage Loans. The strategies are built using the Decision Analytics Tool (Tallyman) for debt management and based on these strategies appropriate actions are taken on the accounts. • Understanding the business logic and outlining the technical requirements out of that logic. • Preparing documents prior to development phase such as estimation sheet, query log, low-level design document, etc. • Technical integration & delivery of the Tallyman solution. • Designing and configuration of Strategy, Activities, Tasks, Dictionaries etc. in Tallyman Tool as per the requirement. • Define Inbound and Outbound Interfaces • Monitoring accounts flow and allocation of accounts to the collector. • Responsible for the specification, quality assurance and delivery of all project development. • Responsible for the timely and complete handover of the project to the Helpdesk following go-live. Project Title : Tallyman Database Services Experian's Decision Analytics business specializes in providing debt collections and recoveries, credit risk and fraud management consulting services and products to enable organizations to make fast, accurate and profitable decisions. The team develops and maintains database objects used in Tallyman such as stored procedures, functions, tables, etc. • Responsible for creating, modification of packages, procedure, triggers and others database objects in PL/SQL and Transact SQL. • SQL Query optimization and performance tuning. • Carrying out the change requests in Database Objects. • Analysis and research of the production issues through incident management. Show less ORGANIZATIONAL PROJECTS Project Title : Acenden Mortgaging Solutions Ltd The team carries out the end to end activities for the Acenden Mortgaging Solutions Ltd of UK. Development, Maintenance & support are carried out by the team to process the day to-day activities of the bank. The Experian Product Tallyman system acts as the solution builder for the Bank customers having Mortgage Loans. The strategies are built using the Decision Analytics Tool (Tallyman) for debt… Show more ORGANIZATIONAL PROJECTS Project Title : Acenden Mortgaging Solutions Ltd The team carries out the end to end activities for the Acenden Mortgaging Solutions Ltd of UK. Development, Maintenance & support are carried out by the team to process the day to-day activities of the bank. The Experian Product Tallyman system acts as the solution builder for the Bank customers having Mortgage Loans. The strategies are built using the Decision Analytics Tool (Tallyman) for debt management and based on these strategies appropriate actions are taken on the accounts. • Understanding the business logic and outlining the technical requirements out of that logic. • Preparing documents prior to development phase such as estimation sheet, query log, low-level design document, etc. • Technical integration & delivery of the Tallyman solution. • Designing and configuration of Strategy, Activities, Tasks, Dictionaries etc. in Tallyman Tool as per the requirement. • Define Inbound and Outbound Interfaces • Monitoring accounts flow and allocation of accounts to the collector. • Responsible for the specification, quality assurance and delivery of all project development. • Responsible for the timely and complete handover of the project to the Helpdesk following go-live. Project Title : Tallyman Database Services Experian's Decision Analytics business specializes in providing debt collections and recoveries, credit risk and fraud management consulting services and products to enable organizations to make fast, accurate and profitable decisions. The team develops and maintains database objects used in Tallyman such as stored procedures, functions, tables, etc. • Responsible for creating, modification of packages, procedure, triggers and others database objects in PL/SQL and Transact SQL. • SQL Query optimization and performance tuning. • Carrying out the change requests in Database Objects. • Analysis and research of the production issues through incident management. Show less