Description
Professional Summary: * Currently Working as Data Architect/Modeler/ETL consultant/Data Analyst in Wipro Technologies. * Overall 10+ Years of varied experience in IT in Database working knowledge of Retail and Health care. * 4 years of experience as Data architect and Data Modeler (Erwin and Power Designer) in oracle 10 and 11g. * 6+ years of experience of as technical lead for Development teams including the roles of oracle database developer, ETL scripting and implementation. * Well versed in Estimates, Proposals, and Preparation of development, PROD deployment strategies. * 6+ experience as Pl/Sql developer for oracle database and as a technical lead. * 6 Months of experience on Teradata and Micro Strategy with good analytical skills to build business rules. * Expertise has been concentrated in all the phases like requirements gathering, Architect, Design, Development, testing, deployment and support and familiar with Software Development Life Cycle (SDLC) like Waterfall, Agile and Scrum methodologies. * Worked on Oracle 10g, 11g, Teradata, Tableau, UNIX, VB6, Trackwise 7, crystal reports, ASP.NET and ETL services. * Good working knowledge on Protegrity encrypted/Tokenized data for handling PII, PCI and sensitive info. * Expertise on Data marts, Data warehouse concepts, executed ETL projects successfully as a team lead. * Sound knowledge on Oracle tuning and performance concepts, Database Administration concepts. * Good awareness of Informatica, ETL, SSIS, SSAS, SSRS, Data warehouse concepts, ETL tools/concepts. * Ability to adapt successfully and quickly to change and deliver quality results in a timely manner and to meet stringent deadlines. * Strong experience on database design for transactional systems as well as OLAP systems. Good knowledge on logical and physical Data Modeling using normalizing Techniques. * Very good data analysis, data profiling and data normalization skills. * Identified and evaluated the current data management technologies and Developed data models for database structure. * Nice experience on design of Data Integration, ETL techniques and tools Dimensional Modelling, DataMart, cube design etc. * Developed database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. * Experience in SQL performance tuning using Cost-Based Optimization (CBO). * Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes. * 4+ years of experience in installation, development, and maintenance phases of EQMS tool - Trackwise. * Good Understanding on middle ware tools like Weglogic, Jboss w.r.t to database interaction and session mgmt. Technical Details
Accomplishments
Highlights:
Keywords
