● Over 14 years of programming experience as a Technical Lead, Developer and Analyst and Architecture Role.
● Experience in Database Design and support Services, AWS cloud practitioner.
● Experience in Data ware housing, oracle PL/SQL, Teradata, Technical Writing and Data modeling.
● Organizing and managing the technical Team of data architects, data modelers, engineers and providing leadership, guidance, and mentoring
● Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation maintenance and Documentation with timely delivery against aggressive deadlines.
● Scripting SQL query with Validation Rule to analyze the data and Data quality.
● Experience with Data flow diagrams, Data dictionary, Database normalization techniques, Entity relation modeling and design techniques.
● Conducted Team Meetings and proposed ETL strategy.
● Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
● Strong experience in Data warehouse concepts, ETL, OLTP and OLAP application.
● Working with the DBA to transform the logical information model into a first-cut logical database design (physical information model for the target DBMS)
● Developed database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
● Having knowledge on Shell Scripts for invoking SQL scripts and scheduled them using crontab.
● Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Subjects
-
RDBMS Beginner-Expert
-
Data Warehousing Beginner-Expert
-
Oracle PLSQL Beginner-Expert
-
SQL query writing Beginner-Expert
Experience
No experience mentioned.
Education
-
MSc IT (May, 2010–Aug, 2012) from SMUDE
-
BCA (Jun, 2005–Jun, 2008) from JIS COLLEGE OF ENGINEERING, KALYANI
Fee details
₹800–1,500/hour
(US$9.51–17.84/hour)