| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate..Candidate's Name
Seasoned Business Intelligence Architect specializing in comprehensive end-to-end BI solutions, ETL processes, and data warehousing.PHONE NUMBER AVAILABLE EMAIL AVAILABLESummaryHighly skilled Business Intelligence Architect with over 15.5 years of experience specializing in delivering robust end- to-end BI solutions across diverse domains. Expertise in ETL development, BI reporting, data modeling, dashboard design, and performance optimization. Demonstrated ability to lead cross-functional teams in executing complex projects within scope, budget, and timeline. Renowned for mentoring and onboarding teams on advanced products and technologies.Skills ETL and BI reporting Dimension modelling & Data warehousing Software Development Life Cycle (SDLC) PL/SQL Agile project management Training and mentoringTechnical SkillsETL Tools Informatica PowerCenter, IICS, DataStage, Ab-Initio Databases SQL Server 2016/2018/2022, Oracle 12c/11g/10g, Teradata, iBM DB2 Visualization Tool MicroStrategy AI (2019,2020,2021) Scheduling Tools Autosys, Control-M, CrontabData Modeling Tool ErwinProject Management Tools JIRA, GIT, Salesforce, Workday, ServiceNow Utilities Putty, Python, Toad, REST APISPlatforms Windows, UNIX, AZURE, AWSEducation and TrainingTechnocrats Institute of Technology - Bhopal, India Bachelor of Engineering (B.E.) Information Technology (HONS.)Certifications Microsoft Certified: Azure Fundamentalshttps://learn.microsoft.com/api/credentials/share/en-us/Candidate's Name -1530/7C8F8625038385C0?sharingId=9C8FC0B2E75D67C8 MicroStrategy Application Architecthttps://www.credential.net/8259a914-7327-4291-8379-ced7bd306852 MicroStrategy Analysthttps://www.credential.net/bbe24f88-b5e8-46dd-b231-34d2d79a8af2 Oracle Introduction to SQL (1Z0-007)..ExperienceETL/ BI ARCHITECT 05/2019 - CurrentMICROSTRATEGY Tysons Corner, VA Spearheaded the design and implementation of an Enterprise Data Warehouse (EDW) for the MicroStrategy BI platform, producing critical reports for C-suite executives. Engineered and deployed comprehensive BI solutions including data modeling, ETL, schema design, and dashboard creation to meet diverse business needs. Design and implement complex data mappings using Informatica PowerCenter and IICS, ensuring high performance and precision in data transformation and loading from various ERP, CRM, and database systems. Designed and optimized over 80 ETL workflows, reducing data processing time by 30% and improving overall system efficiency by 20%. Led data migration and integration projects for 20+ systems, ensuring seamless data transfer and increasing data accuracy by 40%. Developed and implemented advanced MicroStrategy solutions, leveraging Dossier Authoring, Web, Developer, Workstation, and Library to create robust and scalable BI platforms tailored to business requirements. Integrated over 10+ diverse data sources, designing and maintaining schema architectures that improved data accuracy by 20% and reduced query times by 25%. Proficient in designing complex data models, including star and snowflake schemas, and implementing robust data warehouse architectures. Led performance tuning initiatives for MicroStrategy reports and dashboards, achieving significant improvements in processing speed and user experience, thereby enhancing the quality and timeliness of business insights. As a Customer Zero team for MicroStrategy, pioneered the use of advanced MicroStrategy features, driving AI/BI innovation and improving data-driven decision-making. Developed and maintained detailed technical documentation, including data models, ETL workflows, and BI report specifications.ETL CONSULTANT 10/2017 - 04/2019SAVVYTECH SOLUTIONS INC (MicroStrategy/ Priceline) Led large-scale data integration projects, consolidating data from diverse sources into enterprise data warehouses, achieving seamless integration. Designed and developed complex ETL processes using Informatica to extract, transform, and load data from various sources into data warehouses and data marts. Managed end-to-end ETL projects, from requirements gathering and design to implementation, testing, and deployment, ensuring timely and within-budget delivery. Optimized ETL processes, reducing data load times by 25% and enhancing overall system performance. Facilitated cross-functional team meetings to streamline ETL project phases, improving project delivery timelines by 15%. Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse. TECHNOLOGY ANALYST 12/2008 - 09/2017INFOSYS LIMITED (Bank of America/UNDP/Citizens Bank/Capital One Bank/Atradius)- US/India Designed and implemented a data warehouse integrating diverse sources using ETL tools, enhancing data accessibility. Involved in system study, analysis of the requirements and designing of the complete system. Meeting with business users and defining Functional and Technical business requirements. Performed Informatica code migration from development to testing and testing to production systems. Streamlined data integration processes, enhancing data accuracy by 20% through advanced ETL tools. Led a team of onshore and offshore ETL developers, delivering projects on time with a 95% success rate. |
