Tampa, Florida, United States
● Over 15+ years of experience in Analysis, Design, Development, Up- gradation of Applications. ● Managed technical services and support operations both onshore and offshore. ● Expertise in Oracle Database, SQL, PL/SQL, Performance tuning. ● Experience in Python programming for ETL processes, particularly in transforming and loading data from various sources into target systems. ● 13+ years of experience with Oracle databases, proficient in writing complex queries and developing intricate PL/SQL database objects, including both DML and DDL. ● Proficient in database management and SQL performance tuning, optimizing query execution for enhanced system efficiency and responsiveness. ● Demonstrated ability to thrive under pressure, consistently meeting deadlines while upholding high standards of quality and efficiency. ● Hands experience in AWS RedShift, Unix shell scripting, ODI (Oracle Data Integrator), Airflow, BI tool Hyperion, Angular UI. ● Knowledge on AWS services and Data Analysis. ● Worked on Migration of Oracle to Redshift Datawarehouse.
• Serving as Senior Technical Leader for a high-impact data migration project. • Leading the migration of data and digital assets from legacy systems to the modern DXP (Digital Experience Platform). • Writing Python scripts to perform ETL operations, particularly focused on transforming and loading large datasets efficiently. • Collaborating closely with client teams to assess existing systems and strategize seamless transitions to the new platform. • Managing technical deliverables, ensuring high-quality outcomes and adherence to project timelines. • Conducting performance tuning, database optimization, and validation of migrated data for accuracy and integrity. • Providing ongoing technical guidance and support for integration challenges and production issues.
• Performing Technical lead and onsite coordinator role. • Working as Oracle PL/SQL Developer for creating Oracle database design and objects and experience on PL/SQL packages, procedures, functions, triggers. • Conducted SQL Review and performance tuning. • Working on data modeling, database schema design. • Successful Migration of Oracle Datawarehouse to AWS Redshift Datawarehouse. • Monitor the CPU utilization, application logs in AWS CloudWatch services. • Performed Analysis, Design, Technical Lead and Development of ETL and Migration. • Working on business intelligence (BI) tool Hyperion(Brio). • Worked on complex weightage concept which projects market analysis outcome by utilizing the Universe Estimate data. • Hands on experience of User Interface in Angular. • Identifying Use cases and preparation of test cases. • Providing technical support for critical SEV1 to Production Support team.
● Requirements Planning, Gathering, Documentation and Analysis. ● Worked on data modeling and database schema design. ● Worked on SQL Development such as SQL queries, complex queries, joins, aggregate functions, analytic functions, views, materialized views, SYS related views, partitioning and explain plan. ● Conducted SQL Review and performance tuning. ● Worked on PLSQL Development. ● Used ODI Topology manager to define data servers and physical schemas for various sources and target databases. ● Implemented the CDC Change Data Capture feature of ODI to minimize the data load times. ● Hands on experience on dealing with ODI Knowledge Modules like LKM, IKM and JKN, CKM. ● Analysis/Design & Development of User Interface and Business Tier. ● Identifying Use cases, preparation of test plans and test cases ● Production migration and Production Support. ● Carry out maintenance and enhancement activities which include. o Impact Analysis. o High Level and Low Level Design. o Unit Test Plan. o Coding. o Unit testing and Unit test Results. o Code Reviews and Walkthrough. ● Carry out Quality assurance activities (reviews, walkthrough etc.) as defined in the Project Plan. ● Report progress to Nielsen and TCS (TATA Consultancy Services) management. ● Be responsible for the overall quality and timeliness of the deliverables.
Developing PLSQL functions, procedures and packages for providing data to UI part. Skilled in implementing robust database security measures to safeguard sensitive information and ensure compliance with industry standards Designed and developed Oracle forms and reports. Experienced in utilizing Git version control for efficient collaboration, code management, and project tracking in software development workflows. Experienced in Agile methodologies, adept at facilitating iterative development cycles and fostering collaboration to deliver high-quality software solutions. Developing Java Classes for UI part. Interaction with clients regarding delivery procedures. Understanding the overall business knowledge and implementing them in the application. Involved in checking the standards of a program. This helps to follow a certain level of standards consistently throughout the application. Coordination with team members to allow subsequent development of other modules. Software estimation and estimation of the size of the project and capacity planning.
1. Developing and Delivering Reports to users on time. 2. Writing procedures, functions and Packages using Oracle-PL/SQL for developing reports 3. Writing Shell Scripts in UNIX for loading data into files and delivering to respective servers or re-directing them automatically to respective mail box 4. Monitoring cron jobs and debugging the erroneous scripts and reporting status on time during business hours including night shifts. 5. Helping the team in various technical aspects, enhancements activities. 6. Knowledge transition for newly joined team members. Working on severity tickets and resolving without breaching its SLA.