Neelima Mukkala

PL/SQL developer with 16+ years of experience in building data intensive applications handling challenging architectural and scalability problems, collecting and sorting data in the Insurance, banking and retail domains using the Oracle Relational Database Management System (RDBMS). Proficient in SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Hands on with Data flow diagrams, Data dictionary, Database normalization theory techniques, logical and physical Data Modeling using normalizing Techniques. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). Strong expertise in database management, including proficiency in traditional SQL databases as well as NoSQL databases, such as MongoDB, enabling me to design and implement scalable and efficient data solutions. Have good knowledge on cloud computing platform such Google Cloud Platform (GCP). Have worked in developing ETL program for supporting Data extraction, transformations and loading using informatica power center along with data visualization using Tableau. Knowledge in full life cycle development of data warehousing. Expertise in Client-Server application development using RDBMS systems like oracle, MS SQL server. Proficient in table Functions, Indexes, table partitioning, analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. Expertise in Dynamic SQL, Collections and Exception handling, experience in SQL performance tuning using Query Optimizer, execution plans and indexes. Worked extensively on Ref Cursor, temporary tables and Collections. Hands on with materialized views for data replication in distributed environments. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. Experience in writing Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Extensively used DBMS_REDEFINITION to alter tables online and redesigned database stored proc to convert from collections to temporary tables to improve system performance. Good knowledge in MongoDB concepts, administration and performed enhancements to MongoDB architecture to improve performance and scalability. Hands on with MongoDB, worked on architectural performance improvements and scalability. Created and managed jobs scheduled in control-M and AutoSys application tools. Experience on Python scripts to load the data into RDBMS database. Good experience in Agile and Water fall development models. Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

• Oracle Certified Associate (OCA)
• Oracle Certified Professional (OCP)
• MongoDB certified Developer