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.
amutha.ayyadurai@gmail.com
English
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.