Scrum Master Database Developer

Irving, TX ***** 945-***-**** ***************@*****.***

.

RAKESH IMMANUEL TAMIL SELVAN

Database Developer

PROFESSIONAL SUMMARY

Accomplished 15 Plus years of experience in designing and managing Oracle databases, SQL/PLSQL, Performance Tuning, DB designing. I am working as a Database Developer with a proven track record at Epsilon, adept in Data warehousing, ETL, Unix, Oracle PL/SQL and Agile methodologies.

TECHNICAL SKILLS

SQL, Oracle PL/SQL, Unix Shell Scripting, Python, ETL, Data Structures, Data Visualization, Data Mining & Analytics

Database Architecture Analysis, Software & Data Warehousing

Oracle databases 9i, 10g, 11g, 12c, 18c, 19c - Designing and Modeling

TOOLS

Oracle Warehouse Builder, TOAD, SQL Developer, SQL*Plus, PL/SQL Developer, SQL Navigator, UT PL/SQL, SQL Server, SAP BODS, Putty, Microsoft VSS, JIRA, Rally, GIT, Bitbucket, Power BI, TABLEAU, File Zilla, Win Merge, MS Office.

WORK HISTORY

DATABASE DEVELOPER 01/2025 to Current

Epsilon, Irving, TX

Managed multiple data platforms that include the ingestion, orchestration, and enrichment of data for several commercialized data analytics products.

Leveraged custom and packaged business intelligence solutions like Tableau and PowerBI for data visualization.

Strong PL/SQL and SQL programming skills in database development life cycle.

Worked extensively with Dimensional modeling, Data migration, Data cleansing and ETL Processes for data warehouses.

Experience in creating Repository, Source systems, Target Databases and developing strategies for ETL mechanisms.

Experience with command-line scripting in UNIX and LINUX environments.

Extensively worked in developing ETL programs for supporting Data Extraction, transformations and loading into ETL tools

SENIOR IT ARCHITECT 05/2015 to 11/2024

Honeywell, Bangalore, India

Experience includes overall process of System Study, Business Requirement gathering, Analysis, Design, Development, Implementation and Support of Business-critical applications.

Good experience in designing and managing Oracle databases, SQL/PLSQL, Performance Tuning, DB designing, Debugging and deployment.

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

Worked extensively with Dimensional modeling, Data migration, Data cleansing and ETL Processes for data warehouses.

Worked in developing ETL programs for supporting Data Extraction, transformations and loading into ETL tools.

Performed Bulk Insert, Import and Export data from different Data Sources.

Experienced in planning and implementing Database Security by creating users, Roles, and assigning permissions to them.

Good Experience in Materialized Views, collections, and JSON format data output.

Created several re-usable packages, functions and stored procedures. Extensive experience in converting business requirements into solutions by creating Oracle objects like Tables, Synonyms, Triggers, Indexes, Views and Materialized Views.

Expertise in Bulk SQL features such as Bulk Collect and FORALL statement. Extensive working knowledge of Cursors, Ref Cursors, %TYPE and %ROWTYPE attributes.

Strong knowledge in creating Global temporary tables, records and collection types – Associative array, Varray and Nested tables. Developed flexible Adhoc programs using EXECUTE IMMEDIATE statement.

Experience in trapping, raising and handling errors using User-defined and System defined Exceptions. Query optimization and performance tuning using indexes, optimizer hints, DBMS_STATS, EXPLAIN PLAN, AUTOTRACE, dynamic performance views and partitioning.

Hands on experience using Analytic Functions for SQL development.

Worked closely and listened to team members' feedback to identify issues and resolve conflicts.

Identified issues, analyzed information and provided solutions to problems.

In depth knowledge of STLC, SDLC, and AGILE methodologies and it's various aspects like functionality, and integration

Implemented Continuous Integration for database, Standardization of Process such as Design to deployment standards, PL SQL standards, Migration Check List, Standard Scripts, Naming Conventions, and Capacity Planning.

Proved successful working within tight deadlines and fast-paced atmosphere.

Improved operations through consistent hard work and dedication.

Assessed each scrum team member's responsibilities and delegated tasks to balance each employee's workload.

Led sprint reviews and planning meetings to promote full team engagement.

Oversaw entire product deployments from vision and creation to rollout and delivery.

Improved performance of various report generation modules of reliability COE involving TBs of data by techniques such as Materialized Views, partitioning of tables, AWR analysis, Debugging/ Tuning using TkProf/ Explain Plan and Design tuning

Owned and prioritized product backlog.

Interacted with internal stakeholders as voice of customer.

Facilitated Scrum framework – Sprint Planning, Daily Standup's, Sprint retrospectives, Sprint Demos, Story Grooming and Release Planning.

Drove Scrum team progress to overcome obstacles and realize success throughout life of each sprint.

Broke project into epics and implementable user stories.

Handled many calls per day to address customer inquiries and concerns.

Managed product backlog and supported Scrum framework for monthly sprint releases

Attended team meetings to resolve technical and project issues and review project schedules

SENIOR APPLICATION ENGINEER 08/2014 to 04/2015

Manpower Services India Pvt. Ltd (Honeywell On Contract), Bangalore, India

Drove continual improvement in systems operations by building tools and automation.

Reviewed existing programs to refine, reduce operating time and improve techniques.

Developed standardized work processes, tools and methodologies to improve quality and profitability.

Met with internal and external customers to develop relationships and foster co-innovation opportunities.

SENIOR DEVELOPER 11/2009 to 07/2014

New age Software Solutions Pvt. Ltd., Chennai, Indian

Coordinated efficient large-scale software deployments.

Evaluated and improved development work of other developers on team, working to provide training, constructive criticism and knowledge transfer.

Reviewed and incorporated the latest technology innovations and development strategies to improve build speed, quality and end-user experience.

Documented software development methodologies in technical manuals to be used by IT personnel in future projects.

EDUCATION

Karunya Institute of Technology, Coimbatore, India

Bachelor of Engineering, Information Technology, 08/2003 to 12/2008

St. Peter's Higher Secondary School, Tirunelveli, India

Higher Secondary School, 06/2001 to 03/2003

St. Xavier's Higher Secondary School, Tirunelveli, India

Secondary School, 06/1996 to 03/2001

#HRJ#f933e3f6-e326-43b5-917a-d06ef3be3e63#

Contact this candidate