ROFESSIONAL SUMMARY ✓ Having 3.
6 years of experience of IT industry in the
P
areas of ORACLE SQL, PL/SQL . ✓ Experience Working in 24/7 Level 1 and Level 2
Support. ✓ Expertise knowledge experience in Oracle SQL, PL/SQL with solid
understanding of key such as Triggers, Cursors. ✓ Experience in creating Stored
Procedures, Functions, Packages, Views and Indexes. ✓ Handing experience in
working with Composite data types, Global Temporary tables. ✓ Experience in using
Ref Cursor, Bulk Collect, Pragma Autonomous Transaction PL/SQL Collections and
tables. ✓ Creating scripts to create new Tables, Views and Queries for new
enhancement in the application. ✓ Excellent SQL Skills, experience writing complex
queries and working with database objects like sequences. ✓ Experienced in data
migration in many large firms. ✓ Interacted with onsite coordinator/ clients for
requirement gathering and effective analysis WORK EXPERIENCE ✓ Worked as a
Software Programmer in Roadmap IT Solutions (P) Ltd- Pondicherry, India From 30
Nov 2020 to 01 Dec 2024. ✓ Worked as a Oracle Developer (Associate IT Consultant)
in ITC Infotech,Bangalore, India From 10 Jan 2024 to till date. ACADEMIC
CREDENTAILS ✓ U.G B.E – Mechanical Engineering Mohamed Sathak A J college of
engineering Chennai, Anna university (2014-2018) with 6.67 CGPA. ✓ HSC AKT
Academy Matric. Higher secondary school Kallakurichi (2014) with 75%. TECHNICAL
SKILLS: Language : Oracle SQL, PL/SQL. Operating System : Windows 7, Windows 8,
Windows 10 GUI Tools : Oracle Developer suite 10g, 11g, 12c (Forms and Reports),
Jasper Report. Operating System : SQL *Plus, Toad for oracle, SQL Developer.
Database : Oracle 10g, 11g & 12c. PROJECT DETAILS Project #1 : Apr’21 – Nov’21.
Client Name : DMW CNC Solutions India Pvt. Limited , Perundurai. Domain : ERP for
High Precision machined components Manufacturing. Technology : Oracle 12c Forms
and Reports, Oracle 12c Database Responsibilities: ✓ Involved in full development
cycle of Analysis, Design, and Development. ✓ Developed the front end User
Interface (UI) using Oracle Forms and the necessary PLSQL functions, stored
procedures, triggers and packages. ✓ Created Scripts to create new tables, views,
queries for new enhancement in the application using TOAD. ✓ Handled errors using
Exception Handling extensively for the ease of debugging and displaying the error
messages in the application. Project #2 : Jan22’- Aug’22. Client Name : Ultramarine &
Pigments Ltd, Ranipet Domain : ERP for Pigment and Surfactant Manufacturing.
Technology : Oracle 12c Forms and Reports, Oracle 12c Database Responsibilities: ✓
Involved in Analysis, Design, and Development. ✓ Developed the front end User
I nterface (UI) using Oracle Forms and the necessary PLSQL functions, stored
procedures, triggers and packages. ✓ Created Scripts to create new tables, views,
queries for new enhancement in the application using TOAD. ✓ Creating Reports as
per the client requirement. Project #3: : Aug’22 – Feb’22 Client Name : MASO
AUTOMOTIVES PVT. LTD, Mumbai. Domain : ERP for parts and accessories for motor
vehicles Manufacturing. Module : Supply Chain Management & Planning. Technology
: Oracle 12c Forms and Reports, Oracle 12c Database Responsibilities: ✓ Analysis the
Client Requirement and develop the Screens for the client ✓ Creating Reports as per
the client requirement. ✓ Developed the front end User Interface (UI) using Oracle
Forms and the necessary PLSQL functions, stored procedures, triggers and packages
✓
Reports as per the client requirement. Project #4 : Mar’23- July’23. Client Name :
Alufit international Pvt. Limited. Domain : ERP for Facade Fabricate Manufacturing.
Technology : Oracle 12c Forms and Reports, Oracle 12c Database Responsibilities: ✓
Involved in Analysis, Design, and Development. ✓ Developed the front end User
Interface (UI) using Oracle Forms and the necessary PLSQL functions, stored
procedures, triggers and packages. ✓ Created Scripts to create new tables, views,
queries for new enhancement in the application using TOAD. ✓ Creating Reports as
per the client requirement. Project #4 : Jan’24- April’24. Client Name : British
American Tobacco Kenya Domain : ERP for Bat Kenya cigarettes Manufacturing.
Technology : Oracle 12c Forms and Reports, Oracle 12c Database Responsibilities: ✓
Involved in Analysis, Design, and Development. ✓ Developed the front end User
Interface (UI) using Oracle Forms and the necessary PLSQL functions, stored
procedures, triggers and packages. ✓ Created Scripts to create new tables, views,
queries for new enhancement in the application using TOAD. Creating Reports as per
the client requirement PERSONAL INFORMATION ✓ Father Name : Arjunan.E ✓
Nationality : Indian. ✓ Date of Birth : 23-10-1996. ✓ Gender : Male. ✓ Contact Details
: 10/5 Mariyamman Kovil Street, Ayinamplayam,T.mettupalayam(post),
Vikravandi(taluk), Villupuram – 605 602 ✓ Languages Known : English,Tamil
DECLARATION I hereby declare that all the information mentioned above is true to
the best of my knowledge.
✔ Passionate Data Analyst with over 4 Years experience in handling data and developing
ashboards using Power BI. Managed numerous data projects, championed automation of
d
data processes, and executed efficient data management. Data strategy innovator with a
knack for identifying data inconsistencies and leading efficient, collaborative teams.
✔ Experience in developing SSAS (Tabular Mode) and Power BI Reports using different DAX
queries, Visual, Filters and Configuring
✔ Dashboards with drill down capabilities
✔ Worked on different level of filters like page level filters, visual level filters, Report level filters
to reduce the data size into visual of report.
✔ Good Knowledge on Power BI Data Modelling and Data warehouse concept like star scheme,
s now flake schema. Dimension and fact Tables
✔ Good Experience of performance Tuning with the help of DAX Studio.
TECHNICAL SUMMARY
✔ Tools : Power BI Desktop, DAX Studio
✔ Language Known: SQL, DAX, Power Query
✔ Database : SQL Server
✔ Productivity Tool : MS office suite
E DUCATION
Master of science in Computer Science [2004-2006]
, country wise for particular Vendor.
o
o To Drill through the Month to find particular PO Details.
Customer Analysis:
Month wise Outstanding trends which drill throughinvoice Details.
o
o Calendar Control display daily Transaction to analysed Customer Capabilities.
o To Analysed Total Sales, Return, Actual Invoice Amount
