Business Intelligence Data Warehouse

MINESH PATIL

214-***-**** ***********@*****.***

PROFESSIONAL SUMMARY

Seasoned as Data Warehouse / Business Intelligence Architect with more than 15 years of experience shaping data ecosystems for enterprise-level organizations. Recognized for architecting and implementing enterprise-wide frameworks that support strategic planning and business transformation. Known for delivering scalable, insight-driven initiatives that have consistently improved operational outcomes. Experienced in translating business vision into actionable data solutions across diverse industries. Adept at managing the full lifecycle of BI initiatives, from conceptualization through implementation and continuous improvement. Trusted partner to executive leadership, aligning analytics initiatives with organizational priorities. Focused on driving enterprise value through thoughtful integration of business needs and intelligence capabilities. Dedicated to building future-ready BI environments that support sustained growth and innovation. AREAS OF EXPERTISE

BI Architecture Design Enterprise Data Modeling Data Governance Business Intelligence Strategy Data Warehousing

Stakeholder Management ETL Process Design Team Collaboration Project Planning & Execution Budgeting & Cost Control Strategic Thinking Team Leadership Agile & Waterfall Methodologies Risk Assessment & Mitigation Data Integration Performance Tracking Process Optimization Decision-Making Change Management Communication CAREER HISTORY

Business Intelligence Leader JC Penney Sep 2017 - Present Oversees strategic and operational analytics initiatives across functions such as promotional pricing, retail performance, HR, and finance, while managing EDP projects with multi-million-dollar budgets with global teams and third-party vendors.

• Leads the design and deployment of secure, scalable BI environments, including enterprise-wide data governance frameworks and executive dashboards that drive data-informed decision-making.

• Design Dimensional modeling with ETL/ELT Architecture and assign the development work to technical resources.

• Manages a high-performing BI development team of 20 technical professionals across the U.S. and India, ensuring seamless coordination, optimal resource allocation, and successful project execution.

• Spearheads BI platform modernization by transitioning from Oracle to Snowflake and migrating reporting tools from Tableau and Oracle BI to MicroStrategy to enhance performance and scalability.

• Negotiates licensing agreements with Oracle, MicroStrategy, and Snowflake, delivering significant cost savings and ensuring alignment with organizational needs and future growth plans. BI Manager/Senior Data Warehouse Architect/ Apr 2003 - Aug 2017 IBM and Microtech Consulting Group Inc.

Oversaw full project lifecycles including scope definition, planning with risk contingencies, and cross-functional coordination across global teams, ensuring timely execution and stakeholder alignment through status tracking and executive presentations.

• Led enterprise-level BI and data warehousing projects for top-tier clients, utilizing Oracle BI, Siebel Analytics, and custom DW solutions while managing end-to-end delivery across SQL Server, DB2, Teradata, and Oracle databases.

• Designed complex data models using Erwin and Visio for both normalized and dimensional schemas, and integrating multiple source systems like PeopleSoft, Taleo, Oracle EBS, and Siebel to align with business intelligence goals.

• Engineered robust ETL pipelines using Informatica and DataStage by building and enhancing workflows, performing source-target mapping, and implementing advanced data transformation logic to support evolving reporting needs.

• Customized reporting metadata, dashboards, and analytics layers to enhance usability and security, implemented row- level access controls, and performed query optimization to improve performance across platforms and database. Siebel Analytics Leader /Principal Consultant Siebel Systems Inc. Atlanta, GA & Dallas, TX 1999 - 2003 Executed end-to-end deployments of multiple Siebel modules across various client environments, from telecommunications, to healthcare, finance, and technology sectors, ensuring seamless integration with existing enterprise systems.

• Handled all phases of implementation from requirement gathering and scope definition to effort estimation, solution design, and strategic planning while adhering to Siebel and client-specific standards.

• Engineered and enhanced data flows by designing 3NF and Dimensional models, integrating data from disparate systems into staging and warehouse environments using Informatica, DataStage, and custom SQL processes.

• Configured and customized Siebel Tools components, including UI modifications, workflow automation, and multi- org hierarchies, to meet specific business logic and operational processes at various organizational levels.

• Streamlined data exchange and synchronization using EAI, XML, and middleware tools like IBM MQ, while improving performance and accuracy through optimization of ETL processes and database tuning techniques. EDUCATION AND CERTIFICATIONS

• Oracle BI Customer Certified.

• Bachelor’s degree in finance.

PROFESSIONAL ACCOMPLISHMENTS

• Managed end-to-end projects with Onshore/Offshore teams, including DW Architects, Business Analysts, ETL Developers, and Report Developers, ensuring smooth project execution and delivery.

• Led bi-weekly Agile sprints using JIRA, served as Scrum Master, and employed Waterfall methodology to effectively manage project timelines and resources.

• Leveraged expertise across multiple industries, including Investments, Financials, Auto Finance, Supply Chain, HR, Retail, Marketing, Consumer Sector, Automobile, and Telecommunications, driving business intelligence initiatives. TECHNICAL SKILLS

Visualization Tools: MicroStrategy, Tableau, Power BI, Oracle Business Intelligence, and Siebel Analytics.

Industries: Financials &Investments, Automobile Leasing, Software and Services, Biotech, Transportation, Telecommunication, Supply Chain Industries and CPG. Operating Systems: LINUX, UNIX, Windows Server, and IBM AS/400. Cloud Technology: Amazon AWS using Redshift, S3, Kinesis, KAFKA, and Python. Development Tools: BMC Remedy, JIRA, Bugzilla, Clarity, Service Now, MS Project, Microsoft Office Suite, MicroStrategy Desktop, MicroStrategy Developer Tool, Tableau Desktop, OBIEE Admin Tool, Erwin, TOAD, SQL Developer, Visual Studio, Siebel EIM and Siebel EAI

Applications: Oracle Business Intelligence (OBIEE) with Oracle Data Warehouse (OBIA), Enterprise Data Warehouse (EDW), Clinical Data Warehouse, Siebel Analytics with CRM Core Applications

Database: Amazon Redshift, Snowflake Data Warehouse, Oracle, Teradata, Microsoft SQL Server, MySQL, and Informix.

ETL Tools: DBT, Informatica, IBM DataStage, Microsoft SSIS and Oracle ODI.

Contact this candidate