Mathivanan Subramanian Email & Phone Number

Bedford, Nh, Us

Boston, Ma, Us

Teaneck, New Jersey, Us

• Working as a Senior Data Engineer in complex interfaces, key responsibility is to analyze data and interview subject matter experts for building concise, accurate Design/Functional/Technical specifications and then walking them across various internal and external teams• Responsible for creating source to target ETL mapping document.• Participates in requirement review sessions to assure project artifacts contain documentation sufficient to provide metadata specified by organization standards.• Creating data model and developing code in Scala and Spark SQL for ETL process in Databricks• Designed and implemented an ETL framework using Scala to load data from multiple sources into Delta Lake and from Delta Lake to API• Developed Scala scripts using both Data frames/SQL in Spark for Data Aggregation, queries and writing data into the Delta Lake• Reviewing test cases/plans for Quality assurance.• Good experience in Agile Methodologies, Scrum stories, and sprints experience in a Spark/Scala based environment• Involved in sizing and estimation for new or enhancement works• Designing error handling and optimization in Enterprise level.• Mentoring team and conduct various knowledge sharing session within team members

Teaneck, New Jersey, Us

• Working as a key player in Predictive Banking, Financial Health Services, Recurring Payment analysis, FICO score delivery• Working in Oracle 19c Active-Active-Active database servers with Multitenant RAC environment which provides maximum availability, it receives 500 million stored proc calls per day, and holds billions of data • Expertise in database migration from Oracle 11g to 12c and 12c to 19c with highly critical tier -1 applications• Working in database design and development with MongoDB• Working complex table design using data modelling tool Toad Data modeler• Using the replication tool Goldengate to load data from various data servers• Developed the internal application to load data efficiently from different applications• Designed and developed complex Oracle PL/SQL procedures, functions, packages, views, materialized views, triggers, constraints, synonyms and sequences for complex reporting environment with Oracle 12c database• Tune the SQL queri¬¬es as well as PL/SQL programs using hints, indexes, partitions and other performance tuning techniques using AWR report• Load external file with millions records into system tables and generate the outbound file using Ab Initio tool.• Working with Business Analyst team to gather the requirements, and analyze impacts with the dependent team with the new requirement• Reviewing the functional specification document and testing plan document• Documenting the technical specifications• Performing the unit testing and documenting unit test case results• Coordinating with Release management for quarterly enterprise release

Teaneck, New Jersey, Us

• Worked on critical data management application, and involved in developing new modules and/or making enhancements in this portal. Reviewing the business requirement and technical specification• Responsibilities include planning and reviewing and fine tuning the application development activities• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.• Developed database objects including Tables, Cursors, Indexes, Views, Sequences, Packages, Synonyms, Triggers and Procedures to troubleshoot any database problems.• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases. • Developed Master Detail, Detail reports using tabular and Group above reports. • Developed Procedures for collecting the data as per business rules and loaded the data in lookup table with the help of Bulk Collections.• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.• Worked with business users to understand/clarify the requirements• Created Technical Design Document (TDD)• Developing/modifying the modules/programs/scripts to execute the project• Performed unit testing• Worked with QA team to perform Integration testing followed by implementation • Provided technical support for any application related issues • Worked towards continual service improvements by way of optimizing the code • Involved in spearheading value additions/process improvements recommendation to the client• Designing and developing the customizations based on the client requirement

Noida, Uttar Pradesh, In

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.• Involved in creation of Conceptual Modeling covering all the business requirements.• Loaded the data into database tables using SQL*loader from text and excel files. • Developed data model, SQL Coding, SQL Query tuning process and Schemas.• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules. • Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.• Atomized routine jobs using DBMS_JOB. On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL.• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases. • Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.• Developed custom Reports as per client requirements and making them web enabled using Oracle Reports builder 10g.• Developed Master Detail, Detail reports using tabular and Group above reports. • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.• Developed Shell Scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors. • Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.• Developed UNIX Shell scripts to automate table creation, execute procedures.• Created some oracle objects for OLAP.• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Troy, Michigan, Us

• Involved in the Analysis, Design, Coding and Testing of the application.• Created and Modified PL/SQL Triggers, Procedures, Functions and packages.• Developed ER Diagrams, Data flow diagrams based on the requirement.• Developed SQL scripts to Create database objects like Tables, Views and Sequences.• Used SQL*Loader to load bulk data from various flat files and legacy systems.• Developed SQL and PL/ SQL scripts for transfer of data between databases.• Used For all and Bulk collect to fetch large volumes of data from table.• Developed Complex SQL Coding, Triggers for building Reports using Form, form letter and mailing label report styles.• Developed Complex Triggers in reports before/after for validation of user input.• Designed and developed reports by using Oracle Reports 10g.• Performed Unit Testing and supported Integration Testing and End User Testing.• Extensively worked on production issues with effective defect management.• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.• Involved in SQL tuning, PL/SQL Tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN etc.• Implemented Application Infrastructure policies, Procedures and Standards, and ensured their continual compliance

Troy, Michigan, Us

Master Of Science (Ms), Software Systems

Bachelor Of Engineering (B.E.), Electrical And Electronics Engineering