Description
Experience Summary * About 15 years of adept experience in Data Warehouse Systems and Application Development, experienced in implementing complete end-to-end Software Development Life Cycle (SDLC) process. * Good experience in executing and implementing end-to-end data warehouse project implementations and worked in each and every phase of DW/BI Lifecycle. * Expertise in Data Modeling, created various Logical/Physical Data Models for many Data Marts and Data Warehouse implementations. * Define end-to-end Solution Architecture along with the integration of other products, performing hardware sizing, performance benchmarking and define data architecture. * Performed System Analysis & captured Requirements related to Architecture, ETL, Data Quality, MDM, Dashboards and Reports. Captured enhancements from various entities and provided Impact analysis. * Good experience in Data Profiling, Data Mapping, Data Cleansing, Data Integration, Data Analysis, Data Quality, Data Architecture, Data governance, Metadata Management & Master Data Management * Designed key system architectures with complete system integration involving various modules. * Created first of a kind unique Data Model for Intelligence Domain. * Self-initiative, Excellent Analytical, Communication skills, can work independently & good team player. * Good experience in debugging SQL Code developed PL/SQL scripts, stored procedures and triggers to extract and load the data. Experience in UNIX shell scripting to Automate and schedule the jobs. * Developed Multiple ETL processes for data loading data facts, Dimensions & other tables. * Designed & implemented pilot projects using various set of BI tools involving the latest features & product trends, experience in technologies such as Big-data, cloud computing & In-memory Apps. * Good experience in other BI Tools, ETL tools and worked with many high-performance databases. * Expertise in Business Objects (BO) & worked extensively on Xcelsius Dashboard & Performance tuning. * System Optimization, performance monitoring and tuning experience in Business Intelligence systems. * Developed various Semantic layers such as Universes, RPD, Framework's and fine-tuned queries generated. Developed complex reports and Dashboards with best Data Visualization capabilities. * Involved in continuous Performance Tuning & improvements for existing OLAP systems. Adept in developing reports, dashboards and implementing Business Intelligence solutions. * Successfully installed and upgraded lower versions to higher versions & migrated application data. * Supported and maintained many application systems thereby ensuring all deliveries are met on time. * Coordinated test plans, test cases which provided feature/functionality/usage scenarios. Created Strategy & Roadmap with execution plan, there by monitoring the progress of the projects. * Proposal preparation in response to RFP, providing Effort estimation and project planning * Provided training for the technical and business users in terms of operations & usability. * Implement various data warehouse projects in Waterfall & Agile methodologies. * Worked as Solution Architect, Business System Analyst, Data Analyst, Technical Lead and Sr. Business Intelligence & ETL Developer.