Business Intelligence Analyst

Balbir Gujral

************@*****.*** Cell: 734-***-****

Experienced with strong business and technical skills that enable me to effectively manage cross-functional teams. More than 20 years of experience delivering high-impact solutions in the areas of enterprise planning and business intelligence. I have served in numerous roles on diverse engagements, ranging from programmer to senior technical lead. I led projects from Inception to Realization. Certified Project Manager in PMP methodology. Track record of establishing credibility with customers and delivering successful projects. Experience in working with Techno-Functional Teams in implementation & problem-solving. Worked as Lead and SME for the business intelligence department in various organizations. I have good leadership skills, ability to multiple-task, ability to work between functional and technical teams.

Relevant Skills and Experiences

1. BI solutions PowerBI, COGNOS, SQL Server Reporting Services, QlikView Experience: 16+ years 2. Project Management Experience: 5+ years

3. ORACLE SQL, Reports Experience: 10+ years

4. OSI PI systems and scheduling Experience: 2+ years 5. Oracle's Hyperion Essbase Experience: 3+ years

6. Unix Experience: 3+ years

BI Tools: Power BI Desktop, Power BI Service, Tableau Desktop IBM Cognos BI Suite Cognos 11.x Report Studio, Query Studio, Framework Manager Certifications

● Project Management Professional (PMP Certification).

● ITIL v3 Foundation Certification

● Sun Certified Programmer for the Java Platform, SE 6 (SCJP Certification)

● IBM Certified Solution Expert - Cognos BI

● IBM Certified Designer - Cognos BI Reports.

● IBM Certified Developer - Cognos BI Metadata Models.

● IBM Certified Administrator - Cognos BI

● Cisco Certified Network Associate (CCNA Certification).

● Certificate in Systems Analysis & Design from Thiagrajagar College of Engineering, India.

● Certificate in Excellent Requirements by Orasi, USA. Experience

Assistant Vice President

Troy, MI based Flagstar Bank (Jan 27, 2019 till Apr 16, 2025) Leading department within a bank for Business Intelligence and I am responsible for managing staff, implementing strategies, and ensuring compliance. Working with multiple departments in Flagstar bank and providing excellent BI solutions and support to the business such as Underwriting, Loan Origination, Servicing, BSA Compliance, Escrow, Capital Markets, Profit & Loss, Secondary Markets, Mortgage Servicing, Investor and Digital Marketing.

● Collaborating with business stakeholders to understand their data needs and translate them into technical specifications for Development purposes. Technical Skills

● BI solutions Power BI, Cognos,

QlikView, SSRS,Tableau, Looker

● ASP.NET / C# / Visual Basic & Python

● Visual Source Safe, VisualSVN

● JAVA / J2EE

● ORACLE (PL/SQL, Reports & Forms)

● Alteryx,Snowflake

● Oracle's Hyperion Essbase – System

● OSI PI systems - ProcessBook

● Proficient Microsoft Office Suite

● MQ Series

● SQL Server

● Statistics package SPSS

● G Suite

● Analyzing data to identify trends, patterns, and key insights to support decision-making.

● Gathering data from various sources, cleaning and transforming data to ensure accuracy for analysis.

● Created data models using Power BI's data modeling features, including relationships between tables and hierarchies.

● Expertise in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week

● I provided custom solutions for Senior Leadership teams through BI platforms from Power BI, IBM Cognos.

● Proficiency in DAX language for creating calculations within Power BI Senior Analyst (Team Lead)

Detroit MI based GM Finance Company (April 2014 to Nov,2018)

● Working as data steward knowing how the data is collected, maintained, and interpreted in the organization and responsible for the Operational Oversight, Data Quality, Privacy, Security, and Risk Management of data and Policies and Procedures to access data. Led design and development effort for various applications. Worked with Business users to set priorities by resolving conflicts.

● Communication with stakeholders to define business strategy to create centralized reporting capability for analytical and ad hoc reporting and designed report mockups to show capabilities of Cognos.

● Supported and lead data insights projects and participated in initiatives and projects to assess impact to BI domain. Identified potential issues and developed work arounds as needed to ensure continuity of BI solutions.

● Developed, installed, configured and maintained Cognos architectural solutions.

● Provided technical support for migration process from Cognos series 8 to Cognos 10 and from Cognos 10 to Cognos Analytics.

● Reviewed functional requirements and technical specification and recommended changes if any.

● Assisted in troubleshooting design, development and support issues.

● Developed stored procedures and queries for reporting purposes.

● Performed query tuning and data modeling to improve performance efficiency.

● Created security for Cognos 10 and Cognos Analytics based on Country, Role and management levels using AD credentials.

● Helped in performance of Cognos 10 and Cognos Analytics on regular basis.

● Conducted end user training and delivered presentations to the user community. Responsible to create and maintain the Cognos Framework model for reporting in coordination with ETL team & DBA’s. Created metadata Relational and DMR models from data extracted from multiple databases for Cognos reporting.

● Team Lead for Oracle's Hyperion Essbase team in the supporting of a Financial Planning application that will utilize Hyperion Essbase, Smart View.

• Monitoring and changing the monthly Actual load UNIX scripts as required

• Performed Administration of Hyperion Essbase application.

• Worked with OMCS (Oracle Managed Cloud Support).

• Creating a process to upgrade the cube automatically using Unix scripts.Used both Essbase Administration Services (EAS) and MaxL scripts.

● Participated in developing the short and long-term strategic approach for business intelligence and associated governance.

Information Analyst - SME

US Steel, Michigan (April 1998 to December 2013)

● Responsible for planning, executing, monitoring and delivery of various projects with effective handling of budget and time constraints. Worked in Capability Maturity Model.

● Designed solution to migrate several operations for different geographies to an ERP platform. Worked on creating several dashboards and reports to monitor the KPIs for steel production process. This solution enabled US Steel to reduce waste and produce according to orders.

● Responsible for converting legacy applications to ASP.NET web pages using SQL Server on the Backend. Created documents for use cases, data mapping, and test cases and conducted user training for migration from legacy systems to COGNOS and QlikView solutions. I was the SME

(subject matter expert) for Cognos. I have extensively used Cognos event studio to schedule and trigger jobs on certain conditions. I have experience establishing BI Semantic Layer in Cognos Framework with proven experience with SQL using Toad and developing various complicated reports in Report Studio.

● Participated in business and status conference calls, workgroup discussions with stakeholders in various countries and United States. Implemented Projects using Waterfall and Agile Methodology.

● Analyzed current state technology environment like legacy applications and developed future state architecture Recommended quality checks in the Applications to reduce the down time at Assembly Plants due to IT issues.

● Created a Client-Server design and development of safety system as per OSHA requirements using SQL Server, MS Access and Visual Basic.

● Extensively worked on extraction, transformation and loading data from heterogeneous source systems into target databases for business intelligence. Key Quality Characteristics (KQC) Project:

In 2012 there was just over $26M lost due to quality related issues like diversions, retreats, customer claims, and excursions. The KQC application was developed to perform specific monitoring, alarming, alerting of defined states of operation on a given facility by Real-time monitoring and alerting, Event Tracking, Operator feedback for events, Manual data entry, Auto Holds. Benefits: KQC provides immediate alerting as opposed to after the fact alerting. With this project Mill reduced the $2.6M loss (about 10%) annually.

On Time Delivery Project:

A very critical metric at Great Lakes Works is on time delivery. The Business Service Center group at Great Lakes worked very closely with the coordination group to come up with an improved process. The Systems group provided enhanced business intelligence reports using Cognos and PI system alerts to the logistics group that assisted them in scheduling the right orders at the right time and Improved adherence to schedule by priority inter shipping, determining lost coils, improve location entry. Manager-Information Technology

Bank of Punjab Ltd., India (July 1995 to April 1998)

● IT Manager for Bank reported directly to Vice President - IT.

● Managed all IT resources for computer software & hardware development & enhancements.

● Responsible for managing the development effort from design through deployment phase of various application packages of information to top management using Oracle, PL/SQL on UNIX platform.

● BANCS2000 Package System Implementation and Package System Maintenance in all fully computerized branches of the bank with facilities like Single Window Banking, ATM, Phone banking and Anywhere Banking.

● Created procedures for Computer Auditing of Branches as mandated by policies of the Bank.

● Manage teams of up to 30 people including DBA and developers. Conducted performance reviews and evaluations.

● Oversaw Call Center for all Branches and understand the procedures and needs of customers and make appropriate process improvements from time to time. Education : Masters degree in Statistics, Panjab University (Securing First Position in the University) Status : U.S Citizen.

Contact this candidate