Aarthi Ravindra kumar

• Conversion of Abinito graphs to Spark code
• Migration of Abinitio graphs on premises to AWS EKS pods
• Performance tunning of Spark code
• Mananging the Customer Datamart of JPMC
• Mannaged the hadoop storage
• Ingestion of Fixed width ascii file , ebcidic file to data lake (AWS S3 and Hadoop) using spark code - Preprocess, Transformation and Loading
• Created AWS Glue tables , EKS pods

NBN (National Broadband Network) is an Australian national wholesale open access data network.

• Involved in the design, requirement gathering, development, testing and deployment of applications in AWS Redshift by extracting various source data from AWS S3 via in built spark framework in AWS EMR.
• Involved in designing and development of the ETL of new source data containing work order management system data to existing.
• Involved in end-to-end implementation of migration of the application to extract the completed work orders data from AWS Redshift and transfer the data via AWS S3 to the vendor SFTP server to conduct surveys. The epic involved building a complex functionality in the absence of strategic solution to push data NBN network to external vendor and massive coordination between Operations, Third Party Vendor, Business Team and development team which was successfully accomplished by exemplary communication skills.
• Involved in the designing and building reconciliation feed for billing data of the Sky Muster product from the vendor and BRM system in Netezza.
• Involved in the design, development and testing of the New Field Contract KPI metrics in CEDW - AWS Redshift.
• Prepared the High-Level Design and Detailed Design for various epics and presented in Design Authority (Architects) forum for approval.
• Prepared IDA documents for the end-to-end solutions provided.
• Successfully collaborated and deployment multiple applications in the production with strict timelines.

Virgin Media Limited is a British company which provides telephone, television and internet services the United Kingdom. CEO Scorecard is a critical project where the growth and success of the various work streams across VM is monitored by capturing key performance indicators and reported to the CEO of VM on monthly and weekly basis. The process of building Scorecard was a convoluted involving various stakeholders, generating intermediate files and manual adjustments. We automated the generation of CEO scorecard with in Netezza by adopting a new agile strategy involving:Step 1 -Data Analysis by conduction CRP calls with the stakeholders.Step 2 -Design and Prototype build with smaller data set.Step 3 -Design for the complete end to end implementation.Step 4 -Development to automate the scorecard to fetch the data directly from the source, which is Netezza, without involving manual intervention.Step 5 -End to end implementation from source to target.

• Conducting CRP calls with the stake holders to understand the existing convoluted manual process for generating the KPI (Key performance indicator) reported for various Scorecard work streams.
• Analyzed the existing process to define, detail and document desired end-to-end business process and workflows. Also, to identify the gaps and area of change between the existing and new process.
• The data from the various sources such as manually maintained data in Excel, OBIEE reports, SQL database, SSIS Package, Qlikview reports, MS Access database and Netezza DWH are analyzed by reverse engineering to ascertain on the business logic of score card KPI generation.
• Designed and data modeled to automate the process within Netezza DWH by adopting dimensional modeling and layered (landing layer, snapshot layer, final KPI metric layer) approach to build the scorecard.
• Developed prototype in Netezza by creating Type 2 SCD dimension tables, stored procedures, functions and CTEs.
• Created efficient table structures by generation optimal data distribution in the disk.
• Implemented end to end solution by creating ETL workflows in Informatica.
• Developed test cases in Netezza and did unit test on the functionality of the automated process.
• Coordinated and conducted the user acceptance testing by reconciling the automated KPI scorecards with the existing (manually generated) scorecards; with the clients with zero defects in UAT.
• Provided warranty support of the developed applications.
• Prepared BRD (Business Requirement document) based on the analysis, STTM documentation, Reconciliation sheet and TDD.
• Conduct code Netezza code reviews for peer projects and optimize the queries.

• Providing AOD (Answer on Demand) application support for SQL databases
• Design, development and Implementation of Oracle, MySQL and Netezza database objects as per the business requirement.
• Analyzing and developing queries to remove duplicate records in Netezza database. Ability to perform general administration activities on Oracle, MySQL and Netezza database
• Experience in troubleshooting database system performance.
• Ability to Analyze Queries and plan files to resolve the performance issue and optimize queries
• Monitor, troubleshoot and resolve database related issues. Managing and reporting Internal Team Pticket SLA breach.
• Prepared technical and functional designs Document in collaboration with teams and business users.
• Developed data warehouse solutions and application by translation of business and functional needs.
• Designed and Developed Fact and Dimensional tables as per the business requirement with SCD Type 1 and SCD type 2 Logic in Netezza.
• Implemented procedures for development of detailed specifications along with interfaces and platforms.
• Coordinated and conducted system integration testing and user acceptance testing.
• Managed Netezza queries by performance tuning and techniques such as CBT and Collocation.
• Automated Netezza SQLs through UNIX scripts and scheduled the jobs in ControlM.
• Involved in designing, capacity planning and creation of MySQL 5.5/5.6 database objects in production environment.
• Collaborate with core team, Project Management and other teams to provide the appropriate solution