Around 16 years of experience as a Software Engineer, Analyst, Module Leader, Project Leader, Data Modeler/Data Architect/Director/AVP, Managing Projects.
Over 12 Years of experience as Data Modeler for Relational and Dimensional Databases of various size and scope.
Lead and Managed the Data Warehouse Projects of Team size of 30.
Managed Overseas Project with end-to-end responsibilities that included Project Life Cycle requirement analysis, designing, planning, implementation, management and communication to all team members, executive management and key client personnel.
Proven ability to effectively define business requirements and manage multiple projects.
Involved in Stock holders Management provided Monthly status and ensured the Smooth Delivery.
Well experienced in Data Modeling both ER Model and Dimensional using Data Modeling tools Erwin, and Power Designer, Microsoft Visio.
Very good experience in Complex SQL Query writing and procedures and Functions etc.
Supporting development team with in Oracle - SQL query optimization using SQL Trace, Explain Plan, SQL Query Analyzer and Optimizer Hints.
Extensive experience in Oracle database, SQL, PL/SQL, TSQL, Packages Stored procedure, Functions, Triggers etc.
Involved Oracle – Performance tuning techniques.