Home

Subhakar - Data Architect/Data Modeler/Business Intelligence/PowerBI

[email protected]

Location: Chicago, Illinois, USA

Relocation: No

Visa: H1B

Subhakar Parigi CHICAGO, IL +1-(805)-206-2948 [email protected] https://www.linkedin.com/in/subhakarparigi/ PROFESSIONAL SUMMARY Sr BI Consultant with 18 years of expertise in leveraging advanced reporting tools such as OBIEE, Tableau, and Power BI to enhance operational excellence across industries like Retail, Supply Chain, Banking, and Airlines. Known for a meticulous approach to data modeling and a strategic vision that consistently delivers innovative solutions, ensuring successful project execution from concept to implementation. Passionate about driving data-driven decisions, fostering collaboration, and maintaining a forward-thinking mindset to meet evolving business needs. SKILLS ERStudio, Erwin, Tableau, PowerBI, Foundry, Quantum Metric, Google Analytics, Big Query, OBIEE, Snowflake, Amazon Redshift, Oracle, Teradata, SQL Se, Datadog, Appdynamics, SQL, Pyth, Agile, JIRA, ServiceNow, Data Warehousing, Data Governance, Data Analytics, Data Visualization, ETL Processes, Data Architecture, Data Quality, Data Profiling, Stakeholder Engagement EMPLOYMENT HISTORY United Airlines Apr 2023 - Present Data Architect/Data Modeler/Business Intelligence/PowerBI Chicago The Product Analytics project involves analyzing data from various sources, interpreting trends, and improving operational excellence. Tools like Power BI, Quantum Metrics, Datadog, AppDynamics, Google Analytics, and Big Query are used, collaborating with teams to align goals. Developed data models utilizing ER diagrams and Star Schema modeling techniques through ER Studio. Conducted data profiling and analysis to establish, modify, and maintain data models effectively. Designed, created, and maintained both logical and physical data models, ensuring accurate metadata documentation. Managed data ingestion into tables and views and implemented periodic data refresh through scheduling, ensuring timely and accurate data availability for analysis Partnered with data architects and database administrators to create conceptual data models and define data flows. Established and enforced a governance process to oversee implementation activities, ensuring adherence to the defined architecture. Created dashboards in PowerBI based on the data model, aligning with business requirements. Meticulously manage data quality and integrity throughout the modelling process. Ensure adherence to data governance standards and best practices. Northern Trust Dec 2021 - Mar 2023 BUSINESS INTELLIGENCE/SR DATA MODELER Chicago Wealth Management Executives require a dashboard with multiple reports, including user usage, app usage, Zelle transfers, leads, representative call handling count, app rating, and customer hierarchy. ER Studio models tables for reporting, and Microsoft Power BI creates dashboards. Evaluated current data systems to identify areas for improvement and ensure data accuracy Maintained logical and physical data models with accurate metadata, ensuring data integrity and consistency Collaborated with data architects and database administrators to design conceptual data models, enhancing data structure and accessibility Developed ideal data coding practices to ensure system consistency and reliability Created conceptual data models using ER Studio, facilitating efficient data management and reporting Supported teams through project phases, including knowledge transition, to ensure smooth project execution and continuity Communicated modeling results and recommendations to internal stakeholders, aiding in informed decision-making Enforced governance process for implementation activities, ensuring compliance and standardization Conducted data profiling and analysis for data model maintenance, improving data quality and usability 7-Eleven Aug 2021 - Nov 2021 Data Architect/Data Modeler/Business Intelligence/PowerBI/SR DATA ANALYST Chicago In this Project, the 7-Eleven built a unified platform that enables practical usage of data. This platform, dubbed '7-Central' or Seven Central, allows real-time data views to drive future strategies and initiatives for business scaling. Gathered data from various sources like POS systems, market research, customer surveys, and financial reports, leading to compre- hensive data sets for analysis Analyzed data to identify trends, opportunities, and risks, which informed strategic decision-making and risk mitigation Developed recommendations and presented business improvement strategies, resulting in enhanced operational efficiency and growth opportunities Collaborated with cross-functional teams to build analytics dashboards, improving data accessibility and decision-making processes Prepared regular reports detailing current and future sales projections, aiding in strategic planning and resource allocation Analyzed large data sets to identify performance trends, supporting data-driven decision-making and performance optimization Used Python libraries like Pandas & NumPy for data analysis, enhancing data processing efficiency and accuracy Conducted ad hoc analysis as requested, providing timely insights for urgent business queries and decisions Shared insights and their impact on the business, facilitating informed decision-making and strategic alignment United Airlines Mar 2016 - Jul 2021 Data Architect/Data Modeler/Business Intelligence/PowerBI Lead Chicago The United Beat project allows United Airlines executives, regional and airport managers, and other departments to analyze customer satisfaction using surveys. The OBIEE Reporting Solution offers multiple dashboards with predefined reports, allowing analysis from various departments like Clubs, Lounges, Catering Operations, and Airport Operations. Documented report specifications and implemented metadata layers, improving report accuracy and consistency across departments Configured OBIEE Metadata Objects and developed interactive dashboards, enhancing user engagement and data accessibility Used OBIEE Answers for queries, views, charts, and user interaction, facilitating better data visualization and user insights Configured and set up OBIEE Security using LDAP and External Database Tables, ensuring secure and efficient access control Led team in Agile environment, improving project delivery speed and adaptability to changes Loaded additional data for analysis using ETL tools, enhancing data comprehensiveness and analytical capabilities Collaborated with other technology teams, fostering cross-functional synergy and innovation Led team in Offshore-Onsite Model, tracking tasks and ensuring smooth delivery, which improved project efficiency and communi- cation Microsoft Corp Oy Jan 2012 - Feb 2016 Data Architect/Data Modeler/Business Intelligence/PowerBI SAT is a reporting solution providing end-to-end visibility for sales and marketing insights, using a data model for supply chain excellence. It creates dashboards covering various modules, including inventory planning, sourcing, production, and transportation. Developed technical strategies and roadmaps for projects, leading to improved project alignment and successful execution Led project planning, design, and implementation, ensuring timely and quality delivery, which resulted in increased project efficiency and client satisfaction Mentored and guided the team, fostering skill development and enhancing team productivity Designed, developed, tested, and maintained Tableau functional reports, improving data accessibility and decision-making processes Mastered the ability to design and deploy rich graphic visualizations, enhancing data presentation and user engagement Created different KPIs using calculated key figures and parameters, leading to more accurate performance tracking and analysis Developed Tableau data visualizations using various charts, improving data interpretation and strategic insights Worked extensively with advanced analysis actions, calculations, parameters, background images, maps, trend lines, statistics, and table calculations, enhancing analytical capabilities and data insights Utilized Tableau server for reporting publishing and sharing, facilitating better collaboration and data-driven decision-making Nokia Corporation May 2010 - Dec 2011 SR BI DEVELOPER Helsinki The Sales Management Dashboard (SMD) is a comprehensive reporting solution that offers end-to-end visibility for sales metrics, including Channel, Financial, and Device Activation data, sourced from over 15 sources. Oversaw data collection and consolidation for reporting, improving data accuracy and consistency across sales metrics Designed and built dashboards for sales performance metrics monitoring, enhancing decision-making capabilities for sales teams Developed and reviewed complex SQL queries for data validation, ensuring high data quality and reliability Communicated effectively across platforms and departments, facilitating seamless collaboration and information sharing Created various visualizations including scatter plots, stacked bars, and heat maps, enabling comprehensive data analysis and insights Embedded Power BI reports for customers, enhancing user experience and accessibility to data insights Created lookup tables in Power BI and imported fact tables, streamlining data processing and analysis Created complex DAX queries for conditional hiding of data, improving data security and user-specific data access Utilized Power Query and DAX for calculations, enhancing data processing efficiency and accuracy Nokia Corporation Aug 2007 - Apr 2010 DEVELOPER Chennai The Retail Net business program consolidates sales outlets, field representative information, and training courses into a single platform, enabling accurate stock volume, sales, and advertisement calculations, promoting customer-centric orientation and growth. Developed and deployed dashboard solutions and multi-dimensional reports using IBM's Cognos, enhancing data visibility and decision-making for stakeholders Collaborated with team members to evaluate and meet company needs related to Cognos development, improving project alignment with business goals Translated business requirements into technical specifications, ensuring clear communication and successful project execution Developed test plans to ensure a quality product was successfully delivered, leading to improved product reliability and customer satisfaction Monitored activities to ensure all tasks were executed on time, contributing to project efficiency and timely delivery Built reporting solutions while adhering to data warehousing best practices, resulting in improved data accuracy and reporting efficiency EDUCATION Sri Krishnadevaraya University BACHELOR'S, ELECTRONICS AND COMMUNICATIONS Keywords: business intelligence active directory information technology Illinois