Developer Power

Professional Summary:

oHaving * years of experience in IT using Oracle development tools, DWH/BI, Power BI reporting tool.

oStrong skills in ORACLE-SQL, PLSQL, D2K Development (Oracle Forms & Reports 11G,12C).

oExperience in ERP Implementation using Oracle Application Development Tools.

oStrong knowledge on Visualization tool Such as Power BI.

oExposure to writing complex Queries in Oracle SQL / PLSQL.

oWorking knowledge of Cursors, Stored Procedure, Functions, Triggers, Joins, and Views.

oExperienced in data migration in many large firms.

oPreparing Test Plan, User Acceptance testing and Cut Over plans for Production deployments.

oInteracted with clients eminently to clear up the doubts and bugs in the product. Involved in Implementations, Version Upgrades, Enhancements, Data conversions with post Go-Live, production support and capabilities.

Technical Skills:

oProgramming Language

o Oracle SQL, PLSQL

oDatabase

o Oracle 11g,12c.

oOperating system

o Windows 7, Windows 10.

oGUI Tools

o Oracle Developer Suite 10g, 11g & 12c (Forms and Reports).

oData Migration

o Toad,SQL Developer,SQL Loader

Work Experience :

As an Software programmer at Roadmap IT Solutions Pvt Ltd,Pune from

May 2018-Till Now.

Roadmap ERP is a fully integrated business solution that gives organization in a complete control over the planning and management of all faces of their operations including modules Purchase Order Management, Sales&Distribution, Planning Manufacturing, Human Resource Management, Inventory Control Management, Finance Management, Costing.

Education Qualification :

Specialization

College

Year of Passing

Percentage (CGPA)

Bachelor of Engineering

(Information Technology)

12thStandard PCM

Technocrates Institute of Technology Bhopal

M.G.M.Higher Sec.School

2017

2012

6.32

60%

Projects:

Project #1:

Client Name : TechnipFMC

Duration : May 2018 to April 2019

Domain : ERP for heavy oil and gas Pressure vessel and burner Manufacturing Industries.

Role : Oracle/Power BI Developer

Development Tool : Oracle 11g,12c Forms and Reports(D2K)

Database : Oracle 11g &12c.

Team Size : 4

Responsibilities:

oInvolved in Development cycle of Planning, Analysis and Development.

oStudy over client’s requirements and functional flow analysis.

oData Migration which includes migration of client data into the product.

oPrepared and updated design specifications.

oCreation of database objects like tables, views, materialized views, procedures using tools Toad, SQL Developer and SQL* plus.

oDeveloped PL/SQL procedures, triggers, functions, Indexes and Collections to implement business logic and user interfaces using Oracle D2K Applications.

oUsed Power BI, Power Pivot to develop data analysis prototype, and used Power View to visualize reports

oPublished Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

oExplore data in a Variety of ways and across multiple visualizations using Power BI

oPublished reports and dashboards using Power BI.

oProvided end user training to business.

Project #2:

Client Name : ABS Electroplatters.

Duration : May 2019 to till now

Domain : ERP for Molding and cooler Manufacturing Industry.

Role : Oracle/Power BI Developer

Development Tools : Oracle 11g,12c Forms and Reports (D2K), Power BI

Database : Oracle 11g &12c.

Team Size : 7

Responsibilities:

•Developed necessary PLSQL functions, procedures, triggers.

•Created Scripts to Create tables, views, queries and Designed Reports for new enhancement in the application using SQL DEVELOPER, TOAD, SQL* Plus, Oracle Forms &Report Services (D2K)

•Published reports and dashboards using Power BI.

•Weekly and Monthly status call with the project status report with the client.

•Performed Unit Testing, Integration Testing and Performance Testing.

•Tuned SQL queries and performed code debugging using TOAD.

•Provided end user training to business users.

Personal Information:

Father Name : Shiv Kumar Tamrakar

Nationality : Indian

Date of Birth : 01-01-1995

Gender : Male

Marital Status : Single

I do hereby declare that the particulars of information and facts stated above are true, correct and complete to the best of my knowledge.

Date:

Place: Tanmay Tamrakar

DECLARATION:

Contact this candidate