Summary
Overview
Work History
Education
Skills
Contactemail
Toolsandtechnology
Area Of Expertise
Personal Information
Languages
Projects
Timeline
Generic

Amutha Ayyadurai

Brussels

Summary

Enthusiastic Software Professional with 11 years of experience in software development across various domains. Highly organized, result oriented individual with Go - Getter attitude, capable of delivering project bounded by multiple constraints.

Enthusiastic Software Professional with 11 years of experience in software development across various domains. Highly organized, result oriented individual with Go - Getter attitude, capable of delivering project bounded by multiple constraints. AREA OF EXPERTISE Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema. Worked on Waterfall and Agile Sprint based development. Hands on experience in Informatica PowerCenter, Unix Shell Scripting, Power BI, SSRS and SSI, SQL scripts. Experienced as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines. Knowledge in SQL Server Analysis Services and Cognos reporting. Domain knowledge on Telecom, Energy and Manufacturing. Working in Belgium with work experience in India Worked with US and Belgium clients. A skilled problem-solver and efficient team player. Possess good interpersonal and communication skills. Architecture Design and Implementation of various process automation features in the project.

Overview

11
11
years of professional experience

Work History

BI Analyst/Technical Analyst/Functional Analyst

Infosys
Brussels
03.2020 - Current
  • Leading a team of 13 developers, expertise in creating Detail Design documents for technical teams based on Business Requirement
  • Assist Product owner in estimation of features / user stories
  • Actively involved in technical aspect of the application involved in SAS (Solution Architecture & Strategy) maturation
  • Involved with test team for E2E test plan preparation
  • Keeping track of project timelines and ensuring projects are completed within SLA
  • Understanding AS-IS model and proposing a TO-BE model that is more efficient in processing the fiber data in Proximus
  • Played the role of Functional analyst and technical analyst.

BI Analyst & Lead Developer

Infosys
Bangalore
07.2016 - 02.2020
  • Designed and developed performance efficient mappings
  • Involved in conducting reviews for the codes after development
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter
  • Developed unit test case scenarios for thoroughly testing ETL processes and shared them with testing team
  • Implemented various automation process through Unix Shell scripting
  • Knowledge on SOAP UI
  • Direct interaction with Client and End-Users for requirement gathering and demonstration of the reports
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as unit work performance for domain managers, incident management and list of SLA breached incidents on hourly basis with slicers enabling end-user to make filters
  • Created visualization utilizing Cross Tabs, Maps, Scatter Plots, Tree Map, Funnel, Pie, Bar, Line Charts and Stacked reports
  • Knowledge on Power BI DAX Functions, Licenses and Gateway Types, App Creation, Publishing
  • Work in a fast-paced environment, under minimal supervision
  • Working closely with Onshore and offshore application development leads
  • Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements
  • Responsible for designing and developing key ETL processes
  • Created the required documents like Mapping Documents, UTR, UTP, ATB, Detail Design Document, Logical data model
  • Responsible for Performance Tuning of sources, targets, mappings and sessions
  • Scheduling and monitoring of load sessions using Maestro
  • Code promotion to Integration and UAT and Production environments.

Lead Developer & Technical Analyst

Infosys
Bangalore
03.2014 - 06.2016
  • Worked in Time Warner Cable (Telecom), NY, USA project for 1+ year
  • Job responsibilities include on-demand SSRS reports from BRD, migration of Cognos reports to SSRS
  • Optimizing the T-SQL query to reduce the run time of report
  • Worked on various SSIS package transformations for export and import of SQL Server/Oracle based data.

Lead Developer

Infosys
Bangalore
08.2014 - 02.2015
  • Worked in Baker Hughes (Oil and Gas), Houston, USA project for 4+ months
  • Job responsibilities include developing and onboarding of SSRS reports for client's Operations plants
  • Handled development of Purchase order volume reports and OTD reports
  • Expertise in developing Parameterized, Chart, Graph, Linked, Drill-down and Drillthrough reports using SSRS
  • Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks
  • Involved in Installation, Configuration and Deployment of Reports using SSRS with ScaleOut topology
  • Experience in SDLC life cycle for Design, Development and Staging phases of the projects with support of Dataflow, Process Models, E-R Diagrams
  • Created various support documents like Business Requirement document, Mapping Documents and Technical design document.

Developer

Infosys
Bangalore
06.2013 - 07.2014
  • Worked in Microsoft (Manufacturing), Richmond, USA project for 9+ months with a team of 4 members
  • Job responsibilities include creating and maintaining database objects such as indexes, views, stored procedures, and user defined functions in T-SQL, performance tuning on database
  • Test data integrity among various sources, targets and various performance issues
  • Created Linked Server for load balancing and increased the performance of the Data Warehouse
  • Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes
  • Scheduled Jobs and Alerting using SQL Server Agent
  • Rigorously tested and debugged all the scripts to test the validity of the data after the export/import/delete were done
  • Performed full, transactional, and differential backup
  • Worked on SSIS packages
  • Actively participated in User Acceptance Testing and debugging of the system
  • Conducted knowledge transfer to help internal team members.

Education

M.B.A Information Systems -

Bharathiyar University, Coimbatore
05.2014

Bachelor of Engineering in Computer Science -

Sri Ramakrishna Institute of Technology, Anna University
04.2012

Skills

  • Data Modeling
  • Star schema
  • Snowflake schema
  • Waterfall
  • Agile Sprint
  • Informatica PowerCenter
  • Unix Shell Scripting
  • Power BI
  • SSRS
  • SSI
  • SQL scripts
  • Oracle PL/SQL Developer
  • Analysis
  • Design
  • Implementation
  • Business Applications
  • Oracle Relational Database Management System
  • SDLC
  • SQL Server Analysis Services
  • Cognos reporting
  • Telecom
  • Energy
  • Manufacturing
  • Problem-solving
  • Team player
  • Interpersonal skills
  • Communication skills
  • Architecture Design
  • Process automation
  • Agile Methodology
  • Data Visualization
  • BI tools expertise
  • Data Mapping
  • Problem-solving abilities

Contactemail

amutha.ayyadurai@gmail.com

Toolsandtechnology

  • Informatica Power Center
  • SQL Server Integration Services
  • SQL Server Reporting Services
  • MS Power BI Reporting
  • MS Management Studio (TSQL)
  • Oracle PL/SQL Developer (PLSQL)
  • MS Reporting Analytics
  • Unix Shell Scripting
  • MS Visio
  • MS Word
  • MS Excel
  • Agile Tools- Rally, Jira, Target Process

Area Of Expertise

  • Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.
  • Worked on Waterfall and Agile Sprint based development.
  • Hands on experience in Informatica PowerCenter, Unix Shell Scripting, Power BI, SSRS and SSI, SQL scripts.
  • Experienced as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
  • Knowledge in SQL Server Analysis Services and Cognos reporting.
  • Domain knowledge on Telecom, Energy and Manufacturing.
  • Working in Belgium with work experience in India
  • Worked with US and Belgium clients.
  • A skilled problem-solver and efficient team player. Possess good interpersonal and communication skills.
  • Architecture Design and Implementation of various process automation features in the project.

Personal Information

  • Date of Birth: 08/09/1990
  • Marital Status: Single

Languages

English

Projects

Infosys, Brussels, Belgium, Proximus (Telecom), Belgium, THINK, 03/2020 - Present, Leading a team of 13 developers, expertise in creating Detail Design documents for technical teams based on Business Requirement., Assist Product owner in estimation of features / user stories., Actively involved in technical aspect of the application involved in SAS (Solution Architecture & Strategy) maturation., Involved with test team for E2E test plan preparation., Keeping track of project timelines and ensuring projects are completed within SLA., Understanding AS-IS model and proposing a TO-BE model that is more efficient in processing the fiber data in Proximus., Played the role of Functional analyst and technical analyst. Infosys, Bangalore, India, Proximus (Telecom), Belgium, THINK, HP SCE Reporting, EXCITE, 07/2016 - 02/2020, Designed and developed performance efficient mappings., Involved in conducting reviews for the codes after development., Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter., Developed unit test case scenarios for thoroughly testing ETL processes and shared them with testing team., Implemented various automation process through Unix Shell scripting., Knowledge on SOAP UI., Direct interaction with Client and End-Users for requirement gathering and demonstration of the reports., Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as unit work performance for domain managers, incident management and list of SLA breached incidents on hourly basis with slicers enabling end-user to make filters., Created visualization utilizing Cross Tabs, Maps, Scatter Plots, Tree Map, Funnel, Pie, Bar, Line Charts and Stacked reports., Knowledge on Power BI DAX Functions, Licenses and Gateway Types, App Creation, Publishing, Work in a fast-paced environment, under minimal supervision, Working closely with Onshore and offshore application development leads., Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements., Responsible for designing and developing key ETL processes., Created the required documents like Mapping Documents, UTR, UTP, ATB, Detail Design Document, Logical data model., Responsible for Performance Tuning of sources, targets, mappings and sessions., Scheduling and monitoring of load sessions using Maestro., Code promotion to Integration and UAT and Production environments Infosys, Bangalore, India, Time Warner Cable (Telecom), NY, USA, Finance Metrics & Ad hoc BI, 03/2015 - 06/2016, Worked in Finance Metrics project for 1+ year., Job responsibilities include on-demand SSRS reports from BRD, migration of Cognos reports to SSRS., Optimizing the T-SQL query to reduce the run time of report., Worked on various SSIS package transformations for export and import of SQL Server/Oracle based data. Infosys, Bangalore, India, Baker Hughes (Oil and Gas), Houston, USA, Celle, 08/2014 - 02/2015, Worked in BH Celle project for 4+ months. Job responsibilities include developing and onboarding of SSRS reports for client's Operations plants., Handled development of Purchase order volume reports and OTD reports., Expertise in developing Parameterized, Chart, Graph, Linked, Drill-down and Drillthrough reports using SSRS., Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks., Involved in Installation, Configuration and Deployment of Reports using SSRS with ScaleOut topology., Experience in SDLC life cycle for Design, Development and Staging phases of the projects with support of Dataflow, Process Models, E-R Diagrams., Created various support documents like Business Requirement document, Mapping Documents and Technical design document. Infosys, Bangalore, India, Microsoft (Manufacturing), Richmond, USA, Skylab, 09/2013 - 07/2014, Worked in Microsoft Skylab project for 9+ months with a team of 4 members., Job responsibilities include creating and maintaining database objects such as indexes, views, stored procedures, and user defined functions in T-SQL, performance tuning on database., Test data integrity among various sources, targets and various performance issues., Created Linked Server for load balancing and increased the performance of the Data Warehouse., Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes. Scheduled Jobs and Alerting using SQL Server Agent., Rigorously tested and debugged all the scripts to test the validity of the data after the export/import/delete were done., Performed full, transactional, and differential backup., Worked on SSIS packages., Actively participated in User Acceptance Testing and debugging of the system., Conducted knowledge transfer to help internal team members.

Timeline

BI Analyst/Technical Analyst/Functional Analyst

Infosys
03.2020 - Current

BI Analyst & Lead Developer

Infosys
07.2016 - 02.2020

Lead Developer

Infosys
08.2014 - 02.2015

Lead Developer & Technical Analyst

Infosys
03.2014 - 06.2016

Developer

Infosys
06.2013 - 07.2014

M.B.A Information Systems -

Bharathiyar University, Coimbatore

Bachelor of Engineering in Computer Science -

Sri Ramakrishna Institute of Technology, Anna University
Amutha Ayyadurai