• Supporting and Maintaining the existing EMEA Reports exists in SharePoint
• Supporting the Daily and Monthly financial process available in SQL Server
• Monitoring the Existing Alteryx workflows scheduled and supporting for issues and enhancement
• Scheduling meeting with clients for requirement review and estimation
• Creating new Alteryx workflows using various tools available based on requirement document and schedule to publish data to tableau server for dashboard development
• creating new tableau dashboards by using the datasets published via Alteryx workflows
• Grant/Revoke access to dashboards for user and user groups

• Design, Development and Deployment of SSIS packages to support the business requirement
• Troubleshooting live issues by identifying the root cause and raising defects for fixing the same through sprints
• Enhancing and Maintaining data feed SSIS packages. Monitoring SSIS jobs on a daily basis and update status to onsite coordinators
• Design, Development, Support and Deployment of SSRS tabular and matrix reports to monitor SSIS package execution status to provide instructions to hosted team
• Developing supporting stored procedures, views, functions, tables, triggers for SSIS packages and SSRS reports
• DB backup, restore and setting up the replication for the development box
• Actively participating in Requirement gathering, Elaboration of new requirements and estimation
• Part of Sprint planning, Sprint review and retrospective calls.
• Leading, guiding and grooming the extracts team
• Reviewing the code for standards, issues and rewriting logic if needed.
• Debugging Performance issues with SSIS and SQL queries and applying best practices
• Conducting Sessions on Advanced concepts in SQL Server to give an awareness to others teams on the floor.
• Part of DB team to review fixes provided by others team before the final review by UK Team Architects
• Direct client interaction in case of escalation.
• Developed a small sql based solution to Anonymize production data for volume and performance testing

·         Developing business critical reports using SSRS and supporting for possible enhancement and fixes through DM release.

·         Enhancing and maintaining data feed SSIS packages. Monitoring SSIS jobs on a daily basis and update status to onsite coordinators

To follow up on escalations and issues with clients and onsite managers

·         Coordinating with Client for issues related to Production Support and provides warning to avoid a possible outages or system slowdown

·         Involved in post implementation maintenance of the existing projects

·         Involved in process maintenance, defect monitoring

·         Analyzing the business logic and troubleshooting system and suggested alternate solutions to add new functionalities and to improve performance of the existing functionalities

·         Executing the feed rollouts on request basis from the stake holders

·         Monitoring the issues and generates the necessary analysis and post mortem documents

·         Review and provide regular feedback to the team on the correctness and stability of the changes done by the team.

·         Ensuring that the delivered test artifacts confirms to the customer requirements and agreed quality standards

·         To follow up on escalations and issues with clients and onsite managers

·         Handling of SCM (PO, GR, and INVENTORY) and Finance modules (AR, AP and GL) with Real Estate solution.

·         Responsible for Analysis, Design, Coding and debugging

·         Responsible for Data Migration from Oracle Apps to SQL Server

·         Responsible for Administration activities like Backup & restore, user creation etc

·         Verification of migrated data with the forward cycles.

·         Customization of the product and Defect Fixing

·         Developed reports for the Purchase Modules Using Excel & Crystal Reports

·         Given user support for the Purchase and Finance Modules.

·         Responsible for analysis & reconciliation of data to ensure consistency

·         Responsible for Design, Construction and Testing of CR’s

·         Responsible for Fixing the defects found during unit, system & UAT

·         Responsible for collection & verification of CR documents for Quality Audit

·         Responsible for providing/reviewing data patches for the critical issues

·         Responsible for scheduling consistency checks & root cause analysis