SUMMARY

• Having 12 years 6 months of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) and UNIX developer and production support projects.
• Having 3 + years of experience as SQL Server Developer with extensive experience of analytical techniques using SSMS.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, SQL Server, PL/SQL, SQL *PLUS, TOAD, SQL Developer, PL/SQL Developer, SSMS, Teradata.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in writing SQL queries and optimizing the queries in SQL Server 2012.
• Developed materialized views for data replication in distributed environments.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in Unix cronjob scheduling and developing shell scripts as per requirement.
• Basic knowledge on oracle DBA role like creating /managing schemas, giving permissions, data backups.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Good command in Telecom, Insurance domains.
• Worked extensively in Development of large Projects with complete END to END participation in all areas of Software Development Life Cycle and maintain documentation.
• Working with enterprise clients ETIQA, ALLIANZ, TNB, GE (Malaysia), GE (Singapore).
• Extensive Experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions, and ensuring client deliverables with in committed timelines.
• Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.

TECHNICAL SKILLS

Databases: ORACLE 11g SQL & PL/SQL, SQL Server, DB2 SQL, MS-Access, TeradataUTILITY/Tools SQL*Plus, SQL*Loader, Advance Query Tool, Toad, SQL Developer, PL/SQL Developer, DB2 Load Client, SSMS, Teradata Sql Assistant

Data Modeling Tool: ER/Studio Data Architect, Azure Synapse

Data warehouse: DWH concepts

Operating Systems: Window server 2008, Unix

Knowledge on ORACLE Database Architecture.: Experience in analysis, documentation, development, implementation, maintenance, and support of application systems.

Ticketing Tools: Jira, ADO Board

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, California

Senior Database Developer

Responsibilities:

• Analyze and Understand business requirement.
• Installing, configuration and maintenance different Operating System such as Windows, Linux, VMware and Amazon Linux.
• Prepare System and Technical Artifacts.
• Responsible for changes and modifications of development, implementing new Enhancements, Change Requests (CRs) and Problem requests (PRs).
• Involve in Software Development Life Cycle (SDLC) like Design, Develop, Test, Configure, Deploy and Maintenance of Web related applications
• Preparing technical flow documents and giving demos to other stakeholders on enhancements on day-to-day operation.
• Work in Agile process and promote Quality Assurance and Quality Control processes.
• Work on system and data level performance tuning and load balance using Oracle database.
• Involve in code migrating to different environments like Dev, UAT and Production.
• Involve in Implementation and Integration of production Operations and Maintenance.

Confidential, Harrison, New York

Data Modeller

Responsibilities:

• Work with the data analyst team to gather requirements for the database design and model.
• Understand the data needs of the company or client.
• Collaborate with the development team to design and build the database model.
• Engage the development team to implement the database.
• Determine the business needs for data reporting requirements.
• Adjust access to the data and the reports as needed.
• Work closely with the development team to implement data warehouse and reporting.
• Understand the company’s data migration needs.
• Work with the development team to implement the migration.
• Work with data scientists / data engineers to determine metadata querying requirements.
• Help to implement the querying.
• Help determine and manage data cleaning requirements.

Confidential

SQL & PL/SQL Database Developer

Responsibilities:

• Developing the Complete Back-end application according to the client requirement.
• Developed different kinds of claims registration, discharge through bulk file uploads.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Involved in Unit Testing Stored Procedures and Functions.
• Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Used the technical document to design the database tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Created Materialized Views and partitioning tables for performance reasons.
• Responsible for Analyzing and Implementing the Change Requests.
• Involved in handling the changes in compiling scripts according to the database changes.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Good understanding of database objects and ability to triage issues.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Developed reports using complex queries as per client request as a part of production support.
• Provided on call support, solved the user issues and made necessary changes.
• Resolving Production severity Issues in time and meeting the SLA.
• All Scripts are automated using unix scripting to run the jobs as per schedule.
• Assisting client in completing the UAT and provide the required documents on the changes made and explain the new functionality after the change.
• Making sure that client approved changes were moved from UAT to production and getting post implementation sign off from the client.
• Documenting the solution provided for the production issues and making sure that clients are aware of the impact of the fix provided.
• Follow up for the delivery & roll out of the solution to live at the earliest.
• Analyzing the product behavior with application performance.
• Estimating, design and implementation of various modules as per client requirements.

Confidential

MIS Executive / Sql Server Database Developer

Responsibilities:

• Performed server installation and configuration using SQL server 2012.
• Designing, implementing and maintaining the database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements.
• Maintaining the database schema in source code control (MS team suite database edition preferred).
• Developing the SQL programs and involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
• Using the quality center (defect tracking tool) for bug fixing and resolution details.
• Involving in mock testing and unit testing and integration testing in SSIS, SSAS.
• Creating the automated stored procedures for day end operations using SQL server agent and CTE.
• Coordinating with the front-end for implementing logic in stored procedures and functions.
• Creating stored procedures to validate the data coming with different data discrepancies using data conversions.

Confidential

BI Operations

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Integrated the SMS system to alert various group on the status of data pulls and data processing.
• Creating, Scheduling and monitoring jobs in Oracle job schedules.
• Resolved the unix requests or issues related to schedulers.
• Created shell scripts and updated the scripts as per the requirement.
• Developed scripts for inbound and outbound of the data on servers.
• Efficiently managed disk by deleting old log files.
• Created cronjobs for automatic scheduling the jobs to run as per schedule.
• Co-ordination with the users, other application developers in testing all the applications.
• Direct client interactions and coordinating between offshore and onsite.
• Directly interacting with the business users, gathering their reporting requirements and providing appropriate data/solution out of BI system.
• Working as a IT-SPOC for the marketing, finance and CSD teams for South HUB.
• Provided on BI tools & system to business users. Making BI more effective.

Confidential

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logics.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Analysis of the specifications provided by the clients, Writing Queries as per business requirements Tune the query and help the users in rectifying the errors in the query.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Loading data into tables by using unix cronjob scheduler to process the files automatically.
• Rewritten all scripts from windows environment to unix as per data migration.
• Loading business data into data warehouse.
• Designing Report Specification Document.
• Report development using Oracle SQL.
• Interaction between team members, Client IT Department & Business User.
• Conducted various knowledge transfer sessions to the new joiners.
• Responsible for Code fixing and testing.
• Reviewing all the deliverables and Ensuring timely and defect free delivery.
• Defect fixing if any issue persists in coding after the code deployment to production.
• Testing and recording test results with strict adherence to Quality Procedures.
• Participated in conference calls with onsite coordinators.
• Analysis of the specifications provided by the clients.
• Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.

Confidential

Responsibilities:

• As a team member, was responsible for Developing SQL & PL/SQL scripts.
• Designing Report Specification Document.
• Report development using Oracle SQL.
• Interaction between team members, Client IT Department & Business User.
• Conducted various knowledge transfer sessions to the new joiners.
• Responsible for Code fixing and testing.
• Reviewing all the deliverables and Ensuring timely and defect free delivery.
• Defect fixing if any issue persists in coding after the code deployment to production.
• Testing and recording test results with strict adherence to Quality Procedures.
• Participated in conference calls with onsite coordinators.
• Analysis of the specifications provided by the clients.