Summary
Overview
Work History
Education
Skills
Disclaimer
Projects
Timeline
Generic
Leena Nayak

Leena Nayak

Hyderabad

Summary

With an overall experience of 13 years spread across technology migration of legacy systems to competitive business systems as per new tech stacks, I have ensured the products I worked, met adapt to newer datacenter and technology requirements.

Overview

14
14
years of professional experience

Work History

Associate Software Engineer

JPMorgan Chase & Co
Hyderabad
04.2022 - Current
  • Implemented ETL processes to extract, transform and load data into the data warehouse environment.
  • Maintained database performance by troubleshooting query problems and optimizing queries for better results.
  • Monitored system performance to ensure efficient operations of the data warehouse.
  • Performed unit testing on all development objects before production deployment.
  • Assisted with extracting large datasets from multiple sources into a central repository for analysis.
  • Developed scripts for automating regular maintenance tasks associated with Data Warehousing.
  • Maintained up-to-date knowledge of new technologies available that could be utilized in improving current Data Warehousing solutions.
  • Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
  • Involved in creating database objects such as tables, views, indexes based on business requirements.
  • Resolved complex issues related to ETL process through debugging existing code or writing new programs.
  • Maintained source system metadata information in order to ensure accuracy of the ETL process.
  • Analyzed large volumes of data to determine trends and patterns that can be used to improve business processes.
  • Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.
  • Developed complex Oracle PL and SQL packages, procedures, functions and triggers to support application development.
  • Analyzed existing database objects for performance issues and implemented tuning solutions.
  • Implemented Oracle database changes based on business requirements.
  • Investigated reported incidents and took appropriate action based on findings.
  • Created automated scripts for build and release activities using shell scripting or other languages.

Senior Software Engineer

Cognizant technology
Hyderabad
05.2019 - 03.2022
  • Developed ETL process to extract, transform and load data from Oracle database into the Data Warehouse using Informatica PowerCenter.
  • Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
  • Optimized existing ETL processes by analyzing performance bottlenecks and implementing best practices in Informatica PowerCenter.
  • Performed unit testing of mappings, sessions and workflows developed in Informatica PowerCenter.
  • Provided production support for all ETL related issues involving Informatica PowerCenter.
  • Monitored loading jobs on daily basis to ensure that all ETL jobs are running as scheduled.
  • Designed complex transformations using various transformation objects like Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.
  • Identified data quality issues and worked with business users to resolve them in a timely manner.
  • Migrated existing code base from lower version of informatica to higher version.
  • Used Performance tuning techniques such as Partitioning technique and Bulk Loader options available within Transformations section while developing Mapping logic .
  • Identified, debugged, and fixed system bottlenecks and problems.
  • Developed stored procedures, functions and packages using PLSQL to support the application development needs.
  • Designed complex database objects like tables, views, triggers and indexes as per business requirements.
  • Optimized SQL queries for better performance by analyzing execution plans and query optimization techniques.

Software Engineer

Tech Mahindra
Bhubaneswar
04.2011 - 05.2019
  • Analyzing the requirement and prepared design document.
  • Have worked on UNIX scripting.
  • Have used various Power Center Transformations and tools, Design Power Center Mappings, Workflows, Worklets based on the requirements.
  • Have used the concept of Parameter files, Variables etc. in Informatica.
  • Involved in Unit Testing.
  • Understood the functionality and the data flow in Aviation domain.
  • Have worked in understanding and translating business requirements to ETL processes.
  • Have used various Power center Transformations and tools, Design Power Center Mappings, Workflows, Worklets based on the requirements.
  • Have used the concept of Parameter files, Variables etc in Informatica.
  • Performed Code review and wrote Unit Test Cases.
  • Have also worked on Testing the Code in DEV, QA and Production and addressing the issues at all levels.
  • Have performed Code promotion from Development to QA and to Production.
  • Have Worked on Scheduling of Power Center Workflows.

Education

B.Sc - IT

Kuvempu University
Karnataka

Diploma - Information Technology and engineering

Sundargarh Engineering School
Odisha

Skills

  • Informatica (91,101,105)
  • Informatica Intelligent Cloud Service
  • SQL
  • PL/SQL
  • Oracle (9i,10g,11g)
  • Tera data
  • Greenplum
  • SQL Developer
  • Toad
  • Unix shell script,Python
  • Autosys
  • Pentaho
  • Talend
  • Putty
  • Jira

Disclaimer

I hereby declare that the above-mentioned information is true to the best of my knowledge and belief.

Projects

JPMORGAN

ALM is privileged access discovery tool that enables privileged account owner to monitor , manage and control privileged access accounts.Account details are collected by ALM on a weekly basic .We receive the data from different platforms like Xygate,Synscort, Active directory, Spohia, EPV  etc every week for detection of account controls.

Cognizant

Projcect-1

Test Data Management Humana is managed Health care Company that markets and administers health insurance in the United States. Humana Inc. is an American Louisville, Kentucky-based for-profit health insurance company. As of 2014 Humana has had over 13 million customers in the U.S, reported a 2013 revenue of US$41.3 billion, and has had over 52,000 employees. In 2013, the company ranked 73 on the Fortune 500 list, which made it the highest ranked (by revenues) company based in Kentucky. It has been the third largest health insurance in the nation. The U.S. Dept. of Health and Human Services investigated Humana in 2009 for sending flyers to MediCare recipients that the AARP characterized as deceptive. The company's managed care model has also been criticized for ethical lapses and limitations. The health insurer Aetna had acquired Humana for $37 billion. 

Projcect-2

CMDM (Campaign Management Data Mart) deal with pulling the claims, inbound/outbound responses, dispositions, preferences, and demographic info etc. data from multiple data sources like user files, EDW (Oracle) in to campaign database (Netezaa), where EMM (Enterprise Marketing Management) can use for creating reports and send to end users.

Tech Mahindra

Project-1

FDL is the collection and consolidation of nearly all available financial data related to GE activities. FDL makes this data available to the industries, business units and corporate management to support internal and external operative reporting just as ad-hoc and advanced analytics.

We integrate data from several heterogeneous sources like Oracle, Teradata, and Flat-files etc. into a centralized Greenplum database using ETL tool like Talend Studio.

Project-2

GE aviation, a subsidiary of General Electric, is headquartered in Evansdale, Ohio (a Cincinnati suburb).GE Aviation is the top supplier of aircraft engines in the world and offers engines for the majority of commercial aircraft.GE Aviation is part of GE Technology infrastructure, itself a major part of the conglomerate General Electric, one of the world’s largest Corporations.

System Engineering DWH application is responsible to get financial data as flat file source from corporate system and loading into GE Aviation data warehouse. Financial data like Invoice, Payment, Requisition, Purchase, Supplier, Receipt etc. Source file is having both header and details level information with having identification of Rec type and also coming from different vendor and organization. System Engineering DWH application splitting the record based on rec type. 

Project-3

GE Aviation, a subsidiary of General Electric, is headquartered in Evansdale, Ohio (a Cincinnati suburb). GE Aviation is the top supplier of aircraft engines in the world and offers engines for the majority of commercial aircraft. GE Aviation is part of GE Technology Infrastructure, itself a major part of the conglomerate General Electric, one of the world's largest corporations.

Pulling Best-Version-of-Truth Master data (Like Customers, Part, Product, Engine Hierarchy, ESN, Contracts etc.) from MDM, EBOM and ADW for different sources and loading to CSA DATA, where downstream application team can access the master data from single system.

Project-4 

CSAi: The primary objective of the CSAi dashboard is to provide BI capabilities to a wide range of GE Aviation personnel. These are complex and robust BI applications that will provide a great degree of development flexibility. Most importantly, the CSAi dashboard will bring high visibility about the state of the business to a wide array of users.

The CSA Intelligence dashboard will automate the delivery of shop visit results to operational and shops leads and upper management. They will be used to track the ongoing health of CSA contract performance in an effort to understand the impact on operating margin and identify those variables which can be brought to bear for cost migration and target modeling accuracy.

Timeline

Associate Software Engineer

JPMorgan Chase & Co
04.2022 - Current

Senior Software Engineer

Cognizant technology
05.2019 - 03.2022

Software Engineer

Tech Mahindra
04.2011 - 05.2019

B.Sc - IT

Kuvempu University

Diploma - Information Technology and engineering

Sundargarh Engineering School
Leena Nayak