Having 11+ years experience in database development, data Integration, data warehouse, data analytics and business intelligence.
Skill Set -
SQL Server 2005/08/14, Oracle 11g, 9i, Teradata 13.0 , Alteryx, SSIS ,ODI 11g, VB 6.0, XL Macro, Tableau, Business Object.
Have done some prior engagement like -
Project 1:
• Collect data, business requirements from client then design and architect the solution.
• Designing and implementing the data warehouse.
• Understand the client data and convert the data into the data warehouse.
• Database development – Stored Procedures, UDF, Triggers.
• Tuned existing procedures.
• Used SQL Server 2008/2014, SSIS & Business Objects
Project 2:
• Developed SSIS package.
• Create procedures and call SSIS packages inside from SP.
• Schedule the procedure to run once in a day.
• Written macros to pull the data from database and for GUI also.
• Prepare LOE for the project.
Project 3:
• Extensively worked in data Extraction, Transformation and loading from source to target system using bteq queries.
• Create DFD using Omnigraffle tool.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Worked with various databases layer of Teradata Warehouse in our project like semantic, core layer
• Involved in unit testing and preparing test cases.