Archana Arockiadass

· Managing team and responsible for maintaining open communications with project leaders and management about project status, deadlines and release plans.

· Understanding the business context and translating business requirements to technical solutions.

· Code development and enhancement in accordance with the design, following relevant programming methodologies and applying agreed coding standards.

· Migrating legacy datawarehouse from Netezza to Cloud(Snowflake) which includes creating tables, sqls, scripts, maestro jobs and reports.

· Worked on ETL requirement to bring data from external sources via Nifi, Spark, Airflow to AWS and send extracts/load to Snowflake.

· Worked on DataLake in AWS to fulfill warehouse and business intelligence needs on Cloud.

· Provide leadership, performance feedback, mentoring and career development planning to team members.

· Understanding the business context and translating business requirements to technical solutions.

· Code development and enhancement in accordance with the design, following relevant programming methodologies and applying agreed coding standards.

· Creating system component artefacts covering contingency/code rollback plans.

· Expertise in development and implementation of different capabilities like MSI, MLI, MRS, MLP, MDA.

· Expertise in products like Cloud, IPCG Global

· Ensuring that the support teams are provided knowledge transfer for each release.

· Working with Project Manager/Delivery Manager on various stages of software development, enhancements and support, to meet SLA’s.

· Providing guidance and assistance to new employees and team members in programming methodologies, standards and technical/functional help.

· Handling and fixing of all the live and ORT issues.

· As a Project Lead, I have handled a team of 4 engineers across Onshore and Offshore.

· Attending calls with the Business and Offshore team on daily basis for Requirement clarifications and delivery Issues.

· Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs

· Identifying risks proactively and proposing solutions to resolve them.

· Developed several custom Forms to interact with data tables and schema.

· Explain Plan, Tkprof was used for checking the performance of queries.

· Modified and updated existing custom forms to adapt to new database schema.

· Modified Reports to suit client requirements.

· Development of interfaces to the CDS system for purchase orders, manufacturing orders, advanced ship notices and invoices.

· Automating existing customized manual process to standard processes.

· Creating Triggers, Stored Procedures and packages to enhance the existing application.

· Involved in the analysis, design and implementation of maintenance and enhancement modules of EDI Transactions.

· Create Technical Specifications, Test cases and perform unit testing.

· Involved in end-to-end development of Administration module for EDI system.

· Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader – for different cases).

· Generate SQL Reports and Automating existing customized manual process to standard processes.

· Sending Weekly status reports to Onsite and Offshore.