Professional Summary
Over 9 years of IT experience with expertise in analysis, design, development and implementation of Data warehousing applications using ETL and BI tools with Oracle and Teradata databases on windows/Unix platforms. IT professional with experience in all phases of software development life cycle, with forte at successful project implementations - analyzing systems, understanding & defining requirements, development, technical designs & reviews and project planning. Sound knowledge of Data of Data Warehouse concepts with primary competency in Oracle, Teradata, SQL, Informatica Power Center, Unix Shell Scripting, Qlik Sense, Business objects, Microsoft SSRS and CA Workload Automation. Strong Informatica technical knowledge in the areas of Informatica Designer Components - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor. Expert in Teradata and Oracle SQL Concepts with 9 years of strong working experience in writing large/complex SQL queries. Expertise in creating tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database. And worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files. - Experience in Dimensional Data Modeling, Slowly Changing Dimensions Type I, II & III, ODS, Star/ Snowflake Schema modeling, Fact & Dimension tables, OLAP & OLTP Systems. - Technically proficient in debugging and Performance tuning of existing mappings and SQL queries by analyzing the data flow and evaluating the architecture. Extensive experience with Scrum and Waterfall software development methodologies - Involved in Data Analysis, Development and Implementation of Data warehouse, Technical trouble shooting, Business Intelligence, Data Governance, Application Development and Database Performance Tuning & Optimization. Working Experience in UNIX Shell Scripting and knowledgeable on Python language Clear documentation skills with working knowledge on creating Project deliverable documents like Functional Requirement Specifications, Detailed Design document, System Integration and Unit Test cases and Results. lest cases Proactive and result-oriented Team Leader adept in mentoring and motivating dynamic teams. - Problem solver with a passion for technology; skilled in grasping the big picture, conceptualizing & implementing solutions & partnering closely with business leaders & stakeholders for enabling effective solutions leading to high customer satisfaction and low operational costs An effective communicator with excellent relationship & interpersonal skills